Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

For a table T in schema S, how do I use the unload command to export T data into a IXF file? The IBM DB2 documentation isn't very helpful for this simple case.

I am trying to compare performance between the export command and the unload command. This is on DB2 9.7 for AIX

share|improve this question
up vote 1 down vote accepted

Ah ok.

If you are referring to the UNLOAD command, that is only available on DB2 for z/OS. DB2 LUW does not have an UNLOAD command....except if you purchase IBM's separate product Optim High Performance Unload. (I am assuming you are wishing to use that?)

Optim High Performance Unload uses the db2hpu command. And though we do not use the tool where I work, it appears that the syntax you are after is the following:

db2hpu -t 'S.T' -d <database-name> -format ixf -m 'filesystem/messages.MSGS' -o 'filesystem/myfile.IXF'
share|improve this answer
I edited my post. Basically I already use the export command, I want to try an equivalent unload command to compare performance – Gabriel R. Dec 21 '12 at 14:24

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.