Solved

DB2MOVE - EXPORT causes error when LOB file reaches 4GB

Posted on 2008-10-14
22
2,142 Views
Last Modified: 2012-05-05
Hello,

I am using the db2move command to export 2 tables from my database. (DB2 - Express C)

If i only have a small number of entries I do not have any problems but if I have many entries I get the following error:

################################################################################
SQL3104N The Export utility is beginning to export data to file "tab2.ixf".

SQL3015N An SQL error "-452" occurred during processing.

SQL0452N Unable to access the file referenced by host variable "13". Reason
code: "5". SQLSTATE=428A1

SQL3105N The Export utility has finished exporting "12742" rows.
################################################################################

This always seems to happen when the LOB file size reaches 4GB. The database is running on windows vista with a NTFS file system.

Any ideas would be most appreciated.

Thanks

MAC
0
Comment
Question by:mac-will
  • 11
  • 9
22 Comments
 
LVL 37

Expert Comment

by:momi_sabag
ID: 22712975
this code indicates permission problems which is very odd
do you have lob values in all your records or only in some of them ? (and other records contains null)
0
 
LVL 8

Author Comment

by:mac-will
ID: 22713359
Yes, only some of the records contain LOB values and others are null.

Is this the problem?  What would I do in this case?

Thanks

MAC
0
 
LVL 8

Author Comment

by:mac-will
ID: 22722806
I've raised the point value.  I would really appreciate any help.

Thanks

MAC
0
Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

 
LVL 37

Expert Comment

by:momi_sabag
ID: 22728323
let's first identify the problem
can you try to export only the records that has no lob value?
0
 
LVL 8

Author Comment

by:mac-will
ID: 22734455
Ok I will try this. Please give me a day or so as I do not have access to this DB all the time.

Thanks

MAC
0
 
LVL 8

Author Comment

by:mac-will
ID: 22769424
Hello momi_sabaq,

I tried several tests as follows:

If I have a mix of records with LOB values or without LOB values I get the same error at a LOB file size of 4GB.

If I have all records having a LOB value I get the same error at a LOB file size of 4GB,

If I have only a few records that have LOB values and the LOB file size stays under 4GB I get no error.

One of my LOB fields is required so I did not try and export without any LOB files.

Any ideas?  I really need this to work.

Thanks,

MAC
0
 
LVL 37

Expert Comment

by:momi_sabag
ID: 22803836
which version of db2 are you using? maybe it was fixed in a fixpack since it sounds like a bug
0
 
LVL 8

Author Comment

by:mac-will
ID: 22814021
I am using DB2 Express-C with fixpack 2
0
 
LVL 37

Expert Comment

by:momi_sabag
ID: 22819712
v8 or v9?
0
 
LVL 8

Author Comment

by:mac-will
ID: 22822994
sorry,
V9.

Thanks,

MAC

0
 
LVL 37

Expert Comment

by:momi_sabag
ID: 22823079
well,
is it possible that you don't have a permission to write a file bigger than 4gb on your machine?
have you tried it with a user that belongs to the administrators group?
0
 
LVL 8

Author Comment

by:mac-will
ID: 22830396
I don't think that is possible.  I am running this command as an Administrator so I don't know.  
I had asked the same question on the IBM forum and was directed to IBM document "JR30345" as a possible reason, but as of now I am still unable to access this document.

0
 
LVL 37

Expert Comment

by:momi_sabag
ID: 22830614
where is this document located?
0
 
LVL 8

Author Comment

by:mac-will
ID: 22833345
I was told to go to the IBM website (www.ibm.com) and search for it.
0
 
LVL 37

Expert Comment

by:momi_sabag
ID: 22838767
0
 
LVL 8

Author Comment

by:mac-will
ID: 22875701
Hello momi_sabaq,

When I navigate to that link I get a support sign-in page.  What do I sign in / register with?

Thanks

MAC
0
 
LVL 8

Author Comment

by:mac-will
ID: 22875717
Sorry, I should have mentioned I've already signed in to the IBM main site my problem is with the entitled resources sign in.

Thanks
0
 
LVL 37

Expert Comment

by:momi_sabag
ID: 22875783
i just registered using my email address and it worked
just try to sign in again with your ibm account
0
 
LVL 8

Author Comment

by:mac-will
ID: 22888541
I still can't access it.  Anyway you could email me the file?

mac_will01@hotmail.com
0
 
LVL 37

Expert Comment

by:momi_sabag
ID: 22905972
it seems that this is not open for the public
i suggest you contact ibm
sorry for the confustion
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 23116114
PAQed with points refunded (500)

Computer101
EE Admin
0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
OPENQUERY syntax errors (not recognizing CROSS APPLY) 17 598
db2 connect on mac 3 522
How to create a stored procedure in AS400 1 98
creating materialized view in ibm i series 5 80
November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.

805 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question