Creation of Tablespaces and Tables

[ Team LiB ]

Creation of Tablespaces and Tables A tablespace and table strategy needs to be developed: the type of space that will be used, SMS or DMS, as well as the size and number of tables per tablespace, along with the number of containers to be used. HINT Prior to creation of tablespaces, remember to enable the DB2_PARALLEL_IO environmental variable so that it is applied to any tablespaces you create. File systems must be built or drive assignment verified and raw logical volumes requested if DMS device containers are being used. This requires coordination with system, storage, and possibly network or InfiniBand administrators if storage area networks (SANs) or InfiniBand networks are being used or planned. Tablespace Breakout Strategy A tablespace breakout strategy consists of the following: Assigning high priority tables to a single tablespace. Placing high priority tablespaces in dedicated bufferpools and/or on separate physical disks or disk arrays. Creating separate tablespaces for indexes and/or assigning indexes to separate bufferpools.

[ Team LiB ]