DSXchange

A mistake, which has been corrected now in my post.

Hi I have a sequencer which calls 6 jobs sequencially. It works will functionally and logically. But sometime sequencer wont trigger the next job immediately once previous job is finished with status Ok. It takes around 20 -30 min to trigger the next job. It is not the case of one job in sequencer. ...

peddidsx wrote:i am getting warning as 'uanble to parse configuration file' at the stage level in the inputs/outputs tab.

Did you get status OK when you check your default configuration file using config file checker in Manager?

what is the difference between this methods and the use of Orchadmin ? No difference , if you do your work of deletion perfectly . this method must be ban , yes or no ? No. But not highly preferred by anyone to be a method of deleting DataSets, because an option in utility orchadmin does the same t...

Yes.

Nothing will happen to the job design even you delete the log file.

But, the Job has become unusable further because NO Run-time action(Compile, Execute) can be applied to that Job.

DSRajesh, The deletion of any Run-time DataStage file will not do any harm (but just a warning mesage) on the Job Design or any action(Create Copy, Rename, Delete, Add to Palette) performing on the Job Design but will prevent highly any Run time action(Compile, Execute) performing on the Job. ArndW,...

ray.wurlod, Need a small clarification: Do not, whatever you do, delete the RT_LOGnnn objects to which ag_ram refers. Your job will immediately become unusable. The deletion of any Run-time DataStage files will make that particular Job unusable further. However, If the Run time files accidentally de...

ray.wurlod, I did not list the Job Status Code, indeed but just listed out Job Status in words. For your information: Job Status Code taken from JOBCONTROL.H * Possible return values for token DSJ.STATUS: Equ DSJS.RUNNING To 0 ;* This is the only status that means the job is actually running Equ DSJ...

First, we may recommend you to have a look at Server Job Developer's Guide v7.5 page# 711. You can better use dsjob -jobinfo for retrieving current Job Status information of a Job. Job Status: 1. RUNNING 2. RUN OK 3. RUN with WARNINGS 4. RUN FAILED 5. VALIDATED OK 6. VALIDATE with WARNINGS 7. VALIDA...

All log entries for a particular Job would be stored in DataStage Table RT_LOGnnn ( nnn --> Job Number)[a Type 30 Hashed file] which would be available in the project directory.

But the strongest recommendation is to purge log entries through DataStage Director.

ray.wurlod,chulett My question at its old is that Question: Can we have any customization in the default(or other if chosen) XSL Stylesheet to get Job report for the Job Sequence and the Job Report for the Jobs, which are configured inside the Job Sequence, in the same Job Sequence Reporting folder....

Sure... in the words from DataStage Release 7.5 Developer's Help pages ...(the report is initially generated in XML, the stylesheet converts it to HTML, suitable for viewing in a browser). You can also define a custom stylesheet for this purpose, in which case choose User defined stylesheet and type...

ray.wurlod, Till i have focussed on 'Job Reports', the answer to my question is NO. Because DataStage Job reporting facility does not indeed generate HTML report but generates an XML report initially to which, the mentioned XSLT Stylesheet applied to convert to HTML to be suitable for viewing in a b...

ray.wurlod wrote:The answer to question 1 is "Yes".

ray.wurlod,

Can you please expand saying how we can achieve this.

Do we have answers for these questions? 1. But i want to generate the report in Sequence level, if seq contain 2 job then report should contain details of 2 jobs in a single log file Can we have any customization in the default(or other if chosen) XSL Stylesheet to get Job report for the Job Sequenc...