dbspace

When you installed DB2, you created public and private dbspaces. QMF needs some of the public dbspaces for tables, queries, procedures, forms, and data.

A dbaspace is a logical allocation of space in the database, which consists of 4K pages. To convert dbspaces to megabytes, cylinders and tracks, or to add dbspaces to the database, see the DB2 Server for VSE System Administration manual.

If QMF tries to acquire the dbspace and there is not an exact match, it will try to acquire the next largest size available. To avoid wasting space, check that you have:

• One 5,120-page public dbspace
• Three 256-page public dbspaces
• Six 128-page public dbspaces

QMF needs this amount of space for each DB2 database; if you have multiple databases, you need to take that into account. To verify the size of the dbspaces, you can enter the following SQL statement from ISQL:

SELECT * FROM SYSTTEM.SYSDBSPACES WHERE DBSPACETYPE=1 AND OWNER=' '

Your disk storage allotment is the sum of the dbspace, VSAM catalog space and library block size calculated in cylinders or blocks.