PH01013: VARIOUS SQL ERRORS ARE POSSIBLE IF A TABLE WITH A LARGE NUMBER OF COLUMNS IS BEING REFRESHED WITH A ROW SUBSET

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• If a table with a large number of columns is being refreshed
  and a row subset selection is being specified using the
  Management Console dialogue, the SQL being prepared to perform
  the row selection can exceed the size of the buffer being used
  for the SQL PREPARE statement.  This will cause overlaying of
  the constructed SQL at some point in its extent, causing an
  error to be raised by the SQL PREPARE process.  The specific
  SQL error that occurs is not predictable
  

Local fix

• Use a row filtering expression rather than a row subset
  selection for the refresh
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IIDR CDC for z/OS who employ the    *
  *                 row subsetting capability of the Management  *
  *                 Console during a refresh.                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: If a table has a large number of        *
  *                      columns, then preparation of the SELECT *
  *                      statement to be used for row subsetting *
  *                      during a refresh can exceed the size of *
  *                      the host variable used to PREPARE the   *
  *                      SQL.  DB2 will then issue an error when *
  *                      it examines the SQL statement being     *
  *                      PREPAREd.  At this time, an SQLERROR    *
  *                      -302 has been seen.                     *
  ****************************************************************
  * RECOMMENDATION: APPLY CORRECTIVE SERVICE                     *
  ****************************************************************
  
  Use of row subsetting during a refresh can cause an SQL error if
  the table being refreshed has a large number of columns.
  

Problem conclusion

• The host variable has been expanded to the maximum size allowed.
  

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:

  UI58553

Modules/Macros

•    CHCPAADB
  

Fix information

• Fixed component name

  INFO SRVR CDC Z

• Fixed component ID

  5655U7600

Applicable component levels

• RA21 PSY UI58553

     UP18/09/27 P F809

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.