ltm profile mssql
ltm profile mssql(1) BIG-IP TMSH Manual ltm profile mssql(1)
NAME
mssql - Configures a profile to manage mssql(tds) database traffic.
MODULE
ltm profile
SYNTAX
Configure the mssql component within the ltm profile module using the syntax in the following sections.
CREATE/MODIFY
create mssql [name]
modify mssql [name]
options:
app-service [[string] | none]
defaults-from [name]
description [[string] | none]
read-pool [string]
read-write-split-by-user [disabled | enabled]
read-write-split-by-command [disabled | enabled]
user-can-write-by-default [true | false]
user-list [add | delete | none | replace-all-with] {
[user names...]
}
write-persist-timer [number]
write-pool [string]
edit mssql [ [ [name] | [glob] | [regex] ] ... ]
options:
all-properties
non-default-properties
reset-stats mssql
reset-stats mssql [ [ [name] | [glob] | [regex] ] ... ]
DISPLAY
list mssql
list mssql [ [ [name] | [glob] | [regex] ] ... ]
show running-config mssql
show running-config mssql [ [ [name] | [glob] | [regex] ] ... ]
options:
all-properties
non-default-properties
one-line
partition
show mssql
show mssql [ [ [name] | [glob] | [regex] ] ... ]
options:
(default | exa | gig | kil | meg | peta | raw | tera | yotta | zetta)
field-fmt
global
DELETE
delete mssql [name]
DESCRIPTION
You can use the mssql component to configure a profile to manage mssql(tds) database traffic.
EXAMPLES
create mssql my_mssql_profile defaults-from mssql
Creates a mssql profile named my_mssql_profile that inherits its settings from the system default mssql
profile.
list mssql
Displays the properties of all mssql profiles.
OPTIONS
app-service
Specifies the name of the application service to which the profile belongs. The default value is none.
Note: If the strict-updates option is enabled on the application service that owns the object, you cannot
modify or delete the profile. Only the application service can modify or delete the profile.
defaults-from
Specifies the profile that you want to use as the parent profile. Your new profile inherits all settings
and values from the parent profile specified. The default value is mssql.
partition
Displays the administrative partition within which the profile resides.
read-pool
Specifies the pool of MS SQL database servers to which the system sends ready-only requests.
read-write-split-by-command
When enabled, the system decides which pool to send the client requests the by the content in the
message. It can only be enabled when read-write-split-by-user is disabled.
read-write-split-by-user
When enabled, the system decides which pool to send the client requests the by user name. It can only be
enabled when read-write-split-by-command is disabled.
user-can-write-by-default
Specifies whether users have write access by default. When set to true, all users have write access,
except those added to the users list.
user-list
Specifies the users who have read-only access to the MS SQL if user-can-write-by-default is true, or the
users who have write access to the MS SQL database if user-can-write-by-default is false.
write_persist_timer
Specify how many minimum time in milliseconds the connection will be persisted to write-pool after
connection switch to write pool.
write-pool
Specifies the pool of MS SQL database servers to which the system sends requests that are not read-only.
SEE ALSO
create, delete, edit, glob, list, ltm virtual, modify, regex, reset-stats, show, tmsh
COPYRIGHT
No part of this program may be reproduced or transmitted in any form or by any means, electronic or
mechanical, including photocopying, recording, or information storage and retrieval systems, for any purpose
other than the purchaser's personal use, without the express written permission of F5 Networks, Inc.
F5 Networks and BIG-IP (c) Copyright 2009-2013. All rights reserved.
BIG-IP 2014-09-25 ltm profile mssql(1)