DB2常用命令大全列表(国外英文).docVIP

DB2常用命令大全列表(国外英文资料) Landing electronic reconciliation database 22.5.233.142 DB2, connect, to, eBill, user, ebank, using, ebank Landing company online banking database 22.5.233.142 DB2, connect, to, ebank5, user, ebank, using, ebank Backup table DB2 export, to, EBC_BILL_LIST_2007_7.ixf, of, ixf, select, * from, EBC_BILL_LIST, where, EBL_BILL_SIGNBACK_FLAG =1, and, YEAR (EBL_CREATE_DATE) = 2007, and, MONTH (EBL_CREATE_DATE) = Import data DB2 import, from, EBC_BILL_LIST_2007_7.ixf, of, ixf, replace, into, EBC_BILL_LIST. Export database table SQL Db2look, -d, ebank5, -a, -e, -x, -o, creatab.sql Backup the data with db2move Db2move ebank5 export Import all data from the database Db2move ebank5 import Import data into the new library Db2move ebank5 load Run stored procedure DB2 call EB_UPDATE_STATESIGN? Represents input and output The terminator in the SQL statement is changed to @ DB2 - tvf createdb.sql - td@ Table DB2, get, snapshot, for, locks, on, eBill DB2 force application (the last statement to wait until ID) Connect database: Connect to [database name] user [operation user name] using [password] Creating a buffer pool (8K): Create, bufferpool, ibmdefault8k, IMMEDIATE, SIZE, 5000, PAGESIZE, 8, K; Creating a buffer pool (16K) (OA_DIVERTASKRECORD): Create, bufferpool, ibmdefault16k, IMMEDIATE, SIZE, 5000, PAGESIZE, 16, K; Creating a buffer pool (32K) (OA_TASK): Create, bufferpool, ibmdefault32k, IMMEDIATE, SIZE, 5000, PAGESIZE, 32, K; Create tablespace: CREATE TABLESPACE exoatbs IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 8K MANAGED BY SYSTEM USING (/home/exoa2/exoacontainer) EXTENTSIZE 32 PREFETCHSIZE 16 BUFFERPOOL IBMDEFAULT8K 24.10 OVERHEAD TRANSFERRATE 0.90 DROPPED TABLE RECOVERY OFF; CREATE TABLESPACE exoatbs16k IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 16K MANAGED BY SYSTEM USING (/home/exoa2/exoacontainer16k) EXTENTSIZE 32 PREFETCHSIZE 16 BUFFERPOOL IBMDEFAULT16K 24.1 OVERHEAD TRANSFERRATE 0.90 DROPPED TABLE RECOVERY OFF; CREATE TABLESPACE