PK59321: UTLITY SYSIN PARSING , S0C4 IN ABPUSE15 , THREAD BLOCK & CANCEL PROBLEM , SECURITY EXIT , JES2 , S222

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Correct various problems in DB2 Utility Enhanced Tool:
  
  - Utility SYSIN parsing fails if comment does not start in
    column 1.  Utility may not parse sysin statements beyond
    comment.
  - 0C4 in ABPUSE15 when loaded value violates column
    Constraint.
  - Thread block and cancel may not occur when mulitiple
    tablespaces specified in the tablespace ruleset.
  - Security User exit with options
       ALLOW_THREADS - ALLOW OTHERS and
       DELETE_BLOCKER_ID work incorrectly
  - Support LOAD utility optoin format Delimited
  - Change JES2 and JES in ABPOPTS in SABPSAMP and add
    JES3 note.
  - When it is necessary to terminate the DUET Sort during
    utility intercept operations, avoid the S222 abend.
  
  OTHER KEYWORDS: ABENDS0C4 ABENDS222 S0C4 S222 0C4 222
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Utilities Enhancement Tool.     *
  ****************************************************************
  * PROBLEM DESCRIPTION: Correct various problems in DB2         *
  *                      Utility Enhanced Tool:                  *
  *                      - Utility SYSIN parsing fails if        *
  *                      comment does not start in column 1.     *
  *                      Utility may not parse sysin statements  *
  *                      beyond comment.                         *
  *                      - 0C4 in ABPUSE15 when loaded value     *
  *                      violates column Constraint.             *
  *                      - Thread block and cancel may not       *
  *                      occur when mulitiple tablespaces        *
  *                      specified in the tablespace ruleset.    *
  *                      - Security User exit with options       *
  *                         ALLOW_THREADS - ALLOW OTHERS and     *
  *                         DELETE_BLOCKER_ID work incorrectly   *
  *                      - Support LOAD utility optoin format    *
  *                      Delimited                               *
  *                      - Change JES2 and JES in ABPOPTS in     *
  *                      SABPSAMP and add JES3 note.             *
  *                      - When it is necessary to terminate     *
  *                      the DUET Sort during utility intercept  *
  *                      operations, avoid the S222 abend.       *
  ****************************************************************
  * 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:

  UK34927

Modules/Macros

•    ABPOPTS  ABPPCHCK ABPPCOPY ABPPDOBJ ABPPEXEC
  ABPPFSPC ABPPLIST ABPPLOAD ABPPOPTS ABPPQUIS ABPPREBU ABPPRECO
  ABPPREOR ABPPSTMT ABPPTMPL ABPPUNLD ABPPUTLU ABPPUTLX ABPRBTHD
  ABPRUSQL ABPSBTHD ABPSTSRV ABPSUSQL ABPUFSPC ABPULDEF ABPUMAIN
  ABPUSE15 ABPUSE35
  

Fix information

• Fixed component name

  DB2 UTIL ENHANC

• Fixed component ID

  5655T5800

Applicable component levels

• R210 PSY UK34927

     UP08/04/02 P F804

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.