Oninit
Talk to an expert →

Informix Error -600

-600 Cannot create TEXT or BYTE value.

This statement creates a new BYTE or TEXT value, but some unexpected error prevented the creation of that value. Roll back the current transaction. Check the accompanying ISAM error code for more information. Possibly the storage space or tblspace has filled up, or you are not referring to a valid storage space. If the error recurs, note all circumstances and contact IBM Informix Technical Support.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-600 fires when creating a new TEXT/BYTE (simple large object) value fails unexpectedly — the first of a three-error family covering create (-600), delete (-601), and open/locate (-602) failures for these types.

  1. The storage space or tblspace holding the BLOB data has filled up, per the official guidance — the specific, most likely cause.
  2. A reference to an invalid storage space, per the official guidance, for where the new TEXT/BYTE value should be created.
  3. An underlying ISAM-level error during creation, per the official guidance's pointer to checking the accompanying ISAM error code for other possibilities.
Solutions / Resolution
  1. Roll back the current transaction, per the official guidance.
  2. Check the accompanying ISAM error code, per the official guidance, for the specific underlying reason.
  3. Check free space in the storage space/tblspace holding the BLOB data, since a shortage is the most likely named cause:
    onstat -d
  4. Confirm the storage space referenced is actually valid, per the official guidance, if free space isn't the issue.
  5. If this recurs after ruling out space and validity issues, note all circumstances and contact IBM Informix Technical Support, per the official guidance.
Examples
Checking space before escalating
$ onstat -d
-- review free-page counts for the blobspace/dbspace holding TEXT/BYTE data
Diagnostic Checks
  1. Check the accompanying ISAM error code first, per the official guidance.
  2. Check free space in the relevant storage space/tblspace as the most plausible concrete cause named by the official text.
Related Errors / Related Topics
  • -601 — "Cannot delete TEXT or BYTE value." Same family, at the delete stage instead of create.
  • -602 — "Cannot open TEXT or BYTE value." Same family, at the open/locate stage instead of create.

The first stage in a three-error BLOB-operation family — check free space in the storage space/tblspace first, then the accompanying ISAM error code.