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

New User

Joined: 30 Jan 2012
Posts: 34
Location: USA

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


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

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!!

Back to top
View user's profile Send private message
sushanth bobby

Senior Member

Joined: 29 Jul 2008
Posts: 1018
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.

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