# | Date | Forum | Type | Thread | Post |
---|---|---|---|---|---|
7 | 14 Jul 2009 @ 03:00 PDT | Database | Reply | DBQLOGTBL SPOOL USAGE NOT CORRECT IN TD12 | can anyone help me on this please? |
6 | 06 Jul 2009 @ 01:41 PDT | Database | Reply | DBQLOGTBL SPOOL USAGE NOT CORRECT IN TD12 | I look for the maximum of current spool with pmon during query execution and compare it with dbqllogtbl spool usage column value after query execution. |
5 | 02 Jul 2009 @ 10:22 PDT | Database | Reply | DBQLOGTBL SPOOL USAGE NOT CORRECT IN TD12 | Measuring by the spoolusage column of the dbqlogtbl |
4 | 01 Jul 2009 @ 07:31 PDT | Database | Topic | DBQLOGTBL SPOOL USAGE NOT CORRECT IN TD12 | THE SPOOLUSAGE FOUND IN DBQLOGTBL FOR A QUERY IS NOT CORRECT. IT DIFFERS A LOT FROM THE ACTUAL SPOOL USAGEOF A QUERY.Let me know any other way to extract accurate spool information after query exec... |
3 | 17 Jun 2008 @ 03:05 PDT | Database | Reply | FastExport to Text | Hi,Dont ever open a data file which you got. you can only use it to load an other table.Dont verify your data by opening your file. Just load an other table and verify your data.Thanks,Bharath Raja... |
2 | 17 Jun 2008 @ 02:54 PDT | Database | Reply | Moving data between 2 servers in Teradata | If your table is smaill you can even do a bteq export/import |
1 | 17 Jun 2008 @ 02:36 PDT | Database | Reply | what kind of query being logged in dbqlogtbl? how to enable logging for an account? | To check if a user has logging enabled in DBQL, do a select form the DBQL Rules table and look for the desiered user/account or for the profile of the desiered user/account and check if any logging... |