标题: 继续请教,关于"Table space access is not allowed."(已解决了,谢谢) [打印本页] 作者: smallpig815 时间: 2007-09-28 11:48 标题: 继续请教,关于"Table space access is not allowed."(已解决了,谢谢) 在table 中插入一个数据,返回以下出错,请问应该怎样解决?
SQL0290N Table space access is not allowed.
备份后,解决问题了,赫赫,谢谢各位
[ 本帖最后由 smallpig815 于 2007-12-3 10:21 编辑 ]作者: smallpig815 时间: 2007-09-28 12:03
SQL0290N Table space access is not allowed. SQLSTATE=55039
SQL0290N Table 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作者: 我老婆黑社会 时间: 2007-09-28 13:09
注意tablespace包含的容器是否赋予了用户的访问权限作者: smallpig815 时间: 2007-09-28 13:48
一直都是用那一个用户进行insert的,访问权限应该没有问题吧作者: 我老婆黑社会 时间: 2007-09-28 16:07
db2 list tablespaces show detail 看看表空间的state作者: smallpig815 时间: 2007-09-28 16:23
Tablespace ID = 2
Name = USERSPACE1
Type = System managed space
Contents = Any data
State = 0x0020
Detailed explanation:
Backup pending
剧了解,应该没有做过LOAD或者修改DB的配置的作者: whiterain 时间: 2007-09-29 12:04
归档的数据库做过load，我想可能有人做过，或者改了参数重新启动了db作者: lizhuo 时间: 2007-09-29 14:03
A process attempted to access a table space which is in an
invalid state for which the intended access is not allowed
错误代码的解释很清楚。作者: dgjddk 时间: 2007-10-06 10:22
UP作者: anonyaniu 时间: 2007-11-13 20:03
情况如下，应该如何解决？
-bash-3.00$ db2 connect to test user db2inst1 using db2inst1
SQL0290N Table space access is not allowed. SQLSTATE=55039
-bash-3.00$ db2 backup database test
SQL1015N The database is in an inconsistent state. SQLSTATE=55025
-bash-3.00$ db2 list tablespaces show detail
SQL1024N A database connection does not exist. SQLSTATE=08003作者: lizhuo 时间: 2007-11-14 09:57
当数据库处于不一致状态，需要作崩溃恢复。连接数据库，自动做。然后备份数据库。
连接上数据库后才能看表空间的信息。作者: wangkai8 时间: 2007-11-15 09:22
restart db 一下。作者: psc2001 时间: 2007-11-17 14:27
backup pending 当然backup tablespace
除非db 需要 rollforward 否则可以考虑循环日志作者: huyuhui001 时间: 2007-11-23 22:36
