If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Journal GUI : Empty Database History

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 08-06-08, 08:55
sakvertor sakvertor is offline
Registered User
 
Join Date: Aug 2008
Posts: 2
Unhappy 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?
Reply With Quote
  #2 (permalink)  
Old 08-07-08, 00:42
rahul_s80 rahul_s80 is offline
Registered User
 
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
Reply With Quote
  #3 (permalink)  
Old 08-07-08, 02:55
sakvertor sakvertor is offline
Registered User
 
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?
Reply With Quote
  #4 (permalink)  
Old 08-07-08, 08:58
rahul_s80 rahul_s80 is offline
Registered User
 
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
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On