SEO

db2dasdiag.log file contains the following:

2007-08-16-17.52.08.081000+180 I2H210 LEVEL: Error
PID : 1760 TID : 3952
FUNCTION: DB2 Tools, DB2 administration server, getProcess, probe:10
DATA #1 : Sint32, 4 bytes
1314

2007-08-16-17.52.08.081000+180 I214H217 LEVEL: Error
PID : 1760 TID : 3952
FUNCTION: DB2 Tools, DB2 administration server, handleStmRequest,
probe:90
DATA #1 : Sint32, 4 bytes
-4010

2007-08-16-17.52.08.081000+180 I433H218 LEVEL: Error
PID : 1760 TID : 3952
FUNCTION: DB2 Tools, DB2 administration server, handleStmRequest,
probe:150
DATA #1 : Sint32, 4 bytes
-4010

2007-08-16-17.52.08.127000+180 I653H210 LEVEL: Error
PID : 1760 TID : 3108
FUNCTION: DB2 Tools, DB2 administration server, getProcess, probe:10
DATA #1 : Sint32, 4 bytes
1314

2007-08-16-17.52.08.127000+180 I865H217 LEVEL: Error
PID : 1760 TID : 3108
FUNCTION: DB2 Tools, DB2 administration server, handleStmRequest,
probe:90
DATA #1 : Sint32, 4 bytes
-4010

2007-08-16-17.52.08.127000+180 I1084H218 LEVEL: Error
PID : 1760 TID : 3108
FUNCTION: DB2 Tools, DB2 administration server, handleStmRequest,
probe:150
DATA #1 : Sint32, 4 bytes
-4010

2007-08-16-17.52.09.409000+180 I1304H210 LEVEL: Error
PID : 1760 TID : 3564
FUNCTION: DB2 Tools, DB2 administration server, getProcess, probe:10
DATA #1 : Sint32, 4 bytes
1314

2007-08-16-17.52.09.425000+180 I1516H217 LEVEL: Error
PID : 1760 TID : 3564
FUNCTION: DB2 Tools, DB2 administration server, handleStmRequest,
probe:90
DATA #1 : Sint32, 4 bytes
-4010

2007-08-16-17.52.09.425000+180 I1735H218 LEVEL: Error
PID : 1760 TID : 3564
FUNCTION: DB2 Tools, DB2 administration server, handleStmRequest,
probe:150
DATA #1 : Sint32, 4 bytes
-4010

2007-08-16-17.52.09.440000+180 I1955H210 LEVEL: Error
PID : 1760 TID : 3336
FUNCTION: DB2 Tools, DB2 administration server, getProcess, probe:10
DATA #1 : Sint32, 4 bytes
1314

2007-08-16-17.52.09.440000+180 I2167H217 LEVEL: Error
PID : 1760 TID : 3336
FUNCTION: DB2 Tools, DB2 administration server, handleStmRequest,
probe:90
DATA #1 : Sint32, 4 bytes
-4010

2007-08-16-17.52.09.440000+180 I2386H218 LEVEL: Error
PID : 1760 TID : 3336
FUNCTION: DB2 Tools, DB2 administration server, handleStmRequest,
probe:150
DATA #1 : Sint32, 4 bytes
-4010

2007-08-16-17.52.09.503000+180 I2606H210 LEVEL: Error
PID : 1760 TID : 3968
FUNCTION: DB2 Tools, DB2 administration server, getProcess, probe:10
DATA #1 : Sint32, 4 bytes
1314

2007-08-16-17.52.09.503000+180 I2818H217 LEVEL: Error
PID : 1760 TID : 3968
FUNCTION: DB2 Tools, DB2 administration server, handleStmRequest,
probe:90
DATA #1 : Sint32, 4 bytes
-4010

2007-08-16-17.52.09.503000+180 I3037H218 LEVEL: Error
PID : 1760 TID : 3968
FUNCTION: DB2 Tools, DB2 administration server, handleStmRequest,
probe:150
DATA #1 : Sint32, 4 bytes
-4010

2007-08-16-17.52.09.753000+180 I3257H209 LEVEL: Error
PID : 1760 TID : 768
FUNCTION: DB2 Tools, DB2 administration server, getProcess, probe:10
DATA #1 : Sint32, 4 bytes
1314

2007-08-16-17.52.09.768000+180 I3468H216 LEVEL: Error
PID : 1760 TID : 768
FUNCTION: DB2 Tools, DB2 administration server, handleStmRequest,
probe:90
DATA #1 : Sint32, 4 bytes
-4010

2007-08-16-17.52.09.768000+180 I3686H217 LEVEL: Error
PID : 1760 TID : 768
FUNCTION: DB2 Tools, DB2 administration server, handleStmRequest,
probe:150
DATA #1 : Sint32, 4 bytes
-4010

