SEO

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 size and
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?

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?