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 |
When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing?
Return code 100 means?
How to find primary key of a table in db2?
What is dbrm? When it will be created?
How and when does the db2 enforces the unique key?
How to solve S0C7 abend with out using DISPlay in 10 mins?
What are the two types of logging in the db2 database? Explain them.
How can you display the current date & current time ?
What is db2 instance?
I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).
What is Call attach facility? How does it work?
How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?