Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2008
    Posts
    131

    Question Unanswered: list application data

    Hi,
    when we do 'list applications', where the output data comes from. I mean, is there any table where the current applications info is stored and the command 'list applications' fetches the data from that particular table???

    also for 'list active databases'.

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Technically, there is no table that has that information, but DB2 V9.5 has some administrative views that will supply the information. Check out this view:

    SYSIBMADM.APPLICATIONS

    If you don't have version 9.5 you can use the following table function:

    SNAP_GET_APPL_INFO

    Go to the DB2 Info Center for your release and search on one of the above options to get more information on how they work.

    If you have V9.5 the above view is preferred and I think the table functions will eventually be phased out.

    I doin't think there is one for "list active databases" because the above view or function assumes you are connected to a database already (but not 100% certain about that).
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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