Cisco WAN Manager Database Interface Guide, 15.0
Database Management
Downloads: This chapterpdf (PDF - 210.0KB) The complete bookPDF (PDF - 11.04MB) | Feedback

Database Management

Table Of Contents

Database Management

Coldstart Script

User Data Preserved

Stratacom Database User Data Preserved

Statsdb User Data Preserved

Scmdb User Data Preserved

Backup and Restore of the Informix OnLine Database

Changes to the Size of the Informix OnLine Database

Additional Databases

CWM User Data Backup Procedures

CWM User Data Restore Procedures


Database Management


This appendix describes how to manage the Informix database.

For more information about how to use the Informix database, refer to the Informix documentation located at the following URL:

http://www-01.ibm.com/software/data/informix/pubs/library/

Coldstart Script

CWM Release 15 contains a coldstart script that cold starts the system.

The coldstart script with the optional -F (coldstart -F) drops the network data and user data tables and recreates them again. Dropping the tables removes the tables from the database.

The coldstart without the optional -F script drops all network data tables and creates them again. The user data tables are preserved.

Executing the coldstart script without the optional -F argument removes all network data while preserving the existing user data in the following databases:

stratacom

statsdb

scmdb

To execute the coldstart script, complete the following steps:


Step 1 Log in as svplus.

Step 2 Shut down CWM by selecting option 2 (Stop Core) from the CWM MAIN MENU.

Step 3 At the prompt, enter the coldstart command.

host% coldstart or coldstart -F


User Data Preserved

This section contains the user-defined data preserved when executing the coldstart script without the optional -F argument. The lists of files are from the following databases:

stratacom

statsdb

scmdb

Stratacom Database User Data Preserved

The following user data tables are preserved in the stratacom database:

cwm_info

xpvc_preferred

node_parent

user_info

sec_profile

sct_vc

sct_cosb

sct

sct_usage

sct_vcdesc

sct_vcdescxg

sct_cosbdesc

sct_deployment

conn_template

conn_templ_param

user_conn_desc

node_info

cwm_role_info

scmcollsvr

scmnodeenable

scmcardenable

scmnodecollhost

scmcardcollhost

scmnodecoll

scmnodecollstatus

scmcardcoll

scmcardcollstatus

scmnodetemplate

scmcardtemplate

scmcolpar

scmcolparsubobj

scmcolparstat

packet_ln_data

circuit_ln_data

serial_ln_data

frp_data

connection_data

axsm_conn_data

axsme_conn_data

axsmxg_conn_data

pxm1e_conn_data

frsm12_conn_data

fpd_conn_data

asi_ln_data

pnni_pn_port_data

pnni_nodal_data

axsmxg_path_data

axsmxg_ds3_ln_data

axsmxg_ln_data

mgx3_ln_data

mgx3_cd_data

phy_ln_data

asi_port_data

ftc_port_data

ausm_port_data

axsmxg_port_data

mgx3_port_data

station_data

axsmxg_pl_data

mgx3_pl_data

ima_group_data

ima_link_data

stat_enable

Statsdb User Data Preserved

The following user data tables are preserved in the statsdb database

statsdb_config

scmenablelist

scmnode

scmcollsvr

voice_conn_data

data_conn_data

fpsv_conn_data

fr_conn_data

fpv_conn_data

fpd_conn_data

fpfr_conn_data

atm_conn_data

axisfr_conn_data

axisatm_conn_data

axisce_conn_data

bb_conn_data

t1_line_data

e1j1_line_data

asi_line_data

axisatm_line_data

axist1_line_data

serial_line_data

axist3_line_data

phyt1_line_data

phye1_line_data

phyt3_line_data

sonet_line_data

narrow_trk_data

ipxatm_trk_data

bpxatm_trk_data

axisnb_trk_data

axisatm_trk_data

sonet_trk_data

ftc_trk_data

igxatm_trk_data

fr_port_data

asi_port_data

ftc_port_data

axisfr_port_data

atm_port_data

voice_port_data

bb_port_data

sdlc_port_data

bsc_port_data

asi_vport_data

axsm_conn_data

axsm_line_data

axsm_card_data

axsm_port_data

axsme_conn_data

axsme_line_data

axsme_port_data

axsmet3e3_pl_data

axsmesonet_pl_data

Scmdb User Data Preserved

The following user data tables are preserved in the scmdb database:

node_info

collsvr_info

statsdb_info

coll_info

sync_info

sync_list

coll_summ_list

Backup and Restore of the Informix OnLine Database

When the Informix OnLine database is either full or in danger of being full, back up the database. This section provides the procedures for backing up and restoring the database to a file or standard 150-megabyte Sun tape.

To backup the whole database, complete the following steps:


Step 1 Log in as user svplus.

Step 2 To back up the database, do the following:

a. Shut down the CWM by selecting option 2 (Stop Core) from the CWM main menu

b. Do one of the following:

Enter the pkill command to kill the Guard and AuditLogger processes:

pkill Guard
pkill AuditLogger

Issue the following commands:

