PI80388: DB2 ADMIN TOOL ALTERING TABLE TO PBR SQLERROR ON CREATE COMMAND,PREPARE FUNCTION SQLCODE = -104

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• 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>
     DSNT418I SQLSTATE   = 42601 SQLSTATE RETURN CODE
     DSNT415I SQLERRP    = DSNHPARS SQL PROCEDURE DETECTING ERROR
     DSNT416I SQLERRD    = 3  0  0  -1  5932  502 SQL DIAGNOSTIC
              INFORMATION
     DSNT416I SQLERRD    = X'00000003'  X'00000000'  X'00000000'
              X'FFFFFFFF' X'0000172C'  X'000001F6' SQL DIAGNOSTIC
              INFORMATION
  

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 ")". SOME SYMBOLS THAT MIGHT BE
  LEGAL ARE: MAXVALUE MINVALUE >CHARSTRING<
  >HEXSTRING< >GRAPHSTRING<
  

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:

Modules/Macros

•    ADBCCMM
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI49874

     UP17/08/31 P F708

• RC10 PSY UI49875

     UP17/08/31 P F708

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.