1.2.2 Definition method

If this linkage function is used, the following items are collected by default:

RDBSAR_EB
RDBSAR_ED
RDBSAR_EM
RDBSAR_AGE
RDBSAR_EL
RDBPS_S
RDBPS_R

By implementing this definition procedure, the following items can be collected.

RDBSAR_ER
RDBSAR_EC
RDBPS_IA
RDBINF_AI
RDBINF_AP
RDBSPCINF_PD

Point

If the items that are collected by default meet the requirements for the operation, there is no need to implement the procedure in this section.

Procedure 1

Modify the "template.dat" file.

Definition location

[Windows]

<Variable file storage directory>\control\template.dat

[UNIX]

/etc/opt/FJSVssqc/template.dat

Modifications

Collecting RDBSAR_ER/RDBSAR_EC

In the SYMSAR section, perform the following tasks:

Set the "DSIBUF" option to "ON" to enable collection for RDBSAR_ER.
Set the "RDBCOM" option to "ON" to enable collection for RDBSAR_EC.

Extract from the SYMSAR section

#########################################

## Symfoware RDBSAR DCA_CMD

[SYMSAR]

DCAID="SYMFOSAR"

INTERVAL=5

AUTOFLAG="ON"

BUFPOOL="ON"

DBSPIO="ON"

TMPLOG="ON"

ARCLOG="ON"

MEMORY="ON"

DSIBUF="OFF" *Set this option to "ON" to enable collection for RDBSAR_ER.

RDBCOM="OFF" *Set this option to "ON" to enable collection for RDBSAR_EC.

Note

RDBSAR_EC cannot be collected if the load share mechanism has not been enabled on the Symfoware side.
Take care when enabling RDBSAR_ER collection, as this may place load on Symfoware depending on the environment or too much data may be collected. This may prevent data collection from completing within the collection interval, and data collection may not run correctly.

Collecting RDBPS_IA

In the SYMSAR section, perform the following task:

Set the "DSISTATUS" option to "ON" to enable collection for RDBPS_IA.

Extract from the SYMPS section

#########################################

## Symfoware RDBPS DCA_CMD

[SYMPS]

DCAID="SYMFOPS"

INTERVAL=5

AUTOFLAG="ON"

SQLSTATUS="ON"

PRGSTATUS="ON"

DSISTATUS="OFF" *Set this option to "ON" to enable collection for RDBPS_IA.

Note

Take care when enabling RDBPS_IA collection, as this may place load on Symfoware depending on the environment or too much data may be collected. This may prevent data collection from completing within the collection interval, and data collection may not run correctly.

Collecting RDBINF_AI/RDBINF_AP

In the SYMINF section, perform the following tasks:

Set the "SPCINFO" option to "ON" to enable collection for RDBINF_AP.
Set the "DSIINFO" option "ON" to enable collection for RDBINF_AI.

Extract from the SYMINF section

#########################################

## Symfoware RDBINF DCA_CMD

[SYMINF]

DCAID="SYMFOINF"

AUTOFLAG="ON"

INTERVAL=5

SPCINFO="ON" *Set this option to "ON" to collect RDBINF_AP.

DSIINFO="ON" *Set this option to "ON" to collect RDBINF_AI.

Modify the ATTR::DB section.

Add the "SYMSPCINF" keyword to the GROUP parameter.

Extract from the ATTR::DB section.

[ATTR::DB]

GROUP="SYMSAR,SYMPS,ORA"

GROUP="SYMSAR,SYMPS,ORA,SYMINF"

Note

To enable collection for RDBINF_AI/RDBINF_AP, the DSI names and database space names must also be specified in "Middlewareconf.xml" as monitored objects.
If there are a large number of monitored objects, this may place load on Symfoware depending on the environment, or too much data may be collected. This may prevent data collection from completing within the collection interval, and data collection may not run correctly. As far as possible, try to limit the number of objects to be monitored.

Collecting RDBSPCINF_PD

In the SYMSPCINF section, perform the following tasks:

Set the "SPCALL" option to "OFF" and the "SPCSEP" option to "ON" in order to enable collection for RDBSPCINF_PD.

Extract from the SYMSPCINF section

#########################################

## Symfoware RDBSPCINF DCA_CMD

[SYMSPCINF]

DCAID="SYMFOSPCINF"

INTERVAL=5

AUTOFLAG="ON"

SPCALL="ON" *Set this option to OFF.

SPCSEP="OFF" *Set this option to ON.

Modify the ATTR::DB section.

Add the "SYMSPCINF" keyword to the GROUP parameter.

Extract from the ATTR::DB section

[ATTR::DB]

GROUP="SYMSAR,SYMPS,ORA"

GROUP="SYMSAR,SYMPS,ORA,SYMSPCINF"

Note

To enable collection for RDBSPCINF_PD, the database space names must also be specified in "Middlewareconf.xml" as monitored objects.

Take care when enabling RDBSPCINF_PD collection, as this may place load on Symfoware depending on the environment or too much data may be collected. This may prevent data collection from completing within the collection interval, and data collection may not run correctly.

Procedure 2

Modify "MiddlewareConf.xml".

Definition location

[Windows]

<Variable file storage directory>\control\MiddlewareConf.xml

[UNIX]

/etc/opt/FJSVssqc/MiddlewareConf.xml

Note

This file is created by executing the policy creation command.

Make sure that the Symfoware database to be monitored is detected when the policy creation command is executed, and then modify the "MiddlewareConf.xml" file.

Modifications

To collect RDBINF_AP/RDBINF_AI/RDBSPCINF_PD information, first make sure that there is a message indicating that Symfoware has been detected when the policy creation command is executed, and then specify the names of the databases, database spaces and DSIs to be monitored in this file.

Before modification

If Symfoware is detected when the policy creation command is executed, tags up to the <RDB_System> tag will be generated automatically in the file, as shown below.

<RDB_System DisplayName="GYOMU" InstanceName="GYOMU" NodeType="I">

*Enter settings in here

</RDB_System>

</Symfoware>

* Make settings for the names of the databases, database spaces and DSIs to be monitored at the location indicated by the star (*).

Modification method

Enter information for the database for which information is to be collected inside the <RDB_System> tag (the line with the star symbol).

Syntax

<DB tag> #Required

<DB_Space tag> # Required

<DSI tag /> # Required if RDBINF_AI information is collected

</DB_Space tag>

</DB tag>

Modification example

<RDB_System DisplayName="GYOMU" InstanceName="GYOMU" NodeType="I">

* <DB DisplayName="DB_A" InstanceName="DB_A" NodeType="I">

* <DB_Space DisplayName="DSPACE" InstanceName="DSPACE" NodeType="I">

* <DSI DisplayName="DSI1" InstanceName="DSI1" NodeType="I-D"/>

* <DSI DisplayName="DSI2" InstanceName="DSI2" NodeType="I-D"/>

* :

* </DB_Space>

* </DB>

</RDB_System>

</Symfoware>

Note:

Enter the name of the database for the DisplayName and InstanceName attributes of the <DB> tag. Be sure to enter "1" for the "NodeType" attribute.

Enter the name of the database space for the DisplayName and InstanceName attributes of the <DB_Space> tag. Be sure to enter "1" for the "NodeType" attribute.

Enter the DSI names for the DisplayName and InstanceName attributes of the <DSI> tags. Be sure to enter "I-D" for the "NodeType" attribute.