Using the Product in a DB2 Environment › Background DB2 Catalog Extraction › Synchronous Data Gatherer › Display DB2 Server Settings

Display DB2 Server Settings

Z/OS MODIFY commands can be used to display or change most of the DB2 Harvester and data collection commands in the server.

To change a setting

Issue the following command:

F server,HARVESTER,SETFLAG,command,value

where

• server is the server name.
• command is one of the commands listed in the section Synchronous Data Gatherer.
• value is the new value.

DB2HVSUM, DB2HVSE1, DB2HVSE2, and DB2HVSE3 cannot be modified.

Example:

F MATUNER,HARVESTER,SETFLAG,DB2HVLOC,NO

The following messages will be displayed in the server JES log:

TN3443I The old setting for DB2HVLOC was YES
TN3444I The new setting for DB2HVLOC is NO
TN3431I Harvester command processed for: SETFLAG,DB2HVLOC,NO

To display a setting

Issue the following command:

F server,HARVESTER,SHOWFLAG,command

where

• server is the server name.
• command is one of the commands listed in the section Synchronous Data Gatherer.

Example:

F MATUNER,HARVESTER,SHOWFLAG,DB2HVLOC

The following messages will be displayed in the server JES log:

TN3445I The setting for DB2HVLOC is NO
TN3431I Harvester command processed for: SHOWFLAG,DB2HVLOC

To display all the DB2 Harvester and data collection commands in the server

Issue the following command:

F server,HARVESTER,SHOWFLAG,DB2

where server is the server name.

Example:

F MATUNER,HARVESTER,SHOWFLAG,DB2

The following messages will be displayed in the server JES log:

TN3445I The setting for DB2TCSID is -1
TN3445I The setting for DB2SPSQL is YES
TN3445I The setting for DB2SPDYN is NO
TN3445I The setting for DB2PLAN  is MAT85DB2
TN3445I The setting for DB2PACK  is MAT85
TN3445I The setting for DB2CTSQL is YES
TN3445I The setting for DB2EXPL  is YES
TN3445I The setting for DB2HEXPL is YES
TN3445I The setting for DB2HRVST is YES
TN3445I The setting for DB2HVLOC is NO
TN3445I The setting for DB2HVCOR is YES
TN3445I The setting for DB2HVIID is YES
TN3445I The setting for DB2HVTHD is YES
TN3445I The setting for DB2HVSQL is YES
TN3445I The setting for DB2HVDYN is NO
TN3445I The setting for DB2HVSUM is 0
TN3445I The setting for DB2HVMXA is 1000
TN3445I The setting for DB2HVMXM is 100
TN3445I The setting for DB2HVEXT is DB2E3
TN3445I The setting for DB2HVSE1 is NONE
TN3445I The setting for DB2HVSE2 is NONE
TN3445I The setting for DB2HVSE3 is DB8G,DB9G,DIA1,DIA2,DIA3,IA4,IA5
TN3431I Harvester command processed for: SHOWFLAG,DB2