IBM Support

IC69255: DB2UPDV97 TO REPAIR UTL_SMTP.OPEN_CONNECTION PROCEDURE FOR EXISTING DATABASES

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Databases created or upgraded to DB2 Version 9.7 GA or Fix Pack
    1 will experience a problem with the UTL_SMTP.OPEN_CONNECTION
    procedure as described in APAR IC66788.  In order to repair this
    procedure on these existing databases, this APAR fix is required
    in combination of running the db2updv97 command.
    
    Databases created or upgraded to DB2 Version 9.7 Fix Pack 2 will
    contain the fix already for APAR IC66788, hence, this APAR fix
    is not required for those databases.
    

Local fix

  • Recreate your database on DB2 Version 9.7 Fix Pack 2 or later.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * DB2 Version 9.7 GA through to Fix Pack 1 servers on Linux,   *
    * Unix and Windows platforms that rely on the                  *
    * UTL_SMTP.OPEN_CONNECTION working properly.                   *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Function is needed to modify existing databases containing a *
    * defective definition of the UTL_SMTP.OPEN_CONNECTION         *
    * procedure.                                                   *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply DB2 Version 9.7 Fix Pack 3 and issue the db2updv97     *
    * command.  Otherwise, recreate databases at DB2 Version 9.7   *
    * Fix Pack 2 or later.                                         *
    ****************************************************************
    

Problem conclusion

  • Functionality to fix existing databases exists for DB2 Version
    9.7 Fix Pack 3 and all subsequent Fix Packs.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC69255

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-06-15

  • Closed date

    2010-09-16

  • Last modified date

    2010-09-16

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    IC69283

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 September 2010