Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 04 Aug 2000 @ 18:57:41 GMT


     
  <Prev Next>   <<First <Prev
Next>
Last>>
 


Subj:   Re: Configuration
 
From:   Andy Blevins

There are a number of parameters that can be changed that MAY increase performance. I would not recommend that these be changed until someone who is a qualified and experienced Teradata performance analyst has done a performance audit on your system. Changing these parameters can cause bad these to happen if they are set to the wrong settings or changed for the wrong reasons. Here are some of the parameters:

     DBS Control Record - File System Fields:

         1.  FreeSpacePercent
         2.  MiniCylPackLowCylProd
         3.  PermDBSize
         4.  JournalDBSize
         5.  DefragLowCylProd
         6.  PermDBAllocUnit
         7.  WriteDBsToDisk
         8.  Cylinders Saved for PERM

     DBS Control Record - Performance Fields:

         1.  DictionaryCacheSize
         2.  DBSCacheCtrl
         3.  DBSCacheThr
         4.  MaxParseTreeSegs
         5.  ReadAhead
         6.  StepsSegmentSize
         7.  RedistBufSize
         8.  DisableSyncScan
         9.  SyncScanCacheThr
        10.  HTMemAlloc
        11.  SkewAllowance

Depending upon what symptoms you are seeing, some of these may be changed to improve the situtation. For example, if you are getting errors when you try to parse large complex SQL, increasing the DictionaryCacheSize & MaxParseTreeSegs may solve this.



     
  <Prev Next>   <<First <Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023