Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

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

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: How to get the plan name/correlation id in the logscan
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: 1013
Location: India

PostPosted: Fri Aug 07, 2015 4:26 pm    Post subject:
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Program and its corresponding plan vickey_dw DB2 4 Thu Apr 07, 2016 9:27 pm
No new posts Should we Rebind Plan if no SQL changes sappy_mf DB2 2 Thu Mar 03, 2016 2:13 pm
No new posts What's plan, package, bind ? jackzhang75 DB2 2 Sun Feb 28, 2016 7:29 pm
No new posts DB2 plan for DSNTEP2 / DSNTEP4 Mainak_Dalal DB2 3 Thu Jan 21, 2016 1:08 am
No new posts Multiple COBOL-DB2 pragrams calling b... deepak_shrivastava DB2 1 Wed Jan 06, 2016 3:45 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us