SELECT substr(n.dbsname,1,15) type,
substr(dbinfo('DBSPACE', i.ti_partnum),1,15) dbspace,
FROM systabnames n, systabinfo i
WHERE (bitval(i.ti_flags, 32) = 1
OR bitval(i.ti_flags, 64) = 1
OR bitval(i.ti_flags, 128) = 1)
AND i.ti_partnum = n.partnum
into temp ggtmp with no log;
SELECT type[1,12], users, table, dbspace[1,12], kb
order by 1,2,3,4
It's not working correctly. This query retrieve my current sesion id.
I need sesion id for another users who create temporary tables.
I need list of sesion id for active users who have created temporary tables with special names.
One company with about 300 customers use old and new version client/server application. Administrators don't know who use old and who use new version.
They would like to block database connection for customers who use old software. Old software always create temporary table called "tmp_param".
I would like to write server process which control who and when temp table "tmp_param" was created. If this table exist the process disconnect application (connected by session id) from database server.