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
 

 

IMS ENQ/DEQ > PIMAX causing U0775 with CHKP freq = 2 - He

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

New User


Joined: 23 Aug 2012
Posts: 2
Location: India

PostPosted: Thu Aug 23, 2012 8:50 pm    Post subject: IMS ENQ/DEQ > PIMAX causing U0775 with CHKP freq = 2 - He
Reply with quote

Hi,

We recently converted a DLI batch program to BMP. The job started abending with U0775. After initial research, we found that PIMAX was being exceeded. We started off with a checkpoint once every 2000 records and finally settled at 2. But, the U0775 continued.

Later, by looking at DFSTAT, we realized that the child to parent ration of the IMS database (which is the driver for pgm) is around 1500. All these child segments were being enqueued due to a PROCOPT of A. This huge enqueue of childs + root data is probably crossing the PIMAX.

IMS Locking is Program Isolation. Please suggest if there is a way to avoid the huge/enqueue while still having PROCOPT=A. PROCOPT=A was needed since DLETs are required on the database.
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10274
Location: italy

PostPosted: Thu Aug 23, 2012 8:54 pm    Post subject: Reply to: IMS ENQ/DEQ > PIMAX causing U0775 with CHKP fre
Reply with quote

ENQ is there to protect Your data...

speak to Your support to raise the limits of the ENQ buffer pool and friends
Back to top
View user's profile Send private message
saikiran A

New User


Joined: 23 Aug 2012
Posts: 2
Location: India

PostPosted: Thu Aug 23, 2012 9:02 pm    Post subject:
Reply with quote

Thanks Enrico,

DBA are already in the process of increasing PIMAX.

I am just curious if PROCOPT or something else can be adjusted to achieve the DELETEs without ENQ of the whole IMS record. something similar to ENQ of root alone.

One other detail is that the job can have exclusive access of the database. No other job or online user is expected to access the database while the job runs.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10274
Location: italy

PostPosted: Thu Aug 23, 2012 9:14 pm    Post subject: Reply to: IMS ENQ/DEQ > PIMAX causing U0775 with CHKP fre
Reply with quote

Quote:
No other job or online user is expected to access the database while the job runs.


that' the usual horse manure ( that You were told )
be sure that sooner or later the same person will tell that You did not understand the requirement to it' s full extent icon_wink.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 -> 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 Is the explanation correct? XRST,CHKP Martylin IMS DB/DC 1 Wed Mar 15, 2017 9:26 am
No new posts VSAM Initializing causing Repro to ru... bpavan2k4 JCL & VSAM 4 Fri Nov 29, 2013 6:27 pm
No new posts SQL query causing timeout prasun dhara DB2 2 Wed Mar 21, 2012 5:52 pm
No new posts U0775 Abend.... dick scherrer IMS DB/DC 7 Thu Sep 01, 2011 6:08 pm
No new posts FTP: MODE S causing corrupt data. vasanthz IBM Tools 2 Tue Apr 20, 2010 6:12 pm


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