Get IP Address of connected DB2 client

When DB2 agent (db2bp process) makes a connection for your CONNECT request, it stores the IP address of the client in the application ID as shown below: $ db2 list applications Auth Id Application Appl. Application Id DB # of Name Handle Name Agents --------...

How to know what is installed in DB2?

How do I know what is installed in DB2? Is there a way, I can determine about hidden components installed in DB2? How do I know which language packs are installed in DB2? Sometime, you might want to know answers about above questions. Normally, you will run db2level...

SQL PL function to convert int to hex

If you are converting from Sybase, you might run into issues for converting INT to HEX. In Sybase: 1> select inttohex(234) 2> go -------- 000000EA (1 row affected) In DB2: DB2 => values hex(234) 1 -------- EA000000 If you want the same exact behavior from DB2, you...