Start a new topic

DBvis doesn't show Global Temporary Tables (GTT) in Object Tree (DB2)

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

DBvis with DB2 for LUW doesn't show Global Temporary Tables (GTT) in Object Tree. GTT in DB2 are the same as Temporary Tables in Oracle. They are created with command DDL 'CREATE' and deleted with the command 'DROP'. But they are absent in the DBvis Object Tree. In the System Catalog the only difference between GTT and usual tables is that the column syscat.tables.type = 'G' for GTT and 'T' for a usual table. Or (alternative method) column sysibm.tables.table_type is null for GTT and 'BASE TABLE' for a usual table. Example, see: select * from syscat.tables where tabschema='' It will be fine if you will show GTT either in the Tables Node with special mark or in the separate node 'GTT'. Thank you. Edited by: Evg on Nov 23, 2012 4:07 PM

[This reply is migrated from our old forums.]

Re: DBvis doesn't show Global Temporary Tables (GTT) in Object Tree (DB2)
Hi, Thanks for reporting this. I've opened a ticket for adding a new Global Temporary Tables node in the tree for these. Best Regards, Hans
[This reply is migrated from our old forums.]

Re: DBvis doesn't show Global Temporary Tables (GTT) in Object Tree (DB2)
Hi, I'm looking into this now and realize that the node for a GTT cannot have a Data tab, because the data in a GTT is only visible to the session that inserted it. What seems feasible is to list them in the tree and show an Object View tab with Info and Columns sub tabs. Is that what you're looking for? Best Regards, Hans
[This reply is migrated from our old forums.]

Re: DBvis doesn't show Global Temporary Tables (GTT) in Object Tree (DB2)
Hi, Just to inform you this is now fixed in the just released 9.1.1 version. http://www.dbvis.com/download/ Regards Roger