Start a new topic

DB2 z/OS (mainframe) schemas-databases show up as 'null'

[This topic is migrated from our old forums. The original author name has been removed]

I am positive this is related to something incorrect in the DB2 z/OS environment, but the DBAs have not found it yet. Perhaps someone on the forum can provide insight. ... The issue is that when connecting to our development DB2, the connection is made and the schemas/databases are represented. However, all the schema/database names are displayed as 'null'. The main reason I suspect that this is not DbVisualizer related is that the same installation connects to the production environment and all is displayed correctly. There was an earlier problem that prevented connection to the development environment, and that was resolved by doing a rebind on the packages associated with the SYSIBM.SQLTABLES routine. Thoughts?

[This reply is migrated from our old forums. The original author name has been removed]

Re: DB2 z/OS (mainframe) schemas-databases show up as 'null'
Found some additional info by turning on the monitor. ------------------------- Product Information ------------------------ Product: DbVisualizer Free 9.1.12 Build: #2306 (2014-11-27 14:36:33) Java VM: Java HotSpot(TM) 64-Bit Server VM Java Version: 1.7.0_25 Java Vendor: Oracle Corporation OS Name: Windows Server 2008 R2 OS Arch: amd64 OS Version: 6.1 ------------------------- Connected Databases ------------------------ Database Type: DB2 LUW Major Version: 10 Minor Version: 1 Profile: generic Connection Message: DB2 DSN10015 IBM DB2 JDBC Universal Driver Architecture 2.7.58 --------------------------- Debug Printouts -------------------------- [cleared] [db2][jcc][Time:1430330643628][Thread:ExecutorRunner-pool-2-thread-4][ResultSet@4d2b72] wasNull () returned true [ibm][db2][jcc][Time:1430330643628][Thread:ExecutorRunner-pool-2-thread-4][ResultSet@4d2b72] getString (5) called [ibm][db2][jcc][Time:1430330643628][Thread:ExecutorRunner-pool-2-thread-4][ResultSet@4d2b72] getString () returned null [ibm][db2][jcc][Time:1430330643628][Thread:ExecutorRunner-pool-2-thread-4][ResultSet@4d2b72] wasNull () called [ibm][db2][jcc][Time:1430330643628][Thread:ExecutorRunner-pool-2-thread-4][ResultSet@4d2b72] wasNull () returned true [ibm][db2][jcc][Time:1430330643628][Thread:ExecutorRunner-pool-2-thread-4][ResultSet@4d2b72] next () called [ibm][db2][jcc][Time:1430330643628][Thread:ExecutorRunner-pool-2-thread-4][ResultSet@4d2b72] next () returned true [ibm][db2][jcc][Time:1430330643628][Thread:ExecutorRunner-pool-2-thread-4][ResultSet@4d2b72] getString (1) called [ibm][db2][jcc][Time:1430330643628][Thread:ExecutorRunner-pool-2-thread-4][ResultSet@4d2b72] getString () returned null [ibm][db2][jcc][Time:1430330643628][Thread:ExecutorRunner-pool-2-thread-4][ResultSet@4d2b72] wasNull () called [ibm][db2][jcc][Time:1430330643628][Thread:ExecutorRunner-pool-2-thread-4][ResultSet@4d2b72] wasNull () returned true [ibm][db2][jcc][Time:1430330643628][Thread:ExecutorRunner-pool-2-thread-4][ResultSet@4d2b72] getString (2) called [ibm][db2][jcc][Time:1430330643628][Thread:ExecutorRunner-pool-2-thread-4][ResultSet@4d2b72] getString () returned SPGAAC [ibm][db2][jcc][Time:1430330643628][Thread:ExecutorRunner-pool-2-thread-4][ResultSet@4d2b72] wasNull () called [ibm][db2][jcc][Time:1430330643628][Thread:ExecutorRunner-pool-2-thread-4][ResultSet@4d2b72] wasNull () returned false [ibm][db2][jcc][Time:1430330643628][Thread:ExecutorRunner-pool-2-thread-4][ResultSet@4d2b72] getString (3) called [ibm][db2][jcc][Time:1430330643628][Thread:ExecutorRunner-pool-2-thread-4][ResultSet@4d2b72] getString () returned null [ibm][db2][jcc][Time:1430330643628][Thread:ExecutorRunner-pool-2-thread-4][ResultSet@4d2b72] wasNull () called [ibm][db2][jcc][Time:1430330643628][Thread:ExecutorRunner-pool-2-thread-4][ResultSet@4d2b72] wasNull () returned true [ibm][db2][jcc][Time:1430330643628][Thread:ExecutorRunner-pool-2-thread-4][ResultSet@4d2b72] getString (4) called [ibm][db2][jcc][Time:1430330643628][Thread:ExecutorRunner-pool-2-thread-4][ResultSet@4d2b72] getString () returned null [ibm][db2][jcc][Time:1430330643628][Thread:ExecutorRunner-pool-2-thread-4][ResultSet@4d2b72] wasNull () called [ibm][db2][jcc][Time:1430330643628][Thread:ExecutorRunner-pool-2-thread-4][ResultSet@4d2b72] wasNull () returned true ... Much more similar, then, at the end: ....... ....... [ibm][db2][jcc][ResultSetMetaData@4896b8a3] BEGIN TRACE_RESULT_SET_META_DATA [ibm][db2][jcc][ResultSetMetaData@4896b8a3] Result set meta data for statement Statement@2c468062 [ibm][db2][jcc][ResultSetMetaData@4896b8a3] Number of result set columns: 1 isDescribed=true[ibm][db2][jcc][ResultSetMetaData@4896b8a3] Column 1: { label=1, name=1, type name=VARCHAR, type=12, nullable=0, precision=128, scale=0, schema name=, table name=, writable=false, sqlPrecision=0, sqlScale=0, sqlLength=128, sqlType=448, sqlCcsid=37, sqlName=1, sqlLabel=null, sqlUnnamed=1, sqlComment=null, sqludtxType=, sqludtRdb=, sqludtSchema=, sqludtName=, sqlxKeymem=0, sqlxGenerated=1, sqlxParmmode=0, sqlxCorname=null, sqlxName=null, sqlxBasename=null, sqlxUpdatable=0, sqlxSchema=null, sqlxRdbnam=UCCMVSBD, internal type=12, is locator parameter=false } [ibm][db2][jcc][ResultSetMetaData@4896b8a3] { sqldHold=0, sqldReturn=0, sqldScroll=0, sqldSensitive=0, sqldFcode=0, sqldKeytype=0, sqldRdbnam=UCCMVSBD, sqldSchema=null } [ibm][db2][jcc][ResultSetMetaData@4896b8a3] END TRACE_RESULT_SET_META_DATA [ibm][db2][jcc][Time:1430330643641][Thread:pool-3-thread-7][Statement@2c468062] executeQuery () returned ResultSet@1f33fa90 [ibm][db2][jcc][Time:1430330643641][Thread:pool-3-thread-7][Statement@2c468062] getUpdateCount () called [ibm][db2][jcc][Time:1430330643641][Thread:pool-3-thread-7][Statement@2c468062] getUpdateCount () returned -1 [ibm][db2][jcc][Time:1430330643641][Thread:ExecutorRunner-pool-2-thread-4][ResultSet@1f33fa90] next () called [ibm][db2][jcc][Time:1430330643641][Thread:ExecutorRunner-pool-2-thread-4][ResultSet@1f33fa90] next () returned true [ibm][db2][jcc][Time:1430330643641][Thread:ExecutorRunner-pool-2-thread-4][ResultSet@1f33fa90] getObject (1) called [ibm][db2][jcc][Time:1430330643641][Thread:ExecutorRunner-pool-2-thread-4][ResultSet@1f33fa90] getObject () returned MNTMRM [ibm][db2][jcc][Time:1430330643641][Thread:pool-3-thread-7][Statement@2c468062] close () called [ibm][db2][jcc] [t4][time:1430330643641][thread:pool-3-thread-7][tracepoint:1][Request.flush] [ibm][db2][jcc][t4] SEND BUFFER: RDBCMM (ASCII) (EBCDIC) [ibm][db2][jcc][t4] 0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF 0123456789ABCDEF [ibm][db2][jcc][t4] 0000 000AD00100010004 200E ........ . ..}....... [ibm][db2][jcc][t4] [ibm][db2][jcc] [t4][time:1430330643642][thread:pool-3-thread-7][tracepoint:2][Reply.fill] [ibm][db2][jcc][t4] RECEIVE BUFFER: ENDUOWRM (ASCII) (EBCDIC) [ibm][db2][jcc][t4] 0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF 0123456789ABCDEF [ibm][db2][jcc][t4] 0000 002BD05200010025 220C000611490004 .+.R...%"....I.. ..}............. [ibm][db2][jcc][t4] 0010 00162110E4C3C3D4 E5E2C2C440404040 ..!.........@@@@ ....UCCMVSBD [ibm][db2][jcc][t4] 0020 4040404040400005 211501 @@@@@@..!.. ..... [ibm][db2][jcc][t4] [ibm][db2][jcc][t4] RECEIVE BUFFER: SQLCARD (ASCII) (EBCDIC) [ibm][db2][jcc][t4] 0000 000BD00300010005 2408FF ........$.. ..}........ [ibm][db2][jcc][t4] 11:04:03 [ERROR ExecutorRunner-pool-2-thread-4 B.?] Could not find filter column name 'TABLE_SCHEM' in DataSet. Notify vendor as the database profile is in an inconsistent state. 11:04:03 [DEBUG ExecutorRunner-pool-2-thread-4 B.execute] Total rows/columns: 181/5. Rows after filtering: 181
[This reply is migrated from our old forums.]

Re: DB2 z/OS (mainframe) schemas-databases show up as 'null'
Hi Michael, I first suggest that you upgrade to the latest 9.2.6 version as the object filtering has been completely redesigned. http://www.dbvis.com/download/ Give that version a try and let me know the results. Regards Roger