Setting Up DBQLRuleTbl - Teradata Database

Teradata Database Node Software Migration Guide

Product
Teradata Database
Release Number
16.10
Published
November 30, 2017
Language
English (United States)
Last Update
2018-04-25
dita:mapPath
bkn1504122461303.ditamap
dita:ditavalPath
5942_Migrating_1610.ditaval
dita:id
B035-5942
lifecycle
previous
Product Category
Software

This task is optional.

Database Query Logging (DBQL) data is not automatically migrated from the source to the destination system. However, if DBQL logging data was manually copied from the DBQL tables to user tables prior to archiving the source system, the data must be repopulated to the DBC.DBQLRuleTbl, before DBQL logging on the destination system is begun.
  1. Repopulate the DBC.DBQLRuleTbl using one of the following methods:
    • Run the bteq script that was created by the pre_upgrade_prep.pl script with the BEGIN QUERY LOGGING statements.
    • Issue the BEGIN QUERY LOGGING statements manually.