Product Documentation

db dbProfile

Sep 12, 2016

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

add | rm | set | unset | show

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]