DSXchange

There are at least four ways to accomplish this. Exactly which is most appropriate depends on exactly what you are trying to do. In particular, what is the rule that generates the "1", "2", etc.? If its just the two that you specify, try writing to a single sequential file a single column containing...

This is easily accomplished with DataStage job control. Create a job that consists only of a job control routine and, in that routine, perform whatever monitoring task you require. -----Original Message----- From: Roosa, Mike [mailto:Mike.Roosa@getronics.com] Sent: Saturday, 11 August 2001 04:11 To:...

This one looks like a timeout for connecting to SQL Server has expired. The error message has come back from the ODBC driver for SQL Server, so its outside the domain of DataStage. -----Original Message----- From: Roosa, Mike [mailto:Mike.Roosa@getronics.com] Sent: Friday, 10 August 2001 22:50 To: d...

Essentially the log file for job # 49 has become corrupted (physically). UniVerse does ship with repair tools that *may* fix it. The main ones are called uvfixfile and fixtool. UniVerse specialists can effect repair with other tools. Before attempting to use these I would try to purge the file of al...

I will make a wild guess that youre running your batch of jobs via few jobs which exclusively run Job Control. If so, you can inquire with DSGetJobInfo once a job finishes to see what the DSJ.JOBSTATUS is set to. If the job is aborted or stopped, have it reset and rerun the job. But do this only if ...

I would like to know if it is possible to write a universe program to monitor the status of all the jobs and automatically restart them if they have aborted. Or can I do this with current functionality in the Datastage application. It seems that one or two of our jobs will abort once or twice a week...

This is a topic for an orphaned message.

Bibhu, Here is the text from the second document. HTH, Mark Document 2 ------------------------------------------------- DataStage Reference Lookups The most important factor in maximizing DataStage Reference Lookup performance when using large hashed files is to use the Windows NT Cache Manager by ...

This is a topic for an orphaned message.

Bibhu, I see that the attachments did not make it. Here is the text from the first document; Ill send the text from the second document in another message, since the size limit for emails on this listserve will not allow me to include both in one message. FYI, document 2 applies specifically to perf...

Hi All, Even when I am in the design phase of my ETL jobs, I was curious to know about the ways to improve performance of DataStage jobs. I understand that use of hash files is one of ways, but the manuals are really tightlipped about them and any other paths that one would want to tread to improve ...

The Pivot stage supports functionality whereby you can wirte multiple output from a single input. The only caveat is that your input data must conform to some pivot rules. You might be able to fool around with this a little to get it to do what you want (in your example, send your data to a transfor...

I have routines where I need to write a rejected record from potentially 4 different points in a job. I write to the same hashed file stage from each of the 4 (Transformer) points. Then, in a parent "driver" job (which calls this one via Job Control and therefore runs the dependent job before its ow...

I have a job that does that except Im writing the multiple records to a table using an OCI. I changed the OCI to a sequential file and got the same results you did, even when I set it to append to file. Maybe you can write to multiple sequential files and then merge them. Kenny -----Original Message...

Hi, How to generate many output records to the same text file from 1 input record. Such as I have 1 record "A" and I want to generate 2 records "A","1" and "A","2". I try to do this but I have problem because if I have 2 links from 1 transformer stage to sequential stage. It will generate only 1 rec...