Connecting Tech Pros Worldwide Help | Site Map

Database creation failing on AIX.

Newbie
 
Join Date: Nov 2008
Posts: 2
#1: Nov 5 '08
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.
Newbie
 
Join Date: May 2008
Posts: 9
#2: Nov 5 '08

re: Database creation failing on AIX.


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
Newbie
 
Join Date: Nov 2008
Posts: 2
#3: Nov 5 '08

re: Database creation failing on AIX.


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??
Newbie
 
Join Date: Mar 2007
Location: Minneapolis, MN
Posts: 4
#4: Dec 2 '08

re: Database creation failing on AIX.


Hi,
Are you using windows external security, if so, please add the userid to local windows security group db2users or db2admns
docdiesel's Avatar
Moderator
 
Join Date: Aug 2007
Location: Munich
Posts: 289
#5: Dec 3 '08

re: Database creation failing on AIX.


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:
Expand|Select|Wrap|Line Numbers
  1. tcp  0  0  0.0.0.0:523    0.0.0.0:*  LISTEN  1234/db2dasrrm
  2. 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
Reply