converting appl id to ip address in partitioned environment

azs0309 · #1 (**permalink**) 02-18-09, 09:41

Hi Folks,
does anyone has any idea how to convert this application id into ip address,protocol used is TCP/IP only

Application ID = 003C2FF0.CF6C.F3C2F9C6C1F0

The problem is that it starts with 00 and its conversion into decimal is also 00, so I do not know any ip address starting with 00 , so m a bit sceptical.

I think it has something to do with partitioning.

Thanks in advance
Ajay

nick.ncs · #2 (**permalink**) 02-18-09, 10:43

try

Code:

select inbound_comm_address from table(snapshot_appl('sample',-1)) as t

where sample is the name of your database.....

However there is one drawback.... for local connections it'll display LOCAL.Instancename instead of I.P.

stolze · #3 (**permalink**) 02-18-09, 10:48

How did you get this application ID (which SQL statement)?

azs0309 · #4 (**permalink**) 02-19-09, 01:02

Stolze,

I got it by snapshot for application agnetid

And the table snapshot function is not working as well...

stolze · #5 (**permalink**) 02-19-09, 01:15

Could you be a bit more specific and show us the SQL statements and also demonstrate what you mean by "not working"? The exact output would be helpful. And as usual, please state the DB2 version and platform you are using.

nick.ncs · #6 (**permalink**) 02-19-09, 01:39

Quote:

Originally Posted by stolze

And as usual, please state the DB2 version and platform you are using.

This seems to be a pretty common feature now.

Can the Admin do something like compulsorily ask the user to input the following fields for every new post -
DB2 Version
OS Version

This would definitely stop half the to and fro in the posts....

azs0309 · #7 (**permalink**) 02-19-09, 03:34

yuup nick...

my mistake...
DB2 version is 8.1 fix pak 14 and OS is AIX..

when I used table functions it started giving me ADM11000E DB2 is unable to create or attach to the memory segment used for fenced routine communications.
Error

nick.ncs · #8 (**permalink**) 02-19-09, 09:07

Quote:

Originally Posted by stolze

Could you be a bit more specific and show us the SQL statements and also demonstrate what you mean by "not working"? The exact output would be helpful.

Please state this.... maybe we can help you out then.

db2girl · #9 (**permalink**) 02-25-09, 19:21

Re: ADM11000E

Some built-in functions are fenced. The error indicates that db2 was unable to attach to the segment used for fenced mode communications. With 32-bit architecture on AIX, db shared memory will be attached in a set of contiguous segments and can occupy up to 8 segments. The location of fenced mode segment is not at a fixed address and it's determined based on your setting (this is done to allow more room for db shared memory set). You'll get this error if the segment is already in use. To resolve the error, db shared memory allocation needs to be reduced (ie. reduce bufferpools). This limitation goes away with 64-bit.

Internet Services

Web Development

Digital Marketing

Consumer Tech