DBOPT
Purpose
Use this statement to support Dynamic Workload Console reporting. It provides the information required to connect to the database and store data. The information is used by the Java™ program that populates the history tables and by the server that provides the URL information to Dynamic Workload Console process.
Format
Parameters
- CLEANUPPOLICY (days|10)
- The number of days for which the historical run data is kept in the database. Data older than the number of days specified is deleted. The default value is 10 days.
- CODEPAGE (host system codepage|IBM–037)
- The name of the host code page, used by the archiving process. You
can provide the IBM®–nnn value, where nnn
is the EBCDIC code page. The default value, IBM®–037,
defines the EBCDIC code page for US English, Portuguese, and Canadian French. The following list
shows the EBCDIC code pages:
- IBM®–939
- Japan Extended
- IBM–937
- Taiwan
- IBM–935
- China
- IBM–933
- Korea
- IBM–975
- Greece
- IBM–971
- Iceland
- IBM–970
- Latin 2
- IBM–838
- Thai
- IBM–500
- International
- IBM–424
- Israel
- IBM–297
- France
- IBM–285
- UK
- IBM–284
- Spain - Latin America
- IBM–280
- Italy
- IBM–278
- Sweden - Finland
- IBM–277
- Denmark - Norway
- IBM–274
- Belgium
- IBM–273
- Germany
- IBM–1388
- China
- IBM–1122
- Estonia
- IBM–1112
- Baltic
- IBM–1047
- Open Systems
- IBM–1026
- Latin 5 (Turkey)
- IBM–1025
- Cyrillic
- IBM–1140
- Finland, Sweden
- IBM–1141
- Austria, Germany
- IBM–1142
- Denmark, Norway
- IBM–1143
- USA
- IBM–1144
- Italy
- IBM–1145
- Spain, spanish-speaking Latin America
- IBM–1146
- UK
- IBM–1147
- France
- IBM–1148
- Belgium, Switzerland
- DBPSW (password)
-
The password associated with the user set in DBUSER. To avoid leaving the password in plaintext, you can have it encrypted. For details about how to encrypt the password, see Managing the Workload.
The password can be long up to 15 characters. This limit ensures that the password will continue to fit on one line after it is encrypted.
This parameter is required and does not have a default value. - DBURL (url)
-
Information about the URL, in the following format:
Ensure thatjdbc:db2://server:port/database
jdbc:db2
is written in lowercase format, and replace the variables as follows:- server
- TCP/IP address or host name of the system where the database resides.
- port
- SQL port number used by the DB2® server.
- database
- Name of the target database.
- DBUSER (userid)
- The user ID to access the database. This parameter is required and does not have a default value.
- EXTENDEDARC (YES|NO)
- Specifies
the type of occurrences that are saved by the archiving process.
If you specify YES, the archiving process stores the occurrences belonging to the old current plans and the completed operations, either successful or in error, that still belong to the current plan. For example, the completed operations related to started occurrences are processed to be saved in the DB2 tables.
If you specify NO, the archiving routines save only the operations belonging to the occurrences that are no longer in the current plan. All the other entries are ignored.
Note: When the archiving routines process a job, they do not process it again at the next archiving run. This means that if you set EXTENDEDARC(NO), the occurrences that were not stored during the current run will not be stored during the next run, even if you change the setting to EXTENDEARC(YES). - LONGDURPOLICY (nnn|150)
- The policy used to decide if a job is a long duration job, based on the formula:
AD >= (ED * LDP / 100)
where:- AD
- Actual duration.
- ED
- Estimated duration.
- LDP
- Long duration policy.
- SMOOTHPOLICY (percentage)
-
The policy used to calculate the average duration of a job. It sets the weighting factor that favors the most recent job run, when calculating the average duration for a job. This is expressed as a percentage. For example, a value of 40 applies a weighting factor of 40% to the most recent job run, and 60% to the existing average.
If you do not set this parameter, the smoothing is not used and the average duration is calculated as the total elapsed time divided by the number of successful runs. - SUBSYSTEM (subsystem name)
-
Name that indicates the subsystem from which data is collected. You can specify up to 8 characters; the default value is
SUBS
. - TBLPREFIX (DB2 table prefix)
-
Prefix to be used for the DB2 tables. You can specify up to 128 characters; the default value is
MDL
. - TIMEZONE (timezone_string)
-
Local time zone of the z/OS® system where the controller runs, for example
TIMEZONE('Europe/Rome')
. It is the format used in standardzoneinfo
files at distributed side. Do not specify the time zone in a three-letter format, because this results in an incorrect time zone from Java™ APIs during daylight saving time.This parameter is required and does not have a default value.
- TRACELEVEL (level|0)
- Trace level for internal logging and traces. Possible values are:
- 0
- To receive error messages only.
- 1
- To receive error and warning messages.
- 2
- To receive error, warning, and informational messages.
- 3
- Indicates the fine level, to receive the most important messages with the lowest volume.
- 4
- Indicates the finer level, to activate entry and exit traces.
- 5
- Indicates the finest level, to receive the most detailed tracing output.
The default value is 0.
- WRKDIR (working directory)
- The complete path of the working directory for the archiving process. Each
subsystem must have its own working directory. This
parameter is required and does not have a default value.
Run EQQPCS08 to customize the content of the working directory.
This parameter is required and does not have a default value.