• Housekeeping - Recreating Sandb from Flatfiles.
• Description
• Procedure

Housekeeping - Recreating Sandb from Flatfiles.

Description

This document is intended as a template to describe how to recreate sandb following an array recarve or symm addition to the site.

Procedure

Ideally, this procedure will be run over the course of a few days, as sanity should run as clean as possible. If this is not possible, ensure that all errors (disregarding errors concerning the newly discovered storage) are rectified before starting.

 Firstly, run sanity for both buildings - check and fix all errors not relating to newly installed storage devices.

 If additional arrays have been added the following flatfile will need to be edited to include the new symmetrix information:
 eusan-mgt1:/var/opt/san/sandb/FLATFILES/symmetrix_information (if CGC arrays are added).
 eusan-mgt2:/var/opt/san/sandb/FLATFILES/symmetrix_information (if RDC arrays are added).

 From CGC, dump out the reserv information. Do this by running:-

 /var/opt/san/sandb_dev/reserv_dump.pl

 (check that the reserv flatfiles exist in /tmp/FLATFILES)

 Now in CGC, run :-

 $>/var/opt/san/sandb_dev/dbinsert_cgc.pl

 This should drop the initial database and recreate the tables with the data from the flatfiles as follows:-

 INFO : creating table meta_port
 INFO : running populate_meta_and_meta_port_tables
 Counter at populate_meta_and_meta_port_tables at 1000
 Counter at populate_meta_and_meta_port_tables at 2000
 Counter at populate_meta_and_meta_port_tables at 3000
 Counter at populate_meta_and_meta_port_tables at 4000
 Counter at populate_meta_and_meta_port_tables at 5000
 Counter at populate_meta_and_meta_port_tables at 6000
 Counter at populate_meta_and_meta_port_tables at 7000
 Counter at populate_meta_and_meta_port_tables at 8000
 Counter at populate_meta_and_meta_port_tables at 9000
 Counter at populate_meta_and_meta_port_tables at 10000
 INFO : running drop_table(host)
 INFO : creating table host
 INFO : running populate_table_host
 INFO : running drop_table(meta_host)
 INFO : creating table meta_host
 INFO : completed creation of meta_port hash
 record count for add_meta_host_table_row at  1000
 record count for add_meta_host_table_row at  2000
 record count for add_meta_host_table_row at  3000
 record count for add_meta_host_table_row at  4000
 record count for add_meta_host_table_row at  5000
 record count for add_meta_host_table_row at  6000
 record count for add_meta_host_table_row at  7000
 record count for add_meta_host_table_row at  8000
 record count for add_meta_host_table_row at  9000
 record count for add_meta_host_table_row at  10000
 record count for add_meta_host_table_row at  11000
 record count for add_meta_host_table_row at  12000
 record count for add_meta_host_table_row at  13000
 record count for add_meta_host_table_row at  14000
 record count for add_meta_host_table_row at  15000
 record count for add_meta_host_table_row at  16000
 record count for add_meta_host_table_row at  17000
 record count for add_meta_host_table_row at  18000
 record count for add_meta_host_table_row at  19000
 record count for add_meta_host_table_row at  20000
 record count for add_meta_host_table_row at  21000
 record count for add_meta_host_table_row at  22000
 record count for add_meta_host_table_row at  23000
 Almost done now ......just creating the database indexes
 All done - now try some commands in sandb and verify that everything works!

 Now in RDC, run :-

 $>/var/opt/san/sandb_dev/dbinsert_rdc.pl

 bash-2.03$ /var/opt/san/sandb_dev/dbinsert_rdc.pl
 INFO : clearing transaction log for database
 INFO : running populate_dmx_table
 INFO : running add_dmx_table_row(000287750107,5R,FLEX,000287750129,DMX2000,RDC)
 INFO : running add_dmx_table_row(000287750096,6R,GEN,000287750125,DMX2000,RDC)
 INFO : running add_dmx_table_row(000287750200,7R,FLEX,000287750122,DMX2000,RDC)
 INFO : running add_dmx_table_row(000287750442,8R,GEN,000287750383,DMX2000,RDC)
 INFO : running add_dmx_table_row(000287890275,9R,GEN,000287890296,DMX3000-M2,RDC)
 INFO : running add_dmx_table_row(000287890300,10R,GEN,000287890294,DMX3000-M2,RDC)
 INFO : running add_dmx_table_row(000287890293,11R,FLEX,000287890298,DMX3000-M2,RDC)
 INFO : running add_dmx_table_row(000287890581,12R,GEN,000287890587,DMX3000-M2,RDC)
 INFO : running add_dmx_table_row(000287890596,13R,GEN,000287890603,DMX3000-M2,RDC)
 INFO : running add_dmx_table_row(000287890602,14R,GEN,000287890877,DMX3000-M2,RDC)
 INFO : running add_dmx_table_row(000287751808,15R,FLEX,000287751820,DMX2000,RDC)
 INFO : running add_dmx_table_row(000287751819,16R,GEN,000287751811,DMX2000,RDC)
 INFO : running add_dmx_table_row(000290101150,17R,GEN,000290101067,DMX3-24,RDC)
 INFO : running add_dmx_table_row(000290101136,18R,GEN,000290101081,DMX3-24,RDC)
 INFO : running add_dmx_table_row(000290100953,19R,GEN,000290100940,DMX3-24,RDC)
 INFO : running add_dmx_table_row(000290101065,20R,GEN,,DMX3-24,RDC)
 INFO : running add_dmx_table_row(000290102839,22R,GEN,000290102838,DMX3-24,RDC)
 INFO : running populate_director_table
 INFO : running populate_port_table
 INFO : running populate_meta_and_meta_port_tables
 Counter at populate_meta_and_meta_port_tables at 1000
 Counter at populate_meta_and_meta_port_tables at 2000
 Counter at populate_meta_and_meta_port_tables at 3000
 Counter at populate_meta_and_meta_port_tables at 4000
 Counter at populate_meta_and_meta_port_tables at 5000
 Counter at populate_meta_and_meta_port_tables at 6000
 Counter at populate_meta_and_meta_port_tables at 7000
 Counter at populate_meta_and_meta_port_tables at 8000
 Counter at populate_meta_and_meta_port_tables at 9000
 Counter at populate_meta_and_meta_port_tables at 10000
 Counter at populate_meta_and_meta_port_tables at 11000
 INFO : running populate_table_host
 INFO : completed creation of meta_port hash
 record count for add_meta_host_table_row at  1000
 record count for add_meta_host_table_row at  2000
 record count for add_meta_host_table_row at  3000
 record count for add_meta_host_table_row at  4000
 record count for add_meta_host_table_row at  5000
 record count for add_meta_host_table_row at  6000
 record count for add_meta_host_table_row at  7000
 record count for add_meta_host_table_row at  8000
 record count for add_meta_host_table_row at  9000
 record count for add_meta_host_table_row at  10000
 record count for add_meta_host_table_row at  11000
 record count for add_meta_host_table_row at  12000
 record count for add_meta_host_table_row at  13000
 record count for add_meta_host_table_row at  14000
 record count for add_meta_host_table_row at  15000
 record count for add_meta_host_table_row at  16000
 record count for add_meta_host_table_row at  17000
 record count for add_meta_host_table_row at  18000
 record count for add_meta_host_table_row at  19000
 record count for add_meta_host_table_row at  20000
 record count for add_meta_host_table_row at  21000
 record count for add_meta_host_table_row at  22000
 record count for add_meta_host_table_row at  23000
 record count for add_meta_host_table_row at  24000
 record count for add_meta_host_table_row at  25000
 record count for add_meta_host_table_row at  26000
 All done - now try some commands in sandb and verify that everything works!

 Now in CGC, run the following to import the reserv information from the flatfile created in the first step:

 /var/opt/san/sandb_dev/reserv_renew.pl.