PM63849: INSERT SQL GOT ABEND04E RC00C90101 DSNISRTI:5363 BECAUSE INSERT PROC (IPROC) DID NOT WORK CORRECTLY.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• INSERT sql got abend04e rc00c90101 dsnisrti:5363 because
  Assemble Optimized Version insert proc (iproc, DSNIZAZ2) did not
  work correctly and overlaid coverted field in RRF.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: DB2 for z/OS version 10 users of static SQL  *
  *                 INSERT statements against an ASCII or        *
  *                 UNICODE table in Reordered Record Format     *
  *                 (RRF), when the SQL INSERT uses default      *
  *                 values of USER or CURRENT SQLID registers    *
  ****************************************************************
  * PROBLEM DESCRIPTION: Column value overlay or truncation is   *
  *                      possible if the INSERT fills columns    *
  *                      with default value USER or CURRENT      *
  *                      SQLID. Various kinds of symptoms might  *
  *                      occur, such as ABEND04E DSNISRTI        *
  *                      ERQUAL5363.                             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  DB2 10 introduced bind time Insert Procs (IProcs) in plans/
  packages (before they were only built at runtime). If the
  following conditions are true, an incorrect bind time IProc can
  be built:
  
   1. The table's encoding scheme is UNICODE or ASCII.
  
   2. The table has column(s) with default value USER or CURRENT
      SQLID.
  
  The bind time IProc would be incorrect in the sense that it
  would contain the bind time values of special registers USER
  and CURRENT SQLID, when it should have had their runtime values.
  The bind time length of USER and CURRENT SQLID registers is
  different from runtime, so the IProc might populate the default
  value with an incorrect length, which during SQL INSERT could
  cause overlay or truncation if the insert populates such
  columns with their default values.
  
  If the SQL INSERT does not abend and goes through, subsequently
  incorrout is possible though no such case has actually been
  reported at the time of writing.
  

Problem conclusion

• DB2 code has been fixed to build bind time IProcs in a way that
  they do not pick up the USER and CURRENT SQLID register values
  until runtime (execution time).
  
  Additional keywords: SQLINSERT SMCOVERLAY DB2OVRLAY/K
                       SQLINCORR SQLINCORROUT DB2INCORR/K
  

Temporary fix

• *********
  * HIPER *
  *********
  

Comments

• ž**** PE12/08/02 FIX IN ERROR. SEE APAR PM66487  FOR DESCRIPTION
  

APAR Information

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

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

  UK79943

Modules/Macros

• DSNIZAZ2
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK79943

     UP12/07/14 P F207

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.