SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLEシステム手続ã??を使ã?£ã?¦ã€?表や索引ã?«å‰²ã‚Šå½“ã?¦ã‚‰ã‚Œã?Ÿæœªä½¿ç”¨ã?®é ˜åŸŸã‚’回å?Žã?™ã‚‹ã?“ã?¨ã?Œã?§ã??ã?¾ã?™ã€‚ 未利用ã?®å‰²ã‚Šå½“ã?¦ã‚‰ã‚Œã?Ÿé ˜åŸŸã?Œå˜åœ¨ã?™ã‚‹å…¸åž‹çš„ã?ªçжæ³?ã?¯ã€?表ã?‹ã‚‰å¤§è¦?模ã?ªæƒ…å ±ã?Œæƒ…å ±ã?Œå‰Šé™¤ã?•れã?Ÿå¾Œã€?ã??れã?§ç©ºã?„ã?Ÿé ˜åŸŸã‚’使ã?†æƒ…å ±ã?ŒæŒ¿å…¥ã?•れã?¦ã?„ã?ªã?„å ´å?ˆã?§ã?™ã€‚ 既定ã?§ã?¯Derbyã?¯æœªä½¿ç”¨ã?®é ˜åŸŸã‚’基本ソフト(OS)ã?«è¿”å?´ã?—ã?¾ã?›ã‚“。例ã?ˆã?°è¡¨ã‚„索引ã?«å‰²ã‚Šå½“ã?¦ã‚‰ã‚Œã?Ÿãƒšãƒ¼ã‚¸ã?¯ã€?表や索引ã?Œç ´æ£„ã?•れるã?¾ã?§ã?¯åŸºæœ¬ã‚½ãƒ•ト(OS)ã?«è¿”å?´ã?•れã?¾ã?›ã‚“。 SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLEã?«ã‚ˆã‚Šä½¿ã‚?れã?¦ã?„ã?ªã?„é ˜åŸŸã‚’åŸºæœ¬ã‚½ãƒ•ãƒˆ(OS)ã?«è¿”å?´ã?™ã‚‹ã?“ã?¨ã?Œã?§ã??ã?¾ã?™ã€‚
ã?“ã?®ã‚·ã‚¹ãƒ†ãƒ 手続ã??ã?«ã‚ˆã‚Šã€?三種類ã?®åœ§ç¸®ã‚’SQL表ã?®è¨˜éŒ²ã?•れã?Ÿé ˜åŸŸã?«ã?¦è¡Œã?„ã?¾ã?™ã€‚ ã??ã?®ä¸‰ç¨®é¡žã?¨ã?¯PURGE_ROWSã€?DEFRAGMENT_ROWSã??れã?¨ TRUNCATE_ENDã?§ã?™ã€‚ã?¾ã?ŸSYSCS_UTIL.SYSCS_COMPRESS_TABLE()ã?¨ã?¯ç•°ã?ªã‚Šã€?æ—¢å˜ã?®è¡¨ã?Šã‚ˆã?³ç´¢å¼•ã?Œè¨˜éŒ²ã?•れã?Ÿé ˜åŸŸã? ã?‘を使ã?£ã?¦å…¨å‡¦ç?†ã?Œè¡Œã‚?れã?¾ã?™ã€‚
SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE( IN SCHEMANAME VARCHAR(128), IN TABLENAME VARCHAR(128), IN PURGE_ROWS SMALLINT, IN DEFRAGMENT_ROWS SMALLINT, IN TRUNCATE_END SMALLINT )
call SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE('US', 'CUSTOMER', 1, 1, 1);
call SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE('US', 'CUSTOMER', 0, 0, 1);
CallableStatement cs = conn.prepareCall ("CALL SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE(?, ?, ?, ?, ?)"); cs.setString(1, "US"); cs.setString(2, "CUSTOMER"); cs.setShort(3, (short) 1); cs.setShort(4, (short) 1); cs.setShort(5, (short) 1); cs.execute();
CallableStatement cs = conn.prepareCall ("CALL SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE(?, ?, ?, ?, ?)"); cs.setString(1, "US"); cs.setString(2, "CUSTOMER"); cs.setShort(3, (short) 0); cs.setShort(4, (short) 0); cs.setShort(5, (short) 1); cs.execute();