请教teradata问题 - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

请教teradata问题

请教teradata问题# Database - 数据库

c*j2008-11-11 08:11

1 楼

请问有没有什么工具能够查到Teradata server所接受的Query呢？类似于SQL Server
Profiler的咚咚？
Thanks

w*r2008-11-11 08:11

2 楼

turn on DBQL Logging or use TASM to log deatail for the workload you are
targetig to log, then check the content of dbc.qrylogtbl table or dbc.
querylog view.
Be careful when you turn on logging for high-concurrent workload with detail
steps logging, it do have performance complication(not quite visible for
low activity OLAP systems).

【在 c******j 的大作中提到】

: 请问有没有什么工具能够查到Teradata server所接受的Query呢？类似于SQL Server
: Profiler的咚咚？
: Thanks

c*j2008-11-11 08:11

3 楼

Thanks, could you please kindly give some details? I am totally new to this
server.

w*r2008-11-11 08:11

4 楼

for DBQL Logging
Begin query logging [with ,*] [LIMIT [AND <
limit option>}*} ON [username ,] | ACCOUNT= (account string,*)>;
check the SQL Reference Database Definition Statements manual.
For TASM , check the Teradata document broucher and search Teradata Dynamic
Workload
Management
Both methods write the results into a set of DBQL Tables plus a couple of
TASM summary tables. Details
can be found in the SQL Reference DDL reference.

detail

【在 w*r 的大作中提到】

: turn on DBQL Logging or use TASM to log deatail for the workload you are
: targetig to log, then check the content of dbc.qrylogtbl table or dbc.
: querylog view.
: Be careful when you turn on logging for high-concurrent workload with detail
: steps logging, it do have performance complication(not quite visible for
: low activity OLAP systems).

c*j2008-11-11 08:11

5 楼

Thanks a lot!