Re: Spurious error 197?
What is interesting is that it says "partition" recently added to. That
seems to imply that the extents of a tblspace have been added to. But I
don't see why that would require a level-0 archive. You didn't by any
chance do an oncheck -pt of the table before doing the level-0? That might
have told us something. But I guess that as the problem has cleared we will
never know - and I know what you mean about immature techies :-0
regards
Malcolm W
----- Original Message -----
From: "Malc P" <malc_p@btinternet.com>
To: <informix-list@iiug.org>
Sent: Tuesday, December 23, 2003 4:39 PM
Subject: Spurious error 197?
> IDS9.30HC5, HPUX 11i, 4GL 7.20
> Just had this on one of our test systems when writing to a table:
> =====================================================================
> -197 ISAM error: Partition recently appended to; can't open for
> write or logging.
>
> If this internal error recurs, please note all circumstances and
> contact Technical Support at tsmail@us.ibm.com.
> =====================================================================
>
> ... but we haven't added any chunks or anything. Tried a checkpoint
> and a logical log (Oh how the immature techies laugh when you tell
> them you're going to force a log to see what happens. sigh.) but still
> got the error (both INSERT and UPDATE); it cleared when I did a
> level-0 to /dev/null. There are no blobs or varchars or anything nasty
> on the table, and no untoward messages in the online log - the
> instance has been up happily for the last week.
> Anyone seen this before? I'll raise a tech support case but they won't
> be that interested as the fault has cleared up.
> Cheers
> Malc
sending to informix-list