-START PROFILE (DB2)

The DB2® command START PROFILE loads or reloads the profile table into a data structure in memory.

If this data structure already exists, DB2 deletes it, and a new structure is created. The profile table must be loaded by issuing the command above explicitly. The table is not loaded when the database is initialized at the startup time. After loading the database, the functions specified in the profile become active. Only the rows in the profile table with column PROFILE_ENABLED='Y' are activated.

Abbreviation: -STA PROFILE

Environment

Start of changeThis command can be issued from the z/OS® console, through a batch job or the instrumentation facility interface (IFI).End of change

Data sharing scope: Member

Authorization

To execute this command, you must use a privilege set of the process that includes one of the following authorities:
  • Start of changeSQLADM authority End of change
  • Start of changeSystem DBADM authorityEnd of change
  • SYSOPR authority
  • SYSCTRL authority
  • SYSADM authority

Syntax

>>-START PROFILE-----------------------------------------------><

Examples

Example 1: This command is required to load the profile table into memory.
-START PROFILE