[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference orarep::nomahs::rdb_60

Title:	Oracle Rdb - Still a strategic database for DEC on Alpha AXP!
Notice:	RDB_60 is archived, please use RDB_70..
Moderator:	NOVA::SMITHISON

Created:	Fri Mar 18 1994
Last Modified:	Fri May 30 1997
Last Successful Update:	Fri Jun 06 1997
Number of topics:	5118
Total number of notes:	28246

5090.0. "Enqlm exceeded when creating index" by ORAREP::XSTACY::PBUCKLEY () Mon Mar 03 1997 04:31

    I'm getting the following error when creating an index on 
    a table
    
-RDB-E-NO_META_UPDATE, metadata update failed
-RDMS-F-EXQUOTA, exceeded quota
-COSI-F-EXENQLM, exceeded enqueue quota
    
    The sysgen paramater PQL_MENQLM is 60000 on the node where the database
    resides, so my process has an enqlm of 60000. The cardinality of the
    table is approx. 2 million rows. I've tried disabling the snapshots
    and reserving the table for exclusive access but to no avail. I'd
    appreciate any suggestions.
    
    Regards,
    Patrick.

T.R	Title	User	Personal Name	Date	Lines
5090.1		ORAREP::HERON::GODFRIND	Oracle Rdb Engineering	`Mon Mar 03 1997 06:32`	9
	Could it be that the area containing the table and/or the index uses page locking ? Other than that, EXCLUSIVE access should reduce the number of locks required. Are you sure it also fails in that case ? How many buffers does the process use ? /albert
5090.2		M5::LWILCOX	Chocolate in January!!	`Mon Mar 03 1997 08:39`	2
	Batch update might be another thing to try. Just make sure you have done an RMU/BACKUP first.
5090.4		ORAREP::XSTACY::PBUCKLEY		`Mon Mar 03 1997 16:01`	5
	Batch Update did the trick. Cheers, Patrick.