WCC 11.4.x Database activity during startup

Products

• CA Workload Automation AE

Issue/Introduction

During a recent restart of WCC 11.4.x we noticed suspicious activity in the database.
Multiple create table statemets were issued.
Table names included 
ao_realm
ao_installationfiles
ao_scheduler
cfg_global_pref
ao_schagent_plugin
sequence

Environment

Release : 11.3.6

Component : CA WORKLOAD AUTOMATION ADVANCED INTEGRATION FOR HADOOP

Resolution

When WCC 11.4.x is installed you provide database connection information.
Example: Target db, id and password.
The 11.4.x install itself does NOT create the schema in the database.
The id must already exist and have specific permissions such that when 
the product is started it checks the db looking for the WCC specific
tables it needs.  If they do not already exist the product creates them
during that startup or later as a result of user interactions.

NOTE - As of WCC R12 the above has changed.  R12's installer creates
all the tables in the db upfront.  When you start WCC the tables must 
already exist.  It will NOT create any missing tables during startup.
This change was done to have WCC's behavior match more closely with AutoSys.

So, if your WCC is version 11.4.x it can be expected to potentially see
WCC try to create a table during startup or at a later time.

Note :

Tables that have the following prefixes are related to WCC:
AO_
CFG_
ECLI_
EDITOR_
FRCST_
MON_
RPT_
SEQENCE