David Frankel wrote:
I have created an MDC table using UDB ESE v8.1 fixpack 6 on AIX 5.1.
The table is organized by 3 columns with a product of 100 * 3 * 5
values -- only 1500 values. When I try to use the load utility to
insert only 5000 rows of data, the load fails in the build phase with
an SQL03011C. I see messages in the diag log that the utility was
unable to obtain memory for the sortheap. However, I see no evidence
of memory constraint on the system when I do an lsps -a or a vmstat. I
have changed the ulimit for data to unlimited.
Any ideas? Thanks in advance for any help on this.
David,
Are you sure that it is not your UTIL_HEAP_SZ which needs to be increased ?
There were some problems pre-Stinger with the algorithm for finding where
to put a row of data, and if you can you'd be advised to put FP7a on.
Handy Hint : I've found that the fastest way to load MDC tables, if you can
spare the disk space, is to create a non-MDC version, load that then load
the MDC from a cursor opened on the non-MDC (with an ORDER BY dimensions
clause).
Another Hint : try to ensure that the extent size you choose will result in
mostly full extents for the cells. Otherwise you could end up wasting a
lot of space, and actually making your performance worse.
All this, and more, will be covered in a one day seminar on DB2 V8 and
Beyond which I plan to be teaching on 16th November in Birmingham (UK).
HTH
Phil