Managing databases
Learn about managing databases.
- 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. - Managing cache files
Learn about managing cache files. - Deleting unused databases
When databases are no longer needed, you can delete them. - 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.
Feedback