Product Documentation

Configuring a Database Profile

Sep 03, 2014

A database profile is a named collection of parameters that is configured once but applied to multiple virtual servers that require those particular parameter settings. After creating a database profile, you bind it to load balancing or content switching virtual servers. You can create as many profiles as you need.

To create a database profile by using the command line interface

At the command line, type the following commands to create a database profile and verify the configuration:

  • add db dbProfile <name> [-interpretQuery ( YES | NO )] [-stickiness (YES | NO )] [-kcdAccount <string>]
  • show db dbProfile

Example

> add dbProfile myDBProfile -interpretQuery YES -stickiness YES -kcdAccount mykcdaccnt 
 Done 
> show dbProfile myDBProfile 
	Name: myDBProfile 
	Interpret Query: YES 
	Stickyness: YES 
	KCD Account: mykcdaccnt 
	Reference count: 0 
 
 Done 
> 

To create a database profile by using the configuration utility

Navigate to System > Profiles and, on the Database Profiles tab, configure a database profile.

To bind a database profile to a load balancing or content switching virtual server by using the command line interface

At the command line, type:

set (lb | cs) vserver <name> -dbProfileName <string>

To bind a database profile to a load balancing or content switching virtual server by using the configuration utility

  1. Navigate to Traffic Management > Load Balancing > Virtual Servers or Traffic Management > Content Switching > Virtual Servers, and open a virtual server.
  2. In Advanced Settings, select Profiles and, in the DB Profile list, select a profile to bind to the virtual server. To create a new profile, click plus (+).