Troubleshooting
Problem
When you try to install the Registry Services database on Windows, you might receive the SQL1052N error. This error happens if the DB2_CREATE_DB_ON_PATH variable is not correctly set.
Symptom
After you complete the full installation of Jazz for Service Management, if you try to manually install the Registry Services database on Windows, you might receive the SQL1052N error.
This error happens if the DB2_CREATE_DB_ON_PATH variable is set to NO, which is the default value.
The following example shows the error message that you can see on the CLI log files:
Jan 29, 2013 10:30:38 PM com.ibm.frs.install.db.ScriptRunner$1 run
INFO: [Tue 01/29/2013 22:30:36.69] FRS DB2 Setup Database Script
Jan 29, 2013 10:30:38 PM com.ibm.frs.install.db.ScriptRunner$1 run
INFO: --------------------------------------------------------------------------------
Jan 29, 2013 10:30:38 PM com.ibm.frs.install.db.ScriptRunner$1 run
INFO: "db2 create database 'frs' AUTOMATIC STORAGE YES ON 'C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\2\frs.455229066127963\dbdata' using codeset UTF-8 territory US"
Jan 29, 2013 10:30:38 PM com.ibm.frs.install.db.ScriptRunner$1 run
INFO: SQL1052N The database path
Jan 29, 2013 10:30:38 PM com.ibm.frs.install.db.ScriptRunner$1 run
INFO: "C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\2\frs.455229066127963\dbdata" does not
Jan 29, 2013 10:30:38 PM com.ibm.frs.install.db.ScriptRunner$1 run
INFO: exist.
Jan 29, 2013 10:30:38 PM com.ibm.frs.install.db.ScriptRunner$1 run
INFO: --------------------------------------------------------------------------------
Jan 29, 2013 10:30:38 PM com.ibm.frs.install.db.ScriptRunner$1 run
INFO: db2 frsconnect 'frs'
Jan 29, 2013 10:30:38 PM com.ibm.frs.install.db.ScriptRunner$1 run
INFO: SQL0843N The server name does not specify an existing connection.
Resolving The Problem
If you receive the SQL1052N error, you must set the DB2_CREATE_DB_ON_PATH variable to YES to activate the support to the use of a path as a database path. Run the following steps to set this variable:
Open the DB2 command window.
Open the DB2_HOME\bin directory.
Run the db2stop command to stop the database instance.
Set the variable to YES by running this command: db2set DB2_CREATE_DB_ON_PATH=YES.
Run the db2start command to restart the database instance.
Install the Registry Services database.
This manual installation of the Registry Services database must be used for installation maintenance only.
Related Information
Was this topic helpful?
Document Information
More support for:
Tivoli Components
Software version:
1.1
Operating system(s):
Windows
Document number:
220887
Modified date:
17 June 2018
UID
swg21626717