db2 中的 REORG 命令 [英] REORG command in db2

问题描述

所以我一直在修改 QMF 中的一个表.经过 3 次更改后，我相信该表已进入挂起重组状态，因此我无法另外更改它.我在这个假设中正确吗?如果是这样，这有什么影响，为了解决这个问题，我可以简单地重新组织表格并继续改变它吗?如果是这样，重组表的语法是什么样的?我试过REORG TABLE PIDJBIP.TABLE_NAME_T并收到错误:

So I have been altering a table in QMF. After 3 alters I believe the table has gone into a pending reorg state so that I cannot alter it additionally. Am I correct in this assumption? If so what implications does this have and to get around it can I simply reorganize the table and continue altering it? If so, what does the syntax look like for reorganizing a table? I tried REORG TABLE PIDJBIP.TABLE_NAME_T and receive the error:

在REORG TABLE"之后发现了一个意外的标记PIDJBIP".预期的标记可能包括:JOIN".SQL 状态 = 42601.

an unexpected token "PIDJBIP" was found following "REORG TABLE". Expected tokens may include: "JOIN". SQL state = 42601.

我没有从 IBM 页面中获得关于此主题的太多帮助.

I haven't gotten much help out of the IBM pages regarding this subject.

推荐答案

REORG 不是 SQL 语句，因此不能使用 SQL 接口(如 QMF)发出.您将需要使用 DB2 命令行处理器来运行它.

REORG is not an SQL statement, so it cannot be issued using a SQL interface (such as QMF). You will need to run it using the DB2 Command Line Processor.

或者，您可以使用管理存储过程，可以通过 QMF 调用:

Alternatively, you might use the administrative stored procedure, which you could call via QMF:

call sysproc.admin_cmd('reorg table PIDJBIP.TABLE_NAME_T')

这篇关于db2 中的 REORG 命令的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！