HPE Community read-only access December 15, 2018
This is a maintenance upgrade. You will be able to read articles and posts, but not post or reply.
Hours:
Dec 15, 4:00 am to 10:00 am UTC
Dec 14, 10:00 pm CST to Dec 15, 4:00 am CST
Dec 14, 8:00 pm PST to Dec 15, 2:00 am PST
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle

 
Mulder_1
Frequent Advisor

Oracle

How do I determine which quota is exceeded ?

Oracle Rdb V7.2-350 Event Notification for Database
$1$DGA575:[PRL.PQL]JKHG.RDB;1
Process 206000D8 generating bugcheck dump file
PLTRDV1:[RDBBUGCHK]RDSBUGCHK.DMP;
Exception at 0000000000D3809C : RDMSHRP72\BLI$CALLG + 000000BC

%COSI-F-UNEXPERR, unexpected system error
-COSI-F-EXQUOTA, exceeded quota

Thanks
4 REPLIES
Richard J Maher
Trusted Contributor

Re: Oracle

Reproducable at will? If so can you put one of those DCL process quota watchers on and see which one's growing/shrinking?

Do you have the source code? Program change? Rdb version (optimizer strategy) change? New program? Read-Only txn or Raed-Write? Selecting or Updating?

What do you have ENQLM and PQFLQUOTA set to?

If you go to www.jcc.com you can search the archives (or Rdb meta-link) for a link to Peter Jackson's bugcheck summarizer which can be useful if you have no luck tracking down the problem yourself and have to contact Oracle. May also be a more useful error "%" in the DMP file.

Cheers Richard Maher
Oswald Knoppers_1
Valued Contributor

Re: Oracle

Process 206000D8 generating bugcheck dump file
PLTRDV1:[RDBBUGCHK]RDSBUGCHK.DMP;

You can edit this file, there should be info in there.

Oswald
Andy Bustamante
Honored Contributor

Re: Oracle

If you can recreate the error, bring up Availability Manager and monitor the process. http://h71000.www7.hp.com/openvms/products/availman/index.html?jumpid=/products/openvms/availabilitymanager

If you don't have time to do it right, when will you have time to do it over? Reach me at first_name + "." + last_name at sysmanager net
Guy Peleg
Respected Contributor

Re: Oracle

Assuming a recent OpenVMS version
you can use SDA to analyze the process
dump and look at the JIB to determine which
quota been exceeded.

$ analyze/crash process_dump.dmp

SDA> read sysdef
SDA> format JIB

Guy Peleg
Maklee Engineering
www.maklee.com