DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
abc123



Group memberships:
Premium Members

Joined: 25 Aug 2006
Posts: 606

Points: 5478

Post Posted: Mon Nov 18, 2019 1:47 pm Reply with quote    Back to top    

DataStage® Release: 9x
Job Type: Parallel
OS: Unix
I would like to query the log of a multi-instance job. I would like to see if any of the instances ever encountered a warning. I thought of querying RT_STATUSnnn files in the project but I am not sure how to do it. Any ideas? Is there any other way that this can be done?
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 43085
Location: Denver, CO
Points: 222463

Post Posted: Tue Nov 19, 2019 5:49 am Reply with quote    Back to top    

Well... lots of discussions here but it can be a bit of a pain to wade through them looking for the bits you are interested in.

There are basically two places you can access the job information via the API: your server's command line or the BASIC routine API. Both have the same set of functions. Both the command line interface and BASIC API are fully documented, or at least they were and I assume they still are. From the command line you would use the "dsjob" utility, the same one that amongst other things can start/monitor/stop jobs. Then there are all of the various "DSGetJob***" options you can call in a custom BASIC routine and leverage in a Sequence or Server job.

For the previous discussions, I'd suggest an exact search here for "multi-instance" and/or "dsgetjob". Shouldn't really matter how old they are as this is core functionality that has not changed. Keep in mind the fact the multi-instance job invocations are all stored in the same log, identified by their InvocationID. The Director can make them look like they are stored separately, but it is basically using a "view" in the table to filter each one.

_________________
-craig

"You can never have too many knives" -- Logan Nine Fingers
Rate this response:  
abc123



Group memberships:
Premium Members

Joined: 25 Aug 2006
Posts: 606

Points: 5478

Post Posted: Tue Nov 19, 2019 4:01 pm Reply with quote    Back to top    

Thanks. I tried:
dsjob -domain MyDomain -user MyID -password MyPwd -server MyServer -logdetail MyProj MyJob.InstanceID

I get the error:
ERROR: ASBHome not found
no JvmPath configured
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 43085
Location: Denver, CO
Points: 222463

Post Posted: Tue Nov 19, 2019 8:14 pm Reply with quote    Back to top    

As what user? Don't know what "ABSHOME" is but if it is Java based, from the error it would seem that $JAVA_HOME may not be set. Are you running this with the proper user with the proper / full set of expected environment variables set?

Others will need to provide specific guidance, sorry but after all these years I'm only good for the general stuffs. Wink

_________________
-craig

"You can never have too many knives" -- Logan Nine Fingers
Rate this response:  
Not yet rated
PaulVL



Group memberships:
Premium Members

Joined: 17 Dec 2010
Posts: 1310

Points: 8608

Post Posted: Sun Nov 24, 2019 8:05 am Reply with quote    Back to top    

Did you source your dsenv settings?


$DSHOME/bin/dsjob -logdetail proj jobname.invocation
Rate this response:  
Not yet rated
battaliou
Participant



Joined: 24 Feb 2003
Posts: 155
Location: London
Points: 887

Post Posted: Sun Nov 24, 2019 9:23 am Reply with quote    Back to top    

Easy way to do it is to create a SERVER job with a HASHED file stage feeding an output link. Set the filename to RT_LOGnn and then go VIEW-DATA. You may have to setup a few column names, one being defined as a key.

_________________
3NF: Every non-key attribute must provide a fact about the key, the whole key, and nothing but the key. So help me Codd.
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54601
Location: Sydney, Australia
Points: 296091

Post Posted: Tue Dec 03, 2019 4:15 pm Reply with quote    Back to top    

Logs are also accessible from the DataStage Operations database (DSODB). This is fully documented in the IBM Knowledge Center, with example queries. Since InvocationID is a column in the JobExec 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.
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours