DB2 UDB Interview Questions Answers
What is online reorg/offline?
Ans: Both online and offline are there, online reorg allows other transaction to access the tables. REORG with ALLOW NO/READ/WRITE ACCESS
If you want to load data without any chance of taking the tablespace to back up pending state ,how will you achieve it?
Ans:LOAD with NORECOVERY option
Whats the difference between Load and import?
Ans:Load is faster than import, import is like bulk insert, every thing goes to the transaction log.
Would you load data to the production tables directly?
Ans:No,this cannot be used.Instead use staging tables
If application team is contacting you telling the application is running very slow , what all things you will check out ?
Ans:Check for any transactions that are in lock wait state, list in doubt transactions
- Table DB snap shop, Application snapshot,sql snap shopt , cpu utilization using top,check is there any stale connection( connections that very old )
- check if any background process is running there using list utilities.
- Check the number of active connections to the DB server.
- Force the application/transactions which are in lock wait state.
What is online reorg/offline?
Ans: Both online and offline are there, online reorg allows other transaction to access the tables. REORG with ALLOW NO/READ/WRITE ACCESS
If you want to load data without any chance of taking the tablespace to back up pending state ,how will you achieve it?
Ans:LOAD with NORECOVERY option
Whats the difference between Load and import?
Ans:Load is faster than import, import is like bulk insert, every thing goes to the transaction log.
Would you load data to the production tables directly?
Ans:No,this cannot be used.Instead use staging tables
If application team is contacting you telling the application is running very slow , what all things you will check out ?
Ans:Check for any transactions that are in lock wait state, list in doubt transactions
- Table DB snap shop, Application snapshot,sql snap shopt , cpu utilization using top,check is there any stale connection( connections that very old )
- check if any background process is running there using list utilities.
- Check the number of active connections to the DB server.
- Force the application/transactions which are in lock wait state.
