IBM Data and AI Ideas Portal for Clients

Shape the future of IBM!

We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:

Post your ideas

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

Post ideas and requests to enhance a product or service. Take a look at ideas others have posted and upvote them if they matter to you,

  1. Post an idea

  2. Upvote ideas that matter most to you

  3. Get feedback from the IBM team to refine your idea

Help IBM prioritize your ideas and requests

The IBM team may need your help to refine the ideas so they may ask for more information or feedback. The offering manager team will then decide if they can begin working on your idea. If they can start during the next development cycle, they will put the idea on the priority list. Each team at IBM works on a different schedule, where some ideas can be implemented right away, others may be placed on a different schedule.

Receive notification on the decision

Some ideas can be implemented at IBM, while others may not fit within the development plans for the product. In either case, the team will let you know as soon as possible. In some cases, we may be able to find alternatives for ideas which cannot be implemented in a reasonable time.

Additional Information

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

IBM Employees:

The correct URL for entering your ideas is: https://hybridcloudunit-internal.ideas.aha.io

Include new virtual table for IFCID 0199

Banco do Brasil are using several SMF virtual tables available by IDAA LOADER but some reports that we desired need to of IFCID 0199 data. So we want new table(s) with these data to improve our DB2 environment analysis.

  • Guest
  • May 9 2019
  • Delivered
Who would benefit from this IDEA? Yes, it will improve our DB2 environment performance analysis.
Priority Justification It's important for continue using IDAA LOADER.
Client Name Banco de Brasil
How should it work?

We propose create one table or set of them to delivery IFCID 0199 data like "db2hlq.SDSNMACS(DSNDQW02)".

***********************************************************************
**   IFCID 0199 FOR RMID 10 TO RECORD DATASET STATISTICS             **
**                                                                   **
** IFCID 0199 PROVIDES DATASET I/O STATISTICS.                       **
**                                                                   **
** THE RECORD IS MADE UP OF A NUMBER OF MAPPED SECTIONS:             **
**      SECTION QWT02PSO IS MAPPED BY DSNDQWHS (AND, OPTIONALLY,     **
**              DSNDQWHC, DSNDQWHT, DSNDQWHU, DSNDQWHD)              **
**      SECTION QWT02R1O IS MAPPED BY QW0199HE                       **
**      SECTION QWT02R2O IS MAPPED BY QW0199                         **
**                                                                   **
** THERE IS ONE QW0199HE PER IFCID 0199 RECORD.  QW0199HE GIVES      **
** CONTROL INFORMATION ABOUT THE DATASET STATISTICS VALUES.          **
**                                                                   **
** THERE IS ONE QW0199 SECTION GIVEN FOR EACH OPEN DATASET THAT HAS  **
** AVERAGED AT LEAST 1 I/O PER SECOND WITHIN THE CURRENT REPORTING   **
** INTERVAL.  THE MAXIMUM NUMBER OF QW0199 SECTIONS IN A SINGLE      **
** TRACE RECORD IS 50.  IF THERE ARE MORE THAN 50 DATASETS TO BE     **
** REPORTED, THEN MULTIPLE IFCID 0199 RECORDS ARE GENERATED EXCEPT   **
** FOR IFI READS, WHERE ALL RECORDS ARE RETURNED UNLESS THE OUTPUT   **
** PROVIDED BY THE CALLER IS NOT LARGE ENOUGH TO CONTAIN THE RECORDS.**
** IF REPORTED VIA THE IFI READS INTERFACE, THEN IFCID 0199 GIVES    **
QW0199HE DSECT            IFCID(QWHS0199) HEADER                     
*                         POINTED TO BY QWT02R10                     
         DS    0F         INSURE BOUNDARY                            
QW0199TS DS    CL8        STORE CLOCK VALUE AT THE END OF THE        
*                         STATISTICS INTERVAL                        
QW0199   DSECT                                                       
*                         POINTED TO BY QWT02R20                     
         DS    0F         INSURE BOUNDARY                            
