1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

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

Question Posted / vat

Answer Posted / vat

Depends on version of DB2 also
V7:
64: NOT (LARGE OR DSSIZE > 2GB)
254: LARGE OR DSSIZE > 2GB

V8:
64: NOT (LARGE OR DSSIZE > 2GB)
4096: Depending on what's specified for DSSIZE OR LARGE and
the page size

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

720

What are the uses of db2 optimizer?

819

Where do you specify them?

681

What is database manager in db2?

552

What does db2 stand for?

598




What is the role of union all and union

651

Define sqlca.

651

What is the use of commit in db2?

636

What is sqlca?

625

Explain the contention situations caused by locks?

594

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

637

Can you use max on a char column?

638

Is db2 relational database?

574

Can there be more than one cursor open for any program?

662

How do you stop a db2 database in linux?

570