DSXchange

I donot have access to the dsadm or root account so to run any query on unix I ask the unix sysadmin. Some of the DataStage jobs are failing with error 'Unable to allocate Type 30 descriptor'. unixsa ran $DSHOME/bin/smat -d | wc -l 153 Total number of processes under dsadm ps -aef | grep dsadm 26 We...

I have the tools Designer, Manager also. I never tried scripting routines, is there any process to perform it that way?

Hi,

I have access to Datastage Director, but no access to the unix account.

If there any option in these tool to reset mutiple jobs together?

Thanks in advance

Hi I am new to Datastage routines. I am analysing a job where the flow is taking me to a routine. Code is given below: Call DSU.AuditRoutineOne(InputArg1,DSJ.ERRFATAL) FileName = InputArg2:InputArg3 Call DSU.AuditRoutineTwo(FileName,DSJ.ERRFATAL) Ans="JobDone" I want to know the use of DSJ...

Hi All,

I wanted to now how the status column of datastage director is defined or how it is derived.

Regards,
Lebu

Hi,

I need to collect the job status of a current job without running it. I believe this can be done through a routine. I am new to coding in routines. Can you please suggest the functions that will be required?

There is another issue, I donot have the rights to access 'dsadm' from unix.

I see directories like:

/dstage/projects/MikusProj/RT_STATUS*

Is there anyway to extract the job status from these files?

Actually I was thinking about an automated process from server side itself. like getting the list of number of processes in Oracle by v$session

I am using DataStage 7.5 on HP UX system. There are hundreds of jobs stored in different projects, I must go to each and every folder to check the job status.

Isn't there any table or file where the list of the statuses for all jobs is stored?

Thanks in advance, Lebu