IDC3009I ** VSAM CATALOG RETURN CODE IS 86 - REASON CODE IS



Help for IBM's record-oriented filesystem VSAM, ESDS, KSDS, RRDS, LDS and Storage management Subsystems

IDC3009I ** VSAM CATALOG RETURN CODE IS 86 - REASON CODE IS

Postby Bad Man » Wed Apr 20, 2011 7:01 pm

I have tried everything I can to delete this dataset like DELETE VVR and things....The dataset does not show on volume now....but shows only in 3.4 ...But ACSVS.ETFR.V122.CSI does not show up in 3.4 but ACS%S.ETFR.V122.CSI.DATA shows up

DEFINE CLUSTER -
(NAME(ACSVS.ETFR.V122.CSI) -
RECATALOG VOLUMES(PP0005))-
DATA (NAME(ACSVS.ETFR.V122.CSI.DATA) VOLUMES(PP0005)) -
INDEX (NAME(ACSVS.ETFR.V122.CSI.INDEX) VOLUMES(PP0005))
IDC3014I CATALOG ERROR
IDC3009I ** VSAM CATALOG RETURN CODE IS 86 - REASON CODE IS IGG0CLEY-6
IDC3003I FUNCTION TERMINATED. CONDITION CODE IS 12

IDC0002I IDCAMS PROCESSING COMPLETE. MAXIMUM CONDITION CODE WAS 12
Bad Man
 
Posts: 96
Joined: Sun Apr 04, 2010 2:20 pm
Has thanked: 0 time
Been thanked: 0 time

Re: IDC3009I ** VSAM CATALOG RETURN CODE IS 86 - REASON CODE IS

 

Re: IDC3009I ** VSAM CATALOG RETURN CODE IS 86 - REASON CODE

Postby MrH » Wed Apr 20, 2011 7:31 pm

Sounds like you've got an orphan. This is what happens when someone deletes a VSAM dataset incorrectly, and the catalog entries don't get removed correctly as a result. So:

1) Identify the correct catalog with the entry, using the IDCAMS LISTCAT utility.
2) Delete with the following IDCAMS statement, using the correct catalog:
DELETE ACSVS.ETFR.V122.CSI.DATA CATALOG(CATALOG.DS.NAME)

This example assumes the VTOC entry does not exist, so make sure. The easiest way to check is to do a 3.4 on the volume. If it shows up there, your dataset isn't deleted.
MrH
 

Re: IDC3009I ** VSAM CATALOG RETURN CODE IS 86 - REASON CODE

Postby Robert Sample » Wed Apr 20, 2011 7:40 pm

It is not clear from what you have posted what the problem is. If the DATA component exists without a catalog entry, you need to use IDCAMS command
DELETE ACSVS.ETFR.V122.CSI.DATA NVR FILE(DD)
where DD is a DD name pointing to the volume serial. You can do the same with the INDEX component if it exists without a catalog entry. If the catalog entry exists without the data sets being on the volume serial, you'll need to delete the catalog entry (see NOSCRATCH in the IDCAMS manual DELETE command).
Robert Sample
Global moderator
 
Posts: 3542
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 253 times

Re: IDC3009I ** VSAM CATALOG RETURN CODE IS 86 - REASON CODE

Postby Bad Man » Mon May 02, 2011 7:10 pm

Yes the dataset was their wothout a volume

My colleague did DEl NOSCR with the catalog and it worked....

Thanks
Bad Man
 
Posts: 96
Joined: Sun Apr 04, 2010 2:20 pm
Has thanked: 0 time
Been thanked: 0 time

Re: IDC3009I ** VSAM CATALOG RETURN CODE IS 86 - REASON CODE

Postby prino » Mon May 02, 2011 8:38 pm

Robert Sample wrote:It is not clear from what you have posted what the problem is. If the DATA component exists without a catalog entry, you need to use IDCAMS command
DELETE ACSVS.ETFR.V122.CSI.DATA NVR FILE(DD)
where DD is a DD name pointing to the volume serial. You can do the same with the INDEX component if it exists without a catalog entry. If the catalog entry exists without the data sets being on the volume serial, you'll need to delete the catalog entry (see NOSCRATCH in the IDCAMS manual DELETE command).

Just when I needed something like this, you come along! :mrgreen: :mrgreen:

Any hints as how I would find all datasets on every volume that only exist as a VTOC entry?
Robert AH Prins
robert.ah.prins @ the.17+Gb.Google thingy
User avatar
prino
 
Posts: 564
Joined: Wed Mar 11, 2009 12:22 am
Location: Vilnius, Lithuania
Has thanked: 3 times
Been thanked: 24 times

Re: IDC3009I ** VSAM CATALOG RETURN CODE IS 86 - REASON CODE

Postby Robert Sample » Mon May 02, 2011 11:53 pm

Glad to hear the time was right!

We usually run across uncataloged datasets by accident. The DCOLLECT D type record has a bit flag in information byte #2 (offset 70) at the third bit in (..1. ....) iwhich ndicates whether or not the data set is cataloged in an ICF catalog.
Robert Sample
Global moderator
 
Posts: 3542
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 253 times

Re: IDC3009I ** VSAM CATALOG RETURN CODE IS 86 - REASON CODE

Postby prino » Tue May 03, 2011 12:21 am

Robert Sample wrote:Glad to hear the time was right!

We usually run across uncataloged datasets by accident. The DCOLLECT D type record has a bit flag in information byte #2 (offset 70) at the third bit in (..1. ....) iwhich ndicates whether or not the data set is cataloged in an ICF catalog.

I have slightly elevated RACF privileges on a z/OS system, and occasionally come across them. The method of getting rid of VTOC remnants of VSAM files works like a charm, but I've also got datasets in the VTOC that are resistant to the
DELETE MY.DATA.SET NVR FILE(DD)
method - I get a message that the delete is successful, but when I go back to the volume in ISPF option 3.4, the data set is still there.

Any clues?
Robert AH Prins
robert.ah.prins @ the.17+Gb.Google thingy
User avatar
prino
 
Posts: 564
Joined: Wed Mar 11, 2009 12:22 am
Location: Vilnius, Lithuania
Has thanked: 3 times
Been thanked: 24 times

Re: IDC3009I ** VSAM CATALOG RETURN CODE IS 86 - REASON CODE

Postby expat » Sat May 14, 2011 1:45 pm

I suppose that the final method would be to ZAP the VTOC. A long long time since I've done that.

Think that the program name may have changed since the dark ages when I last run one, but maybe a google on AMASPZAP might help you out here for deleting the FORMAT1 DSCB entry.
expat
 
Posts: 433
Joined: Sat Jun 09, 2007 3:21 pm
Has thanked: 0 time
Been thanked: 5 times


Return to VSAM/SMS

 


  • Related topics
    Replies
    Views
    Last post