select tabname from systables
where hex(partnum) matches upper("*c000000017b4d460*")
And you don't have to put separate locks on the table.
Locks you are seeing are intent locks. Intent locks are special kinds of locks and are handled by database server. You can't control them. If you update for example one row, the database server puts exclusive lock on this row or page(depends on table locking ) and also puts intent exclusive lock on the whole table to ensure that no other sessions can put locks on this table.
When you end your transaction or close session, these locks should disappear.
This TBLSpace appear be Temporary tables .
Are ddj_temp_dbs* in DBSPACETEMP config?
This temp tables are created by user (CREATE TEMP TABLE) or automatically created in SQL with HASHs, SORTs, etc.
The easy way to identify is looking the first char on your tblspace/partnum :
a00001 = DBspace "0xA" = 10 = onstat -d : column dbspaces / number = 10
7800001 = DBspace "0x78" = 120 = onstat -d : number = 120
Tables like "task_notification" is part of sysadmin dbspace , don't worry about theys locks. The sysadmin Database