Finally DB2 implemented a long standing demand for setting the Java application name so that you could see the name through DB2 utilities instead of seeing db2jcc_applica.
You set a connection property clientProgramName to your chosen name and the db2 utilities will pick up this name instead of the default name of db2jcc_application.
java.util.Properties conProp = new java.util.Properties(); String url = "jdbc:db2://localhost:50000/GSDB"; Class.forName("com.ibm.db2.jcc.DB2Driver"); conProp.put("user", "myUserName"); conProp.put("password", "myPassword"); conProp.put("clientProgramName", "MyProgram"); connection = DriverManager.getConnection(url, conProp);
When you list the application, you will see the name that you set.
C:\Documents and Settings\Administrator>db2 list applications Auth Id Application Appl. Application Id DB # -------- -------------- ---------- ------------------------------ -------- ---- DBAPOT db2jcc_applica 993 127.0.0.1.48648.090430221610 GSDB 1 DBAPOT MyProgram 997 127.0.0.1.50184.090430221627 GSDB 1 DBAPOT db2jcc_applica 996 127.0.0.1.49416.090430221613 GSDB 1 DBAPOT db2jcc_applica 995 127.0.0.1.49160.090430221612 GSDB 1 VIKRAM db2bp.exe 988 *LOCAL.DB2.090430221558 GSDB 1 DBAPOT db2jcc_applica 994 127.0.0.1.48904.090430221611 GSDB 1