Top
Systemwalker Service Quality Coordinator User's Guide (WebsiteManagement Functions Edition)
Systemwalker

4.2.2 Defining the usage DB environment definition file

Use the following sample files to create and store usage DB environment definition files.

[UNIX]

When you set the environment in "3.1 System Configuration", refer to the following table.

File

Path

Sample file

/opt/FJSVssqc/sample/DatabaseConfig

Storage destination of usage DB environment definition file

/etc/opt/FJSVssqc/DatabaseConfig


[Windows]

When the managed server is Window, refer to the following table.

File

Path

Sample file

<Installation directory>\DatabaseConfig

Storage destination of usage DB environment definition file

<Variable file storage directory>\\control\DatabaseConfig

The following gives a definition example of the usage DB environment definition file.


Example:

The definition example is shown below.

[Server]

Symbol = HostA1

Name = HostA1

Type = web

Domain = xxx.yyy.com

DatabaseInterval = week(sun)

SearchDNS = yes

RequestURLSuffix = "html,htm,shtml,shtm,stm,cgi,asp,pl,tcl,sh"

DatabaseMode = both

[Log]

Symbol = HostA1

Name = HostA1

Path = /usr/local/apache/logs/access_log

Format = Common

Region = +0900

Note

Note the following settings.

Setting item

Remarks

Name

Use Name under [Server] to specify the name of the analysis target server that is defined in the environment setting window for the managed server.

Format

Accord to the log format of the Web server. When the Web server is Apache HTTP Server, accord to the log format specified in httpd.conf CustomLog.

Domain

Defines the domain name of the analysis target server.

For details, refer to "15.2.1.4 File internal format (analysis target server definition block)".


See

See "15.2.1 Usage DB Environment Definition File" in the online manual for details on setting the usage DB definition file.

Point

After the settings above have been made, check that the usage DB registration engine starts.


[UNIX]

Use the following procedure to check whether the settings have been made correctly:

  1. Execute the command.

    /opt/FJSVssqc/bin/dbregmng

  2. Check the log.
    Check the output message of the following log file.

    /var/opt/FJSVssqc/log/dbreg.log


    If the following message is displayed after the command is executed, the usage DB has been created correctly.

    dd/mmm/yyyy:hh:mm:ss +0900 dbreg[22262] DBReg_Main:1098 103001001i "[server=HostA1][log=HostA1]Database register engine started"

    dd/mmm/yyyy:hh:mm:ss +0900 dbreg[22262] DBReg_Main:1853 103001002i "[server=HostA1][log=HostA1]Database register engine stopped."


    Check that:

    • A pair of messages shown above is displayed.

    • No error message is displayed between the first and second messages.

    See

    If the usage DB is not correctly created, see this section and "11.1.1.2 Start operation" to review the settings.


[Windows]

In case of Windows, check as follows:

  1. Execute the command.

    1. <Installation directory>\bin\dbregmng.exe


  2. Check the log.
    Check the output message of the following log file.

    1. <Variable file storage directory>\log\dbreg.log


    If the following message is displayed after the command is executed, the usage DB has been created correctly.

    dd/mmm/yyyy:hh:mm:ss +0900 dbreg[22262] DBReg_Main:1098 103001001i "[server=HostA1][log=HostA1]Database register engine started"

    dd/mmm/yyyy:hh:mm:ss +0900 dbreg[22262] DBReg_Main:1853 103001002i "[server=HostA1][log=HostA1]Database registration engine stopped."


    Check that:

    • A pair of messages shown above is displayed.

    • No error message is displayed between the first and second messages.

    See

    If the usage DB is not correctly created, see this section and "11.1.1.2 Start operation", to review the settings.