About the Db2udb resource types and attribute definitions
Prev Appendix C. Resource type attributes for DB2 Next

About the Db2udb resource types and attribute definitions

Review the description of the DB2 agent attributes. The agent attributes are classified as required, optional, and internal.

Table: Required attributes for the agent for DB2 shows the required attributes for the agent for DB2, you must assign values to required attributes.

Table: Required attributes for the agent for DB2

Required attributes

Description

DB2InstHome

Path to DB2 UDB instance home directory that contains critical data and configuration files for the DB2 instance.

Type and dimension: string-scalar

DB2InstOwner

User ID of Instance Owner that starts a DB2 UDB instance. Each instance requires a unique user ID.

Type and dimension: string-scalar

Note:

Incorrect changes to this attribute can result in DB2 entering an inconsistent state.

Table: Optional attributes for the agent for DB2 shows the optional attributes for the agent for DB2.

Table: Optional attributes for the agent for DB2

Optional attributes

Description

DatabaseName

Name of the database for in-depth monitoring; required if in-depth monitor is enabled (IndepthMonitor = 1).

Be careful when you change the DataBase name attribute as you can fault all the partitions in the database. Do not change the DataBaseName attribute to an invalid or an incorrect value.

Note:

Make sure the database with the provided DatabaseName has been created in the same partition for which the Db2udb agent resource has been configured.

Type and dimension: string-scalar

NodeNumber

Node number or partition number of the database. Used when monitoring a specific database partition.

Default: 0

Type and dimension: integer-scalar

StartUpOpt

Provides start up options. The allowed values are: START, ACTIVATEDB, or CUSTOM.

Review the following options:

  • START (default)

    Starts the DB2 instance or partition.

  • ACTIVATEDB

    Performs activate database command after db2 processes start.

  • CUSTOM

    The agent leaves all the online function completely to the user when the StartUpOpt attribute is set to CUSTOM. It looks for a file named start_custom_$db2instance_$nodenum in the /opt/VRTSagents/ha/bin/Db2udb directory. If this file exists and is executable, it executes this customized online file instead.

    Example:

    To customize the online function for partition/nodenum 1 for the db2 instance named db2inst1, the agent for DB2 runs this customized file start_custom_db2inst1_1. It runs this file under the /opt/VRTSagents/ha/bin/Db2udb directory.

Type and dimension: string-scalar

ShutDownOpt

The allowed values for this attribute are STOP and CUSTOM.

Review the following options:

  • STOP (Default)

    Shuts the Db2 instance or partition down in the usual way.

  • CUSTOM

    Leaves all the offline function completely to the user when the ShutDownOpt is set to CUSTOM. It looks for a file named stop_custom_$db2instance_$nodenum in the /opt/VRTSagents/ha/bin/Db2udb directory.

    If this file exists and is executable, it executes this customized offline file instead.

    Example:

    You want to customize the offline function for partition/nodenum 0 for the db2 instance named db2inst1. You have the agent for DB2 run this customized file: stop_custom_db2inst1_0. The file is in the /opt/VRTSagents/ha/bin/Db2udb directory.

Type and dimension: string-scalar

IndepthMonitor

Set the value of the IndepthMonitor attribute to 1 to enable in-depth monitoring. The agent now looks for the monitor_custom_$db2instance_$nodenum file in the /opt/VRTSagents/ha/bin/Db2udb directory.

It executes this customized indepth monitor file if the file exists and is executable. You can find samples of custom monitor scripts in the sample_db2udb directory.

Type and dimension: string-integer

Encoding

Specifies the operating system encoding corresponding to DB2 UDB encoding for display of DB2 UDB output.

Type and dimension: string-scalar

AgentDebug

When the value of this attribute is 1, it causes the agent to log additional debug messages.

Type and dimension: boolean-scalar

WarnOnlyIfDBQueryFailed

This attribute either logs SQL errors, or checks the errors to handle them specially.

Set the value of the WarnOnlyIfDBQueryFailed attribute to 1 to enable it. When this attribute is enabled, it ignores all SQL errors and logs a warning message in the agent log once a day.

Set the value of the WarnOnlyIfDBQueryFailed attribute to 0 to disable it. When disabled, it checks if an error code needs to be handled specially in the db2error.dat file. If the error code does not exist in the db2error.dat file, then it returns OFFLINE for monitor. Otherwise, it follows the action of that particular error code in the db2error.dat file.

Type and dimension: boolean-scalar

UseDB2start

Enables you to choose an alternate way to start DB manager. The agent executes the db2start when UseDBStart is set to 1, whereas it uses db2gcf when UseDBStart is set to 0. If the setup is non-MPP, you must set the value of the UseDB2start attribute to 1.

If the setup is MPP, you must set the value of the UseDB2start attribute to 0. For MPP, VCS uses the actual hostname and needs the ability to start and stop each partition. For this purpose, VCS uses the db2gcf command and requires a value of 0 for the UseDB2start attribute.

Type and dimension: boolean-scalar

Default: 0

For more information on using UseDB2start attribute refer : See About DB2 configurations in VCS.

Table: Internal attribute for the agent for DB2 shows the resource attribute for the agent for DB2.

Table: Resource attribute for the agent for DB2

Internal attributes

Description

ContainerOpts

This agent is zone-aware. The ContainerOpts resource type attribute for this type has a default value of 1 for RunInContainer and a default value of 0 for PassCInfo. Veritas recommends that you do not change these values. Refer to the Cluster Server Administrator's Guide for more information.

Table: Internal attribute for the agent for DB2 shows the internal attributes for the agent for DB2.

Table: Internal attribute for the agent for DB2

Internal attributes

Description

AgentDirectory

Specifies the location of other files and scripts that are related to the agent.

Do not use. For internal use only.

IMF

This resource-type level attribute determines whether the DB2 agent must perform intelligent resource monitoring.

This attribute includes the following keys:

  • Mode: Define this attribute to enable or disable intelligent resource monitoring.

    Valid values are as follows:

    • 0 - Does not perform intelligent resource monitoring

    • 1 - Performs intelligent resource monitoring for offline resources and performs poll-based monitoring for online resources

    • 2 - Performs intelligent resource monitoring for online resources and performs poll-based monitoring for offline resources

    • 3 - Performs intelligent resource monitoring for both online and for offline resources

    Default: 2

  • MonitorFreq: This key value specifies the frequency at which the agent invokes the monitor agent function. The value of this key is an integer.

    Default: 5

    You can set this key to a non-zero value for cases where the agent requires to perform both poll-based and intelligent resource monitoring.

    If the value is 0, the agent does not perform poll-based process check monitoring. After the resource registers with the AMF kernel driver, the agent calls the monitor agent function as follows:

    • After every (MonitorFreq x MonitorInterval) number of seconds for online resources

    • After every (MonitorFreq x OfflineMonitorInterval) number of seconds for offline resources

  • RegisterRetryLimit: If you enable intelligent resource monitoring, the agent invokes the imf_register agent function to register the resource with theAMF kernel driver. The value of the RegisterRetryLimit key determines the number of times the agent must retry registration for a resource. If the agent cannot register the resource within the limit that is specified, then intelligent monitoring is disabled until the resource state changes or the value of the Mode key changes.

    Default: 3.

See Enabling and disabling intelligent resource monitoring for Db2udb resource.
Prev Up Next
Appendix C. Resource type attributes for DB2 Home Appendix D. Sample configurations