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(Unknown Source)] DB2 SQL error: SQLCODE: -443, SQLSTATE: 38553, SQLERRMC: SYSPROC.SNAPSHOT_BP;SNAPSHOT_BP;SQL1427
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
10同行回答
还有, 看看另另一个error
$ db2 ? SQL1427
SQL1427N An instance attachment does not exist.
Explanation:
The application is not attached to an instance. The attempted
command/API cannot be executed unless there is an existing
instance attachment.
User Response:
If the error occurred when detaching from an instance, continue
processing. If the error occurred during the execution of any
other command, attach to an instance and reissue the failed
command.收起
$ db2 ? SQL1427
SQL1427N An instance attachment does not exist.
Explanation:
The application is not attached to an instance. The attempted
command/API cannot be executed unless there is an existing
instance attachment.
User Response:
If the error occurred when detaching from an instance, continue
processing. If the error occurred during the execution of any
other command, attach to an instance and reissue the failed
command.收起
浏览3815
db2 version?
snapshot table function may not be always reliable.
以前也遇到过类似的情况。
restart may help.
另外， 你是用的 instance ower id 吗？收起
snapshot table function may not be always reliable.
以前也遇到过类似的情况。
restart may help.
另外， 你是用的 instance ower id 吗？收起
浏览2942
没有见过。
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.
查日志看看。收起
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.
查日志看看。收起
浏览3068