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

Fix Pack 5.1.1.1 (April 2013) for Tivoli Storage Productivity Center

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 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