Connector Guides › Connector Xpress Guide › Troubleshooting › Tuning the Database Used by the Provisioning Server

Tuning the Database Used by the Provisioning Server

We recommend that you tune your Provisioning Server. If you do not tune the Provisioning Server, its performance can suffer when there are large numbers of objects stored in dynamic namespaces (JDBC and JNDI).

Use the CA Directory dxtunedb command if you add many objects to the Provisioning Directory. With the introduction of the dynamic namespace option, execute the following Ingres commands following each dxtunedb command:

• optimizedb –zr499 –zu240 <database name> -rsubsearch –acid
• optimizedb –zr499 –zu240 <database name> -rdit –aparent –ardnkey –aeid
• sql <database name> > set trace point RD010 \g