DB2不允许访问表空间解决.docxVIP

1. DB2进行异常操作后，如命令未执行完将其中断，或对DB2表进行load/restore操作后，DB2将只能select，不能update,altet,insert，报错如下：? ? ?DB2?SQL Error: SQLCODE=-290, SQLSTATE=55039, SQLERRMC=null, DRIVER=3.50.152消息：?不允许访问表空间。. SQLCODE=-290, SQLSTATE=55039, DRIVER=3.50.152?2. 可查看DB2的表空间状态，确认状态后进行相应的处理解决???????$ db2 list tablespace show detail? ? ??????Tablespaces?for?Current?DatabaseTablespace?ID?=?0Name?=?SYSCATSPACEType?=?System?managed?spaceContents?=?Any?dataState?=?0x0000Detailed?explanation:NormalTotal?pages?=?2519Useable?pages?=?2519Used?pages?=?2519Free?pages?=?Not?applicableHigh?water?mark?(pages)?=?Not?applicablePage?size?(bytes)?=?4096Extent?size?(pages)?=?32Prefetch?size?(pages)?=?32Number?of?containers?=?1Tablespace?ID?=?1Name?=?TEMPSPACE1Type?=?System?managed?spaceContents?=?System?Temporary?dataState?=?0x0000Detailed?explanation:NormalTotal?pages?=?1Useable?pages?=?1Used?pages?=?1Free?pages?=?Not?applicableHigh?water?mark?(pages)?=?Not?applicablePage?size?(bytes)?=?4096Extent?size?(pages)?=?32Prefetch?size?(pages)?=?32Number?of?containers?=?1Tablespace?ID?=?2Name?=?USERSPACE1Type?=?System?managed?spaceContents?=?Any?dataState?=?0x0004?这个代码意义就是“停顿的独占”，正常状态为0x0000，非0就是有问题，都可以用下面方法解决。Detailed?explanation:Quiesced:?EXCLUSIVETotal?pages?=?687Useable?pages?=?687Used?pages?=?687Free?pages?=?Not?applicableHigh?water?mark?(pages)?=?Not?applicablePage?size?(bytes)?=?4096Extent?size?(pages)?=?32Prefetch?size?(pages)?=?32Number?of?containers?=?1Number?of?quiescers?=?1?注意下面几行Quiescer?1:Tablespace?ID?=?2Object?ID?=?50?“object?id是造成死锁表的id”3. 若处于0X0004“停顿的独占”，可执行?db2?=?select?tabname?from?syscat.tables?where?tableid=50?通过所住的id号找出是哪个表TABNAME?SYSINDEXEXTENSIONPARMS?TEST?就是这个表?2?record(s)?selected.db2?=?quiesce?tablespaces?for?table?test?reset?执行该命令清除错误的状态DB20000I?The?QUIESCE?TABLESPACES?command?completed?successfully.? ? ?4. 若处于0X0020“备份暂挂”，对整个数据库进行backup后即可将其恢复正常db2 backup db enms tablespace(userspace1) online include logs（需等待较长时间，然后会echo出备份的时间戳）