Create Tablespace - DMS overhead

[kozlow]

The only thing I can find on space needed for DMS overhead is "53 Bytes plus the size needed to hold the Container Name".

I am having some problems where I recieve an error:
SQL0968C The file system is full.

When I try an ALTER TABLESPACE DATA01 EXTEND.....

Any Ideas?

 

[gregsimpson]

Koz,

I have encountered problems before with the large files as detailed below.

ulimit and large file enabled
To create large files on AIX greater than 2GB, "Large file enabled" must be true for the file system, and fsize for the DB2 instance owner must be set to unlimited (or -1). To verify your settings using smit, (AS ROOT) select:
System storage management
File systems
Add/change/show/delete file systems
Journaled file systems
Change/show characteristics of a journaled file system (select File System where DB2 data resides)
Large file enabled TRUE
To change the hard and soft limit of fsize to unlimited, run the following two commands (AS ROOT):
ulimit –Hf unlimited ( Hard Limit)
ulimit –Sf unlimited ( Soft Limit )



You may use ulimit –Ha and ulimit –Sa to display the hard and soft limit, respectively. Ulimit sets the /etc/security/limits for the system.

Leaving the default values set by AIX can cause the following error:
SQL0968C – The file system is full.


There are other reasons for SQL0968C but it's probably worth making sure it's not this one first of all.

Cheers
Greg