PI68311: INSERT OF XML DATA ENDS WITH ERROR DSNT400I SQLCODE = 000

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Customer is performing INSERT of DB2 data, including XML
  columns, and receives teh following system error:
  
  IBM InfoSphere Optim System Error Structure - ErrCB
  
  ErrCB.ID=      ZZZERRCBZZ
  
  SysRel=        7.2.0
  
  DB2Rel=        1115(NFM)
  
  ErrCB.Type=    DB2 SQL ERROR
  
  ErrCB.AuxInfo=
  
  ErrCB.Code=    -9999
  
   DSNT408I SQLCODE =  -9999, SQLSTATE =
  
            ?                                               TOKENS
  
            DSDB2V85 - NO LOB VALUE SUPPLIED
  
  Number of Function Entries=  7
  
    ErrCB.N(0).Src=     FOPQ     20160811 UI39944
  
    ErrCB.N(0).Func=    (002455) DSQLIntExecStmt
  
    ErrCB.N(1).Src=     FOPSDUMP 20160616 COPYSEND
  
    ErrCB.N(1).Func=    (000247) ErrFmtDB2Msg
  
    ErrCB.N(2).Src=     FOPJINS  20160621 UI38701
  
    ErrCB.N(2).Func=    (003828) GetDPError
  
    ErrCB.N(3).Src=     FOPJINS  20160621 UI38701
  
    ErrCB.N(3).Func=    (005489) BuildInsertReport
  
    ErrCB.N(4).Src=     FOPUREST 20160616 COPYSEND
  
    ErrCB.N(4).Func=    (005313) InsertStatement
  
    ErrCB.N(5).Src=     FOPUMAIN 20160616 COPYSEND
  
    ErrCB.N(5).Func=    (000798) FOPMMUTL_dynamn
  
    ErrCB.N(6).Src=     FOPMMAIN 20160719 UI39350
  
    ErrCB.N(6).Func=    (000975) Main
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Optim users performing Insert/Update with tables that        *
  * contain XML columns.                                         *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Users may see the following failures:                        *
  * IBM InfoSphere Optim System Error Structure - ErrCB          *
  *                                                              *
  * ErrCB.ID=      ZZZERRCBZZ                                    *
  *                                                              *
  * SysRel=        7.2.0                                         *
  *                                                              *
  * DB2Rel=        1115(NFM)                                     *
  *                                                              *
  * ErrCB.Type=    DB2 SQL ERROR                                 *
  *                                                              *
  * ErrCB.AuxInfo=                                               *
  *                                                              *
  * ErrCB.Code=    -9999                                         *
  *                                                              *
  *  DSNT408I SQLCODE =  -9999, SQLSTATE =                       *
  *                                                              *
  *           ?                                                  *
  * TOKENS                                                       *
  *           DSDB2V85 - NO LOB VALUE SUPPLIED                   *
  *                                                              *
  * Number of Function Entries=  7                               *
  *                                                              *
  *   ErrCB.N(0).Src=     FOPQ     20160811 UI39944              *
  *                                                              *
  *   ErrCB.N(0).Func=    (002455) DSQLIntExecStmt               *
  *                                                              *
  *   ErrCB.N(1).Src=     FOPSDUMP 20160616 COPYSEND             *
  *                                                              *
  *   ErrCB.N(1).Func=    (000247) ErrFmtDB2Msg                  *
  *                                                              *
  *   ErrCB.N(2).Src=     FOPJINS  20160621 UI38701              *
  *                                                              *
  *   ErrCB.N(2).Func=    (003828) GetDPError                    *
  *                                                              *
  *   ErrCB.N(3).Src=     FOPJINS  20160621 UI38701              *
  *                                                              *
  *   ErrCB.N(3).Func=    (005489) BuildInsertReport             *
  *                                                              *
  *   ErrCB.N(4).Src=     FOPUREST 20160616 COPYSEND             *
  *                                                              *
  *   ErrCB.N(4).Func=    (005313) InsertStatement               *
  *                                                              *
  *   ErrCB.N(5).Src=     FOPUMAIN 20160616 COPYSEND             *
  *                                                              *
  *   ErrCB.N(5).Func=    (000798) FOPMMUTL_dynamn               *
  *                                                              *
  *   ErrCB.N(6).Src=     FOPMMAIN 20160719 UI39350              *
  *                                                              *
  *   ErrCB.N(6).Func=    (000975) Main                          *
  *                                                              *
  *                                                              *
  *   They may also see:                                         *
  *    *** The Following Error was Encountered during            *
  * UPDATE/INSERT Processing ***                                 *
  *                                                              *
  *                                                              *
  *      The Following SQL Error was Encountered:                *
  *                                                              *
  *        DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply this fix.                                              *
  ****************************************************************
  When performing Inserts on tables that contain XML larger than
  4K, and a row is reprocessed client may see a number of failures
  related to lob locators not being available.  When the original
  request fails, for example Process Mode BOTH is chosen, and
  keyed update fails to match key, Optim will try the request
  again with an Insert instead of update. DB2 removes the
  reference to the XML file after a request, so Optim tries to
  process the row with the erroneous assumption that the XML data
  was stored in a LOB locator.
  

Problem conclusion

• Optim will check if XML external data needs to be recreated and
  and prepare the row for reprocessing by rebuilding the RBA data
  for that XML column and recreate an XML file member before
  performing the Insert.
  

Temporary fix

Comments

APAR Information

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

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

  PI68312

Modules/Macros

• FOPMMUNU FOPHSTM  FOPOMN   FOPZMAIN FOPCFPMN FOPMCMAI FOP9APIM
  FOPMAIN
  

Fix information

• Fixed component name

  OPTIM MOVE FOR

• Fixed component ID

  5655V0700

Applicable component levels

• R720 PSY UI40776

     UP16/09/15 P F609

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.