View previous topic :: View next topic
|
Author |
Message |
vasanthz
Global Moderator
Joined: 28 Aug 2007 Posts: 1742 Location: Tirupur, India
|
|
|
|
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 |
|
|
steve-myers
Active Member
Joined: 30 Nov 2013 Posts: 917 Location: The Universe
|
|
|
|
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 |
|
|
vasanthz
Global Moderator
Joined: 28 Aug 2007 Posts: 1742 Location: Tirupur, India
|
|
|
|
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 |
|
|
steve-myers
Active Member
Joined: 30 Nov 2013 Posts: 917 Location: The Universe
|
|
|
|
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 |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8696 Location: Dubuque, Iowa, USA
|
|
|
|
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 |
|
|
vasanthz
Global Moderator
Joined: 28 Aug 2007 Posts: 1742 Location: Tirupur, India
|
|
|
|
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 |
|
|
steve-myers
Active Member
Joined: 30 Nov 2013 Posts: 917 Location: The Universe
|
|
|
|
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 |
|
|
|