Quelques exemples de requetes sur le catalogue :

--
-- Controle de l'espace des pages occupées par les INDEXS 
--
SET CURRENT SQLID = 'xxx'
SELECT B.SPACE*100/(A.PQTY*4),A.IXNAME,A.PQTY,A.SQTY,B.NLEAF, 
  B.NLEAF*B.PGSIZE/B.SPACE,B.CREATOR                          
  FROM SYSIBM.SYSINDEXPART A ,SYSIBM.SYSINDEXES B             
    WHERE   (IXNAME = NAME) AND                               
            (IXNAME LIKE 'xxx%') AND                           
            (B.SPACE > 0) AND                                 
            (CREATOR = 'xxx')                                
   ORDER BY IXNAME ASC;
  
-- 
-- Controle de l'espace des pages occupées par les TABLESPACES
-- 
 SET CURRENT SQLID = 'xxx';                                      
 SELECT B.SPACE*100/(A.PQTY*4),A.TSNAME,A.PQTY,A.SQTY,B.NACTIVE,  
   B.NACTIVE*B.PGSIZE*100/B.SPACE,B.CREATOR                       
   FROM SYSIBM.SYSTABLEPART A ,SYSIBM.SYSTABLESPACE B             
     WHERE   (TSNAME = NAME) AND                                  
           (TSNAME LIKE 'xxx%') AND                                
             (B.SPACE  > 0) AND                                   
             (CREATOR = 'xxx')                                   
     ORDER BY TSNAME;
 
--
-- Controle de l'etat d'ordre des INDEXS
--
 SET CURRENT SQLID = 'PROD';                                      
 SELECT A.CLUSTERED,B.PQTY,B.SQTY,A.NAME,A.DBNAME,A.CLUSTERING    
    FROM SYSIBM.SYSINDEXES A,SYSIBM.SYSINDEXPART B                
    WHERE (NAME = IXNAME)  AND                                    
          (CLUSTERING ='Y' AND CLUSTERED='N') AND                 
          (NAME LIKE 'xxx%') AND                                  
          (CREATOR = 'xxx')                                      
    ORDER BY NAME ASC;
  
--                  
-- Controle du nombre des pages hors limit sur les INDEXS
--
SET CURRENT SQLID = 'xxx';                                     
SELECT LEAFDIST,PQTY,SQTY,IXNAME,FREEPAGE,PCTFREE               
   FROM SYSIBM.SYSINDEXPART                                     
   WHERE (LEAFDIST > 1000) AND                                     
      (IXNAME LIKE 'xxx%') AND                                   
            (IXCREATOR = 'xxx')                                
   ORDER BY IXNAME ASC; 

--  
-- Controle du nombre des pages hors limit sur les TABLESPACES
--
SET CURRENT SQLID = 'xxxx';                                     
SELECT (A.NEARINDREF + A.FARINDREF) * 100 / A.CARD,A.PQTY,A.SQTY,    
       A.TSNAME,B.DBNAME,A.STORNAME,A.CARD                           
       FROM SYSIBM.SYSTABLEPART A,SYSIBM.SYSTABLESPACE B             
       WHERE (TSNAME = NAME) AND                                     
             (CARD > 1) AND                                          
             (TSNAME LIKE 'xxx%') AND                                 
             (CREATOR = 'xxx')                                      
       ORDER BY TSNAME ASC;

                                          
--                                                                       
--*********** LISTE DES tablespaces sans copy *************              
--                                                            
  SET CURRENT SQLID = 'xxx'
  SELECT DISTINCT A.TSNAME,A.DBNAME,A.STORNAME,B.CREATOR      
    FROM SYSIBM.SYSTABLEPART  A,SYSIBM.SYSTABLESPACE B       
    WHERE (A.TSNAME = B.NAME)   AND                          
         (A.DBNAME LIKE 'xxx%') AND                          
           (CREATOR = 'xxxx') AND                           
         NOT EXISTS(SELECT *                                
             FROM SYSIBM.SYSCOPY C                          
             WHERE (A.TSNAME=C.TSNAME) AND                  
             ICDATE='aa0jjj'))                             
   ORDER BY A.TSNAME ASC; 


--                                                                       
--*********** LISTE DES STOGROUP  *************************              
--                                                                       
  SELECT NAME,VOLID,VCATNAME,CREATOR,SPACE                               
         FROM SYSIBM.SYSSTOGROUP,SYSIBM.SYSVOLUMES                       
         WHERE (SGNAME = NAME) AND                                       
           (SGNAME LIKE 'RG%') AND                                       
              (CREATOR = 'PROD')                                         
     ORDER BY NAME;                                                      


--                                                              
--*********** LISTE DES DATABASES *************************     
--                                                              
  SELECT NAME,STGROUP,CREATOR,DBID,BPOOL                        
     FROM SYSIBM.SYSDATABASE                                    
          WHERE (NAME LIKE 'RD%') AND                           
              (CREATOR = 'PROD')                                
     ORDER BY NAME ASC; 

--                                                                 
--*********** LISTE DES TABLESPACES ***********************        
--                                                                 
  SELECT A.TSNAME,B.DBNAME,A.STORNAME,A.PQTY,A.SQTY,               
         A.FREEPAGE,A.PCTFREE,B.NACTIVE,B.CREATOR                  
         FROM SYSIBM.SYSTABLEPART A,SYSIBM.SYSTABLESPACE B         
         WHERE (TSNAME = NAME) AND                                 
               (TSNAME LIKE 'RS%') AND                             
              (CREATOR = 'PROD')                                   
     ORDER BY TSNAME ASC;                                   

--                                                               
--*********** LISTE DES TABLES et des VUES *****************           
--                                                               
  SELECT NAME,DBNAME,TSNAME,RECLENGTH,KEYCOLUMNS,CREATOR         
     FROM SYSIBM.SYSTABLES                                       
     WHERE (DBNAME LIKE 'RD%') AND                               
          (NAME LIKE 'RT%'  OR                                   
           NAME LIKE 'RV%') AND                                  
              (CREATOR = 'PROD')                                 
     ORDER BY NAME ASC;                                          


--                                                                   
--*********** LISTE DES INDEX *****************************          
--                                                                   
  SELECT IXNAME,FREEPAGE,PCTFREE,PQTY,SQTY,LEAFDIST,IXCREATOR        
     FROM SYSIBM.SYSINDEXPART                                        
     WHERE (IXNAME LIKE 'RI%') AND                                   
              (IXCREATOR = 'PROD')                                   
     ORDER BY IXNAME ASC;                                            


--                                                                        
--*********** LISTE DES CLES D'INDEX **********************               
--                                                                        
  SELECT DISTINCT IXNAME,COLNAME,COLSEQ,LENGTH,COLTYPE,TBCREATOR          
    FROM SYSIBM.SYSKEYS,SYSIBM.SYSCOLUMNS                                 
        WHERE (COLNAME = NAME) AND                                        
        (IXNAME LIKE 'RI%') AND                                           
              (TBCREATOR = 'PROD')                                        


--                                                                              
--*********** LISTE DES CONTRAINTES DE REFERENCES *********                     
--                                                                              
  SELECT A.REFTBNAME,A.TBNAME,A.RELNAME,B.COLNAME,A.DELETERULE,B.CREATOR        
         FROM SYSIBM.SYSRELS A,SYSIBM.SYSFOREIGNKEYS B                          
         WHERE (A.RELNAME = B.RELNAME) AND                                      
               (A.REFTBNAME LIKE 'RT%') AND                                     
               (B.CREATOR = 'PROD')                                             
         ORDER BY RELNAME ASC;