How to run SQL queries on the Derby Database for WCC

book

Article ID: 39384

calendar_today

Updated On:

Products

CA Workload Automation AE - Business Agents (AutoSys) CA Workload Automation AE - Scheduler (AutoSys) CA Workload Automation Agent

Issue/Introduction

Summary:

These are steps on how to connect to the Derby DB and run SQL queries from the command prompt.

 

Instructions:

For Linux

=========

1) cd $CA_WCC_INSTALL_LOCATION/bin

2) ./wcc_config.sh -u ejmcommander -p ejmcommander --displaydb

Logging in as ‘ejmcommander’ – SUCCESS

 

Database server connection

Host Name: localhost

Port: 1527

Database instance name: WCC_MAIN

Platform: derby

User: wcc

Password: *****

 

3) cd ../derby/lib

4) java -jar derbyrun.jar ij

5) Connect ‘jdbc:derby://localhost:1527/WCC_MAIN’ user ‘wcc’ password ‘*****’;

(Password will be what you chose during install)

 

After you have connected to the database, you will see the ij prompt and be able to use SQL queries.

For example:

ij> show tables;

ij> describe MON_JOB;

ij> select * from MON_JOB;

 

For Windows

===========

1) cd %CA_WCC_INSTALL_LOCATION%\bin

2) wcc_config.bat -u ejmcommander -p ejmcommander --displaydb

Logging in as ‘ejmcommander’ – SUCCESS

 

Database server connection

Host Name: localhost

Port: 1527

Database instance name: WCC_MAIN

Platform: derby

User: wcc

Password: *****

 

3) cd ..\derby\lib

4) java -jar derbyrun.jar ij

5) Connect ‘jdbc:derby://localhost:1527/WCC_MAIN’ user ‘wcc’ password ‘*****’;

(Password will be what you chose during install)

 

After you have connected to the database, you will see the ij prompt and be able to use SQL queries.

For example:

ij> show tables;

ij> describe MON_JOB;

ij> select * from MON_JOB;

Environment

Release: ATSYHA99000-11.3.6-Workload Automation AE-High Availability Option
Component: