DSXchange

Hi all, We have a requireent to load about 60-70 million of records per day.Currently we are using OPTILOAD tool for this.Now we are considering to load it using Data Stage through DB2/UDB Enterprise stage.So just wanted to know about the fesability of this or if there are any benhmarks laid by IBM ...

Hi,
Check the data and meta data both.Probably a null value is coming in a non nullable column.

Hi Ray,
Even I am facing similar problem.When I compile the job I get following error :

"Stage 'DB2_UDB_Load_1' requires minimum of '1' stream output(s)".

My job is
Sequential File --> DB2/UDB Bulk Load

Thanks in advance.

Hi all,
I am getting this error quite often while running jobs-

"Fatal error:Unable to allocate communication resources"

When I reset the job and rerun it ,it runs well.

please help me out.

Thanks in advance.

Hi, RCP--Runtime Column Propagation is mainly used in the scenarios where the modification in DDLs is possible. The advantage of having RCP checked is - if there is an addition of columns in your source table and these columns need to be propagated as such to the target (without any derivation) then...

Hi Salil,
I tried to insert same timestamp through my stage,its truncating the microseconds

Hi Salil,
I am able to insert timestamp with microseconds from backend.

Hi , When I keep format of timestamp as %yyyy-%mm-%dd %hh:%nn:%ss.6 its fetching microseconds but while writing in target which is DB2/UDB API stage ,it is truncating microseconds; even if I fetch microseconds separately and concatenate it .But I can populate it in a sequential file with data type a...

I am still looking for suggestions as to what settings are required in this case if i need to work with Timestamp datatype only.

Please tell me.It would be of great help.

Thanks in advance.

Hi Ray! I searched for it.There are indeed quite a few posts regarding this issue,but the issue has not been resolved so far,just a workaroung has been suggested..............to use varchar as datatype. I tried writing in the database with varchar as data type.Its working. Thank you and sorry for no...

Hi Keshav,
I tried that but still it is giving microseconds as '000000'.

Hi Keshav,
Thanks for the reply.

Can you please explain how do we set this property of extending timestamp to milliseconds in parallel jobs.

I am working on a job which is used for incremental loading depending upon the timestamp of the source records. Now during execution it does not consider the microseconds.For eg: if the time stamp in source is 2006-08-25-01.02.42.764123 ; it executes the job taking the timestamp as 2006-08-25-01.02....

Hi, I have tried using a reject link.But no record got populated in the sequential file(reject file), despite the fact that there were 10 records which got rejected by the target database because of database constraints. I cannot use DB2/UDB Enterprise stage as we don't have create table privelege o...

Hi Ray, I have searched for it.I could get information about capturing rejected rows in DB2/UDB Enterprise stage and not in DB2/UDB API stage in parallel jobs. What all I could gather is for DB2/UDB API stage , information regarding rejected records is captured in log,but my requirement is to captur...