【正文】 2 Servers Migrating DB2 servers involves upgrading your existing instances and databases so that they can run properly in DB2 9. If you are migrating from DB2 Version 8, then you can migrate directly to DB2 9. If you are migrating from DB2 Version 7 or earlier, you will need to migrate to DB2 Version 8 first, and then migrate to DB2 9. N O T E The methodologies to migrate to DB2 9 or DB2 are exactly the same. We will discuss migration to DB2 9 to mean both DB2 9 and DB2 in the following migration discussion Migration Steps for a DB2 Server on Windows In DB2 9, you have the option to migrate an existing DB2 Version 8 installation or to install a new copy of DB2 9, test it, and migrate it manually later. If you migrate your existing Version 8 installation, your DB2 instances and DB2 Administration Server (DAS) are migrated automatically for you. If you install a new copy, you can migrate the instances later by running the db2imigr mand, and you can manually migrate the DAS by running the dasmigr mand after the migration. To migrate to DB2 9 from DB2 Version 8: ? Log in as a Local Administrator or user id with elevated installation privileges. ? Launch the DB2 Setup Wizard to begin installation of DB2 9 code. You will see theoptions Work with Existing and Install New on the Install a Product panel as shown in Figure . You can choose either the Work with Existing or install new option. If you choose the Work with Existing option, DB2 will migrate your existing DB2 Version 8 instances and the DB2 Administration Server (DAS) automatically for you. If you choose to install a new DB2 copy, then you must run the db2imigr mand to migrate the instances, and the dasmigr mand to migrate the DAS manually. ? Migrate the databases, if any. Use the migrate database mand to migrate your databases: db2 migrate database database_alias user username using password where database_alias is the name or the alias of the database you want to migrate. username and password refer to a user with SYSADM authority. N O T E You may want to test DB2 before migrating an existing DB2 Version 8 copy. You can first install DB2 on the server that already has DB2 Version 8 installed. Then create a DB2 instance, and test your applications and environment. When you are satisfied with you testing, you can migrate your instances using the db2imigr and dasimgr mands mentioned above. 1..3 Migration Steps for a DB2 Server on Linux and UNIX To migrate to DB2 9: 1. Log on as root. 2. Run the db2setup mand to install DB2 9. Select Install New on the Install a Product panel to install a new copy of DB2 9. (There is no migrate option for Linux and UNIX as there is for Windows.) 3. Migrate all instances from the same installation path that you indicated during the installation in step 2. Make sure all instances are stopped. db2imigr –u fencedID Instname where u fencedID is the user under which the fenced userdefined functions (UDFs) and stored procedures will run. Instname is the login name of the instance owner. 4. Migrate the databases, if any. Use the migrate database mand to migrate your databases: db2 migrate database database_alias user username using password where database_alias is the name or the alias of the database you want to migrate. username and password refer to a user with SYSADM authority. 2. DB2 FixPack 安裝（完整版） DB2 fixpack 介紹 A DB2 Fix Pack provides fixes to program defects. A fix to a program defect is also known as an Authorized Program Analysis Report (APAR). APARs can be discovered during IBM testing, or reported by customers in test or production environments. Every Fix Pack is acpanied by a document known as the APAR List (), which describes the fixes that particular Fix Pack contains. All Fix Packs are cumulative. This means that the latest Fix Pack for any given version of DB2 contains all of the updates of the previous Fix Packs for the same version of DB2. For example, FP3 will 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. 根據(jù)各自的實(shí)際情況選擇適合自己的補(bǔ)丁包，最后的補(bǔ)丁包下載界面是 。Upgrade161。 is monly used in the DB2 manuals to indicate an upgrade from one version of DB2 to another. We will follow this convention in this book, although, the term 161。migrate161。 local database directory ............................................................................................................................................................................15 7. The Relationship between the DB2 Directories ...........................................................................................................................................................................................16 8. configure a connection using db2 discovery..............................................................................................................................................................................................18 9. Diagnose connection problems ........................................................................................................................................................................................................................18 10. 建表時(shí)表空間的分配使用方法 .............................................................................................................................................................................................................................21 11. SQL語句監(jiān)