Export large table to Flat file

[sskrish]

Hi,

I am using DB2 UDB v 8.1 on AIX. I have a table that has around 10 million records and I want to export the data in this table to a flat file on AIX. I get an error message SQL03003 saying the output file cannot be closed. Below are the parameters that I have in my export statement.

<<export to ${CURR_RUN_DIR}${JOBNAME}.${CALLED_SCRIPT}.file.del of del modified by coldel| chardel< messages ${CURR_RUN_DIR}${JOBNAME}.${CALLED_SCRIPT}.load_msg \ select_statement...>

Can you please let me know how I can do an export with this volume? The record length is around 100.

Regards,
Ram.

 

[Dagon]

I presume your script works if you export a smaller number of records ? If so, it could be that you've run out of space on the file system. Try running the job and monitor the disk usage with a &quot;df -k&quot; to see if it is running out of space.

Alternatively, you could have exceeded the maximum size allowed for files on that file system. There is a setting on UNIX which determines this. I'm not a UNIX admin person, so I can't remember what it is but someone on the AIX forum ought to be able to tell you.

You could probably determine this if this is happening by monitoring the size of the output file with an &quot;ls -l&quot;. If it falls over just after reaching 2 gig or something, then that is probably the reason.

 

[sathyarams]

Or maybe, you have a userlimit set

issue ulimit -a from the command line

file(blocks) is the portion of the output you will be interested in


For db2 resoruces visit

http://www.db2click.com

More DB2 questions answered at

http://www.dbforums.com/f8

 

[udbeeedba]

What does

nofiles(descriptors) 2000

in the ulimit -a output stand for?

Is this the one that needs to be increased when the db cfg parm MAXFILOP is increased?