×

Loading...
Ad by
  • 推荐 OXIO 加拿大高速网络，最低月费仅$40. 使用推荐码 RCR37MB 可获得一个月的免费服务
Ad by
  • 推荐 OXIO 加拿大高速网络，最低月费仅$40. 使用推荐码 RCR37MB 可获得一个月的免费服务

@Florida

DB2 on UNIX: How to improve the performance of MERGE

streetoflondon(streetoflondon)
I need to MERGE a small table S(0.25M records) to a huge table T(39M records), they join on the composite primary key, both tables have expactly same columns of the composite primary key.

But the MERGE is aborted with "File system full" error message, the reason is because of the table-scans of the huge table and it uses lots of temporary space.

The huge table is a partitioned table, the data will be merged to the last partition of the huge table.

How can I avoid the table-scan of the huge table? Should I drop the Primary Key of the small table?

Any suggestion or idea are welcome!
(#7994935@0)
Last Updated: 2013-1-12
This post has been archived. It cannot be replied.
Report

Replies, comments and Discussions:

  • 工作学习 / 学科技术讨论 / DB2 on UNIX: How to improve the performance of MERGE -streetoflondon(streetoflondon); 2013-1-12 {601} (#7994935@0)
    I need to MERGE a small table S(0.25M records) to a huge table T(39M records), they join on the composite primary key, both tables have expactly same columns of the composite primary key.

    But the MERGE is aborted with "File system full" error message, the reason is because of the table-scans of the huge table and it uses lots of temporary space.

    The huge table is a partitioned table, the data will be merged to the last partition of the huge table.

    How can I avoid the table-scan of the huge table? Should I drop the Primary Key of the small table?

    Any suggestion or idea are welcome!
    • If you have partitioned field in condition, it should avoid scan whole table. -deep_blue(BLUE); 2013-1-14 (#7998133@0)
      • Thanks! The partition fields are in the condition, but the target table(huge table) is still scaned. I removed the ORDER BY from SELECT statement for source table, index access to target table is applied. Just don't know why. -streetoflondon(streetoflondon); 2013-1-17 (#8005656@0)
        • Then you may need give more spare space to the database server. -deep_blue(BLUE); 2013-1-18 (#8005876@0)
          • Good. It's great remind. -streetoflondon(streetoflondon); 2013-1-21 (#8010709@0)

More Topics

  • 看大家讨论日语，俺也正在认真学习。其实语言问题应该是很快也很容易就解决的，可能比自动驾驶来的还快。TREK里面，全宇宙的人都在大脑里安装了UNIVERSAL TRANSLATOR，外星人之间相互交流无障碍。废话少说，看视频。。。加上个MIC和耳机，不同国家的人就可以无障碍交流。
  • 肉脸真有搞 IT 的？Linux 把俄国中国伊朗踢出去了好像肉脸 IT 没啥感觉似的
  • 请问web developer和software developer技术上有什么区别？
  • Elon Musk 带着川普总统奔向火星了。
  • 扔硬币的实验研究
    • 枫下论坛主坛 /  工作学习 /  学科技术讨论