Problem Statement: Problem Statement

Configuration

• Configuration

• The new AUTO_LLOG configuration parameter specifies
• Dbspace for new logical log files
• Maximum size of all logical log files.

• Estimation of maximum logical log space requirements:

• Depending on the number of concurrent users accessing your database server…….
• 1 - 100: 200 MB
• 101 - 500: 500 MB
• 501 - 1000: 1 GB
• More than 1000: 2 GB

onconfig.std value 0

• onconfig.std value 0

• By default this is 0, disabled.

• AUTO_LLOG 1, dbspace_name, max_size

• 1 - Add Logical logs when needed to improve performance.
• dbspace_name - dbspace name in which to add logical log files.
• This dbspace must have the default page size for the operating system.
• max_size = Optional. Default is 2048000 KB (2 GB).
• The maximum size in KB of all logical log files, including any logical log files that are not stored in the dbspace dbspace_name.
• If max_size is not specified, the AUTO_TUNE_SERVER_SIZE configuration parameter setting affects the maximum size.
• Takes effect:
• After you edit the onconfig file and restart the database server.
• Reset the value dynamically in your onconfig file by running the onmode -wf command
• Reset the value in memory only by running the onmode -wm command.