Solved

DB2MOVE - EXPORT causes error when LOB file reaches 4GB

Posted on 2008-10-14
22
2,239 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Certified OpenStack Administrator Course

We just refreshed our COA course based on the Newton exam.  With 14 labs, this course goes over the different OpenStack services that are part of the certification: Dashboard, Identity Service, Image Service, Networking, Compute, Object Storage, Block Storage, and Orchestration.

 
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

Interactive Way of Training for the AWS CSA Exam

An interactive way of learning that will help you visualize core concepts so that you can be more effective when taking your AWS certification exam.  Built for students by a student to help them understand the concepts that they are being taught.

Question has a verified solution.

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

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 (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Suggested Courses

630 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