Audience: IT Support Staff

When used: The database backup had failed for the table --- httpfPageResult. Due to the database data block corruption, application was not able to do select. Thus the daily data dump was also failing for the table. The only recovery process is to get the data from all the monitoring nodes and then pump the data into the database.

1. Get the list of serviceIds that should have data for httpf service. Issue the following SQL statement in the production database:

2. Create a script to extract the data from each monitoring nodes:

3. Execute the script on each monitoring node at the location ~vwpoint. The output file "abcd" will contain all the httpfPageResult data set.

4. Compress the output file "abcd" and transfer to the server "<your account>@binary4".

5. In <your account>@binary4 created the directories ~<your home dir>/viewPoint, ~<your home dir>/viewPoint/bin, and ~<your home dir>/viewPoint/var.

6. Move the data extract file (abcd) to the location ~sbehera/viewPoint/var and rename it as "data.<YYMMDD>".

7. Copy the program ~vwpoint/viewPoint/bin/sndMonRes to ~<your home dir>/viewPoint/bin.

8. Set the environment variable ==> VIEWPOINT=~s<your home dir>/viewpoint

9. Execute the program ~<your home dir>/viewPoint/bin/sndMonRes -i 216.58.225.31.

10. This will transfer the data to the main production system.

Retrieve Data from Nodes (last edited 2006-03-01 23:38:06 by Eric)