1. Set the database -omsize
startup parameter to the number of database objects (tables, indexes, lobs) defined in the _storageobject
For example, use the following SQL command to determine the current number of database objects:
select count(*) from PUB_”storageobject”
2. Revise the application code that queries _lock
to use the temp-table method
as opposed to calling the _lock
table directly. Refer to the code example in Article 000033245, How to monitor locks using VST?
3. Instead of querying the _lock
VST, use a more efficient VST table _Userlock
. It's result set is much smaller because it limits the number of locks per user instead of having to scan the entire lock table. For further information refer to Article 000021994, What is the Record locking table _UserLock
4. Consider client-server connections by making use of the -H <hostname> -S <servicename or portnumber> as opposed to self-service.