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 would you print the output of an SQL statement from SPUFI?

2 Answers  


What are the three lock types?

2 Answers  


when does the SQL statement gets executed when you use cursor in the application programming ?

3 Answers   IBM,


What is the information associated with sysibm.syslinks table?

0 Answers  


What is the meaning concurrency in the db2 database?

0 Answers  


I have 1000 rows in a db2 table.I want to update first 100 records,How do I do it?

4 Answers   CTS,


i have one file having 100 of records? i want to display it like 20 records in one column and 20 records in another column total 40 records per page ? how ?

2 Answers   EDS,


What error I will get if my select query gives multiple row while executing a Cobol-DB2 program.How can I solve it without using a cursor.

4 Answers   Cap Gemini, Verizon,


what's the equivalent Cobol Data type for Decimal(x,y) in DB2? what does the current SQLID register contain?

3 Answers   Cap Gemini, Tech Mahindra,


What are some SQL aggregates and other built-in functions?

2 Answers  


What is lock escalation?

2 Answers  


I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

1 Answers   HeadStrong,


Categories