HP XP P9000 Replication Manager Software 7.6.0-00 Application Agent CLI User Guide

2. Specify the parameter in the sqlinit_instance-name.conf file.
Write the parameter starting from the far left, without spaces. Delimit the parameter name and
timeout value by an equal sign (=), and do not enter space or tab characters before or after the
equal sign. Lines beginning with # are assumed to be comment lines. If a parameter is specified
two or more times, the earliest value written is effective.
• To specify the SQL Server login timeout option
Add the SQL_LOGIN_TIMEOUT=login-timeout-value.
• To specify the SQL Server automatic recovery time
Add the SQL_AUTORECOVERY_TIME=SQL-Server-automatic-recovery-time.
The following tables show details of each parameter:
Table 39 Parameter defined in the sqlinit_instance-name.conf file (specification of SQL Server
login timeout option)
DefaultDescriptionParameter
None
In this parameter, specify the same number of
seconds as the waiting period for completion of a
SQL_LOGIN_TIMEOUT
request to log in to an SQL Server. If this parameter
is specified, a login to SQL Server uses the value is
specified in the SQL_ATTR_LOGIN_TIMEOUT
attribute of the ODBC function
SQLSetConnectAttr. If the parameter is not
specified, the SQL_ATTR_LOGIN_TIMEOUT attribute
is not specified.
The value specified for SQL_LOGIN_TIMEOUT must
be smaller than the VDI generation timeout period
specified for the drmsqlinit command. If you
specify a value greater than the VDI generation
timeout period, the drmsqlbackup command may
encounter a VDI generation timeout when waiting
for the processing of the request for login to SQL
Server and may terminate with an error.
Table 40 Parameter defined in the sqlinit_instance-name.conf file (specification of SQL Server
automatic recovery time)
DefaultDescriptionParameter
0
In this parameter, specify the SQL Server
automatic recovery time (in seconds) for the
restoration command.
SQL_AUTORECOVERY_TIME
If this parameter is set to a value other than 0,
the system waits for completion of SQL Server
automatic recovery processing for the specified
period of time.
When you determine a value for
SQL_ATTR_LOGIN_TIMEOUT, add enough
time so that the value becomes about twice as
much as the time from the beginning to the end
of automatic recovery of the system databases
(master, model, msdb, and tempdb).
Preparation for using Application Agent146