information on databases

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • brion m
    New Member
    • Feb 2008
    • 3
    #1

    information on databases

    Hi,
    i am new to Udb db2. I have to collate information about databases on various servers e.g database size, last used, directory location. Is there a tool that can access information on all databases in a DB2 instance .

    thanks for any help

    p.s currently use V8.2
    Tags: None
    • sakumar9
      Recognized Expert New Member
      • Jan 2008
      • 127
      #2
      You can use snapshots to get this information.

      Check this link:
      http://publib.boulder. ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.db2.luw .admin.cmd.doc/doc/r0001945.html

      Regards
      -- Sanjay

        Comment

        • sakumar9
          Recognized Expert New Member
          • Jan 2008
          • 127
          #3
          You can also use SNAP_GET_DB table function.

          You can find more information at:
          http://publib.boulder. ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.db2.luw .sql.rtn.doc/doc/r0012558.html

          Regards
          -- Sanjay

            Comment

            Previous template Next
            Working...