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)