linux db2删除表字段命令,DB2 的表在删除字段后 表能挂起 需要执行 reorg命令

DB2 的表在删除字段后 表会挂起 需要执行 reorg命令

DB2 的表在删除字段后 表会挂起 需要执行 reorg命令

步骤如下:

通过ssh 登陆到 192.168.1.74 数据库所在服务器

工具: Xshell 5

连接之后：

引用

Connecting to 192.168.1.74:22...

Connection established.

db2 安装的目录在

/opt/ibm/db2/V11.1/

进入bin

cd bin

命令

./db2 list db directory

引用

System Database Directory

Number of entries in the directory = 2

Database 1 entry:

Database alias                       = MPOS

Database name                        = MPOS

Local database directory             = /home/db2inst1

Database release level               = 14.00

Comment                              =

Directory entry type                 = Indirect

Catalog database partition number    = 0

Alternate server hostname            =

Alternate server port number         =

Database 2 entry:

Database alias                       = IBBDKUSR

Database name                        = IBBDKUSR

Local database directory             = /home/db2inst1

Database release level               = 14.00

Comment                              =

Directory entry type                 = Indirect

Catalog database partition number    = 0

Alternate server hostname            =

Alternate server port number         =

先连接上db2：

./db2 connect to IBBDKUSR user mpos using JYCDB2

引用

Database Connection Information

Database server        = DB2/LINUXX8664 11.1.1.1

SQL authorization ID   = MPOS

Local database alias   = IBBDKUSR

再执行 表整理

./db2 reorg table withholding_test.merchant

引用

[mpos@localhost bin]$ ./db2 reorg table withholding_test.merchant;

DB20000I  The REORG command completed successfully.