PI89457: DB2 ADMIN TOOL ALTERING TABLE TO PBR, ERROR ON CREATE, PREPARE FUNCTION SQLCODE = -104, APAR PI80388 COMPLETION FIX.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• After applying PTF for APAR PI80388,  still see this issue:
  When Altering a non-partitioned table to a partition by range
  table and the table has 2 or more indexes, fails with:
    sqlerror on CREATE     command, PREPARE    function
     DSNT408I SQLCODE = -104, ERROR:  ILLEGAL SYMBOL ")". SOME
              SYMBOLS THAT MIGHT BE LEGAL ARE: MAXVALUE MINVALUE
              <CHARSTRING> <HEXSTRING> <GRAPHSTRING>
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool for         *
  *                 z/OS who use the MKPBR command to            *
  *                 alter a tablespace to Partitioned-By-        *
  *                 Range (PBR), along with an index             *
  *                 change.                                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: The partition clause of a CREATE        *
  *                      TABLE statement is generated            *
  *                      with an unnecessary blank limit key,    *
  *                      causing a SQLCODE=-104 /                *
  *                      SQLCODEN104 error.                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When using the ALT command to alter a tablespace to
  PBR, along with its associated index change, the partition
  clause of a CREATE TABLE statement is generated with
  an unnecessary blank limit key.
  
  PARTITION BY (column_name1 ASC,
    column_name2 ASC,
    column_name3 ASC,
    column_name4 ASC)
    (PARTITION 1 ENDING AT (100),
    PARTITION 2 ENDING AT (),
    PARTITION 3 ENDING AT (9999),
    PARTITION 4 ENDING AT ())
  
  The incorrect change statement results in the following
  SQLCODE -104 error:
  
   DSNT408I SQLCODE = -104, ERROR: ILLEGAL
   SYMBOL ">closed parenthesis<". SOME SYMBOLS THAT MIGHT BE
   LEGAL ARE: MAXVALUE MINVALUE >CHARSTRING<
   >HEXSTRING< >GRAPHSTRING<
  
  NOTE:  >closed parenthesis< is actually the symbol.
  

Problem conclusion

• Problem has been resolved.
  

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:

  UI52201 UI52202

Modules/Macros

•    ADBCCMM
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI52201

     UP17/11/30 P F711

• RC10 PSY UI52202

     UP17/11/30 P F711

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.