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][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] Unsupported ccsid, encoding, or locale: "Cp1047".
To add the zOS DB2 support to DBVisualizer you can follow this easy steps: