what are the max. & min. no. of partitions allowed in a
partition tablespace?

Answers were Sorted based on User's Feedback



what are the max. & min. no. of partitions allowed in a partition tablespace?..

Answer / rahul

1 to 64

Is This Answer Correct ?    0 Yes 0 No

what are the max. & min. no. of partitions allowed in a partition tablespace?..

Answer / s

The maximum number of partitions allowed in DB2 V8 is 4096
partitions.

Is This Answer Correct ?    3 Yes 6 No

Post New Answer

More DB2 Interview Questions

How do you run JCL in cobol program

1 Answers   IBM, Syntel,


how can you copy records present in a flat physical file to a database file(physical file).please explain in rpg400 with a simple example

1 Answers   CTS,


Discuss about db2 bind?

0 Answers  


How does DB2 determine what lock-size to use?

2 Answers  


In a DB2-CICS program which is acts as co-ordinator and which is participant?

1 Answers   IBM,






How do u achieve record level locking in DB2 versions when record level locking is not allowed?

2 Answers   IBM,


What is db2 isolation?

2 Answers  


For Null indicator we have 3 values 0,-1,-2. 0->Not nulll -1->Null -2->Value truncated If ther is any possibility to have any positive value other than 0 in Null indicator.If it is so then when we will get and what is the value?

1 Answers   BNP Paribas,


How are write I/Os from the buffer pool executed?

1 Answers  


What is host variable in db2 cobol?

0 Answers  


If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI

4 Answers   ADP,


I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?

10 Answers   Fidelity,


Categories