var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: which users connected to a table
Is there anyway we can know which users are connected to a table in a database......
You can do that by running a query against sysmaster db
where sqs_statement where matches '*<tabname>*';
this would give you session id, dbname, sql statement being run and some more info.
Hope it helps.
is there any command that helps us in knowing the database lock mode apart from extracting dbschema.I wanna see at lock mode at database level not at table levels.please correct me if my question is wrong
What exactly you want means with this?
There no exists database lock mode.
If you want the default lock mode , this is not define on the database , is defined over the all instance in the ONCONFIG file with parameter DEF_TABLE_LOCKMODE.
by default the lock mode is PAGE lock.
Another parameter is the IFX_DEF_TABLE_LOCKMODE enviroment variable. This override the DEF_TABLE_LOCKMODE parameter on the ONCONFIG , but is valid only to the session where the variable is set.
to get the lock mode of each table , you can use the dbschema with -ss parameter.
I am not aware about locking modes of databases.
What exactly you want to do with this info?
my point is instead of extracting the schema and checking for the locking level set to all the tables in the schema do we hav any shortcut.......
Use below query
select tabname , locklevel from systables where tabid > 99
This will provide you the table locking level info.