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 |
Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code?
query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop
How can we define a table? How can we apply SEARCH ALL on it ?
Is it possible using max on a char column?
What will the FREE command do to a plan?
What is a thread?
Mention the definition of cobol in varchar field.
what is db2 restart?
What is temporal table in db2?
What is load utility in db2?
What are db2 objects?
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.