log files

bikan · Post by **bikan** » Thu Jan 17, 2008 1:52 am

Can sumbody tell me column defination of RT_LOGnnn file. ( I searched on forum but could not get it)

I want to dump log file for each job into delimiter file.

Also by Dsjob command can I copy complete log into file I have tried
c:\Ascential\DataStage\Engine\bin\dsjob -logdetail #$DS_PROJ_NAME# <Job Name> > #$DS_LOG_FILE_DIR#\LFM_Load_Cust_Vech_Dtl_CapRej.txt
but it's not working.
when I try
:\Ascential\DataStage\Engine\bin\dsjob -logaum #$DS_PROJ_NAME# <Job Name> > #$DS_LOG_FILE_DIR#\LFM_Load_Cust_Vech_Dtl_CapRej.txt
there warning msg are getting trucated.

AmeyJoshi14 · Post by **AmeyJoshi14** » Thu Jan 17, 2008 2:37 am

bikan wrote:Can sumbody tell me column defination of RT_LOGnnn file. ( I searched on forum but could not get it)

I want to dump log file for each job into delimiter file.

Also by Dsjob command can I copy complete log into file I have tried
c:\Ascential\DataStage\Engine\bin\dsjob -logdetail #$DS_PROJ_NAME# <Job Name> > #$DS_LOG_FILE_DIR#\LFM_Load_Cust_Vech_Dtl_CapRej.txt
but it's not working.
when I try
:\Ascential\DataStage\Engine\bin\dsjob -logaum #$DS_PROJ_NAME# <Job Name> > #$DS_LOG_FILE_DIR#\LFM_Load_Cust_Vech_Dtl_CapRej.txt
there warning msg are getting trucated.

Yes,from DSjob Command you can copy complete log into file.

$path/dsjob -logsum -type INFO -max 30 PRJCT_NAME JOB_NMAE > /path/log.txt

Now if you want only Warning , instead of INFO use warning...

For detail logs use -logdetails.

AmeyJoshi14 · Post by **AmeyJoshi14** » Thu Jan 17, 2008 4:38 am

One more thing ...

if you want the last run job logs first you have to again use "logsum" command:
/bin/dsjob -logsum -type STARTED -max 2 PRJCT_NAME JOB_NAME
This will give you the 'start' and 'end' event ids...substract the two and you will get the number of logs generated from last run..

Suppose this value is 45 then in "logsum" command use the max value as 45( instead of 30).....

ray.wurlod · Post by **ray.wurlod** » Thu Jan 17, 2008 5:25 am

Columns for DataStage log tables are:

Code: Select all

@ID        INTEGER   displayed 10 characters wide with leading zeroes
TYPE       TINYINT   encoded severity value
WAVE.NO    INTEGER   internal uniqueness number used by DataStage
FULL.TEXT  VARCHAR   text of the log event
SEVERITY   VARCHAR   decoded severity value e.g. "Info", "Warning"

An example query, losing the leading zeroes:

Code: Select all

SELECT @ID FMT '10R', SEVERITY, FULL.TEXT FROM RT_LOG135 WHERE @ID NOT LIKE '//%' ORDER BY 1;

shivadas · Post by **shivadas** » Sat May 03, 2008 6:25 am

Hi,
Can you please tell me where the datastage log table will be ...
how do i access the table without using dsjob

thanks
Das
[/quote]

ray.wurlod · Post by **ray.wurlod** » Sat May 03, 2008 6:45 pm

It's in the DataStage Repository database. You can execute queries from the Administrator client Command window, or after establishing a telnet session and opening dssh in the project on the server.

shivadas · Post by **shivadas** » Sun May 04, 2008 2:10 am

ray.wurlod wrote:It's in the DataStage Repository database. You can execute queries from the Administrator client Command window, or after establishing a telnet session and opening dssh in the project on the server. ...

Hi ray,
Thanks for the info...
in Admin client command window

select * from

what will be the table name?

in my system Datastage is installed on Unix os and we use IDB DB2 database i have few schemas on the database. How do i check the schema of repository database...

Thanks
das

