Mainframe Interview Questions,DB2 Administration Interview Questions, DB2 UDB Admin Interview Questions,DB2 Admin Interview

If you are given with a query, how you tune it?

Does runstats do a sort?

Explain the steps of Server Installation?

Explain the steps of Disaster Recovery?

What is Increamental /Delta Back up ?

What are the db cfg parms which affect the back up strategy?

Have you worked in partitioned DB ?

How to check no of active conncetions to the DB >> db2 list active databases

The Application team contacts saying DB response is very low what would you do ?

What is a Global Declared Temporary table ? How to use it ?

What is runstats ? how it improves performance ?

What is HADR ? How to load data to a HADR Server ?

SMS table space is full, filesystem is also full , Cannot add SAN what would you do ?

Have you worked in Partitioned DB ?

What are the tables spaces that get created when a DB is initially created,?

What is the use of SYSCAT SPACE ?

What is the use of buffer pools ?

What is buffer pool hit ratio ?

How would you see the buffer pool usage?

How do you find out deadlock transaction ?

What is Reorg check?

Whats are the different Back up types ?

Do you write shell scripts ?

Other than space utilization what is the difference between DMS and SMS ?

How do you find containers that are in error with out looking into diaglog ?

What DB parameter must be set to allow to take incremental back up ?

IBM Mainframe Tutorials - JCL DB2 COBOL CICS

Here you can find

• Links to JCL Tutorials, DB2 tutorials, SQL tutorials, COBOL tutorials, VSAM tutorials, XPEDITER tutorials, FILE-AID tutorials.
• Links to DB2 Inteview Questions, COBOL Interview questions, JCL interview questions, CICS interview questions, VSAM interview questions.
• You can also find links to IBMMAINFRAME Forums, COBOL forums, DB2 forums, CICS forums, VSAM forums, REXX forums, JCL forums, DFSORT forums, ICETOOL forums, EASYTRIEVE forums, IMS DB forums, IMS DC forums, XML forums, Mainframe Jobs forums, Interview questions forums.

IBM Mainframes Certification

To achieve challenging position in Software field, where my analytical and problem solving skills can put in for the successful completion of the project and the growth of the organization, which is in turn my growth and development.
Personal traits: Dedicated, Consistent positive notions, ability to work in groups, analytical and innovative skills. Good communication skill, Reasoning ability and smart working.

Software Exposure
IBM Mainframes : JCL, VSAM, COBOL, DB2, CICS, IMS
Languages : C, C++, HTML
Operating System : MS-DOS, Windows 9x, 2000, XP, UNIX
Package : MS –Office XP

Certification:
IBM Mainframes Certification from Hinduja TMT Ltd, Bangalore.

Project Profile:
ATM Transaction Management System
Module handled : Account information provider
Software : IBM Mainframes
Operating System : MVS, Z/OS - 390
Host Language : COBOL
Compiler : JCL
RDBMS/Backend : DB2
Description: This module will access the master database and generate the respective account information for those accounts with correctly entered passwords. It will generate various screens relevant to each transaction .Screens involved in this module designed using CICS and COBOL is used as host language. The database consists accounting information of customer like name, address, account number, password, amount deposited, retrieved. Once the password entered matches, this module will display account information.If, not the necessary instructions containing screen to proceed will comes into picture.