Developer Documentation
ADC CLI Commands
Current Release 13.1 13.0 12.1

db-dbProfile

May 28, 2024
Contributed by: 
C

The following operations can be performed on “db-dbProfile”:

show unset rm set add

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]

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]

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

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

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

db-dbProfile
May 28, 2024
Contributed by: 
C
May 28, 2024
Contributed by: 
C

In this article

Site feedback | Your privacy choices footer linkYour Privacy Choices | Privacy and legal terms | Cookie preferences | Consent settings | docs.cloud.com
© 1999- Cloud Software Group, Inc. All rights reserved.