Solved

DB2MOVE - EXPORT causes error when LOB file reaches 4GB

Posted on 2008-10-14
22
2,116 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
 
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
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

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…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

705 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now