Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    28

    Unhappy Unanswered: How To Load A Table Partition With Sysrec Syspunch Unload External

    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

  2. #2
    Join Date
    Jan 2005
    Posts
    191
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •