Moving the DB2 instance to another drive

Technote (troubleshooting)


Problem(Abstract)

The Tivoli Compliance Insight Manager DB2 instance (CIFINST) is automatically installed in drive C for grouped servers installations.

Symptom

After installation the database gets created in the C drive (c:\CIFINST), even if during installation another drive was selected.


Resolving the problem

Follow the instructions below to move the DB2 instance to the correct drive:

**Note: The below steps need to be executed as cifdb2admin.

1. Create a file called reloc.cfg in a temporary directory (c:\temp) with the following contents:

DB_NAME=CIFDB
DB_PATH=C:,F:
INSTANCE=CIFINST
NODENUM=0
STORAGE_PATH=C:,F:

where,

  • CIFDB is the name of the DB2 database.
  • F: is the drive to which you want to move the database.
  • CIFINST is the database instance name.
  • To find the correct information for the STORAGE_PATH, run the following SQL query:

select PATH from sysibmadm.dbpaths where type='DB_STORAGE_PATH'
    The command returns a list of all storage paths currently in use by DB2. If the list contains more than one storage path, specify each entry in the reloc.cfg file on a separate line. For example, if the query returns paths C: and D:, add the following lines to the reloc.cfg file:

    STORAGE_PATH=C:,F:
    STORAGE_PATH=D:,F:

2. Stop all IBM Tivoli Compliance Insight Manager Services:

IBM Tivoli Compliance Insight Manager Server 8.5.0
IBM Tivoli Compliance Insight Manager Auth Daemon
All IBM Tivoli Compliance Insight Manager Event Mapper* services (there could be more than one event mapper service)
IBM Tivoli Compliance Insight Manager Tomcat

3. Execute from the command line:

db2stop force

4. Copy C:\CIFINST to F:\CIFINST with the same permissions!! (After copying add DB2ADMNS user with full control)

5. From the command line, change to the temporary directory (c:\temp) and execute the following:

db2start
db2relocatedb -f reloc.cfg
db2stop force

6. Rename C:\CIFINST folder to C:\CIFINST_OLD

7. Execute from the command line:

db2start

8. Start all IBM Tivoli Compliance Insight Manager Services

IBM Tivoli Compliance Insight Manager Server 8.5.0
IBM Tivoli Compliance Insight Manager Auth Daemon
All IBM Tivoli Compliance Insight Manager Event Mapper* services(there could be more than one event mapper service)
IBM Tivoli Compliance Insight Manager Tomcat


** The C:\CIFINST folder can be removed after verifying the functionality of the server.

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Tivoli Compliance Insight Manager

Software version:

8.5

Operating system(s):

Windows

Reference #:

1321404

Modified date:

2011-02-15

Translate my page

Machine Translation

Content navigation