Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2006
    Posts
    1

    Unanswered: Sybase's sysprocesses and sysdatabases equivalent in db2

    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

  2. #2
    Join Date
    Apr 2004
    Posts
    54

  3. #3
    Join Date
    Apr 2004
    Posts
    54
    There is no equivalent of Sybase's sysdatabases in DB2 for LUW.
    The best approach is using SCHEMA instead of the one.(IMHO)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •