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