Answer

As an admin of the Netezza server, it can be useful to know which of your clients are connecting through DbVisualizer.  By default, this information is not passed to the NPS server and so it is not logged.

You can use a feature of DbVisualizer to create an entry in the pg.log for monitoring usage.
1. Open your database connection page:



2. At the bottom left, click on the Properties tab.

3. On the Properties tab, add the following to the Run SQL at Connect box:

select 'DBVisualizer 6.5.9';



When you monitor the /nz/kit/log/postgres/pg.log file, you will see a line indicating that DbVisualizer was the client running in that session:

2009-09-16 16:15:26.562065 EDT [27554]  DEBUG:  connection: host=172.29.65.3 user=admin database=database_test 2009-09-16 16:15:26.571532 EDT [27554]  DEBUG:  QUERY: set datestyle to 'ISO'; 2009-09-16 16:15:26.571988 EDT [27554]  DEBUG:  QUERY: set nz_encoding to 'utf8'; 2009-09-16 16:15:26.572330 EDT [27554]  DEBUG:  QUERY: select version(); 2009-09-16 16:15:26.573306 EDT [27554]  DEBUG:  QUERY: select feature :: int1 from _v_jdbc_feature where spec_level = '3.0' 2009-09-16 16:15:26.576880 EDT [27554]  DEBUG:  QUERY: select 'JDBC Client Version: Release 4.6.5 driver [build 10119]','32-BIT','OS Platform: Windows 2003','OS Username: administrator' 2009-09-16 16:15:26.588768 EDT [27554]  DEBUG:  QUERY: select 'DBVisualizer 6.5.9' 2009-09-16 16:15:26.948166 EDT [27554]  DEBUG:  QUERY: SELECT * FROM _V_JDBC_CATALOG2  ORDER BY TABLE_CAT