-START PROFILE command (Db2)

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

Important: Start of changeIf the value of the PROFILE_AUTOSTART subsystem parameter is set to YES, the START PROFILE command is issued automatically as part of Db2 start processing.End of change
Tip: For best results, do not issue a STOP PROFILE command when you add or modify existing profiles. Use the STOP PROFILE command only if you intend to disable all existing profiles.

If the profile tables data structure already exists when a START PROFILE command executes, Db2 deletes it, and a new structure is created. After loading the database, the functions specified in the profile tables become active. Only the rows in the profile table with column PROFILE_ENABLED='Y' are activated.

Db2 supports a maximum of 4096 active DSN_PROFILE_TABLE rows.

Important: Start of changeAlways check the status of any newly added profile table rows in the STATUS columns of DSN_PROFILE_HISTORY and DSN_PROFILE ATTRIBUTES_HISTORY tables after you issue the START PROFILE command. Successful completion of the START PROFILE command does not imply that all profiles started successfully. If the STATUS column of either history table contains a value that does not start with 'ACCEPTED', further action is required to enable the profile or the keyword action.End of change

Abbreviation: -STA PROFILE

Environment

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

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:
  • SQLADM authority
  • System DBADM authority
  • SYSOPR authority
  • SYSCTRL authority
  • SYSADM authority

Syntax

Read syntax diagramSkip visual syntax diagram START PROFILE

Example

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