How can you do the explain of a dynamic sql statement?

1019

Which isolation level provides maximum concurrency?

1093

What is performance tuning db2?

1010

What are host variables in db2?

994

What does db2 plan contain?

966

What is the reason behind not using select * in embedded sql programs?

1049

What is the use of predicate?

985

How can you quickly find out the # of rows updated after an update statement?

987

Give a brief description of db2 isolation levels?

1018

define clustering index.

980

Explain dclgen.

1146

What is the role of schema in the db2 database?

1188

What are iseries servers?

1012

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

2280

What do you mean by rollback?

937