Database creation failing on AIX.

[Bhushan12]

Hi Experts,
I have installed db2 8.1 on AIX 5.3 system, I am trying to create database using db2 control center.
But DB creation is failing with error "SQL1224N A database agent could not be started to service a request, or was terminated as a result of a database system shutdown or a force command. SQLSTATE=55032".
I am not understanding why this is happening.
Plz help me.

Thanks.

[kazam]

First try to do
1) killdbm
2) create the database
3) db2start

If this doesn't work, then check if
DB2COMM registry variable is set to tcpip
if the port name is set in database manager configuration file

If they are not set, them set them and do
db2stop force
db2start.

Thanks,
Madhavi

[Bhushan12]

Hi Madhavi,
I have already done the steps that you are mentioned.
But I am getting same error.
Can you please give me some more ideas??

[leo2007]

Hi,
Are you using windows external security, if so, please add the userid to local windows security group db2users or db2admns

[docdiesel]

Hi,

make sure that the DB2 Admin Server is up and running. You may also have a look with netstat what ports are open. There should be two lines like this:

tcp  0  0  0.0.0.0:523    0.0.0.0:*  LISTEN  1234/db2dasrrm
tcp  0  0  0.0.0.0:50000  0.0.0.0:*  LISTEN  2345/db2sysc

If port 523 isn't open, logon as DB2 admin user (db2as or db2adm, depends) and start the administration server (db2admin start).

Regards


Doc Diesel