DB2 Interview Questions

Call dsn8cc in cobol

How will you call dsn8cc in a cobol program and why it is used.

Db2 generate DDL

If, for a given table, the control center does not show the choice generate DDL, which of the following describes the reason? A. the table is a system object. B. the table is a summary table. C. the table is in load pending. D. the table is a replicated table. E. the table was created by a different...

Generate DDL?

If, for a given table, the control center does not show the choice generate DDL, which of the following describes the reason? A. the table is a system object. B. the table is a summary table. C. the table is in load pending. D. the table is a replicated table. E. the table was created by a different...

Which db2 components allows references to Oracle and db2 databases in a single query?

Which of the following db2 components allows references to Oracle and db2 databases in a single query? A. db2 query patroller b. db2 warehouse manager c. db2 relational connect d. db2 connect enterprise edition

Db2 memory structures

What are memory structures used to handle multiple row selections at a time 1 cursors2 host variables3 indicator variable4 SQLcacursors

Db2 SQL query

Table1 has the following data – book chapter ---------------------------- db2 retrieval db2 updates db2 locking cobol file processing cobol working storage jcl job statement cics maps what will be the result of the queryselect book from table1 group by book having count(*) > 1a.Db2, cobol, jcl,...

Db2 operating system

The operating system in which db2 runs isa.Os/2b.Unixc.Xenixd.Mvse.None of the above mvs

How to convert non-db2 files into db2 format for ex . Data in excel, ms-acces, Oracle etc.

What is db2 thread locks and thread terminator?What is lvl1 in tso mainframes?

I'm looking out for some solution or website that can lead me to the following issues that I currently face. Could some one please help me out on these. Loading of ‘db2 unload with packed decimal’...

What is a cartesian product?

A cartesian product results from a faulty query. It is a row in the results for every combination in the join tables.

Compare a subselect to a join. Any subselect can be rewritten as a join, but not vice versa. Joins are usually more efficient as join rows can be returned immediately, subselects require a temporary work...

Db2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences. A merge join requires that the tables being joined be in a sequence; the rows are retrieved...

What is the difference between static and dynamic SQL?

Static SQL is hard-coded in a program when the programmer knows the statements to be executed. For dynamic SQL the program must dynamically allocate memory to receive the query results.

What keyword does an SQL select statement use for a string search?

The like keyword allows for string searches. The % sign is used as a wildcard.

How is the substr keyword used in SQL?

Substr is used for string manipulation with column name, first position and string length used as arguments. Eg. Substr (name, 1 3) refers to the first three characters in the column name.

Explain transactions, commits and rollbacks in db2. In db2 a transaction typically requires a series of updates, insertions and deletions that represent a logical unit of work. A transaction puts an implicit...

In terms of db2 indexing, what is the root page?

The simplest db2 index is the b-tree and the b-tree's top page is called the root page. The root page entries represent the upper range limits of the index and are referenced first in a search.

What are some characteristics of columns that benefit from indexes?

Primary key and foreign key columns; columns that have unique values; columns that have aggregates computed frequently and columns used to test the existence of a value.

What is meant by index cardinality?

The number of distinct values for a column is called index cardinality. Db2's runstats utility analyzes column value redundancy to determine whether to use a tablespace or index scan to search for data.