Use the following sample file to create a use trend database environment definition file and store it in the file show below:
[Windows]
When you set the environment according to "3.1 System Configuration", refer to this table.
File | Path |
|---|---|
Sample file | <Installation directory>\sample\DatabaseConfig |
Storage destination of use trend database environment definition file | <Variable file storage directory>\control\DatabaseConfig |
[UNIX]
File | Path |
|---|---|
Sample file | /opt/FJSVssqc/sample/DatabaseConfig |
Storage destination of use trend database environment definition file | /etc/opt/FJSVssqc/DatabaseConfig |
An example of the use trend database environment definition file is shown below.
Example
A sample definition 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 = db [Log] Symbol = HostA1 Name = HostA1 Path = "C:\SystemwalkerSQC\database\csv\HostA1\*.csv" Format = SQC-CSV Region = +0000 [Server] Symbol = HostA2 Name = HostA2 Type = web Domain = xxx.yyy.com DatabaseInterval = week(sun) SearchDNS = yes RequestURLSuffix = "html,htm,shtml,shtm,stm,cgi,asp,pl,tcl,sh" DatabaseMode = db [Log] Symbol = HostA2 Name = HostA2 Path = "C:\SystemwalkerSQC\database\csv\HostA2\*.csv" Format = SQC-CSV Region = +0000 |
Note
Note the following settings:
Name | For "Name" under [Server], specify the name of the server to be analyzed defined in the Managed Server setting window for environment settings. |
Path | <Variable file storage directory>\database\csv\<server>\db*.csv |
Format | Accord the format to the log format specified by CustomLog of Httpd.conf. When you operate the Management Server, specify "SQC-CSV" |
Region | Here, specify the region of time by the time difference from GMT (Greenwich Mean Time). When you operate the Management Server: Specify "+0000" as the Region definition of the Management Server side. Specify "+0900" as the Region definition of the Managed Server side. Note However, in case of IIS, specify "+0000" as the Region definition of the Managed Server side. |
See
For detail of the setting of a use trend database environment definition file, refer to "15.2.1.5 File internal format (log definition block to be analyzed)".
Point
After the above settings are finished, check whether the settings are correct according to the following procedure:
Note
In order to check the settings, the system configuration must be registered. For details on registering system configuration, refer to "5.3 Registering System Configuration".
[Windows]
Check that the use trend database registration engine starts normally.
Enter the command
Enter the following command:
<Installation directory>\bin\dbregmng.exe |
Check the log file
Check the output messages in the following log file:
<Variable file storage directory>\log\dbreg.log |
If the following messages are output as the result of the command, the use trend database was created normally.
dd/mmm/yyyy:hh:mm:ss +0900 dbreg[22262] DBReg_Main:1098 103001001i "[server=HostA1][log=HostA1]The database registration engine started." dd/mmm/yyyy:hh:mm:ss +0900 dbreg[22262] DBReg_Main:1853 103001002i "[server=HostA1][log=HostA1] The database registration engine ended." |
Check that no error messages are output between the above 2 messages.
See
If the use trend database was not normally created, check the settings while referring to "Chapter 4 Environment Settings for the Managed Server".
[UNIX]
When the Managed Server is Solaris, check whether the setting is proper or not according to the following procedure.
Enter the command
/opt/FJSVssqc/bin/dbregmng |
Check the log
Check the following log file output message.
/var/opt/FJSVssqc/log/dbreg.log |
If the following messages are output as the result of the command, the use trend database was created normally.
dd/mmm/yyyy:hh:mm:ss +0900 dbreg[22262] DBReg_Main:1098 103001001i "[server=HostA1][log=HostA1]The database registration engine started." dd/mmm/yyyy:hh:mm:ss +0900 dbreg[22262] DBReg_Main:1853 103001002i "[server=HostA1][log=HostA1]The database registration engine ended." |
Check from the following points of view:
Above messages were outputted in pairs.
No error message was output between the first message and the second message.
See
If the use trend database was not normally created, check the settings while referring to "Chapter 4 Environment Settings for the Managed Server".
