Direct links to fixes
Tivoli Storage Productivity Center 5.1.1.6
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.3 (August 2014) 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
in cogserver.log: RQP-DEF-0177 An error occurred while performing operation 'sqlOpenResult' status='-28'. UDA-SQL-0114 The cursor supplied to the operation "sqlOpenResult" is inactive. UDA-SQL-0144 An arithmetic exception was detected. [IBM][CLI Driver][DB2/NT] SQL0801N Division by zero was attempted. SQLSTATE=22012
Local fix
Apply fix pack or call IBM support for temp fix.
Problem summary
**************************************************************** * USERS AFFECTED: * * Users running Cognos reports for Storage Virtualizers * **************************************************************** * PROBLEM DESCRIPTION: * * When report Storage Virtualizer - Space Report is run the * * following error is generated: * * RPQ-DEF-0177 An error occurred while performing operation * * 'sqlOpenResul' status='28', USA-SQL-0114. The cursor * * supplied to the operation "sqlOpenResult" is inactive. * * UDA-SQL-0144. An arithmetic exceptionwas detected. [IBM][CLI * * Driver][DB2/INT]Division by zero was attempted. * * SQLSTATE=22012 * **************************************************************** * RECOMMENDATION: * * Apply fix maintenance when available. * ****************************************************************
Problem conclusion
Storage Virtualizer reports will be generated successfully when the fix is applied. The fix for this APAR is targeted for the following maintenance packages: | fix pack | 5.1.1-TIV-TPC-FP0006 - target TBD | refresh pack | 5.2-TIV-TPC-RP0003 - target August 2014 http://www-01.ibm.com/support/docview.wss?&uid=swg21320822 The target dates for future refresh packs or fix packs do not represent a formal commitment by IBM. The dates are subject to change without notice.
Temporary fix
Comments
APAR Information
APAR number
IT02396
Reported component name
TPC
Reported component ID
5608TPC00
Reported release
510
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2014-06-10
Closed date
2014-06-16
Last modified date
2014-06-16
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
COGNOS
Fix information
Fixed component name
TPC
Fixed component ID
5608TPC00
Applicable component levels
R510 PSY
UP
R511 PSY
UP
R520 PSY
UP
R521 PSY
UP
R522 PSY
UP
Document Information
Modified date:
23 March 2022