Error 179 - any ideas??

Posted in 1997

Neil Truby — Wed, 16 Jul 1997 22:26:24 -0700 — source: Informix-list mailing list archive (1991-1998)

I set up a test instance on a server, with a copy of our production database, for testing. I kept BUFFERS very small - 500 I think. The server application failed with 179 errors (no more sort space). This suggests a problem with DBSPACETEMP. It's certainly true that my setting for this area would have been unusable, since there's a bug in our release of OnLine (7.13) whereby all temporary dbspaces in a restored instance will be marked down. I bounced the database server with BUFFERS set to 5000, but no other parameter changes. The temporary dbspaces remain down, but the application worked fine from then on. Why should this be?