Job is: TDConnector (read) -> DB2EntStage (load)
I have added a sort stage to the job in between the read and the write. I would like to use the DB2 partitioner here in the sort stage, and then use same partitioning going into the DB2 load stage. Now, I am getting errors that the db2part operator cannot connect to the database.
I have specified the instance and the database name, in addition to the tablename. However, I cannot find where you specify the userid and password.Sort_Data.Teradata_Table_Read_Part: Error Idx = 1;
DB2Driver Embedded SQL message: SQL30082N Attempt to establish connection failed with security reason "3"
("PASSWORD MISSING"). SQLSTATE=08001
;
sqlcode = -30082;
sqlstate = 08001 [db2utils.C:249]
A few questions:
1. In the Partition/Collections Properties window, I specified the database and table, but which instance does it need? The client instance (local) or the server instance (remote)?
2. Where do I put userid and password? This is required for the DB2 Enterprise stage, but I do not find any options anywhere in this partitioner window to specify them.
Thanks!
Brad.