SQL3022N  An SQL error "-20285" occurred while processing the SELECT string in 
the Action String parameter.

SQL20285N  The statement or command was not processed either because the table 
named "DB2INST1.T1_202203" has detached dependent tables or because an 
asynchronous partition detach operation on the table is not complete. Reason 
code = "2".  SQLSTATE=55057

根据解释：
Monitor the progress of the asynchronous partition detach task
by using the LIST UTILITIES command and wait for the
asynchronous partition detach task to complete. Then re-issue
the statement or command.

detach命令为异步方式进行,等待命令完成后再次操作http://www.cndba.cn/hbhe0316/article/116357http://www.cndba.cn/hbhe0316/article/116357

db2 connect to dbname
db2 list utilities
db2 -x "select DATAPARTITIONNAME from SYSCAT.datapartitions WHERE TABSCHEMA='DB2INST1' and TABNAME='T1'"

版权声明：本文为博主原创文章，未经博主允许不得转载。

DB2