on 12-16-2009 2:09 PM
Hello Guys,
I am facing error for Reorgchk_All job scheduled by DBA Planning Calendar as bellow:
Reorgck_All:SQL statement CALL REORGCHK_IX_STATS(?,?) failed with SQL error 99999
Reorgck_All:CLI0111E Numeric value out of range. SQLSTATE=22003 row=1 col=17
Exception CX_DB6_CON in program CL_DB6_RDI====================CP / CL_DB6_RDI====================CM008 at line ADBC error with r
Reorgck_All:REORGCHK failed
REASON=ADBC error
I got no information from db2diag.log reagarding this.
Does anyone have any clue about how to solve it?
Thanks,
Paulo.
Hi Paulo,
please check if note 1011191 or note 1378499 applies to your problem.
Regards
Frank
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Paolo,
I assume, that this error is caused by the changed resultset of the REORGCHK_IX_STATS stored procedure
in DB2 9.7 compared to earlier releases! So do you use DB2 9.7 ? What is your SAP Release and SP level ?
kind regards
Thomas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Thomas,
Please, find below the information you asked for:
SAP Release: sap 2004s release 7.0
DB2 Release:
DB21085I Instance "db2x11" uses "64" bits and DB2 code release "SQL09010" with
level identifier "02010107".
Informational tokens are "DB2 v9.1.0.0", "s060629", "AIX64", and Fix Pack "0".
Product is installed at "/usr/opt/db2_09_01".
Stored Procedure Information:
PROCSCHEMA SYSPROC
PROCNAME REORGCHK_IX_STATS
SPECIFICNAME REORGCHK_IX_STATS
PROCEDURE_ID 65813
DEFINER SYSIBM
PARM_COUNT 2
PARM_SIGNATURE x'003C0038'
ORIGIN E
CREATE_TIME 2007-10-18-19.26.44.195548
DETERMINISTIC N
FENCED Y
NULLCALL Y
LANGUAGE C
IMPLEMENTATION db2dbroutext!reorgchk_ix_stats
Please, just let me know if you need any additional informaition.
Best Regards,
Paulo.
Hello Paulo,
could you please provide the sm21 log entries.
Regards
Olaf
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Olaf,
Please, find below the SM21 log results:
Details Page 2 Line 8 System Log: Local Analysis of mysapsan 1
-
Time | Type | Nr | Clt | User | TCode | Grp | N | Text |
-
00:04:05 | BTC | 010 | 001 | RG04077 | BY | 2 | Database error -99999 at FET |
-
Database error -99999 at FET
Details
Recording at local and central time........................ 12/16/2009 00:04:05
-
Task...... | Process | User...... | Terminal | Session | TCode | Program | Cl | Problem cl | Package |
-
88480 | Background Processor No. 010 | RG04077 | 1 | RSDB6RSTATS | K | SAP Web AS Problem | SBAC |
-
-
Module nam | Line | Table Name | Field Name |
-
dbds | 592 | -99999 | FET |
-
-
Documentation for system log message BY 2 : |
After the attempt to call a database operation, the database system has |
returned the error code specified in the message, which indicates that |
the operation concerned could not be executed successfully. |
-
Technical details
-
File | Offset | RecFm | System log type | Grp | N | variable message data |
-
23 | 333720 | h | Database Error (Non-SQL) | BY | 2 | -99999 FET dbds 592 |
-
Details Page 2 Line 9 System Log: Local Analysis of mysapsan 1
-
Time | Type | Nr | Clt | User | TCode | Grp | N | Text |
-
00:04:05 | BTC | 010 | 001 | RG04077 | BY | 1 | Database error -99999 |
-
Database error -99999
Details
Recording at local and central time........................ 12/16/2009 00:04:05
-
Task...... | Process | User...... | Terminal | Session | TCode | Program | Cl | Problem cl | Package |
-
88480 | Background Processor No. 010 | RG04077 | 1 | RSDB6RSTATS | K | SAP Web AS Problem | SBAC |
-
-
Module nam | Line | Table Name | Field Name |
-
dbacds | 1433 | -99999 |
-
-
Documentation for system log message BY 1 : |
When calling up a database operation the database system underlying the |
SAP system has returned an error code which indicates that the operation |
in question could not be carried out successfully. |
-
Technical details
-
File | Offset | RecFm | System log type | Grp | N | variable message data |
-
23 | 334260 | h | Database Error (Non-SQL) | BY | 1 | -99999 dbacds 1433 |
-
Please, just let me know if you need anything else.
Regards,
Paulo.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.