db2速查手册

db2速查手册内容摘要：

l include all the fixes present in FP1 and FP2. Fix Packs are normally available every three months. It is remended to keep your DB2 environment running at the latest Fix Pack level to ensure a lowincident operation. DB2 FixPack 下载 You can download the latest DB2 Fix Pack from the IBM DB2 and DB2 Connect Onlin Support Web Site at Each Fix Pack also contains a set of Release Notes and a Readme file. The Readme file provides instructions for installing the Fix Pack for each operating system. 根据各自的实际情况选择适合自己的补丁包，最后的补丁包下载界面是。 选择最新的 Regular FixPack 17a PTF number: U823673 Build level: s081229 Prerequisite: GA Signature: Release Date:27 Feb 2020 点击 DD 列的 ↓钮下载，此文件包有 945M，下载时间会比较长，如果在客户处升级的话，需要先行下载好。 当前 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 安装 准备工作 `将下载的补丁包文件（ ）解压后 FTP到主机 /db2inst目录下。 停止所有应用，停止实例运行，停止 DAS 运行。 cd /db2inst 正式安装 全部选中所列的包 进行安装。 期间要留意观察安装是否顺利进行。 安装完后最好将机器重启一下。 DB2实例更新 When you apply a DB2 regular Fix Pack, you are in fact refreshing the DB2 code by overwriting some or all of the DB2 binaries. You then need to reestablish the links to an existing instance using the db2iupdt program on Linux and UNIX (this step is not required on Windows). Applying a Fix Pack does not affect the data in the databases. Figure shows an example of what happens after applying Fix Pack 1 to DB2 . [170 root][/usr/opt/db2_08_01/instance] ./db2iupdt DBI1011I Usage: db2iupdt [h|?] [d] [k] [s] [D] [a AuthType] [w WordWidth] [u FencedID] {e|InstName} Explanation: An incorrect argument was entered for the db2iupdt mand. Valid arguments for this mand are: h|? display the usage information d turn debug mode on. k keep the current instance type during the update. s ignore existing SPM log directory D updates the instance to a code level that is lower than the current code level. This option is only valid in a multiple FixPak environment. a AuthType is the authentication type (SERVER, CLIENT, DCS, SERVER_ENCRYPT, or DCS_ENCRYPT) for the instance. The default is SERVER. w WordWidth is the width, in bits, of the instance to be created (31, 32, or 64). Ignored if e is specified. You must have the requisite version of DB2 installed (31bit, 32bit or 64bit) to be able to select the appropriate width. The default width value is the lowest bit width supported by the current version of DB2, the platform, and the instance type. The default value will be the same as the instance to be updated. u FencedID is the name of the user under which fenced UDFs and fenced Stored Procedures will be run. This flag is not required if only a DB2 client is installed. e specifies that every instance is updated. InstName is the name of the instance. User Response: Enter the mand again with the proper options and arguments. [170 root][/usr/opt/db2_08_01/instance] ./db2iupdt k e db2inst1 yixq db2inst1 DBI1070I Program db2iupdt pleted successfully. [170 root][/usr/opt/db2_08_01/instance] su db2inst1 [170 db2inst1][/home/db2inst1] $ls cfgfile_bk mbox project IBM db2inst1 sqllib todo_tomorrow importfile yihanyumove [170 db2inst1][/home/db2inst1] $ps ef |grep db2 dasusr1 262288 1 0 10:55:47 0:00 /usr/opt/db2_08_01/bin/db2fmcd dasusr1 295086 262288 0 10:55:47 0:00 /home/dasusr1/das/bin/db2admin start dasusr1 307208 1 0 11:00:20 0:00 /home/dasusr1/das/bin/db2fmd i dasusr1 m /home/dasusr1/das/lib/ root 352432 1 0 11:00:19 0:00 /usr/opt/db2_08_01/bin/db2fmcd db2inst1 364774 372888 0 11:00:47 pts/0 0:00 grep db2 db2inst1 368774 372888 5 11:00:47 pts/0 0:00 ps ef db2inst1 372888 159896 0 11:00:36 pts/0 0:00 ksh [170 db2inst1][/home/db2inst1] $ [170 db2inst1][/home/db2inst1] $db2start 03/10/2020 11:00:57 0 0 SQL1063N DB2START processing was successful. SQL1063N DB2START processing was successful. [170 db2inst1][/home/db2inst1] $db2level DB21085I Instance db2inst1 uses 32 bits and DB2 code release SQL08029 with level identifier 030A0106. Informational tokens are DB2 , s080813, U823673, and FixPak 17. Product is installed at /usr/opt/db2_08_01. [170 db2inst1][/home/db2inst1] $db2 activate db yihanyu activate db yihanyu DB20200I The ACTIVATE DATABASE mand pleted successfully. [170 db2inst1][/home/db2inst1] $ [170 db2inst1][/home/db2inst1] $ [170 db2inst1][/home/db2inst1] $db2 connect to yihanyu connect to yihanyu Database Connection Information Database server = DB2/6000 SQL authorization ID = DB2INST1 Local database alias = YIHANYU 3. TERMINATE, CONNECT RESET amp。 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。