Reorg fails when associated tablespace size reaches 1Gb

[Bruce Pullen]

db27.2 (fp13) on AIX 5.2.

The following error is generated when attempting a reorg or, more
precisely, when the file associated with the reorg tablespace reaches
1Gb.

SQL2216N SQL error "-968" occurred while reorganizing a database
table.

I can happily export to a file > 1Gb as the same userid (who created
the reorg tablespace and attempted the reorg) and on the same
filesystem (which is large-file-enabled).

The userid I'm using is that of the instance owner.

Is there a 1Gb temporary tablespace file-size limit?

[Ian]

Bruce Pullen wrote:

db27.2 (fp13) on AIX 5.2.

The following error is generated when attempting a reorg or, more
precisely, when the file associated with the reorg tablespace reaches
1Gb.

SQL2216N SQL error "-968" occurred while reorganizing a database
table.

I can happily export to a file > 1Gb as the same userid (who created
the reorg tablespace and attempted the reorg) and on the same
filesystem (which is large-file-enabled).

The userid I'm using is that of the instance owner.

Is there a 1Gb temporary tablespace file-size limit?

I assume that the temp tablespace is not DMS.

Check the ulimit settings for the instance owner. If they've been set
recently to remove the default fsize limit (i.e. changed since the
instance was started, but prior to you logging in as the instance
owner), you may need to restart the instance for it to pick up the
change.