PQ65942: CREATE INDEX WITH CX COMMAND WITH NO PIECESIZE VALUE RESULTS IN SQLCODE104

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In DB2 Admin Tool, using CX line command to CREATE INDEX in
  panel adb26 leads to panel adb26cxs where a prompt for PIECESIZE
  is left blank.  SQLCODE104 results from the generated statement
  in which a default value is specified as PIECESIZE K .
  .
  Additional symptoms: sqlcode 104 -104 option 2.4 adb2e1 piece
  size msgdsnt408i
  DSNT408I SQLCODE = -104, ERROR:  ILLEGAL SYMBOL "K". SOME
     SYMBOLS THAT MIGHT BE LEGAL ARE: <INTEGER> <BIG_INTEGER>
  

Local fix

• Edit the CREATE INDEX statement before submitting for execution,
  or specify a valid value for PIECESIZE
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 ADMIN TOOL who use CX line      *
  *                 command in panel ADB26 may be affected.      *
  ****************************************************************
  * PROBLEM DESCRIPTION: Using CX line command to CREATE INDEX   *
  *                      in panel ADB26 leads to panel ADB26CXS  *
  *                      where a prompt for PIECESIZE is left    *
  *                      blank. SQLCODE104 results from the      *
  *                      generated statement in which a default  *
  *                      value is specified as PIECESIZE K .     *
  ****************************************************************
  * RECOMMENDATION: INSTALL CORRECTIVE SERVICE FOR APAR/PTF      *
  ****************************************************************
  "CREATE INDEX WITH CX COMMAND WITH NO PIECESIZE VALUE" results
  in SQLCODE104
  

Problem conclusion

• The following two problems are fixed:
  If PIECESIZE value not specified, option is generated anyway
  as 'PIECESIZE  K'
  If PIECESIZE value not specified, but unit is indicated (K,M,G),
  option is incorrectly generated
  Both situations result in SQLCODE-104 when executed.
  

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

•    ADB26CXS
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R410 PSY UQ70910

     UP02/10/23 P F210

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.