Overview

Use the jdbcmk.sh utility to update database tables and create required database objects during the upgrade process.

Upgrade APWMQ / WGS Tables

1. Run the jdbcmk utility

   • From your shell: ./jdbcmk.sh
     

2. From the jdbcmk main menu, select Option 2.
   
   

3. Then select Option 2 from WGS/MANAGE DATABASE menu, to upgrade the APWMQ/WGS tables.

Upgrade PERMITSV3 / Manage Tables

1. Run the jdbcmk utility

   • From your shell: ./jdbcmk.sh
     

2. From the jdbcmk main menu, select Option 2.
   
   
    

3.  Then select Option 4 from WGS/MANAGE DATABASE menu, to upgrade the PERMITSV3 / Manage tables.

Create Job Scheduler Table

Creating AP_SCHED table

1. Run the jdbcmk utility

   • From your shell: ./jdbcmk.sh
     

2. From the jdbcmk main menu, select Option 3.
   
   
3. Then select Option 1 from SCHEDULER DATABASE menu, to create AP_SCHED tables.

Creating QUARTZ tables

1. Run the jdbcmk utility

   • From your shell: ./jdbcmk.sh
     

2. From the jdbcmk main menu, select Option 3.
   
   
3. Then select Option 4 from SCHEDULER DATABASE menu, to create QUARTZ tables.

Create Track Tables

1. Run the jdbcmk utility

   • From your shell: ./jdbcmk.sh
     

2. From the jdbcmk main menu, select Option 5.
   
   

3. Then select Option 1 from TRACK DATABASE menu, to create Track tables.

Create DS Tables

1. Run the jdbcmk utility

   • From your shell: ./jdbcmk.sh
     

2. From the jdbcmk main menu, select Option 4.
   
   

3. Then select Option 1 from DATA SERVICES DATABASE menu, to create DS tables.

Create Pinot Topics and Tables

Ensure that the ZooKeeper, Kafka, and Pinot (Controller, Server, and Broker) services are running before proceeding.

1. Run the jdbcmk utility

   • From your shell: ./jdbcmk.sh
     

2. From the jdbcmk main menu, select Option 4.
   
   

3. Then select Option 3 from DATA SERVICES DATABASE menu, to create Pinot Topics and tables.