IBM Support

IT23092: A SELECT CAN CAUSE A SERVER TO CRASH IF A ROW IS GREATER THAN 32K IN SIZE

Direct links to fixes

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Running a select command from dsmadmc on v7.1 or 8.1 server
    against a table that is using a staging table
    and not a view, can cause the server to crash, if a row is
    greater than 32K.
    This doesn't affect running a similar select from the DB2
    command prompt.
    
    dbx on AIX shows:
    
    RdbBindParamsForStmt(??, ??, ??, ??, ??, ??) at 0x100188928
    RdbCliInsert(??, ??, ??, ??, ??) at 0x100184960
    tbCliSRInsDel(??, ??, ??, ??, ??, ??, ??) at 0x100184430
    TsmSqlPrepareData(??) at 0x1008f1924
    StartThread(0x0) at 0x10000da90
    
    or
    
    malloc_y.splay(u = 0x000000012c8efc60, v = 0x000000012c8effc0,
    heap =
    0x09001000a00ab6c0), line 628 in "malloc_y.c"
    free_y(ptr = 0x000000012c8efc70, flags = 0), line 1623 in
    "malloc_y.c"
    free_common(ptr = 0x000000012c8efc70), line 2610 in
    "malloc_common.c"
    pkFreeTracked(??, ??, ??, ??) at 0x100004514
    OutPopDataBlock(??) at 0x10039b794
    outGetNext(??, ??, ??) at 0x100026f0c
    TsmSqlPrepareData(??) at 0x10065a5d4
    StartThread(0x0) at 0x10000d670
    
    TsmSqlPrepareData() is the important function to match this
    defect.
    
    One known case is using a very long "Client Access Privilege"
    list in the ADMINS table
    that causes a column to be greater than 24K, and can be seen
    with "q admin f=d", such that running
    
    "select ADMIN_NAME, REG_ADMIN, CONTACT from ADMINS"
    
    can cause this type of crash.
    This large column caused the row to be greater than 32K in size
    and thus a crash occurred
    
    "SHOW ADMINSQL" can be used to see what tables are affected.
     If the column "Staged" is true then that table "could" cause a
    crash when select is run against it and the row can be greater
    than 32K.
    
    
    Initial Impact: Medium
    
    
    Tivoli Storage Manager and IBM Spectrum Protect Versions
    Affected:
    Space Management Server v7.1 and v8.1 on supported platforms
    
    
    
    
    
    Additional Keywords:  TSM  Spectrum Protect abend crash core
    fails staging
    

Local fix

  • Do not run the failing select command
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All IBM Spectrum Protect server users.                       *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See error description.                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply fixing level when available. This problem is currently *
    * projected to be fixed in levels 7.1.9.100, 7.1.10 and 8.1.6. *
    * Note that this is subject to change at the discretion of     *
    * IBM.                                                         *
    ****************************************************************
    

Problem conclusion

  • This problem was fixed.
    Affected platforms for reported release:  AIX, HP-UX, Solaris,
    Linux, and Windows.
    Platforms fixed:  AIX, HP-UX, Solaris, Linux, and Windows.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT23092

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    71A

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-11-09

  • Closed date

    2018-09-11

  • Last modified date

    2018-09-11

  • 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

    TSM SERVER

  • Fixed component ID

    5698ISMSV

Applicable component levels

[{"Business Unit":{"code":"BU029","label":"Software"},"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.1.3"}]

Document Information

Modified date:
06 September 2023