IC93070: DEVICE DISCOVERY OR DEVICE PROBE FAILURE WITH DB2 SQL ERROR: SQLCODE: -802, SQLSTATE: 22003

Refresh Pack 5.2.2 (June 2014) for Tivoli Storage Productivity Center
Fix Pack 5.1.1.5 (July 2014) for Tivoli Storage Productivity Center
Refresh Pack 5.2.3 (August 2014) for Tivoli Storage Productivity Center
Fix Pack 5.2.4 (November 2014) for Tivoli Storage Productivity Center
Fix Pack 5.2.4.1 (December 2014) for Tivoli Storage Productivity Center
Refresh Pack 5.2.5 (March 2015) for Tivoli Storage Productivity Center (withdrawn)
Fix Pack 5.1.1.6 (March 2015) for Tivoli Storage Productivity Center
Fix Pack 5.2.5.1 (April 2015) for Tivoli Storage Productivity Center (withdrawn)
Refresh Pack 5.2.6 (June 2015) for Tivoli Storage Productivity Center
Refresh Pack 5.2.7 (August 2015) for Tivoli Storage Productivity Center
Fix Pack 5.1.1.9 (October 2015) for Tivoli Storage Productivity Center
IBM Spectrum Control V5.2.8 (December 2015)
IBM Spectrum Control V5.2.9 (February 2016)
IBM Spectrum Control V5.2.10 (May 2016)
IBM Spectrum Control V5.2.10.1 (July 2016)
IBM Spectrum Control V5.2.11 (August 2016)
Fix Pack 5.1.1.12 (October 2016) for Tivoli Storage Productivity Center
Fix Pack 5.1.1.13 (February 2017) for Tivoli Storage Productivity Center
Fix Pack 5.1.1.14 (June 2017) for Tivoli Storage Productivity Center
Fix Pack 5.1.1.15 (Sept 2017) for Tivoli Storage Productivity Center
IBM Spectrum Control V5.2.12 (November 2016)
IBM Spectrum Control V5.2.13 (March 2017)
IBM Spectrum Control V5.2.14 (May 2017)
IBM Spectrum Control V5.2.15 (August 2017)
IBM Spectrum Control V5.2.15.2 (November 2017)
IBM Spectrum Control V5.2.16 (March 2018)
IBM Spectrum Control V5.2.17 (May 2018)
Fix Pack 5.1.1.8 (July 2015) for Tivoli Storage Productivity Center
Fix Pack 5.2.7.1 (February 2016) for Tivoli Storage Productivity Center

APAR status

• Closed as program error.

Error description

• DETAIL OF PROBLEM (include example(s) of error(s)):
  
  Frequent fabric principal switch changes over a long period of
  time may cause TPC discovery and probe failures with resulting
  HWN02182E and DB2 error(s):
  
  Error--
  Server: your_server.com  Status:12
  [Attributes={}][faultCode=Soap-ENV:Server]]faultString=Exception
  from
  service object:HWN02182E Experienced SQL problems while
  working with
  database: DB2 SQL error: SQLCODE: -802, SQLSTATE: 22003, SQLERRM
  C: null.
  [faultActorURI=/ITSRM/ServiceManager][DetailEntries=[(0)=<detai
  lentry]
  
  
  The Fabric principal switch changes cause unnecessary processing
  of fabric zoning and fabric switch port information. If these
  changes occur frequently in a TPC environment it can cause this
  type of an issue.
  
  
  RECREATE STEPS:
  Attempt to run discovery of Device and/or Probe to Device
  ________________________________________________________________
  
  DB2 Version used for Server: DB2  9.7 FP4
  The defect is against component: 5608T300
  Server/Manager build/release (TPC): 4.2.2.119
  ________________________________________________________________
  
  Customer impact: MED
  

Local fix

• TBD
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All TPC 4.x and 5.x users monitoring fabrics over extended   *
  * periods of time.                                             *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See ERROR DESCRIPTION.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to fix maintenance when available.                   *
  ****************************************************************
  

Problem conclusion

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

Temporary fix

Comments

APAR Information

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

  IC90057

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

Modules/Macros

• DEVICE
  

Fix information

• Fixed component name

  TPC

• Fixed component ID

  5608TPC00

Applicable component levels

• R510 PSY

     UP

• R511 PSY

     UP

• R520 PSY

     UP