Db2

Db2

Where DBAs and data experts come together to stop operating and start innovating. Connect, share, and shape the AI era with us.


#Data


#Data
#Databases
#Operatingsystems
#Db2
#Databasesolutions
 View Only
  • 1.  dmc explore tables

    Posted 12/17/20 10:27 AM

    dmc 3.1.3 on linux

    connected to a database  : explore : tables

    I can select tables - see columns and show data : but no indexes or other objects on this table

    explore : indexes : shows the name of the index but not the tablename - you have to click each index to find the tablename

    this is again a poor design of new release .....

    any other way to find objects for a table ?



    ------------------------------
    Thank for all update/help
    Best Regards, Guy Przytula
    ------------------------------


    #Db2


  • 2.  RE: dmc explore tables

    Posted 12/21/20 01:59 AM
    Edited by System Admin 01/20/23 04:51 PM

    Hi Guy

    Thanks for your feedback! It may not be very obvious to find dependent objects for a table. You can refer to below guide.

    In Explorer - Table, while you select a table in the left side, the details of that table will show up in the right side. You can click the drop down action icon on the top right corner. There is an item 'dependencies' in the drop down menu. Once click it, you can see other objects that dependent on this table.

    Maybe exposing this option in the table definition page can help. 



    ------------------------------
    Su Li Hou
    ------------------------------



  • 3.  RE: dmc explore tables

    Posted 12/21/20 02:30 AM

    thanks for the update - missed this option

    but when selecting the tablespace - only the data ts is displayed not the index ts : correct ?



    ------------------------------
    Thanks for all answers
    Best Regards,
    Guy Przytula
    ------------------------------



  • 4.  RE: dmc explore tables

    Posted 12/21/20 03:21 AM

    Hi Guy

    Table space support is added in DMC coming release, also includes similar dependency graph as we did for table. You should be able to try it out in early 2021.



    ------------------------------
    Su Li Hou
    ------------------------------