New PDF release: Sap Solutions on IBM DB2 Udb V8.2.2 Handbook

By Whei-Jen Chen

ISBN-10: 0738493880

ISBN-13: 9780738493886

Show description

Read Online or Download Sap Solutions on IBM DB2 Udb V8.2.2 Handbook PDF

Best languages & tools books

Debugging Applications for Microsoft.NET and Microsoft - download pdf or read online

Within the predecessor quantity of Debugging functions for Microsoft . web and Microsoft home windows, which handled visible simple 6, John Robbins broke new flooring via codifying the innovations and techniques serious about debugging Microsoft home windows functions. during this greatly revised and masses longer model (in retaining with Microsoft's enormous shift to the .

Additional resources for Sap Solutions on IBM DB2 Udb V8.2.2 Handbook

Example text

In this kind of table space, DB2 UDB is responsible for managing the storage space. DB2 UDB strips the information stored to ensure an even distribution of the data in the containers. Typically containers reside in different disks to avoid I/O bottleneck problems. The space for DMS table spaces is allocated when the table space is created. Chapter 2. DB2 UDB architecture from SAP’s point of view 29 DMS table spaces can also have many containers. If a container in a DMS table space becomes full, DB2 UDB can still use the free space of the other containers.

2, the basic space unit allocated is an extent. In previous versions of DB2 UDB, the basic space unit allocated was a page. If we wanted to allocate an extent, run the db2empfa tool. This tool changes the MULTIPAGE_ALLOC database configuration parameter from NO to YES. We can have many directories used as containers in an SMS table space; however, once the file system that holds the table space container is full, the complete SMS table space is considered to be full and we cannot allocate new containers.

If we wanted to allocate an extent, run the db2empfa tool. This tool changes the MULTIPAGE_ALLOC database configuration parameter from NO to YES. We can have many directories used as containers in an SMS table space; however, once the file system that holds the table space container is full, the complete SMS table space is considered to be full and we cannot allocate new containers. Therefore, it is important to know the size requirements of the table space and create all required containers when the table space is created.

Download PDF sample

Sap Solutions on IBM DB2 Udb V8.2.2 Handbook by Whei-Jen Chen


by Jeff
4.1

Rated 4.76 of 5 – based on 35 votes