How to Delete a PC Farm's Spatial Database

This should be done about once a month for PC1
  1. You must first log on to some machine as babaropr
  2. Find the boot file for the PC farm that will have its spatial database deleted
    grep OO_FD_BOOT /nfs/oprserv0x/u1/PCx/prod/OprProcessingSys/OprConfPCx.xml
  3. Set the bootfile accordingly
    setenv OO_FD_BOOT < output of last command >
  4. srtpath
  5. Execute the following command:
    OprSpatialCleanUp
  6. The output should look something like this:
    (Wed 13:54) babaropr@oprserv02 $ OprSpatialCleanUp
    This program deletes instances of the spatial DB.
    Don't use it unless you know what you are doing.
    Found Spatial Root Node.
    Found Spatial Root MetaData.
    MetaData lists 6 spatialDB instances.
    Here are their: Indices, Instance Names, and Database Names:
    0 04-12-17.18:30:34 spa0
    1 05-01-13.10:25:06 spa1
    2 05-01-22.23:34:21 spa2
    3 05-01-22.23:40:40 spa3
    4 05-01-23.00:25:32 spa4
    5 (EMPTY) spa5
    Delete one or more? y/n y
    You can delete a range.
    Enter the instance index number for the first to delete (-1 to quit): 0
    Enter the instance index number for the last to delete (-1 to quit): 4
    Preparing to delete 0 thru 4.
    OK? (y/n)
    y
    Succesfully deleted number 0
    Succesfully deleted number 1
    Succesfully deleted number 2
    Succesfully deleted number 3
    Succesfully deleted number 4
    MetaData lists 6 spatialDB instances.
    Here are their: Indices, Instance Names, and Database Names:
    0 (EMPTY) spa0
    1 (EMPTY) spa1
    2 (EMPTY) spa2
    3 (EMPTY) spa3
    4 (EMPTY) spa4
    5 (EMPTY) spa5
    Delete one or more? y/n n

Last modified: Wed Mar 16 13:56:44 PST 2005