Profiles define values for the following system parameters:
- Default database
- Spool space
- Temporary space
- Default account and alternate accounts
- Password security attributes
- Optimizer cost profile
- Query band
An administrator can define a profile and assign it to a group of users who share the same settings.