DB2 ® DB2 Version 9 for Linux, UNIX, and Windows Getting started with DB2 installation and administration on Linux and Windows GC10-4247-00
DB2 ® DB2 Version 9 for Linux, UNIX, and Windows Getting started with DB2 installation and administration on Linux and Windows GC10-4247-00
Before using this information and the product it supports, be sure to read the general information under Notices. Edition Notice This document contains proprietary information of IBM. It is provided under a license agreement and is protected by copyright law. The information contained in this publication does not include any product warranties, and any statements provided in this manual should not be interpreted as such. You can order IBM publications online or through your local IBM representative.
Contents About this book . . . . . . . . . . . v Part 1. Getting started with DB2 installation . . . . . . . . . . . . . 1 Chapter 1. Installation prerequisites . . . 3 Disk and memory requirements . . . . . . . . 3 Getting started with database authorities . . . . . 3 Windows installation prerequisites . . . . . . . 5 Installation requirements for DB2 clients and servers (Windows) . . . . . . . . . . . 5 Security issues when installing the DB2 database manager . . . . . . . . . . . . . . .
Ordering printed DB2 books . . . . . . . . . Displaying SQL state help from the command line processor . . . . . . . . . . . . . . . Accessing different versions of the DB2 Information Center . . . . . . . . . . . . . . . . Displaying topics in your preferred language in the DB2 Information Center . . . . . . . . . . Updating the DB2 Information Center installed on your computer or intranet server . . . . . . . DB2 tutorials . . . . . . . . . . . . . . iv 82 DB2 troubleshooting information .
About this book This book provides information on how to install your DB2® product. It also introduces DB2 maintenance, administration, and development. For a complete look at the DB2 documentation library, see the DB2 Information Center at http://publib.boulder.ibm.com/infocenter/db2help/. © Copyright IBM Corp.
vi Getting started with DB2 installation and administration
Part 1. Getting started with DB2 installation © Copyright IBM Corp.
2 Getting started with DB2 installation and administration
Chapter 1. Installation prerequisites Disk and memory requirements Disk requirements: The disk space required for your product depends on the type of installation you choose and the type of file system you have. The DB2 Setup wizard provides dynamic size estimates based on the components selected during a typical, compact, or custom installation.
SYSADM is the highest level of administrative authority. It includes all privileges on databases within the DB2 instance as well as the authority to grant and revoke all other authorities and privileges. DBADM provides administrative authority for a specific database. It allows the user to access and modify all objects within that database. A user with DBADM authority can grant and revoke privileges on the database but cannot grant or revoke DBADM authority.
Windows installation prerequisites Installation requirements for DB2 clients and servers (Windows) For the most up-to-date prerequisite information, see v www.ibm.com/software/data/db2/udb/sysreqs.html. To install a DB2 client or server product, the following operating system, software, and hardware prerequisites must be met: Table 1.
Additional software considerations v MDAC 2.8 is required. The DB2 Setup wizard will install MDAC 2.8 if it is not already installed. v v v v v Note: If a previous version of MDAC (for example, 2.7) is already installed, DB2 install will upgrade MDAC to 2.8. For a typical install, MDAC 2.8 is installed. For a compact install, MDAC 2.8 is not installed. For a custom install, MDAC 2.8 is installed but only if you have not deselected the default which is to install it.
program creates default values for different user IDs and the group. Different defaults are created, depending on whether you are installing on UNIX® or Windows platforms: v On UNIX and Linux platforms, if you choose to create a DB2 instance in the instance setup window, the DB2 database install program creates, by default, different users for the DAS (dasusr), the instance owner (db2inst), and the fenced user (db2fenc).
UNIX platforms A valid DB2 database user name that belongs to the primary group of the instance owner. SYSADM privileges are the most powerful set of privileges available within the DB2 database manager. As a result, you might not want all of these users to have SYSADM privileges by default. The DB2 database manager provides the administrator with the ability to grant and revoke privileges to groups and individual user IDs.
Granting user rights (Windows) This topic describes the steps required to grant user rights on Windows operating systems. Specific user rights are recommended for user accounts required to install and set up DB2. Prerequisites: To grant advanced user rights on Windows you must be logged on as a local Administrator. Procedure: 1. Click Start and select Run .... 2. Type secpol.msc and click OK. 3. Select Local Security Policy. 4.
account is defined, adding a domain user to the local Administrators group on the server does not grant the domain user SYSADM authority to this group. To avoid adding a domain user to the Administrators group at the domain controller, create a global group and add the domain users to which you want to grant SYSADM authority to it. Then update the DB2 configuration parameter SYSADM_GROUP with the name of the global group.
When db2schex.exe completes, you can proceed with the installation of your DB2 product. Related reference: v “Installation requirements for DB2 clients and servers (Windows)” on page 5 v “CATALOG LDAP DATABASE command” in Command Reference v “REGISTER command” in Command Reference Linux installation prerequisites Installation requirements for DB2 clients and servers (Linux) For the most up-to-date prerequisite information, see http://www.ibm.com/ software/data/db2/udb/sysreqs.html.
By default, DB2 uses rsh when executing commands on remote DB2 nodes, for example, when starting a remote DB2 database partition. To use the DB2 default, the rsh-server package must be installed (see table below). For a comparison between rsh and ssh, see the “Security issues when installing DB2” section of the Administration Guide: Implementation. If you choose to use the rsh remote shell utility, inetd (or xinetd) must be installed and running as well.
Package requirements for Red Hat Directory Package name Description /System Environment/ Daemons rsh-server This package contains a set of programs which allow users to run commands on a remote computer. Required for partitioned database environments. This package is not required if you configure DB2 to use ssh. /System Environment/ Daemons nfs-utils Network File System support package. It allows access to local files from remote computers.
Related concepts: v “Security issues when installing the DB2 database manager” on page 6 Related tasks: v “Modifying kernel parameters (Linux)” in Quick Beginnings for DB2 Servers v “Preparing to install DB2 for Linux on zSeries” in Quick Beginnings for DB2 Servers Related reference: v “Communication protocols supported” in Quick Beginnings for DB2 Clients v “IBM Software Development Kit for Java levels for DB2 products” in Quick Beginnings for DB2 Servers v “Communications variables” in Performance Guide
Related reference: v “Installation requirements for DB2 clients and for DB2 Servers v “Installation requirements for DB2 clients and Beginnings for DB2 Servers v “Installation requirements for DB2 clients and v “Installation requirements for DB2 clients and System)” in Quick Beginnings for DB2 Servers servers (AIX)” in Quick Beginnings servers (HP-UX)” in Quick servers (Linux)” on page 11 servers (Solaris Operating Chapter 1.
16 Getting started with DB2 installation and administration
Chapter 2. Installation Installing DB2 servers (Windows) This task describes how to start the DB2 Setup wizard on Windows. You will use the DB2 Setup wizard to define your installation and install your DB2 product on your system. Prerequisites: Before you start the DB2 Setup wizard: v If you are planning on setting up a partitioned database environment, see the "Setting up a partitioned database environment" topic. v Ensure that your system meets installation, memory, and disk requirements.
If you have at least one existing DB2 product installed on your computer, you can: v Click Install New to create a newDB2 copy v Click Work with Existing to upgrade an existing DB2 copy, to add functionality to an existing DB2 copy, or to install an add-on product. v Click Migrate to migrate an existing DB2 Version 8 copy. 5. The DB2 Setup wizard will determine the system language, and launch the setup program for that language. Online help is available to guide you through the remaining steps.
Related concepts: v “About the Release Notes” in Release notes v “DB2 database object naming rules” in Administration Guide: Implementation v “DB2 Information Center installation options” in Quick Beginnings for DB2 Servers Related tasks: v “Notification and contact list setup and configuration” in Administration Guide: Implementation v “Tools catalog database and DB2 administration server (DAS) scheduler setup and configuration” in Administration Guide: Implementation v “Migrating a DB2 server (Windows)” i
Procedure: To start the DB2 Setup wizard: 1. Log on to the system as a user with root authority. 2. Change to the directory where the DB2 product CD is mounted by entering the following command: cd /cdrom where /cdrom represents mount point of the DB2 product CD. 3. If you downloaded the DB2 product image, you must decompress and untar the product file. a. Decompress the product file: gzip -d product.tar.gz where product is the name of the product that you downloaded. b.
db2install.history. If the name already exists, then the DB2 installer renames it db2install.history.xxxx, where xxxx is 0000-9999, depending on the number of installations you have on that machine. Each installation copy has a separate list of history files. If an installation copy is removed, the history files under this install path will be removed as well.
22 Getting started with DB2 installation and administration
Chapter 3. Verifying your installation Verifying the installation of DB2 servers using First Steps (Linux and Windows) You should verify that the DB2 server installation has completed successfully by accessing data from the SAMPLE database. Prerequisites: v You must have the Control Center and the First Steps component installed to perform this task. First Steps is listed as a getting started component in the feature selection window in the DB2 Setup wizard.
Related reference: v “db2fs - First steps command” in Command Reference Verifying the installation using the command line processor (CLP) You can verify the installation by creating a sample database and running SQL commands to retrieve sample data. Prerequisites: v The sample database component, found in the features selection, must be installed on your system and is included in a typical installation. v You require a user with SYSADM authority. Procedure: To 1. 2. 3.
Chapter 4. DB2 product licensing DB2 product license files Each DB2 product and feature has a license file associated with it. The license file is found on the associated activation CD supplied as a part of the product media. You should register the license file before using the DB2 product. The management of licenses for DB2 products or features is done through the License Center within the Control Center, or, through the db2licm License Management Tool command.
1. Start the DB2 Control Center and select License Center from the Tools menu. 2. Select the system for which you are installing a license. Select the instance on your systems. Select the product from installed products. The Installed Products field will display the name of the product that you have installed. 3. Select Add from the License menu. 4. In the Add License window, select the license file: v On Windows servers: x:\db2\license\license_filename.
v For Windows operating systems: db2instance_path\adm\db2licm -g filename where v db2instance_path is where the DB2 instance was created. v filename specifies the file name where output is to be stored. DB2 features showing a violation must have the license key registered using either the License Center or the db2licm command. See the related links for details.
28 Getting started with DB2 installation and administration
Part 2. Getting started with DB2 administration © Copyright IBM Corp.
30 Getting started with DB2 installation and administration
Chapter 5. Basic administration Now that you have installed your DB2 product and verified its successful installation, you are ready to create your own database. The following sections will guide you through the steps of creating a new database that will take advantage of DB2 automatic maintenance features. Creating your own database Database basics A relational database presents data as a collection of tables. A table consists of a defined set of columns and any number of rows.
v v v v v creates a new database on the disk or directory of your choice assigns disk space for your data configures the new database for optimal performance turns on automatic maintenance configures notification by e-mail or pager if the database needs attention The Create Database with Automatic Maintenance wizard can be started from First Steps or directly from within the Control Center.
Figure 1. Control Center with a database selected Expand the Object Tree until you can see your database and select it. The right side of the Control Center will fill with details about the database’s current operation and links to relevant actions. When you created your database with the Create Database with Automatic Maintenance, you enabled certain Automatic maintenance features. The features are set up and do not necessarily require any further attention.
34 Getting started with DB2 installation and administration
Chapter 6. Automatic maintenance Your DB2 product provides automatic maintenance capabilities for performing database backups, and keeping statistics current as necessary. Automatic database backup provides users with a solution to help ensure their database is being backed up both properly and regularly, without either having to worry about when to back up, or having any knowledge of the backup command.
Protect your data by planning and implementing a disaster recovery strategy for your system. If suitable to your needs, you may incorporate the automatic database backup feature as part of your backup and recovery strategy. If the database is enabled for roll-forward recovery (archive logging), then automatic database backup can be enabled for either online or offline backup. Otherwise, only offline backup is available.
enabled, DB2 will automatically run the RUNSTATS utility in the background to ensure the correct statistics are collected and maintained. Starting in DB2 Version 9, automatic statistics collection is enabled by default when a new database is created. The performance impact of automatic statistics collection is minimized in several ways: v Statistic collection is performed using throttled RUNSTATS.
38 Getting started with DB2 installation and administration
Chapter 7. DB2 administration and development tools This section describes the DB2 administration and development tools. It explains what each tool is used for and why you might want to use it. It tells you how to invoke a tool and presents basic usage information.
Toolbars: Toolbars are panels that contain icons representing functions you can perform. Toolbars are located below the menu bar. To see a brief description of a tool, place your cursor over its icon and hover help will tell you what function each icon represents. Toolbars provide quick access to the functions you can perform. The functions can also be selected in the View menu. A Contents pane toolbar is located below the contents pane. It allows you to tailor the information in the contents pane.
Figure 2. Contents Pane view Filtering in the Contents pane simply hides data that has already been retrieved from the database. If your database has so many objects that retrieval time is an issue, you may prefer to retrieve only a subset of the objects (for example, tables). This filtering is referred to as Object Filtering and is explained in the next section. Object filtering: Object filtering enables you to work with a subset of all the objects in the database in the Control Center.
Infopops are disabled or re-enabled from the Documentation tab of the Tools Settings notebook. To disable or enable infopops for the Configuration Assistant, select the Display Infopops checkbox menu in the Help menu from the Configuration Assistant tool. Mandatory fields: Mandatory fields are fields for which you must supply information. Mandatory fields are displayed with thick red borders around the field. When information is entered in the mandatory field, the red border is no longer displayed.
Figure 3. Control Center views Three different Control Center views are available. Basic From this folder you can work with all the databases to which you have been granted access, including their related objects such as tables and stored procedures. This view does not include the database objects that are at a higher level than the database in the DB2 hierarchy (systems and instances). It provides you with the essentials for working with data.
v View the details of database objects. You can look at a table’s constituent columns and see the current state of a database. v Manage database objects. You can create, alter, and drop databases, table spaces, tables, views, indexes, triggers, and schemas. You can also manage users. v Manage data. You can load, import, export, and reorganize data. You can also gather statistics. v Perform preventive maintenance by backing up and restoring databases or table spaces.
The Maintenance status category in the Object Details pane will tell you whether or not automatic maintenance is enabled for the database in question. Clicking on Maintenance will allow you to enable, configure, and disable automatic maintenance for the database. If you created the database with the Create Database Using Automatic Maintenance wizard, from First Steps or within the Control Center, then Maintenance should be in the ″enabled″ state. Figure 5.
Setting up notification and contact lists For your DB2 product to contact you or others regarding the health of your databases, you will have to set up notification and contact lists. If you did not do this during the DB2 installation, you can manually set up these lists. Procedure: To set up notification and contact lists: 1. Log on as the instance owner or a user with SYSADM authority. 2.
v v v v Work with query results. View a graphical representation of the access plan for explained SQL statements. Run commands in sequence. Create and save a script. You can optionally store a saved script in the Task Center, where you can schedule the script to run at a specific time. Figure 6. Command Editor window On the Commands page, you can execute an SQL statement or DB2 CLP command. You do not need to precede the command by "DB2".
To run commands and SQL statements:: 1. To open an embedded Command Editor, expand the Control Center object tree until you find a DB2 database. Right-click the object and select Query from the pop-up menu. A Command Editor tile opens in the Control Center. 2. To open a stand-alone Command Editor from the Start menu, select Programs —> IBM DB2 —> [DB2 copy name] —> Command Line Tools —> Command Editor. 3. Select a target database to connect to.
16. Optional: You can save your commands and statements in a file. Click specify a file using the file browser Save As window. to Related concepts: v “Basic GUI navigation concepts” on page 39 v “Getting started with the Control Center” on page 42 Getting started with the Health Center You can start the Health Center in the following ways: v On Windows systems, click Start and select Programs —> IBM DB2 —> [DB2 copy name]—> Monitoring Tools —> Health Center.
Depending on the configuration of the DB2 instance, the following actions can occur when the health monitor generates an alert: v An entry is written in the administration notification log, which you can read from the Journal. v A script or task is executed. v An e-mail or pager message is sent to the contacts that you specify for this instance. The following are some of the key tasks that you can perform with the Health Center: v View the status of the database environment.
To use the Task Center, you must first create a tools catalog. If you did not create a tools catalog when you installed DB2, you can select Tools —> Tools Settings —> Scheduler Settings and create one now. Figure 8. Task Center window Use the Task Center to run tasks, either immediately or according to a schedule, and to notify people about the status of completed tasks. The Task Center includes functionality from the Script Center in previous DB2 versions, plus additional functionality.
combine three backup scripts into a grouping task and then specify a reorganization as a follow-on task that will be executed if all of the backup scripts execute successfully. To see the most recent information, click the Refresh icon button. You can view the results as follows: v To see the results from the last time a task was executed, right-click the task and select Show Results. v To see the results from every time a task was executed, open the Journal.
Figure 9. Journal window To see the most recent information, click the Refresh icon button. The Task History page shows the results of tasks that were previously executed. You can use this information to estimate how long future tasks will run. The Task History page contains one row for each execution of a task. The Task Center contains only one row for each task no matter how many times the task is executed.
Figure 10. Database History The Messages page shows messages that were previously issued from the Control Center and other GUI tools. The Notification Log page shows information from the administration notification log. You can filter the list. For example, you can show only alerts from the health monitor. Several customizable saved views are available using the pull-up menu at the bottom of the Journal.
v v v v v v v Work with existing database objects Bind applications Set database manager configuration parameters for DB2 clients Import and export configuration information Set DB2 registry parameters Change passwords Test connections v Configure CLI settings The graphical interface makes these complex tasks easier through: v Wizards that help you perform certain tasks v Dynamic fields that are activated based on your input choices v Hints that help you make configuration decisions v Discovery that can r
Figure 11.
The client can be any computing device that supports an HTML 4.0-compliant Web browser. The browser does not need to support Java, JavaScript™, or cookies. The middle tier must have DB2 Web Tools installed. DB2 Web Tools requires an application server, such as IBM WebSphere® or BEA WebLogic.
v Using the PDA, you securely log on to a portal where DB2 Web Tools is installed. v You use the Web versions of the Health Center and the Command Center to investigate the problem. v You use the Web version of the Command Center to execute SQL, DB2, and OS commands that fix the problem.
Part 3. Appendixes © Copyright IBM Corp.
60 Getting started with DB2 installation and administration
Appendix A. Installing DB2 servers using response files Response file installation basics Unlike the DB2 Setup wizard, a DB2 response file installation lets you install DB2 products without any user interaction. A response file is a text file that contain setup and configuration information. A response file specifies configuration and setup parameters and the products and components to install.
v Although response files in Version 8 and Version 9 have similar formats, there are version limitations as to where response files can be used. For example, any response file generated in DB2 Version 9 can only be used to install DB2 Version 9; it cannot be used to install DB2 Version 8. The opposite is also true, where response files generated in DB2 Version 8 cannot be used to install DB2 Version 9. This is primarily caused by mandatory keywords that are new in Version 9.
4. In the Select the installation type window, select from Typical, Compact or Custom installation. 5. In the Select the installation, response file creation, or both window, select either the Save my installation setting in a response file option or the Install product on this computer and save my settings in a response file option. Then, in the Response file name field type the path where you want the DB2 Setup wizard to place the generated response file.
64 Getting started with DB2 installation and administration
Appendix B. Language support Changing the DB2 interface language (Windows) The interface language of DB2 is the language that appears in messages, help, and graphical tool interfaces. When installing DB2, you have the option of installing support for one or more languages. If, at some time after installation, you want to change the interface language for DB2 to one of the other installed interface languages, use the steps outlined in this task.
Changing the DB2 interface language (Linux) The interface language of the DB2 product is the language that appears in messages, help, and graphical tool interfaces. When installing your DB2 product, you have the option of installing support for one or more languages. If, at some time after installation, you want to change the interface language to one of the other installed interface languages, use the steps outlined in this task.
Supported DB2 interface languages DB2 language support for DB2 interfaces can be categorized into server group languages and client group languages. Server group languages will translate most messages, help, and DB2 graphical interface elements. Client group languages will translate the DB2 Runtime Client component, which will include most messages and certain help documentation.
Table 3.
v “Supported DB2 interface languages” on page 67 v “db2setup - Install DB2 command” in Command Reference v “setup - Install DB2 command” in Command Reference Appendix B.
70 Getting started with DB2 installation and administration
Appendix C. Installing DB2 fix packs Applying fix packs A DB2 fix pack contains updates and fixes for problems (Authorized Program Analysis Reports, or ″APARs″) found during testing at IBM, as well as fixes for problems reported by customers. Every fix pack is accompanied by a document, called APARLIST.TXT, that describes the fixes it contains. Each fix pack contains a Readme and a set of Release Notes: v The fix pack Readme provides instructions for installing and uninstalling the fix pack.
v “db2setup - Install DB2 command” in Command Reference v “installFixPack - Update installed DB2 products command” in Command Reference v “setup - Install DB2 command” in Command Reference 72 Getting started with DB2 installation and administration
Appendix D. Uninstalling your DB2 product Uninstalling your DB2 product (Windows) This task provides steps for completely removing your DB2 product from your Windows operating system. You should only perform this task if you no longer require existing your DB2 instances and databases. If you are uninstalling the DB2 default copy, and you have other DB2 copies on your system, you should use the db2swtch command to choose a new default copy before you proceed with the uninstallation.
v “Uninstalling your DB2 product (Linux and UNIX)” in Quick Beginnings for DB2 Servers v “Uninstalling a DB2 product using a response file (Windows)” in Installation and Configuration Supplement v “Changing the Default DB2 copy after installation (Windows)” in Administration Guide: Implementation Related reference: v “db2swtch - Switch default DB2 copy command” in Command Reference v “db2unins - Uninstall DB2 database product command” in Command Reference v “DROP DATABASE command” in Command Reference Unin
Related reference: v “db2_deinstall - Uninstall DB2 products or features command” in Command Reference v “db2_install - Install DB2 product command” in Command Reference v “Multiple DB2 copies roadmap” in Administration Guide: Implementation Stopping DB2 instances (Linux) You must stop all DB2 instances associated with the DB2 copy you are uninstalling. Instances associated with other DB2 copies should not be affected by uninstalling the current copy. Procedure: To stop a DB2 instance: 1.
Related concepts: v “DB2 Administration Server” in Administration Guide: Implementation Related tasks: v “Removing DB2 products using the db2_deinstall or doce_deinstall command (Linux)” on page 74 Related reference: v “db2admin - DB2 administration server command” in Command Reference Removing the DB2 administration server (Linux) You must remove the DB2 administration server (DAS) before you remove your DB2 product.
1. Log in as a user with root authority. 2. Remove the instance by entering the following command: DB2DIR/instance/db2idrop InstName where DB2DIR is the location you specified during the DB2 Version 9 installation. The default installation path for Linux is /opt/ibm/db2/V9.1. The db2idrop command removes the instance entry from the list of instances and removes the INSTHOME/sqllib directory, where INSTHOME is the home directory of the instance and where InstName is the login name of the instance.
78 Getting started with DB2 installation and administration
Appendix E. DB2 Database technical information Overview of the DB2 technical information DB2 technical information is available through the following tools and methods: v DB2 Information Center – Topics – Help for DB2 tools – Sample programs – Tutorials v DB2 books – PDF files (downloadable) – PDF files (from the DB2 PDF CD) – printed books v Command line help – Command help – Message help v Sample programs IBM periodically makes documentation updates available.
Related concepts: v “Features of the DB2 Information Center” in Online DB2 Information Center v “Sample files” in Samples Topics Related tasks: v “Invoking command help from the command line processor” in Command Reference v “Invoking message help from the command line processor” in Command Reference v “Updating the DB2 Information Center installed on your computer or intranet server” on page 85 Related reference: v “DB2 technical library in hardcopy or PDF format” on page 80 DB2 technical library in hardc
Table 4.
Table 5. DB2 Connect-specific technical information (continued) Name Form Number Available in print Quick Beginnings for DB2 Connect Personal Edition GC10-4244 Yes Quick Beginnings for DB2 Connect Servers GC10-4243 Yes Table 6.
Note: The most up-to-date and complete DB2 documentation is maintained in the DB2 Information Center at http://publib.boulder.ibm.com/infocenter/ db2help/. Procedure: To order printed DB2 books: v To find out whether you can order printed DB2 books online in your country or region, check the IBM Publications Center at http://www.ibm.com/shop/ publications/order.
Accessing different versions of the DB2 Information Center For DB2 Version 9 topics, the DB2 Information Center URL is http:// publib.boulder.ibm.com/infocenter/db2luw/v9/. For DB2 Version 8 topics, go to the Version 8 Information Center URL at: http://publib.boulder.ibm.com/infocenter/db2luw/v8/.
Related concepts: v “Overview of the DB2 technical information” on page 79 Updating the DB2 Information Center installed on your computer or intranet server If you have a locally-installed DB2 Information Center, updated topics can be available for download. The 'Last updated' value found at the bottom of most topics indicates the current level for that topic.
a. Navigate to the path where the Information Center is installed. By default, the DB2 Information Center is installed in the /opt/ibm/db2ic/V9 directory. b. Run the help_start script using the fully qualified path for the DB2 Information Center: /doc/bin/help_start The systems default Web browser launches to display the stand-alone Information Center. 3. Click the Update button ( ). On the right hand panel of the Information Center, click Find Updates.
DB2 tutorials The DB2 tutorials help you learn about various aspects of DB2 products. Lessons provide step-by-step instructions. Before you begin: You can view the XHTML version of the tutorial from the Information Center at http://publib.boulder.ibm.com/infocenter/db2help/. Some lessons use sample data or code. See the tutorial for a description of any prerequisites for its specific tasks. DB2 tutorials: To view the tutorial, click on the title.
Terms and Conditions Permissions for the use of these publications is granted subject to the following terms and conditions. Personal use: You may reproduce these Publications for your personal, non commercial use provided that all proprietary notices are preserved. You may not distribute, display or make derivative work of these Publications, or any portion thereof, without the express consent of IBM.
Appendix F. Notices IBM may not offer the products, services, or features discussed in this document in all countries. Consult your local IBM representative for information on the products and services currently available in your area. Any reference to an IBM product, program, or service is not intended to state or imply that only that IBM product, program, or service may be used.
Licensees of this program who wish to have information about it for the purpose of enabling: (i) the exchange of information between independently created programs and other programs (including this one) and (ii) the mutual use of the information that has been exchanged, should contact: IBM Canada Limited Office of the Lab Director 8200 Warden Avenue Markham, Ontario L6G 1C7 CANADA Such information may be available, subject to appropriate terms and conditions, including in some cases payment of a fee.
© (your company name) (year). Portions of this code are derived from IBM Corp. Sample Programs. © Copyright IBM Corp. _enter the year or years_. All rights reserved. Trademarks Company, product, or service names identified in the documents of the DB2 Version 9 documentation library may be trademarks or service marks of International Business Machines Corporation or other companies. Information on the trademarks of IBM Corporation in the United States, other countries, or both is located at http://www.ibm.
92 Getting started with DB2 installation and administration
Index A creating database automatic maintenance wizard response files DB2 Setup wizard 62 sample databases 23 administration notification log Health Center 49 Journal 52 Alert Center Health Center 49 alerts tool 49 authorities overview 3 automatic maintenance 35 automatic maintenance wizard creating databases 31 D B backups automatic 35 beacons Health Center 49 C changing Windows default language setting client configurations Configuration Assistant (CA) 54 clients configuration 54 code pages supported
Health Center Alert Center 49 Web version 57 health monitor tool 49 help displaying 84 for SQL statements Linux hardware prerequisites 11 installation requirements 11 operating system prerequisites 11 LOAD authority 3 locales supported 67 83 M I Information Center updating 85 versions 84 viewing in different languages 84 installation response files 61 types 61 silent 61 installation prerequisites Linux 11 Windows 5 installing hardware prerequisites (Linux) 11 hardware prerequisites (Windows) 5 Java requi
updates DB2 Information Center 85 Information Center 85 user IDs selecting 6 user privileges, Windows 9 V verifying DB2 installation using First Steps Visual Explain tutorial 87 23 W Web tools Command Center 56 Health Center 57 where is the response file 61, 62 Windows changing default language setting 65 DB2 system administrator group 9 extending the directory schema Windows 2000 and Windows Server 2003 10 Windows Server 2003 10 granting user rights 9 hardware prerequisites 5 installation prerequisites
96 Getting started with DB2 installation and administration
Contacting IBM To contact IBM in your country or region, check the IBM Directory of Worldwide Contacts at http://www.ibm.com/planetwide To learn more about DB2 products, go to http://www.ibm.com/software/data/db2/. © Copyright IBM Corp.
98 Getting started with DB2 installation and administration
Part Number: CT3ZKNA GC10-4247-00 (1P) P/N: CT3ZKNA Printed in Ireland
IBM DB2 DB2 Version 9 Spine information: Getting started with DB2 installation and administration
