how many partitions are possible in partitioned tablespace?
dont say 1-64.
a)240
b)256
c)512
d)none

Answer Posted / viks

any body knows this answer plzzzzz

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

579


What are the 2 sqlcodes that are returned?

642


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 ?

1818


DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2278


What is plan in cobol db2?

595






What is package in db2 mainframe?

559


What is release/acquire in bind?

656


Before you give the explain statement, what are the prerogatives?

581


How is deadlock resolved?

650


Which are the db2 tools to protect integrity of the database?

691


What is bufferpool in db2?

579


Name the various locking levels available?

634


Mention a credible reason why select* is never given preference in an sql program that has been embedded.

719


What does a deadlock mean in DB2?

653


How can tablespace be moved to another dasd volume that is allocated for that tablespace?

749