继续请教,关于"Table space access is not allowed."(已解决了,谢谢)
在table 中插入一个数据,返回以下出错,请问应该怎样解决?SQL0290NTable space access is not allowed.
备份后,解决问题了,赫赫,谢谢各位
[ 本帖最后由 smallpig815 于 2007-12-3 10:21 编辑 ] SQL0290NTable space access is not allowed.SQLSTATE=55039
SQL0290NTable space access is not allowed.
Explanation:
A process attempted to access a table space which is in an
invalid state for which the intended access is not allowed.
o If the table space is in a quiesced state, only processes
which also hold the table space in a quiesced state are
allowed access to the table space.
o If the table space is in any other state, only the process
which is performing the action specified is allowed access to
the table space.
o A system or user temporary table space cannot be dropped
which contains active system or declared temporary tables.
o The SET CONTAINER api cannot be used to set the container
list unless the table space is in a "restore pending"
state.
User Response:
Possible actions include:
o If the table space is in a quiesced state, attempt to acquire
a quiesced share or quiesced update state on the table space.
Or, attempt to quiesce reset the table space.
o If the table space is in any other state, wait until the
table space has returned to normal state before attempting to
access the table space.
Refer to the Administration Guide for further information about
the table space states.
sqlcode : -290
sqlstate :55039 注意tablespace包含的容器是否赋予了用户的访问权限 一直都是用那一个用户进行insert的,访问权限应该没有问题吧 db2 list tablespaces show detail 看看表空间的state Tablespace ID = 2
Name = USERSPACE1
Type = System managed space
Contents = Any data
State = 0x0020
Detailed explanation:
Backup pending
出来了..应该就是Backup pending 的问题 那就backup database就ok了 请问怎样才能防止以后发生类似的情况呢
剧了解,应该没有做过LOAD或者修改DB的配置的 归档的数据库做过load，我想可能有人做过，或者改了参数重新启动了db A process attempted to access a table space which is in an
invalid state for which the intended access is not allowed
错误代码的解释很清楚。
页:
[1]
2