Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2012
    Posts
    6

    Unanswered: DB2 Redirected Restore - SQL5005C System Error

    DB2 9.5 on AIX

    I am trying to do a redirected restore. I generated the restore script and updated it. When I run it I get: SQL5005C System Error.

    SQL5005C Explanation:

    A system error, probably an I/O error, was encountered while
    accessing a configuration file.

    The command cannot be processed.

    User Response:

    Resubmit the command. If the error persists, check the db2diag.log file for details and ensure that the configuration file is accessible.

    But db2diag does not indicate what file is the problem.


    2012-09-27-15.07.29.871369-300 I1296524A540 LEVEL: Error
    PID : 16187424 TID : 17692 PROC : db2sysc
    INSTANCE: db2debiz NODE : 000 DB : METROF
    APPHDL : 0-10955 APPID: *LOCAL.db2debiz.120927200729
    AUTHID : DB2DEBIZ
    EDUID : 17692 EDUNAME: db2agent (METROF)
    FUNCTION: DB2 UDB, config/install, sqlf_read_db_and_verify, probe:30
    MESSAGE : SQL5005: sqlf_openfile rc =
    DATA #1 : Hexdump, 4 bytes
    0x07000001BF3F15E0 : 870F 0011 ....

    2012-09-27-15.07.29.871618-300 I1297065A435 LEVEL: Error
    PID : 16187424 TID : 17692 PROC : db2sysc
    INSTANCE: db2debiz NODE : 000 DB : METROF
    APPHDL : 0-10955 APPID: *LOCAL.db2debiz.120927200729
    AUTHID : DB2DEBIZ
    EDUID : 17692 EDUNAME: db2agent (METROF)
    FUNCTION: DB2 UDB, config/install, sqlf_read_db_and_verify, probe:0
    RETCODE : ZRC=0xFFFFEC73=-5005

    2012-09-27-15.07.29.871820-300 I1297501A488 LEVEL: Severe
    PID : 16187424 TID : 17692 PROC : db2sysc
    INSTANCE: db2debiz NODE : 000 DB : METROF
    APPHDL : 0-10955 APPID: *LOCAL.db2debiz.120927200729
    AUTHID : DB2DEBIZ
    EDUID : 17692 EDUNAME: db2agent (METROF)
    FUNCTION: DB2 UDB, config/install, sqlf_alert, probe:2
    DATA #1 : Hexdump, 4 bytes
    0x07000001BF3F1670 : FFFF EC73 ...s

    2012-09-27-15.07.29.871989-300 I1297990A421 LEVEL: Severe
    PID : 16187424 TID : 17692 PROC : db2sysc
    INSTANCE: db2debiz NODE : 000 DB : METROF
    APPHDL : 0-10955 APPID: *LOCAL.db2debiz.120927200729
    AUTHID : DB2DEBIZ
    EDUID : 17692 EDUNAME: db2agent (METROF)
    FUNCTION: DB2 UDB, config/install, sqlfixdb, probe:2
    RETCODE : ZRC=0xFFFFEC73=-5005

    2012-09-27-15.07.29.872179-300 I1298412A445 LEVEL: Severe
    PID : 16187424 TID : 17692 PROC : db2sysc
    INSTANCE: db2debiz NODE : 000 DB : METROF
    APPHDL : 0-10955 APPID: *LOCAL.db2debiz.120927200729
    AUTHID : DB2DEBIZ
    EDUID : 17692 EDUNAME: db2agent (METROF)
    FUNCTION: DB2 UDB, base sys utilities, sqlePrepareForSerialization, probe:30
    RETCODE : ZRC=0xFFFFEC73=-5005

    2012-09-27-15.07.29.872390-300 I1298858A451 LEVEL: Severe
    PID : 16187424 TID : 17692 PROC : db2sysc
    INSTANCE: db2debiz NODE : 000 DB : METROF
    APPHDL : 0-10955 APPID: *LOCAL.db2debiz.120927200729
    AUTHID : DB2DEBIZ
    EDUID : 17692 EDUNAME: db2agent (METROF)
    FUNCTION: DB2 UDB, base sys utilities, sqeDBMgr:tartUsingLocalDatabase, probe:10
    RETCODE : ZRC=0xFFFFEC73=-5005


    How do I determine the cause of the I/O error?

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Where in the script are you getting the error?

    Andy

  3. #3
    Join Date
    Mar 2012
    Posts
    6
    The first RESTORE DB command is generating the error.

    RESTORE DATABASE SOMEDB
    FROM '/db2system/db2debiz/backups'
    TAKEN AT 20120925003030
    ON '/u01/SOMEDB_CNTNR/AUTOSPACE_TS_C003'
    , '/u01/SOMEDB_CNTNR/AUTOSPACE_TS_C002'
    , '/u01/SOMEDB_CNTNR/AUTOSPACE_TS_C001'
    INTO SOMEDB
    NEWLOGPATH '/db2logs/db2debiz/SOMEDB_LOGS'
    REDIRECT
    ;

    What is weird is that previously I was able to get past this step and I got an error on a SET TABLESPACE CONTAINER command. Fixed that by emptying the directory but now I don't even get that far.

    Thanks in advance for any input.

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Does the instance have the appropriate permissions to all of the locations and files stated in the command?

    Andy

  5. #5
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    It looks like db2 can't open a file where the 'db cfg' info is stored -> SQLDBCONF. See:
    IBM DB2 9.7 Information Center for Linux, UNIX, and Windows

    Check if you have this file in the local db directory and its size.

    Does 'get db cfg for <db name' work? Why are you performing a redirected restore? Are you restoring into a new db or an existing db? In your restore example, source and target is SOMEDB.

  6. #6
    Join Date
    Mar 2012
    Posts
    6
    Thanks for the suggestions. Got sidetracked for a bit but never did get the redirected restored to work. Ended up re-creating the database and exporting/importing the data.

Tags for this Thread

Posting Permissions

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