db-dbProfile
The following operations can be performed on "db-dbProfile":
show db dbProfile
Display all the configured DB profiles in the system. If a name is specified, then only that profile is shown.
Arguments
name Name of the DB profile.
Output
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
unset db dbProfile
Unset DB profile values.Refer to the set db dbProfile command for meanings of the arguments.
add db dbProfile
Add a new DB profile on the Citrix ADC
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
set db dbProfile
Set/modify DB profile values
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
rm db dbProfile
Remove a DB profile on the Citrix ADC
Synopsis
rm db dbProfile <name>
Arguments
name Name of the DB profile
Example
rm dbprofile <profile name>