PH64658: DSNT408I SQLCODE = -20398, ERROR: ERROR ENCOUNTERED DURING XML PARSING

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Customers are editing a DB2 table which contains XML column(s).
  While the XML column has not been changed, an update attempt
  of a row end with the following SQL error:
  
  Release=11.7.0, DB2Rel=1215(NFM)
                Encountered the SQL Error Described Below
  
  DSNT408I SQLCODE = -20398, ERROR:  ERROR ENCOUNTERED DURING XML
           PARSING
           AT LOCATION 1 An incorrect character is found within
           markup.RC=000C,RSN=3029.
  DSNT418I SQLSTATE   = 2200M SQLSTATE RETURN CODE
  DSNT415I SQLERRP    = DSNNONPR SQL PROCEDURE DETECTING ERROR
  DSNT416I SQLERRD    = -490  0  0  -1  0  0 SQL DIAGNOSTIC
                                             INFORMATION
  DSNT416I SQLERRD    = X'FFFFFE16'  X'00000000'  X'00000000'
           X'FFFFFFFF'  X'00000000'  X'00000000' SQL DIAGNOSTIC
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Optim users editing DB2 tables with XML or   *
  *                 LOB columns.                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: See Error Description.                  *
  ****************************************************************
  Optim is incorrectly processing XML and LOB data during DB2
  table edit in scenarios when the XML or LOB column has not been
  updated.
  

Problem conclusion

• Optim processing will be corrected.
  

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:

  UI99692

Modules/Macros

• FOP00003 FOP00103 FOP00203 FOP00303 FOP00B   FOP01B   FOP05B
  FOP07B   FOP08B   FOP09B   FOP0AB   FOP0BB   FOP0DAUE FOP0ITKA
  FOP1ODRV FOP1OSFN FOP1XTRN FOP2RRSQ FOP3DTPR FOP4IPMN FOP4PEMN
  FOP4PMMN FOP4TRCE FOP9APIM FOP9GINF FOPCFPMN FOPCXLIB FOPHSTM
  FOPIO    FOPK05   FOPMACAS FOPMADDE FOPMAFCN FOPMAIN  FOPMAMAI
  FOPMARCN FOPMCBMN FOPMCDRT FOPMCENU FOPMCMAI FOPMCMMN FOPMCOFN
  FOPMCOLA FOPMCOLP FOPMDBMN FOPMDDDL FOPMDMAI FOPMDPRC FOPMDXTR
  FOPMECMN FOPMEMAI FOPMIXMM FOPMMCMN FOPMMCMR FOPMMJBS FOPMMUNU
  FOPMMUTL FOPMSELM FOPMSORT FOPMTMDB FOPMUXIM FOPODPP  FOPOMN
  FOPRS9   FOPUBMC  FOPUIAUL FOPUMCBT FOPUUNLD FOPVOU   FOPZFBMN
  FOPZFMMN FOPZMAIN FOPZSUB
  

Fix information

• Fixed component name

  OPTIM MOVE FOR

• Fixed component ID

  5655V0700

Applicable component levels

• RB70 PSY UI99692

     UP25/01/22 P F501

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.