ray.wurlod · Post by **ray.wurlod** » Sun May 04, 2008 4:07 pm

You use DataStage, not DB2, for the DataStage Repository, since your DataStage version is 7.

The name of the table is RT_LOGnnn, where nnn is the job number. Each job has its own, separate, log table.

shivadas · Post by **shivadas** » Mon May 05, 2008 2:34 am

ray.wurlod wrote:You use DataStage, not DB2, for the DataStage Repository, since your DataStage version is 7.

The name of the table is RT_LOGnnn, where nnn is the job number. Each job has its own, separate, log ta ...

Hi Ray,

when i query from the Administrator command window I am able to see the logs, but when i am querying from outside it is asking for the schema ...
can you please let me know the schema name
eg: SELECT * FROM ?.RT_LOG10

If this information is stored in table what sort of the database will it use to store the information.., is it .mdb by any chance

Thanks
Das

ArndW · Post by **ArndW** » Mon May 05, 2008 2:58 am

These are DataStage hashed files; there is no schema and there is no method of accessing them apart from the TCL command (or the command line tool in the administrator)

ray.wurlod · Post by **ray.wurlod** » Mon May 05, 2008 3:39 am

The schema name is the same as the project name, but is not necessary if you are in the project "account". So, when you choose the project in the Administrator client before opening the Command window, the schema is automatically selected. Therefore, SELECT * FROM RT_LOG10; (with the terminating semi-colon, which is required) will work, provided that there is a job number 10. If that does not work, please post the exact error message. Note also that the name of the table must be in upper case.

veera24 · Post by **veera24** » Sun May 11, 2008 12:27 am

shivadas wrote:
ray.wurlod wrote:You use DataStage, not DB2, for the DataStage Repository, since your DataStage version is 7.

The name of the table is RT_LOGnnn, where nnn is the job number. Each job has its own, separate, log ta ...
Hi Ray,

when i query from the Administrator command window I am able to see the logs, but when i am querying from outside it is asking for the schema ...
can you please let me know the schema name
eg: SELECT * FROM ?.RT_LOG10

If this information is stored in table what sort of the database will it use to store the information.., is it .mdb by any chance

Thanks
Das

hi,
can any one explain me how to go to Administrator command window

veera24 · Post by **veera24** » Sun May 11, 2008 12:29 am

AmeyJoshi14 wrote:
bikan wrote:Can sumbody tell me column defination of RT_LOGnnn file. ( I searched on forum but could not get it)

I want to dump log file for each job into delimiter file.

Also by Dsjob command can I copy complete log into file I have tried
c:\Ascential\DataStage\Engine\bin\dsjob -logdetail #$DS_PROJ_NAME# <Job Name> > #$DS_LOG_FILE_DIR#\LFM_Load_Cust_Vech_Dtl_CapRej.txt
but it's not working.
when I try
:\Ascential\DataStage\Engine\bin\dsjob -logaum #$DS_PROJ_NAME# <Job Name> > #$DS_LOG_FILE_DIR#\LFM_Load_Cust_Vech_Dtl_CapRej.txt
there warning msg are getting trucated.
Yes,from DSjob Command you can copy complete log into file.

$path/dsjob -logsum -type INFO -max 30 PRJCT_NAME JOB_NMAE > /path/log.txt

Now if you want only Warning , instead of INFO use warning...

For detail logs use -logdetails.

hi amey
please excuse me.. since am new to datastage i couldn understand ur point so could you pls. explain in detail so that it will be helpful for me.. hope you will..
Your time ll b highly appreciated...
thanks in adv...
veera...

chulett · Post by **chulett** » Sun May 11, 2008 7:34 am

veera24 wrote:can any one explain me how to go to Administrator command window

Okay... Administrator / Projects / <select project> / Command.

tsn · Post by **tsn** » Mon May 12, 2008 4:32 am

get into datastage administrator and then go to project tab and select the project and click the command. Type the query and then execute.

DSXchange

log files

log files

Re: log files

Can use logsum

Datastage log tables

Datastage log Table

Log table

Re: Log table

Re: log files

Re: Log table