Archives of the TeradataForum

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

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

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>>