log files
Moderators: chulett, rschirm, roy
log files
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.
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.
-
- Participant
- Posts: 334
- Joined: Fri Dec 01, 2006 5:17 am
- Location: Texas
Re: log files
Yes,from DSjob Command you can copy complete log into file.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.
$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.
-
- Participant
- Posts: 334
- Joined: Fri Dec 01, 2006 5:17 am
- Location: Texas
Can use logsum
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).....
/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).....
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Columns for DataStage log tables are:
An example query, losing the leading zeroes:
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"
Code: Select all
SELECT @ID FMT '10R', SEVERITY, FULL.TEXT FROM RT_LOG135 WHERE @ID NOT LIKE '//%' ORDER BY 1;
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Datastage log tables
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]
Can you please tell me where the datastage log table will be ...
how do i access the table without using dsjob
thanks
Das
[/quote]
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Datastage log Table
Hi ray,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. ...
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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
The name of the table is RT_LOGnnn, where nnn is the job number. Each job has its own, separate, log table.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Log table
Hi Ray,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 ...
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
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)
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Re: Log table
hi,shivadas wrote:Hi Ray,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 ...
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
can any one explain me how to go to Administrator command window
Re: log files
hi ameyAmeyJoshi14 wrote:Yes,from DSjob Command you can copy complete log into file.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.
$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.
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...
Re: Log table
Okay... Administrator / Projects / <select project> / Command.veera24 wrote:can any one explain me how to go to Administrator command window
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers