Technology
Stefan Damian, , , , , Leave a Comment on Rebuild and Validate the BPPM Server Sybase Database
, , , , ,

Rebuild and Validate the BPPM Server Sybase Database

1. Stop the ProactiveNet Server and verify that none of the related processes are running.

pw system stop
pw system status

2. Backup the ProactiveNet Server Database data file, “storm_HOSTNAME.db” (\pw\sybase\), and transaction log, “pronto.log” (\pw\sybase\), to a directory outside the installation of the ProactiveNet Server.

3. Start the ProactiveNet Server Database (dbsrv) and verify that no other processes are running.

pw process start dbsrv
pw system status

4. Unload the ProactiveNet Server Database and review the “dbunload.txt” for any error messages.

>dbunload.exe -c "LINKS=tcpip;eng=storm_%COMPUTERNAME%;uid=dba;pwd=pronet" 
-an "%BMC_PROACTIVENET_HOME%\dbrebuild\storm_%COMPUTERNAME%" 
-o dbunload.txt -v

 SQL Anywhere Unload Utility Version 11.0.1.2789 
 Connecting and initializing 
 Unloading user and group definitions 
 Unloading table definitions 
 Unloading text configurations 
 Unloading materialized view definitions 
 Unloading index definitions 
 Unloading functions 
 Unloading view definitions 
 Unloading procedures 
 Unloading triggers 
 Unloading SQL Remote definitions 
 Unloading MobiLink definitions Creating new database 
 Unloading "DBA"."AACADAPTERE_BL" (0 rows) . . .
 Unloaded 1350 tables of 1389
 . . .
 Unloading "DBA"."NTPROC_BL_4" (33 rows)
 Creating indexes
 . . .
 Creating indexes for (1389/1389) "DBA"."NTPROC_BL_4"

NOTE: The number of tables will vary greatly between ProactiveNet Servers depending on the monitoring configuration.

5. Stop the ProactiveNet Server Database (dbsrv) and verify that no other processes are running.

pw process end dbsrv
pw system status

6. Replace the ProactiveNet Server Database data file, “storm_HOSTNAME.db” (\pw\sybase\), and transaction log, “pronto.log” (\pw\sybase\), with the Unloaded/Rebuilt copies (\pw\dbrebuild\).

NOTE: The Unloaded/Rebuilt transaction log, “storm_HOSTNAME.log” (\pw\sybase\), will have the same base-named as the ProactiveNet Server Database data file, “storm_HOSTNAME.db” (\pw\sybase\).

6.1 Start the database process

pw process start dbsrv
pw system status

7. Validate the ProactiveNet Server Database data file, “storm_HOSTNAME.db” (\pw\sybase\), and review the “pw.database.validate.txt” for any error messages.

>pw database validate -o pw.database.validate.txt

SQL Anywhere Validation Utility Version 11.0.1.2789 
VALIDATE DATABASE VALIDATE TABLE "DBA"."_AIXSERVCPUPOOL_BL"
 . . .
No errors reported

8. Start the ProactiveNet Server and verify all of the related processes are running.

pw system start
pw system status

Leave a Reply