I am new to configuring memory in db2. I want to create a database using this command:
db2 CREATE DB TEST USING CODESET UTF-8 TERRITORY US AUTOCONFIGURE USING mem_percent 80 APPLY DB ONLY
According to IBM's Knowledge Center:
...the AUTOCONFIGURE command which will generate values for parameters based on your responses to questions about workload characteristics.
Some configuration parameters can be set to AUTOMATIC, allowing the database manager to automatically manage these parameters to reflect the current resource requirements. To turn off the AUTOMATIC setting of a configuration parameter while maintaining the current internal setting, use the MANUAL keyword with the UPDATE DATABASE CONFIGURATION command.
Is there a resource online that will tell me the values that AUTOCONFIGURE based on my current database manager configurations (assuming that I have not modified anything related to memory)? I want to know if not setting certain memory-related configurations will affect the performance of my database. For example, if I don't set configurations like pckcachesz to automatic, what is the default value of it?