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 |
how to take the back up of the DB2 table.
What is the difference between IN subselects and EXISTS subselect?
What are db2 error codes -305 and -407. What is the difference between these 2 error codes ?
What is isolation level in db2?
Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
0 Answers ITC Infotech, Syntel,
wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?
what is plan? is plan executable or package?
What are types of indexes?
My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??
Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?
what is datacom db?