Element command overview

Each element on the Element Selection panel corresponds to one or more changeable items in a Db2 subsystem. With OPERTUNE, you can make immediate modifications to a ZPARM value without cycling the subsystem.

Before you begin

Before using any of the OPERTUNE elements, you must perform the following steps:

• Specify a valid target OPERTUNE and a valid Db2 subsystem or data sharing group (see  Selecting-a-target-OPERTUNE-and-subsystem ).
• Ensure that you have the proper authority to execute the command (see  Security ).

To access the element commands

1. Select the Subsystem parameters (ZPARMS) option from the Main Selection Menu to display the Element Selection panel.

   DDTG DBI1 Element Selection    Row 1 of 94
   Command ===> ________________________________________________ SCROLL ===> PAGE
   
   Select the desired Element(s) with one of the following. Then press Enter.
   Q =Query R =Reset S =Set SN =Set with noreset
   
   Act Element Description
   .. ABIND ENABLE AUTOMATIC REBIND
   .. ACCESS DB2 ACCESS MODE
   .. ARCALLOC ARCHIVE ALLOCATION CONTROL
   .. ARCBLKSZ ARCHIVE DATA SETS BLOCK SIZE
   .. ARCBSDS # OF ARCHIVE DATA SETS IN BSDS
   .. ARCCATLG ARCHIVE CATALOG PARAMETER
   .. ARCCOMP ARCHIVE LOG COMPRESSION
   .. ARCHIVE LOG ARCHIVING SWITCH
   .. ARCPREF ARCHIVE DATA SET PREFIXES
   .. ARCPROT ARCHIVE LOG SECURITY PROTECTION
   .. ARCRETN ARCHIVE RETENTION PERIOD
   .. ARCTSTMP ARCHIVE TIMESTAMP OPTION
   .. ARCUNIT ARCHIVE UNIT
   .. ARCWTOR ARCHIVE WTOR PARAMETER
   .. ARC2FRST REQUEST COPY2 ARCHIVE LOGS
   .. ASSIST ASSIST PARALLEL PROCESSING
   .. AUTHCACH AUTHORIZATION CACHE SIZE
2. Select one or more elements by typing any of the following line commands next to the elements and pressing Enter:

• 
  
  • Q to build a QUERY command
  • R to build a RESET command
  • S to build a SET command

  • SN to build a SET command with the NORESET option

    Important

    If you request a RESET for an element that cannot be reset (for example, EDMPOOL), OPERTUNE redisplays the selection list with that element at the top of the panel and places an asterisk (*) in the select field. You must make a new selection or replace the asterisk with a blank.

This section contains the following topics: