When I connect to DB2 for z/OS with SquirrelSQL 4.5.1, I do not find a list of triggers associated with a table. There is a "TRIGGER" node under a table that I know has triggers, but it shows none of the triggers that exist.
I am able to manually query SYSIBM.SYSTRIGGERS, so it isn't a permissions issue. Moreover, that table is the one used for the database product name in DB2PlatformType. Driver information is in the attached image.
I see the following errors:
2023-04-12 11:51:44:053 [pool-1-thread-1] INFO net.sourceforge.squirrel_sql.plugins.db2.DB2Plugin - MESSAGE: SYSCAT.TRIGGERS IS AN UNDEFINED NAME. SQLCODE=-204, SQLSTATE=42704, DRIVER=3.65.77
2023-04-12 11:56:34:263 [pool-1-thread-1] INFO net.sourceforge.squirrel_sql.plugins.db2.DB2Plugin - MESSAGE: SYSIBM.TRIGGERS IS AN UNDEFINED NAME. SQLCODE=-204, SQLSTATE=42704, DRIVER=3.65.77
2023-04-12 11:56:37:328 [pool-1-thread-1] INFO net.sourceforge.squirrel_sql.plugins.db2.DB2Plugin - MESSAGE: SYS.TRIGGERS IS AN UNDEFINED NAME. SQLCODE=-204, SQLSTATE=42704, DRIVER=3.65.77
2023-04-12 11:58:59:213 [pool-1-thread-1] INFO net.sourceforge.squirrel_sql.plugins.db2.DB2Plugin - MESSAGE: SYSCAT.TRIGGERS IS AN UNDEFINED NAME. SQLCODE=-204, SQLSTATE=42704, DRIVER=3.65.77
2023-04-12 11:59:15:816 [pool-1-thread-1] INFO net.sourceforge.squirrel_sql.plugins.db2.DB2Plugin - MESSAGE: SYSIBM.TRIGGERS IS AN UNDEFINED NAME. SQLCODE=-204, SQLSTATE=42704, DRIVER=3.65.77
Sorry I can't reproduce your problem on any DB2 instance I have access to.
The one that I used which I guess is closest to yours is:
DriverName: IBM Data Server Driver for JDBC and SQLJ
DatabaseProductName: DB2/LINUXX8664
DatabaseProductVersion: SQL110550
DriverVersion: 4.25.13
This looks like we are using different JDBC drivers.
The easiest download site I found for the driver I use is this:
https://repo1.maven.org/maven2/com/ibm/db2/jcc/db2jcc/db2jcc4/db2jcc-db2jcc4.jar
Some information from IBM on the driver can be found here
https://www.ibm.com/support/pages/db2-jdbc-driver-versions-and-downloads-db2-zos
and here
https://www.ibm.com/support/pages/db2-jdbc-driver-versions-and-downloads
Last edit: Gerd Wagner 2023-04-15