ccmdb unpack

This topic contains information about the ccmdb unpack command.

Synopsis

ccmdb unpack     packfile|archive_device|- [-o|-overwrite]
                 [-p|-space dbspace] [-s|-server servername]
                  -t|-to database_path [-url server_url]

Description and uses

Use the ccmdb unpack command to restore a database from a pack (.cpk) file created using ccmdb pack or ccmdb backup.

Note: You must have already set ORACLE_HOME and ORACLE_SID. Or use the -s option, to use this command.
Note: After unpacking a database (particularly from a packed production database), you might need to change some of the database properties, such as the paths to projects work areas. See Rational® Synergy CLI Help for the ccm wa (work area) command for important information about changing database properties.

To run this command, you must log on as the Oracle user who has write privileges for the appropriate tasks. For more information, see Setting up user privileges for Oracle.

Options and arguments

-

Unpacks from standard input.

archive_device

Unpacks from an archive device.

-o|-overwrite

Causes the unpacked database to overwrite the specified database to database_path.

Use this option to disperse a large database over many drives under multiple file systems using symbolic links for the subdirectories of the database. You cannot overwrite a database if a database with the same name exists in Informix®. You can use the ccmdb drop command. Then, use the -overwrite option to write out the database.

-p|-space dbspace

Specifies the name of the dbspace. By default, the ccm dbspace is used.

packfile

Unpacks from a pack file.

-s|-server servername

Specifies the database server. This option requires that you set the ORACLE_SID, or specify the servername with the ORACLE_SID environment variable. If the -s servername argument is specified, it supersedes the ORACLE_SID environment variable.

-t|-to database_path

Specifies the path to the database to which you are unpacking.

-url server_url

When this option is specified, the new database is assigned to the specified server. Otherwise, it is assigned to the default CCM server running on the database server machine.

Example

Unpack the training database to a new database named /vol/orbit1/ccmdb/train71.

$ ccmdb unpack packfiles/training.cpk -t 
/vol/orbit1/ccmdb/train71

Enter user-name who has privileges of
CREATE USER, DROP USER, CREATE ANY INDEX, DROP ANY INDEX,
CREATE ANY SEQUENCE, CREATE ANY TABLE, INSERT ANY TABLE,
DROP ANY TABLE, SELECT ANY TABLE, UPDATE ANY TABLE,
DELETE ANY TABLE, and GRANT ANY OBJECT PRIVILEGE:ccm_user
Enter password: 
Unpacking database /vol/orbit1/ccmdb/train71.
Creating Rational Synergy database /vol/orbit1/ccmdb/train71.
database create succeeded.
Extracting pack file /vol/orbit1/ccm71/packfiles/training.cpk.
Loading database.
loading Rational Synergy dump file version 7.1 platform UNIX ...
loading table attrib...
..............................3042 records.
loading table bind...
..289 records.
loading table bsite...
..213 records.
loading table compver...
...352 records.
loading table control...
0 records.
loading table relate...
.178 records.
loading table release...
10 records.
database unpacked successfully.ccmdb unpack base.cpk -to 
/vol/hydra/ccmdb/tstgonzo

Feedback