Updating a profile

Each row in the Db2® table DSN_PROFILE_TABLE defines the filtering criteria for a system profile. You might need to modify that criteria as business requirements change. When you apply changes to an existing started profile, you must restart it again before the changes are applied.

Procedure

To update a profile:
  1. On the DB2 Administration Menu (ADB2) panel, specify option Z, and press Enter.
  2. On the System Administration (ADB2Z) panel, specify option 2P, and press Enter.
  3. On the Display/Manage Profile Tables (ADB2Z2P) panel, specify option 1, and press Enter.
  4. On the Display Profiles (ADB2Z2P1) panel, specify the U line command, and press Enter.
  5. On the Insert/Update Profile (ADB2Z2PP) panel, edit the profile information as needed.

    For a description of these fields, see DSN_PROFILE_TABLE profile table (Db2 13 for z/OS documentation) .

  6. Press Enter to update this information in DSN_PROFILE_TABLE.
  7. Start or restart profiles.

    In certain cases, such as changes to optimization parameters, you might need to take additional steps. See Modifying existing profiles (Db2 13 for z/OS documentation) .