Direct links to fixes
Tivoli Storage Productivity Center Refresh Pack 5
Refresh Pack 5.2.5 (March 2015) for Tivoli Storage Productivity Center
Fix Pack 5.2.5.1 (April 2015) for Tivoli Storage Productivity Center
Refresh Pack 5.2.6 (June 2015) for Tivoli Storage Productivity Center
Refresh Pack 5.2.7 (August 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)
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.2.7.1 (February 2016) for Tivoli Storage Productivity Center
APAR status
Closed as program error.
Error description
Investigate to determine if the TPC Main Installer can check for the appropriate permissions on directories and block action, as necessary, if permissions are not sufficient. Error Code Explanation: http://www-01.ibm.com/support/knowledgecenter/SSEPGG_10.1.0/com. ibm.db2.luw.messages.sql.doc/doc/msql20193n.html 6 - The fenced user ID cannot create the file (no execute access to the directory). traceTPCInstall.log 2014-11-19 12:39:12.464-0500 INFO 2014-11-19 12:39:12.450-0500 INS2070E: SQL Error encountered during repository creation. 2014-11-19 12:39:12.464-0500 INFO SQL statement: call admin_cmd('import from "/opt/IBM/TPC/config/install/data/sql/imports/GLOBALIZATION_LOOK UP_MASTER.csv" of DEL MODIFIED BY CODEPAGE=1208 replace into GLOBALIZATION_LOOKUP_MASTER') 2014-11-19 12:39:12.464-0500 INFO SQLSTATE: 560BC, Vendor error code: -20193 2014-11-19 12:39:12.464-0500 INFO DB2 SQL Error: SQLCODE=-20193, SQLSTATE=560BC, SQLERRMC=</directory_path>;6, DRIVER=3.65.77 2014-11-19 12:39:12.464-0500 INFO com.tivoli.itsrm.install.SilentInstallException: 2014-11-19 12:39:12.452-0500 INS2400E: Error encountered during import from file. 2014-11-19 12:39:12.464-0500 INFO com.tivoli.itsrm.common.GeneralException: GEN1034I 2014-11-19 12:39:12.464-0500 INFO at com.tivoli.itsrm.install.SilentDatabaseInstall.executeImportOrLo adFromFile(SilentDatabaseInstall.java:9303) 2014-11-19 12:39:12.464-0500 INFO at com.tivoli.itsrm.install.SilentDatabaseInstall.importFromFile(Si lentDatabaseInstall.java:9260) 2014-11-19 12:39:12.464-0500 INFO at com.tivoli.itsrm.install.SilentDatabaseInstall.doUpgrade(SilentD atabaseInstall.java:6756) 2014-11-19 12:39:12.464-0500 INFO at com.tivoli.itsrm.install.SilentDatabaseInstall.main(SilentDataba seInstall.java:7093) 2014-11-19 12:39:12.464-0500 INFO at com.ibm.tpc.install.backend.RunDB2UpgradeAnt.main(RunDB2UpgradeA nt.java:191) 2014-11-19 12:39:12.464-0500 INFO at com.tivoli.itsrm.install.SilentDatabaseInstall.doUpgrade(SilentD atabaseInstall.java:6785) 2014-11-19 12:39:12.465-0500 INFO at com.tivoli.itsrm.install.SilentDatabaseInstall.main(SilentDataba seInstall.java:7093) 2014-11-19 12:39:12.465-0500 INFO at com.ibm.tpc.install.backend.RunDB2UpgradeAnt.main(RunDB2UpgradeA nt.java:191) 2014-11-19 12:39:12.465-0500 INFO DEBUG SDI closeConnection entry 2014-11-19 12:39:12.465-0500 INFO DEBUG SDI closeConnection exit 2014-11-19 12:39:12.465-0500 INFO 2014-11-19 12:39:12.453-0500 ERROR RunDB2UpgradeAnt main 2014-11-19 12:39:12.453-0500 2014-11-19 12:39:12.452-0500 INS2400E: Error encountered during import from file. 2014-11-19 12:39:12.465-0500 INFO com.tivoli.itsrm.common.GeneralException: GEN1034I 2014-11-19 12:39:12.465-0500 INFO at com.tivoli.itsrm.install.SilentDatabaseInstall.executeImportOrLo adFromFile(SilentDatabaseInstall.java:9303) 2014-11-19 12:39:12.465-0500 INFO at com.tivoli.itsrm.install.SilentDatabaseInstall.importFromFile(Si lentDatabaseInstall.java:9260) 2014-11-19 12:39:12.465-0500 INFO at com.tivoli.itsrm.install.SilentDatabaseInstall.doUpgrade(SilentD atabaseInstall.java:6756) 2014-11-19 12:39:12.465-0500 INFO at com.tivoli.itsrm.install.SilentDatabaseInstall.main(SilentDataba seInstall.java:7093) 2014-11-19 12:39:12.465-0500 INFO at com.ibm.tpc.install.backend.RunDB2UpgradeAnt.main(RunDB2UpgradeA nt.java:191): <text unavailable> 2014-11-19 12:39:12.465-0500 INFO 2014-11-19 12:39:12.453-0500 INFO RunDB2UpgradeAnt main Caught SilentInstallException: com.tivoli.itsrm.install.SilentInstallException: 2014-11-19 12:39:12.452-0500 INS2400E: Error encountered during import from file. RECREATE STEPS: Run installer and view results. ________________________________________________________________ ______ DB2 Version used for Server: 10.1.3 The defect is against component: 5608TPC00 Server/Manager build/release (TPC): Agent build/release (TPC): Server/Manager (OS): AIX 7.,1 Agent (OS): ________________________________________________________________ Problem as described by customer: db2schema installation failed. Initial customer impact (low/med/high): High
Local fix
Engage Support
Problem summary
**************************************************************** * USERS AFFECTED: * * TPC 5.2.x users who want to upgrade TPC and have * * DB2_UTIL_MSGPATH defined in DB2 config variables, where the * * value has a directory path where the DB2 fenced user does * * not have read/execute access. * **************************************************************** * PROBLEM DESCRIPTION: * * Users who want to upgrade TPC and have DB2_UTIL_MSGPATH * * defined in DB2 config variables, where the value has a * * directory path where the DB2 fenced user does not have * * read/execute access. * * The installation error looks like this: * * * * INS2070E: SQL Error encountered during repository creation. * * 2014-11-19 12:39:12.464-0500 INFO SQL * * statement: call admin_cmd('import from * * "/opt/IBM/TPC/config/install/data/sql/imports/GLOBALIZATION_ * * LOOK * * UP_MASTER.csv" of DEL MODIFIED BY CODEPAGE=1208 replace into * * GLOBALIZATION_LOOKUP_MASTER') * * 2014-11-19 12:39:12.464-0500 * * INFO SQLSTATE: 560BC, * * Vendor error code: -20193 * * 2014-11-19 12:39:12.464-0500 * * INFO DB2 SQL Error: * * * * * * * * SQLCODE=-20193, SQLSTATE=560BC, * * SQLERRMC=</directory_path>;6, * * DRIVER=3.65.77 * **************************************************************** * RECOMMENDATION: * * Apply fix maintenance when available. * ****************************************************************
Problem conclusion
The fix for this APAR is targeted for the following maintenance packages: | refresh pack | 5.2-TIV-TPC-RP0005 - target March 2015 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
Grant read and execute access for the DB2 fenced user to the path corresponding to the value of the DB2_UTIL_MSGPATH DB2 config variables. To see the value of DB2_UTIL_MSGPATH, run: db2set -all To see the value of DB2 fenced user on Unix, run: db2pd -fmp | grep "Fenced User" On Windows, the DB2 fenced user is the same as the DB2 installation user, by default db2admin.
Comments
APAR Information
APAR number
IT05717
Reported component name
TPC
Reported component ID
5608TPC00
Reported release
523
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2014-11-25
Closed date
2015-02-04
Last modified date
2015-02-04
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
INSTALL
Fix information
Fixed component name
TPC
Fixed component ID
5608TPC00
Applicable component levels
Document Information
Modified date:
05 October 2023