IBM Data and AI

Welcome to the IBM Data and AI Ideas Portal for Clients!

We welcome and appreciate your feedback on IBM Data and AI Products to help make them even better than they are today!
Before you submit an idea, please perform a search first as a similar idea may have already been reported in the portal. If a related idea is not yet listed, please create a new idea and include with it a description which includes expected behavior as well as why having this feature would improve the service and how it would address your use case.
IBM Employees:
Clients:
  • Our team welcomes any feedback and suggestions you have for improving our offerings / products! This forum allows us to connect your offering / product improvement ideas with IBM product and engineering teams.

  • If you have not registered on this portal please click on the following link and register. To complete registration you will need to open the email you will receive from Aha to confirm your identity. http://ibm.biz/IBM-Data-and-AI-Portal-Register

Additional Information:
  • The shorter URL for this site is: https://ibm.biz/IBM-Data-and-AI-Ideas

  • To view our roadmaps: http://ibm.biz/Data-and-AI-Roadmaps

  • Reminder: This is not the place to submit defects or support needs, please use normal support channel for these cases

  • Please do not use the Ideas Portal for reporting bugs - we ask that you report bugs or issues with the product by contacting IBM support.

Change to 'Active DB2 Systems' panel

When viewing the DB2 Tools Launchpad and the list of tools installed, enter '?' for a list of active SSIDs.

 

The list that returns includes all DB2 Systems by name, but only the descriptions of the subsystems that match entries in the currently allocated SADBTLIB(ADBTPARM).

 

If your installation model includes a test panel mapping to test libraries (including test SADBTLIB), then you will only see the descriptions of the subsystems entered there.  Your production panel will use production libraries (including production SADBTLIB) and you will only see the descriptions of the subsystems entered THERE.   So, even though other subsystems are present, and they are selectable, the descriptions are not completely populated.

 

Additionally, one DB2 subsystem is listed with an incorrect GROUP.   In my environment, I have up to 8 local DB2 subsystems when I am logged on to lpar MVSA.  They are each a part of a different datasharing group.   My SADBTLIB is intended for my "special" datasharing group so SADBTLIB(ADBTPARM) contains a description for my local subsystem which is part of the datasharing group and for the datasharing group itself.  However, there is another subsystem which is listed as being part of the special datasharing group (it is not).  So of the 9 lines on this panel (8 local subsystems and the datasharing group listed in SADBTLIB(ADBTPARM)), 6 have NO group listed.  The remaining 3 all list the special datasharing group, but one of these three is simply incorrect.

 

For example, this display:

Sel DB2 System Description                                                Group
--- ---------- ---------------------------------------------------------- -----
    LD00                                                                      
    LD33                                                                      
    MD01                                                                      
    PD00                                                                  TG02
    PD32                                                                      
    TD01                                                                      
    TD07       DB2-TG02-SPECIAL                                           TG02
    TD32                                                                      
    TG02       DB2-TG02-SPECIAL                                           TG02

...shows TD07 and TG02 as being part of TG02, which is correct.  PD00 is part of PG01 NOT TG02 and should never be listed as a part of TG02.  Additionally, the Description field is only filled out for subsystems in the special datasharing group (TG02) ADBTPARM.

  • Avatar32.5fb70cce7410889e661286fd7f1897de Guest
  • Dec 23 2019
  • Under Review
Who would benefit from this IDEA? My business DBAs could be more certain of their system selections if this view did not contain incomplete and incorrect data.
How should it work?

I do not know how to adjust the architecture but I would prefer that the screen looked like the text below:

Sel DB2 System Description                                                Group
--- ---------- ---------------------------------------------------------- -----
    LD00       DB2-LG02-PRODUCTION                                        LG02
    LD33       DB2-LG03-PEOPLESOFT-PRODUCTION                             LG03 
    MD01       DB2-MG01-SANDBOX                                           MG01 
    PD00       DB2-PG01-PILOT                                             PG01
    PD32       DB2-PG03-PEOPLESOFT-PILOT                                  PG03 
    TD01       DB2-TG01-TEST                                              TG01
    TD07       DB2-TG02-SPECIAL                                           TG02 
    TD32       DB2-TG03-PEOPLESOFT TEST                                   TG03
    TG02       DB2-TG02-SPECIAL                                           TG02

 

 We also want to be able to migrate updates through these environments individually.  So, when an update is offered to DB2 Administration Tool, we want to be able to install it in a TG02 environment to be sure it works before we introduce it to TG01 > PG01 > LG02 etc.

Idea Priority Medium
Priority Justification I ranked this as Medium because we are aware of this behavior and we can advise our users how to work within the current system, but we still find it confusing and inefficient.
Customer Name Principal Financial Group
  • Attach files
  • Admin
    May Chu commented
    9 Oct 04:40pm
    More evaluation has been done - This should be under the Admin Tool
  • Admin
    May Chu commented
    21 Aug 03:24am

    This AHA idea has been reopened and moved to the TOOLS CUSTOMIZER product. Sorry for any confusion.

  • Admin
    May Chu commented
    4 Aug 09:41pm

    Thank you for this idea submission. However, this idea would be best resolved by TCz so we encourage opening an idea with TCz.”This has been evaluated by development.

    This should be opened against TCz

NOTICE TO EU RESIDENTS: per EU Data Protection Policy, if you wish to remove your personal information from the IBM ideas portal, please login to the ideas portal using your previously registered information then change your email to "anonymous@euprivacy.out" and first name to "anonymous" and last name to "anonymous". This will ensure that IBM will not send any emails to you about all idea submissions