Database Management

Additional Databases

You can load a non-default database by selecting the Currently db name option from the Cisco StrataView Plus (SV+) Main Menu during Cisco SV+ start-up.

To create a new database, as user root, type:
host# create_db -D <databasename>

To load the database, invoke Option 4 (Dump db data) from the Cisco SV+ Main Menu.

Note Subsequently created databases share the same disk space as the default database. When the addition of other databases results in insufficient space, you may need to add another Cisco SV+ workstation to the network.

Informix OnLine Database, Backup, and Changing Size

Changing the size of the Informix OnLine database eradicates the data stored in the database. Therefore, before changing the size of the database, you should save it. For detailed information on backing up and changing the size of the database, see Appendix B, "Informix OnLine Database, Backup, and Changing Size".

Even when you don't want to change the size of the database, it is a good idea to back it up periodically.

The /usr/users/informix72/bin/tbmonitor program provides an archiving facility allowing you to back up the database. Informix can be in on-line or quiescent mode to execute an archive. When you are archiving while the system is on-line, be sure to choose an off-peak period.

Step 1 Log in as user informix.

Step 2 Change directory to the /usr/users/informix72/bin directory:
host% cd /usr/users/informix72/bin

Step 3 Run the tbmonitor program:
host% ./tbmonitor

Step 4 Select the Main menu's Archive option.

Step 5 Select the Archive menu's Create option.

You are prompted to mount the tape.

Step 6 Insert a write-enabled tape into the tape drive. (Make sure the tape drive is on line.)

Informix OnLine then prompts you for the level of archiving you desire.

Level-0 copies all dbspaces to tape.
Level-1 or Level-2 records changes since the last archive.

: When a level-0 archive has already been done, you can choose level-1, level-2, or level-0. When a level-0 archive has not already been done, you must enter 0. Wait while the archiving proceeds. (Tapes rewind automatically when full.) The percentage of completion of the archival process is displayed on the screen and is updated at one-minute intervals.
: When the first tape is full, the following messages are displayed:
: Please label this tape as number 1 in the archive sequence.
Please mount tape and press <RETURN> to continue.

Step 7 Label the completed tape and place a new write-enabled tape into the tape drive.

Step 8 Repeat steps 5 and 6 until the backup is complete.

When the archive process is complete, the message "Program over" is displayed.

Table of Contents