Create database profiles using the CREATE PROFILE statement, for example:
CREATE PROFILE profile_name AS ACCOUNT = [‘account_str1’...,’account_str2’], DEFAULT DATABASE = database_name, SPOOL = spool_space, TEMPORARY = temp_space, PASSWORD = (attribute = value, attribute = value...) QUERY_BAND = ‘pair_name=pair_value;[...]’ [[NOT] DEFAULT];
where:
| Syntax Element | Description |
|---|---|
| profile_name | Required. The name of the profile. Recommendation: Where possible, incorporate parameters such as the user type or user department into the profile name to identify the profile function. |
| ‘account_str1’...,’account_str2’ | 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 execution time. A secondary use of account strings is to direct the classification of a query to a default Timeshare workload in TASM or TIWM. This classification will be effective only in cases where normal classification processes do not match the query to a user-defined workload. Enter one or more account strings based on the account setup suggestions shown in Teradata Vantage™ - Database Administration, B035-1093. |
| DEFAULT DATABASE = database_name | Optional. The database the user is most likely to access. Recommendation: Specify the default database at the user level rather than in the profile, to allow for differences in profile member (user) requirements. The database must exist before you identify it as the default.
|
| spool_space | Optional. The maximum amount of space available for intermediate query results, volatile tables, or formatted answer sets to queries. The system borrows spool space from unused system perm space, such as the spool reserve shown in Creating the Spool Space Reserve. Recommendation: Specify approximately 20% of the perm space available to the largest database the user accesses. Periodically monitor spool usage and modify spool allocations where required, as described in Teradata Vantage™ - Database Administration, B035-1093. |
| temp_space | Optional. Required only when using global temporary tables and other features that require temporary space. For information, see Teradata Vantage™ - Database Administration, B035-1093. |
| PASSWORD = (attribute = value,attribute = value ...) | Optional. Specify values for password control attributes if profile members cannot use default values. For available options, see About Password Controls. |
| QUERY_BAND = ‘pair_name=pair_value;[...]’ [[NOT] DEFAULT] | Optional. Set a default query band in a profile for tracking and controlling system usage. The profile query band is automatically set for the session at logon time. For more information, see Using a Profile to Set a Default Query Band and "SET QUERY_BAND" in Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144. |
For complete CREATE PROFILE syntax and options, see Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.