IBM Support

IT05717: INSTALL FAILURE AT REPOSITORY CREATION WITH DB2 SQL ERROR: SQLCODE=-20193, SQLSTATE=560BC

Subscribe

You can track all active APARs for this component.

 

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

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

Document Information

Modified date:
05 October 2023