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 information about migrated datasets and VSAM

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
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    Post subject: How to get information about migrated datasets and VSAM
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: 8593
Location: Back in jolly old England

PostPosted: Thu Aug 16, 2007 1:33 pm    Post subject:
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    Post subject:
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: 8593
Location: Back in jolly old England

PostPosted: Fri Jun 06, 2008 4:10 pm    Post subject:
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: 1703
Location: Australia

PostPosted: Fri Jun 06, 2008 4:56 pm    Post subject:
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    Post subject:
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: 1703
Location: Australia

PostPosted: Wed Jun 11, 2008 5:15 am    Post subject:
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    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
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
No new posts how to recover an uncataloged VSAM da... archanamuthukrishnan All Other Mainframe Topics 4 Wed Jan 11, 2017 6:18 pm


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