Interested to Buy Any Domain ? << Click Here >> for more details...
how many partitions are possible in partitioned tablespace?
dont say 1-64.
a)240
b)256
c)512
d)none
- 8 Answers
- 15893 Views
- Amdocs, HeadStrong, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vish
Unfortunately nonoe of the above answers are completely
correct. Answer posted by Nawal Kishore is partly correct
but not the complete answer. Answer from Vani may be partly
correct depending upon the DSSiZE and the page size. Let me
try to answer the question:
DB2 alllows a maximum of 4096 partitions of a partitioned
table space. Actually, the maximum number of partitions in
a table space depends on the data set size (DSSIZE
parameter) and the page size. Thus the partitions can range
from 1 to 4096 depending upon the above parameters (DSSIZE
ands the page size).
You can refer to IBM documentations to confirm the
same...suggesstions are welcome...!!
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / sathsih
MAXIMUM PARTITION IS 4096 AFTER VERSION 8.
EARLIER VERSION MAXIMUM PARTITION IS 254.
EACH PARTITION MAXIMUM SIZE IS 64GB OF DATA.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / vat
Depends on version of DB2 also
V7:
64: NOT (LARGE OR DSSIZE > 2GB)
254: LARGE OR DSSIZE > 2GB
V8:
64: NOT (LARGE OR DSSIZE > 2GB)
4096: Depending on what's specified for DSSIZE OR LARGE and
the page size
| Is This Answer Correct ? | 0 Yes | 1 No |
how to identify the pseudo conversation by seeing the program
1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.
Which catalog table stores referential constraints?
When will you chose to run RUNSTATS?
Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2 how will we do this. We can create a single program and a single load for this program.
Mention the different locking levels that are available in db2.
Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?
what is Runstats? Whem will u choose to runatats?
What is meant by AUTO COMMIT?
What is load replace in db2?
Explain the use of the WHERE clause?
Explain the contention situations caused by locks?
COBOL 
