db2admin start error

[Lan W via DBMonster.com]

Hi,

I tried to issue the command: db2admin start on my db2 UDB 8.2 with AIX 5.2
server. It gives me the error:
SQL4401C The DB2 Administration Server encountered an error during startup.

Does anyone can tell me how to fix it?

Thanks!
Lan

--
Message posted via http://www.dbmonster.com

[Bernd Hohmann]

Lan W via DBMonster.com wrote:

I tried to issue the command: db2admin start on my db2 UDB 8.2 with AIX5.2
server. It gives me the error:
SQL4401C The DB2 Administration Server encountered an error during startup.

Does anyone can tell me how to fix it?

I have this error sometimes under OS/2 and usually

DB2ADMIN stop
DB2ADMIN drop
DB2ADMIN create /user:your_user /password:your_password
DB2ADMIN start

fixes the problem. But no idea if this is an ointment under AIX :)

Bernd

--
"Ja, alles meine Herren" sprach Fürst Lichnowsky. "Ooch det roochen?"
"Ja, auch das Rauchen." "Ooch im Tiergarten?" "Ja, auch im Tiergarten
darf geraucht werden, meine Herren." Und so endeten die Barrikadenkämpfe
des 18. März in Berlin

[Darin McBride]

Bernd Hohmann wrote:

Lan W via DBMonster.com wrote:

I tried to issue the command: db2admin start on my db2 UDB 8.2 with AIX
5.2 server. It gives me the error:
SQL4401C The DB2 Administration Server encountered an error during
startup.

Does anyone can tell me how to fix it?

I have this error sometimes under OS/2 and usually

DB2ADMIN stop
DB2ADMIN drop
DB2ADMIN create /user:your_user /password:your_password
DB2ADMIN start

fixes the problem. But no idea if this is an ointment under AIX :)

Bernd

Oh, I'd suggest that's a bad idea on AIX. The way to create/drop/etc the
das on OS/2 and Windows is very different than Unix and Linux.

This would be:

/usr/opt/db2_08_01/instance/dasdrop # as root
/usr/opt/db2_08_01/instance/dascrt dasusr1 # as root

(dasdrop automatically stops the das, dascrt automatically starts it)

If you have any configuration in your das, however, you'll lose that. And
because the unix das in v8 is so different from the OS/2 das in v7, this
may not even work.

Lan W - do you have any logfiles that would help diagnose the problem?

[Mark A]

"Darin McBride" <dm******@tower.to.org.no.spam.for.me> wrote in message
news:5f7ff.522939$1i.360354@pd7tw2no...

Oh, I'd suggest that's a bad idea on AIX. The way to create/drop/etc the
das on OS/2 and Windows is very different than Unix and Linux.

This would be:

/usr/opt/db2_08_01/instance/dasdrop # as root
/usr/opt/db2_08_01/instance/dascrt dasusr1 # as root

(dasdrop automatically stops the das, dascrt automatically starts it)

If you have any configuration in your das, however, you'll lose that. And
because the unix das in v8 is so different from the OS/2 das in v7, this
may not even work.

Lan W - do you have any logfiles that would help diagnose the problem?

Before you drop and recreate the administrative server instance, download
and install IBM JDK 1.4.2. You have to register to download, but
registration is free.