DSXchange

Hi experts, Datastage parallel jobs are running one hour prior to the job schedule from the director. Recently we have changed the timezone from MESZ to MES timezone. DS services are restarted also but still we see jobs running one hour prior to the job schedule. Could you please share your advise/s...

ray.wurlod wrote:

Yes you can

; in a trigger expression it's clearer to use OR conjunction. ...

Thanks Ray .

Hi , Can we use the below code. AAAiles_Seq.$JobStatus=DSJS.RUNFAILED Or AAAFiles_Seq.$JobStatus = DSJS.RUNWARN intstead of using system variable @VM. Please share your ideas. If not then what is the significance of using system variable(@VM A value mark (a delimiter used in UniVerse files), Char(25...

HI All

Job auditing is done at the sequence as well as at the job level . Could you please suggest which one is the most preferred one and the advantages of it.


Thanks in advance

Welcome aboard. DataStage does not have log files; it has logs stored in tables. RT_LOGnnn is a hashed file. That is, it is a database table, which happens to be stored in two (binary) files called DATA.30 and OVER.30. RT_LOGnnn is the log table for job number nnn. You examine its contents with SQL...

Thanks a lot for the kind information.


Regards
Shahid

"can then use pattern-matching on the link names to decide which ones to call via DSGetLinkInfo - e.g. ending in "_src" or "_tgt" or somthing like that:-"


Please could you suggest how to perform pattern matching on the links.

.

Thanks in advance

Hi All, Can anybody suggest me how to fetch stage names and link names which are named like source and target in job designs. Actually writing a routine to extract job information(job audit ) which dynamically searches for the source and target stages and get's the link row count pertaining to the s...

Thanks for the suggestions Chulett Actually we recently installed data stage on the new server and imported the whole project from the existing production server(Oracle 10g ). This job is working fine in the production server from where we imported the project. Oracle 10g is used here. Please sugges...

Thanks for the quick response chulett. I have used Longvarchar data type for that field and set it to 4000 size. Array size is already 1 but still the problem persisting.

Thanks in advance
shahid

Hi All , when extracting data from OCI stage , i am getting the error "Oracle Error - OCI_NEED_DATA and ORA-03127: no new operations allowed until the active operation ends" . Other jobs which extracts data from oracle are working fine . there is one column in table whose data type is &quo...

Hi ,

http://www.duke-consulting.com/DataStage_Tips.htm .

kduke wrote:Tips and Tricks page call DataStageBackup.bat. ...

Thanks all

your suggestions really helped me a lot specially duke consulting page( lot of useful informations).

Thanksa lot :D

kduke wrote:Tips and Tricks page call DataStageBackup.bat. ...

Thanks all

your suggestions really helped me a lot specially duke consulting page( lot of useful informations).

Thanksa lot :D

Hi All ,

Does anyone having an idea of exporting jobs(back up) weekly along with the routines and need to automate this process weekly . Any sort of idea would be appreciated.

Thanks in advance.
Shahid