Results 1 to 7 of 7
  1. #1
    Join Date
    Jan 2008
    Posts
    13

    Cool Unanswered: list db directory

    Hello, I am using db2 v9.7.2 on windows server 2003

    is there a way to get list db directory info remotely?

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    There are no DB2 commands that can do this.

    Andy

  3. #3
    Join Date
    Jan 2008
    Posts
    13

    Cool

    yes I am aware that there are no commands for it, but there must some system views or tables that keep this information

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Well there is a file, but it is not human readable.

    Andy

  5. #5
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    There is an API you can use once you (or your application) are attached to the DB2 instance. I'm not sure if a table function/view exists, that wraps the API call. If it isn't there, you can implement it yourself.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  6. #6
    Join Date
    Apr 2013
    Posts
    13
    May i know what is the API used in order to get the database name from c# web application?
    Thanks

  7. #7
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    ---
    "It does not work" is not a valid problem statement.

Posting Permissions

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