DBS Control Settings | Teradata VantageCore | EDW - DBS Control Settings - Teradata VantageCore VMware

Teradata® VantageCore powered by Dell Technologies - Enterprise Data Warehouse

Deployment
VantageCore
Edition
VMware
Product
Teradata VantageCore VMware
Published
April 2024
Language
English (United States)
Last Update
2024-04-24
dita:mapPath
csc1707954420061.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
csc1707954420061
Product Category
Cloud
  VantageCore VMware Settings Dell Recommended Comments
File System Fields
3. PermDBSize 2047 512 512 is optimal for SSD-based platforms
4. JournalDBSize 254 254  
17. DisableAutoCylPack FALSE FALSE Set to TRUE during testing
Disk I/O Integrity Fields
1. System Tables ON ON  
2. System Journal Tables ON ON  
3. System Logging Tables ON ON  
4. UserTables ON ON  
5. Permanent Journal Tables ON ON  
6. Temporary Tables ON ON  
Performance Fields
3. DBSCacheThr 100 10 Assumes workloads typical of EDW
12. Read Ahead Count 15 2 Low read-ahead appropriate for SSD-based media or pdisks
Compression Fields
1. BlockLevelCompression ON ON  
3. CompressSpoolDBs.   IFNOTCACHED  
5. CompressMloadWorkDBs   UNLESSQBNO  
6. CompressPJDBs   ALWAYS  
7. MinDBSectsToCompress   32  
8. MinPercentCompReduction   10%  
9. CompressionAlgorithm ZLIB ZLIB  
10. CompressionLevel 1 1  
12. UncompressReservedSpace   5%  
14. CompressPermPrimaryDBs   1=UNLESSQBNO UNLESSQBNO
15. CompressPermFallbackDBs   1=UNLESSQBNO UNLESSQBNO
16. CompressPermPrimaryCLOBDBs   1=UNLESSQBNO UNLESSQBNO
17. CompressPermFallbackCLOBDBs   1=UNLESSQBNO UNLESSQBNO
18. CompressGlobalTempPrimaryDBs     UNLESSQBNO
19. CompressGlobalTempFallbackDBs     UNLESSQBNO
20. CompressGlobalTempPrimaryCLOBDBs     UNLESSQBNO
21. CompressGlobalTempFallbackCLOBDBs     UNLESSQBNO
32. EnableTempBLC     FALSE
33. DefaultTableMode     MANUAL
34. TempBLCThresh     COLD
35. TempBLCSpread     5%
36. TempBLCInterval     10 minute(s)
37. TempBLCIOThresh     1
38. TempBLCPriority     MEDIUM/DEFAULT
39. TempBLCRescanPeriod     7 day(s)
40. CompressionZLIBMethod   IPPZLIB IPPZLIB
41. OverrideARCBLC     TRUE
Checksum Levels
1. System Tables ON    
2. System Journal Tables ON    
3. System Logging Tables ON    
4. User Tables ON    
5. Permanent Journal Tables ON    
6. Temporary Tables ON    
Internal Fields
9. WorkDBSize 2047 1024 512-1024 is optimal for SSD-based platforms
31. InMemoryHashJoin FALSE   Default
113. FallBackSetting 2   100% Fallback
178. Temporal Purchased FALSE   Default
233. Row Level Security FALSE   Default
314. nPath and Sessionize (TD 16.20) TRUE   Default
245. Columnar Purchased FALSE   Default
348. SecureZonesPurchased FALSE   Default
400. IPEFeedback (TD 16.10) 0=1, 1=1 (For Developer, Base, Advanced)0=0, 1=0 (For Enterprise)   Default
403. Enable In-Memory Optimization FALSE   Default
404. In-Memory Hash Table Size 100   Default