This is an old revision of the document!
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.
