Need to setup Insight database

book

Article ID: 106262

calendar_today

Updated On:

Products

CA Bind Analyzer for DB2 for z/OS CA Detector CA SQL-Ease for DB2 for z/OS CA Sysview Performance Management Option for DB2 for z/OS CA Database Detector for DB2 for z/OS CA Plan Analyzer for DB2 for z/OS CA Subsystem Analyzer for DB2 for z/OS

Issue/Introduction

DDL need for additional tablesĀ 

I got the DDL from the Source dataset to create the INSIGHT database.
I am already having 35 tables compared to the script which creates only 27 tables only.
Please suggest if I need to refer to some other dataset for the remaining tables.

Environment

z/os DB2

Resolution

The 8 tables TCA_AUDCLAS3 TCA_AUDCLAS4 TCA_AUDCLAS5 TCA_AUDCLAS6 TCA_AUDDISTR TCA_AUTHFAIL TCA_GRANTREV TCA_UTILTRAC Would look to be 8 online reports which can run in batch as reports.
Here is a link to the documentation on these reports.
https://docops.ca.com/ca-sysview-db2/19/en/reference/batch-reports/audit-batch-reports/commonly-converted-online-audit-requests
So although we do not supply DDL and load statements for these reports, we do have an option based on the Batch Reporter where users can create their own tables and load statements.
This is what i think has happened on your system.
Here is a link to the Batch Reporter "Load Statement Generator"
https://docops.ca.com/ca-sysview-db2/19/en/configuring/utilities/load-statement-generator-nsightrw