DSXchange

When we are doing bulk load, the job is doing well 30,000 rows/sec. Its the updates that causing the issue. Another interesting thing is we have a similar job which does the updates but the volume of the data for that job is 3 million. That update job is doing 10,000 rows/sec. volume is the major di...

Hi everyone, I have been struggling with the job performance issue with update in Db2 connector just wondering if anyone can shed some light on where it might be going wrong. I have a simple job like below Data set --> Transformer --> DB2 connector (Update) I will give a high level idea about the da...

I am going to mark this topic as resolved but if anyone have information regarding how to make non zero exit status not to show up as warning in director. please let me know. Thanks.

Thanks so much for all the replies. Automatically handle activities that fail is not checked. Please see the warning message below. (@ec_chk_file_exists): Executed: ls /home/../*.* Reply=2 Output from command ====> ls: cannot access /home/../*.*: No such file or directory Execute command activity wa...

Hi, I am using execute command activity to check a file existence in unix and then trigger the next job. My command is like this ls *.* and in the triggers I am saying if the return value = 0 then trigger the next job otherwise exit. When the file is found job sequencer is running fine. But when the...

we have solved this issue by editing the file db2cli.ini which has the schema information for the DB2 native connection. Basically the default schema is set in this file which will be used by the DB2 API stage.

our DBA has created connections to DB2 by cataloging in the production. For testing purpose I have migrated one job which has the DB2 API stage to production to check the connection settings are working. In this stage we are not passing schema name to the table. When I do a view data on the DB2 stag...

Thanks so much Ray/Chulett. This is a really great forum.

I did forgot to mention the Annotation. Thanks for the idea Ray.

The Command stage is not doing anything, it was just put there to end the flow so that job can run. The command that was listed was "ls". (I am just tweaking the job someone developed) So I have removed the Command stage and added Sequential File stage and pointed the data flow to the blac...

I came across this link which is explaining that Command stage is only used for Windows Server. I have exported entire project from Windows to Linux, I am guessing maybe that's why I am able to see the Command stage available in the Linux version of Data Stage pallet, but its really cannot be used i...

I have done couple of tests and came to the conclusion that its not the issue with the folder stage. But with the Command Stage.
I have removed the command stage and ran the job and everything worked fine. I am still checking.

Hi everyone, I have migrated a server job from Windows to the Linux DS server. The job was working fine in the Windows server. Please see the job structure below. Folder Stage ---> Transformer ---> Command Stage When I run/reset the same job in Linux server I am getting the following error. No issue...

I have been transferring in XML format to view the details. But I haven't find anything yet. I think this would be worth mentioning. We are actually migrating from Windows to Red Hat Linux server. As a part of this migration I have move the entire project from Windows to Linux as a Development proje...

New improvement to this. I have deleted all the jobs that are in the acceptance (where I am having issue) and then imported the whole project from Development to Acceptance then the DB2 UDB API stage is pointing to the right schema. Which even more convinced me that some object in the datastage that...

I am actually working with the DBA. We see that connects are set properly because we were able to point to correct schema (even though there is no schema parameter) in Development and Test Project. When we are doing View data the only thing we are changing is the DB2 server name (nothing but Alias n...