what’s the error code for Unique Index Voilation:

-803

DB2 Comments Off

what’s the best locksize that you could use when you create a tablespace?

The answer is Locksize = ANY.Unless you are Sure what’s the Purpose of tablespace ie.,Read-only or R/W.If you use lock size =any, Db2 would automatically determine what type of locks it should use.

DB2 Comments Off

What is the size of a data page?

4K to 8K

DB2 Comments Off

The only place of VSAM KSDS in DB2 is?

BSDS is a VSAM KSDS.

DB2 Comments Off

MAX. NO OF ROWS PER PAGE

127

DB2 Comments Off

What is EXPLAIN in DB2

EXPLAIN is used to detail the access paths chosen by DB2 optimizer for SQL statement. This command is used to monitor the performance of SQL statement used in a program.
Answer: BIND mainly performs two things syntax checking and authorization checking.It binds together all packages into an application plan hence the name BIND.Apart from this bind has optimiser as a subcomponent.Its function is to determine the optimum access strategy.

DB2 Comments Off

What is a lock?

A lock is the mechanism that controls access to data pages and table spaces.

DB2 Comments Off

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.

DB2 Comments Off

What is the difference between IN sub selects and EXISTS sub select?

If there is an index on the attributes tested an IN is more efficient since DB2 uses the index for the IN (IN for index is the mnemonic).

DB2 Comments Off

Compare a sub select to a join.

Any sub select can be rewritten as a join, but not vice versa Joins are usually more efficient as join rows can be returned immediately, sub selects require a temporary work area for inner selects results while processing the outer select.

DB2 Comments Off