Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2003
    Posts
    4

    Unhappy Unanswered: Urgent -- 131 Error

    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

  2. #2
    Join Date
    Aug 2003
    Location
    India
    Posts
    262

    Re: Urgent -- 131 Error

    Originally posted by toml
    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

  3. #3
    Join Date
    Aug 2003
    Posts
    4
    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

  4. #4
    Join Date
    Aug 2003
    Posts
    4

    Talking

    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

  5. #5
    Join Date
    Aug 2003
    Location
    India
    Posts
    262
    Originally posted by toml
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •