IC91036: DYNAMIC SQL SNAPSHOTS MAY EXIT WITH SQLO_DBCSTRUNC ERROR

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • APAR IC74008 may prevent certain statements from getting
    properly stored in the package cache. As a result, when a
    dynamic sql snapshot operation fetches such statements and tries
    to do code page conversion (because the application code page is
    different from database code page), it receives a truncation
    error because the last few characters at the end of such
    statements were invalid. This causes the snapshot invocation to
    exit with SQLO_DBCSTRUNC error (seen in db2diag.log).
    
    Example :
    - db2 get snapshot for dynamic sql on <dbname>
    - Quering SYSIBMADM.SNAPDYN_SQL :
      db2 "SELECT  NUM_EXECUTIONS "NUM EXECS" ,TOTAL_EXEC_TIME "EXEC
    TIME" , TOTAL_USR_CPU_TIME "USER CPU TIME" ,TOTAL_SYS_CPU_TIME
    "SYS CPU TIME", round((total_usr_cpu_time +
    total_sys_cpu_time)/num_executions,3) "Cpu (s)/execution",
    cast(STMT_TEXT as varchar(5000)) "SQL_TEXT" FROM
    SYSIBMADM.SNAPDYN_SQL where total_usr_cpu_time > 2 and
    num_executions > 5 order by total_usr_cpu_time desc"
    
    On command line prompt you will see :
    SQL1224N  The database manager is not able to accept new
    requests, has terminated all requests in progress, or has
    terminated the specified request because of an error or a forced
    interrupt.  SQLSTATE=55032
    
    In db2diag.log you will see :
    
    2013-01-30-08.36.11.657111+480 I8342394A488       LEVEL: Severe
    PID     : 5505504              TID  : 96123       PROC : db2sysc
    0
    INSTANCE: db2inst1             NODE : 000
    APPHDL  : 0-63253              APPID:
    *LOCAL.db2inst1.130130003612
    AUTHID  : DB2INST1
    EDUID   : 96123                EDUNAME: db2agent (instance) 0
    FUNCTION: DB2 UDB, database monitor, sqlm_generic_convert,
    probe:60
    RETCODE : ZRC=0x870F00C0=-2029059904=SQLO_DBCSTRUNC
              "last unconverted char is truncated"
    

Local fix

  • NA
    

Problem summary

  • APAR IC74008 may prevent certain statements from getting
    properly stored in the package cache. As a result, when a
    dynamic sql snapshot operation fetches such statements and tries
    to do code page conversion (because the application code page is
    different from database code page), it receives a truncation
    error because the last few characters at the end of such
    statements were invalid. This causes the snapshot invocation to
    exit with SQLO_DBCSTRUNC error (seen in db2diag.log).
    
    Example :
    - db2 get snapshot for dynamic sql on <dbname>
    - Quering SYSIBMADM.SNAPDYN_SQL :
      db2 "SELECT  NUM_EXECUTIONS "NUM EXECS" ,TOTAL_EXEC_TIME "EXEC
    TIME" , TOTAL_USR_CPU_TIME "USER CPU TIME" ,TOTAL_SYS_CPU_TIME
    "SYS CPU TIME", round((total_usr_cpu_time +
    total_sys_cpu_time)/num_executions,3) "Cpu (s)/execution",
    cast(STMT_TEXT as varchar(5000)) "SQL_TEXT" FROM
    SYSIBMADM.SNAPDYN_SQL where total_usr_cpu_time > 2 and
    num_executions > 5 order by total_usr_cpu_time desc"
    
    On command line prompt you will see :
    SQL1224N  The database manager is not able to accept new
    requests, has terminated all requests in progress, or has
    terminated the specified request because of an error or a forced
    interrupt.  SQLSTATE=55032
    
    In db2diag.log you will see :
    
    2013-01-30-08.36.11.657111+480 I8342394A488       LEVEL: Severe
    PID     : 5505504              TID  : 96123       PROC : db2sysc
    0
    INSTANCE: db2inst1             NODE : 000
    APPHDL  : 0-63253              APPID:
    *LOCAL.db2inst1.130130003612
    AUTHID  : DB2INST1
    EDUID   : 96123                EDUNAME: db2agent (instance) 0
    FUNCTION: DB2 UDB, database monitor, sqlm_generic_convert,
    probe:60
    RETCODE : ZRC=0x870F00C0=-2029059904=SQLO_DBCSTRUNC
              "last unconverted char is truncated"
    

Problem conclusion

  • First fixed in DB2 Version 9.7 Fix Pack 9.
    

Temporary fix

  • NA
    

Comments

APAR Information

  • APAR number

    IC91036

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-03-22

  • Closed date

    2014-07-22

  • Last modified date

    2014-07-22

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    IC96026 IC96273 IC96308 IC96311 IC96312 IC96313 IC96314 IC96315
    IC96316 IC96317 IC96318 IC96319 IC96320 IC96321 IC96322 IC96323
    IC96324 IC96325 IC96326

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSY

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

9.7

Reference #:

IC91036

Modified date:

2014-07-22

Translate my page

Machine Translation

Content navigation