2007-08-16-17.52.10.112000+180 I3905H210 LEVEL: Error
PID : 1760 TID : 3288
FUNCTION: DB2 Tools, DB2 administration server, getProcess, probe:10
DATA #1 : Sint32, 4 bytes
1314

2007-08-16-17.52.10.112000+180 I4117H217 LEVEL: Error
PID : 1760 TID : 3288
FUNCTION: DB2 Tools, DB2 administration server, handleStmRequest,
probe:90
DATA #1 : Sint32, 4 bytes
-4010

2007-08-16-17.52.10.112000+180 I4336H218 LEVEL: Error
PID : 1760 TID : 3288
FUNCTION: DB2 Tools, DB2 administration server, handleStmRequest,
probe:150
DATA #1 : Sint32, 4 bytes
-4010

2007-08-16-17.52.10.190000+180 I4556H210 LEVEL: Error
PID : 1760 TID : 3444
FUNCTION: DB2 Tools, DB2 administration server, getProcess, probe:10
DATA #1 : Sint32, 4 bytes
1314

2007-08-16-17.52.10.190000+180 I4768H217 LEVEL: Error
PID : 1760 TID : 3444
FUNCTION: DB2 Tools, DB2 administration server, handleStmRequest,
probe:90
DATA #1 : Sint32, 4 bytes
-4010

2007-08-16-17.52.10.190000+180 I4987H218 LEVEL: Error
PID : 1760 TID : 3444
FUNCTION: DB2 Tools, DB2 administration server, handleStmRequest,
probe:150
DATA #1 : Sint32, 4 bytes
-4010

2007-08-16-17.52.10.206000+180 I5207H210 LEVEL: Error
PID : 1760 TID : 2124
FUNCTION: DB2 Tools, DB2 administration server, getProcess, probe:10
DATA #1 : Sint32, 4 bytes
1314

2007-08-16-17.52.10.206000+180 I5419H217 LEVEL: Error
PID : 1760 TID : 2124
FUNCTION: DB2 Tools, DB2 administration server, handleStmRequest,
probe:90
DATA #1 : Sint32, 4 bytes
-4010

2007-08-16-17.52.10.206000+180 I5638H218 LEVEL: Error
PID : 1760 TID : 2124
FUNCTION: DB2 Tools, DB2 administration server, handleStmRequest,
probe:150
DATA #1 : Sint32, 4 bytes
-4010

2007-08-16-17.52.10.222000+180 I5858H210 LEVEL: Error
PID : 1760 TID : 3736
FUNCTION: DB2 Tools, DB2 administration server, getProcess, probe:10
DATA #1 : Sint32, 4 bytes
1314

2007-08-16-17.52.10.222000+180 I6070H217 LEVEL: Error
PID : 1760 TID : 3736
FUNCTION: DB2 Tools, DB2 administration server, handleStmRequest,
probe:90
DATA #1 : Sint32, 4 bytes
-4010

2007-08-16-17.52.10.222000+180 I6289H218 LEVEL: Error
PID : 1760 TID : 3736
FUNCTION: DB2 Tools, DB2 administration server, handleStmRequest,
probe:150
DATA #1 : Sint32, 4 bytes
-4010

2007-08-16-17.52.10.268000+180 I6509H210 LEVEL: Error
PID : 1760 TID : 2820
FUNCTION: DB2 Tools, DB2 administration server, getProcess, probe:10
DATA #1 : Sint32, 4 bytes
1314

2007-08-16-17.52.10.300000+180 I6721H217 LEVEL: Error
PID : 1760 TID : 2820
FUNCTION: DB2 Tools, DB2 administration server, handleStmRequest,
probe:90
DATA #1 : Sint32, 4 bytes
-4010

2007-08-16-17.52.10.315000+180 I6940H218 LEVEL: Error
PID : 1760 TID : 2820
FUNCTION: DB2 Tools, DB2 administration server, handleStmRequest,
probe:150
DATA #1 : Sint32, 4 bytes
-4010

2007-08-16-17.52.10.597000+180 I7160H210 LEVEL: Error
PID : 1760 TID : 2284
FUNCTION: DB2 Tools, DB2 administration server, getProcess, probe:10
DATA #1 : Sint32, 4 bytes
1314

2007-08-16-17.52.10.597000+180 I7372H217 LEVEL: Error
PID : 1760 TID : 2284
FUNCTION: DB2 Tools, DB2 administration server, handleStmRequest,
probe:90
DATA #1 : Sint32, 4 bytes
-4010

2007-08-16-17.52.10.597000+180 I7591H218 LEVEL: Error
PID : 1760 TID : 2284
FUNCTION: DB2 Tools, DB2 administration server, handleStmRequest,
probe:150
DATA #1 : Sint32, 4 bytes
-4010

