Need to setup Insight database

Document ID : KB000106262
Last Modified Date : 20/07/2018
Show Technical Document Details
Introduction:
DDL need for additional tables 
Question:
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
Answer:
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