HP 3000 Manuals HP 3000 Manuals
Connecting to Multiple Databases and Multiple DBEnvironments A single DBEnvironment can contain multiple databases. The application software can connect to just one DBEnvironment and access multiple databases without the risk of encountering a non-detectable deadlock situation. However, a non-detectable deadlock situation can occur when your application software connects to multiple DBEnvironments at the same time. To avoid a non-detectable deadlock situation, use the ALLBASE/SQL SET USER TIMEOUT statement to specify the amount of time your application will wait if a requested database resource is unavailable. For detailed information, refer to the "SQL Statements" chapter in the ALLBASE/SQL Reference Manual and the "Transaction Management with Multiple DBEnvironment Connections" chapter in the ALLBASE/SQL Release F.0 Application Programming Bulletin for MPE/iX. To disconnect from all the databases, click on the PC API icon and select Close from the menu.