Skip to Content
avatar image
Former Member

Reorgchk_All ADBC error

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Dec 16, 2009 at 02:22 PM

    Hello Paulo,

    could you please provide the sm21 log entries.

    Regards

    Olaf

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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.

  • avatar image
    Former Member
    Dec 16, 2009 at 02:47 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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.

  • Dec 16, 2009 at 04:29 PM

    Hi Paulo,

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

    Regards

    Frank

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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