Sunday, October 5, 2008

LUWID to IP Address conversion

Often it is required to find the server from which a distributed query comes from. In those cases, find the LUWID from DB2 MSTR: e.g.,

STC13507 DSNL032I +DB2P DSNLZDJN DRDA EXCEPTION CONDITION IN 324
REQUEST FROM REQUESTOR LOCATION=10.130.11.23 FOR THREAD WITH
LUWID=GA820B17.O412.0F9017030439=152303
REASON=00D35601

In the above example, the LUWID is GA820B17. To convert this to a IP address, start from the 2nd character and convert as follows:
Decimal (A) = 10
Decimal (82) = 130
Decimal (0B) = 11
Decimal (17) = 23
So the IP address is 10.130.11.23.

4 comments:

Anonymous said...

YEah, it's exactly what I'm looking for.

BTW IBM docs are useless about this subject...

Anonymous said...

Thanks, this is just what I needed today to find a server.

Anonymous said...

Check this link
https://www-304.ibm.com/support/docview.wss?uid=swg21055269

Kumaresh T said...

Thanks for the IBM link (https://www-304.ibm.com/support/docview.wss?uid=swg21055269). It's good that IBM has published this info (Modified date: 2008-12-30). When I was looking for this info (2008-10-05), I couldn't find it.

Thanks,
Aji