IBM DB2 UDB Interview Questions Answers.
Mainframe DB2 UDB Admin Interview Questions, FAQs.
What is online reorg/offline?Answer : 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?
Answer : LOAD with NORECOVERY option
Whats the difference between Load and import?
Answer : 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?
Answer : 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 ?
Answer : 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.
CICS Interview Questions | JCL Interview Questions |
DB2 Interview Questions | COBOL Interview Questions |
VSAM Interview Questions | IDMS Interview Questions |
IMS Interview Questions | MVS Interview Questions |
Related Posts
No comments :