Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2008
    Posts
    2

    Unhappy Unanswered: Journal GUI : Empty Database History

    Hi,

    I'm using DB2 v8.1.

    I uses to export the database history from journal tools as a report to my customer.
    Today I found the journal tools no longer display the history every time I try to display the history, I keep giving error below
    --------------------------------------------
    SQL1014W
    There are no more entries in the directory, file, or list being
    scanned.
    Explanation:
    The scan of the directory, file, or list is finished.
    User Response:
    No action is required.
    --------------------------------------------

    I did try to get RECOVERY FILE HISTORY output using CLP. It did exist and I can view all the history.

    Can anybody help me?

  2. #2
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    i think journal picks details from toolsdb.
    check over there.
    if db2diag says anything ?
    ..... try restarting the instance
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

  3. #3
    Join Date
    Aug 2008
    Posts
    2
    rahul,

    I have 3 database in 1 instance. From Journal I can see the other 2 databases. Only the remain 1 databases did not have anything display the database history in the Journal.

    Is there anyway I can check either the toolsdb keeping the database history?

  4. #4
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    Any job run thr. task centre are recorded in various table in toolsdb.
    cant say for sure... just a guess
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

Posting Permissions

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