DB2 UDB Interview Questions Answers

1/09/2010 No Comment

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 QuestionsJCL Interview Questions
DB2 Interview QuestionsCOBOL Interview Questions
VSAM Interview QuestionsIDMS Interview Questions
IMS Interview QuestionsMVS Interview Questions
Related Posts


No comments :

 

Aired | The content is copyrighted and may not be reproduced on other websites. | Copyright © 2009-2016 | All Rights Reserved 2016

Contact Us | About Us | Privacy Policy and Disclaimer