Hi Guys :!

HOW TO LOAD A TABLE PARTITION WITH SYSREC SYSPUNCH UNLOAD EXTERNAL

This is my problem

We got a table in wich a partition is full.

We wanted to rebalancing cluster index keys but this failed

so we drop tablespace partitionned,re-create it with partition and partitionned index !!

But when we do the LOAD PHASE,the failure is in the same partition each time we launch it !!!

So is there a way of load a table partition by partition with a file sysrec issued from REORG UNLOAD EXTERNAL ??

Or can we LOAD ALL exept certains records specified by a WHEN or WHERE CONDITION ???

Thanks for your reply !!!!!!

This is an EMMERGENCY !!!!!

Please , Help ME ; - )))

Sidnet

Which version of DB2 (for zOS)?

I suspect the problem you are having is because the data is being reloaded with the specified free space parameters. As the partition was (almost) full it is probably that you now can't fit data plus free space into the partition.

The v7 and prior "correct" way of doing this is to
1) ALTER partitioning-index PART n VALUES(new-high-values)
2) REORG TABLESPACE

In V8 it depends on whether you you using table or index partitioning.

In your situation, I would
- recreate the original tablespace, table and partitioning keys, with both FREEPAGE and PCTFREE set to zero.
- reload your unloaded data
- alter partitioning keys, freepage and pctfree.
- reorg.

There are other things to investigate - eg converting to large partitions with DSSIZE but you can't do this with a reorg.

James Campbell