免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 6727 | 回复: 5
打印 上一主题 下一主题

请教SQL2048N问题! [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2005-07-13 16:21 |只看该作者 |倒序浏览
本人在生产环境中做了数据库的全备份,然后在测试环境中进行恢复,可是恢复完成后,连接数据库报如下的错误,请问各位,是什么意思,如何解决呢?多谢了!!
SQL2048N  An error occurred while accessing object "SQL PROCEDURE FILES".
Reason code: "7".

论坛徽章:
0
2 [报告]
发表于 2005-07-13 17:38 |只看该作者

请教SQL2048N问题!

你可以看Message Reference Volume 2.pdf这本书,看SQL2048N这个错的相关处理提示

论坛徽章:
0
3 [报告]
发表于 2005-07-13 17:54 |只看该作者

请教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 wasencountered during a restore, the set table space container api may be used to modify the table space before resubmitting the utility command.

论坛徽章:
0
4 [报告]
发表于 2005-07-13 18:00 |只看该作者

请教SQL2048N问题!

楼上说的是这个,我贴出来吧

论坛徽章:
0
5 [报告]
发表于 2005-07-14 08:45 |只看该作者

请教SQL2048N问题!

具体的如何解决该问题呢?
有没有详细具体的解决步骤呢?

论坛徽章:
0
6 [报告]
发表于 2005-07-14 09:23 |只看该作者

请教SQL2048N问题!

有!我是这样解决的!sqllib/function/routine/sqlproc/目录里有个东东,应该是你的库名,把它改个名字吧!呵呵!
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP