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 to take the back up of the DB2 table.

7 Answers  


What is the difference between IN subselects and EXISTS subselect?

1 Answers   HCL, PreVator, TCS,


What are db2 error codes -305 and -407. What is the difference between these 2 error codes ?

1 Answers  


What is isolation level in db2?

0 Answers  


Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?

2 Answers   Verizon,






I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

0 Answers   ITC Infotech, Syntel,


wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?

2 Answers  


what is plan? is plan executable or package?

4 Answers  


What are types of indexes?

0 Answers  


My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??

2 Answers   Xansa,


Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?

1 Answers  


what is datacom db?

2 Answers   CSC,


Categories