Found out it was restarted as root which had ulimits.




On Feb 11, 9:09*am, Ultrak The DBA <truthinl...@yahoo.com> wrote:
> 64 bit instance:
> DB21085I *Instance uses "64" bits and DB2 code release "SQL08027" with
> level identifier "03080106".
> Informational tokens are "DB2 v8.1.1.128", "s061108", "U810098", and
> FixPak
> "14".
>
> db panic on the following error:
> MESSAGE : ADM6017E *The table space "BALANCE_TSD" (ID "7") is full.
> Detected on
>
> * * * * * container "/db2data/dbtcf/Balance_TSD/cont1" (ID "0").*The
>
> * * * * * underlying file system is full or the maximum allowed space
> usage for
>
> * * * * * the file system has been reached. It is also possible that
> there are
>
> * * * * * user limits in place with respect to maximum file sizeand
> these
>
> * * * * * limits have been reached.
>
> user limit for instance owner:
> time(seconds) * * * *unlimited
> file(blocks) * * * * unlimited
> data(kbytes) * * * * 245760
> stack(kbytes) * * * *32768
> memory(kbytes) * * * unlimited
> coredump(blocks) * * unlimited
> nofiles(descriptors) 2000
>
> filesystem sizing:
> Filesystem * *GB blocks * * *Free %Used * *Iused %Iused Mounted on
> /dev/lvdb2dat * *256.00 * *157.80 * 39% * * *113 * * 1% /db2data
>
> Tblespace info
> ID * * *NAME * * * * * * * * * *USEABLE PAGES * USED PAGES * * *HIGH
> WATER * * *FREE PAGES * * *KB ALLOCATED * *% FREE
> 7 * * * BALANCE_TSD * * * * * * 10049952
> 5898784 * * * * 5898784 * * * * 4151168 * * * * 82329600 * * * *41
> 8K Tablespace
> *Total pages * * * * * * * * * * * * *= 10050000
> *Useable pages * * * * * * * * * * * *= 10049952
> *Used pages * * * * * * * * * * * * * = 5898784
> *Free pages * * * * * * * * * * * * * = 4151168
> *High water mark (pages) * * * * * * *= 5898784
> *Page size (bytes) * * * * * * * * * *= 8192
> *Extent size (pages) * * * * * * * * *= 32
> *Prefetch size (pages) * * * * * * * *= 64
>
> aix version
> oslevel -s
> 5300-05-06
>
> Any ideas?