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

How do I add a column to an existing table in db2?

578

Can you use max on a char column?

631

Explain the function of data manager.

628

What are the rules for db2 programming?

634

What are the 2 sqlcodes that are returned?

631




What are iseries servers?

558

What is the syntax for FETCH in DB2 ?

663

What is a cursor in programming?

583

What db2 400?

667

How do I start db2 in windows?

554

What is difference between alias and synonym in db2?

633

What is query_cache_limit?

541

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

628

Explain how can you do the explain of a dynamic sql statement?

643

What is precompiler in db2?

579