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
 

 

Getting U0775 abend when trying to delete segments in DB

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
View previous topic :: :: View next topic  
Author Message
rosmi joseph

New User


Joined: 17 Sep 2007
Posts: 68
Location: Kochi

PostPosted: Tue Dec 30, 2008 1:20 pm    Post subject: Getting U0775 abend when trying to delete segments in DB
Reply with quote

Hi,

I am trying to delete alll segments from from DB (IMS). I didnt not introduce any checkpoint call for the same. But the code is abending with U0775 abend indicating that there is no ENQ available.

Is it always necessary to have checkpoint calls in programs which do a delete. I have coded it only for test purpose.

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

Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Tue Dec 30, 2008 2:02 pm    Post subject:
Reply with quote

Hi,

Please post the complete diagnostic information from the abended JOB.
Back to top
View user's profile Send private message
rosmi joseph

New User


Joined: 17 Sep 2007
Posts: 68
Location: Kochi

PostPosted: Tue Dec 30, 2008 2:41 pm    Post subject:
Reply with quote

Explanation: This abend is issued when IMS cannot acquire any more
ENQ/DEQ blocks or the amount of storage that was specified by the PIMAX
parameter has been exhausted. It can be either a standard abend or a
pseudoabend.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Tue Dec 30, 2008 4:45 pm    Post subject:
Reply with quote

Hi,

May be I was not clear enough - please post the SYSOUT of abended JOB. This may be caused by user or can be a standard abend.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Dec 31, 2008 12:11 am    Post subject:
Reply with quote

Hello,

Quote:
Is it always necessary to have checkpoint calls in programs which do a delete. I have coded it only for test purpose.
No, it is not always necessary. . .
Quote:
This abend is issued when IMS cannot acquire any more
ENQ/DEQ blocks or the amount of storage that was specified by the PIMAX parameter has been exhausted


Your post answers your question - your job is trying to get more resources than it can. Either change the scope of the delete (do multiple runs of fewer) or issue periodic checkpoints.

If you really want to delete everyting, i suspect using a utility to load it "empty" will be less error prone and will run faster.

Keep n mind that if you choose to use checkpoints you will also need to incorporate restart logic (probably not what you want to put time into for this requirement).
Back to top
View user's profile Send private message
Sandy Zimmer

Active Member


Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE

PostPosted: Wed Dec 31, 2008 1:21 am    Post subject:
Reply with quote

A quick and easy way to do it is to do an image copy of the database for backup and then start empty. Why delete ALL segments anyway?
Back to top
View user's profile Send private message
prakash.subramaniam

New User


Joined: 22 Nov 2006
Posts: 7
Location: chennai

PostPosted: Fri Jan 16, 2009 4:51 pm    Post subject:
Reply with quote

Hi,
The way in procedure division call function statement just give the delete function.

Thanks and regards,
Prakash subramaniam
Back to top
View user's profile Send private message
Sandy Zimmer

Active Member


Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE

PostPosted: Fri Jan 16, 2009 6:06 pm    Post subject:
Reply with quote

Have your DBA make an image copy of the database. Then have your DBA do a delete/define/init. You will in effect have an NEW empty database.
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 -> IMS DB/DC All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts JCL to delete component in a package sundaram.naveen Compuware & Other Tools 14 Tue Nov 29, 2016 6:21 pm
No new posts IMS BMP program causes 878 system abend Artemk IMS DB/DC 7 Tue Nov 22, 2016 8:26 pm
No new posts How to delete second instance from Fl... Gunapala CN DFSORT/ICETOOL 6 Tue Oct 18, 2016 11:42 pm
No new posts abend sort based on count records in ... anatol DFSORT/ICETOOL 5 Mon Oct 17, 2016 10:10 pm
No new posts hot to get details when "EXEC CI... Andi1982 CICS 11 Tue Sep 20, 2016 5:01 pm


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