IBM Support

PM61921: Close datasource connections after SQL validation is complete

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Environment: z/OS
    Product name: IBM? Rational? Business Developer
    
    Program Version    :  8.0.1.3
    Description.
    When executing an SQL validation operation from the EGL editor
    on an applicable SQL statement the validation process creates a
    connection to the database. After the validation of the SQL
    statement has been completed the SQL connection is not released
    by default.
    
    The connection can be closed manually in the Database
    Development perspective however with a Derby datasource which
    only allows one connection at a time after the validation is
    complete the connection is directly closed and released.
    
    This defect is to implement the same behavior by closing the
    connection after validation is complete for all datasource
    connections.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    When RBD creates a database connection for SQL validation,
    Retrieve SQL, or the Data Access Application wizard, the
    connection is left open unless the database is Derby.
    

Problem conclusion

  • If RBD creates a database connection for SQL validation,
    Retrieve SQL, or the Data Access Application wizard, it will
    close the connection when the operation is complete.  If the
    connection exists before the operation begins, the
    connection will be left open.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM61921

  • Reported component name

    RATL BUS DEV

  • Reported component ID

    5724S5000

  • Reported release

    801

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-04-05

  • Closed date

    2012-10-08

  • Last modified date

    2012-10-08

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

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

Fix information

  • Fixed component name

    RATL BUS DEV

  • Fixed component ID

    5724S5000

Applicable component levels

  • R801 PSN

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSMQ79","label":"Rational Business Developer"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0.1","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]

Document Information

Modified date:
08 October 2012