QW0199DB DS    H          DATABASE ID                                
QW0199OB DS    H          PAGESET  ID                                
QW0199DN DS    H          PIECE/PART NUMBER                          
QW0199BP DS    X          BUFFER POOL ID                             
*                         For records written to a IFI               
*                         return area on an IFI READS call           
*                         the bufferpool ID will be defined          
*                         as follows:                                
*                         0   -  49 (0x00 - 0x31)  4K bufferpools    
*                         50  -  59 (0x32 - 0x3B) 32K bufferpools    
*                         60  -  69 (0x3C - 0x45)  8K bufferpools    
*                         70  -  79 (0x46 - 0x4F) 16K bufferpools    
*                         For records written as statistics records  
*                         to all destinations other than an IFI    
*                         READS return area:                           
*                         0   -  49 (0x00 - 0x31)  4K bufferpools      
*                         80  -  89 (0x50 - 0x59) 32K bufferpools      
*                         100 - 109 (0x64 - 0x6D)  8K bufferpools      
*                         120 - 129 (0x78 - 0x81) 16K bufferpools      
QW0199DS DS    X          FLAGS                                        
QW0199GD EQU   X'80'      1=GBP-DEPENDENT                              
*                         0=NON GBP-DEPENDENT                          
QW0199ID EQU   X'40'      1=INDEX                                      
*                         0=DATA                                       
QW0199LS EQU   X'20'      1=ANOTHER IFCID 199 RECORD FOLLOWS           
*                           AFTER THIS ONE IN THIS SEQUENCE.           
*                         0=THIS IS THE LAST IFCID 0199 RECORD IN      
*                           THIS SEQUENCE.                             
QW0199SD EQU   X'10'      1=SHADOW COPY                                
*                         0=NON-SHADOW DATA SET                        
*  **....QW0199SP MATCHES DSNB455I MSG CONTENTS                  ....**
*  **....SYNCHRONOUS I/O FOR WRITE AND READ                      ....**
QW0199SV DS    F          AVERAGE I/O DELAY (IN MILLISECONDS)          
QW0199SX DS    F          MAXIMUM I/O DELAY (IN MILLISECONDS)          
QW0199SP DS    F          TOTAL I/O PAGES                              
*  **....QW0199AP, QW0199AC MATCH DSNB456I MSG CONTENTS          ....** 
*  **....QW0199AP, QW0199AC MATCH DSNB456I MSG CONTENTS          ....**
*  **....ASYNCHRONOUS I/O FOR WRITE, READ AND CASTOUT            ....**
QW0199AD DS    F          AVERAGE I/O DELAY (IN MILLISECONDS)          
QW0199AX DS    F          MAXIMUM I/O DELAY (IN MILLISECONDS)          
QW0199AP DS    F          TOTAL I/O PAGES                              
QW0199AC DS    F          TOTAL I/O COUNT                              
*  **....FOLLOWING 3 FIELDS MATCH DSNB453I AND DSNB454I MSG      ....**
*  **....CONTENTS:  BUFFER POOL CACHED DATA                      ....**
QW0199VP DS    F          CURRENT PAGE COUNT - VIRTUAL POOL            
QW0199VD DS    F          CURRENT CHANGED PAGE COUNT - VIRTUAL POOL    
         DS    F          RESERVED                                     
*  **....FOLLOWING 1 FIELD NOT INCLUDED IN A DSNB MSG *jbt 8/02  ....**
QW0199GP DS    F          CURRENT NUMBER OF GET PAGES                  
QW0199SC DS    CL8        TIMESTAMP OF THE LAST TIME THIS DATASET WAS  
*                         EXTERNALIZED IN THE DATASET STATISTICS IFCID.
*                         IF THIS IS THE FIRST TIME THIS DATASET SHOWS
*                         UP IN THE STATISTICS RECORD, THIS TIMESTAMP  
*                         REPRESENTS THE TIME WHEN THE DATASET WAS     
*                         OPENED. THIS FIELD HAS NO MEANING FOR AN IFI
*                         READS CALL.                                  
*  **....FOLLOWING 2 FIELDS MATCH DSNB455I MSG CONTENTS          ....**
*  **....SYNCHRONOUS I/O FOR WRITE AND READ IN MICROSECONDS      ....**
QW0199S1 DS    CL8        AVERAGE I/O DELAY (IN MICROSECONDS)          
QW0199S2 DS    CL8        MAXIMUM I/O DELAY (IN MICROSECONDS)          
*  **....FOLLOWING 2 FIELDS MATCH DSNB456I MSG CONTENTS          ....**
*  **....ASYNCHRONOUS I/O FOR WRITE, READ AND CASTOUT IN MICROSEC....**
QW0199A1 DS    CL8        AVERAGE I/O DELAY (IN MICROSECONDS)          
QW0199A2 DS    CL8        MAXIMUM I/O DELAY (IN MICROSECONDS)          
*  **....I/O FOR USING Z/HYPERLINK IN MICROSECONDS               ....**
QW0199ZV DS    CL8        AVERAGE I/O DELAY (IN MILLISECONDS)          
QW0199ZX DS    CL8        MAXIMUM I/O DELAY (IN MILLISECONDS)          
QW0199ZP DS    CL8        TOTAL I/O PAGES                              
QW0199Z1 DS    CL8        AVERAGE I/O DELAY (IN MICROSECONDS)          
QW0199Z2 DS    CL8        MAXIMUM I/O DELAY (IN MICROSECONDS)         
Idea Priority High

IBM's success depends on gathering feedback from customers like yourself. Aha Ideas Portal is the third party tool through which IBM Offering Managers gather feedback from customers such as yourself.
IBM is a global organization with business processes, management structures, technical systems and service provider networks that cross borders. As such, the information collected through Aha Ideas Portal (Customer Name, Customer Email Address) will be stored by them in the United States, and handled only as per IBM's instructions and policies. Your data (Name and Email Address) will NOT be shared with other IBM customers.
In order to safeguard your information in Aha, do not leave your workstation unattended while using this application, log off after using it, and print only if necessary. If you need to make a hardcopy, remember to pick up the print-out immediately, keep it under lock, and destroy it immediately when no longer needed.
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