DSXchange

Hi All, We are getting high volume of reference data is one of my job and this job is taking 40 min time for complete execution. On daily basis they are adding reference data and at this point of time we are getting more than 50 million records. We have tried few options but the issue is still same....

Hi All, Our requirement is to move informatica mapping into Datastage jobs. I have done some googling but can not find about the exact information. There was coule of points mentioned in DSXchange as well. 1) XMigrate : But no information is there even on IBM site. 2) Trying to import informatica ma...

Issue is you have multiple records in the reference table having the same vaule in the column with which you are performing lookup.
handle that before you perform lookup

For removing quotes, while reading from source file itself, for the column, in column properties, give quote as 'single'. then the sequential file will read the date column without the single quote.

Thank you guys... now its working fine ...

Solution: Sourced the dsenv file from dshome i.e. "/opt/ibm/IS/InformationServer/Server/DSEngine"

@Craig : My script makes a list of jobs in a project.

@Paul : No I did not source the dsenv file. I never scheduled a script (having dsjob dssh etc) in cron before so I didnt know about that.

Actually I am directing the output of dsjob to a file. I am able to do this when I run the script from $ prompt $ my_script.sh It works fine Schedule it thru cron 00 02 * * * /path/to/script/my_script.sh not working properly. I am doing this thru unix crontab and not thru datastage director. PaulVL ...

Hi, I am running the following dsjob command through a script - /opt/ibm/IS/InformationServer/Server/DSEngine/bin/dsjob -domain <dom> -user <usernm> -password <pwd> -server <server> -ljobs <projnm> And on manually running the script, its giving output but when I am scheduling the script, it is not g...

Check with isnull() and also empty space. Eg: IsNull(Col1) or Col1='' or Col1='NULL' if you assigned 'NULL' in previous stages I hope this works. Thanks' Vijay Thanks for the swift response but having the same problem tried two options Option1 ) Directly added Constraint IsNull(Col1) or IsNull(Col2)...

Hi,
We faced the similar issue some time back and got resolution.When using connector stage. It tries to query some of the DB2 system views related to environment. Once after granting permission to the Application user id (datastage id) on the respective tables our issue got resolved.

Hi, We are using datastage 8.1. Job design is like a dataset - > Transformer -> DB2/UDB enterprise stage The write method is kept as Load append. But job is getting aborted with following are the error messages from job log DSP_DB2,5: {0} [db2load_driver.C:969] DSP_DB2,5: SQLCODE = -3,025; SQLSTATE=...

Greetings DS Doctors, We are also facing similar time out issue. DS Engine/WAS/X-META db ever ty looks normal. Not sure why i am still getting this issue. Issue persists, when logging from client tools on my local machine and Citrix server as well. Am i missing to check something..? Thanks your help...

Hi Friends, We are working on Informatica to Datastage Migration project. One of the job which we have developed is giving issue. All the mappings and transformations are same as Informatica mappings and logics. But the record count in the target differs. For Example, Informatica is loading 2 record...

Ray, I want to know if there is any table other than DS_AUDIT from which I can extract job modification information. As I didnt receive any response to my previous question I asked information on how to list the tables in administrator client. Why I need this information? This is because I am workin...

How can I find out all the tables listed in administrator client?

Is there any show tables or any other command which might save my purpose?