cannot start db2 instance 1

[naveenrt]

Hello Friends
I installed DB2V8.1 on AIX 5.1 (32 bit) .All installation went successfull . When i try to start the db2 instance it gives the following error. I checked and the links exist for /usr/lib/threads/libc.a and there is no link for /usr/opt/db2_08_01/lib/libdb2e.a this file . I checked the same on db2V7.2 and here also the link does not exist.

Can anyone help me in finding the reason for db2 instance not starting



=========================================================
flamingo(db2inst) /users/db2inst-> db2start
exec(): 0509-036 Cannot load program db2start because of the following errors:
0509-130 Symbol resolution failed for /usr/lib/threads/libc.a(aio.o) because:
0509-136 Symbol kaio_rdwr (number 0) is not exported from
dependent module /unix.
0509-136 Symbol listio (number 1) is not exported from
dependent module /unix.
0509-136 Symbol acancel (number 2) is not exported from
dependent module /unix.
0509-136 Symbol iosuspend (number 3) is not exported from
dependent module /unix.
0509-136 Symbol aio_nwait (number 4) is not exported from
dependent module /unix.
0509-130 Symbol resolution failed for /usr/opt/db2_08_01/lib/libdb2e.a(shr.o) because:
0509-136 Symbol aio_nwait (number 416) is not exported from
dependent module /usr/lib/threads/libc.a(aio.o).
0509-192 Examine .loader section symbols with the
'dump -Tv' command.



Here is the db2diag.log
==========================================================
flamingo(db2inst) /users/db2inst/sqllib/db2dump-> cat db2diag.log

2003-10-06-18.58.03.188729 Instance:db2inst Node:000
PID:42068(db2bp) TID:1 Appid:none
oper system services sqlocque Probe:20

Unexpected system error 0x16 has occurred.
This has been mapped to ZRC 0x83000016.

PID:42068 TID:1 Node:000 Title: SYSTEM ERROR DESCRIPTION
A system call received a parameter that is not valid.flamingo(db2inst) /users/db2inst/sqllib/db2dump-> date
Mon Oct 6 19:10:50 IST 2003
flamingo(db2inst) /users/db2inst/sqllib/db2dump->
============================================================

Cheers
Naveen

 

[scottrisi]

After the install, did you run the "db2imigr" command as root ?

 

[haribol1]

Naveen,
I am heaving same problem, could you share your findings.

Thank you
Om Sharma

 

[donttreadonme]

Most likely it cannot find the DB2 lib files that would be in /home/db2inst/lib or the lib path under the instance owner.

 

[naveenrt]

Om Sharma
Here is the solution for the same . Sorry for not replying immediately

Solution
=======
Here is the link where i got the solution from

http://dbforums.com/arch/199/2002/11/579037

Moving aio from defined to available will fix the issue..

DB2 UDB Version 8.1 you now
need two new prerequisites for AIX:
It must have maintenance level 8 (AIX4.3.3.) and version 5.0.2.0 of xlC.rte and
asynchronous I/O enabled.

To make use of asynchronous I/O the following fileset must be installed on AIX
bos.rte.aio

To determine if this fileset is installed, use:
lslpp -l bos.rte.aio

You must also make the aio0 device available via SMIT.
smit chgaio
STATE to be configured at system restart available

SMIT page:
Change / Show Characteristics of Asynchronous I/O

Type or select values in entry fields.
Press Enter AFTER making all desired changes.

[Entry Fields]
MINIMUM number of servers [1] #
MAXIMUM number of servers [10] #
Maximum number of REQUESTS [4096] #
Server PRIORITY [39] #
STATE to be configured at system restart available +

Restart the AIX Server

or

Use the following command and restart the AIX Server
/usr/sbin/mkdev -l aio0 -q /usr/sbin/chdev aio0 -q -P /usr/sbin/chdev aio0 -q -P -a
autoconfig='available'

 

[naveenrt]

Om
I missed one more step . After the server is restarted run the db2iupdt command to update all ur instances and then u should be able to start the DB2 Instance

Cheers
Naveen

 

[NewBlue]

I am having the same problem in HP-UX version 11.11. I get the following error when trying the db2icrt command. C&P from the db2diag.log
2003-12-01-20.25.02.061315 Instance:db2inst2 Node:000
PID:13468(db2bp) TID:1 Appid:none
oper system services sqloGetCPUInfo Probe:5

Unexpected system error 0x16 has occurred.
This has been mapped to ZRC 0x83000016.
--------

I have tried turning on asynchronous I/O (enabled fs_async kernel parameter, and yes re-booted the machine after), and got the same error. Any help would be appreciated.

 

[haribol1]

Try the followings:
Run smitty and enable Async I/O and re-boot the database server.
start DB2

Good Luck!!

 

[haribol1]

If you are still experiencing the DB2 instance start problem, you may have to un-install DB2 and enable Async I/o, re-boot the database server and re-install DB2 and create instance.
This worked for me.

Good Luck.

 

[NewBlue]

Thanks for the info. When I turned on async i/o before, I did not un-install and re-install. I'll give it a shot and post results.