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
 

 

Need to Catalog VSAM file

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
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    Post subject: Need to Catalog VSAM file
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

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7251

PostPosted: Mon Oct 17, 2011 12:11 pm    Post subject: Reply to: Need to Catalog VSAM file
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10210
Location: italy

PostPosted: Mon Oct 17, 2011 12:16 pm    Post subject: Reply to: Need to Catalog VSAM file
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    Post subject:
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    Post subject:
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10210
Location: italy

PostPosted: Mon Oct 17, 2011 12:29 pm    Post subject: Reply to: Need to Catalog VSAM file
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

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7251

PostPosted: Mon Oct 17, 2011 12:53 pm    Post subject: Reply to: Need to Catalog VSAM file
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 User


Joined: 31 Dec 2009
Posts: 437
Location: London

PostPosted: Thu Nov 24, 2011 11:23 pm    Post subject:
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    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 SORTJOIN - Copy Matched and Unmatched... Steve Ironmonger DFSORT/ICETOOL 5 Tue Jan 17, 2017 4:26 pm
No new posts how to recover an uncataloged VSAM da... archanamuthukrishnan All Other Mainframe Topics 3 Wed Jan 11, 2017 6:18 pm
No new posts Underlying DB2 VSAM LDS - SMF recording vasanthz All Other Mainframe Topics 6 Thu Jan 05, 2017 4:20 am
No new posts Copy RECFM =VB TO FB file with RECL =... sahil41352 DFSORT/ICETOOL 3 Wed Dec 28, 2016 11:29 pm
No new posts Add PD field from 2nd file to PD in 1st Sushant Garje DFSORT/ICETOOL 6 Thu Dec 01, 2016 4:32 pm


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