HP Serveur lame HP ProLiant BL465c Gen8 User Manual

Page 144

Advertising
background image

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

).

You can use the

SQL_LOGIN_TIMEOUT

parameter to specify the SQL Server login timeout option

in

sqlinit_

instance-name

.conf

.

A login request timeout is likely to occur in environments with high network loads, which may
result from a large-scale database.

Specifying the SQL Server automatic recovery time
Specify the recovery time if the command terminates with an error because the automatic recovery
processing at SQL Server startup is incomplete during restoration of the SQL Server database
(when the error message

KAVX1008-E

with the detailed message

DRM-11011

and code

5180

or

904

is output).

You can use the

SQL_AUTORECOVERY_TIME

parameter to specify the SQL Server automatic re-

covery time in

sqlinit_

instance-name

.conf

.

The following table lists whether the parameter can be specified for each combination of restoration-
target databases.

Table 38 Relationship between SQL_AUTORECOVERY_TIME parameter and restored objects

Parameter specifica-
tion

SQL Server
automatic re-
covery pro-
cessing

Restoration
type

System config-
uration

Restored object

U

S

Needed

#

Performed

Restoration
while cluster
resources are
offline

Cluster

--

Yes

Needed

#

Performed

--

Non-cluster

Needed

#

Performed

Restoration
while the
cluster re-
sources are
offline

Cluster

Yes (all)

Yes

Needed

#

Performed

--

Non-cluster

Needed

#

Performed

Restoration
while the
cluster re-
sources are
offline

Cluster

Yes (partial)

Yes

Needed

#

Performed

--

Non-cluster

Preparation for using Application Agent

144

Advertising