Skip to content

Teradata – DBQL DETAIL TABLES did not load

ISSUE:

PDCR job failed with below error:
LD_Error6: The DBQL DETAIL TABLES did not load. SqlState = ‘T2646’, SqlCode = 2646 when executing SQL statement number 106

or

[Teradata Database] [TeraJDBC 15.10.00.09] [Error 2646] [SQLState HY000] No more spool space in PDCRAdmin.

DESCRIPTION:

PDCR job will fail with this error if spool for PDCRADMIN is not big enough. Try to increase the spool for PDCRAdmin user and re-run the job. No other action is needed to fix this issue.

Teradata – SQL Performance Issues diagnostics 101

Basic 101 for Teradata sql performance issue:

1) Look at explain plan for the sql. eg:
explain
select * from dbc.tables;

2) For more details on explain plan and get suggestions on missing stats enable helpstats at session level and the run explain plan. eg:
diagnostic helpstats on for session;
explain
select * from dbc.tables;

3) For more detailed explain with recomendations enable verboseplain at session level and the run explain plan. eg:
diagnostic verboseexplain on for session;
explain
select * from dbc.tables;