DBvis doesn't show Global Temporary Tables (GTT) in Object Tree (DB2)
a
anonymous
started a topic
almost 12 years ago
[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
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
Hans Bergsten
said
about 11 years ago
[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
Roger Bjärevall
said
about 11 years ago
[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
anonymous
[Attachment has been removed.]