Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2010
    Posts
    2

    Unanswered: Problem restoring db2 database with rollforward using HP Data Protector

    Hi,
    i really have trouble restoring my database into the same database using HP Data Protector with rollforward to end of logs.
    i'm getting the error
    SQL1268N Roll-forward recovery stopped due to error "24" while retrieving log
    file "S0000021.LOG" for database "<name>" on node "0".

    backup and restore without rollforward works perfectly,although afterwards i'm not able to rollforward to end of logs manually..i then use the command to get the database out of the pending state:
    => rollforward db <name> stop

    i configure the database as follows
    => CREATE DATABASE <name>
    => UPDATE DB CFG FOR <name> USING USEREXIT ON DEFERRED
    => UPDATE DB CFG FOR <name> USING LOGRETAIN RECOVERY
    => UPDATE DB CFG FOR <name> USING TRACKMOD YES DEFERRED
    => BACKUP DATABASE <name> TO "" WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING

    i think all the environmental variables are set right. i can see the logs in the folder /app/db2inst2/db2inst2/NODE0000
    i don't know why they have trouble restoring them


    i'm working on the platform
    HP UX B.11.31 U ia64
    DB2 V9.7

    hope someone can help me with this problem
    Regards

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    I think you need to look at your userexit code to figure out what the error code 24 means there.

  3. #3
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    If all required logs are in /app/db2inst2/db2inst2/NODE0000, then try adding NORETRIEVE option to the rollforward command if this is allowed when using HP Data Protector.

  4. #4
    Join Date
    Dec 2010
    Posts
    2
    unfortunately there is no such option

Posting Permissions

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