Controle de l'etat d'ordre (ORDERED) 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;