IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

How to get the plan name/correlation id in the logscan


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
ravindra.vadali

New User


Joined: 30 Jan 2012
Posts: 34
Location: USA

PostPosted: Thu Jul 16, 2015 1:22 am
Reply with quote

Hi

Firstly, my apologies if this question was already posted. I searched for a few combinations in the forum but didn't find the appropriate one so I am guessing I am the first one to ask this, but incase if you have already discussed on this then please redirect me.


I have a requirement where I have to run a logscan job on few tables and collect the data on few of the columns, also I have to collect the plan name/ correlation id for that unit of work, meaning I have to find what program updated/deleted/inserted that row.

I tried to use the following option

(URID 65
LOGRECORD 10
FORWARDCOMPLETION 10
BACKWARDCOMPLETION 10
ANOMALY 5)

But this is giving me the unit of recovery id details, database name, table space name and table name but is not returning the plan name or correlation id.

I did a little research on SYSIBM tables which use the plane name columns or correlation id and I found that SYSIBM.DSN_PGROUP_TABLE has near to what I need but unfortunately I have no access to that table to see the actual content.

Could you please help me if you know any solution on this?

Thanks a many for your help!!

Regards,
Ravi.
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1020
Location: India

PostPosted: Fri Aug 07, 2015 4:26 pm
Reply with quote

Hi Ravi,

How are you doing this log scan via BMC or CA Log Analyzer ?

I know in CA Log analyzer it will give you the plan and correlation id.

Thanks,
Sushanth
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts current batch plan DB2 3
No new posts Log an Plan name/id or Job Id using D... DB2 1
No new posts Usage/Utiliy of Plan in DB2 DB2 4
No new posts How do I define a DB2 plan for a web ... CICS 5
No new posts Finding the plan when code compiled u... DB2 2
Search our Forums:

Back to Top