DSXchange

As per Kim's suggestion, listing the code was pretty horrendous. If you want the objects and spreadsheet in one, download the zip file.

Sorry Kim - it's late (nearly midnight). Amended the post.

Following suggestion in next reply and deleted code posting. Replaced with links to code at own web site.

Want to profile your end-to-end DataStage processing to see potential bottlenecks? Seeing significantly day-to-day variations in your end-to-end job completion time? Having to undertake performance impact testing in a test environment prior to deployment to your production environment without having...

How about something like: The OCI then executes an update statement appropriate to each link.

David

Hermant, using the XML from the post should be fairly straight forward. For each block of code in the post: 1) highlight the code and copy it 2) paste it into notepad 3) save the file with a distinct name Then use the import functionality within DataStage manager and pick the XML files one by one. D...

import it with a same name - do you mean the file or the routine? You are able to name the file anything you want. Similarly, if you want just the routine, you could manually edit the XML and change the name, should it clash with a routine that you already have. I recommend that you import each of ...

And if you can't find it in the forum, one possible solution is the UNIX "paste" command. Try "man paste" for an explanation.

Try this thread: viewtopic.php?t=95633. It provides you with the ability to dump the content of the log to a flat file. This may be what you are after.

David

I don't see -13s any more. I did at one stage but I think it was a bug in the initial version(s?) of JobLogGet. I deployed an update to it on Oct 7th. Did you obtain a version prior to then? Is so, could you try getting the most recent version of the routine and see if it helps? Plus there was a min...

A minor refinement to the grep suggestion. Something like the following:
would output everything bar that which matches the format of the trailer record, so TRA could appear in other data records.

I think I see a -13 when the most recent action on the job is that is was compiled. I'll have a nosey and see if I can find out more about where the -13 is coming from, but it might not be until next week, as we have an office move on tomorrow.

David

This thread viewtopic.php?t=95633 may provide you with what you are looking for. It contains a number of DS objects which, when imported into DS, allow you to dump the content of the job log.

HTH.

David.

One option may be the Unix "paste" command. You can use it to roll-up multiple lines of data into a single line (I'm assuming that there are a consistent number of rows per set to be rolled up). I don't have a Unix command session on hand to try this but some variation on paste -s -d '\t\t...

Using this job is (meant to be) fairly straight forward. There are five parameters: JOB_NAME_MATCH Specifies a pattern which jobs' name should match to be included in the output. Use ... to obtain all jobs. EXCLUDED_JOBS_LIST A comma separated list of job names that are excluded from the output. EXC...

The final object is a job that actually uses the shared container. I'll post this, have some dinner, and then follow up with a brief description of using this job. <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE DSExport [ <!ELEMENT DSExport (Header, (Job | SharedContainer | Dat...