Troubleshooting
Problem
While installing the Tivoli Storage Manager Reporting and Monitoring feature on Linux, the configuration fails with a popup error with the following text : "KCIIN0364E Failed to create database TEPS".
Symptom
An example of the popup error follows :
Cause
Permissions on the directories needed during the install/configuration process.
Diagnosing The Problem
Review the following files, adjusting for different directories depending on the installation path.
- /opt/tivoli/tsm/reporting/itm/logs/db2prep.log
This file will display which command failed during the configuration.
- /opt/tivoli/tsm/reporting/itm/logs/kfwdb2prep_db2inst1.log
This file will display more information about the error.
- db2diag.log
This file contains additional information about the errors.
For example :
KFWDB2PREP Starting on Thu Feb 11 16:03:28 PST 2010
Attaching to DB2 instance db2inst1...
db2 ATTACH TO db2inst1 USER db2inst1 2>&1
Instance Attachment Information
Instance server = DB2/LINUX 9.1.3
Authorization ID = DB2INST1
Local instance alias = DB2INST1
Creating the database TEPS...
SQL0970N The system attempted to write to a read-only file. SQLSTATE=55009
Failed to create database TEPS
In this case, the db2diag.log file shows
2010-02-11-16.03.33.415345-480 I7152G499 LEVEL: Error
PID : 5972 TID : 3086546624 PROC : db2agent (instance) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-21 APPID: *LOCAL.db2inst1.100212000329
AUTHID : DB2INST1
FUNCTION: DB2 UDB, buffer pool services, sqlbLockAllDirs, probe:905
MESSAGE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"
DIA8701C Access denied for resource "", operating system return code
was "".
2010-02-11-16.03.33.415509-480 I7652G395 LEVEL: Error
PID : 5972 TID : 3086546624 PROC : db2agent (instance) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-21 APPID: *LOCAL.db2inst1.100212000329
AUTHID : DB2INST1
FUNCTION: DB2 UDB, buffer pool services, sqlbLockAllDirs, probe:905
DATA #1 : String, 29 bytes
Cannot create /tmp/SQLDIR.LK0
This example shows that the installation get an "access denied" error trying to create /tmp/SQLDIR.LK0.
Resolving The Problem
Change the permissions on the directory that is having the issue and add the required permissions to be able to create/update files.
[{"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Not Applicable","Platform":[{"code":"PF016","label":"Linux"}],"Version":"All Supported Versions","Edition":"Edition Independent","Line of Business":{"code":"LOB26","label":"Storage"}}]
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21422146