HP Serveur lame HP ProLiant BL465c Gen8 - Manual (Page 146)

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)
Default Description Parameter
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)
Default Description Parameter
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 Agent 146