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

Need to Catalog VSAM file


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

New User


Joined: 14 Oct 2011
Posts: 3
Location: India

PostPosted: Mon Oct 17, 2011 12:06 pm
Reply with quote

Hi All,

Good day !!!

Two months back our Mainframe server has experienced a hardware failure which maybe difficult to remedy because of it's age. We would like to recover the VSAM files for future use. And we are going to use "ADRDSSU" utility to take backup for all VSAM files into single sequential file. But the problem is VSAM files are in proper volumes but not cataloged. so we are unable to take backup using "ADRDSSU" utility. Please help.
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix

PostPosted: Mon Oct 17, 2011 12:11 pm
Reply with quote

Have you talked to your storage people? They will know how to catalogue files. It is not difficult. If test files, you can do it yourself. Anything else, leave to appropriate person responsible.

Consult the VSAM manual looking for words which might help if you want to CATALOG a dataset.
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Mon Oct 17, 2011 12:16 pm
Reply with quote

Most probably the storage group of this dis.organization are just incompetent morons

how to recover a orphan VSAM dataset is part of the basic storage training and most important tutoring

did they ever hear of the word RECATALOG ?
Back to top
View user's profile Send private message
Raja Dayalan

New User


Joined: 14 Oct 2011
Posts: 3
Location: India

PostPosted: Mon Oct 17, 2011 12:19 pm
Reply with quote

Thank you Bill.

Actually we don't have Mainframe system administator here to guide us. We (Programmer) are assigned to work on this issue and we are trying our best. icon_sad.gif
Back to top
View user's profile Send private message
Raja Dayalan

New User


Joined: 14 Oct 2011
Posts: 3
Location: India

PostPosted: Mon Oct 17, 2011 12:21 pm
Reply with quote

Well, we even tried with RECATALOG option but the step throws belolw error.

Job :

Code:
//DEFJMB  EXEC PGM=IDCAMS                                         
//AMSDUMP  DD  SYSOUT=*                                           
//SYSPRINT DD  SYSOUT=*                                           
//SYSIN    DD  *                                                 
  DEFINE CLUSTER -                                               
    ( -                                                           
    NAME (SGAHLAN.PST.TS.JMB.LLL1200.MSTR) -                     
    RECATALOG VOLUMES(VSAM03) INDEXED) -                         
    DATA(NAME(SGAHLAN.PST.TS.JMB.LLL1200.MSTR.DATA) -             
    VOLUMES(VSAM03)) -                                           
    INDEX(NAME(SGAHLAN.PST.TS.JMB.LLL1200.MSTR.INDEX) -           
    VOLUMES(VSAM03))                                             
/*                       


Error message :

Code:
IDCAMS  SYSTEM SERVICES                                           TIME: 03:
                                                                           
  DEFINE CLUSTER -                                                         
    ( -                                                                   
    NAME (SGAHLAN.PST.TS.JMB.LLL1200.MSTR) -                               
    RECATALOG VOLUMES(VSAM03) INDEXED) -                                   
    DATA(NAME(SGAHLAN.PST.TS.JMB.LLL1200.MSTR.DATA) -                     
    VOLUMES(VSAM03)) -                                                     
    INDEX(NAME(SGAHLAN.PST.TS.JMB.LLL1200.MSTR.INDEX) -                   
    VOLUMES(VSAM03))                                                       
IDC3014I CATALOG ERROR                                                     
IDC3009I ** VSAM CATALOG RETURN CODE IS 50 - REASON CODE IS IGG0CLE4-88   
IDC3003I FUNCTION TERMINATED. CONDITION CODE IS 12                         
                                                                           
IDC0002I IDCAMS PROCESSING COMPLETE. MAXIMUM CONDITION CODE WAS 12         

Please advise.
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Mon Oct 17, 2011 12:29 pm
Reply with quote

RTFM

it' going to be a loong week

You should remember that people replying do it
on their own time
free of charge


if Your organization decided to save money by not providing the proper resources
for what reason You think that we should spend our money (*) to get Your stupid organization out of trouble

yes,
I strongly support the concept that in this case we are not helping a poor guy
we do for free the job for which the dis.organization does not want to spend money

(*)
our time ,
our experience is a valuable resource on which we spent time
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix

PostPosted: Mon Oct 17, 2011 12:53 pm
Reply with quote

You need to point this example out to your management. This sort of thing is outside the normal expectation for your work.

Yes, you could catalog all the datasets, but you need to check on everything beforehand. You need to know that all those are related directly to the original problem. You need to try to ensure that if the same hardware problem happens it is identified quickly or has no data impact etc, and many other things.

You have no time for all that. Your organisation needs that to feel secure. You might even need all that for correct audit/accounts (depending on size/industry of organisation).

Plus, on top of all that - whose head rolls if this is done wrong in some big way that you don't even know is possible because you don't have the training?
Back to top
View user's profile Send private message
Pete Wilson

Active Member


Joined: 31 Dec 2009
Posts: 580
Location: London

PostPosted: Thu Nov 24, 2011 11:23 pm
Reply with quote

Try the DEFINE RECATALOG specifying just the Cluster name and the VOLUME where the Data component resides, and the RECORG (INDEXED, ORDERED, NUMBER etc). Depends a bit on what level of ZOS (or OS) you're on, and if they're multivolume, and if their original Usercatalog and Alias still exists. IDCAMS uses the information from the VVDS on the volume to rebuild the catalog information so you must specify the correct volume(s) in order.

e.g. for a KSDS
DEF CL(cluster.name) VOL(volser) INDEXED ) RECATALOG

If you need to find the catalog they should be in then use IDCAMS PRINT to print the VVDS of the volume and find the cluster name which will lead you to that info.
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 How to split large record length file... DFSORT/ICETOOL 9
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts Access to non cataloged VSAM file JCL & VSAM 18
No new posts Need help for File Aid JCL to extract... Compuware & Other Tools 23
Search our Forums:

Back to Top