 |
 |
Archives of the TeradataForum
Message Posted: Thu, 21 Jan 2010 @ 15:42:43 GMT
Subj: | | Re: Step Name column of DBC.DBQLSTEPTBL |
|
From: | | Dieter Noeth |
Rehman Ansari wrote:
| In DBC.DBQLSTEPTBL there is one column Stepname which contains values as Edt, FDS, JIN, MLK, MRD, RET, SplTAB Can anyone explain what
that mean? | |
Search the "Database Administration" manual for "step descriptions" to get a list.
| Also using DBC.DBQLSTEPTBL how to trace exact step of Query which is utilising more resource. | |
In newer releases there's a lots of columns with info about CPU/IO/Spool-Usage etc. within that table.
Dieter
| |