If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Note that '/dev/rdsk/data20' was the name set up by my UNIX administrator for a specific raw logical volume on an array striped by the OS.

In the above example 128000 is the number of pages (4K page size in this tablespace). If you want to express it in MB use 512M. I prefer to specify in pages because I believe that is how it is displayed when you do a db2look, regardless of how it was input (IIRC).

128000 X 4096 (page size) is 524,288,000 bytes. If there are 1,024,000 bytes per MB, that is 512MB. I am not sure if that is exactly right, so you can use 512M if you want to, and then do a db2look to see how many pages DB2 used.