some arbitrary application ids in "db2 list applications"

Rahul B

Hi,

When i do a "db2 list applications", i get the required applications
with their ip addresses.

However, some of the application Ids are ip addresses while some
application Ids are arbitrary(like GA500A2B.K105.014AC7050331) and of
the form "GA500%'.

Can somebody explain what are these indifferent application ids?

Also, i want to find out the ip address of the machine is running
these applications(because some of the locks are being caused because
of that application id).

Thanks

Rahul

Aug 28 '07 #1

Rahul B

On Aug 28, 10:32 am, Rahul B <rahul.babb...@gmail.comwrote:

Hi,

When i do a "db2 list applications", i get the required applications
with their ip addresses.

However, some of the application Ids are ip addresses while some
application Ids are arbitrary(like GA500A2B.K105.014AC7050331) and of
the form "GA500%'.

Can somebody explain what are these indifferent application ids?

Also, i want to find out the ip address of the machine is running
these applications(because some of the locks are being caused because
of that application id).

Thanks

Rahul

Hi,

I have found out the cause of it.
It seems we were accessing the application through some alias given to
the machine.
Further,
"db2 get snapshot for application applid <application_id>" was also
helpful in finding the actual ip address.
Rahul

Aug 28 '07 #2

Knut Stolze

Rahul B wrote:

Hi,

When i do a "db2 list applications", i get the required applications
with their ip addresses.

However, some of the application Ids are ip addresses while some
application Ids are arbitrary(like GA500A2B.K105.014AC7050331) and of
the form "GA500%'.

Can somebody explain what are these indifferent application ids?

The DRDA protocol does not allow application IDs to start with a digit
(0-9). Therefore, all digits in the first character are mapped to the
letters G thru P.

Also, i want to find out the ip address of the machine is running
these applications(because some of the locks are being caused because
of that application id).

You may want to have a look here:
http://www.ibm.com/developerworks/db...ein/index.html

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany

Aug 28 '07 #3

Rahul B

On Aug 28, 10:21 pm, Knut Stolze <sto...@de.ibm.comwrote:

Rahul B wrote:

Hi,

When i do a "db2 list applications", i get the required applications
with their ip addresses.

However, some of the application Ids are ip addresses while some
application Ids are arbitrary(like GA500A2B.K105.014AC7050331) and of
the form "GA500%'.

Can somebody explain what are these indifferent application ids?

The DRDA protocol does not allow application IDs to start with a digit
(0-9). Therefore, all digits in the first character are mapped to the
letters G thru P.

Also, i want to find out the ip address of the machine is running
these applications(because some of the locks are being caused because
of that application id).

You may want to have a look here:http://www.ibm.com/developerworks/db...le/dm-0402gree...

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany

Knut,

It is the problem only with some application ids, rest all application
ids showed correct ip addresses.

Rahul

Aug 29 '07 #4

Knut Stolze

Rahul B wrote:

On Aug 28, 10:21 pm, Knut Stolze <sto...@de.ibm.comwrote:

>Rahul B wrote:

Hi,

When i do a "db2 list applications", i get the required applications
with their ip addresses.

However, some of the application Ids are ip addresses while some
application Ids are arbitrary(like GA500A2B.K105.014AC7050331) and of
the form "GA500%'.

Can somebody explain what are these indifferent application ids?

The DRDA protocol does not allow application IDs to start with a digit
(0-9). Therefore, all digits in the first character are mapped to the
letters G thru P.

It is the problem only with some application ids, rest all application
ids showed correct ip addresses.

If the first digit (first 4 bits) is 0 thru 9, it is mapped to G thru P. If
the first 4 bits already represent a letter A thru F, then no such mapping
is necessary. Therefore, some IP addresses are already correct while some
have to be mapped back - depending on the first letter.

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany

Aug 29 '07 #5