DSXchange

Hi, I have a job with lookup stage, Iam writing the Failed records to a Dataset file . After running job when I tried to open the dataset or try to use that dataset in other job Iam getting an Error saying Error when checking operator: Could not find input field "File_TBLEID". and in the V...

Hi, I have to capture the records that have duplicates in to one file and non duplicate records in to another file . For Example ProductID Country Currency CH Price 1 FR EUR 00 50 1 FR EUR 00 50 1 FR EUR 00 50 1 UK EUR 00 50 1 GR EUR 00 100 Now I want all FR country records in to one file , I mean a...

Hi, I have a job with D2 tables and lam using hash file as a look up and writing to an output file. But Iam getting an error saying. NoVariant.NoVariant.Src_TSUR_Table: SQLAllocHandle: Failed to allocate environment handle 'ENV'. I searched in form but I couldn't find any thing related to DB2 . Plea...

Hi Ray,


Thanks for your help, Iam not finding LD_LIBRARY_PATH from the job log. Can you tell me at what place this env should be added in dsenv file. Can you paste me where this LD_LIBRARY_PATH is located in dsenv






Thanks.
Srinu

Hi,

Iam getting an error when Iam trying to insert data into a DB2 table, Iam using DB2/API stage


Error

main_program: Fatal Error: Fatal: Shared library (dsdb2.so) failed to load: errno = (2), system message = (No such file or directory)



Thanks,
SomaRaju.

Hi,

Can some body tell me how much disk space I need to add to Datasets and scratch directory for 10 million records , In order to overcome this disk space problem and how much free space do I require .



Thanks,
SomaRaju

Hi Sanjay, I splited job in to two jobs and Iam taking first job out put as one of the input in second and performed join function but Iam getting the error like this Errors : Join_Src_Tables,0: Write to dataset failed: No space left on device The error occurred on Orchestrate node node1 (hostname d...

HI Ray, The jobs are executed by Raju0212 . And these are the permission on the two directories drwxrwxr-x 2 dsadm dstage 326144 May 20 17:10 Datasets/ drwxrwxr-x 2 dsadm dstage 46080 May 19 17:09 Scratch/ One more thing is Iam able to join records and it is running fine untill 974597 records when i...

Hi Ray, I went to Datasets directory /DataStage/751A/Ascential/DataStage/Datasets> and permission I found was -rwxrwx--- 1 Raju0212 dstage 9788336 Mar 8 2006 lookuptable.20060308.ij emh5c* -rwxrwx--- 1 Raju0212 dstage 9788336 Mar 8 2006 lookuptable.20060308.ls d1o2d* I went to scratch directory /Dat...

Hi , Iam getting the above error when Iam using a join stage , but when I use a look up stage the job is working fine . Iam getting this error even after increasing scratch disk space . Is there any limitations in join stage or do I need to increase any buffer size in administrator for join stage to...

Hi Dsguru, In one of the post it was mentioned like this The TEMP_FILE error usually occurs when the database instance owner cannot write to the local server. If you are on a multi-node system, each node needs to have a local path to write to for the database's temp files. For example, on our system...

Hi DSguru, I searched in the form . I found in one of the post saying each node needs to have a local path to write to for the database's temp files . But Iam confused what temp directory path I have to provide. In my env file I can find DB2DIR = /usr/opt/db2_08_01 ; export DB2DIR DB2INSTANCE = db2s...

Hi Ray, As you mentioned I changed Load Immediate to 'YES' but my job is failed by throwing this error Tgt_Conf_Pricetype_Tbl,0: Warning: CopyOfPopulate_Conf_Price.Tgt_Price_Tbl: ERROR occurred : loading table, SQLCODE -3508 Tgt_Conf_Pricetype_Tbl,0: Warning: CopyOfPopulate_Conf_Pricetype.Tgt_Conf_P...

Hi, Iam using Db2/UDB load plugin to load data in to a Db2 table. The job finished ok with no warnings but when I check in table it is showing 0 records . Please can some body help me . Properties I changed in Load stage are Load Method : Sequential File Load Immediate : No Load From Client : Yes Di...

Hi "chulett", Iam pasting you some data samples for Price field here Price 1195999900000.00 (15,2) 15600000000.00 (13,2) 12999999000.00 (13,2) 11959999000.00 (13,2) 4056000000.00 (12,2) 3754351000.00 (12,2) 3588000000.00 (12,2) And ray I could not find your Isvalid() server function in the...