Search found 22 matches

by dilip.datastage
Tue Dec 11, 2007 11:30 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Handling different metadata in runtime for the same table in
Replies: 8
Views: 2938

Handling different metadata in runtime for the same table in

Hi,
I have a situation to handle different metadata for the same target table in incremental load. How can i procced with. should i have to change manually for different load or there is any way to handle this automatically.
by dilip.datastage
Sat Oct 06, 2007 10:07 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Handling Null in Load Utility
Replies: 2
Views: 1065

Hi

I am using DB2 database. In the JOb i am using ODBC stages to trigger Stored Procedure.
by dilip.datastage
Sat Oct 06, 2007 8:40 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Handling Null in Load Utility
Replies: 2
Views: 1065

Handling Null in Load Utility

Hi, 1)I am loading a file which contains 50 million of records in to target table. If i use job design it will take atleast 1 or 2 days to load. I have written a unix script and loading data through load utility from sequential file to target table. it is getting hanged because if there is any null ...
by dilip.datastage
Sat Oct 06, 2007 1:14 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Callinf Stored Procedure
Replies: 1
Views: 882

Callinf Stored Procedure

Hi, I am calling a stored procedure 13 times in a job at the same time with different parameters. In job there is single tranformer and 13 output links to ODBC stages which is executing Stored procedure. There is no input stage. All 13 ODBC stages are calling same procedure. I have one doubt like al...
by dilip.datastage
Sat Sep 22, 2007 8:18 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error while writing to hash file
Replies: 1
Views: 747

Error while writing to hash file

Error while writing to hash file. ds_uvput() - Write failed for record id . Can anyone help regarding this
by dilip.datastage
Sat Sep 22, 2007 7:32 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error in Sequencer
Replies: 1
Views: 647

Error in Sequencer

While running sequencer, jod is called and started running but after calling job- sequencer is getting aborted. How can i resolve the problem.
by dilip.datastage
Fri Sep 21, 2007 6:18 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error - ds_ipcflush() - Error in mutex_unlock() - Not owner
Replies: 1
Views: 911

Error - ds_ipcflush() - Error in mutex_unlock() - Not owner

Hi, Job got aborted and the error message was ds_ipcflush() - Error in mutex_unlock() - Not owner. Can anyone help me how to resolve this problem. No. of i/p records are 17 million. I have used link collector in the job. is the problem with link collector. I have changed biffer size from 128 to 256,...