IBM Support

IC88276: THE DATA BEING RETURNED BY A PROBE CAN EXCEED THE LENGTH ALLOCATED TO THE ACCESS_CONTROL COLUMN OF TPC.T_RES_XXX.TABLE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • SONAS system probe is not working correctly.
    
    At some point the probe calls (on the device) the following cli
    command.
    "cli lsexport -c xxxxx.xxxxx-v  -Y  -r"
    According to the documentation, lsexport command "retrieves data
    regarding the exported folders of
    the managed clusters from the database and returns a list in
    either a human-readable format or in a
    format that can be parsed."
    When the "control" value from the output of lsexport command is
    stored in the  ACCESS_CONTROL
    column of TPC T_RES_PROTOCOL_OPTIONS table
    DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null,
    DRIVER=3.62.56 was thrown.
    Db2 reason:
     SQL0302N The value of a host variable in the EXECUTE or OPEN
              statement is too large for its corresponding use.
    The fix provided, modifies the size of ACCESS_CONTROL column
    from 256 to 512.
    
    Probe example:
    
    Found in program  files / IBM / TPC / DEVICE/  ... probe log
    from device ( SONAS system probe )
    
    2012-10-29 11:27:11.322+0100 HWNEP0001I  persisted 50 files set
    instances
    2012-10-29 11:27:11.369+0100 HWNEP0001I  persisted 62 files set
    instances
    2012-10-29 11:27:12.447+0100 HWNEP0001I  persisted  50 export
    protocol
    2012-10-29 11:27:12.994+0100 HWNEP0002E  Log/output file,
    xxxxxx.xxxxxx._output.txt, not found or failed to load
    2012-10-29 11:27:13.010+0100 HWN021709I  Perform collection post
    process tasks for storage system
    2012-10-29 11:27:13.010+0100 BTADS0001I  Discover Process with
    Device Server RUN ID xxxx  and Job ID xxxxx is complete with
    Status= 4 , Return Code= 1
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * TPC 5.1.0 and 5.1.1 users                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See ERROR DESCRIPTION.                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade when fix pack is available.                          *
    ****************************************************************
    <span><span>If the CIFS ACL or NFS client list exceeds the
    length of 256 characters the share protocol options are not
    properly collected by TPC.</span></span>
    

Problem conclusion

  • The fix for this APAR is targeted for the following maintenance
    package:<br/><br/>| fix pack | 5.1.1-TIV-TPC-FP0001 - target
    March
    2013<br/><br/>http://www-01.ibm.com/support/docview.wss?&amp;uid
    =swg21320822<br/><br/>The target dates for future fix packs do
    not represent a formal <br/>commitment by IBM. The dates are
    subject to change without <br/>notice.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC88276

  • Reported component name

    TPC

  • Reported component ID

    5608TPC00

  • Reported release

    510

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-11-16

  • Closed date

    2012-11-19

  • Last modified date

    2012-11-19

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

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

Modules/Macros

  • data
    

Fix information

  • Fixed component name

    TPC

  • Fixed component ID

    5608TPC00

Applicable component levels

  • R510 PSY

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SS5R93","label":"IBM Spectrum Control"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"510","Line of Business":{"code":"LOB26","label":"Storage"}}]

Document Information

Modified date:
23 March 2022