DB2 UDB on AIX - How to interpret db2diag.log error codes?

Lydia Lee

DB2 UDB on AIX - How to interpret db2diag.log error codes?
We are running DB2 UDB 8.1.1 fix pack 11 on AIX 5.3. Where can I go to look
up error codes found in db2diag.log? For the error listed below, I tried
searching for ZRC=0xFFFFFB38=-1224 on
http://www-306.ibm.com/software/data/db2/udb/support/ but I could not find
anything.

2006-11-26-23.02.17.900260-480 I2065156A321 LEVEL: Error
PID : 843786 TID : 1178 PROC : db2hmon 0
INSTANCE: db2dss NODE : 000
APPID : *LOCAL.db2dss.061127070111
FUNCTION: DB2 UDB, Automatic Table Maintenance, AtmTable::iter_action,
probe:610
MESSAGE : ZRC=0xFFFFFB38=-1224

Thanks.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

James Campbell

Re: DB2 UDB on AIX - How to interpret db2diag.log error codes?
(in response to Lydia Lee)
Possibly sqlcode = -1224 "A database agent could not be started to service a request, or
was terminated as a result of a database system shutdown or a force command. "

Does this seem likely?

James Campbell

On 28 Nov 2006 at 16:33, Lydia Lee wrote:

> We are running DB2 UDB 8.1.1 fix pack 11 on AIX 5.3. Where can I go to look
> up error codes found in db2diag.log? For the error listed below, I tried
> searching for ZRC=0xFFFFFB38=-1224 on
> http://www-306.ibm.com/software/data/db2/udb/support/ but I could not find
> anything.
>
> 2006-11-26-23.02.17.900260-480 I2065156A321 LEVEL: Error
> PID : 843786 TID : 1178 PROC : db2hmon 0
> INSTANCE: db2dss NODE : 000
> APPID : *LOCAL.db2dss.061127070111
> FUNCTION: DB2 UDB, Automatic Table Maintenance, AtmTable::iter_action,
> probe:610
> MESSAGE : ZRC=0xFFFFFB38=-1224
>
> Thanks.
>
> ---------------------------------------------------------------------------------
> Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Lydia Lee

Re: DB2 UDB on AIX - How to interpret db2diag.log error codes?
(in response to James Campbell)
Hi James,

Thanks a lot for the reply. Looks like the database is up as there are
normal messages right before and after the error. I wonder what is
iter_action?

2006-11-26-23.02.17.899937-480 I2064811A344 LEVEL: Event
PID : 843786 TID : 1443 PROC : db2hmon 0
INSTANCE: db2dss NODE : 000
FUNCTION: DB2 UDB, Automatic Table Maintenance, AtmTable::runstats,
probe:900
STOP : Automatic Runstats: runstats completed successfully on table
"SAPDSS "."AGR_AGRS2"

2006-11-26-23.02.17.900260-480 I2065156A321 LEVEL: Error
PID : 843786 TID : 1178 PROC : db2hmon 0
INSTANCE: db2dss NODE : 000
APPID : *LOCAL.db2dss.061127070111
FUNCTION: DB2 UDB, Automatic Table Maintenance, AtmTable::iter_action,
probe:610
MESSAGE : ZRC=0xFFFFFB38=-1224

2006-11-26-23.02.17.947806-480 I2065478A371 LEVEL: Event
PID : 843786 TID : 1445 PROC : db2hmon 0
INSTANCE: db2dss NODE : 000
APPID : *LOCAL.db2dss.061127070227
FUNCTION: DB2 UDB, Automatic Table Maintenance, AtmTable::runstats,
probe:500
START : Automatic Runstats: runstats has started on table "SAPDSS
"."TSPOPTIONS"

Lydia

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Derez D Lusk

Re: DB2 UDB on AIX - How to interpret db2diag.log error codes?
(in response to Lydia Lee)
Based on the last two days, the job executed in CA7 using the previous
day's file, before the file was NDM'ed.

Can you verify if the time trigger overrided the DSN trigger ?
yesterday and today



DEREZ LUSK
ENTERPRISE DATA LAYER / MARS
HTSU Corporate CIM
1501 Feehanville Drive
Mount Prospect, IL 60056
(0) 847-824-2871
(P) 866-203-3513
(F) 847-824-3171




Lydia Lee
<[login to unmask email]>
Sent by: DB2 Data Base To
Discussion List [login to unmask email]
<[login to unmask email]> cc

Subject
11/29/2006 11:19 AM Re: [DB2-L] DB2 UDB on AIX - How to
interpret db2diag.log error codes?

Please respond to
DB2 Database Discussion
list at IDUG
<[login to unmask email]
>






Hi James,

Thanks a lot for the reply. Looks like the database is up as there are
normal messages right before and after the error. I wonder what is
iter_action?

2006-11-26-23.02.17.899937-480 I2064811A344 LEVEL: Event
PID : 843786 TID : 1443 PROC : db2hmon 0
INSTANCE: db2dss NODE : 000
FUNCTION: DB2 UDB, Automatic Table Maintenance, AtmTable::runstats,
probe:900
STOP : Automatic Runstats: runstats completed successfully on table
"SAPDSS "."AGR_AGRS2"

2006-11-26-23.02.17.900260-480 I2065156A321 LEVEL: Error
PID : 843786 TID : 1178 PROC : db2hmon 0
INSTANCE: db2dss NODE : 000
APPID : *LOCAL.db2dss.061127070111
FUNCTION: DB2 UDB, Automatic Table Maintenance, AtmTable::iter_action,
probe:610
MESSAGE : ZRC=0xFFFFFB38=-1224

2006-11-26-23.02.17.947806-480 I2065478A371 LEVEL: Event
PID : 843786 TID : 1445 PROC : db2hmon 0
INSTANCE: db2dss NODE : 000
APPID : *LOCAL.db2dss.061127070227
FUNCTION: DB2 UDB, Automatic Table Maintenance, AtmTable::runstats,
probe:500
START : Automatic Runstats: runstats has started on table "SAPDSS
"."TSPOPTIONS"

Lydia

---------------------------------------------------------------------------------

Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org
. The IDUG List Admins can be reached at [login to unmask email]
Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm

-----------------------------------------
******************************************************************
This message originated from the Internet. Its originator may or
may not be who they claim to be and the information contained in
the message and any attachments may or may not be accurate.
******************************************************************



-----------------------------------------
******************************************************************
This E-mail is confidential. It may also be legally privileged. If
you are not the addressee you may not copy, forward, disclose or
use any part of it. If you have received this message in error,
please delete it and all copies from your system and notify the
sender immediately by return E-mail.

Internet communications cannot be guaranteed to be timely, secure,
error or virus-free. The sender does not accept liability for any
errors or omissions.
******************************************************************
SAVE PAPER - THINK BEFORE YOU PRINT!

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm