IBM DB2

 to know the database back up is running use the below commands 

SELECT UTILITY_ID, UTILITY_TYPE, UTILITY_STATE, *   FROM TABLE(SNAP_GET_UTIL(-1)) AS T

select  PROGRESS_COMPLETED_UNITS, PROGRESS_TOTAL_UNITS  FROM TABLE(SNAP_GET_UTIL_PROGRESS(-1)) AS T 

******************************************************************

--To know the connections made by a user 

SELECT SUBSTRING(APPLICATION_ID,0,12) AS SERVER_IP, COUNT(1) AS CONNECTION_COUNT FROM SYSIBMADM.MON_CONNECTION_SUMMARY

WHERE SESSION_AUTH_ID='APPUSER' AND APPLICATION_NAME='db2jcc_application'

GROUP BY SUBSTRING(APPLICATION_ID,0,12);

--To know locks 

SELECT APPLICATION_HANDLE, substr(workload_occurrence_state,1,20) as connection_state, NUM_LOCKS_HELD,  CLIENT_PORT_NUMBER, substr(SESSION_AUTH_ID,1,10) as SESSION_AUTH_ID,

CURRENT_SERVER as DATABASE_NAME, substr(APPLICATION_NAME,1,20) as APPLICATION_NAME,substr(EXECUTION_ID,1,10) as EXECUTION_ID, substr(CLIENT_PROTOCOL,1,5) as CLIENT_PROTOCOL, 

substr(CLIENT_PLATFORM,1,8) as CLIENT_PLATFORM, substr(CLIENT_HOSTNAME,1,25) as CLIENT_HOSTNAME, uow_stop_time,

int((current timestamp - uow_stop_time)/60)  as Minits_in_waiting, substr(APPLICATION_ID,1,30) as APPLICATION_ID, 

 substr(CLIENT_IPADDR,1,20) as CLIENT_IPADDR

FROM TABLE(MON_GET_CONNECTION(cast(NULL as bigint), -2))

ORDER BY NUM_LOCKS_HELD desc, APPLICATION_HANDLE, CONNECTION_STATE;

--where APPLICATION_NAME ='toad.exe' 

SELECT * FROM SYSIBMADM.LOCKWAITS l ;

SELECT * FROM SYSIBMADM.APPLICATIONS a ;

SELECT * FROM SYSIBMADM.SNAPLOCK;

select * from SYSIBMADM.MON_LOCKWAITS;

select * from SYSIBMADM.APPLICATIONS;

select * from SYSIBMADM.MON_CONNECTION_SUMMARY

where session_auth_ID='APPUSER' and APPLICATION_NAME='db2jcc_application';

to know the index present on the column 

SELECT c.tabschema, c.tabname, i.iid AS index_id, i.indname, ck.colname
FROM syscat.tabconst c
INNER JOIN syscat.indexes i
 ON i.indname = c.constname -- unique index name matches constraint name
AND i.tabschema = c.tabschema AND i.tabname = c.tabname
INNER JOIN syscat.keycoluse ck
 ON ck.constname = c.constname 
AND ck.tabschema = c.tabschema and  c.tabname = ck.tabname AND 
WHERE c.type = 'U' -- constraint type: unique
AND (c.tabschema, c.tabname) = ('YOURSCHEMA', 'YOURTABLE') -- replace schema/table
ORDER BY i.iid, ck.colseq