Problem Statement: Problem Statement

This is set only when you install the product and request, as part of the installation process, that a server instance be created:

• This is set only when you install the product and request, as part of the installation process, that a server instance be created:

• It sets the sizes of memory and storage spaces to allocate based on the number of expected concurrent users provided by the user during the install.
• SMALL = 1 - 100 users
• MEDIUM = 101 - 500 users
• LARGE = 501 - 1000 users
• XLARGE = more than 1000 users

• The setting affects the following:

• The size of the buffer pool.
• The maximum size of logical log files (from 200 MB up to 2 GB) before the server stops automatically adding logical logs to improve performance
• The initial size (from 50 MB to 500MB) of the following created storage spaces, which are created automatically during installation:
• An extendable plogspace for the physical log
• A dbspace for the logical log
• Dbspaces for databases and tables
• A temporary dbspace
• An sbspace
• A temporary sbspace
•