how to get agent id

udbadmin@gmail.com · *nix forums beginner Joined: 16 Nov 2005 Posts: 8

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"

Knut Stolze · *nix forums Guru Joined: 28 Jul 2005 Posts: 755

crazy_jutt wrote:

jagdip@gmail.com · *nix forums beginner Joined: 23 Jun 2005 Posts: 25

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:

jefftyzzer · *nix forums beginner Joined: 27 Jun 2006 Posts: 12

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:

udbadmin@gmail.com · *nix forums beginner Joined: 16 Nov 2005 Posts: 8

how can i use this in dynamic SQL ?

jefftyzzer wrote:

Serge Rielau · *nix forums Guru Joined: 29 Apr 2005 Posts: 1583

jefftyzzer wrote:

jefftyzzer · *nix forums beginner Joined: 27 Jun 2006 Posts: 12

Doh! Nothing speaks against it--I just like to waste keystrokes Smile

.
Good catch.

-- Jeff

Serge Rielau wrote:

udbadmin@gmail.com · *nix forums beginner Joined: 16 Nov 2005 Posts: 8

thanks guys
i got it

here it what i did

db2 -x "SELECT APPL.AGENT_ID FROM TABLE(SNAPSHOT_APPL_INFO('PROD1',-2))
AS APPL WHERE APPL.APPL_ID = (VALUES APPLICATION_ID())" | read agent_id
echo ${agent_id}

jefftyzzer wrote:

udbadmin@gmail.com · *nix forums beginner Joined: 16 Nov 2005 Posts: 8

are there more functions like this
i know there must not be function like AGENT_ID() otherwise you guys
must have mentioned but i am curious if there are more functions like
this which could be useful

crazy_jutt wrote:

jefftyzzer · *nix forums beginner Joined: 27 Jun 2006 Posts: 12

First thing: as Serge pointed out, you don't need "= VALUES(...", just
call the function directly as he illustrated--my mistake. As to your
question, I wouldn't say there are many functions like that, but there
is a lot of information available in snapshot table functions like
SNAPSHOT_APPL and SNAPSHOT_APPL_INFO.

--Jeff

crazy_jutt wrote:

Gert van der Kooij · *nix forums Guru Wannabe Joined: 27 May 2005 Posts: 267

In article <1153321751.452515.151670@i3g2000cwc.googlegroups.com>,
udbadmin@gmail.com says...

Google