SAP Knowledge Base Article - Preview

2082410 - DB6: SQL2310N The utility could not generate statistics


The job E2E_HK_CONTROLLER is cancelled with an ABAP TIME_OUT short dump.

The ABAP short dump looks as follows:


Category                        ABAP Programming Error            
Runtime errors                 TIME_OUT            
ABAP Programe                CX_SQL_EXCEPTION==============CP            
Responsible component     BC-DB-DBI    

Short text                                
        Time limit exceeded.                            
What happened?                                
        The program "CX_SQL_EXCEPTION==============CP" has exceeded the maximum permitted runtime without interruption and has therefore been terminated.                            

Client.............. xxx
User................ "SOLMAN_BTC"
Transaction......... " "
Call Program........."SAPLE2E_EFWK_HOUSEKEEPING"
Function Module..... "SMD_HK_AGGREGATE_MDX"

The relevant work process trace (ST11) shows the following error:

C  *** ERROR in DB6Open[dbdb6.c, 3588] CON = 1 (BEGIN)
C  &+***      dsql_db6_open( SQLExecute ): [IBM][CLI Driver][DB2/AIX64] SQL2310N  The utility could not generate statistics. Error "-911" was returned row=1
C  &+***      CALL ADMIN_CMD(?) /* RUNSTATS */
C  &+***        cursor type=NO_HOLD, isolation=UR, cc_release=YES, optlevel=5, degree=1, op_type=24, read_only=0
C  &+***        ABAP location info: 'CL_SQL_STATEMENT==============CP', 468
C  &+***
C  &+***      Input SQLDA:
C  &+***                         1 CT=WCHAR           T=VARCHAR         L=272   P=272   S=0
C  &+***
C  &+***      Input data:
C  &+***      row 1:             1 WCHAR           I=272     "runstats on table SAP<SID>."/BI0/xxxxxxxxxx" on all columns with d"...
C  &+***
C  &+***      ABAP location info 'CL_SQL_STATEMENT==============CP', 468
C  &+***
C  *** ERROR in DB6Open[dbdb6.c, 3588] (END)



SAP on IBM Db2 for Linux, UNIX, and Windows


E2E_HK_CONTROLLER, SAPLE2E_EFWK_HOUSEKEEPING, RUNSTATS, LOCK, -911, SQL0911N, DB6. -911 , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , BC-DB-DB6-DBA , Database Administration , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.