2007-08-16-17.52.11.441000+180 I7811H210 LEVEL: Error
PID : 1760 TID : 3596
FUNCTION: DB2 Tools, DB2 administration server, getProcess, probe:10
DATA #1 : Sint32, 4 bytes
1314

2007-08-16-17.52.11.441000+180 I8023H217 LEVEL: Error
PID : 1760 TID : 3596
FUNCTION: DB2 Tools, DB2 administration server, handleStmRequest,
probe:90
DATA #1 : Sint32, 4 bytes
-4010

2007-08-16-17.52.11.441000+180 I8242H218 LEVEL: Error
PID : 1760 TID : 3596
FUNCTION: DB2 Tools, DB2 administration server, handleStmRequest,
probe:150
DATA #1 : Sint32, 4 bytes
-4010

2007-08-16-17.52.11.456000+180 I8462H210 LEVEL: Error
PID : 1760 TID : 3468
FUNCTION: DB2 Tools, DB2 administration server, getProcess, probe:10
DATA #1 : Sint32, 4 bytes
1314

2007-08-16-17.52.11.456000+180 I8674H217 LEVEL: Error
PID : 1760 TID : 3468
FUNCTION: DB2 Tools, DB2 administration server, handleStmRequest,
probe:90
DATA #1 : Sint32, 4 bytes
-4010

2007-08-16-17.52.11.456000+180 I8893H218 LEVEL: Error
PID : 1760 TID : 3468
FUNCTION: DB2 Tools, DB2 administration server, handleStmRequest,
probe:150
DATA #1 : Sint32, 4 bytes
-4010

2007-08-16-17.52.11.534000+180 I9113H210 LEVEL: Error
PID : 1760 TID : 2660
FUNCTION: DB2 Tools, DB2 administration server, getProcess, probe:10
DATA #1 : Sint32, 4 bytes
1314

2007-08-16-17.52.11.534000+180 I9325H217 LEVEL: Error
PID : 1760 TID : 2660
FUNCTION: DB2 Tools, DB2 administration server, handleStmRequest,
probe:90
DATA #1 : Sint32, 4 bytes
-4010

2007-08-16-17.52.11.534000+180 I9544H218 LEVEL: Error
PID : 1760 TID : 2660
FUNCTION: DB2 Tools, DB2 administration server, handleStmRequest,
probe:150
DATA #1 : Sint32, 4 bytes
-4010

I don't understand anything here! Please, help.

On Fri, 17 Aug 2007 01:10:02 -0700, alexandis scribbled:

> db2dasdiag.log file contains the following:
>
[snip pointless log]
>
> I don't understand anything here! Please, help.

Quick crash course in why "db2dasdiag.log" isn't particularly helpful:

In DB2, databases are managed as part of an "instance". By default a
single database instance is created (usually called "db2inst1" on Linux/
UNIX or "DB2" on Windows), but you can create more later if you wish.
Diagnostic information for instances is held in a file called
"db2diag.log" (found in C:\Program Files\IBM\SQLLIB\DB2 on Windows or
~db2inst1/sqllib/db2dump/ on Linux/UNIX).

There is also a special instance called the "administration" instance.
The administration instance cannot contain databases, and there cannot be
more than one admin instance. Instead it exists to aid in various
administrative functions (e.g. e-mailing health monitor warnings). The
admin instance is often referred to as the "DAS" (DB2 Admin Service), and
diagnostic information for it can be found in "db2dasdiag.log", which is
what you've posted.

In other words: given that the admin instance has little or nothing to do
with creating databases, it's probably not going to contain anything
useful. What *would* be useful is if you could post the error you receive
when you attempt to create a database?

From a DB2 Command Window (if you're on Windows) or a bash prompt as
db2inst1 (if you're on Linux/UNIX) try entering:

db2sampl

This command attempts to create and populate the "SAMPLE" database. If
you get an error, please post the *full* text of it here including any
codes at the beginning and end of the message.

If it works, try creating your own database. If you get an error, please
post the full text of the command you used to create the database (if
you're using the Control Center there is usually a "Show Command" button
which will display the SQL that the GUI will attempt to execute), along
with the full text of the error message you receive.

Cheers,

Dave.

Thanks, Dave,

I was able to successfully create SAMPLE db (actually it was done
automatically - so it's not my merit ),

but when I try to create my test db (via right click in Control
Center), i'm getting the following mysterious message:

SQL22205C The DB2 Administration Server encountered an
unexpected error while executing a request.

Explanation:

An unexpected 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

And there's no 'Show Command' button in that dialog box (I guess it's
because it's some problem PRIOR to sql command).