IBM Frozen Dessert Maker VERSION 9 User Manual

DB2®Getting started with DB2 installation and administration on Linux and Windows DB2 Version 9 for Linux, UNIX, and Windows GC10-4247-

2 Getting started with DB2 installation and administration

92 Getting started with DB2 installation and administration

Index Aadministration notification logHealth Center 49 Journal 52 Alert CenterHealth Center 49 alertstool 49 authoritiesoverview 3 automatic

Health CenterAlert Center 49 Web version 57 health monitortool 49 helpdisplaying 84 for SQL statements 83 IInformation Centerupdating 85

updatesDB2 Information Center 85 Information Center 85 user IDsselecting 6 user privileges, Windows 9 VverifyingDB2 installationusing Firs

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/planetwi

98 Getting started with DB2 installation and administration

򔻐򗗠򙳰Part Number: CT3ZKNA Printed in Ireland GC10-4247-00 (1P) P/N: CT3ZKNA

Spine information: IBM DB2 DB2 Version 9 Getting started with DB2 installation and administration 򔻐򗗠򙳰

Chapter 1. Installation prerequisites Disk and memory requirements Disk requirements: The disk space required for your product depend

SYSADM is the highest level of administrative authority. It includes all privileges on databases within the DB2 instance as well as

Windows installation prerequisites Installation requirements for DB2 clients and servers (Windows) For the most up-to-date prerequisite

Additional software considerations v MDAC 2.8 is required. The DB2 Setup wizard will install MDAC 2.8 if it is not already instal

program creates default values for different user IDs and the group. Different defaults are created, depending on whether you are i

UNIX platforms A valid DB2 database user name that belongs to the primary group of the instance owner.SYSADM privileges are the mo

Granting user rights (Windows) This topic describes the steps required to grant user rights on Windows operating systems. Specific u

account is defined, adding a domain user to the local Administrators group on the server does not grant the domain user SYSADM au

When db2schex.exe completes, you can proceed with the installation of your DB2 product. Related reference: v “Installation requiremen

By default, DB2 uses rsh when executing commands on remote DB2 nodes, for example, when starting a remote DB2 database partition.

Package requirements for Red Hat Directory Package name Description /System Environment/Daemons rsh-server This package contains a set o

Related concepts: v “Security issues when installing the DB2 database manager” on page 6 Related tasks: v “Modifying kernel para

Related reference: v “Installation requirements for DB2 clients and servers (AIX)” in Quick Beginnings for DB2 Servers v “Installa

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

If you have at least one existing DB2 product installed on your computer, you can: v Click Install New to create a newDB2 copy

Related concepts: v “About the Release Notes” in Release notes v “DB2 database object naming rules” in Administration Guide: Imp

Procedure: To start the DB2 Setup wizard: 1. Log on to the system as a user with root authority. 2. Change to the directory

db2install.history. If the name already exists, then the DB2 installer renames it db2install.history.xxxx, where xxxx is 0000-9999, de

DB2®Getting started with DB2 installation and administration on Linux and Windows DB2 Version 9 for Linux, UNIX, and Windows GC10-4247-

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 ver

Related reference: v “db2fs - First steps command” in Command ReferenceVerifying the installation using the command line processor

Chapter 4. DB2 product licensing DB2 product license files Each DB2 product and feature has a license file associated with it. The

1. Start the DB2 Control Center and select License Center from the Tools menu. 2. Select the system for which you are install

v For Windows operating systems: db2instance_path\adm\db2licm -g filename where v db2instance_path is where the DB2 instance was

28 Getting started with DB2 installation and administration

Part 2. Getting started with DB2 administration © Copyright IBM Corp. 1993, 2006 29

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

Before using this information and the product it supports, be sure to read the general information under Notices. Edition Notice Thi

v creates a new database on the disk or directory of your choice v assigns disk space for your data v configures the new d

Expand the Object Tree until you can see your database and select it. The right side of the Control Center will fill with detail

34 Getting started with DB2 installation and administration

Chapter 6. Automatic maintenance Your DB2 product provides automatic maintenance capabilities for performing database backups, and keepi

Protect your data by planning and implementing a disaster recovery strategy for your system. If suitable to your needs, you may in

enabled, DB2 will automatically run the RUNSTATS utility in the background to ensure the correct statistics are collected and mainta

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 w

Toolbars: Toolbars are panels that contain icons representing functions you can perform. Toolbars are located below the menu bar. T

Filtering in the Contents pane simply hides data that has already been retrieved from the database. If your database has so many

Contents About this book . . . . . . . . . . .v Part 1. Getting started with DB2 installation . . . . . . . . . . . .

