Problem with dostats

Posted in 2004

Dale Gilbert — Thu, 27 May 2004 12:40:50 -0700 — source: Usenet: comp.databases.informix

I am getting the following error running dostats: Cannot FETCH curs2. SQL=-461, ISAM=0 I have this same binary running on several other Sun servers (IDS v7.31UD1) without problem. I get this error if I try to do the entire instance, a single db or single table. Thanks sending to informix-list

↪ replying to Dale Gilbert

Art S. Kagel — Fri, 28 May 2004 13:09:13 -0400 — source: Usenet: comp.databases.informix

On Thu, 27 May 2004 15:40:50 -0400, Dale Gilbert wrote: Check your environment variables: DBSPACETEMPPSORT_DBTEMP Make sure that the dbspaces listed in the former and the filesystems listed in the latter all exist and are writable by user informix. If these are not set in your own environment (ie the one running dostats) check the values that were set for the engine at startup (or just set some good ones yourself to override any 'bad' ones set in the server). Art S. Kagel