#DateForumTypeThreadPost
714 Jul 2009 @ 03:00 PDTDatabaseReplyDBQLOGTBL SPOOL USAGE NOT CORRECT IN TD12can anyone help me on this please?
606 Jul 2009 @ 01:41 PDTDatabaseReplyDBQLOGTBL SPOOL USAGE NOT CORRECT IN TD12I look for the maximum of current spool with pmon during query execution and compare it with dbqllogtbl spool usage column value after query execution.
502 Jul 2009 @ 10:22 PDTDatabaseReplyDBQLOGTBL SPOOL USAGE NOT CORRECT IN TD12Measuring by the spoolusage column of the dbqlogtbl
401 Jul 2009 @ 07:31 PDTDatabaseTopicDBQLOGTBL SPOOL USAGE NOT CORRECT IN TD12THE 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...
317 Jun 2008 @ 03:05 PDTDatabaseReplyFastExport to TextHi,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...
217 Jun 2008 @ 02:54 PDTDatabaseReplyMoving data between 2 servers in TeradataIf your table is smaill you can even do a bteq export/import
117 Jun 2008 @ 02:36 PDTDatabaseReplywhat 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...