As you monitor and tune the database server, you might want to change global resource limit parameters without stopping and restarting the database server. You might also see specific sessions who either need more resources or are using more than their share of resources.
User informix and user root can use the onutil SET command to change the values of the following configuration parameters temporarily on all coservers:
Use onmode -g to change the value of DS_TOTAL_TMPSPACE. Use the PERSISTENT keyword with the onutil SET command to make the change permanent. Otherwise these changes remain in effect only as long as the database server is up and running. The next time that the database server is initialized, it uses the values set in the ONCONFIG file.
For more information about these configuration parameters, refer to Tuning Configuration for Resource Usage. For more information about how to use onmode with xctl, refer to the IBM Informix: Extended Parallel Server Administrator's Guide.
If you change the values of the decision-support parameters regularly, such as to set MAX_PDQPRIORITY to 100 each night for processing reports, you can use a scheduled operating-system job to set the values. For information about creating scheduled jobs, refer to your operating-system manuals.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]