View previous topic :: View next topic
|
Author |
Message |
rosmi joseph
New User
Joined: 17 Sep 2007 Posts: 68 Location: Kochi
|
|
|
|
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 |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
Hi,
Please post the complete diagnostic information from the abended JOB. |
|
Back to top |
|
|
rosmi joseph
New User
Joined: 17 Sep 2007 Posts: 68 Location: Kochi
|
|
|
|
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 |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
|
Sandy Zimmer
Active Member
Joined: 13 Jun 2007 Posts: 826 Location: Wilmington, DE
|
|
|
|
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 |
|
|
prakash.subramaniam
New User
Joined: 22 Nov 2006 Posts: 7 Location: chennai
|
|
|
|
Hi,
The way in procedure division call function statement just give the delete function.
Thanks and regards,
Prakash subramaniam |
|
Back to top |
|
|
Sandy Zimmer
Active Member
Joined: 13 Jun 2007 Posts: 826 Location: Wilmington, DE
|
|
|
|
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 |
|
|
|