Load Problem With MDC Table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

David Frankel - 27 Oct 2004 21:40 GMT

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.

Reply to this Message

Philip Nelson - 27 Oct 2004 23:38 GMT

> 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
[quoted text clipped - 6 lines]
>
> 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

Reply to this Message