473,322 Members | 1,736 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

How to fix importing error: SQL3306N An SQL error "-289 ?

1
hope someone can help me out in this error!
thanks alot!

EXPORT TO "D:\PROGRA~1\IBM\SQLLIB\WEBCPTAB.IXF" OF IXF MESSAGES "D:\PROGRA~1\IBM\SQLLIB\WEBCPTAB.EXM" SELECT * FROM DB2ADMIN.MCREC

Number of rows exported: 1271587


IMPORT FROM "D:\PROGRA~1\IBM\SQLLIB\WEBCPTAB.IXF" OF IXF COMMITCOUNT 5000 MESSAGES "D:\PROGRA~1\IBM\SQLLIB\WEBCPTAB.IMM" CREATE INTO DB2ADMIN.MCRECTEST IN WARRANTY01 INDEX IN WARRANTY02
SQL3306N An SQL error "-289" occurred while inserting a row into the table.
Feb 22 '07 #1
2 17659
Hope you have had a reply .. just in case ... error is a tablespace free space problem .. thus extend/resize
Nov 4 '10 #2
vijay2082
112 100+
Hi,

this probably points towards a space issue, which can result for various underlying conditions. Look at your diagnostic log file whihc will give you more information on what went wrong at the database level.

You can know the location of your diagnostic log files using below command

db2 get dbm cfg|grep -i "diag"

Look for the value set for DIAGPATH where you can find db2diag.log file

Complete listing for the error code for db2 v9.5 is as below:

C:\Windows\system32>db2 " ? sql289n "


SQL0289N Unable to allocate new pages in table space
"<tablespace-name>".

Explanation:

One of the following conditions is true on one or more database
partitions:

1 One of the containers assigned to this SMS table space has
reached the maximum file size. This is the likely cause of the
error.

2 All the containers assigned to this DMS table space are full.
This is the likely cause of the error.

3 A rebalance is in progress, but has not progressed far enough
to enable the newly added space to be used.

4 A redirected restore is being done to containers that are too
small.

5 A rollforward is being done following a redirected restore and
all the containers assigned to this tablespace are full.

6 A rollforward skipping add containers is being done and all the
containers assigned to this tablespace are full.

7 An attempt was made to create a table space with less than 5
usable extents.

8 An auto-resize table space has reached its maximum size and all
of the containers are full. Alternately, there is not enough
space between the current size and the maximum size for
containers to be extended or added so an automatic increase in
space is not possible.

9 An automatic storage table space is being created with a value
for initial size that does not result in an equal distribution
of container space. As a result, a higher value is being used
but this value is larger than the maximum size specified.

10 A DMS table space enabled for auto-resize has not reached its
maximum size but one of the file systems on which the
containers exists is full and the container cannot grow.

11 A DMS table space enabled for auto-resize has not reached its
maximum size and the file systems on which the table space
resides are not full. However, a container operation (or a
subsequent rebalance) is in progress and the auto-resize
capability is suspended until it is complete.

12 A table space with the auto-resize feature enabled that is
managed by a database, or automatic storage, cannot increase in
size because the table space is in a WRITE SUSPEND state.

User response:

Perform the action corresponding to the cause of the error:

1 Either switch to a DMS TABLESPACE or recreate the SMS
TABLESPACE with more directories (PATHs) such that: (number of
directories) >= (max tablesize / maxfilesize). Note that
maximum file size is operating system dependent.

2 Add new container(s) to the DMS table space and try the
operation again, after the rebalancer has made the new pages
available for use.

3 Wait for the rebalancer to finish.

4 Perform the redirected restore again to larger containers.

5 Perform the redirected restore again to larger containers.

6 Perform the rollforward again allowing add containers, or
perform a redirected restore to larger containers.

7 Resubmit the CREATE TABLESPACE statement, ensuring that the
table space has at least 5 usable extents.

8 Increase the maximum size for the table space.

9 Reduce the initial size or increase the maximum size for the
table space.

10 Add a new stripe set of containers to the table space. Existing
containers will no longer grow, only those new containers in
the last range of the table space are extended when an
automatic resize occurs.

11 Wait for the operation and subsequent rebalance to complete.

12 The table space must be removed from the WRITE SUSPEND state
before new pages can be allocated.

sqlcode: -289

sqlstate: 57011

Cheers, Vijay
Nov 11 '10 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: Marcin Dobrucki | last post by:
I've been having some problems with a parse error that I can't figure out (PHP 4.3.11 on Solaris9). Sample code: <?php // getting strange parse errors on this class A { var $value; function...
3
by: N. Graves | last post by:
Hello, I don't understand this error message." Error accessing File. Network Connection may have been lost." I'm not using any network connection for the database. In the VBA editor is goes...
3
by: mrwoopey | last post by:
Hi, I am using the example "Authenticate against the Active Directory by Using Forms Authentication and Visual Basic .NET": http://support.microsoft.com/default.aspx?scid=KB;EN-US;326340 ...
0
by: Gianni Nitti | last post by:
If I set in web.config this: <compilation defaultLanguage="vb" debug="false"/> I receive this error: "Compiler Error Message: BC30560: 'barratop_ascx' is ambiguous in the namespace '_ASP'....
11
by: MLH | last post by:
Private Sub ButtonP_Click() On Error GoTo Err_ButtonP_Click Dim ThisForm As String ThisForm = Me.Name Exit_ButtonP_Click: Exit Sub Err_ButtonP_Click: Dim r As String, k As String, Message3...
2
by: Praveen Chandra | last post by:
Hi, I am trying to build a static library, while building the library i am getting the following error: fatal error C1189: #error : "No sstream/strstream implementation" Following is the...
4
by: rukkie | last post by:
Hi, I have some problems with a PHP reference in a <SCRIPTtag, but only with the Internet Explorer, which gives a "Error on page" message in the Status Bar. The code is as follows : <script>...
3
by: sachinv1821 | last post by:
hi , i am Getting this Error fatal error C1189: #error : "eh.h is only for C++!" my Problem is i am Having C++ librabry and Appropriate .h file i want to Access Them is .c File Files..... to Be...
2
by: RAG2007 | last post by:
Hi, I'm running an ADP with SQL Server as back end. On a main form, my subform is coming up blank. When I was running as an mdb with no back end I didn't have this problem. I get an error "Syntax...
3
by: Christina Brook | last post by:
I am fairly new at this and I am I am receiving this error code: Parse error: syntax error, unexpected T_STRING in /home/brooks/christinalbrooks-www/index.html on line 1 for this code: <?xml...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.