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.收起
浏览3850