Docstoc

backup

Document Sample
backup Powered By Docstoc
					                                                                                      C H A P T E R                        A
                         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.1 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




                                                                              Cisco WAN Manager Database Interface Guide
 Part Number OL-6261-01, Rev. B0                                                                                           A-1
                                                                                                  Chapter A   Database Management
    Coldstart Script




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



              Cisco WAN Manager Database Interface Guide
  A-2                                                                                                Part Number OL-6261-01, Rev. B0
Chapter A   Database Management
                                                                                        Coldstart Script




                         •   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




                                                  Cisco WAN Manager Database Interface Guide
Part Number OL-6261-01, Rev. B0                                                                     A-3
                                                                                               Chapter A   Database Management
    Coldstart Script




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



              Cisco WAN Manager Database Interface Guide
  A-4                                                                                             Part Number OL-6261-01, Rev. B0
 Chapter A   Database Management
                                                                                   Backup and Restore of the Informix OnLine Database




                          •   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.




                                                                              Cisco WAN Manager Database Interface Guide
 Part Number OL-6261-01, Rev. B0                                                                                                 A-5
                                                                                                 Chapter A   Database Management
  Backup and Restore of the Informix OnLine Database




                      o 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




           Cisco WAN Manager Database Interface Guide
A-6                                                                                                 Part Number OL-6261-01, Rev. B0
Chapter A    Database Management
                                                                                     Changes to the Size of the Informix OnLine Database




                         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 on page A-5.



                         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:




                                                                               Cisco WAN Manager Database Interface Guide
 Part Number OL-6261-01, Rev. B0                                                                                                    A-7
                                                                                                    Chapter A   Database Management
   Additional Databases




                          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/*




            Cisco WAN Manager Database Interface Guide
 A-8                                                                                                   Part Number OL-6261-01, Rev. B0
Chapter A   Database Management
                                                                                                                 Additional Databases




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




                                                                                Cisco WAN Manager Database Interface Guide
Part Number OL-6261-01, Rev. B0                                                                                                  A-9
                                                                                                  Chapter A   Database Management
   Additional Databases




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




            Cisco WAN Manager Database Interface Guide
 A-10                                                                                                Part Number OL-6261-01, Rev. B0

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:26
posted:4/9/2011
language:English
pages:10