Regardless of the amount of available memory on your system, you need to use it effectively. To determine if your system is using memory effectively:
- Start with a value for FSG Cache percent. See Managing FSG Cache.
- Adjust the value based on available free memory requirements. See Reserving Additional Free Memory for Applications and About Managing Free Memory.
- Consider adjusting other memory-related settings to optimize database function.
- IdCol Batch Size
For information on how to adjust DBS Control memory settings, see Teradata Vantage™ - Database Utilities , B035-1102 .