Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2003
    Posts
    21

    Unanswered: How list backup file in V8.1?

    Hi,

    How can I list the backup and log files using some system views in db2 v8.1 (something equivalent to SYSIBMADM.DB_HISTORY available in v9)?

    thanks.

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

  3. #3
    Join Date
    Jan 2003
    Posts
    21
    for sure.... but I must access the information via SQL (views or tables) not db2 cli

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    select * from table (admin_list_hist()) as x

    You can customize it as you need it. Here is the documentation:

    http://publib.boulder.ibm.com/infoce...n/r0012548.htm

    Andy

  5. #5
    Join Date
    Jan 2003
    Posts
    21
    Thanks Andy, that was exactly what I was searchiing for.

    (Sorry, for my newby question, but I'm new on db2 (coming from oracle world) and I 'm still searching for a good way to find the good ref guide ...does not seem to be as easy as Oracle... or I'm too colored by Oracle maybe )

Posting Permissions

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