IBM Support

LI74155: AFTER MIGRATING FROM V8.1 TO V9.5, SQL PROCEDURES THAT REQUIRE MANUAL MIGRATION CANNOT BE IDENTIFIED BY QUERY IN INFOCENTER.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • If you created your SQL procedures in DB2 UDB Version 8.1 and
    migrated from a DB2 UDB Version 8 32-bit instance to a DB2
    Version 9.5 64-bit instance, you must drop and re-create those
    SQL procedures as part of the manual migration process.
    
    However, during the migration to V9.5, SQL procedures created in
    V8.1 are changed to FENCED and cannot be identified by the
    following query in InfoCenter.
    
    Migrating SQL procedures
    
      Procedure
      2. Run the following query to identify the SQL procedures that
    you need to re-create:
         SELECT procschema, specificname
         FROM syscat.procedures
         WHERE language = 'SQL' AND fenced = 'N' AND
               substr(IMPLEMENTATION, 10,6) = 'pgsjmp'
    

Local fix

  • Use the following query instead to identify the SQL procedures
    that you need to re-create.
    
    SELECT procschema, specificname
    FROM syscat.procedures
    WHERE language = 'SQL' AND substr(IMPLEMENTATION, 10,6) =
    'pgsjmp'
    

Problem summary

  • Users affected: All who use SQL procedures migrated from V8.1 to
    V9.5.
    Problem Description: As same as Error description.
    Problem Summary: As same as APAR abstract.
    

Problem conclusion

  • Problem was first fixed in Version 9.5 Fix Pack 5 (s091123).
    

Temporary fix

Comments

APAR Information

  • APAR number

    LI74155

  • Reported component name

    DB2 UDE ESE LIN

  • Reported component ID

    5765F4104

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-01-27

  • Closed date

    2009-12-14

  • Last modified date

    2009-12-14

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

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

    IC62056 IC62057 IC62105 IC62107

Fix information

  • Fixed component name

    DB2 UDE ESE LIN

  • Fixed component ID

    5765F4104

Applicable component levels

  • R950 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":"950","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
14 December 2009