Syntax options:

    MULTISCHEMA IS ON | MULTISCHEMA IS OFF

    Specifies the multischema attribute for the database. If a
    database has the multischema attribute, you can create multiple
    schemas in that database and group them within catalogs. The
    MULTISCHEMA IS ON option is the default for databases created
    with the multischema attribute. MULTISCHEMA IS OFF is the default
    for databases created without the multischema attribute.

    You can create a database using the CREATE DATABASE MULTISCHEMA
    IS ON clause, but you cannot use ALTER DATABASE MULTISCHEMA IS
    OFF to take away the multischema attribute. Once a database has
    the multischema attribute, you cannot change it.