PI75548: IF COLUMN F_FORCE IS NOT ADDED TO UET REPOSITORY A BIND ERROR WILL OCCUR AND ABPSTC WILL ISSUE A DSNT408I SQLCODE = -805

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A -805 error can occur after applying PTF UI43312 and when
  trying to run the Bind a -204 error can occur due to column
  F_FORCE missing.
  Please complete the following steps to correct this issue:
  In TCz:
  a. Update the repository using the Alter existing DB2 UET
  objects step.
  This step runs the following command to add a new column:
  ALTER TABLE &CCQ_ABP_PLANQUAL..ABPUSTMTINFO
  ADD COLUMN F_FORCE CHAR (1) NOT NULL DEFAULT ' ';
  b. REBIND the DB2 UET product plan.
  c. Stop and then restart the DB2 UET started task, ABP ABPID,
  where ABPID is the started task ID defined in Tools Customizer
  during the customization process.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM DB2 Utilities Enhancement Tool  *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: A -805 error can occur after applying   *
  *                      PTF UI43312 and when trying to run the  *
  *                      Bind a -204 error can occur due to      *
  *                      column F_FORCE missing.                 *
  *                      Please complete the following steps to  *
  *                      correct this issue:                     *
  *                      In TCz:                                 *
  *                      a. Update the repository using the      *
  *                      Alter existing DB2 UET objects step.    *
  *                      This step runs the following command    *
  *                      to add a new column:                    *
  *                      ALTER TABLE                             *
  *                      &CCQ_ABP_PLANQUAL..ABPUSTMTINFO         *
  *                      ADD COLUMN F_FORCE CHAR (1) NOT NULL    *
  *                      DEFAULT ' ';                            *
  *                      b. REBIND the DB2 UET product plan.     *
  *                      c. Stop and then restart the DB2 UET    *
  *                      started task, ABP ABPID, where ABPID    *
  *                      is the started task ID defined in       *
  *                      Tools Customizer during the             *
  *                      customization process.                  *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• APPLY the PTF.
  

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:

  UI44326

Modules/Macros

•    ABPSINIT
  

Fix information

• Fixed component name

  DB2 UTIL ENHANC

• Fixed component ID

  5655T5800

Applicable component levels

• R220 PSY UI44326

     UP17/03/22 P F703

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.