How to get sql command line access to the WCC derby database

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

Question:

How do I access the sql command line for the WCC derby database?

Answer:

1. Stop the CA-WCC-db service. Only one application can connect to the database at a time.

 

2. Change directory to the location of the database files for derby:

 

Windows: cd "C:\Program Files\CA\Workload Control Center\derby\DB_FILES"

 

Unix:    cd <WCC_INSTALL_LOCATION>\derby\DB_FILES

 

3. Execute the ij derby tool:

 

Windows "java  -jar "C:\Program Files\CA\Workload Control Center\derby\lib\derbyrun.jar" ij"

 

Unix    "java  -jar <WCC_INSTALL_LOCATION>\derby\lib\derbyrun.jar ij"

 

4. You should see an ij> prompt. At this command prompt type "connect 'jdbc:derby:<WCC_DERBY_DB_NAME>;bootPassword=srqadmin';"

 

Example:

 

connect 'jdbc:derby:WCC_MAIN;bootPassword=srqadmin';

 

5. If your able to login to the Database, you will get a command line prompt "ij>" with no error indication.

 

6. To test, show the tables that exist in the database. Type “show tables;” and hit Enter.

 

You should see a list of all the tables in the WCC Configuration/Reporting/Monitor databases.