z/OS DB2 DBVisualizer (and other java) support

DBVisualizer by default doesn't supports DB2 databases running on z/OS mainframe.
When you try to connect it can throw this error:

    [jcc][t4][10109][10354][3.57.82] The version of the IBM Universal JDBC driver in use is not licensed for connectivity to QDB2 databases.
    To connect to this server, please obtain a licensed copy of the IBM DB2 Universal Driver for JDBC and SQLJ.
    An appropriate license file db2jcc_license_*.jar for this target platform must be installed to the application class path.
    Connectivity to QDB2 databases is enabled by any of the following license files: [ db2jcc_license_cisuz.jar ]. ERRORCODE=-4472, SQLSTATE=42968

    Details:
       Type: com.ibm.db2.jcc.am.io
       Error Code: -4472
       SQL State: 42968

Or this one:

    [ibm][db2][jcc][10275][10041] Unsupported ccsid, encoding, or locale: "Cp1047".

To add the zOS DB2 support to DBVisualizer you can follow this easy steps:

  1. Download the db2jcclicensecisuz.jar file and put in C:\Program Files\DbVisualizer\lib
  2. Download the charsets.jar file and put it in %JAVA_HOME%\lib
  3. Profit!