cancel
Showing results for 
Search instead for 
Did you mean: 

Reorgchk_All ADBC error

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (3)

Answers (3)

Frank-Martin
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Paulo,

please check if note 1011191 or note 1378499 applies to your problem.

Regards

Frank

Former Member
0 Kudos

Thank you again, Frank!

Former Member
0 Kudos

Hi Paulo,

Could you please let us know how the issue was solved?

I am facing the same issue with my Reorg Job.

Thanks

Nagaraja

Thomas_Matthä
Employee
Employee
0 Kudos

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

Former Member
0 Kudos

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.

Former Member
0 Kudos

Hello Paulo,

could you please provide the sm21 log entries.

Regards

Olaf

Former Member
0 Kudos

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.