Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2010
    Location
    Sweden
    Posts
    8

    Unanswered: Please help : Cannot connect to DB after DISK issue

    Hello DB2 friends,

    Our environment : AIX 6.1 / DB2 V9.1 FP 8.
    DB(preprod) is about 800GB. We have got OFFLINE BACKUP taken a week before and ONLINE backup taken yesterday. But due to disk issue we lost ALL transaction logs. Do not have any other identical db2 server.

    Issue : An I/O error occurred while accessing the database.

    $ db2start -> ok
    $ db2 connect to preprod
    SQL1036C An I/O error occurred while accessing the database. SQLSTATE=58030

    First active log file = S0000005.LOG

    2012-05-15-00.54.10.165619-240 I102187A313 LEVEL: Error
    PID : 5339644 TID : 1 PROC : db2loggr (PREPROD)
    INSTANCE: db2prepd NODE : 000
    FUNCTION: DB2 UDB, data protection services, sqlpgInitRecoverable, probe:1370
    DATA #1 : <preformatted>
    Log file S0000005LOG not found.

    2012-05-15-00.54.10.166235-240 I102501A362 LEVEL: Error
    PID : 5339644 TID : 1 PROC : db2loggr (PREPROD)
    INSTANCE: db2prepd NODE : 000
    FUNCTION: DB2 UDB, data protection services, sqlpgLoggrInit, probe:430
    RETCODE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
    DIA8411C A file "" could not be found.


    We need to get this db up soon. So please let us know the recovery options.

    1> Can we use 'without rolling forward' clause of RESTORE ( from ONLINE backup)? But it seems it still ask me to run Rollforward? Exactly what Rollforward command I should run in this situation?

    $ db2 "restore db preprod replace existing without rolling forward without prompting"
    SQL2537N Roll-forward is required following the Restore.


    2> In past we had done patching (other db2system) of db2 log control file (SQLOGCTL.LFH) though IBM support. Is it the only option for us to recover? But that need to rebuild the whole db after using the patched SQLOGCTL.LFH from IBM.

    PS: we have extended support for v9.1

    Looking for your help friends.

    - Jenny

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    If you have used INCLUDE LOGS in your online backup command, they you restore the logs and rollforward to the "end of logs" which will be the time of the end of backup.

    Otherwise, I am afraid, using IBM support is the only option.
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Aug 2010
    Location
    Sweden
    Posts
    8
    thanks,

    db2ckbkp -h shows "Include Logs -- 0"

  4. #4
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    You lost all transaction logs stored in the active log dir (active/archived) or do you archive them to another location? If the logs are truely missing (it could be the FS wasn't mounted correctly, check that?) and you can't use an offline backup, then IBM support can patch it to make it accessible (don't really have to restore from an online backup) but the db will be unsupported until you rebuild it.

Posting Permissions

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