HP DL380-SL Betriebsanweisung PDF herunterladen (Seite 133)

Chapter 3: mx Commands 122

mx vsqlinstance – Virtual SQL Instance commands

Use the following mx vsqlinstance commands to manage Virtual SQL

Instances.

add—Add a Virtual SQL Instance

mx vsqlinstance add --vpath <path> --port <TCP_port> [arguments]

<vsql\instancename>

The arguments are:

--vpath <path>

The full path that will be used for the data files and directories for this virtual

SQL Server instance. This location will store the SQL Data Root that was

created when the SQL Server instance was installed.

--port <TCP_port>

The port number for TCP/IP sockets that the SQL Server instance should

listen on. Specifying a port is required.

[--timeout <seconds>]

The maximum amount of time that will be waited for the probe to complete.

The default is five seconds.

[--frequency <seconds>]

The interval of time, in seconds, at which the monitor runs the probe. The

default is 10 seconds.

[--restarts <number of restarts>]

The number of attempts that should be made to restart the SQL service

instead of immediately failing over the Virtual SQL Server. If you do not

Command Description

add Add a Virtual SQL Instance

clear Clear a monitor event

delete Delete a Virtual SQL Instance

disable Disable a Virtual SQL Instance

dump Dump the Virtual SQL Instance configuration

enable Enable a Virtual SQL Instance

status Show status for a Virtual SQL Instance

update Modify an existing Virtual SQL Instance

1 2 ... 128 129 130 131 132 133 134 135 136 137 138 139 140 141

Keine Kommentare

HP DL380-SL Betriebsanweisung Seite 133