Topic
No replies
SystemAdmin
SystemAdmin
1143 Posts
ACCEPTED ANSWER

Pinned topic Issue with the TRUNCATE statement in the Informix Developer Edition

‏2012-09-03T03:08:13Z |
Hi.

Using Informix Developer Edition (IBM Informix Dynamic Server Version 11.70.FC3DE)

Does anybody know of an issue with the TRUNCATE statement on a fragmented table. When I use the TRUNCATE statement on a table fragmented by round robin the rows in the table are deleted but it doesn't release the extents in the dbspaces.

The TRUNCATE statement works fine on a none fragmented table. I don't have this problem on our production box (11.70.FC2).

I have inspected the restrictions for the TRUNCATE statement in the SQL Guide and I don't think I'm encountering any of the conditions.

Thanks, Brendon.