DB2 Connector Stage - instance connection issue

[Klaus Schaefer]

Hi there :D

I have an issue with DS(IS) 9.1 and DB2 10.1, both on one machine, OS Win Server 2008:

I can run "classic" server jobs with DB2 API stage without problems.

When trying a parallel job and DB2 connector stage I get "An error occurred setting DB2 instance to value . The active DB2 instance is already set to value: IBM DB2."
That is when I leave the stage parameter "Instance" empty.

When I set "Instance" to "IBM DB2" it says: "An error occurred validating the DB2 instance. Verify that a valid DB2 instance is specified in the Instance property."

However - my instance is actually called just "DB2" (my DB2INSTANCE environment varaible is set to "DB2" and the DB2 Data Studio 4.1.0.1 client reports same), but using "DB2" as instance value gets back to the first message now complaining "An error occurred setting DB2 instance to value DB2. The active DB2 instance is already set to value: IBM DB2."

What can I do - what am I doing wrong...?

Any hints appreciated

Best regards
Klaus

[MT]

Hi Klaus Schaefer

the instance property is missleading in the DB2 Connector. It actually means the name of the CLIENT instance - the one on the DataStage Server.

Additionally there could be another problem - check out:
http://pic.dhe.ibm.com/infocenter/iisin ... tor11.html

[MT]

Hi

.. I forgot to mention - in your case you should leave it blank
This is always the best solution in my eyes.

But this means the DataStage Admin user has to have the DB2 environment set (sourcing the db2profile - on UNIX systems)

[Klaus Schaefer]

Hi MT,

thanks for your suggestion. As I mentioned in my issue describtion, leaving "Instance" blank gives an error. As I mentioned I am on windows, so there is no dsenv....

Best regards
Klaus

[MT]

Hi
well yes you mentioned it but you mentioned as well that you have set it at some point in time - and my experience on UNIX is that DataStage keeps it cached untill it gets restarted.
So you might still suffer from the one test where you had it set.