Reg. log files

Naveen · Post by **Naveen** » Wed Apr 11, 2007 1:40 am

Hi,

Pls tell me the path where the logfiles are getting stored in DS server.
And also tell me how the structure it look like??

ray.wurlod · Post by **ray.wurlod** » Wed Apr 11, 2007 2:12 am

If you are talking about DataStage job logs, they are not stored in files at all. They are stored in database tables in the Repository for the project.

Like with any database product, the structure is irrelevant to you. You can access its contents with DataStage/SQL, with the Director client, with the dsjob command or through the DataStage API.

cosec · Post by **cosec** » Thu May 24, 2007 2:08 am

Where can i get info on this database

ray.wurlod wrote:If you are talking about DataStage job logs, they are not stored in files at all. They are stored in database tables in the Repository for the project.

Like with any database product, the structur ...

ray.wurlod · Post by **ray.wurlod** » Thu May 24, 2007 2:44 pm

Nowhere, really. The vendor chooses not to publish details.

When a project is created several tables (implemented as hashed files) having names beginning with "DS_" are created to store the design-time components, for example DS_ROUTINES, DS_CONTAINERS.

When a job is created several more tables (implemented as hashed files) are created to store run-time information, for example RT_CONFIGnnn, RT_STATUSnnn, RT_LOGnnn, where nnn is the unique number allocated to the job by DataStage.