2082410 - DB6: SQL2310N The utility could not generate statistics | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2082410 - DB6: SQL2310N The utility could not generate statistics

Symptom

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

The ABAP short dump looks as follows:

Example

-------------------------------------------------------------------------------------------------------
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)
-------------------------------------------------------------------------------------------------------

Read more...

Environment

SAP on IBM Db2 for Linux, UNIX, and Windows

Keywords

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 with DB2 Universal Database , Problem

About this page

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

Search for additional results

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