Profiles define the system resources available to member users, and can also set password control parameters.
- Log on to the database as user DBC.
- Create the profile for the database administrator:
CREATE PROFILE admin_profile AS [ SPOOL = spool_space ] [ TEMPORARY = temp_space ] [ ACCOUNT = 'account' ];
- admin_profile
- The name of the database administrator profile (for example, DBADMIN).
- spool_space
- [Optional] The amount of space available for intermediate query results or formatted answer sets to queries and volatile tables. The system borrows spool space from unused permanent space anywhere in the system.
- temp_space
- [Optional] Required only when you use global temporary tables, volatile tables and other features that require temporary space.
- account
- [Optional] Account strings are an optional method of controlling the granularity of resource accumulations that are reported in the DBC.Acctg table. Account strings allow the collection of CPU and I/O that is reported in DBC.Acctg to be grouped by application time of day, and priority. Variable substitution parameters included in the account string will be resolved at runtime.