Oninit
Talk to an expert →

Informix Error -21569: This client cannot create or open tables that use large rowids.

Cause and resolution

This client cannot create or open tables that use large rowids.

You are attempting to create or open a large table, but your client program is not compatible with large tables. Set the TABLE_SIZE session environment variable to "SMALL" or rebuild your client using the latest client libraries.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-21569 fires when a client that does not support large tables tries to create or open a table that uses large rowids.

  1. An older client or client library that is not compatible with large tables opens or creates a large table, per the official guidance.
Solutions / Resolution
  1. Set the TABLE_SIZE session environment variable to SMALL, per the official guidance, if the client must stay as it is.
  2. Rebuild or update the client with the latest client libraries.
Diagnostic Checks
  1. Check the client library version and whether TABLE_SIZE is set in the session.
Related Errors / Related Topics

No closely related error codes are cross-referenced for -21569 in this set yet.

The client is not compatible with large-rowid tables — set TABLE_SIZE to SMALL or update the client libraries.