Hello!
Any ideas why the library file libdb2iocp.a could not be loaded?
DB2 is V9.7.2, server is AIX 5.3_TL10, iocp is installed:
bos.iocp.rte 5.3.10.1 A F I/O Completion Ports
API
The lib file is in its place (and world readable and executable):
-r-xr-xr-x 1 bin bin 4349 4 Ruj 17:52
/home/db2/sqllib/lib64/libdb2iocp.a

__________________________________________________ _______________________
2010-09-05-14.49.57.707410+120 E58601564A1097 LEVEL: Error (OS)
PID : 823456 TID : 258 PROC : db2sysc 0
INSTANCE: db2 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, 35 bytes
/home/db2/sqllib/lib64/libdb2iocp.a
DATA #2 : shared library load flags, PD_TYPE_LOAD_FLAGS, 4 bytes
2
DATA #3 : String, 503 bytes
Symbol resolution failed for /home/db2/sqllib/lib64/libdb2iocp.a because:
Symbol CreateIoCompletionPort (number 0) is not exported from
dependent
module /unix.
Symbol GetQueuedCompletionStatus (number 1) is not exported from
dependent
module /unix.
Symbol GetMultipleCompletionStatus (number 2) is not exported from
dependent
module /unix.
Could not load module /home/db2/sqllib/lib64/libdb2iocp.a.
System error: Exec format error
Examine .loader section symbols with the 'dump -Tv' command.

2010-09-05-14.49.57.777882+120 E58602662A839 LEVEL: Error (OS)
PID : 823456 TID : 258 PROC : db2sysc 0
INSTANCE: db2 NODE : 000
EDUID : 258 EDUNAME: db2sysc 0
FUNCTION: DB2 UDB, oper system services, sqloAIXLoadModuleTryShr, probe:140
CALLED : OS, -, dlopen
OSERR : ENOEXEC (8) "Exec format error"
MESSAGE : Attempt to load specified library augmented with object name
failed.
DATA #1 : Library name or path, 45 bytes
/home/db2/sqllib/lib64/libdb2iocp.a(shr_64.o)
DATA #2 : shared library load flags, PD_TYPE_LOAD_FLAGS, 4 bytes
262146
DATA #3 : String, 203 bytes
Could not load module /home/db2/sqllib/lib64/libdb2iocp.a(shr_64.o).
File /home/db2/sqllib/lib64/libdb2iocp.a is not an
archive or the file could not be read properly.
System error: Exec format error

2010-09-05-14.49.57.954084+120 I58603502A563 LEVEL: Severe
PID : 823456 TID : 258 PROC : db2sysc 0
INSTANCE: db2 NODE : 000
EDUID : 258 EDUNAME: db2sysc 0
FUNCTION: DB2 UDB, oper system services, sqloLioInitIocp, probe:200
CALLED : DB2 UDB, oper system services, sqloLoadModule
RETCODE : ZRC=0x870F009B=-2029059941=SQLO_MOD_LOAD_FAILED
"Dynamic library load failed."
DATA #1 : Library name or path, 12 bytes
libdb2iocp.a
DATA #2 : Library Search Path, 22 bytes
/home/db2/sqllib/lib64
__________________________________________________ _______________________


Regards,
Damir

Most likely IOCP is not activated in AIX. You don't have to worry about this
error, if you don't want to use IOCP.

If you want to use IOCP, you will have to change the value in 'smitty iocp'
from 'defined' to 'available' and restart the box.

It seems that you are using a non-root user installation of DB2 on AIX 5.3.
If this is the case, you can't use IOCP.
Please check the prereqs for non-root installations:
http://tinyurl.com/2f43kzg

--
Helmut K. C. Tessarek
DB2 Performance and Development

/*
Thou shalt not follow the NULL pointer for chaos and madness
await thee at its end.
*/

Thank you for your quick answer - the IOCP is indeed not active!
Are there any advantages when it is active (a document describing IOCP,
white paper, red paper... anything that could prove to mgmt that is is worth
switching on)? The DB2 InfoCenter is rather mediocre on the subject...

BTW, the installation is root, the directory /home/db2/sqllib/lib64 is only
a sym. link to /opt/IBM/db2/V9.7/lib64/.

Regards,
Damir

---
"Helmut Tessarek" <tessarek (AT) evermeet (DOT) cx> wrote

IOCP should give you better performance under heavy IO load. If not, it should
at least not make it worse. :-)
I'll check, if I can find a paper on it.

Ok, then you are good to go.

You can always deactivate it again, if you don't want to use it. There is a
regvar to turn it off:
db2set DB2_USE_IOCP=off

The easiest way is to turn it on and compare the performance.

--
Helmut K. C. Tessarek
DB2 Performance and Development

/*
Thou shalt not follow the NULL pointer for chaos and madness
await thee at its end.
*/