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

Underlying DB2 VSAM LDS - SMF recording


IBM Mainframe Forums -> All Other Mainframe Topics
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
vasanthz

Global Moderator


Joined: 28 Aug 2007
Posts: 1693
Location: Tiruppur, India

PostPosted: Thu Jan 05, 2017 4:20 am
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: 888
Location: The Universe

PostPosted: Thu Jan 05, 2017 5:55 am
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: 1693
Location: Tiruppur, India

PostPosted: Thu Jan 05, 2017 6:02 am
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: 888
Location: The Universe

PostPosted: Thu Jan 05, 2017 9:24 am
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: 8578
Location: Dubuque, Iowa, USA

PostPosted: Thu Jan 05, 2017 8:08 pm
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: 1693
Location: Tiruppur, India

PostPosted: Thu Jan 05, 2017 11:35 pm
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: 888
Location: The Universe

PostPosted: Fri Jan 06, 2017 7:12 am
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> All Other Mainframe Topics

 


Similar Topics
Topic Forum Replies
No new posts Map VSAM Dataset to a Table/Tablespace DB2 2
No new posts Recreating VSAM cluster catalog info ... All Other Mainframe Topics 6
No new posts VSAM file Storage Calculation JCL & VSAM 3
No new posts FILE STATUS - 39 ON VARIABLE LENGTH V... COBOL Programming 2
No new posts VSAM Alter Command - Cylinder Extent ... JCL & VSAM 3
Search our Forums:

Back to Top