what are the max. & min. no. of partitions allowed in a
partition tablespace?
Answers were Sorted based on User's Feedback
Answer / s
The maximum number of partitions allowed in DB2 V8 is 4096
partitions.
| Is This Answer Correct ? | 3 Yes | 6 No |
Give some example of statistics collected during RUNSTATS?
what is the difference between where clause and having clause
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What are the 2 sqlcodes that are returned?
What is rct?
What is the FREE command?
Request to database but database is not available so what is was abend is raised?
What is an intent lock?
What is a db2 package?
what is SMP/E? and what are the major steps of it? thanks...
Explain about cursor stability?
how to execute qcmdexc in rpgle?plz write code also?