Renaming Chunk Paths with SAPDBA
Use
You can use SAPDBA to rename chunk paths in your Informix database. For example, you can use this during a system copy.
Prerequisites
SAPDBA is installed correctly. Refer to
SAPDBA Setup.
- You are logged on in expert mode, that is, as user
informix
, and you have started SAPDBA. Refer to
Starting SAPDBA.
- Create a level-0 (full) database backup (
ON-Bar
) or archive (
ON-Archive
or
ontape
)
before reorganization. For more information, see:
Creation of a Database Backup (ON-Bar)
Creation of an Archive (ON-Archive)
Creation of an Archive (ontape)
If data is lost during the renaming of the chunk paths, you can then
restore the database using this database backup or archive.
Procedure
Choose Dbspaces
®
Rename Chunk Path in SAPDBA.
SAPDBA prompts to make sure that you have completed a level-0 backup.
Enter the new SID (that is, system id) for the chunk paths.
If you are using Windows NT, specify the disk drive too. You can specify the disk drive for all chunks or for individual chunks.
If required, choose List Chunk Paths to see the names of the current chunk paths.
This is the same functionality as in
Listing Chunk Paths with SAPDBA.Choose Continue.
Result
SAPDBA renames the chunk paths and displays a confirmation message.
See also:
SAP Notes 191314 and 158079
Dropping a Chunk with SAPDBA
Adding a Chunk with SAPDBA