DSXchange

Hi everyone , I get this Error when i run a job . seq_rej: When checking operator: A sequential operator cannot preserve the partitioning of the parallel data set on input port 0. i really dont understand what this error means exactly. can anyone guide me how to work on this warning message when i r...

Hi Everyone , Hope everyone had a good weekend. I am stuck with a problem . i am not able to access the stages within the DataStage jobs. the error Says (40503) A call to an OLE server has failed or a runtime error occurred within the OLE Server itself. Did anyone of you get this kind of issue. Kind...

hi everyone ,

can anyone suggest me what can be the maximum load limits for a table lookup. i have DB2 table as a lookup and the data volumes are more than 25 million. can i do a look up for such high volumes of records. my primary source has only 1,00,000 records.

kindly suggest

thanks

Hi Everyone , I am doing a Sparse Look up with the UDB/DB2 Enterprise Stage and when i run the job it throws me an error indicating that there is a conenctivity problem with the Dbase Lkp_Name: Error Idx = 1; DB2 Driver Embedded SQL message: ; sqlcode = -1390; sqlstate = Failed to connect to the dat...

thank you ray

Hi Everyone ,

How many stages exist for DB2 in DataStage PX

i found ,

DB2/UDB API
DB2/UDB Enterprise
DB2/UDB Load

i wonder if there is any DSDB2PX stage . kindly clarify

Thanks

Thanks a Lot Whale

Hi All , I have a parallel job which loads data into Teradata DBase . The job works fine , but my DBA complains that my job occupies threads and these threads are not getting released when the job completes and when the data is loaded into the tables. let us say , that this job occupies 10 threads u...

thanks a lot kris

Hi Can any one suggest me if a table lookup (DB2, which has 28 million records) is much faster or a BD2 Sparse Lookup is much better to do a lookup on a table with 28 million records. Can i load this DB2 table into a hash file ( can a hash file take all the 28 million records) and use this hash file...