PK30182: DSNT404I SQLCODE 20272 OCCURRS TWICE ALTER INDEX NOT CLUSTER CONVERTED TO USE TABLE-CONTROLLED PARTITIONING INSTEAD OF INDEX

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Altering  partitionning index to not cluster puts out two
  messages:
  DSNT404I SQLCODE = 20272 WARNING:  TABLE SPACE BACTRATS HAS
     BEEN CONVERTED TO  USE TABLE-CONTROLLED PARTITIONING INSTEAD
  DSNT418I SQLSTATE   = 01666 SQLSTATE RETURN CODE
  DSNT415I SQLERRP    = DSNXISB6 SQL PROCEDURE DETECTING  ERROR
  DSNT416I SQLERRD    = 42  0  0  -1  0  0 SQL DIAGNOSTIC
  INFORMATIONLSTATE   = 01666 SQLSTATE RETURN CODE
  DSNT416I SQLERRD    = X'0000002A'  X'00000000'  X'00000000'
  

Local fix

• Please apply ptf when available.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool, who use    *
  *                 Batch Restart Program  (ADBTEP2)  running    *
  *                 SQL statements that receive a DB2 SQLCODE    *
  *                 greater than 98, are affected.               *
  ****************************************************************
  * PROBLEM DESCRIPTION: Program ADBTEP2 may display SQLCA twice *
  *                      if the SQLCODE is greater than 98.      *
  *                      .*                                      *
  *                      DSNT404I  SQLCODE  20272  occurs  twice *
  *                      when  Altering  partitionning  index to *
  *                      not cluster.                            *
  *                      .* Note:                                *
  *                      ADBTEP2 has been changed  to only print *
  *                      the  SQLCA  once  when an SQL statement *
  *                      has a problem.                          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  See Problem Description.
  

Problem conclusion

• Apply the fix.
  

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

•    ADBTEP2
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R710 PSY UK20015

     UP06/11/30 P F611

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.