How to Rebuild the Derby Database for the CA Workload Control Center r11.3.5+

Document ID : KB000010230
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

When the Derby database experiences data corruption, you are no longer able to login to the WCC GUI. To make the GUI accessible again, the database must be rebuilt. After your database is rebuilt, you will be able to login to the GUI but you will notice that none of your monitoring views or AE configurations are present.

This is the procedure to export your monitoring views/filters/alerts/configurations from WCC so they can be imported into your rebuilt Derby database. 

Environment:
CA Workload Control Center r11.3.5+CA Workload Control Center r11.4+
Instructions:

1.Export all views, their filters, alert policies using the following command: 

Windows: wcc_monitor.bat -u username -p password -x monitor_filename 

Linux: ./wcc_monitor.sh -u username -p password -x monitor_filename

 

2.Export all configurations (including AE definitions) using the following command: 

Windows: wcc_config.bat -u user_name -p password -x config_filename

Linux: ./wcc_config.sh -u user_name -p password -x config_filename

 

3.Stop all WCC services

 

4.Rename the DB_FILES directory under the %CA_WCC_INSTALL_LOCATION%\derby directory (or $CA_WCC_INSTALL_LOCATION/derby directory)

 

5.Restart WCC services (this will force WCC to recreate the database)

 

6.Log into the WCC GUI (it may take a while to log into WCC because the database is still being created at this time)

 

7.Import your config_filename using the following command:

Windows: wcc_config.bat -u username -p password -i config_filename 

Linux: ./wcc_config.sh -u username -p password -i config_filename

 

8.Within the GUI, validate the AE server(s) (if they haven't already been validated after the import)

 

9.Import your monitor_filename using the following command:

Windows: wcc_monitor.bat -u username -p password -i monitor_filename 

Linux: ./wcc_monitor.sh -u username -p password -i monitor_filename