IBM VERSION 9 - Manual

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 an...

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...

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 pr...

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...

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...

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 DB...

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 “Communicatio...

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 pla...

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 ...

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 produc...

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 F...

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 man...

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 C...

v creates a new database on the disk or directory of your choice v assigns disk space for your data v configures the new database for optimal performance v turns on automatic maintenance v configures notification by e-mail or pager if the database needs attention The Create Database with Automatic M...

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 regu...

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. v “Basic GUI navigation concepts” ...

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 a...

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 field...

The following are some of the key tasks that you can perform with the Replication Center: v Create replication control tables v Register replication sources v Create subscription sets v Operate the Capture program v Operate the Apply program v Monitor the replication process v Perform basic troubles...

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 ins...

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 installat...

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 ...

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 AP...

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 uni...

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 Re...

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 insta...

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 ...

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 f...

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. WebSphere Information Integration technical information Name Form Number...

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 o...

© ( 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 trad...

Index A 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 B backups automatic 35 beacons Health Center 49 C changing Windows default language sett...

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