“SQL1024N数据库连接不存在”使用db2GetSnapshotSizeData和db2gGetSnapshot时 [英] "SQL1024N A database connection does not exist" when using db2GetSnapshotSizeData and db2gGetSnapshot

问题描述

大家好，

我写了一个应用程序，使用快照监视器获取快照

API（db2gGetSnapshot和db2GetSnapshotSize），偶尔这些

方法失败，我得到SQL1024N错误（数据库连接不存在
存在.SQLSTATE = 08003）。

应用程序附加到db2实例初始化，以及

是安全的，我还确保了DB2INSTANCE环境

变量也已设置。


有没有人熟悉这个问题？


TIA

Yaron

Hi all,

I wrote an application that takes snapshots using the snapshot monitor
API (db2gGetSnapshot and db2GetSnapshotSize), every now and then these
methods fail and I get SQL1024N error (A database connection does not
exist. SQLSTATE=08003).
The application is attached to the db2 instance initialization, and to
be on the safe side, I also made sure that the DB2INSTANCE environment
variable is also set.

Does anybody familiar with this problem?

TIA
Yaron

推荐答案

Yaron，

指示iStoreResult属于结构的指示符
db2gGetSnapshotData反过来控制

db2GetSnapshot API强制执行的行为如果启用，管理器将在db2服务器中存储

调用的结果。

你可能想检查上面提到的指标是不是启用。

Yaron,
An indicator iStoreResult which belongs to structure
db2gGetSnapshotData which in turn controls the behaviour the
db2GetSnapshot API enforces the manager to store the results of the
call in the db2 server if enabled.
You might want to check if the mentioned indicator isn''t enabled.

我写了一个应用程序，使用快照监视器API（db2gGetSnapshot和db2GetSnapshotSize）来拍摄快照，时不时用这些方法失败，我得到SQL1024N错误（数据库连接不存在。 SQLSTATE = 08003）。
应用程序附加到db2实例初始化，为了安全起见，我还确保了DB2INSTANCE环境
变量也已设置。 />
有人熟悉这个问题吗？

TIA
Yaron

I wrote an application that takes snapshots using the snapshot monitor
API (db2gGetSnapshot and db2GetSnapshotSize), every now and then these
methods fail and I get SQL1024N error (A database connection does not
exist. SQLSTATE=08003).
The application is attached to the db2 instance initialization, and to
be on the safe side, I also made sure that the DB2INSTANCE environment
variable is also set.

Does anybody familiar with this problem?

TIA
Yaron

嗨Shyam。


标志总是设置为0，但它仍然会发生。


还有其他想法吗？

Hi Shyam.

The flag is always set to 0, but it still happends.

Any other ideas ?

有一个名为utilsnap.c的样本。在sqllib / samples / c"

目录中。我建议从这个样本开始。


问候，

Udo


-

Speedgain for DB2 - DB2 Monitor
http：// www.itgain.de/en/index.html

There''s a sample called "utilsnap.c" in the sqllib/samples/c"
directory. I suggest to start with this sample.

Regards,
Udo

--
Speedgain for DB2 - The DB2 Monitor
http://www.itgain.de/en/index.html

这篇关于“SQL1024N数据库连接不存在”使用db2GetSnapshotSizeData和db2gGetSnapshot时的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！