CREATE TABLE M2 
   (COL0 INTEGER COMPRESS SYSTEM DEFAULT) 
   COMPRESS YES
   VALUE COMPRESSION IN TST; 

CREATE PROCEDURE ss ( )
	DYNAMIC RESULT SETS  0 
BEGIN
  declare stmt varchar( 4096 );
  DECLARE i INTEGER DEFAULT  0 ;
  WHILE i <  999  DO      
    SET i = i +  1 ;
    SET stmt = 'ALTER TABLE m2 ADD col' || CHAR(i) || ' INT  COMPRESS SYSTEM DEFAULT';
    execute immediate stmt;	  
  END WHILE;	
END@ 

CREATE PROCEDURE sss()
    LANGUAGE SQL 
    BEGIN
        DECLARE i INTEGER DEFAULT  0 ;
        DECLARE j INTEGER DEFAULT  0 ;
        WHILE i <  1000000  DO 
            SET i = i +  1 ;
            SET j = j +  1 ;
            INSERT INTO m2 (col0) VALUES ( 1 );
            IF j >=  10000  THEN
                COMMIT WORK;
                SET j =  0 ;
            END IF;
        END WHILE;
    END@

SELECT TABNAME AS TABLE_NAME,
  INT(DATA_OBJECT_P_SIZE/ 1024 ) AS OBJ_SZ_MB,
  INT(INDEX_OBJECT_P_SIZE/ 1024 ) AS INX_SZ_MB,
  INT(XML_OBJECT_P_SIZE/ 1024 ) AS XML_SZ_MB
FROM SYSIBMADM.ADMINTABINFO
WHERE TABSCHEMA='KHL' AND
      TABNAME = 'M2'

                           COMPRESS
                          | Y |  N
                          |---|----
COMPRESS SYSTEM DEFAULT |Y| 30| 390
                        |N| 52| 781