SEO

#1 (**permalink**) 02-27-2008, 04:12 AM

Hello, I am getting error code -22205 in the journal when I execute a
task.

Inside my DAS log says:

2005-07-04-06.31.46.394000-240 I71293H217 LEVEL: Error
PID : 1572 TID : 2328
FUNCTION: DB2 Tools, DB2 administration server, getProcess, probe:30
DATA #1 : Sint32, 4 bytes
-1879048173

2005-07-04-06.31.46.410000-240 I71512H217 LEVEL: Error
PID : 1572 TID : 2328
FUNCTION: DB2 Tools, DB2 administration server, handleStmRequest,
probe:90
DATA #1 : Sint32, 4 bytes
-4010

2005-07-04-06.31.46.426000-240 I71731H218 LEVEL: Error
PID : 1572 TID : 2328
FUNCTION: DB2 Tools, DB2 administration server, handleStmRequest,
probe:150
DATA #1 : Sint32, 4 bytes
-4010

Any idea of wha's going on?

Thanks
J

#2 (**permalink**) 02-27-2008, 04:12 AM

Purely guessing...

Don't know whether the following information would help or not.
sql22205 means DAS encountered an unexpected error. I am guessing that
-4010 is the cause of the problem where you have an illegal nesting of
Compound SQL statements.

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:

Problem description
SQLCODE or message number
SQLCA contents if possible
Trace file if possible

SQL4010N Illegal nesting of Compound SQL statements.
Explanation:
This error is returned when a BEGIN COMPOUND clause is detected as a
sub-statement of a Compound SQL statement.

User Response:
Resubmit the precompilation without the nested BEGIN COMPOUND.

#3 (**permalink**) 02-27-2008, 04:14 AM

joonw@yahoo.com wrote:
> Purely guessing...
>
> Don't know whether the following information would help or not.
> sql22205 means DAS encountered an unexpected error. I am guessing that
> -4010 is the cause of the problem where you have an illegal nesting of
> Compound SQL statements.
....
>
> SQL4010N Illegal nesting of Compound SQL statements.
> Explanation:
> This error is returned when a BEGIN COMPOUND clause is detected as a
> sub-statement of a Compound SQL statement.
>
> User Response:
> Resubmit the precompilation without the nested BEGIN COMPOUND.

Nope.

-4010 is the DAS internal error code for 'failed to create DAS process'
(no the DAS error codes aren't published externally...).
-1879048173, converted to hex, is 0x90000013 which is another internal
error corresponding to a timeout.

Unfortunately I can't find any closely related issues that have a
clear-cut resolution. Can you perform other tasks involving the DAS
(e.g. discovery) from the Control Center?

Andy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

-22205 return code from task center