PI15752: DB2 ADMINISTRATION TOOL FOR Z/OS CM BATCH IVP ADBCMBIV RUN MAY END WITH SQLCODEN171 IF COLUMNS NOT IN ORDER FOR TABLE ADBCHG

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool for z/OS CM Batch IVP ADBCMBIV run may
  end with SQLCODEN171 if columns not in order for table ADBCHG
  resulting in the below error trying to delete a canceled change:
  ADB2C11 n ------------------ CM - Changes
  
  <SETUP
  
  >CANCEL_CHANGE
  mode=DELETEU
  >GET_CHANGE_INFO
  mode=BYNAME
  Unexpected sqlcode in : getChangeInfo.
  mode=
  
   DSNT408I SQLCODE = -171, ERROR:  THE DATA TYPE, LENGTH, OR
  VALUE OF
  ARGUMENT 1
            OF DECIMAL IS
  INVALID
   DSNT418I SQLSTATE   = 42815 SQLSTATE RETURN
  CODE
   DSNT415I SQLERRP    = DSNXROHB SQL PROCEDURE DETECTING
  ERROR
   DSNT416I SQLERRD    = -221  0  0  -1  0  0 SQL DIAGNOSTIC
  INFORMATION
   DSNT416I SQLERRD    = X'FFFFFF23'  X'00000000'  X'00000000'
  X'FFFFFFFF'
            X'00000000'  X'00000000' SQL DIAGNOSTIC
  

Local fix

• use Object Compare or ALT/TB function to correct the column
  order for table ADBCHG where column GRTSQLID needs to be moved
  after column ASSOCIATIONID.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who upgrade from DB2 Administration     *
  *                 Tool Version 10, Release 2 to Version 11,    *
  *                 Release 1, and use Change Management (CM).   *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Admin Tool upgrade process      *
  *                      allowed columns of a DB2 Admin Tool     *
  *                      DB2 table, ADBCHG, to have columns      *
  *                      out of order. This resulted in the      *
  *                      following SQLCODE=-171 / SQLCODEN171    *
  *                      error when attempting to import a       *
  *                      change:                                 *
  *                                                              *
  *                      SQLCODE = -171                          *
  *                      ERROR:  THE DATA TYPE, LENGTH, OR       *
  *                      VALUE OF ARGUMENT 1 OF DECIMAL IS       *
  *                      INVALID                                 *
  *                      DSNT418I SQLSTATE   = 42815             *
  *                      SQLSTATE RETURN CODE                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The DB2 Admin Tool upgrade process allowed columns of a DB2
  Admin Tool DB2 table, ADBCHG, to have columns out of order.
  This resulted in the following SQLCODE=-171 / SQLCODEN171
  error when attempting to import a change:
  
  SQLCODE = -171
  ERROR:  THE DATA TYPE, LENGTH, OR
  VALUE OF ARGUMENT 1 OF DECIMAL IS
  INVALID
  DSNT418I SQLSTATE   = 42815 SQLSTATE RETURN
  CODE
  

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:

  UI17982

Modules/Macros

• ADBCSRV
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI17982

     UP14/05/17 P F405

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.