Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2014
    Posts
    294

    Unanswered: LIST DB DIRECTORY Query

    Hi,

    LIST DB DIRECTORY. Is there any query on db2 which will give the output of this command LIST DB DIRECTORY.I want to watch all my databases on a tabular format. manually can be done. Is there any other way just to list the databases on a tabular output.


    thanks in advance

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    No. How would one database know about any others?

    Andy

  3. #3
    Join Date
    Feb 2008
    Location
    Japan
    Posts
    3,483
    I got the following output from LIST DB DIRECTRY command on CLP.

    Code:
    (c) Copyright IBM Corporation 1993,2007
    Command Line Processor for DB2 Client 9.7.5
    
    You can issue database manager commands and SQL statements from the command
    prompt. For example:
        db2 => connect to sample
        db2 => bind sample.bnd
    
    For general help, type: ?.
    For command help, type: ? command, where command can be
    the first few keywords of a database manager command. For example:
     ? CATALOG DATABASE for help on the CATALOG DATABASE command
     ? CATALOG          for help on all of the CATALOG commands.
    
    To exit db2 interactive mode, type QUIT at the command prompt. Outside
    interactive mode, all commands must be prefixed with 'db2'.
    To list the current command option settings, type LIST COMMAND OPTIONS.
    
    For more detailed help, refer to the Online Reference Manual.
    
    db2 => LIST DB DIRECTORY
    
     System Database Directory
    
     Number of entries in the directory = 4
    
    Database 1 entry:
    
     Database alias                       = PROFILE
     Database name                        = PROFILE
     Local database directory             = D:
     Database release level               = d.00
     Comment                              =
     Directory entry type                 = Indirect
     Catalog database partition number    = 0
     Alternate server hostname            =
     Alternate server port number         =
    
    Database 2 entry:
    
     Database alias                       = GERMANY
     Database name                        = GERMANY
     Local database directory             = D:
     Database release level               = d.00
     Comment                              =
     Directory entry type                 = Indirect
     Catalog database partition number    = 0
     Alternate server hostname            =
     Alternate server port number         =
    
    Database 3 entry:
    
     Database alias                       = COMPCORR
     Database name                        = COMPCORR
     Local database directory             = D:
     Database release level               = d.00
     Comment                              =
     Directory entry type                 = Indirect
     Catalog database partition number    = 0
     Alternate server hostname            =
     Alternate server port number         =
    
    Database 4 entry:
    
     Database alias                       = SAMPLE
     Database name                        = SAMPLE
     Local database directory             = D:
     Database release level               = d.00
     Comment                              =
     Directory entry type                 = Indirect
     Catalog database partition number    = 0
     Alternate server hostname            =
     Alternate server port number         =
    
    db2 =>
    What format did you expected?
    What did you mean by "tabular format"?

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    what he means is an administrative view like sysibmadm.dbcfg to get back a table to have the possibility to filter rows/columns
    Of my knowledge there is no view for this command
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  5. #5
    Join Date
    Jul 2014
    Posts
    294
    Yes.
    what @przytula_guy said is the thing which I am looking for. Thanks for the replies. I ll do this manually.

Tags for this Thread

Posting Permissions

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