HP XP Command View Advanced Edition Software - Manual (Page 144)

NOTE:
•
If your system is in a cluster configuration. or if you use Continuous Access Software or Continuous
Access Journal functionality, you need to execute the
drmsqlinit command on each server.
• Execute the drmsqlinit command after setting up the SQL Server instance. If you change SQL
Server configuration information, such as the metafile storage directory or undo file storage dir-
ectory, re-execute the
drmsqlinit command. If you do not, the drmsqlbackup command
will end with an error.
• In the following cases, VDI metafiles must be stored in the same location as SQL Server database
data files. Therefore, do not specify a VDI metafile storage directory.
- When your system is in a cascade configuration
- When Continuous Access Software or Continuous Access Journal functionality is used to back
up an SQL Server database between a local site and a remote site
- When an SQL Server database is restored to a different SQL instance from that used at backup
• The value for the VDI generation timeout period specified by using the drmsqlinit command
should be the duration necessary for the backup or restore process of the SQL Server database.
If you specify an unsuitable timeout value and backup takes a long time, one of the following
problems might occur. Specify a suitable value that allows enough time for both operation and
backup.
• If the timeout value is too low
The command ends with an error due to a timeout and the database cannot be backed up.
• If the timeout value is too high
The client application connected to the SQL Server reaches a timeout before the command
ends with an error due to a timeout.
You can check the estimated VDI generation timeout value by performing the following steps to
measure the VDI freeze time.
1. Use the drmsqlinit command to set the number of seconds for the VDI generation timeout
to a large value (such as 1000).
2. Execute the drmsqlbackup command.
3. Check the interval between the following two log messages by viewing the Application Agent
log file
drm_output.log .
KAVX1371-I Processing to freeze databases will now start.
KAVX1372-I Processing to thaw databases will now end.
4. Re-execute the drmsqlinit command to set up the VDI generation timeout value, based
on the time obtained in step 3 above. Because the execution time of the drmsqlbackup
command is affected by the status of system resources, set a timeout value larger than the
time obtained in step 3.
Specifying settings related to linkage with an SQL Server
This section describes the following two types of settings:
• Specifying the SQL Server login timeout option
Specify this option if the command that operates the SQL Server database terminates with an error
due to an SQL Server login request timeout (error message:
KAVX1008-E , detailed message DRM-
11013 , Code: 0 ).
Preparation for using Application Agent 144