db dbProfile¶
The following operations can be performed on "db dbProfile":
add db dbProfile¶
Add a new DB profile on the Netscaler
Synopsys¶
add db dbProfile <name> [-interpretQuery ( YES | NO )] [-stickiness ( YES | NO )] [-kcdAccount <string>] [-conMultiplex ( ENABLED | DISABLED )] [-enableCachingConMuxOFF ( ENABLED | DISABLED )]
Arguments¶
name
Name for the database profile. Must begin with an ASCII alphanumeric or underscore (_) character, and must contain only ASCII alphanumeric, underscore, hash (#), period (.), space, colon (:), at sign (@), equal sign (=), and hyphen (-) characters. Cannot be changed after the profile is created.
CLI Users: If the name includes one or more spaces, enclose the name in double or single quotation marks (for example, "my profile" or 'my profile').
interpretQuery
If ENABLED, inspect the query and update the connection information, if required. If DISABLED, forward the query to the server.
Possible values: YES, NO
Default value: YES
stickiness
If the queries are related to each other, forward to the same backend server.
Possible values: YES, NO
Default value: NO
kcdAccount
Name of the KCD account that is used for Windows authentication.
conMultiplex
Use the same server-side connection for multiple client-side requests. Default is enabled.
Possible values: ENABLED, DISABLED
Default value: ENABLED
enableCachingConMuxOFF
Enable caching when connection multiplexing is OFF.
Possible values: ENABLED, DISABLED
Default value: DISABLED
Example¶
add dbprofile <profile name> -interpretQuery YES -stickyness YES -kcdaccount account
rm db dbProfile¶
Remove a DB profile on the Netscaler
Synopsys¶
rm db dbProfile <name>
Arguments¶
name
Name of the DB profile
Example¶
rm dbprofile <profile name>
set db dbProfile¶
Set/modify DB profile values
Synopsys¶
set db dbProfile <name> [-interpretQuery ( YES | NO )] [-stickiness ( YES | NO )] [-kcdAccount <string>] [-conMultiplex ( ENABLED | DISABLED )] [-enableCachingConMuxOFF ( ENABLED | DISABLED )]
Arguments¶
name
Name for the database profile. Must begin with an ASCII alphanumeric or underscore (_) character, and must contain only ASCII alphanumeric, underscore, hash (#), period (.), space, colon (:), at sign (@), equal sign (=), and hyphen (-) characters. Cannot be changed after the profile is created.
CLI Users: If the name includes one or more spaces, enclose the name in double or single quotation marks (for example, "my profile" or 'my profile').
interpretQuery
If ENABLED, inspect the query and update the connection information, if required. If DISABLED, forward the query to the server.
Possible values: YES, NO
Default value: YES
stickiness
If the queries are related to each other, forward to the same backend server.
Possible values: YES, NO
Default value: NO
kcdAccount
Name of the KCD account that is used for Windows authentication.
conMultiplex
Use the same server-side connection for multiple client-side requests. Default is enabled.
Possible values: ENABLED, DISABLED
Default value: ENABLED
enableCachingConMuxOFF
Enable caching when connection multiplexing is OFF.
Possible values: ENABLED, DISABLED
Default value: DISABLED
Example¶
set dbprofile <profile name> -interpretQuery YES -stickyness YES
unset db dbProfile¶
Unset DB profile values.Refer to the set db dbProfile command for meanings of the arguments.
Synopsys¶
unset db dbProfile <name> [-interpretQuery] [-stickiness] [-kcdAccount] [-conMultiplex] [-enableCachingConMuxOFF]
show db dbProfile¶
Display all the configured DB profiles in the system. If a name is specified, then only that profile is shown.
Synopsys¶
show db dbProfile [<name>]
Arguments¶
name
Name of the DB profile.
Outputs¶
interpretQuery
Interpret Queries on NS
stickiness
Stickyness for Queries
kcdAccount
KCD account for windows authentication
conMultiplex
Enable/Disable Connection Multiplexing
refCnt
Profile Reference Count
enableCachingConMuxOFF
Enable Caching When Connection Multiplexing is OFF
stateflag
State flag
devno
count
Example¶
show dbprofile [profile name]