how many partitions are possible in partitioned tablespace?
dont say 1-64.
a)240
b)256
c)512
d)none
Answer Posted / 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 |
Post New Answer View All Answers
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
How do I add a column to a table in db2?
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?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What is check constraint. Explain with example.
What db2 400?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What is a db2 table?
How to find primary key of a table in db2?
What is database alias db2?
What is null indicator in cobol db2?
How to resolve deadlock issue
What is a db2 package?
What is difference between isnull and coalesce?
What is a page in db2?