DB2 SQL error: SQLCODE: -443, SQLSTATE: 38553,

SELECT * FROM SYSIBM.SYSDUMMY1,TABLE( SNAPSHOT_BP( 'OrDbName', -1 )) as SNAPSHOT_BP where BP_NAME='bpName'这个查询的时候出现的错误什么问题啊,而且有10台设备只有一台有这个错误07/13 15:03:53 [ERROR] [pigms.collectors.db.db2.DB2BufferPoolIndicator.collect...显示全部
SELECT * FROM SYSIBM.SYSDUMMY1,TABLE( SNAPSHOT_BP( 'OrDbName', -1 )) as SNAPSHOT_BP where BP_NAME='bpName'这个查询的时候出现的错误什么问题啊,而且有10台设备只有一台有这个错误
07/13 15:03:53 [ERROR] [pigms.collectors.db.db2.DB2BufferPoolIndicator.collect(Unknown Source)] DB2 SQL error: SQLCODE: -443, SQLSTATE: 38553, SQLERRMC: SYSPROC.SNAPSHOT_BP;SNAPSHOT_BP;SQL1427收起
参与12

查看其它 9 个回答alleachine的回答

alleachinealleachine技术经理胜科金仕达数据系统(中国)有限公司
没有见过。
Errors that are detected by the IBM supplied routines in the
SYSIBM or SYSPROC schemas and IBM supplied procedures in the
SYSFUN schema all return the SQLSTATE 38553.  The message text
portion of the message contains a message number that may be an
SQLCODE, (for example, SQL0572N), a DBA error message (for
example, DBA4747), or some other indication from the routine as
to what error was encountered. Note that if the message for the
message number would normally contain tokens, these token values
are only available in the db2diag.log file.

查日志看看。
证券 · 2011-07-14
浏览3099

回答者

alleachine
技术经理胜科金仕达数据系统(中国)有限公司
擅长领域: 数据库关系型数据库存储

alleachine 最近回答过的问题

回答状态

  • 发布时间:2011-07-14
  • 关注会员:2 人
  • 回答浏览:3099
  • X社区推广