Reviewing and setting system defaults

Before using a SQL/MX database, review the system defaults contained in the metadata table SYSTEM_DEFAULTS_SCHEMA.SYSTEM_DEFAULTS in the system catalog. Depending on your database needs, you might want to change some of the system defaults to alternative settings. To review the current settings, you can use the following statement:

OSS> mxci
>> SELECT * FROM NONSTOP_SQLMX_node_name.SYSTEM_DEFAULTS_SCHEMA.SYSTEM_DEFAULTS;
    

For more information, see SQL/MX Management Manual and the SQL/MX Reference Manual.