MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

How to delete uncatalog sms vsam in batch

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Data Management
View previous topic :: View next topic  
Author Message
Eaglenut
Beginner


Joined: 16 Dec 2004
Posts: 5
Topics: 1

PostPosted: Thu Dec 16, 2004 12:00 pm    Post subject: How to delete uncatalog sms vsam in batch Reply with quote

We sometimes encounter issues on our mvs system where we get uncataloged SMS vsam files. In the past, I delete these via ISMF.
Is there a way to delete these in a batch job?

Thanks,
D.
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12369
Topics: 75
Location: San Jose

PostPosted: Thu Dec 16, 2004 12:21 pm    Post subject: Reply with quote

Eaglenut,

You can delete the uncataloged dataset using 3.4 in ISPF but make sure that you supply the volume serial.

You can also use IEFBR14 with DISP=(MOD,DELETE) and the VOL=SER= coded.

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Eaglenut
Beginner


Joined: 16 Dec 2004
Posts: 5
Topics: 1

PostPosted: Thu Dec 16, 2004 12:32 pm    Post subject: Reply with quote

Yea, I tried that, and it didn't work.. I also tried using ADRDSSU with catlg eq no,
and had no luck. I was hoping there was some ISMF batch processing, other than naviquest, to delete the datasets. (I couldn't get IDCAMS to work either)
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12369
Topics: 75
Location: San Jose

PostPosted: Thu Dec 16, 2004 1:10 pm    Post subject: Reply with quote

Eaglenut,

Can you post the error messages ?

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Eaglenut
Beginner


Joined: 16 Dec 2004
Posts: 5
Topics: 1

PostPosted: Thu Dec 16, 2004 1:53 pm    Post subject: Reply with quote

These are the errors from IDCAMS and ADRDSSU. For the IDCAMS, I tried to delete one SMS uncataloged dataset from vol=ser=VOL001

For ADRDSSU, I tried to delete all uncataloged SMS datasets from vol=ser=VOL001

Just as an FYI, I was told by some senior sys pgmrs that they didn't think there was a way to delete uncataloged SMS vsam datasets in batch, only using the ISMF panels. That's why I thought I'd see if anyone else had some ideas.

IDCAMS Error:
DELETE (VSAM.DSN) PURGE SCRATCH -
FILE(DEL01)
DC3012I ENTRY VSAM.DSN NOT FOUND
DC3009I ** VSAM CATALOG RETURN CODE IS 8 - REASON CODE IS IGG0CLEG-42
DC0551I ** ENTRY VSAM.DSN NOT DELETED
DC0001I FUNCTION COMPLETED, HIGHEST CONDITION CODE WAS 8
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
ADRDSSU Error:
//SYSIN DD *
DUMP DATASET(INCLUDE(**) -
BY((CATLG,EQ,NO))) -
INDDNAME(VOL001) -
OUTDDNAME(OUT1)-
DELETE PURGE

ADR101I (R/I)-RI01 (01), TASKID 001 HAS BEEN ASSIGNED TO COMMAND 'DUMP '
ADR109I (R/I)-RI01 (01), 2004.351 13:33:15 INITIAL SCAN OF USER CONTROL STATEMENTS COMPLETED.
ADR016I (001)-PRIME(01), RACF LOGGING OPTION IN EFFECT FOR THIS TASK
ADR006I (001)-STEND(01), 2004.351 13:33:15 EXECUTION BEGINS
ADR730W (001)-FDSDU(01), CLUSTER VSAM.DSN.TWO IS OPEN
ADR972E (001)-FDSDU(01), CLUSTER VSAM.DSN.THREE ON VOLUME VOL001 IS NOT SUPPORTED BY PHYSICAL DATASET DUMP
ADR972E (001)-FDSDU(01), CLUSTER VSAM.DSN.FOUR ON VOLUME VOL001 IS NOT SUPPORTED BY PHYSICAL DATASET DUMP
ADR402E (001)-AUTH (04), AUTHORIZATION CHECK FAILED FOR DATA SET VSAM.DSN.FIVE, ON VOLUME VOL001, 14-008-042, IN
CATALOG CAT.XXX
ADR402E (001)-AUTH (04), AUTHORIZATION CHECK FAILED FOR DATA SET VSAM.DSN.SIX, ON VOLUME VOL001, 14-008-042, IN
CATALOG CAT.XXX
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12369
Topics: 75
Location: San Jose

PostPosted: Thu Dec 16, 2004 2:29 pm    Post subject: Reply with quote

eaglenut,

Try this job.


Code:
 
//STEP0100 EXEC PGM=ADRDSSU
//SYSPRINT DD SYSOUT=*
//DASD1    DD VOL=SER=xxxxxx,UNIT=SYSDA,DISP=SHR
//TAPE     DD DUMMY
//SYSIN    DD *
  DUMP DATASET(INCLUDE(**) -
  BY((DSORG EQ VSAM) -
  (CATLG EQ NO))) -
  LOGINDDNAME(DASD1) -
  OUTDDNAME(TAPE) -
  DELETE PURGE
/*


Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Eaglenut
Beginner


Joined: 16 Dec 2004
Posts: 5
Topics: 1

PostPosted: Thu Dec 16, 2004 3:33 pm    Post subject: Reply with quote

No go.. got this error this time.

DUMP DATASET(INCLUDE(**) -
BY((DSORG EQ VSAM) -
(CATLG EQ NO))) -
LOGINDDNAME(DASD1) -
OUTDDNAME(TAPE) -
DELETE PURGE
ADR101I (R/I)-RI01 (01), TASKID 001 HAS BEEN ASSIGNED TO COMMAND 'DUMP '
ADR109I (R/I)-RI01 (01), 2004.351 15:25:35 INITIAL SCAN OF USER CONTROL STATEMENTS COMPLETED.
ADR016I (001)-PRIME(01), RACF LOGGING OPTION IN EFFECT FOR THIS TASK
ADR006I (001)-STEND(01), 2004.351 15:25:35 EXECUTION BEGINS
ADR732E (001)-FDSCO(01), DATA SET VSAM.FILE.ONE WAS NOT SELECTED BECAUSE IT WAS NOT CATALOGED
Back to top
View user's profile Send private message
nevilh
Beginner


Joined: 11 Aug 2004
Posts: 115
Topics: 0

PostPosted: Fri Dec 17, 2004 4:36 am    Post subject: Reply with quote

Have you tried using an IDCAMS job to define recatalog the cluster and the delete it?
Depending on how the uncatalog was done, this may work
Back to top
View user's profile Send private message
nevilh
Beginner


Joined: 11 Aug 2004
Posts: 115
Topics: 0

PostPosted: Fri Dec 17, 2004 4:37 am    Post subject: Reply with quote

Soory the previos post shoul dhave read.
Have you tried using an IDCAMS job to define recatalog the cluster and then trying to delete it?
Depending on how the uncatalog was done, this may work
Back to top
View user's profile Send private message
nevilh
Beginner


Joined: 11 Aug 2004
Posts: 115
Topics: 0

PostPosted: Fri Dec 17, 2004 4:39 am    Post subject: Reply with quote

Its Friday and I am having problems co-ordinating my fingers sorry for the typing errors in the above posts
Back to top
View user's profile Send private message
Eaglenut
Beginner


Joined: 16 Dec 2004
Posts: 5
Topics: 1

PostPosted: Fri Dec 17, 2004 10:22 am    Post subject: Reply with quote

I've figured out a workaround.. I'll run and FDR report on uncat datasets, and
write the output to a DSN. Then I'll write something to read the o/p to create
IDCAMS delete cards. (I figured out the IDCAMS delete..
DELETE VSAM.FILE.ONE FILE(DEL01) VVR
Thanks for the help and ideas though!
Back to top
View user's profile Send private message
bablack
Beginner


Joined: 04 Dec 2002
Posts: 71
Topics: 0
Location: Little Falls, NJ

PostPosted: Mon Feb 07, 2005 4:54 pm    Post subject: Reply with quote

Eaglenut wrote:
I've figured out a workaround.. I'll run and FDR report on uncat datasets, and
write the output to a DSN. Then I'll write something to read the o/p to create
IDCAMS delete cards. (I figured out the IDCAMS delete..
DELETE VSAM.FILE.ONE FILE(DEL01) VVR
Thanks for the help and ideas though!


I presume you are using FDREPORT. FDREPORT can generate the IDCAMS statements for you. See section 54.45 PUNCH EXAMPLES in the FDR manual. One of them is for generating IDCAMS DELETEs. With minor modifications it can do exactly what you need.
_________________
Bruce A. Black
Senior Software Developer
Innovation Data Processing
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Data Management All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group