IC96273: DYNAMIC SQL SNAPSHOTS MAY EXIT WITH SQLO_DBCSTRUNC ERROR

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as duplicate of another APAR.

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

Problem conclusion

Temporary fix

Comments

  • This APAR is a duplicate of IC96026
    

APAR Information

  • APAR number

    IC96273

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    A10

  • Status

    CLOSED DUA

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-09-26

  • Closed date

    2014-05-09

  • Last modified date

    2014-07-22

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

    IC91036

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

Fix information

Applicable component levels



Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

10.1

Reference #:

IC96273

Modified date:

2014-07-22

Translate my page

Machine Translation

Content navigation