How to Delete a PC Farm's Spatial Database
This should be done about once a month for PC1
- You must first log on to some machine as babaropr
- 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
- Set the bootfile accordingly
setenv OO_FD_BOOT < output of last command >
- srtpath
- Execute the following command:
OprSpatialCleanUp
- 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