Hi All

I am getting the following error when i use the activity monitor.
As far as i can see the problem seems to be with SP AM_GET_RPT
How do i resolve this?


Routine "*PPL_INFO" (specific name "") has returned an error
SQLSTATE with diagnostic text "SQL1013 Reason code or token:
DW ". SQLSTATE=38553

Explanation:

An SQLSTATE was returned to DB2 by routine "<routine-name>"
(specific name "<specific-name>"), along with message text
"<text>". The routine could be a user-defined function or a
user-defined method.

User Response:

The user will need to understand the meaning of the error. See
your Database Administrator, or the author of the routine.

Errors that are detected by the IBM supplied functions in the
SYSFUN schema all return the SQLSTATE 38552. The message text
portion of the message is of the form:


SYSFUN:nn


where nn is a reason code meaning:


01 Numeric value out of range

02 Division by zero

03 Arithmetic overflow or underflow

04 Invalid date format

05 Invalid time format

06 Invalid timestamp format

07 Invalid character representation of a timestamp duration

08 Invalid interval type (must be one of 1, 2, 4, 8, 16, 32, 64,
128, 256)

09 String too long

10 Length or position in string function out of range

11 Invalid character representation of a floating point number

12 Out of memory

13 Unexpected error

Errors that are detected by the IBM supplied routines in the
SYSIBM or SYSPROC schemas and IBM supplied procedures in the
SYSFUN schema all return the SQLSTATE 38553. The message text
portion of the message contains a message number that may be an
SQLCODE, (for example, SQL0572N), a DBA error message (for
example, DBA4747), or some other indication from the routine as
to what error was encountered. Note that if the message for the
message number would normally contain tokens, these token values
are only available in the db2diag.log file.

sqlcode : -443

sqlstate : (the SQLSTATE returned by the routine).




DISCLAIMER: This message may contain information which is confidential,
private or privileged in nature. If you are not the intended recipient, you
may not peruse, use, disseminate, distribute or copy this message or file
which is attached to this message. If you have received this message in
error, please notify the sender immediately by e-mail, facsimile or
telephone and thereafter return and/or destroy the original message. Any
views of this communication are those of the sender except where the sender
specifically states them to be those of TransUnion ITC(Proprietary) Limited.
Please note that the recipient must scan this e-mail and any attached files
for viruses and the like. While we do everything possible to protect
information from viruses, TransUnion ITC accepts no liability of whatever
nature for any loss, liability, damage or expense resulting directly or
indirectly from the access and/or downloading of any files which are
attached to this e-mail message.



DB2 & UDB email list listserv db2-l LazyDBA home page