[DB2 iSeries Connector] DB2 Connector connection string

António Barroso

Question

Hi,

I am using db2Connector extension to connect to a db2 database. In a SELECT query i have no problem, but when using INSERT i get a SQL7008 error. I googled and seems the connection commit mode should be set to Commit immediate (*NONE ), or AutoCommit set to Yes. My problem is that i don't know what connection string property should be used. i tryed several ("AutoCommit", "CommitMode", etc..) and i always get the error "The ConnectionString property is invalid." IBM documentation refer to oledb and odbc connections strings, wich is not the case. Any idea of what is the right property, or where can i find documentation about it?

Thank you
best regards

António Barroso

12 Apr 2013

Pedro Gonçalves

Staff

Hi everyone,

I'm also having this same error (The ConnectionString property is invalid.) with SELECT statements in the DB2Query action. I've validated this connection string (here and here) and all seems fine, though.

Where can I find further info about this exception?
Can anybody recommend any further troubleshooting methods?

Thanks,
Pedro

12 Nov 2013

Pedro Cardoso

Pedro, did you solved it?

I'm having the same problem and I don't see any reply to your question...

29 Jan 2014

1 reply

30 Jan 2014

Show thread

Hide thread

Ruben Goncalves

Hi Pedros and António,

Have you seen the connection string example, that goes with the sample?
If not this was what I was using:
dotnet: "Server=localhost;Port=3306;Database=test;Uid=root;Pwd=xxxpassxxx;"
java: "jdbc:mysql://localhost:3306/test|root|xxxpassxxx"

Hope this helps you out.

Cheers,

RG

30 Jan 2014

Martin Westra

Hi,

just to give you some help:
https://www.querytool.com/help/876.htm

has a lot about this commitment.
https://www-304.ibm.com/support/docview.wss?uid=nas8N1017566

Just to give you some background.
On an i-series there are the traditional file (PF-DTA) they hold data en LF (logical files) which are basically indexes. As the I-series started of with their own proprieraty database, this did not run under commitment control.
When using the interactive SQL tool on the I-series (from the commandline : STRSQL) you can query all PF-DTA files and LF files .
BUT when using a jdbc connection it is required that all the files run under commitment control.
When creating a schema from the STRSQL command, all commitment control is automatic started. And you should be able to connect and retrieve all the data.
Create schema info on I-series
https://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=%2Fsqlp%2Frbafysqlpcschema.htm

Martin

30 Jan 2014

Pedro Cardoso

Thanks for al the replyes guys!

30 Jan 2014

António Barroso

Hi

Thank you. I didn´t resolved the issue so i used a diffente driver to access db2

30 Jan 2014

Robert Nicholson

I believe that in order to use commitment control you need to be journaling the files.

04 Mar 2015

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.

See the full guidelines