【正文】 e table space in the following order of preference, depending on to whom the USE privilege was granted: authorization ID group to which the authorization ID belongs If more than one table space still qualifies, the final choice is made by the database manager. Table space determination can change if: ? Table spaces are dropped or created ? USE privileges are granted or revoked Partitioned tables can have their data partitions spread across multiple table spaces. When multiple table spaces are specified, all of the table spaces must exist, and they must all be either SMS or regular DMS or large DMS table spaces (SQLSTATE 42838). The authorization ID of the statement must hold the USE privilege on all of the specified table spaces. The sufficient page size of a table is determined by either the byte count of the row or the number of columns. 在建表時(shí)，先計(jì)算待建表的各字段的長(zhǎng)度和，再在候選的用戶的表空間中挑選合適頁(yè)大小的表空間，如代建的表的各字段長(zhǎng)度和在 4000以內(nèi)（要考慮 pctfree的值），則會(huì)用 4K的表空間，如超過(guò) 4000byte，則會(huì)選擇用 8K的表空間。期間要留意觀察安裝是否順利進(jìn)行。 選擇最新的 Regular FixPack 17a PTF number: U823673 Build level: s081229 Prerequisite: GA Signature: Release Date:27 Feb 2020 點(diǎn)擊 DD 列的 ↓鈕下載，此文件包有 945M，下載時(shí)間會(huì)比較長(zhǎng)，如果在客戶處升級(jí)的話，需要先行下載好。167。167。DB2 速查手冊(cè) 1. MIGRATING DB2...................................................................................................................................................................................................................................................... 4 Migrating DB2 Servers .............................................................................................................................................................................................................................................. 4 Migration Steps for a DB2 Server on Windows ........................................................................................................................................................................................... 4 2. DB2 FixPack 安裝（完整版） .............................................................................................................................................................................................................................. 6 DB2 fixpack 介紹 .............................................................................................................................................................................................................................................. 6 DB2 FixPack 下載 ............................................................................................................................................................................................................................................ 6 當(dāng)前 DB2版本 ................................................................................................................................................................................................................................................... 8 DB2 FixPack 安裝 ....................................................................................................................................................................................................................................... 8 準(zhǔn)備工作 ..................................................................................................................................................................................................................................................... 8 DB2實(shí)例更新 ..........................................................................................................................................................................................................................................10 3. TERMINATE, CONNECT RESET amp。migrate161。Upgrade161。 當(dāng)前 DB2版本 [170 db2inst1][/home/db2inst1/sqllib/bin] $db2level DB21085I Instance db2inst1 uses 32 bits and DB2 code release SQL08012 with level identifier 02030106. Informational tokens are DB2 , s030508, U486566, and FixPak 2. Product is installed at /usr/opt/db2_08_01. DB2 FixPack 安裝 準(zhǔn)備工作 `將下載的補(bǔ)丁包文件（ ）解壓后 FTP到主機(jī) /db2inst目錄下。安裝完后最好將機(jī)器重啟一下。 如果已經(jīng)確認(rèn)合適的頁(yè)大小的表空間只有一個(gè)則會(huì)查看該用戶是否有 schema 的 createin和表空間的USEAGE權(quán)限。 DISCONNECT To remove the connection to a database, issue the connect reset statement, the terminate mand, or the disconnect statement. Connect reset and terminate will work even if the process is in the middle of a unit of work. Disconnect only works when there is no active unit of work. Closing a window or session without previously issuing a terminate mand will close the CLP application and frontend process and remove the connection to the database, but does not guarantee that the backend process will be terminated. Figure The CLP backend process N O T E The terminate mand is the only one that guarantees the backend process is indeed terminated. Even if the list applications mand does not display the db2bp backend process running, use the terminate mand to be certain It is important to make sure that the backend process is terminated because in some circumstances, a change to a parameter, environment variable, or DB2 registry variable will not take effect until this is performed. For example, in a multipartition environment, the DB2NODE environment variable is used to indicate which partition is the coordinator. After changing the value of this variable, you must issue a terminate mand for it to take effect. N O T E We remend issuing a terminate mand before a db2stop mand. This prevents the backend process from maintaining an attachment to an instance that is no longer active. [YIHANYU/DB2INST1] db2 list applications Auth Id Application Appl. Application Id DB of Name Handle Name Agents