DB2表空间已满,无法访问,状态为暂挂,备份数据库报错

 我来答
nedvedwoo
2013-07-18
知道答主
回答量:5
采纳率:0%
帮助的人:5.6万
展开全部
表空间可能处于脱机状态。尝试确定底层问题并进行更正。一些问题的
示例包括:未安装文件系统(可通过安装文件系统,然后将表空间开关
改变为联机来修正);已经删除了表空间文件(可以通过执行复原操作
来修正)。
表空间可能已停顿。使用 LIST TABLESPACES 来检查表空间的状态。使
用 QUIESCE RESET OR QUIESCE TERMINATE 来使表空间可用。注意,保
持停顿的用户标识可能需要执行 QUIESCE REST OR TERMINATE 操作。

应该是有其他进程再跑吧,看下表空间状态,如果表空间没有异常,那就terminate下应该就可以了
本回答被提问者和网友采纳
已赞过 已踩过<
你对这个回答的评价是?
评论 收起
可兴修mZ
2013-07-17 · 超过31用户采纳过TA的回答
知道答主
回答量:66
采纳率:0%
帮助的人:54.4万
展开全部
db2 ? sql2048N
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL1024N A database connection does not exist. SQLSTATE=08003
db2inst1@p550q:/db2_kgdb64/backup>db2 "? sql2048N"

SQL2048N An error occurred while accessing object "<object>".
Reason code: "<reason-code>".
Explanation:
An error occurred while accessing an object during the processing
of a database utility. The following is a list of reason codes:

1 An invalid object type is encountered.
2 A lock object operation failed. The lock wait may have reached
the lock timeout limit specified in the database configuration.
3 An unlock object operation failed during the processing of a
database utility.
4 Access to an object failed.
5 An object in the database is corrupted.
6 The object being accessed is a table space and either the
table space is in such a state that the operation is not allowed
or one or more containers of the table space is not available.
(LIST TABLESPACES will list the current table space state.)
7 A delete object operation failed.
8 Trying to load/quiesce into a table that is not defined on
this partition.
The utility stops processing.
User Response:
If a lock object operation failed, ensure the lock timeout limit
in the database configuration is adequate and resubmit the
utility command. You may also consider using the QUIESCE command
to bring the database to a quiesced state to ensure access.
If the error was encountered during backup, take corrective
action to recover the database and resubmit the utility
command.
If the error was encountered during restore or load recovery,
ensure the backup or copy image is correct and resubmit the
utility command.
If the object is a table space and the error was encountered
during a restore, the set table space container api may be used
to modify the table space before resubmitting the utility
command.

先解决表空间状态问题,再执行备份。
已赞过 已踩过<
你对这个回答的评价是?
评论 收起
推荐律师服务: 若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询

为你推荐:

下载百度知道APP,抢鲜体验
使用百度知道APP,立即抢鲜体验。你的手机镜头里或许有别人想知道的答案。
扫描二维码下载
×

类别

我们会通过消息、邮箱等方式尽快将举报结果通知您。

说明

0/200

提交
取消

辅 助

模 式