Manuals
/
IBM
/
Kitchen Appliance
/
Frozen Dessert Maker
IBM
VERSION 9 manual Getting started with DB2 installation and administration
Models:
VERSION 9
1
68
109
109
Download
109 pages
12.57 Kb
65
66
67
68
69
70
71
72
<
>
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 68
Image 68
60
Getting started with DB2 installation and administration
Page 67
Page 69
Page 68
Image 68
Page 67
Page 69
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
Contacting IBM
Appendix F. Notices
Index
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
Related concepts
v “LOAD authority” in Administration Guide Implementation
4 Getting started with DB2 installation and administration
Additional client considerations
Windows installation prerequisites
Installation requirements for DB2 clients and servers Windows
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 Red Hat
12 Getting started with DB2 installation and administration
Package requirements for SUSE Linux
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
cd /cdrom
Procedure
20 Getting started with DB2 installation and administration
Related reference
Related concepts
Related tasks
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
Infopops
Figure 2. Contents Pane view
Object filtering
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
Figure 7. Health Center window
Getting started with the Health Center
Related concepts
Related concepts
Getting started with the Task Center
50 Getting started with DB2 installation and administration
For each task, you can do the following v Schedule the task
Related concepts
Getting started with the Journal
52 Getting started with DB2 installation and administration
Database History
Figure 10. Database History
Getting started with the Configuration Assistant
Related concepts
Getting started with the Replication Center
Related concepts
Figure 11. Replication Center window
Getting started with the Web Command Center
Related concepts
Related tasks
Getting started with the Web Health Center
Related concepts
Related tasks
58 Getting started with DB2 installation and administration
Related concepts
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
72 Getting started with DB2 installation and administration
v “db2setup - Install DB2 command” in Command Reference
v “setup - Install DB2 command” in Command Reference
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
DB2DIR/instance/db2idrop InstName
Related tasks
Related reference
78 Getting started with DB2 installation and administration
Documentation feedback
Appendix E. DB2 Database technical information
Overview of the DB2 technical information
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
1P P/N CT3ZKNA
Part Number CT3ZKNA Printed in Ireland
GC10-4247-00
IBM DB2 DB2 Version
Getting started with DB2 installation and administration
Spine information