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屋！