Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2314
  • 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
Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

 
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

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

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