Infopops are disabled or re-enabled from the Documentation tab of the Tools Settings notebook. To disable or enable infopops for th

Three different Control Center views are available. Basic From this folder you can work with all the databases to which you have b

v View the details of database objects. You can look at a table’s constituent columns and see the current state of a database.

The Maintenance status category in the Object Details pane will tell you whether or not automatic maintenance is enabled for the d

Setting up notification and contact lists For your DB2 product to contact you or others regarding the health of your databases, yo

v Work with query results. v View a graphical representation of the access plan for explained SQL statements. v Run commands

To run commands and SQL statements:: 1. To open an embedded Command Editor, expand the Control Center object tree until you fin

16. Optional: You can save your commands and statements in a file. Click to specify a file using the file browser Save As wi

Depending on the configuration of the DB2 instance, the following actions can occur when the health monitor generates an alert: v

To use the Task Center, you must first create a tools catalog. If you did not create a tools catalog when you installed DB2, yo

Ordering printed DB2 books . . . . . . . . .82 Displaying SQL state help from the command line processor . . . . . . . .

combine three backup scripts into a grouping task and then specify a reorganization as a follow-on task that will be executed if

To see the most recent information, click the Refresh icon button. The Task History page shows the results of tasks that were p

The Messages page shows messages that were previously issued from the Control Center and other GUI tools. The Notification Log page

v Work with existing database objects v Bind applications v Set database manager configuration parameters for DB2 clients v Im

The following are some of the key tasks that you can perform with the Replication Center: v Create replication control tables v

The client can be any computing device that supports an HTML 4.0-compliant Web browser. The browser does not need to support Java,

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

Part 3. Appendixes © Copyright IBM Corp. 1993, 2006 59

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 respons

About this book This book provides information on how to install your DB2® product. It also introduces DB2 maintenance, administration

v Although response files in Version 8 and Version 9 have similar formats, there are version limitations as to where response fi

4. In the Select the installation type window, select from Typical, Compact or Custom installation. 5. In the Select the instal

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 appear

Changing the DB2 interface language (Linux) The interface language of the DB2 product is the language that appears in messages, hel

Supported DB2 interface languages DB2 language support for DB2 interfaces can be categorized into server group languages and client

Table 3. Language identifiers (continued) Language Language identifier Danish dk Dutch nl English en Finnish fi French fr German de Greek

v “Supported DB2 interface languages” on page 67 v “db2setup - Install DB2 command” in Command Reference v “setup - Install D

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

vi Getting started with DB2 installation and administration

v “db2setup - Install DB2 command” in Command Reference v “installFixPack - Update installed DB2 products command” in Command Ref

Appendix D. Uninstalling your DB2 product Uninstalling your DB2 product (Windows) This task provides steps for completely removing yo

v “Uninstalling your DB2 product (Linux and UNIX)” in Quick Beginnings for DB2 Servers v “Uninstalling a DB2 product using a re

Related reference: v “db2_deinstall - Uninstall DB2 products or features command” in Command Reference v “db2_install - Install DB

Related concepts: v “DB2 Administration Server” in Administration Guide: Implementation Related tasks: v “Removing DB2 products usi

1. Log in as a user with root authority. 2. Remove the instance by entering the following command: DB2DIR/instance/db2idrop

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 throug

Related concepts: v “Features of the DB2 Information Center” in Online DB2 Information Center v “Sample files” in Samples Topics

Table 4. DB2 technical information (continued) Name Form Number Available in print Developing SQL and External Routines SC10-4373 No Dev

Part 1. Getting started with DB2 installation © Copyright IBM Corp. 1993, 2006 1

Table 5. DB2 Connect-specific technical information (continued) Name Form Number Available in print Quick Beginnings for DB2 Connect Pe

Note: The most up-to-date and complete DB2 documentation is maintained in the DB2 Information Center at http://publib.boulder.ibm.com/

Accessing different versions of the DB2 Information Center For DB2 Version 9 topics, the DB2 Information Center URL is http://publi

Related concepts: v “Overview of the DB2 technical information” on page 79Updating the DB2 Information Center installed on your c

a. Navigate to the path where the Information Center is installed. By default, the DB2 Information Center is installed in the /o

DB2 tutorials The DB2 tutorials help you learn about various aspects of DB2 products. Lessons provide step-by-step instructions. Befo

Terms and Conditions Permissions for the use of these publications is granted subject to the following terms and conditions. Personal

Appendix F. Notices IBM may not offer the products, services, or features discussed in this document in all countries. Consult you

Licensees of this program who wish to have information about it for the purpose of enabling: (i) the exchange of information betwe

© (your company name) (year). Portions of this code are derived from IBM Corp. Sample Programs. © Copyright IBM Corp. _enter the