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.

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.

  • Avatar32.5fb70cce7410889e661286fd7f1897de Guest
  • May 9 2019
  • Delivered
Who would benefit from this IDEA? Yes, it will improve our DB2 environment performance analysis.
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
Priority Justification It's important for continue using IDAA LOADER.
Customer Name Banco de Brasil

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