About Collectors
Pre-requisites
Collector Server Minimum Requirements
Teradata Requirements
-
Access to Teradata
Step 1: Create Teradata permission
This step is performed by the Teradata Admin.
-
Login to Teradata
-
Create a KADA_USER account with read access to the following tables
dbc.DBQLOGTBL
dbc.DBQLSQLTBL
dbc.TABLESV
dbc.COLUMNSV
dbc.INDICESV
dbc.ALL_RI_CHILDRENV
dbc.TVM
dbc.DATABASES2V
dbc.TABLES
dbc.TEXTTBL
dbc.TABLESIZE -
If you have PDCR enabled then also need to access to these tables
pdcrinfo.DBQLOGTBL_HST
pdcrinfo.DBQLSQLTBL_HST -
SHOW command access on tables, macros, procedures.