Database Template Parameters

  • The INFORMATION_SCHEMA is an SQL standard schema with a set of views. This is an optional schema for any database. Use the template parameter create_information_schema to set whether to create an information schema when creating a database. The defualt value is true. For example,
    create_information_schema=true

  • Use db.connection.print to print log messages when users connect and disconnect from databases. This parameter applies when using a database. The default is true. For example,
    db.connection.print=true

  • Use sql.statement.audit to print statement execution information to log files. This information includes the statement text and execution time for each statement executed. This parameter applies when using a database. For example,
    sql.statement.audit=true

  • Use sql.case_insensitive as template parameter for a database to determine whether SQL statements are case insensitive for the database. This parameter applies when using a database. For example,
    sql.case_insensitive=true

  • Set the checkpoint interval for the database, i.e. how many seconds to wait before the next checkpoint. For databases that are infrequently updated, checkpoint intervals can be set to a larger value. This parameter applies when using a database. For example,
    checkpoint_interval=15

  • Set template file for a database schema object, which applies a set of default schema template parameter values for all schemas in the specific database. For example,
    schema_default_template=default.tpl

  • Set template file for a database table object, which applies a set of default table template parameter values for all tables in the specific database. For example,
    table_default_template=default.tpl

  • Set template file for a database view object, which applies a set of default view template parameter values for all views in the specific database. For example,
    view_default_temp.late=default.tpl

  • Set template file for a database index object, which applies a set of default index template parameter values for all indexes in the specific database. For example,
    index_default_template=default.tpl

  • Set template file for a database query object, which applies a set of default query template parameter values for all queries in the specific database. For example,
    query_default_template=default.tpl

  • Set template file for a database user object, which applies a set of default user template parameter values for all users in the specific database. For example,
    user_default_template=default.tpl

  • During recovery, table counts and the largest tuple id values are updated based on the redo and undo performed on the table. However, it is possible for table row counts to get incorrectly set, in which case a check table needs to be run to fix that. This can be turned on or off as required, and the recovery is faster if it is off, with th epotential for incorrect table sizes. The default is off. For example,
    db.do_recovery_table_check=false

  • Use ignore_null_elimination_warning to set whether to generate warning on null value elimination in set functions. Default value of this parameter is false. If this parameter is set to false, then optimization is perfomed on the set functions, which will speed up the procession. For example,
    ignore_null_elimination_warning=true

  • Use check_selectlist_with_groupbycolumns to set whether to check the select list of a select query against the groupby columns list. The default value of this parameter is true, which means that the select list of a select query with group by clause, can have only set functions(min, max, count, sum, avg) or columns which exists in the groupby columns list. This parameter can be set to false to allow columns other than the ones from groupby columns list, in the select list. For example,
    check_selectlist_with_groupbycolumns=false