Db2 (On Premises and Cloud)

Expand all | Collapse all

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

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

    Posted 24 days ago
    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 12 days ago
    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 12 days ago
    Replied in private message.

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



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

    Posted 11 days ago
    Edited by Zhen Ling Yu 11 days ago
    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 11 days ago
    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
    ------------------------------