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
 

 

Underlying DB2 VSAM LDS - SMF recording

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics
View previous topic :: :: View next topic  
Author Message
vasanthz

Global Moderator


Joined: 28 Aug 2007
Posts: 1504
Location: Chennai

PostPosted: Thu Jan 05, 2017 4:20 am    Post subject: Underlying DB2 VSAM LDS - SMF recording
Reply with quote

Hi,

We have a VSAM file and it is an underlying DB2 LDS dataset. We are trying to find out who/what job referenced the dataset.

The dataset information says the dataset was accessed 2 days back.
Code:
Dates                             
 Creation date . . . : 2013/05/05
 Referenced date . . : 2017/01/02
 Expiration date . . : ***None***

But when we look at the SMF 14, 15, 17, 18, 60 to 68 record types for that particular day, there is no evidence on SMF for that access.
Could you please let me know if DB2 secretly accesses its datasets and does not leave an entry on 14, 15, 17, 18, 60 to 68 record types.

Is there any other place we could look?
Back to top
View user's profile Send private message

steve-myers

Active Member


Joined: 30 Nov 2013
Posts: 534
Location: The Universe

PostPosted: Thu Jan 05, 2017 5:55 am    Post subject:
Reply with quote

Try reading MVS System Management Facilities (SMF) for your release. I suspect the record you need is not one of the garbage list of SMF records you listed.
Back to top
View user's profile Send private message
vasanthz

Global Moderator


Joined: 28 Aug 2007
Posts: 1504
Location: Chennai

PostPosted: Thu Jan 05, 2017 6:02 am    Post subject:
Reply with quote

Quote:
not one of the garbage list of SMF records you listed.
They all appear elegant to me in their own way :-)
Back to top
View user's profile Send private message
steve-myers

Active Member


Joined: 30 Nov 2013
Posts: 534
Location: The Universe

PostPosted: Thu Jan 05, 2017 9:24 am    Post subject:
Reply with quote

It's a "garbage list" because opening or closing a VSAM data set does not produce any of the SMF records in the list.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8117
Location: East Dubuque, Illinois, USA

PostPosted: Thu Jan 05, 2017 8:08 pm    Post subject: Reply to: Underlying DB2 VSAM LDS - SMF recording
Reply with quote

From the SMF manual:
Quote:
Record type 62 is written at the successful or unsuccessful opening of a VSAM component or cluster.


However, the issue probably is that DB2 may open the VSAM data set when it is started and not close it until the DB2 subsystem is brought down. Hence unless you're looking at the SMF records generated after an IPL or DB2 start up, you may not see any type 62 records.
Back to top
View user's profile Send private message
vasanthz

Global Moderator


Joined: 28 Aug 2007
Posts: 1504
Location: Chennai

PostPosted: Thu Jan 05, 2017 11:35 pm    Post subject:
Reply with quote

Quote:
DB2 may open the VSAM data set when it is started and not close it until the DB2 subsystem is brought down.

Thank you for your reply Robert. I was having a similar thought but the dataset information says that it was referenced on 2017/01/02.
So I was thinking that the dataset must have been closed. Also the dataset is no longer used by DB2 now. So between 2017/01/01 and now the dataset must have been closed, But there is no evidence of it in the SMF 60 to 68.
Back to top
View user's profile Send private message
steve-myers

Active Member


Joined: 30 Nov 2013
Posts: 534
Location: The Universe

PostPosted: Fri Jan 06, 2017 7:12 am    Post subject:
Reply with quote

Remember, when you examine type 62 records, SMF62DMD will be the name of the data component of the LDS, not the LDS name.
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 -> All Other Mainframe Topics All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts VSAM Space Allocation mrgnndhmk JCL & VSAM 7 Sat Apr 22, 2017 12:42 am
No new posts Updating a VSAM file with DISP=OLD sheersh JCL & VSAM 8 Tue Mar 14, 2017 6:14 pm
No new posts SORT VSAM file with each field one by... maxsubrat DFSORT/ICETOOL 6 Tue Mar 14, 2017 1:07 pm
No new posts VSAM RLS=NRI while doing IDCAMS sheersh JCL & VSAM 1 Tue Mar 07, 2017 1:55 pm
No new posts Fail to change physical VSAM filename... jacobdng CICS 7 Fri Jan 20, 2017 12:36 pm


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