DSXchange

Slow performance.

Job monitor (via Director).
Job log view (via Director).
Job compilation (via Designer).
Job execution (Via Designer or Director).

Many regards,
Abhijit Gaikwad

No respite unless you successfully emulate the problem in front of support from IBM.

Rare and hence arguable.

Many regards,

SP2 Patch had solved the problem.

thanks.

Many regards,

I have raised a PMr with IBM and waiting their response.

Shall close this thread afterwards for I beleive, this BW stage is hardly used by any DataStage user.

Many regards,

Generics and specifics.

:? Some people fail even after they are given choice to use all their textbooks they have during their exams. Once a business analyst had to write the code in order to explain the technical data analyst to make him understand the requirement. So, use this code. Code and technical specifications. :D ...

Dr. Murthy,

During a long drive, you find that one of the tyres has become flat. Is this a problem with the tyre, the motor or the road ?

How long does the DataStage job run before the ORA-03135 error is thrown ?

Analysis on your issue depends on the above question.

Many regards,

Ain't sure, but this might not work after you have installed the engine and services.

A database alias might be a simple working solution. Else, raise a PMR to IBM and get their opinion.

Many regards,

With 8, theres no separate installation for Client atleast for Windows. Run Setup, you get a prompt to select the components - 1. Client 2. Engine 3. Services Offcourse, on Windows, there must be some setup.exe called by the main installation program which could be run separately. No R&D but wit...

Right, thanks for sharing the information. But, Karunakar's thread is about DataStage 7.5.1 and his query about his schedules suddenly vanishing. Even with DataStage 8, the scheduling and reporting capabilities are cause of WebSphere. Situation very much similar to that of DataStage 7.1 or 7.5.x whe...

Puli, You never explained the reason for removing the so-called junk character. Reason for having it, either. Theres no need to remove any such characters unless it is displayed somewhere in reports. I believe, this is some kinda descriptive field. If the above is true, purpose of ETL tool is "...

Nothing much to say. DSXChange has a few experts who can guide the needy. But Ofcourse, it is an individuals choice to decide to serve public or to make money. May take years, though, to become an unprecedented site like Oracle forums. Articles on Oracle are umpteen but try n search for an article o...

Hello Karunakar, DS does not have an inbuilt scheduler hence on UNIX it asks for help from AT (Utility for UNIX scheduling) or Cron (Master scheduler). Once you schedule a job in DS, please logon with the same user on the command prompt and see youself. Use at -l for this purpose. If someone issues ...

Two alternatives.

Use FTP stage for getting the file from the remote machine onto the drive which is visible to your DataStage.

Ask somebody to periodically send the required file to a place that is accessible to DataStage.

Many regards,

@All (except requester). Thought process doesn't work for a person in problem. We all behave in that way. @Requester Better try no to concatenate everything into one column. Based on my interpretation from your super-detailed request for help . 1. Write a job that pulls information into N distinct f...