Search found 90 matches
- Wed Sep 18, 2013 11:14 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 Connector performance issue
- Replies: 2
- Views: 3493
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...
- Wed Sep 18, 2013 7:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 Connector performance issue
- Replies: 2
- Views: 3493
DB2 Connector performance issue
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...
- Wed Jun 19, 2013 7:09 am
- Forum: General
- Topic: Execute command activity warning for file check
- Replies: 6
- Views: 3525
- Wed Jun 12, 2013 9:36 am
- Forum: General
- Topic: Execute command activity warning for file check
- Replies: 6
- Views: 3525
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...
- Tue Jun 11, 2013 3:47 pm
- Forum: General
- Topic: Execute command activity warning for file check
- Replies: 6
- Views: 3525
Execute command activity warning for file check
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...
- Thu Feb 28, 2013 5:01 pm
- Forum: General
- Topic: DB2 UDB API pointing to right schema
- Replies: 12
- Views: 5501
- Tue Feb 26, 2013 11:25 am
- Forum: General
- Topic: DB2 UDB API pointing to right schema
- Replies: 12
- Views: 5501
Revisiting this issue again
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...
- Thu Jan 24, 2013 7:44 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Folder stage Issue
- Replies: 10
- Views: 4954
- Wed Jan 23, 2013 3:28 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Folder stage Issue
- Replies: 10
- Views: 4954
- Wed Jan 23, 2013 12:39 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Folder stage Issue
- Replies: 10
- Views: 4954
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...
- Wed Jan 23, 2013 11:57 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Folder stage Issue
- Replies: 10
- Views: 4954
- Wed Jan 23, 2013 10:32 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Folder stage Issue
- Replies: 10
- Views: 4954
Folder stage Issue
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...
- Mon Jan 21, 2013 8:41 am
- Forum: General
- Topic: DB2 UDB API pointing to right schema
- Replies: 12
- Views: 5501
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...
- Mon Jan 21, 2013 7:37 am
- Forum: General
- Topic: DB2 UDB API pointing to right schema
- Replies: 12
- Views: 5501
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...
- Fri Jan 18, 2013 4:29 pm
- Forum: General
- Topic: DB2 UDB API pointing to right schema
- Replies: 12
- Views: 5501
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...