IBM Support

[Db2] 表の再編成 (REORG TABLE) 実行時に SQL2220W が返ることがある

Question & Answer


Question

空の表に REORG TABLE (表の再編成) を実行した際に、SQL2220W が返されるケースがあります。 原因と対処方法を教えてください。

<エラー・メッセージ>
$ db2 reorg table t1
SQL2220W コンプレッション・ディクショナリーは 1 つ以上のデータ・オブジェクトに対してビルドされませんでした。

[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"ARM Category":[{"code":"a8m500000008PlMAAU","label":"Data Movement-\u003EReorg \/ Runstats"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
30 April 2025

UID

swg22013724