db2admin start error

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lan W - 17 Nov 2005 18:26 GMT

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

Reply to this Message

Bernd Hohmann - 17 Nov 2005 20:37 GMT

> 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

Signature

"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

Reply to this Message

Darin McBride - 17 Nov 2005 22:12 GMT

>> I tried to issue the command: db2admin start on my db2 UDB 8.2 with AIX
>> 5.2 server. It gives me the error:
[quoted text clipped - 13 lines]
>
> 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?

Reply to this Message

Mark A - 18 Nov 2005 04:03 GMT

> 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.
[quoted text clipped - 11 lines]
>
> 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.

Reply to this Message