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 > question:receive error when recover database xxx using history file xxx??

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 05-30-09, 10:21
xiaomage79 xiaomage79 is offline
Registered User
 
Join Date: May 2009
Posts: 9
question:receive error when recover database xxx using history file xxx??

db2 => recover database mydb to end of logs using history file (/share/db2rhist.asc) overflow log path (/share/archtemp)
SQL4904N The pointer to parameter "piHistoryFile" of function "db2Recover" is
not valid.
db2 => terminate
DB20000I The TERMINATE command completed successfully.

$ ls -l /share/db2rhist.asc
-rw-r--r-- 1 db2inst1 db2iadm1 16230 5月 29 23:58 /share/db2rhist.asc

why i receive error when recover database xxx using history file xxx??
Reply With Quote
  #2 (permalink)  
Old 05-30-09, 10:27
Marcus_A Marcus_A is offline
Registered User
 
Join Date: May 2003
Location: USA
Posts: 5,196
Do you need to specify the history file? Try putting single quotes around it.
__________________
M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390

Last edited by Marcus_A; 05-30-09 at 10:31.
Reply With Quote
  #3 (permalink)  
Old 05-30-09, 10:46
xiaomage79 xiaomage79 is offline
Registered User
 
Join Date: May 2009
Posts: 9
i try again the same error

db2 => recover database mydb to end of logs using history file ('/share/db2rhist.asc') overflow log path (/share/archtemp)
SQL4904N The pointer to parameter "piHistoryFile" of function "db2Recover" is
not valid.
Reply With Quote
  #4 (permalink)  
Old 05-30-09, 12:39
db2girl db2girl is offline
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
recover db command:

USING HISTORY FILE history-file path


So, try:
....history file (/share/)....
Reply With Quote
  #5 (permalink)  
Old 05-30-09, 23:24
xiaomage79 xiaomage79 is offline
Registered User
 
Join Date: May 2009
Posts: 9
thank you db2girl

you are right

now that's OK

db2 => recover database mydb to end of logs using history file (/share/) overflow log path (/share/archtemp)

Rollforward Status

Input database alias = mydb
Number of nodes have returned status = 1

Node number = 0
Rollforward status = not pending
Next log file to be read =
Log files processed = S0000004.LOG - S0000004.LOG
Last committed transaction = 2009-05-29-23.52.35.000000 Local

DB20000I The RECOVER DATABASE command completed successfully.
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