Assume PROG A Calling PROG B, C and PROG C calling D and E, Here how many PACKAGES and PLAN will be created?
Answer : There will be a DB2 Package for every program and only one Plan
Showing posts with label DB2 Interview Questions. Show all posts
Showing posts with label DB2 Interview Questions. Show all posts
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 ?
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 ?
Usually, which is more important for DB2 system performance - CPU processing or I/O access?
Question:
Usually, which is more important for DB2 system performance - CPU processing or I/O access?I/O operations are usually most critical for DB2 performance (or any other database for that matter).
I'm sorry but the answer is a firm It depends. Depending on various factors most MVS boxes run short on either CPU or I/O. These factors include workload time of day day of the week etc. A capacity planner could give you a better list but these are the things I've seen in the past.For example daytime is usually devoted to getting info into and out of the system using CICS. This usually involves many many short inquiries or updates. Generally in this case the CPU is most important as the many levels of caching can handle these requests.However once users go home the main use switches doing updates to handling those updates. A single update I/O during the day can drive many thousands of I/O's to process that update. As batch processes work with whole filesets cache hit rates go down and I/O becomes more important.If you could provide more specifics perhaps we could come up with a better answer.
Exec sql and End exec
Question:
why do we declare include in between exec sql and end exec and why cant we declare copybook in place of include. Is their any reason why we declare include only
Answer:
INCLUDE is a pre-compiler statement so it should be coded within the scope of EXEC SQL and END-EXEC.
INCLUDE is expanded during pre-compilation tome but COPY is expanded during compilation time and so declaration of host variable in copybook will produce errors during pre-comilation.
INCLUDE is expanded during pre-compilation tome but COPY is expanded during compilation time and so declaration of host variable in copybook will produce errors during pre-comilation.
Answer2:
It all has to do with the sequence of compiling a program with imbedded SQL. It is important to understand that a COBOL program with SQL statements will actually go through 2 steps in the compile process - The Pre-Compile(SQL) followed by the COBOL compile.The EXEC SQL END-EXEC and everything in between are not COBOL statements and the COBOL compiler will not recognize them. The Pre-compiler step takes the EXEC SQL statements and converts them to the equivalent source code that COBOL will understand. The converted output from the pre-compile is then passed to the COBOL compiler in the 2nd step. It is for this reason that any data areas needed by the Pre-Compile step need to be included via a EXEC SQL INCLUDE statement.If you are also writing CICS COBOL with SQL then you will have 2 pre-compile steps for CICS and SQL followed by a COBOL compile step.
Subscribe to:
Posts (Atom)