IBM Support

IT25955: REST API OPENS THOUSANDS OF ORACLE DATABASE CONNECTIONS

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • Customer is reporting that he sees over thousand database
    connections when he runs a REST API Perl script to update about
    300 user accounts. Similar results are seen when he runs read
    user accounts.
    
    Customer restarted SI to reset database connections. The
    customer ran the following command to determine the number of
    liberty server database connections:
    
    netstat -anop | grep 1521 | grep <liberty pid>
    
    This initially returned 7 database connections.  There were 35
    noapp database connections which remained consistent throughout
    our testing.
    
    The customer ran the Perl script to read 1 user account and
    liberty database connections stayed at 7. Customer then ran
    Perl script to read 302 user accounts and database connections
    increased to 102. The database connections were not removed
    when the script finished. Customer ran Perl script again to
    read the same 302 user accounts and database connections
    increased to 204. 102 connections are being added, everytime the
    script runs.
    
    Noted one occurrence of the "pool maximum size exceeded"
    message in the messages.log file:
    
    WARNING!!! Pool maximum size exceeded 1 time in 300000(ms).
    Consider increasing MaxSize on pool: oraclePool_NoTrans
    

Local fix

  • STRRTC - 563084
    PC / PC
    Circumvention: None
    

Problem summary

  • Users Affected:
    Customers with Oracle Database, using the REST API and creating
    users with SSHUserKeys
    
    Problem Description:
    REST API opens thousands of Oracle database.
    
    Platforms Affected:
    All
    

Problem conclusion

  • Resolution Summary:
    A code fix is provided.
    
    Delivered In:
    5020603_7
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT25955

  • Reported component name

    STR B2B INTEGRA

  • Reported component ID

    5725D0600

  • Reported release

    526

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-08-13

  • Closed date

    2018-10-03

  • Last modified date

    2018-10-17

  • 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

    STR B2B INTEGRA

  • Fixed component ID

    5725D0600

Applicable component levels

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS3JSW","label":"IBM Sterling B2B Integrator"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.2.6","Edition":"","Line of Business":{"code":"LOB02","label":"AI Applications"}}]

Document Information

Modified date:
17 October 2018