Hi,

Im trying to loaded data into tables and am now getting

Database error: <sqlcode -271> <sqlstate IX000> <text - Could not insert new row into the table. >

Database error: <sqlcode -131> <sqlstate IX000> <text - ISAM error: no free disk space >

How can I tell if the dbspace my table is in is full ??
What do I do to fix this problem.

Thanks,

Tom

Hi Tom,

use onstat -d, it will give list of all dbspaces along with their size & free space available. You can add new dbspace thru Onmonitor.

Regards,

lloyd

lloyd,

Thanks, but looking at my system I appear to have loads of free space.

dbspace pages_size pages_used pages_free percent_free

dbspace1 10485250 8378013 2107237 20.10
dbspace2 10485250 7824830 2660420 25.37
dbspace3 10485250 7120230 3365020 32.09
dbspace4 10485250 8453730 2031520 19.38
indexspa 3145575 1847543 1298032 41.27
logspace 500000 150053 349947 69.99
phydbs1 500000 53 499947 99.99
rootdbs 1048525 258284 790241 75.37
sbspace1 8388200 4464015 3924185 46.78
tempdspa 1048525 677 1047848 99.94

I'm not sure adding a new chunk will make any difference.

Looking up the web, I found that error 271 appears to relate to problems with locking. I've run oncheck -cRecIxD and had no problems reports, except that each of the rawspaces have been set up with premissions 777 instead of 660. I'm ruling this out as a problem as I've been loading data for the last 9 days without a problem.

Thanks,

Tom

Hi,

llyod, you were right.

I can created indexspaces and when I created my tables I said to create indexs in indexspace1. This had become full and so no indexes could be added to the database.

I added an extra chunk to indexspace1 and the system is now working fine.

Thanks,

Tom

Hi Tom,

Your welcome, its great that ur system is working fine now.

Regards,

lloyd