2 Database administration

UDR (built-in database, user data repository) is used for permanent storage of data on services and policing settings for the subscribers.

List of database tables

Table	Purpose
bindings	login and address binding
bindings_multi	login and address binding for multu-subscribers (with several IPs)
policing	Subscriber policing setting
profile_names	Names of profiles
profiles	Profiles of services and policing
services	Subscriber services setting
vchannel_policing	Channel policing setting
ip_props	BRAS subscriber properties

Activating the built-in database

UDR activation is required to support dynamic IPs and subscribers with several IPs.

UDR is activated by the configuration parameter in /etc/dpi/fastdpi.conf file.

udr=1

The created database is located in the /var/db/dpi directory

You can make a copy of the database without stopping the DPI with a backup command mdb_copy/var/db/dpi./DB and handle further manipulations in the copied database.

Enlarging the DB

By default, the database size is limited to 1GB. If you have more than 1 million policing profiles, you will need to increase the default size:

udr_size=2147483648

will set the DB size of 2GB.

The built-in database does not require administration and is fault tolerant. However, in rare cases, damage to the embedded database occurred. In this case, one of the following options is possible.