如何获得代理ID [英] how to get agent id
问题描述
你好，
当我连接到数据库并且运行一些sql时，我怎样才能检索代理ID？
我可以做点什么
db2连接数据库1
agent_id = db2" select * from abc"
hello,
How can i retreive agent id in return when i connect to database and
run some sql?
can i do something like
db2 connect to database1
agent_id = db2 "select * from abc"
推荐答案
crazy_jutt写道：
crazy_jutt wrote:
hello，
当我连接到数据库时，如何回复代理ID以及
运行一些sql？
我可以做类似的事情
db2连接数据库1
agent_id = db2" select * from abc"
hello,
How can i retreive agent id in return when i connect to database and
run some sql?
can i do something like
db2 connect to database1
agent_id = db2 "select * from abc"
您可以编写一个不带隔离的UDF来调用C函数getpid。并且
返回其结果。根据您的平台，您可能还需要线程ID
。
但真正的问题是：你想用这个号码做什么？ ？
-
Knut Stolze
DB2信息集成开发
IBM德国
我正在使用unix管道加载管道
有时加载失败并且导出仍然继续将数据推入管道
i想要加载失败时杀死导出，反之亦然
Knut Stolze写道：
I am doing load pipe using unix pipes
sometime load fails and export still keep on pushing data into pipe
i want to kill that export when load fails and vise versa
Knut Stolze wrote:
crazy_jutt写道：
crazy_jutt wrote:
你好，
当我连接到数据库并且运行某些sql时，我怎样才能检索代理ID？
我可以做点什么
db2连接数据库1
agent_id = db2" select * from abc" ;
hello,
How can i retreive agent id in return when i connect to database and
run some sql?
can i do something like
db2 connect to database1
agent_id = db2 "select * from abc"
您可以编写一个不带隔离的UDF来调用C函数getpid并且
返回其结果。根据您的平台，您可能还需要线程ID
。
但真正的问题是：你想用这个号码做什么？ ？
-
Knut Stolze
DB2信息集成开发
IBM德国
You could write a not fenced UDF that invokes the C function "getpid" and
return its result. Depending on your platform, you may need the thread-id
as well.
But the real question is: what do you want to do with this number?
--
Knut Stolze
DB2 Information Integration Development
IBM Germany
如下所示：
SELECT
APPL.AGENT_ID
FROM
TABLE（SNAPSHOT_APPL_INFO（''<你的数据库名称>''， - 1））AS APPL
WHERE
APPL.APPL_ID =（VALUES APPLICATION_ID（））;
和扩展名
BEGIN ATOMIC
DECLARE AGNT BIGINT; -
SET AGNT =
（SELECT
APPL.AGENT_ID
FROM
TABLE（SNAPSHOT_APPL_INFO（''CSE1DV00''， - 1））AS APPL
WHERE
APPL.APPL_ID =（VALUES APPLICATION_ID（）））; -
结束;
HTH，
- 杰夫
crazy_jutt写道：
How about something like:
SELECT
APPL.AGENT_ID
FROM
TABLE (SNAPSHOT_APPL_INFO(''<YOUR DB NAME>'',-1)) AS APPL
WHERE
APPL.APPL_ID = (VALUES APPLICATION_ID());
and by extension
BEGIN ATOMIC
DECLARE AGNT BIGINT;--
SET AGNT =
(SELECT
APPL.AGENT_ID
FROM
TABLE (SNAPSHOT_APPL_INFO(''CSE1DV00'',-1)) AS APPL
WHERE
APPL.APPL_ID = (VALUES APPLICATION_ID()));--
END;
HTH,
--Jeff
crazy_jutt wrote:
hello，
当我连接到数据库时，如何回复代理ID以及
运行一些sql？
我可以做点什么
db2连接数据库1
agent_id = db2" select *来自abc
hello,
How can i retreive agent id in return when i connect to database and
run some sql?
can i do something like
db2 connect to database1
agent_id = db2 "select * from abc"
这篇关于如何获得代理ID的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
