7813 Nov 2007 @ 11:02 PSTDatabaseTopicNode Memory optimizationHi,I am looking for Node Memory Optimization for Operating Systemis there any SQL or tool to do and check it .Thanks for all the replies
7706 Nov 2007 @ 01:12 PSTDatabaseReplyCollect Stats on Primary Indexesrequest replies
7605 Nov 2007 @ 12:37 PSTDatabaseTopicCollect Stats on Primary IndexesHi,Is ther any different syntax to collect stats on Primary indexes or just collecting the stats on column will do the some Thanks
7501 Nov 2007 @ 08:49 PDTDatabaseReplyInserting rows in DBQRYLOGTBLRequest your replies
7431 Oct 2007 @ 04:55 PDTDatabaseTopicInserting rows in DBQRYLOGTBLI want to insert some rows from old backup table of qrylog into DBC.QRYLOGTBL let me know how can I do this and also by which userThanks
7301 Oct 2007 @ 02:55 PDTDatabaseTopicFloat data ype compressionHello all,I have a very huge table 100 GB comprising of many float values , I want to compress them is there any better way of identifying float values whose compression will benifit ?I tried but ...
7224 Sep 2007 @ 11:35 PDTToolsReplyArcmain Question : Rollforward works only with RESTORE ?Hi,Thanks for reply, I tried but it did not worked ,that is copying table, followed by copying journal table and apply option for the table .you can also try and let me know if it worked at your e...
7122 Sep 2007 @ 12:41 PDTToolsTopicArcmain Question : Rollforward works only with RESTORE ?Hi,I am trying to Rollforward database tables using Rollforward but I am not able to do it if I use COPY with ROLLFOFORWARD however I am able to do it using RESTORE with ROLLFOWARDany thoughts
7022 Sep 2007 @ 12:34 PDTToolsReplySQL assistant vs BTEQis there any difference in collecting statistics between SQl Assistant and BTEQ
6920 Sep 2007 @ 05:01 PDTDatabaseReplyHow to enable RSS TablesThanks for reply , there are two table sdsk and pdsk do you knwo where they can be of good use
6819 Sep 2007 @ 11:02 PDTDatabaseTopicHow to enable RSS TablesHi,I want to enable RSS tables I have OS NCR MPRAS Thanks  
6713 Sep 2007 @ 06:35 PDTToolsTopicRollforward in arcmainHi,I am looking for syntax and example of rollforward used in arcmian can anyone help I am using permanent journals
6613 Sep 2007 @ 05:53 PDTDatabaseReplyArcmain RollforwardRequest your replies
6512 Sep 2007 @ 01:11 PDTDatabaseTopicArcmain RollforwardHi,let me know how to rollforward the tables after restoring (using Copy) tablesI am using Permanent Journalsi.e. syntax and example rollforward works with COPY or RESTORE ?Thanks
6430 Aug 2007 @ 02:41 PDTConnectivityTopicArcmain and lockHi,is it possible to update a table while arcmain is backing up .can access locks be used
6322 Aug 2007 @ 03:44 PDTConnectivityReplyUDF and mainframeThanks for reply ,Can you explain it with an example I plan to use UDF in ETL program which runs from MF
6221 Aug 2007 @ 02:43 PDTConnectivityTopicUDF and mainframeis it possible to use UDF where code is kept on mainframe
6114 Aug 2007 @ 05:41 PDTToolsTopicTeradata Utilities V2R6Any new features in Teradata Utilities for V2R6like in Load,Fastload etc.
6029 Jul 2007 @ 03:52 PDTDatabaseReplyTpump Sessions blocking each otheris there anything to do with SERIALIZE ON
5928 Jul 2007 @ 02:03 PDTDatabaseTopicGroup by SQL performanceI have many aggregate queries using group by 15 columns Could any body suggest how to tune the queries in such casese.g. Select sum (c1)Sum(c2)---from abcd group by 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15
5828 Jul 2007 @ 01:57 PDTDatabaseTopicTpump Sessions blocking each otherI am seeing TPUMP sessions blocking each other ,how to resolve this ? is there any Tpump command
5728 Jul 2007 @ 01:56 PDTDatabaseReplyLocks : Blocks and Blockingis it normal to have blocks and blocking sessions?or we need to resolve such situtations
5628 Jul 2007 @ 04:17 PDTDatabaseTopicLocks : Blocks and BlockingSometimes during the batch windows I see from PMON Block and Blocking session .Is there any way I can record all such sessions and time and then troubleshoot them are these locks delay in Batch win...
5523 Jul 2007 @ 02:15 PDTDatabaseReplyTeradata compression and Float data typeRequest replies
5422 Jul 2007 @ 09:24 PDTDatabaseTopicTeradata compression and Float data typeI want to compress float data type , please share your experiences I have seen float values similar but counted differently