Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2011
    Posts
    41

    Unanswered: Serious issue in Backup

    Hello DBA's

    I'm having a serious issues where I coudn't able to take a backup where is used to take it every weekend ..

    Few things I observed :

    When I tried to stop the db i'm getting the below error

    SQL1042C :An unexpected system error occured : SQLSTATE=58004 .

    I have attached the diaglog along with this mail . Kindly help ..

    Regards
    Satish
    Attached Files Attached Files

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    It's not easy to read the screenshots in your attached file - better to attach the diag.log file.

    From what I can see, an end of file is reported by the OS when a prefetcher is reading data from some tablespace (Pool ID = 9? check your 4th screenshot).

    Compare the size of containers for tablespace ID 9? as reported by "db2pd -d <db name> -tab" and "ls -l" and check for any errors logged in the OS log (errpt -a).

  3. #3
    Join Date
    Mar 2011
    Posts
    41
    Hello BELLO4KA,

    I couldn't able get any info from errpt -a and from the diag log i can see the below error ..

    2011-06-04-18.52.07.643289+060 E466610591A1217 LEVEL: Error (OS)
    PID : 12714208 TID : 258 PROC : db2sysc 0
    INSTANCE: db2nid NODE : 000
    EDUID : 258 EDUNAME: db2sysc 0
    FUNCTION: DB2 UDB, oper system services, sqloAIXLoadModuleTryShr, probe:130
    CALLED : OS, -, dlopen
    OSERR : ENOEXEC (8) "Exec format error"
    MESSAGE : Attempt to load specified library failed.
    DATA #1 : Library name or path, 37 bytes
    /db2/db2nid/sqllib/lib64/libdb2iocp.a
    DATA #2 : shared library load flags, PD_TYPE_LOAD_FLAGS, 4 bytes
    2
    DATA #3 : String, 621 bytes
    0509-130 Symbol resolution failed for /db2/db2nid/sqllib/lib64/libdb2iocp.a because:
    0509-136 Symbol CreateIoCompletionPort (number 0) is not exported from
    dependent module /unix.
    0509-136 Symbol GetQueuedCompletionStatus (number 1) is not exported from
    dependent module /unix.
    0509-136 Symbol GetMultipleCompletionStatus (number 2) is not exported from
    dependent module /unix.
    0509-022 Cannot load module /db2/db2nid/sqllib/lib64/libdb2iocp.a.
    0509-026 System error: Cannot run a file that does not have a valid format.
    0509-192 Examine .loader section symbols with the
    'dump -Tv' command.

    I couldn't able to extract the complete diag files at the moment but really appreciate if you give some clue on this ..

  4. #4
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367

  5. #5
    Join Date
    Mar 2011
    Posts
    41
    Hello,

    When we tried to take a tablespace BTABI level backup for the TB sp id 13 where am getting the error again it fails with the same error code . Attached the latest diaglog ..

    Regards
    Satish
    Attached Files Attached Files

  6. #6
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Did you compare ls -l and db2pd -tab for tablespace? Check the size of containers and compare it with what's reported by db2pd.

Posting Permissions

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