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.
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.