Version 8.51 of Extended Parallel Server introduces seven new configuration parameters:
| Parameter | Description |
|---|---|
| FORCE_DDL_EXEC | In onutil SET commands at run time, this enables a feature that aborts concurrent DML operations in other sessions that hold locks on database objects that DDL operations reference in the current session. |
| DISABLE_FILE_CLOSE_
OPTIMIZATION |
When set to 0, this prevents certain files associated
with DML operations on tables from being closed until the transaction is either
committed or rolled back.
When set to 1, it prevents those files from remaining open after the DML operations on those tables are aborted. For more information about this parameter and FORCE_DDL_EXEC, see Forcing DDL Execution. |
| CLASS_DS_MEM_QUOTA | In a resource class definition section of the onconfig file, this sets the maximum percentage of DS_TOTAL_MEMORY that is available for memory-consuming queries, across all databases of the server instance, to the aggregate of all concurrent sessions of the resource class. Setting this to zero prevents sessions of the resource class from using shared memory in queries. |
| CLASS_DS_MAX_QUERIES | In a resource class definition section of the onconfig file, this specifies the maximum number of memory-consuming queries that can execute concurrently across all databases of the server instance in sessions of the resource class. Setting this to zero prevents sessions of the resource class from using shared memory in queries. |
| DS_CLASS_NAME | In a resource class definition section of the onconfig file, this declares a unique name for a resource class of the server instance. |
| DS_CLASSINFO | In onutil SET commands at run time, this can define a new resource class, or can override CLASS_DS_MEM_QUOTA and CLASS_DS_MAX_QUERIES settings from the onconfig file for an existing resource class. For more information about resource classes, see Allocating Memory Through Resource Classes. |
| REPACK_THREAD_MAX | This can specify the maximum number of repack threads that can run concurrently in all databases of the server instance. If you do not include this in the onconfig file, the default is 10. You can also reset this dynamically in onutil SET commands at run time. For more information about repack threads, see Allocating Memory Through Resource Classes. |