Oracle

[Mulder_1]

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

[Richard J Maher]

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]

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

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

Oswald

[Andy Bustamante]

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

[Guy Peleg]

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