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.

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. 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.