Locking of the DBC tables

Database
Enthusiast

Locking of the DBC tables

we have batch jobs running 24 hours. Through out the day there are fastload jobs using multiple users which include dropping and rebuilding the tables. Due to this there are locks on the dbc tables involved. we have the DBQL on. is there a query that can help in knowing the number of locks that occur in a particular timeperiod by user on the database.

2 REPLIES
Junior Contributor

Re: Locking of the DBC tables

There's no information about locks in DBQL, you need to enable Locking Logger for this.

If you want to check the current locks you might use the PMON API UDFs in syslib like MonitorSessions.

Dieter

Enthusiast

Re: Locking of the DBC tables

Thanks Dieter