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

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).

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

Check https://www-304.ibm.com/support/docv...id=swg21430458

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

Did you compare ls -l and db2pd -tab for tablespace? Check the size of containers and compare it with what's reported by db2pd.