PM22762: VARIOUS USABILITY FIXES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The following problems are reported:
  1) Problems with LOAD utility extended syntax.
  2) Threads not matching all filter parameters are cancelled
     erroneously.
  3) Blank line in utility job JCL results in message IKJ56246I
     and ABENDS001.
  4) Syntax error ABPP9930E occurs in DB2 V10 Load utility when
     "...WITH TIME ZONE EXTERNAL" is specified in the Load cards
      for a TIMESTAMP column.
  5) Error processing RUNSTATS utility statement with REPORT
     option.
  6) Utility syntax parser Error ABPU5306E occurs when "L" is 1st
     character in UNICODE SYSIN.
  7) Parsing failure occurs when encountering CREATOR.TABLE_NAME
     where CREATOR > 8 bytes.
  8) Creating System Level Backup ( via IBM Recovery Expert (ARY))
     with UET intercept results in S46D ABEND.
  9) Missing Support for new DB2 Load and Unload syntax in DB2 V9
     and DB2 V10.
  10) ABEND S0C7 possible in UET STC when encountering a SSRC
      ( Subsystem Recognition Character) that is < 4 bytes.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Utilities Enhancement Tool      *
  ****************************************************************
  * PROBLEM DESCRIPTION: The following problems are reported:    *
  *                      1. Problems with LOAD utility extended  *
  *                         syntax.                              *
  *                      2. Threads not matching all filter      *
  *                         parameters are cancelled             *
  *                         erroneously.                         *
  *                      3. Blank line in utility job JCL        *
  *                         results in message IKJ56246I         *
  *                         and ABENDS001.                       *
  *                      4. Syntax error ABPP9930E occurs in     *
  *                         DB2 V10 Load utility when            *
  *                         "...WITH TIME ZONE EXTERNAL" is      *
  *                         specified in the Load cards          *
  *                         for a TIMESTAMP column.              *
  *                      5. Error processing RUNSTATS utility    *
  *                         statement with REPORT                *
  *                         option.                              *
  *                      6. Utility syntax parser Error          *
  *                         ABPU5306E occurs when "L" is 1st     *
  *                         character in UNICODE SYSIN.          *
  *                      7. Parsing failure occurs when          *
  *                         encountering CREATOR.TABLE_NAME      *
  *                         where CREATOR > 8 bytes.             *
  *                      8. Creating System Level Backup         *
  *                         (via IBM Recovery Expert (ARY))      *
  *                         with UET intercept results in        *
  *                         S46D ABEND.                          *
  *                      9. Missing Support for new DB2 Load     *
  *                         and Unload syntax in DB2 V9          *
  *                         and DB2 V10.                         *
  *                      10. ABEND S0C7 possible in UET STC      *
  *                         when encountering a SSRC             *
  *                         (Subsystem Recognition Character)    *
  *                         that is < 4 bytes.                   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Apply the PTF
  

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:

  UK62455

Modules/Macros

•    ABPALTTB ABPALT01 ABPBMAIN ABPBPRMP ABPBPRMV
  ABPCUST1 ABPCUST2 ABPDDL02 ABPFADM0 ABPFADM1 ABPFADM2 ABPFADM3
  ABPFAPI  ABPFCTHD ABPFGABP ABPFGDB2 ABPFGSYS ABPFIAPI ABPFIPCV
  ABPFMAIN ABPFMSGL ABPFMSG1 ABPFOBJR ABPFPRF0 ABPFPRF1 ABPFPRF2
  ABPFPRF3 ABPFRELR ABPFSABP ABPFSDB2 ABPFSESS ABPFSKL  ABPFSSEC
  ABPFSSYS ABPFTAPI ABPFTHDD ABPFTHDL ABPFTHD1 ABPFTHD2 ABPFTHD3
  ABPFTHD4 ABPFTHD5 ABPISPF  ABPLTHD1 ABPMSGEN ABPPANEL ABPPAPI
  ABPPBALC ABPPBATU ABPPBATX ABPPCHCK ABPPCOPY ABPPDITB ABPPDOBJ
  ABPPEXEC ABPPEXPR ABPPFILE ABPPFSPC ABPPINEX ABPPINIX ABPPIPCV
  ABPPLINE ABPPLIST ABPPLOAD ABPPMSG  ABPPMSGI ABPPOPTS ABPPOSGS
  ABPPPACT ABPPPDB2 ABPPPFLE ABPPPLCY ABPPPLYX ABPPPMON ABPPPOPT
  ABPPPRAC ABPPPREL ABPPPRSE ABPPPSTR ABPPQUIS ABPPREBU ABPPRECO
  ABPPREOR ABPPROC  ABPPSCNV ABPPSTMT ABPPSTRG ABPPTMPL ABPPUNLD
  ABPPUTLU ABPPUTLX ABPPXMLU ABPRBTHD ABPRDB2S ABPRDFLT ABPRDOBJ
  ABPRJSQL ABPRSFLT ABPRSOBJ ABPRUSQL ABPSBTHD ABPSCHKP ABPSDB2I
  ABPSDB2S ABPSDFLT ABPSDOBJ ABPSFLTR ABPSINIT ABPSJSQL ABPSSFLT
  ABPSSOBJ ABPSTDB2 ABPSTSRV ABPSUSQL ABPUFSPC ABPULDEF ABPUMAIN
  ABPUSE15 ABPUSE35 ABPUSTUB
  

Fix information

• Fixed component name

  DB2 UTIL ENHANC

• Fixed component ID

  5655T5800

Applicable component levels

• R210 PSY UK62455

     UP10/12/03 P F012

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.