DSXchange

Thank you so much.

Thank you very much for your detailed reply.

Thanks a lot for ur quick and valuable information.

Just one more question regarding this.
As I have very least knowledge about admin part of Datastage, please advice where & how to setup these maps between datastage and double byte character sets.

Thanks and Regards,
Bala

Hi, We are planning for Regional DWH. My company is having many branches in the Asia pacific region and head office is at Singapore. The countries like China, Korea and Taiwan are having double byte info in their data. My questions are below: 1>. Is it possible to have single target database after t...

We are using Datastage 5.2 on Unix AIX We have the follwoing peculiar problem. - Assume that there are 2 IDs ( say ID1 and ID2). - Both IDs are having scheduling permission for particular project. - The ID1 has scheduled the ETL job @ 8:00 PM daily. - When ID2 tries to view the schedule, the system ...

Hi,

Added following line in the dsenv file in datastage home directory.

PATH=$PATH:.; export PATH

Now, it is working fine.

Hi Ray, Thanks for your reply. Checked the PATH variable and is having the current dir (".") in its path reference. The problem is, while execution, the DSSendMail function creates the shell scripts in the proper directory, but failes to fire it. Actually, it suppose to do these two action...

Facing this problem in Datastage 5.2 on the Unix AIX,when calling then DSSendMail function to send the mail. During execution, it has created "sendmail_TestMail.sh" under project directory (.../ds_projects/cust), but it couldn't trigger the shell script.I could receive the mail when I run ...

Ray, Do you have any idea about RT_LOG246. Yesterday, a job was started and then immediatly aborted abnormally. I noticed the lock RT_LOG246 when I ran the command LIST.READU ALL in the universe environment. So, I would like to know the answers for the following questions. 1. What kind of lock it is...

Following actions I had tried, but no use. 1. clear &PH& directory. 2. clear status file 3. clear resources. 4. clear logs. 5. cleanup project. So, I setup the Main job so as to call the child jobs sequentially, instead of calling the independent jobs parallely. This action has improved the ...

Re-run of that etl job was successful. But, in the next run, another other still is in "Running" status, but monitor shows "Finished" for all the links. What could be the reason for this. Please advice if anyone knows.

Thanks for the reply. Actually, the CDWMainScheduler is the main job which calls many (child)jobs.The attached message in my prev mail is the error message from CDWMainScheduler job when one of its child job got aborted abnormally without any error message.Is it because of any log file(??) that is f...

I have this problem for last few days. ETL jobs are failing without any error message. Re-run of the jobs are resulted in abnormal termination at different job. I tried to re-run the jobs after "Cleanup" the project, resources and &PH& directory, but no use. The following is the er...

Thanks for immediate reply. We had the entries in .odbc.ini file as you have mentioned. We understand that this type of odbc is "Wire protocol", which was not working. The following is the old entry in .odbc.ini ******** [DB2 Wire Protocol] Driver=/prod/applc/ds_appls/Ascential/DataStage/D...

Hi Ray, Thanks for your reply. We are having DS 5.2 on UNIX(Sun Solaris5.8). We have reliked /.dslibs already and not using Merant ODBC drivers. Before relink, we got the following error: ============================================== CleanCsmartTable1..JobControl (BCI DB2ExecSqlUM): SQL State = IM0...