Db2 On Premise and Cloud

  • 1.  DMC 3.1.5 Tablespaces in DPF Partition other than Partition 0 not listed!

    Posted Wed September 29, 2021 09:04 AM
    Hi there,

    DB2 DPF 11.1

    just noticed, all my tablespaces in partition groups not containing partition zero are not listed in "Tablespaces" in DMC!

    Example:
    Partition group SDPG has only partition 0
    Partition group PDPG has partitions 1,2,3,4,5
    Partition group ADPG has partitions 0,1,2,3,4,5

    Tablespace SingleParttbs is in Partition Group SDPG, visible in DMC
    Tablespace AllParttbs is in Partition Group ADPG, visible in DMC
    Tablespace Parttbs is in Partition Group PDPG, NOT visible in DMC.


    What once was a mess in Data Studio is now invisible in DMC ;-) 

    Please fix.

    Michael​

    ------------------------------
    Michael Klemmer
    ------------------------------


  • 2.  RE: DMC 3.1.5 Tablespaces in DPF Partition other than Partition 0 not listed!

    Posted Tue October 12, 2021 02:33 AM
    Hi, ​Could you help to run below sql and upload result? Thank you.
    SELECT
    	tb.tbsp_name AS tbsp_name ,
    	MEMBER,
    	storage_group_name,
    	tb.DBPARTITIONNUM,
    	bp.bpname AS bp_name
    FROM
    	TABLE(mon_get_tablespace(NULL,-2)) tb ,
    	syscat.bufferpools bp
    WHERE
    	tb.tbsp_cur_pool_id = bp.bufferpoolid​


    ------------------------------
    Zhen Ling Yu
    ------------------------------



  • 3.  RE: DMC 3.1.5 Tablespaces in DPF Partition other than Partition 0 not listed!

    Posted Tue October 12, 2021 03:06 AM
    Replied in private message.

    ------------------------------
    Michael Klemmer
    ------------------------------



  • 4.  RE: DMC 3.1.5 Tablespaces in DPF Partition other than Partition 0 not listed!

    Posted Tue October 12, 2021 04:31 AM
    Edited by Zhen Ling Yu Tue October 12, 2021 04:50 AM
    Hi,
    Sorry. I didn't make my words clear.

    Please follow below steps:
    1. Login DMC , Select the database you are mentioned with this problem
    2. Click tab 'Storage' --> sub tab 'Table space performance'
    3. Click 'Export as CSV' to download 
    4. Try to find the tablespace without member 0 or upload it. Thank you.

    ------------------------------
    Zhen Ling Yu
    ------------------------------



  • 5.  RE: DMC 3.1.5 Tablespaces in DPF Partition other than Partition 0 not listed!

    Posted Tue October 12, 2021 06:43 AM
    OK, I see, 
    in Database - Data - Storage Objects: there are only table spaces listed with Partition 0 in it,

    in Database - Storage - Table Space Performance:  all table spaces are listed.

    OK, would be really nice to see all table spaces listed in Database - Data - Storage Objects to get a glance of all table space states as an example (I don't dare to say "for instance" ;-)...

    ------------------------------
    Michael Klemmer
    ------------------------------