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
 

 

Records delete from VSAM file

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
riteshsingh92

New User


Joined: 10 Nov 2009
Posts: 17
Location: India

PostPosted: Wed Nov 18, 2009 10:32 pm    Post subject: Records delete from VSAM file
Reply with quote

I am trying to delete records from VSAM file RLUTV.TST.RLAUDLOG to avoid overflow of the VSAM file, but I am not able to delete the records its giving message "COMMAND NOT SUPPORTED" as below. I have tried to delete records from other VSAM files and was able to delete.

Please suggest me why I am not able to delete the records.
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10274
Location: italy

PostPosted: Wed Nov 18, 2009 10:43 pm    Post subject: Reply to: Records delete from VSAM file
Reply with quote

Quote:
Please suggest me why I am not able to delete the records.

because the software You are using does not let You!


if You want useful answers, please post useful info!
PS. but it could also be the dataset organization
Back to top
View user's profile Send private message
riteshsingh92

New User


Joined: 10 Nov 2009
Posts: 17
Location: India

PostPosted: Wed Nov 18, 2009 11:36 pm    Post subject:
Reply with quote

But I am able to delete the records from other VSAM file why this only is getting error message what software you are talking about...

Thanks
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8117
Location: East Dubuque, Illinois, USA

PostPosted: Wed Nov 18, 2009 11:45 pm    Post subject:
Reply with quote

Are you using File Aid or some other software package to delete the records from the VSAM file? If not, how, exactly, are you accessing the VSAM file to delete records from it? Could the file be allocated to a CICS region or other resource that prevents updates such as deletes?

If you can delete records from other VSAM files, there is a difference between those files and the one you are now attempting to delete records from. You need to find the difference to determine the source of the issue. And be aware that knowing the source of the issue does not always provide a resolution -- if there is a conflict because a CICS region is updating the file, you may have to wait until the region comes down to do your deletes or not do manual deletes at all.

Quote:
avoid overflow of the VSAM file
What does this mean? VSAM files, as long as they are defined with primary and secondary space, will do CI and CA splits up to 123 extents (or until the pack runs out of free space).
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10274
Location: italy

PostPosted: Wed Nov 18, 2009 11:47 pm    Post subject: Reply to: Records delete from VSAM file
Reply with quote

looks like You are not at all interested in getting help, but only in whining icon_evil.gif
again You did not post anything useful !

let' s translate to an easier terminolgy...
what program are You using to try to delete the record
what is the type of the vsam where the delete is succesfull
what is the type of the vsam where the delete fails
tyope ==> KSDS,ESDS,RRDS,LINEAR ....

post the message You get not a description of it
Back to top
View user's profile Send private message
Ronald Burr

Active User


Joined: 22 Oct 2009
Posts: 293
Location: U.S.A.

PostPosted: Wed Nov 18, 2009 11:48 pm    Post subject:
Reply with quote

Perhaps the better question is "What software are YOU talking about?"
Namely, what program/product/utility are you using to (try to) delete VSAM records?
What command(s) ( show explicitly ) are you issuing in an attempt to effect deletion of the records?
There are MANY programs/products/utilities that can be used to manipulate VSAM files, and the answer "may" depend on which product you are using, and what command(s) you are trying to use.
Back to top
View user's profile Send private message
riteshsingh92

New User


Joined: 10 Nov 2009
Posts: 17
Location: India

PostPosted: Thu Nov 19, 2009 12:00 am    Post subject:
Reply with quote

I am using Fileaid Tool to delete the records its an KSDS file after disabling and closing the file on online region as file is being used in online transaction.

Thanks
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10274
Location: italy

PostPosted: Thu Nov 19, 2009 12:05 am    Post subject: Reply to: Records delete from VSAM file
Reply with quote

the thread is getting quite boring
when somebody asks for help he should post what people ask,
not what he thinks...

post the error message You get
Back to top
View user's profile Send private message
riteshsingh92

New User


Joined: 10 Nov 2009
Posts: 17
Location: India

PostPosted: Thu Nov 19, 2009 12:10 am    Post subject:
Reply with quote

COMMAND NOT SUPPORTED
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10274
Location: italy

PostPosted: Thu Nov 19, 2009 12:11 am    Post subject: Reply to: Records delete from VSAM file
Reply with quote

explanation/problem determination ...
the software/program You are using does not support the command You are trying to use/issue

problem resolution ...
use/issue a valid/supported command

nuff said, nothing more we can do
Back to top
View user's profile Send private message
riteshsingh92

New User


Joined: 10 Nov 2009
Posts: 17
Location: India

PostPosted: Thu Nov 19, 2009 12:15 am    Post subject:
Reply with quote

Thank you very much for your support.
Back to top
View user's profile Send private message
Terry Heinze

JCL Moderator


Joined: 14 Jul 2008
Posts: 1249
Location: Richfield, MN, USA

PostPosted: Thu Nov 19, 2009 11:13 am    Post subject:
Reply with quote

You're welcome. icon_smile.gif
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
This topic is locked: you cannot edit posts or make replies. Fetching data from BAI File arunsoods JCL & VSAM 1 Wed Jul 19, 2017 4:28 pm
No new posts Write out NODUPS but just from one file Jay Villaverde DFSORT/ICETOOL 8 Fri Jul 14, 2017 12:44 am
No new posts How to add header with Date(YYMMDD) i... Rajan Moorthy DFSORT/ICETOOL 2 Thu Jul 06, 2017 11:44 pm
No new posts How to generate a new unique Input fi... for1ranjith CLIST & REXX 11 Sat Jul 01, 2017 12:09 pm
No new posts Writing a file using online program grvtomar PL/I & Assembler 3 Fri Jun 30, 2017 1:06 pm


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