PH24967: BATCH EXPLAIN SQL204 ERROR ON STATEMENT WITH TABLE NAME WRAPPINGOVER TWO ROWS

5.4.0-TIV-KD5-FP0027.zip
5.4.0-TIV-KD5-FP0027.tar.gz
5.4.0-TIV-KD5-FP0027.README
5.4.0-TIV-KD5-LP0021.zip
5.4.0-TIV-KD5-LP0021.tar
5.4.0-TIV-KD5-FP0026.zip
5.4.0-TIV-KD5-FP0026.tar.gz
5.4.0-TIV-KD5-FP0026.README
5.4.0-TIV-KD5-FP0025.zip
5.4.0-TIV-KD5-FP0025.tar.gz
5.4.0-TIV-KD5-FP0025.README
5.4.0-TIV-KD5-FP0023.zip
5.4.0-TIV-KD5-FP0023.tar.gz
5.4.0-TIV-KD5-FP0023.README
5.4.0-TIV-KD5-FP0022.zip
5.4.0-TIV-KD5-FP0022.tar.gz
5.4.0-TIV-KD5-FP0022.README
5.4.0-TIV-KD5-FP0021.tar.gz
5.4.0-TIV-KD5-FP0021
5.4.0-TIV-KD5-FP0021.README
5.4.0-TIV-KD5-FP0020.zip
5.4.0-TIV-KD5-FP0020.tar.gz
5.4.0-TIV-KD5-FP0020.README
5.4.0-TIV-KD5-FP0019.zip
5.4.0-TIV-KD5-FP0019.tar.gz
5.4.0-TIV-KD5-FP0019.README
5.4.0-TIV-KD5-FP0018.zip
5.4.0-TIV-KD5-FP0018.tar.gz
5.4.0-TIV-KD5-FP0018.README
Tivoli OMEGAMON XE for DB2 on z/OS 5.4.0-TIV-KD5-FP0018
Tivoli OMEGAMON XE for DB2 on z/OS 5.4.0-TIV-KD5-FP0019
Tivoli OMEGAMON XE for DB2 on z/OS 5.4.0-TIV-KD5-FP0020
Tivoli OMEGAMON XE for DB2 on z/OS 5.4.0-TIV-KD5-FP0021
Tivoli OMEGAMON XE for DB2 on z/OS 5.4.0-TIV-KD5-FP0022
OMEGAMON XE for DB2 on z/OS 5.4.0-TIV-KD5-FP0023

APAR status

• Closed as program error.

Error description

• Batch explain SQL204 error on statement with table name wrapping
  over two rows
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: PE Server Subtask                            *
  *                 PWH                                          *
  *                 Explain                                      *
  *                 Classic Interface                            *
  *                 Enhanced 3270 UI                             *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1.Long table name in explain is parsed  *
  *                      Incorrectly.                            *
  *                      2.Support unqualified table in SQLPA    *
  ****************************************************************
  * RECOMMENDATION: Apply the provided PTF.                      *
  ****************************************************************
  1. Statement with table name wraping over two rows returns
  syntax error in explain.
  2. SQLPA returns -204 when unqualified table is used in query.
  

Problem conclusion

• 1.Correct long table name parser error.
  2.Support unqualified table name in SQLPA by setting
  BATSQLID=YES in RKD2PAR(OMPEOPTS).
  
  Search Keywords:
  < SQLPA -204 OMPEOPTS BATSQLID Explain >
  

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:

Modules/Macros

• DGOFEDPM DGOVMSTR DGOZBEXP DGOZPC2  DGOZSQPA KD5AGENT KDPATR
  KDPBAR   KDPCAT   KDPDOC   KDPDSEXP KDPDSQLS KDPHDSQL KDPJSTMS
  KDPJSTPS KDPJSTPW KDPMAP   KDPMSMAN KDPPLEX  KDPVRTMS KO25DSQL
  KO2APC72 KO2APC7K KO2APC7S KO2OSQPB
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R540 PSY UI70644

     UP20/07/22 P F007

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.