Manuals
/
IBM
/
Kitchen Appliance
/
Frozen Dessert Maker
IBM
VERSION 9 manual Getting started with DB2 installation and administration
Models:
VERSION 9
1
100
109
109
Download
109 pages
12.57 Kb
97
98
99
100
101
102
103
104
<
>
Troubleshooting
Install
Extending the directory schema Windows
Maintenance
v Configure and tune instances and databases
Setting up notification and contact lists
To run commands and SQL statements
Procedure
Authorization
Password
Page 100
Image 100
92
Getting started with DB2 installation and administration
Page 99
Page 101
Page 100
Image 100
Page 99
Page 101
Contents
Getting started with DB2 installation and administration on Linux and
Windows
DB2 Version
for Linux, UNIX, and Windows
Page
Getting started with DB2 installation and administration on Linux and
Windows
DB2 Version
for Linux, UNIX, and Windows
Edition Notice
Contents
Part 1. Getting started with DB2 installation
Part 2. Getting started with DB2 administration
Part 3. Appendixes
Index
Appendix F. Notices
Contacting IBM
About this book
vi Getting started with DB2 installation and administration
Part 1. Getting started with DB2 installation
Copyright IBM Corp. 1993
2 Getting started with DB2 installation and administration
Chapter 1. Installation prerequisites
Disk and memory requirements
Getting started with database authorities
Disk requirements
4 Getting started with DB2 installation and administration
v “LOAD authority” in Administration Guide Implementation
Related concepts
Installation requirements for DB2 clients and servers Windows
Windows installation prerequisites
Additional client considerations
Security issues when installing the DB2 database manager
Additional software considerations
Related concepts
Related tasks
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 “General naming rules” in Administration Guide Implementation
v “Authentication” in Administration Guide Planning
v “Authorization” in Administration Guide Planning
UNIX platforms
DB2 system administrator group considerations Windows
Granting user rights Windows
Procedure
Prerequisites
Extending the directory schema Windows
Procedure
Related concepts
Related reference
Linux installation prerequisites
Installation requirements for DB2 clients and servers Linux
Related reference
Package requirements server only
Package requirements for SUSE Linux
12 Getting started with DB2 installation and administration
Package requirements for Red Hat
DB2 product installation on NFS Network File System
Software considerations
Centralized user-management considerations Linux
Related concepts
Related tasks
Related reference
v “Installation requirements for DB2 clients and servers AIX” in Quick Beginnings for DB2 Servers
Related reference
16 Getting started with DB2 installation and administration
Chapter 2. Installation
Installing DB2 servers Windows
Procedure
Prerequisites
v Click Install New to create a newDB2 copy
Installing DB2 servers Linux
Related concepts
Related tasks
Related reference
20 Getting started with DB2 installation and administration
Procedure
cd /cdrom
Related tasks
Related concepts
Related reference
22 Getting started with DB2 installation and administration
Chapter 3. Verifying your installation
Procedure
Prerequisites
Related tasks
Verifying the installation using the command line processor CLP
Procedure
Related reference
Prerequisites
Chapter 4. DB2 product licensing
DB2 product license files
v “License Center overview” in Administration Guide Implementation
v “DB2 installation methods” in Quick Beginnings for DB2 Servers
Checking DB2 license compliance
v “License management” in Administration Guide Implementation
Procedure
Related concepts
Upgrading a Try and Buy license
v “License Center overview” in Administration Guide Implementation
Procedure
v “License Center overview” in Administration Guide Implementation
28 Getting started with DB2 installation and administration
Part 2. Getting started with DB2 administration
Copyright IBM Corp. 1993
30 Getting started with DB2 installation and administration
Chapter 5. Basic administration
Creating your own database Database basics
Related concepts
Related tasks
Verifying your new database
Procedure
Prerequisites
Related concepts
v “Control Center overview” in Administration Guide Implementation
Related concepts
Related tasks
Figure 1. Control Center with a database selected
34 Getting started with DB2 installation and administration
Chapter 6. Automatic maintenance
Automatic database backup
Automatic statistics collection
Related concepts
v “Health monitor” in System Monitor Guide and Reference
Related reference
Chapter 6. Automatic maintenance
Related concepts
Related tasks
Related reference
38 Getting started with DB2 installation and administration
Chapter 7. DB2 administration and development tools
Basic GUI navigation concepts
Start Menu
Control Center menu bars
Contents Pane Details view
40 Getting started with DB2 installation and administration
Toolbars
Wizards
Object filtering
Figure 2. Contents Pane view
Infopops
Getting started with the Control Center
42 Getting started with DB2 installation and administration
Mandatory fields
Help
Advanced
Custom
v Configure and tune instances and databases
v “Control Center overview” in Administration Guide Implementation
To customize objects and actions
Related concepts
Figure 5. Control Center advanced view with a database selected
Setting up notification and contact lists
Getting started with the Command Editor
Procedure
Related reference
v Work with query results
To run commands and SQL statements
48 Getting started with DB2 installation and administration
Related concepts
Getting started with the Health Center
Figure 7. Health Center window
50 Getting started with DB2 installation and administration
Getting started with the Task Center
Related concepts
For each task, you can do the following v Schedule the task
52 Getting started with DB2 installation and administration
Getting started with the Journal
Related concepts
Database History
Related concepts
Getting started with the Configuration Assistant
Figure 10. Database History
Getting started with the Replication Center
Related concepts
Related concepts
Getting started with the Web Command Center
Figure 11. Replication Center window
Related concepts
Getting started with the Web Health Center
Related tasks
Related concepts
58 Getting started with DB2 installation and administration
Related tasks
Part 3. Appendixes
Copyright IBM Corp. 1993
60 Getting started with DB2 installation and administration
Appendix A. Installing DB2 servers using response files
Response file installation basics
Response file considerations
Related concepts
Creating a response file using the DB2 Setup wizard
Procedure
Related concepts
Related tasks
DASPASSWORD = ENCRYPTED = DASPASSWORD
Appendix A. Installing DB2 servers using response files
Related tasks
Related reference
64 Getting started with DB2 installation and administration
Appendix B. Language support
Changing the DB2 interface language Windows
Procedure
Prerequisites
Changing the DB2 interface language Linux
Procedure
Prerequisites
Related tasks
Supported DB2 interface languages
Related tasks
Related reference
Language
Displaying the db2setup command in your national language
Related reference
bourne sh, korn ksh, and bash shells
C shell
v “db2setup - Install DB2 command” in Command Reference
v “setup - Install DB2 command” in Command Reference
v “Supported DB2 interface languages” on page
Appendix B. Language support
70 Getting started with DB2 installation and administration
Appendix C. Installing DB2 fix packs
Applying fix packs
Procedure
Prerequisites
v “setup - Install DB2 command” in Command Reference
v “db2setup - 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
Procedure
db2unins command
Uninstalling your DB2 products Linux
Procedure
Related reference
Prerequisites
Stopping the DB2 administration server Linux
Stopping DB2 instances Linux
Procedure
Procedure
Removing the DB2 administration server Linux
Removing DB2 instances Linux
v “DB2 Administration Server” in Administration Guide Implementation
Procedure
Related reference
Related tasks
DB2DIR/instance/db2idrop InstName
78 Getting started with DB2 installation and administration
Overview of the DB2 technical information
Appendix E. DB2 Database technical information
Documentation feedback
DB2 technical library in hardcopy or PDF format
Related concepts
Related tasks
Related reference
Table 4. DB2 technical information continued
Name
Form Number
Available in print
Ordering printed DB2 books
Related concepts
Related tasks
Table 5. DB2 Connect-specific technical information continued
Displaying SQL state help from the command line processor
Procedure
Procedure
Related concepts
Accessing different versions of the DB2 Information Center
Procedure
84 Getting started with DB2 installation and administration
Related tasks
Procedure
Related concepts
etc/init.d/db2icdv9 stop
DB2 Information Center dir\doc\bin\helpstart.bat
86 Getting started with DB2 installation and administration
Related concepts
Related tasks
DB2 Information Center dir/doc/bin/helpstart
DB2 troubleshooting information
DB2 tutorials
v “Visual Explain overview” in Administration Guide Implementation
Before you begin
Terms and Conditions
88 Getting started with DB2 installation and administration
Appendix F. Notices
IBM Canada Limited Office of the Lab Director 8200 Warden Avenue
Trademarks
92 Getting started with DB2 installation and administration
Index A
Page
Page
96 Getting started with DB2 installation and administration
Contacting IBM
To learn more about DB2 products, go to
98 Getting started with DB2 installation and administration
Page
GC10-4247-00
Part Number CT3ZKNA Printed in Ireland
1P P/N CT3ZKNA
Spine information
Getting started with DB2 installation and administration
IBM DB2 DB2 Version
