After Windows install, DB2DAS won't start

[a***@hotmail.com]

Just installed latest DB2 on two similarly equipped Windows 2003 Servers for testing. On one the install went fine. But the other has a problem: the DB2DAS-DB2DAS00 service won't start. Reports error code -22204.

I suspected a necessary service might be disabled. But I changed all the disabled services to manual without any effect.

Any suggestions?

[Garfield Lewis]

Here is the text of this error:

WSDB::E:\build>db2 ? sql22204


SQL22204N The DB2 Administration Server encountered a non-severe
error while executing a request.

Explanation:

A non-severe error occurred in the DB2 Administration Server
while it was processing a request.

User Response:

Refer to the DB2 Administration Server's First Failure Data
Capture Log for additional information.

If trace was active, invoke the Independent Trace Facility at
the operating system command prompt. Contact IBM Support with
the following required information:

o Problem description

o SQLCODE or message number

o SQLCA contents if possible

o Trace file if possible
--
Garfield A. Lewis
DB2 UDB Development,
IBM Canada Laboratory

Post by a***@hotmail.com
Just installed latest DB2 on two similarly equipped Windows 2003 Servers

for testing. On one the install went fine. But the other has a problem: the
DB2DAS-DB2DAS00 service won't start. Reports error code -22204.

Post by a***@hotmail.com
I suspected a necessary service might be disabled. But I changed all the

disabled services to manual without any effect.

Post by a***@hotmail.com
Any suggestions?

[h***@ca.ibm.com]

Are there any log records in the Windows Event Log related to this service?

[a***@hotmail.com]

Details:

When I boot the server and go to the Computer Manager I can see the DB2DAS service in the process of "STOPPING". It records error in the Window's System Log: DB2DAS-DB2DAS00 service terminated with service specific error 4294945092.

If I try to turn on the service manually in the Computer Manager, I get the error: Windows could not start the service on the local computer and the error code -22204.

The file db2dasdiag.log shows this after trying to turn on the service manually:

2005-05-13-05.20.47.000000 pid:1356 tid:3208 level:2
DB2 tools - DB2 administration server - openDasRrmQueues() probe:10
data #1 (4 bytes)
-1879048101

2005-05-13-05.20.47.000000 pid:1356 tid:3208 level:2
DB2 tools - DB2 administration server - initDasControlBlock() probe:20
data #1 (4 bytes)
0

2005-05-13-05.20.47.015000 pid:1356 tid:3208 level:2
DB2 tools - DB2 administration server - dasRootInit() probe:20
data #1 (4 bytes)
-2129723374

2005-05-13-05.20.47.015000 pid:1356 tid:3208 level:2
DB2 tools - DB2 administration server - rrm_main() probe:80
data #1 (4 bytes)
-3020

If I try to add a table to a database (apparently I can add a database but not a table and columns), and turn on db2trc just before I commit the action, I get a trace of 1169 items. But I am running a trial version; I am not sure I will receive any support from IBM.

[Garfield Lewis]

Did you choose to enable extended secuirty when you installed? If so:

1. are the service logon accounts members of the DB2ADMNS group?
2. are your users members of the DB2USERS group?
3. are your administrators memberso the DB2ADMNS group?
--
Garfield A. Lewis
DB2 UDB Development,
IBM Canada Laboratory

Post by a***@hotmail.com
When I boot the server and go to the Computer Manager I can see the DB2DAS

service in the process of "STOPPING". It records error in the Window's
System Log: DB2DAS-DB2DAS00 service terminated with service specific error
4294945092.

Post by a***@hotmail.com
If I try to turn on the service manually in the Computer Manager, I get

the error: Windows could not start the service on the local computer and the
error code -22204.

Post by a***@hotmail.com
2005-05-13-05.20.47.000000 pid:1356 tid:3208 level:2
DB2 tools - DB2 administration server - openDasRrmQueues() probe:10
data #1 (4 bytes)
-1879048101
2005-05-13-05.20.47.000000 pid:1356 tid:3208 level:2
DB2 tools - DB2 administration server - initDasControlBlock() probe:20
data #1 (4 bytes)
0
2005-05-13-05.20.47.015000 pid:1356 tid:3208 level:2
DB2 tools - DB2 administration server - dasRootInit() probe:20
data #1 (4 bytes)
-2129723374
2005-05-13-05.20.47.015000 pid:1356 tid:3208 level:2
DB2 tools - DB2 administration server - rrm_main() probe:80
data #1 (4 bytes)
-3020
If I try to add a table to a database (apparently I can add a database but

not a table and columns), and turn on db2trc just before I commit the
action, I get a trace of 1169 items. But I am running a trial version; I am
not sure I will receive any support from IBM.