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

select *
from syssqlstat
where sqs_statement where matches '*<tabname>*';

this would give you session id, dbname, sql statement being run and some more info.

Hope it helps.

Nitin

Thanks Nitin

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.

Hi,

I am not aware about locking modes of databases.

What exactly you want to do with this info?

Nitin

Hi Nitin,

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.

regards,

Nitin