IBM Data Platform Ideas Portal for Customers


This portal is to open public enhancement requests against products and services offered by the IBM Data Platform organization. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (https://ideas.ibm.com).


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:


Search existing ideas

Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updates on them if they matter to you. If you can't find what you are looking for,


Post your ideas

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


Specific links you will want to bookmark for future use

Welcome to the IBM Ideas Portal (https://www.ibm.com/ideas) - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal (https://ideas.ibm.com) - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM.

ideasibm@us.ibm.com - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.

IBM Employees should enter Ideas at https://ideas.ibm.com



Add a new idea Subscribe
Status Under review
Workspace Db2 for z/OS
Created by Guest
Created on Feb 25, 2026

RELATED IDEAS

Please provide a DB2 catalog and directory reorg job in SDSNSAMP.

Please provide a DB2 catalog and directory reorg in job in SDSNSAMP which would contain the appropriate parameters to obtain 85-90% of the maximum performance available from IBM's DB2 Reorg utility.

It would be useful for everyone who runs DB2 on z.

It would provide a best practice example of a DB2 catalog and directory reorg.

 

Thank you.

Needed By Yesterday (Let's go already!)
  • Guest
    Mar 25, 2026

    Thank you.

    Please can you add this to SDSNSAMP?

    Reply
  • Guest
    Mar 10, 2026 
    //***************************************                   
    //*  REORG CATALOG V13                                      
    //***************************************                   
    //STEP1 EXEC PGM=DSNUTILB,                                  
    //   PARM='DB2A,REORG1',REGION=0M                           
    //SYSPRINT DD SYSOUT=*                                      
    //UTPRINT  DD SYSOUT=*                                      
    //SYSOUT   DD SYSOUT=*                                      
    //SYSIN DD *                                                
    TEMPLATE UNLOAD DSN(SYSADM.SYSREC.&DB..&TS..T&HO.&MI.)      
                UNIT SYSDA                                      
    TEMPLATE SYSCOPY                                            
                DSN 'SYSADM.&DB..&SN..D&JU..T&HO.&MI.'          
                DISP (NEW,CATLG,CATLG)                          
                UNIT TAPE STACK YES                             
       LISTDEF TS                                         
               INCLUDE TABLESPACE  DSNDB01.DBD01          
               INCLUDE TABLESPACE  DSNDB01.SCT02          
               INCLUDE TABLESPACE  DSNDB01.SPT01          
               INCLUDE TABLESPACE  DSNDB01.SYSDBDXA       
               INCLUDE TABLESPACE  DSNDB01.SYSSPUXA       
               INCLUDE TABLESPACE  DSNDB01.SYSSPUXB       
               INCLUDE TABLESPACE  DSNDB06.SYSTSFAU       
               INCLUDE TABLESPACE  DSNDB06.SYSTSCOL       
               INCLUDE TABLESPACE  DSNDB06.SYSTSTSP       
               INCLUDE TABLESPACE  DSNDB06.SYSTSTPT       
               INCLUDE TABLESPACE  DSNDB06.SYSTSTAB       
               INCLUDE TABLESPACE  DSNDB06.SYSTSIXS       
               INCLUDE TABLESPACE  DSNDB06.SYSTSIXT       
               INCLUDE TABLESPACE  DSNDB06.SYSTSIXR       
               INCLUDE TABLESPACE  DSNDB06.SYSTSIPT       
               INCLUDE TABLESPACE  DSNDB06.SYSTSREL       
               INCLUDE TABLESPACE  DSNDB06.SYSTSFOR       
               INCLUDE TABLESPACE  DSNDB06.SYSTSSYN       
               INCLUDE TABLESPACE  DSNDB06.SYSTSFLD      
               INCLUDE TABLESPACE  DSNDB06.SYSTSTAU      
               INCLUDE TABLESPACE  DSNDB06.SYSTSKEY      
               INCLUDE TABLESPACE  DSNDB06.SYSTSDBA      
               INCLUDE TABLESPACE  DSNDB06.SYSTSDBU      
               INCLUDE TABLESPACE  DSNDB06.SYSGPAUT      
               INCLUDE TABLESPACE  DSNDB06.SYSTSSTG      
               INCLUDE TABLESPACE  DSNDB06.SYSTSVOL      
               INCLUDE TABLESPACE  DSNDB06.SYSTSPLN      
               INCLUDE TABLESPACE  DSNDB06.SYSTSPLA      
               INCLUDE TABLESPACE  DSNDB06.SYSTSDBR      
               INCLUDE TABLESPACE  DSNDB06.SYSTSPLD      
               INCLUDE TABLESPACE  DSNDB06.SYSTSSTM      
               INCLUDE TABLESPACE  DSNDB06.SYSTSPKL      
               INCLUDE TABLESPACE  DSNDB06.SYSTSPLY      
               INCLUDE TABLESPACE  DSNDB06.SYSTSPKG      
               INCLUDE TABLESPACE  DSNDB06.SYSTSPKS      
               INCLUDE TABLESPACE  DSNDB06.SYSTSPKX      
               INCLUDE TABLESPACE  DSNDB06.SYSTSPVR      
               INCLUDE TABLESPACE  DSNDB06.SYSTSPKY        
               INCLUDE TABLESPACE  DSNDB06.SYSTSPKD        
               INCLUDE TABLESPACE  DSNDB06.SYSTSPKA        
               INCLUDE TABLESPACE  DSNDB06.SYSUSER         
               INCLUDE TABLESPACE  DSNDB06.SYSTSCKS        
               INCLUDE TABLESPACE  DSNDB06.SYSTSCHX        
               INCLUDE TABLESPACE  DSNDB06.SYSTSCKD        
               INCLUDE TABLESPACE  DSNDB06.SYSTSSRG        
               INCLUDE TABLESPACE  DSNDB06.SYSTSVEW        
               INCLUDE TABLESPACE  DSNDB06.SYSTSVWD        
               INCLUDE TABLESPACE  DSNDB06.SYSTSVWT        
               INCLUDE TABLESPACE  DSNDB06.SYSTSVTR        
               INCLUDE TABLESPACE  DSNDB06.SYSSTATS        
               INCLUDE TABLESPACE  DSNDB06.SYSDDF          
               INCLUDE TABLESPACE  DSNDB06.SYSTSAUX        
               INCLUDE TABLESPACE  DSNDB06.SYSTSCON        
               INCLUDE TABLESPACE  DSNDB06.SYSTSDAT        
               INCLUDE TABLESPACE  DSNDB06.SYSTSDEP        
               INCLUDE TABLESPACE  DSNDB06.SYSTSENV        
               INCLUDE TABLESPACE  DSNDB06.SYSTSKYC     
               INCLUDE TABLESPACE  DSNDB06.SYSTSPRM     
               INCLUDE TABLESPACE  DSNDB06.SYSTSRAU     
               INCLUDE TABLESPACE  DSNDB06.SYSTSROU     
               INCLUDE TABLESPACE  DSNDB06.SYSPLUXA     
               INCLUDE TABLESPACE  DSNDB06.SYSPLUXB     
               INCLUDE TABLESPACE  DSNDB06.SYSTSSCM     
               INCLUDE TABLESPACE  DSNDB06.SYSTSTBC     
               INCLUDE TABLESPACE  DSNDB06.SYSTSTRG     
               INCLUDE TABLESPACE  DSNDB06.SYSTSTRT     
               INCLUDE TABLESPACE  DSNDB06.SYSSEQ       
               INCLUDE TABLESPACE  DSNDB06.SYSSEQ2      
               INCLUDE TABLESPACE  DSNDB06.SYSHIST      
               INCLUDE TABLESPACE  DSNDB06.SYSGRTNS     
               INCLUDE TABLESPACE  DSNDB06.SYSJAUXA     
               INCLUDE TABLESPACE  DSNDB06.SYSJAUXB     
               INCLUDE TABLESPACE  DSNDB06.SYSJAVA      
               INCLUDE TABLESPACE  DSNDB06.SYSALTER     
               INCLUDE TABLESPACE  DSNDB06.SYSTSOBX     
               INCLUDE TABLESPACE  DSNDB06.SYSTSASC    
               INCLUDE TABLESPACE  DSNDB06.SYSEBCDC    
               INCLUDE TABLESPACE  DSNDB06.SYSTSUNI    
               INCLUDE TABLESPACE  DSNDB06.SYSXML      
               INCLUDE TABLESPACE  DSNDB06.SYSTSXTM    
               INCLUDE TABLESPACE  DSNDB06.SYSTSXTS    
               INCLUDE TABLESPACE  DSNDB06.SYSTARG     
               INCLUDE TABLESPACE  DSNDB06.SYSROLES    
               INCLUDE TABLESPACE  DSNDB06.SYSCONTX    
               INCLUDE TABLESPACE  DSNDB06.SYSTSTSS    
               INCLUDE TABLESPACE  DSNDB06.SYSTSISS    
               INCLUDE TABLESPACE  DSNDB06.SYSTSADT    
               INCLUDE TABLESPACE  DSNDB06.SYSTSCTL    
               INCLUDE TABLESPACE  DSNDB06.SYSTSCTR    
               INCLUDE TABLESPACE  DSNDB06.SYSTSCTD    
               INCLUDE TABLESPACE  DSNDB06.SYSTSPEN    
               INCLUDE TABLESPACE  DSNDB06.SYSTSPDT    
               INCLUDE TABLESPACE  DSNDB06.SYSTSPDO    
               INCLUDE TABLESPACE  DSNDB06.SYSTSTPF    
               INCLUDE TABLESPACE  DSNDB06.SYSTSPTX         
               INCLUDE TABLESPACE  DSNDB06.SYSTSATW         
               INCLUDE TABLESPACE  DSNDB06.SYSTSPRH         
               INCLUDE TABLESPACE  DSNDB06.SYSTSPHX         
               INCLUDE TABLESPACE  DSNDB06.SYSTSATS         
               INCLUDE TABLESPACE  DSNDB06.SYSTSATX         
               INCLUDE TABLESPACE  DSNDB06.SYSTSQRA         
               INCLUDE TABLESPACE  DSNDB06.SYSTSPKC         
               INCLUDE TABLESPACE  DSNDB06.SYSTSQRY         
               INCLUDE TABLESPACE  DSNDB06.SYSTSQRP         
               INCLUDE TABLESPACE  DSNDB06.SYSTSQRO         
               INCLUDE TABLESPACE  DSNDB06.SYSTSVAR         
               INCLUDE TABLESPACE  DSNDB06.SYSTSVAT         
               INCLUDE TABLESPACE  DSNDB06.SYSTSVAD         
               INCLUDE TABLESPACE  DSNDB06.SYSTSVAU         
               INCLUDE TABLESPACE  DSNDB06.SYSTSQRE         
               INCLUDE TABLESPACE  DSNDB06.SYSTSQRS         
               INCLUDE TABLESPACE  DSNDB06.SYSTSIXC         
               INCLUDE TABLESPACE  DSNDB06.SYSTSSFB         
               INCLUDE TABLESPACE  DSNDB06.SYSTSDQY       
               INCLUDE TABLESPACE  DSNDB06.SYSTSDQT       
               INCLUDE TABLESPACE  DSNDB06.SYSTSDQS       
               INCLUDE TABLESPACE  DSNDB06.SYSTSDQE       
               INCLUDE TABLESPACE  DSNDB06.SYSTSDQH       
               INCLUDE TABLESPACE  DSNDB06.SYSTSDQO       
               INCLUDE TABLESPACE  DSNDB06.SYSTSDQD       
               INCLUDE TABLESPACE  DSNDB06.SYSTSICO       
               INCLUDE TABLESPACE  DSNDB06.SYSTSSES       
               INCLUDE TABLESPACE  DSNDB06.SYSTSSNL       
               INCLUDE TABLESPACE  DSNDB06.SYSTSSNX       
               INCLUDE TABLESPACE  DSNDB06.SYSTSSXL       
               INCLUDE TABLESPACE  DSNDB06.SYSTSSTA       
               INCLUDE TABLESPACE  DSNDB06.SYSTSLVH       
               INCLUDE TABLESPACE  DSNDB06.SYSTSADH       
               INCLUDE TABLESPACE  DSNDB06.SYSTSAUH       
               INCLUDE TABLESPACE  DSNDB06.SYSTSCHD       
               INCLUDE TABLESPACE  DSNDB06.SYSTSCHR       
               INCLUDE TABLESPACE  DSNDB06.SYSTSCNH       
               INCLUDE TABLESPACE  DSNDB06.SYSTSCTH             
               INCLUDE TABLESPACE  DSNDB06.SYSTSCXH             
               INCLUDE TABLESPACE  DSNDB06.SYSTSDBH             
               INCLUDE TABLESPACE  DSNDB06.SYSTSFAH             
               INCLUDE TABLESPACE  DSNDB06.SYSTSISH             
               INCLUDE TABLESPACE  DSNDB06.SYSTSPKH             
               INCLUDE TABLESPACE  DSNDB06.SYSTSPLH             
               INCLUDE TABLESPACE  DSNDB06.SYSTSRAH             
               INCLUDE TABLESPACE  DSNDB06.SYSTSSAH             
               INCLUDE TABLESPACE  DSNDB06.SYSTSSCH             
               INCLUDE TABLESPACE  DSNDB06.SYSTSTAH             
               INCLUDE TABLESPACE  DSNDB06.SYSTSTBH             
               INCLUDE TABLESPACE  DSNDB06.SYSTSTSH             
               INCLUDE TABLESPACE  DSNDB06.SYSTSUAH             
               INCLUDE TABLESPACE  DSNDB06.SYSTSVDH             
    REORG TABLESPACE LIST TS SHRLEVEL CHANGE  ICLIMIT_TAPE 4    
    NOSYSREC  SORTDEVT SYSDA  SORTDATA YES PARALLEL 4           
    DRAIN_WAIT 20 RETRY 15  RETRY_DELAY 10 AUX NO               
    MAXRO 10 LONGLOG CONTINUE DELAY 0 DRAIN ALL TIMEOUT TERM    
    //*************************************                     
    //*  SYSLGRNX                                               
    //*************************************                     
    //STEP2 EXEC PGM=DSNUTILB,                                  
    //   PARM='DB2A,REORG2',REGION=0M                           
    //SYSPRINT DD SYSOUT=*                                      
    //UTPRINT  DD SYSOUT=*                                      
    //SYSOUT   DD SYSOUT=*                                      
    //SYSIN     DD *                                            
    TEMPLATE UNLOAD DSN(SYSADM.SYSREC.&DB..&TS..T&HO.&MI.)      
                UNIT SYSDA                                      
    TEMPLATE SYSCOPY                                            
                DSN 'SYSADM.&DB..&SN..D&JU..T&HO.&MI.'          
                DISP (NEW,CATLG,CATLG)                          
                UNIT TAPE                                       
       LISTDEF TS                                               
               INCLUDE TABLESPACE  DSNDB01.SYSLGRNX             
    REORG TABLESPACE LIST TS SHRLEVEL CHANGE                    
    NOSYSREC SORTDEVT SYSDA  SORTDATA YES                       
    DRAIN_WAIT 20 RETRY 15  RETRY_DELAY 10 AUX NO                   
    MAXRO 10 LONGLOG CONTINUE DELAY 0 DRAIN ALL TIMEOUT TERM        
    //***************************************                       
    //*  SYSTSCPY                                                   
    //***************************************                       
    //STEP3 EXEC PGM=DSNUTILB,                                      
    //   PARM='DB2A,REORG3',REGION=0M                               
    //SYSPRINT DD SYSOUT=*                                          
    //UTPRINT  DD SYSOUT=*                                          
    //SYSOUT   DD SYSOUT=*                                          
    //SYSIN     DD *                                                
    TEMPLATE UNLOAD DSN(SYSADM.SYSREC.&DB..&TS..T&HO.&MI.)          
                UNIT SYSDA                                          
    TEMPLATE SYSCOPY                                                
                DSN 'SYSADM.&DB..&SN..D&JU..T&HO.&MI.'              
                DISP (NEW,CATLG,CATLG)                              
                UNIT TAPE                                           
       LISTDEF TS                                                   
               INCLUDE TABLESPACE  DSNDB06.SYSTSCPY                 
    REORG TABLESPACE LIST TS SHRLEVEL CHANGE                 
    NOSYSREC  SORTDEVT SYSDA  SORTDATA YES                   
    DRAIN_WAIT 20 RETRY 15  RETRY_DELAY 10 AUX NO            
    MAXRO 10 LONGLOG CONTINUE DELAY 0 DRAIN ALL TIMEOUT TERM
    Reply

By clicking the "Post Comment" or "Submit Idea" button, you are agreeing to the IBM Ideas Portal Terms of Use.
Do not place IBM confidential, company confidential, or personal information into any field.