cleanGD
cleanAL

c. Change to the /usr/users/svplus/bin directory where the dbexport command is located.

d. To backup a database to another directory, enter the following dbexport command:

host% dbexport -c -o <output directory> <database name>

For example, dbexport -c -o /usr/users/informix92/export stratacom

A stratacom.exp directory is created. This directory contains the entire stratacom database.

Step 3 To back up a database to a tape drive, enter the following dbexport command:

host% dbexport <database name> -t <tape drive location> -b <tape block size> -s <tape size>

For example, dbexport stratacom -t /dev/rst0 -b 16 -s 144000

A prompt indicates when to insert additional tapes, as necessary.


To restore the database from an output directory or tape, complete the following steps:


Step 1 Log in as user svplus.

Step 2 To restore the database from an output directory, enter the following dbimport command.

host% dbimport <database name> -i <incoming directory>

For example, dbimport stratacom -i /usr/users/informix92/export

Step 3 To restore the database from a tape, rewind or fast forward the tape to where the file is stored.

host% mt -f <tape name> rewind

For example, mt -f /dev/nrst4 rewind

or

host% mt -f <tape name> fsf <count - number of files to fast forward>

For example, mt -f /dev/nrst4 fsf 6

Step 4 Enter the following dbimport command:

host% dbimport <database name> -t <tape drive location> -b <tape block size> -s <tape size>

For example, dbimport stratacom -t /dev/rst0 -b 16 -s 144000


Note The tape size of 144 megabytes is appropriate for a standard 150-megabyte Sun tape.


A prompt indicates when to insert additional tapes, as necessary.


After the restore is complete, start CWM by selecting the Start Core option from the CWM MAIN MENU.

Changes to the Size of the Informix OnLine Database

Changing the size of the Informix OnLine database eradicates the data stored in the database. Therefore, save the database before changing the size of it.

To change the size of the database edit the onconfig file found in the /usr/users/informix92/etc directory by completing the following steps:


Step 1 Log in as user informix.

The default directory is /usr/users/informix92.

Step 2 Shut down CWM by selecting option 2 (Stop Core) from the CWM MAIN MENU.

Step 3 Change to the /etc directory.

Step 4 Open the onconfig file in vi Editor.

host% vi onconfig

Step 5 Change the ROOTSIZE parameter to the new value.

Step 6 Save and close the file.

Step 7 Back up then restore the database using the procedures listed in "Backup and Restore of the Informix OnLine Database" section.


After the restore is complete, start CWM by selecting the Start Core option from the CWM MAIN MENU.

Additional Databases

To add a database, complete the following steps:


Step 1 Log in as user svplus.

Step 2 Shut down CWM by selecting option 2 (Stop Core) from the CWM MAIN MENU.

Step 3 To create the statsdb or the scmdb database, enter the following command:

host% create statsdb or create scmdb

Step 4 To create the stratacom database, enter the following command:

host% coldstartCWM



Note Subsequently created databases share the same disk space as the default database. When the addition of other databases results in insufficient space, add another CWM workstation to the network.


To avoid database inconsistencies, enter the create_db command before restarting CWM.

After the restore is complete, start CWM by selecting the Start Core option from the CWM MAIN MENU.

CWM User Data Backup Procedures


Step 1 Stop the core

Step 2 Perform a coldstart (this will drop all the network data and only have the user data left in db)

Step 3 If you are planning to restore the user data onto a different machine, then perform a coldstartSCM -F to drop all the SCM tables. These tables contain the machine name.

Step 4 Create a /usr/users/svplus/dbexports directory. (Note: Please ensure there is at least 2 GB in this directory.)

For example, mkdir /usr/users/svplus/dbexports

Go to this directory /usr/users/svplus/dbexports

For example, cd /usr/users/svplus/dbexports

Step 5 Export the following databases

stratacom

statsdb

scmdb

For example,

dbexport stratacom (stratacom.exp is created in the /usr/users/svplus/dbexports directory. Save a copy of the dbexport.out file if necessary.)

dbexport statsdb (statsdb.exp is created in the /usr/users/svplus/dbexports directory. Save a copy of the dbexport.out file if necessary.)

dbexport scmdb (scmdb.exp is created in the /usr/users/svplus/dbexports directory. Save a copy of the dbexport.out file if necessary.)

Step 6 Tar up the /usr/users/svplus/dbexports directory

For example,

cd /usr/users/svplus

tar cvf /tmp/<server name-date>.tar dbexports/*

Step 7 ftp this tar file to another system for safe keeping.


CWM User Data Restore Procedures


Step 1 Down load or copy the <server name-date>.tar file to the local directory. For example, /tmp

Step 2 Go to that local directory. For example, cd /tmp

Step 3 Untar the <server name-date>.tar file.

For example, tar xvfp <server name-date>.tar

Step 4 Import the following databases:

stratacom

statsdb

scmdb

For example,

dbimport stratacom -i /tmp/dbexports

dbimport statsdb -i /tmp/dbexports

dbimport scmdb -i /tmp/dbexports