Hi,

One of the stored procedures in my application(on sybase and now being migrated to UDB DB2) uses the Sybase system tables sysprocesses and sysdatabases to find out the number of connections to a particular database at a given time. The problem with mapping this particular functionality to DB2 is that no specific connections are made to the schemas. Secondly, we do not have any DB2 equivalents for the above tables or tables which give the same information as far as we could find. I need to know the nymber of users connected to schema (or using the schema) and not to the database. Do we have anything equivalent in DB2

thanks,
Amit

http://publib.boulder.ibm.com/infoce...n/r0007089.htm

There is no equivalent of Sybase's sysdatabases in DB2 for LUW.
The best approach is using SCHEMA instead of the one.(IMHO)