Db2 LUW, Db2 z/OS, Db2 iSeries (AS/400)

Db2 iSeries: Remarks not displayed
When upgrading to DB2 iSeries 7.1, Remarks for tables and columns are not properly shown anymore. The reason for this is that there has been some internal...
Fri, 10 May, 2024 at 1:48 PM
Db2 iSeries: Tables are not listed if schema name contains underscore
Due to an issue with the JTOpen JDBC driver it fails to show tables if the parent schema name contains an underscore (_). Do as follows to workaroun...
Wed, 16 Mar, 2022 at 7:44 AM
Db2 LUW, Db2 z/OS: Messages from the database/JDBC driver don't show any meaningful text
In the Connection tab under the Options section enable Show Detailed Error Messages to show more details about any errors generated by the DB2 database...
Fri, 6 Jan, 2023 at 11:00 AM
Db2 LUW, Db2 z/OS: DbVisualizer may hang when executing erroneous SQL
Disable Show Detailed Error Messages in the options section under connection setup.
Wed, 16 Mar, 2022 at 7:45 AM
Db2 LUW: SQL Error: SQLCODE=-443, SQLSTATE=38553, SQLERRMC=SYSIBM.SQLTABLES
Some DB2 LUW users report that the following error occur while exploring the database objects tree: An error occurred while executing the database request...
Wed, 16 Mar, 2022 at 7:45 AM
Db2 LUW, Db2 z/OS: I get an error regarding "db2jcc_license_*.jar" file at connect?
When connecting to a DB2 database one of the following error messages may appear in the connection message in DbVisualizer: For DB2 z/OS: "The IB...
Sun, 19 May, 2024 at 10:00 AM
Db2 LUW, Db2 z/OS: "Security mechanism not supported" at connect
The default security authorization strategy when connecting to DB2 is that the JDBC driver send the the database password in clear text to the datab...
Wed, 16 Mar, 2022 at 7:45 AM
Db2 LUW: Connect using Kerberos
Use the following steps to connect to Db2 LUW using Kerberos with DbVisualizer. 1. Create jaas.conf file If there is no existing jaas.conf file, you...
Wed, 15 Nov, 2023 at 2:20 PM