Invalid TBLTBLFIRST. The extent size specified is too small.

Technote (troubleshooting)


Problem(Abstract)

Error message "Invalid TBLTBLFIRST. The extent size specified is too small." when trying to bring an IBM Informix® Server online.

Symptom

Instance fails to start raising the error message "Invalid TBLTBLFIRST. The extent size specified is too small." when trying to bring an IBM Informix® Server online. It is possible that sometimes the message parameters change showing an error message that looks similar to this: "Invalid TBLTBLNEXT. The extent size specified is too small."


Cause

The ONCONFIG parametersTBLTBLFIRST and/or TBLTBLNEXT are not set properly.

Environment

Setting both ONCONFIG parameter values below the limit of 500K and 100K for 2k pagesize systems, and 1000K and 200K for 4k pagesize systems will raise this message when trying to bring the IBM Informix® instance online:

$ oninit -v
Invalid TBLTBLFIRST. The extent size specified is too small.

These ONCONFIG parameters has nothing to do with regular tables first/next extent size.

There is a lot of confusion regarding the usage of such parameters:
TBLTBLFIRST
TBLTBLNEXT

Diagnosing the problem

The test case information in this document proves that 1)setting both parameters and 2) creating a table from scratch, will not set the newly created table first and next extent sizes accordingly:


$ onstat -c|grep TBLT
# TBLTBLFIRST - The first extent size, in KB, for the tblspace
# TBLTBLNEXT - The next extent size, in KB, for the tblspace

TBLTBLFIRST 500
TBLTBLNEXT 100

$ echo "create table a (x char(10))"|dbaccess stores_demo

Database selected.


Table created.


Database closed.


$ dbschema -d stores_demo -t a -ss

DBSCHEMA Schema Utility INFORMIX-SQL Version 11.70.FC5

{ TABLE "informix".a row size = 10 number of columns = 1 index size = 0
}

create table "informix".a
(
x char(10)
) extent size 16 next size 16 lock mode page;

revoke all on "informix".a from "public" as "informix";


These parameters dramatically control the size of the first/next extents of the root
and non-root dbspace tlbspace tblspace.

Each dbspace contains a tblspace called the tblspace tblspace that
describes all tblspaces in the dbspace. When the database server creates
a tblspace, it places an entry in the tblspace tblspace that describes
the characteristics of the newly created tblspace. You cannot drop or
move a chunk containing a tblspace tblspace.


Resolving the problem

Check for the minimum required values.


A dbspace can have a maximum number of 2**20 tblspaces.
The default size of the first and next extents depends on whether the
dbspace is the root dbspace or not, as shown in the following table.

Root dbspace:
500 KB for a 2 kilobyte page system
1000 KB for a 4 kilobyte page system

Non-root dbspace:
100 KB for a 2 kilobyte page system
200 KB for a 4 kilobyte page system

You can specify a non-default size for the first and next extents for a
tblspace tblspace in the following ways:

  • For the root dbspace, set the TBLTBLFIRST and TBLTBLNEXT configuration parameters.
  • For non-root dbspaces, use the onspaces utility -ef and -en options when you create a dbspace.

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Informix Servers

Software version:

11.1, 11.5, 11.7, 12.1

Operating system(s):

AIX, HP-UX, Linux, Solaris

Software edition:

Developer, Express, Growth, Hypervisor, Innovator, Ultimate

Reference #:

1632032

Modified date:

2014-01-09

Translate my page

Machine Translation

Content navigation