Chapter 8
| A1: | DB2 supports a database with up to 1,000 partitions. |
| A2: | The IBMDEFAULTBP buffer pool is created automatically in every database. |
| A3: | Since the row width is over 9,000 bytes, the table must be created in a table space with at least a 16K page size. |
| A4: | A table's data object in an SMS table space will be placed in a file with a .DAT extension. |
| A5: | The command LIST TABLESPACES SHOW DETAIL will display the number of used and free pages in each table space. |
| A6: | DMS table spaces are completely allocated when they are created. |
| A7: | SMS table spaces grow and shrink as the tables and indexes within them grow and shrink. |
| A8: | When a table has been defined with its data, index, and large objects in different table spaces, you cannot drop one of the ... |
Get Understanding DB2®: Learning Visually with Examples now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
