DSXchange

Hello Ray, My requirement is as follows: My Input is Start_date =2008-12-31 End_date=2009-12-31 ************************************************************ 1. I want to have a query on DS_AUdit table and want to fetch all the record where which lies between Start_date and End_Date. Select * from ds...

Hello Ray,

thanks for the reply. But I want to use DTM in Group by clause and that in date format.

Regards
Neeraj

Hello, Thanks for the help. I have got the records as per my requirement. If I am executing below mentioned query select max(dtm) from unnest ds_audit on mods where instance='JOB1' group by modifier,reason I am getting below mentioned records MAX ( DTM )......... Modified by......... Reason for modi...

Hello All, when I am running the below mentioned query to fetch the records from DS_AUDIT table SELECT MAX(DTM),DTM,REASON FROM DS_AUDIT WHERE INSTANCE='test1' GROUP BY MODIFIER,REASON I am getting below mentioned error DataStage/SQL: GROUP BY columns must be single valued My Requirement is as below...

Hello everyone, I need your help. I want to know the solution of below mentioned scenerio. ############################################# Job name A is created by user test, which gets modified by number of users and after then one of the user delete the job from the repository. It will be very easy ...

If it's not coming up after your start you can do the following: (using root user) #uv -admin -stop make sure that dsrpcd and monitor are not running #kill -2 (or -9 if needed) all datastage processes #$DSHOME/scripts/DSEClearSockets.sh #uv -admin -start bye Hi, I am not able to find this Script. C...

Hello, We are getting error messages while compiling the job mentioned below. Error trying to set file map on RT_SC6061 to NONE I searched for RT_SC6061 file in the project directory. But I could not find it anywhere. Second problem is that when I am opening the existing jobs, the Icons of the Stage...

We have not taken any export and import. It is the new job which we developed one day before. Next day when we tried to open this job. We got the message and all the links got disappeared and only the stages are left alone in the designer window

Hello,

We are getting an error mentioned below very regularly when we try to open the jobs and job gets corrupt.


Record J/4377/V0S3 in file DS_JOBOBJECTS does not exist.

Please let me know the reson why this prblem comes and what is the solution to handle it.

Regards
Neeraj

Hello, I really like it. No. I am not working as a Unix admin. But being the lead person for datastage, I have got the access to root to look into datastage admin works. I can help my unix administrator in resolving this issue if you could help me. He is not very much clear about the process. Regard...

Hello,

I tried a lot. Might be I am not able to search it properly...

Please help me.

Regards
Neeraj

Hello,

Thanks for the quick reply.

Can you please let me know the process/steps of doing it? I will login using root password and do the needful as suggested by you.

Regards
Neeraj

Hello, I fired below mentioned queries. nohup dsrpcd -d9 > dsrpcd.log 2>&1 & The result is:- RPCPID=1847514 - 07:41:14 - uvrpc_debugflag=9 (Debugging level) RPCPID=1847514 - 07:41:14 - In rpc_init() RPCPID=1847514 - 07:41:15 - bind bombed errno=67 RPCPID=1847514 - 07:41:15 - listen failed Th...

Hello,

I fired the below mentioned commands.

1. uv -admin -stop

2. uv -admin -start

Regards
Neeraj Mahajan

Hello friends, I need your help. When I tried to start the DS engine, it is not coming up. When I fired ps -ef |grep ds command, I got the below mentioned details. dsadm 241834 3113022 0 05:02:43 pts/0 0:00 ps -ef root 266408 94398 0 Sep 30 - 0:18 /usr/sbin/rsct/bin/rmcd -a IBM.LPCommands -r dsadm 7...