• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2377
  • Last Modified:

DB2MOVE - EXPORT causes error when LOB file reaches 4GB

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
mac-will
Asked:
mac-will
  • 11
  • 9
1 Solution
 
momi_sabagCommented:
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
 
mac-willAuthor Commented:
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
 
mac-willAuthor Commented:
I've raised the point value.  I would really appreciate any help.

Thanks

MAC
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
momi_sabagCommented:
let's first identify the problem
can you try to export only the records that has no lob value?
0
 
mac-willAuthor Commented:
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
 
mac-willAuthor Commented:
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
 
momi_sabagCommented:
which version of db2 are you using? maybe it was fixed in a fixpack since it sounds like a bug
0
 
mac-willAuthor Commented:
I am using DB2 Express-C with fixpack 2
0
 
momi_sabagCommented:
v8 or v9?
0
 
mac-willAuthor Commented:
sorry,
V9.

Thanks,

MAC

0
 
momi_sabagCommented:
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
 
mac-willAuthor Commented:
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
 
momi_sabagCommented:
where is this document located?
0
 
mac-willAuthor Commented:
I was told to go to the IBM website (www.ibm.com) and search for it.
0
 
momi_sabagCommented:
0
 
mac-willAuthor Commented:
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
 
mac-willAuthor Commented:
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
 
momi_sabagCommented:
i just registered using my email address and it worked
just try to sign in again with your ibm account
0
 
mac-willAuthor Commented:
I still can't access it.  Anyway you could email me the file?

mac_will01@hotmail.com
0
 
momi_sabagCommented:
it seems that this is not open for the public
i suggest you contact ibm
sorry for the confustion
0
 
Computer101Commented:
PAQed with points refunded (500)

Computer101
EE Admin
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 11
  • 9
Tackle projects and never again get stuck behind a technical roadblock.
Join Now