ADM6017E error, but no obvious limit reached

[Ultrak The DBA]

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_TS D" (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(descrip tors) 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?

[Ultrak The DBA]

Re: ADM6017E error, but no obvious limit reached


Found out it was restarted as root which had ulimits.




On Feb 11, 9:09 am, Ultrak The DBA <truthinl...@ya hoo.comwrote:

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_TS D" (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(descrip tors) 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?