Problem with Surrogate Key generator stage

[mydsworld]

I am using a Surrogate Key generator stage.It runs fine with with a source type = 'File'.But when I am using the Database(DB2) sequence, the job aborts with error :

Surrogate_Key_Generator_1,1: Error Idx = 1;
DB2Driver Embedded SQL message: ;
sqlcode = -1390;
sqlstate =

Surrogate_Key_Generator_1,1: Failed to connect to the database
Surrogate_Key_Generator_1,1: The runLocally() of the operator failed.

Please advise.

[ArndW]

Since it couldn't connect to the database did you check the userid, password and instance to ensure that they are correct? Have you connected to DB2 in you installation already?

[mydsworld]

yes, I have connected to DB2 while using DB2 API stage, but the connection seems to be not working here.I have checked the username,password,client instance name. Is there any other method to debug the stage (as I don't find any option such as view data etc).

[mydsworld]

Does anyone have solution to this.

Thanks.

[ray.wurlod]

Find out what sqlcode -1390 means, then address that.

[ArndW]

You can do it using this command

Code: Select all

db2 ? sql-1390

[OddJob]

db2 ? sql-1390


SQL1390C The environment variable DB2INSTANCE is not defined or
is invalid.

Explanation:

The environment variable DB2INSTANCE is not defined or is not set
to a valid instance owner.

User Response:

Set the DB2INSTANCE environment variable to the name of the
instance to use. If you do not know the name of the instance to
use or how to set the DB2INSTANCE environment variable to the
instance name, refer to the Administration Guide .

Federated system users: refer to the Federated Systems Guide for
DB2INSTANCE information.

Ensure your PATH environment variable contains the sqllib/adm
path in the home directory of the instance you want to use (for
example, /u/instance/sqllib/adm, where /u/instance is the home
directory of the instance owner on a UNIX system).