Results 1 to 5 of 5
  1. #1
    Join Date
    May 2009
    Posts
    9

    Unanswered: 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??

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Do you need to specify the history file? Try putting single quotes around it.
    Last edited by Marcus_A; 05-30-09 at 11:31.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    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.

  4. #4
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    recover db command:

    USING HISTORY FILE history-file path


    So, try:
    ....history file (/share/)....

  5. #5
    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.

Posting Permissions

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