472,954 Members | 1,663 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,954 software developers and data experts.

Reorg fails when associated tablespace size reaches 1Gb

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?
Nov 12 '05 #1
1 4637
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.

Nov 12 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

27
by: Raquel | last post by:
This question if for UDB on LUW. Suppose I take regular database backups of my database Monday: database backup <ts1> Tuesday: Tablespace reorged and imagecopied <ts2> Friday: database...
3
by: datapro01 | last post by:
Running db2 8.1.1 on aix 5.1. Tried to do an offline reorg on the system tables and could not reorg SYSIBM.SYSCOLDIST at about 3.5 million rows. Apparently there was not enough space in the...
1
by: Roger | last post by:
I am using DB2 Z/OS V 7. I am setting up a REORG job for an OLTP database. If i am taking REORG with SHRLEVEL CHANGE with COPYDDN , can I use the IMAGECOPY taken from the INLINE copy to restore...
9
by: mike_dba | last post by:
I am using DMS raw. I have a tablespace which is defined with 5 containers each allocated at 1.5 GB for a total of about 7.5 GB. I did a major deletion followed by a reorg and a runstats. I am...
9
by: Mikael | last post by:
Must admit, I am new to DB2: Seems I can not issue command REORG TABLESPACE: Commands Entered: REORG TABLESPACE SBO_DB.TS_SBO_SAFE; SQL0104N An unexpected token "TABLESPACE" was found...
1
by: pike | last post by:
DB2 v8.1 FP 11 on AIX 5.2. A REORG of a table created in a 4KB-PAGESIZE tablespaces with associated LONG data stored in a 16KB tablespace is failing with the following error: SQL2217N The...
0
by: bwmiller16 | last post by:
Hi All - OSName: AIX NodeName: dr_aixdb01 Version: 5 Release: 3 dr_aixdb01$db2level DB21085I Instance "db2inst1" uses "64" bits and DB2 code release "SQL08027"
7
by: Okonita via DBMonster.com | last post by:
Hi all, I am very surprised to see that after doing a Reorgchk followed by reorg of selected tables and concluding with a runstats of the reorged tables, all of the tables continue to be...
3
by: jane | last post by:
Hi, Just wondering, is there any way to do the online reorg to use temporary tablespace instead of tablespace table existed. since that is really a waste to have some space allocated aside...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
tracyyun
by: tracyyun | last post by:
Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...
2
by: giovanniandrean | last post by:
The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...
4
NeoPa
by: NeoPa | last post by:
Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...
1
by: Teri B | last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...
3
by: nia12 | last post by:
Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...
0
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
1
by: GKJR | last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.