Possibile situations where DB server forces to close the applications connected to it? Some of the situations can be : DB2 restart, DB2 stop, DB2 suspend. What else situations in DB2 server forces to close the applications connected to it? Your help is greatly appreciated !
Answer Question | June 29, 2011 11:00 AM
DB2, DB2 restart, DB2 stop, DB2 suspend, DB2 Universal Database, DB2 Update Query, DBFO, IBM DB2
I heard from our dev team that our db tables are designed such that there is no chance of deadlock. How to test whether the Database tables design avoids deadlock? By reviewing the db scripts (table creation) can we find whether the db table design is deadlock proof or not? What else can we do? [...]
Answer Question | December 10, 2008 11:04 AM
Database deadlock, Database design, Database Failover, Database modeling, Database security, DB2, DBFO, Oracle, SQL Database, SQL Query, SQL Server
Hi, We are doing Database FailOver testing (DBFO). As part of this, we want to check if primary db is in deadlock state then what happens? whether the transactions will go to back up db or not? How to get the primary db into deadlock state? Appreciate your help.
Answer Question | December 2, 2008 11:44 AM
Database deadlock, Database Failover, Database security, DB2, DBFO, Oracle, SQL Database, SQL Query, SQL Server
We have Server connected to Primary, Secondary DB instance. If any of these DB instance is shutdown, forced to shutdown, network disconnected etc, then server will failover to the secondary db and viceversa. We want to test the ‘DB Connection Pooling’ feature involved in the DBFO mechanism. Also, what measurements can we consider? like Connections [...]
Answer Question | November 13, 2008 1:18 PM
Database Failover, DB Connection Pooling, DBFO, Functional testing, Software Quality, Software Quality Assurance, Software security testing, Software testing, Software testing tools