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

Answers were Sorted based on User's Feedback



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

Answer / vish

Unfortunately nonoe of the above answers are completely
correct. Answer posted by Nawal Kishore is partly correct
but not the complete answer. Answer from Vani may be partly
correct depending upon the DSSiZE and the page size. Let me
try to answer the question:

DB2 alllows a maximum of 4096 partitions of a partitioned
table space. Actually, the maximum number of partitions in
a table space depends on the data set size (DSSIZE
parameter) and the page size. Thus the partitions can range
from 1 to 4096 depending upon the above parameters (DSSIZE
ands the page size).

You can refer to IBM documentations to confirm the
same...suggesstions are welcome...!!

Is This Answer Correct ?    3 Yes 0 No

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

Answer / nawal kishore

Partitions can be range from 1 to 4096

Is This Answer Correct ?    3 Yes 1 No

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

Answer / binaya patnaik

Minimu 4, Maximum 64

Is This Answer Correct ?    3 Yes 1 No

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

Answer / sathsih

MAXIMUM PARTITION IS 4096 AFTER VERSION 8.
EARLIER VERSION MAXIMUM PARTITION IS 254.
EACH PARTITION MAXIMUM SIZE IS 64GB OF DATA.

Is This Answer Correct ?    2 Yes 0 No

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

Answer / guest

first of all the question is wrong

Is This Answer Correct ?    2 Yes 1 No

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

Answer / viks

any body knows this answer plzzzzz

Is This Answer Correct ?    2 Yes 2 No

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

Answer / vani

256

Is This Answer Correct ?    0 Yes 0 No

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

Answer / 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

More DB2 Interview Questions

Q3. How will you fetch duplicate values from a DB2 table?

2 Answers   RBS,


What technique is used to retrieve data from more than one table in a single SQL statement?

9 Answers   CTS, IBM, TCS,


What is a result table?

1 Answers  


In a single table,How to retrieve a employee-id of an employee who works in more than one department?

15 Answers   Cap Gemini,


How will you return the number of records in table?

0 Answers  






What is an access path?

3 Answers  


what is SPUFI ?

2 Answers  


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

0 Answers   IBM,


What is drop table?

0 Answers  


What are the contents of dclgen?

0 Answers  


DB2 is a A) data base/data communication system B) data base C) RDBMS D) Programming language

4 Answers   Accenture,


How will fetch last 5 rows from table in db2

6 Answers  


Categories