PM65780: VARIOUS USABILITY FIXES (APARTBD)

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• 1. Error message ABPU5306E is issued with a return code
  of 8, when the in stream SYSIN is empty
  
  2. If the practice name is longer than 32 bytes,  the
  started task and the utility job both terminate with an
  ABENDS0C4 abend
  
  3. The FLOAT data type was not parsing to the correct
  value based on the DB2 Utilities Guide and Reference
  
  4.  Error message ABPP9881E is issued when EXEC_SQL_ALTER
  or EXEC_SQL_DROP is used with the Utility Syntax Monitor
  
  5. The UET parser incorrectly allows duplicate
  attributes under the RULE element in the policy
  
  6.  Error message ABPP9881E is issued when the policy
  attribute or the option parameter contains a null or a blank
  
  7. UET does not calculate the starting position for a
  field that does not contain the position parameter
  
  8. The started task abends with an ABENDS0C4 when the policy
  does not contain the root XML element
  
  9. Some options module parameters are not set to default
  values
  
  10. The TCz Product Parameter Bufferpool field needs to be
  6 bytes long instead of 3
  
  11. If a -805 SQL error is encountered in the started task,
  message ABPU5916E will be emitted in the SYSPRINT.
  ( SQLCODE805 )
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Utilities Enhancement Tool.     *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. Error message ABPU5306E is issued    *
  *                      with a return code of 8, when the in    *
  *                      stream SYSIN is empty                   *
  *                      2. If the practice name is longer than  *
  *                      32 bytes,  the started task and the     *
  *                      utility job both terminate with an      *
  *                      ABENDS0C4 abend                         *
  *                      3. The FLOAT data type was not parsing  *
  *                      to the correct value based on the DB2   *
  *                      Utilities Guide and Reference           *
  *                      4.  Error message ABPP9881E is issued   *
  *                      when EXEC_SQL_ALTER or EXEC_SQL_DROP    *
  *                      is used with the Utility Syntax         *
  *                      Monitor                                 *
  *                      5. The UET parser incorrectly allows    *
  *                      duplicate attributes under the RULE     *
  *                      element in the policy                   *
  *                      6.  Error message ABPP9881E is issued   *
  *                      when the policy attribute or the        *
  *                      option parameter contains a null or a   *
  *                      blank                                   *
  *                      7. UET does not calculate the starting  *
  *                      position for a field that does not      *
  *                      contain the position parameter          *
  *                      8. The started task abends with an      *
  *                      ABENDS0C4 when the policy does not      *
  *                      contain the root XML element            *
  *                      9. Some options module parameters are   *
  *                      not set to default values               *
  *                      10. The TCz Product Parameter           *
  *                      Bufferpool field needs to be 6 bytes    *
  *                      long instead of 3                       *
  *                      11. If a -805 SQL error is encountered  *
  *                      in the started task, message ABPU5916E  *
  *                      will be emitted in the SYSPRINT.        *
  *                      ( SQLCODE805 )                          *
  ****************************************************************
  * 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:

  UK81113

Modules/Macros

•    ABP$$PRM ABPDTDPL ABPGSRVS ABPMSGEN ABPPDOBJ
  ABPPFSPC ABPPLOAD ABPPPLYX ABPPUTLU ABPPUTLX ABPPXMLU ABPRJSQL
  ABPRUSQA ABPRUSQL ABPSCHKP ABPSINIT ABPSJSQL ABPSPLCY ABPSPRMV
  ABPSTDB2 ABPSTSRV ABPSUSQA ABPSUSQL ABPUFSPC ABPUMAIN ABPUSE15
  ABPUUTLM
  

Fix information

• Fixed component name

  DB2 UTIL ENHANC

• Fixed component ID

  5655T5800

Applicable component levels

• R220 PSY UK81113

     UP12/08/31 P F208

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.