| # | 場景 | 關鍵語法/指令 |
|---|---|---|
| 1 | 字串串接 | || 運算子 |
| 2 | 大量刪除 (最快) | ALTER TABLE t ACTIVATE NOT LOGGED INITIALLY WITH EMPTY TABLE |
| 3 | 大量刪除 (次快) | IMPORT FROM /dev/null OF DEL REPLACE INTO t |
| 4 | 資料匯出 | EXPORT TO file.del OF DEL SELECT * FROM t |
| 5 | 資料匯入 | IMPORT FROM file.del OF DEL INSERT INTO t |
| 6 | 檢查表是否存在 | SELECT * FROM SYSIBM.SYSTABLES WHERE LOWER(NAME) = 't' |
| 7 | 鎖診斷流程 | GET SNAPSHOT FOR LOCKS ON <db> → FORCE APPLICATION(<handle>) |
| 8 | 部署預存程序 | db2 -td@ -vf proc.sql (指定終止符 @) |
| 9 | 驗證索引效果 | RUNSTATS ON TABLE t WITH DISTRIBUTION AND DETAILED INDEXES ALL |
| 10 | 完整快照 | UPDATE MONITOR SWITCHES USING LOCK ON SORT ON BUFFERPOOL ON UOW ON TABLE ON STATEMENT ON → GET SNAPSHOT FOR ALL ON <db> |
| 11 | 檢視預存程序原始碼 | SELECT PROCNAME, TEXT FROM SYSIBM.SYSPROCEDURES |
| 12 | 列出所有表 | LIST TABLES |
| 13 | 字串定位 | LOCATE('y', 'xyz') 回傳位置 (1-based) |
| 14 | 日期差天數 | DAYS(DATE('2007-03-01')) - DAYS(DATE('2007-02-28')) |
| 15 | 跨 Schema 別名 | CREATE ALIAS t FOR other_schema.t |
| 16 | 描述表結構 | DESCRIBE TABLE t 或 DESCRIBE SELECT * FROM t |
| 17 | 重啟資料庫 | RESTART DATABASE <db> |
| 18 | 啟用資料庫 | ACTIVATE DATABASE <db> |
| 19 | 停用資料庫 | DEACTIVATE DATABASE <db> |
| 20 | 重命名表 | RENAME TABLE old TO new |
| 21 | 建立序列 | CREATE SEQUENCE seq START WITH 1 INCREMENT BY 1 NO MAXVALUE NO CYCLE CACHE 24 |
| 22 | 檢視索引詳情 | DESCRIBE INDEXES FOR TABLE t SHOW DETAIL |
收藏此表，日常開發運維可節省大量查閱手冊時間。
