IC89283: LATENCY ISSUES WITH INCREASED UPDATE LOADS

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • In solidDB V7.0 FP3, when increasing the UPDATE or other
    write-type load in tables
    that have large column sizes, the response time grows.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users.                                                   *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to solidDB server and ODBC driver to IBM solidDB     *
    * V7.0 Interim Fix 7.                                          *
    ****************************************************************
    

Problem conclusion

  • Fix is included in IBM solidDB V7.0 Interim Fix 7.
    
    A new server startup option and client-side (ODBC) configuration
    parameter have been added to set the limit after which memory
    allocations start to use system memory instead of the solidDB
    internal allocator.
    
    solidDB server startup option
    -xmaxslotalloc:<size_in_bytes> Default is 8192.
    
    Client-side configuration parameter
    [Client]
    MaxSlotAlloc=<size>; Default 8 K.
    
    By increasing the server-side and client-side setting for memory
    slot allocation, write transactions in tables that have large
    column sizes no longer increase latency. For example, in tables
    with 13 K column sizes, setting the memory slot allocation on
    both server and client side to 16384/16 K, the response times
    for UPDATEs are improved.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC89283

  • Reported component name

    SOLIDDB-DB2/IDS

  • Reported component ID

    5724V1700

  • Reported release

    700

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-12-27

  • Closed date

    2013-01-02

  • Last modified date

    2013-01-02

  • 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

    SOLIDDB-DB2/IDS

  • Fixed component ID

    5724V1700

Applicable component levels

  • R700 PSY

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

IBM solidDB

Software version:

700

Reference #:

IC89283

Modified date:

2013-01-02

Translate my page

Machine Translation

Content navigation