Renaming or moving databases for Windows and Informix
You can move (or rename) a database to use the database
on a different machine or a different drive, or to duplicate a database
for use elsewhere. Use the ccmdb copy command to
rename or move a database from one location to another. You can copy
a pack file from UNIX to Windows but not from Windows to UNIX.
Deleting databases
Rational® Synergy
databases are a combination of file system and RDBMS data. Therefore,
you must remove databases using the ccmdb delete command
so that both the file system and metadata are removed.
Moving databases between UNIX and Windows
You can move a database between a UNIX server and a Windows server. However, when moving a database
from Windows to UNIX, the resulting database might have Windows-style
ASCII data in important files, which must be updated. The command ccmdb
upgrade has an option, /w, which converts
the database files in addition to performing the upgrade. All database
configuration files and controlled files of type ascii or
its subtypes are examined and converted to UNIX ASCII format. The conversion affects controlled
files in the archive and cache only. Work areas are not updated.
Monitoring database space
Informix® pre-allocates
space for its databases. You can monitor this pre-allocated space
to determine whether you need to increase its size or remove unneeded
objects.
Managing database space
Space management is an on-going task. Rational Synergy goes to great lengths to
conserve space to improve performance and ensure database access.
Deleting obsolete product files
Use the ccm delete command to delete one
or more obsolete products that are based on a set of selection criteria.
Removing unwanted data
In addition to using the ccm delete command
to delete objects, you can use the Save Offline and Delete (SOAD)
tool to remove unwanted data. You can also use the SOAD tool to save
data offline before deleting it from the database. Objects that are
saved offline are saved in a DCM package that can be received at a
later time.
Reducing database size
There are several other ways you can reduce the size of
your database. These activities do not need to be performed on a regular
basis. They can be performed on an as-needed basis. Here are some
suggestions.