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


1  DBOPT?  CLEANUPPOLICY (
2.1! 10
2.1 days
1 )?  CODEPAGE (
2.1! IBM – 037
2.1 host system codepage
1 )  DBPSW (  password )  DBURL (  url )  DBUSER (  userid )?  EXTENDEDARC (
2.1! NO
2.1 YES
1?  LONGDURPOLICY (
2.1! 150
2.1 nnn
1 )
1 )?  SMOOTHPOLICY (  percentage )?  SUBSYSTEM (?  subsystem name )?  TBLPREFIX (?  DB2 table prefix )  TIMEZONE (  timezone_string )?  TRACELEVEL (
2.1! 0
2.1 level
1 )  WRKDIR (  working directory )

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
The following list shows the EBCDIC code pages for EURO support:
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:
jdbc:db2://server:port/database
Ensure that 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.
This parameter is required and does not have a default value.
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.
Specify a value in the range 100 to 999. The default value is 150.
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 standard zoneinfo 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.

Run EQQPCS08 to customize the content of the working directory.

This parameter is required and does not have a default value.