PI51401: MISSING <LHS> </LHS> AND<RHS> </RHS> TAGS FOR NULL TOLERANT PREDICATE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DataStudio has error message shown as "The XML format is not
  correct. XML
                                  tag WHERE-CLAUSE cannot be
  followed by tag OP."
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 11 for z/OS users of EXPLAIN.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using DB2 for z/OS EXPLAIN,        *
  *                      the data in the NODE_DATA column of the *
  *                      DSN_QUERY_TABLE may have missing        *
  *                      <LHS></LHS> tags for the left hand side *
  *                      predicate of the OR operator and        *
  *                      <RHS></RHS> tags for the IS NULL        *
  *                      predicate that is on the right side     *
  *                      of the OR operator when                 *
  *                      QUERY_STAGE=AFTER.                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The data in the NODE_DATA column of the DSN_QUERY_TABLE may have
  missing <LHS></LHS> tags for the left hand side predicate
  of the OR operator and <RHS></RHS> tags for the IS NULL
  predicate that is on the right side of the OR operator when
  QUERY_STAGE=AFTER.
  
  For example:
  
    EXPLAIN ALL SET QUERYNO = 001 FOR
    SELECT * FROM T1
       WHERE T1.C1 > 1 OR T1.C1 IS NULL;
  
  
  Here is the output for the NODE_DATA before the fix:
  
  ...
  <PREDICATE PNO='1' ACSCTRL='U' CORR = 'N' VTHIDE = 'N'>
  <LHS><COLUMN TNO='1'>
  &quot;SYSADM&quot;.&quot;T1&quot;.&quot;C1&quot;</COLUMN>
  </LHS><OP>&gt;</OP><RHS> <LIT VALUE='1'>?</LIT>
  </RHS></PREDICATE><OP> OR </OP>
  <PREDICATE><COLUMN TNO='1'>
  &quot;SYSADM&quot;.&quot;T1&quot;.&quot;C1&quot;</COLUMN>
  <OP> IS NULL</OP>
  </PREDICATE>...
  
  
  Here is the output for the NODE_DATA after the fix:
  
  ...<PREDICATE PNO='1' ACSCTRL='U'><LHS>
  <PREDICATE PNO='1' ACSCTRL='U' CORR = 'N' VTHIDE = 'N'>
  <LHS><COLUMN TNO='1'>
  &quot;SYSADM&quot;.&quot;T1&quot;.&quot;C1&quot;</COLUMN>
  </LHS><OP>&gt;</OP><RHS> <LIT VALUE='1'>?</LIT>
  </RHS></PREDICATE></LHS><OP> OR </OP><RHS>
  <PREDICATE><COLUMN TNO='1'>
  &quot;SYSADM&quot;.&quot;T1&quot;.&quot;C1&quot;</COLUMN>
  <OP> IS NULL</OP></PREDICATE></RHS>
  </PREDICATE>...
  
  Additional keywords:
  SQLEXPLAIN SQLNULL
  

Problem conclusion

• DB2 code has been updated to resolve the problem described
  above.
  

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:

  UI35513

Modules/Macros

• DSNXODTX
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RB10 PSY UI35513

     UP16/03/05 P F603

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.