title: SQL Connection ClientInfo
body: <p>I am writing a Java Application in which I am connecting to a DB2 database and after getting the connection, I am setting the client info for that connection using the following code:</p>
  
  <pre><code>String clientprogname = "MY PROGRAM";  //Progname
  String clientname = "user1";  // The name of the End-User
  
  con.setClientInfo("ApplicationName", clientprogname);
  con.setClientInfo("ClientUser", clientname);
  
  con.prepareStatement("SELECT * FROM SYSIBM.SYSDUMMY1 WHERE 0 = 1").executeQuery();
  // Execute SQL to force extended client information to be sent to the server
  
  LogFile.log("ApplicationName: " + con.getClientInfo("ApplicationName"));
  LogFile.log("ClientUser: " + con.getClientInfo("ClientUser"));
  </code></pre>
  
  <p>I am aware that I can get the client info using <code>con.getClientInfo</code>, but is the client information stored in the database? According to the <a href="http://docs.oracle.com/javase/6/docs/api/java/sql/Connection.html#setClientInfo%28java.lang.String,%20java.lang.String%29" rel="nofollow">Java Documentation</a>, the client information is stored in a suitable location in the database (for example in a special register, session parameter, or system table column). Is there an SQL statement which I can execute to see a list of all open connection?</p>