IBM DB2 SQL 오류 SQLSTATE=57016

For example,

$ db2 "select count(*) from S1.T1"

1
-----------
SQL0668N  Operation not allowed for reason code "1" on table
"S1.T1".  SQLSTATE=57016

SQL0668N  Operation not allowed for reason code "1" on table "S1.T1".

DB2 REORG가 필요한 상황

REORG TABLE S1.T1

https://www.ibm.com/support/pages/how-identify-what-columns-are-related-constraint-error-sql3603n

Table reorganization

Written by dukgun.com