Skip to content

db-dbProfile

The following operations can be performed on "db-dbProfile":

show| set| unset| add| rm|

show db dbProfile

Display all the configured DB profiles in the system. If a name is specified, then only that profile is shown.

Synopsis

show db dbProfile []

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

Example

show dbprofile [profile name]

set db dbProfile

Set/modify DB profile values

Synopsis

set db dbProfile [-interpretQuery ( YES | NO )] [-stickiness ( YES | NO )] [-kcdAccount ] [-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 -interpretQuery YES -stickyness YES

unset db dbProfile

Unset DB profile values.Refer to the set db dbProfile command for meanings of the arguments.

Synopsis

unset db dbProfile [-interpretQuery] [-stickiness] [-kcdAccount] [-conMultiplex] [-enableCachingConMuxOFF]

add db dbProfile

Add a new DB profile on the Citrix ADC

Synopsis

add db dbProfile [-interpretQuery ( YES | NO )] [-stickiness ( YES | NO )] [-kcdAccount ] [-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 -interpretQuery YES -stickyness YES -kcdaccount account

rm db dbProfile

Remove a DB profile on the Citrix ADC

Synopsis

rm db dbProfile

Arguments

name Name of the DB profile

Example

rm dbprofile

Was this article helpful?