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)