Db2

  • 1.  dmc explore tables

    Posted Thu December 17, 2020 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 Mon December 21, 2020 01:59 AM
    Edited by System Fri January 20, 2023 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
    ------------------------------

    Original Message


  • 3.  RE: dmc explore tables

    Posted Mon December 21, 2020 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
    ------------------------------

    Original Message


  • 4.  RE: dmc explore tables

    Posted Mon December 21, 2020 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
    ------------------------------

    Original Message