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

How to get information about migrated datasets and VSAM


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Abhishek Goel

New User


Joined: 05 Apr 2006
Posts: 6
Location: India

PostPosted: Thu Aug 16, 2007 10:29 am
Reply with quote

Hi everyone,

could anyone please advice how using a REXX exec I can get information (creation date, last reference date, used space) about migrated, VSAM and tape datasets? I tried using DCOLLECT but I don't have sufficient access and also the datsets HSM.MCDS & HSM.BCDS which are required for getting the above information for migrated datasets are not cataloged in my system. I also came accross a command LISTP which seems to be able to give the information I am looking for but when I tried, it says TSO command not found. I know that by putting the RECALL option in LISTDSI we can first recall the migrated datasets and get the information but I don't want the dataset to be recalled.
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales

PostPosted: Thu Aug 16, 2007 1:33 pm
Reply with quote

The only way to get this info is either from the DCOLECT M records, or from the MCDS D records. When VSAM is migrated, it becomes a PS dataset so not even catalog info would give you what you want.

I am very surprised that the CDS datasets are not catalogued. The surely should be. Perhaps they have a different HLQ other than HSM.

To get the DCOLLECT info you will need to talk to your security people to allow you the access, probably the same to access the MCDS too, although if you are using RLS for the CDS you may not be able to REPRO out the MCDS to a flat file.

Can you not use a backup version of the MCDS dataset, restore it with Dfdss to a new name and then use that to REPRO out and analyse ?
Back to top
View user's profile Send private message
gauravgupta01

New User


Joined: 29 Nov 2007
Posts: 10
Location: Delhi

PostPosted: Fri Jun 06, 2008 2:27 pm
Reply with quote

HI Expat,

Thanks for the info.....I also cud not fing the CDS datasets but with other HLQ I was able to figure that out.....I also copied down a bakup to my file.

Now the problem is I do not know what are the MCDS D records and also what information I will get about migrated datasets as all info I am getting is not in displayble format.
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales

PostPosted: Fri Jun 06, 2008 4:10 pm
Reply with quote

You need to get a hold of the DFSMShsm disgnostics manual to see the layout of the record formats, and that yill give you everything that you need to know.
Back to top
View user's profile Send private message
gcicchet

Senior Member


Joined: 28 Jul 2006
Posts: 1702
Location: Australia

PostPosted: Fri Jun 06, 2008 4:56 pm
Reply with quote

Hi,
here is some JCL that should assist

Code:
//ALLOCATE EXEC PGM=IEFBR14                                             
//ALLOCATE DD DSN=OUPT-FILE,                                           
//            DISP=(,CATLG,DELETE),                                     
//            UNIT=(SYSDA,3),                                           
//            SPACE=(TRK,(500,150),RLSE),                               
//            DCB=(RECFM=FBA,LRECL=121)                                 
//*                                                                     
//**********************************************************************
//*                                                                     
//HLIST    EXEC PGM=IKJEFT01,DYNAMNBR=30                               
//SYSTSPRT DD SYSOUT=*                                                 
//SYSTSIN  DD *                                                         
HLIST DSNAME('USER.CAL') BOTH ODS('OUTPUT-FILE')                       


or
Code:
HLIST LEVEL(Userid) BOTH ODS('output-file')



Gerry
Back to top
View user's profile Send private message
gauravgupta01

New User


Joined: 29 Nov 2007
Posts: 10
Location: Delhi

PostPosted: Tue Jun 10, 2008 1:04 pm
Reply with quote

Hi Gerry,

Thanks a lot for the code that you have provided. I can fetch the relevent information now. Could you help me with the values that the code is fetching.

following are the fields which I am not able to understand :

QTY QTY
2K BLKS 16K BLKS

Please tell what info are these feilds showing.

Once again thanks a lot.
Back to top
View user's profile Send private message
gcicchet

Senior Member


Joined: 28 Jul 2006
Posts: 1702
Location: Australia

PostPosted: Wed Jun 11, 2008 5:15 am
Reply with quote

Hi,
my understanding of 2k blks and 16k blks is that HSM writes in 2k blks when it writes to MIGRAT1 and 16k blks when it writes to MIGRAT2.


Gerry
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 -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts Access to non cataloged VSAM file JCL & VSAM 18
No new posts Capturing Job Execution Information All Other Mainframe Topics 3
No new posts Merge two VSAM KSDS files into third ... JCL & VSAM 6
No new posts CVDA value for RRDS VSAM dataset. CICS 2
No new posts VSAM return code 23 - for a Random read COBOL Programming 4
Search our Forums:

Back to Top