PM98602: THREAD WITH PLAN DISTSERV ON A DB2 SUBSYSTEM THAT IS NOT THE PRIMARY SSID FOR ABP TASK NOT CANCELING.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When running a batch cancel a thread with plan DISTSERV (for
  distributed access) on a DB2 subsystem that is not the primary
  SSID for ABP task may not cancel.
  
  Also include fixes:
  -  SB78 Abend in ABPUTLM.UTLMJSYN
  -  Incorrectly discard SYSREC records when a LOAD statement
     includes a WHEN clause.
  -  LOAD with PRESORT completes with abend S04E for table with
     REAL columns.
  -  Started task goes down with S0C4 ABEND in module ABPSJSQL.
  -  S0C4 when refreshing a table through ICDC using the DB2 LOAD.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Utilities Enhancement Tool.     *
  ****************************************************************
  * PROBLEM DESCRIPTION: When running a batch cancel a thread    *
  *                      with plan DISTSERV (for distributed     *
  *                      access) on a DB2 subsystem that is not  *
  *                      the primary SSID for ABP task may not   *
  *                      cancel.                                 *
  *                      Also include fixes:                     *
  *                      -  SB78 Abend in ABPUTLM.UTLMJSYN       *
  *                      -  Incorrectly discard SYSREC records   *
  *                       when a LOAD statement includes a WHEN  *
  *                       clause.                                *
  *                      -  LOAD with PRESORT completes with     *
  *                       abend S04E for table with REAL         *
  *                       columns.                               *
  *                      -  Started task goes down with S0C4     *
  *                       ABEND in module ABPSJSQL.              *
  *                      -  S0C4 when refreshing a table         *
  *                       through ICDC using the DB2 LOAD.       *
  ****************************************************************
  * 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:

  UI19101

Modules/Macros

•    ABPGIPCV ABPGSRVS ABPIHOOK ABPIWRIT ABPPPLYX
  ABPRJSQL ABPSDB2I ABPSINIT ABPSJSQL ABPSPLCY ABPUFSPC ABPUMAIN
  ABPUSAPI ABPUSE15 ABPUSPRT ABPUUTLM ABPVS19I ABPVS20I ABPVS22I
  

Fix information

• Fixed component name

  DB2 UTIL ENHANC

• Fixed component ID

  5655T5800

Applicable component levels

• R220 PSY UI19101

     UP14/07/01 P F406

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.