Manuals
/
IBM
/
Kitchen Appliance
/
Frozen Dessert Maker
IBM
VERSION 9 manual Getting started with DB2 installation and administration
Models:
VERSION 9
1
46
109
109
Download
109 pages
12.57 Kb
43
44
45
46
47
48
49
50
<
>
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 46
Image 46
38
Getting started with DB2 installation and administration
Page 45
Page 47
Page 46
Image 46
Page 45
Page 47
Contents
DB2 Version
Getting started with DB2 installation and administration on Linux and
Windows
for Linux, UNIX, and Windows
Page
DB2 Version
Getting started with DB2 installation and administration on Linux and
Windows
for Linux, UNIX, and Windows
Edition Notice
Part 2. Getting started with DB2 administration
Contents
Part 1. Getting started with DB2 installation
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
Getting started with database authorities
Chapter 1. Installation prerequisites
Disk and memory requirements
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
Related concepts
Security issues when installing the DB2 database manager
Additional software considerations
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 “Authorization” in Administration Guide Planning
v “General naming rules” in Administration Guide Implementation
v “Authentication” in Administration Guide Planning
UNIX platforms
Procedure
DB2 system administrator group considerations Windows
Granting user rights Windows
Prerequisites
Related concepts
Extending the directory schema Windows
Procedure
Related reference
Related reference
Linux installation prerequisites
Installation requirements for DB2 clients and servers Linux
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
Related tasks
Centralized user-management considerations Linux
Related concepts
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
Procedure
Chapter 2. Installation
Installing DB2 servers Windows
Prerequisites
v Click Install New to create a newDB2 copy
Related tasks
Installing DB2 servers Linux
Related concepts
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
Prerequisites
Chapter 3. Verifying your installation
Procedure
Related tasks
Related reference
Verifying the installation using the command line processor CLP
Procedure
Prerequisites
v “License Center overview” in Administration Guide Implementation
Chapter 4. DB2 product licensing
DB2 product license files
v “DB2 installation methods” in Quick Beginnings for DB2 Servers
Procedure
Checking DB2 license compliance
v “License management” in Administration Guide Implementation
Related concepts
Procedure
Upgrading a Try and Buy license
v “License Center overview” in Administration Guide Implementation
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
Related concepts
Chapter 5. Basic administration
Creating your own database Database basics
Related tasks
Prerequisites
Verifying your new database
Procedure
Related concepts
Related tasks
v “Control Center overview” in Administration Guide Implementation
Related concepts
Figure 1. Control Center with a database selected
34 Getting started with DB2 installation and administration
Chapter 6. Automatic maintenance
Automatic database backup
v “Health monitor” in System Monitor Guide and Reference
Automatic statistics collection
Related concepts
Related reference
Related tasks
Chapter 6. Automatic maintenance
Related concepts
Related reference
38 Getting started with DB2 installation and administration
Start Menu
Chapter 7. DB2 administration and development tools
Basic GUI navigation concepts
Control Center menu bars
Toolbars
Contents Pane Details view
40 Getting started with DB2 installation and administration
Wizards
Object filtering
Figure 2. Contents Pane view
Infopops
Mandatory fields
Getting started with the Control Center
42 Getting started with DB2 installation and administration
Help
Advanced
Custom
v Configure and tune instances and databases
Related concepts
v “Control Center overview” in Administration Guide Implementation
To customize objects and actions
Figure 5. Control Center advanced view with a database selected
Procedure
Setting up notification and contact lists
Getting started with the Command Editor
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
Response file considerations
Appendix A. Installing DB2 servers using response files
Response file installation basics
Related concepts
Related concepts
Creating a response file using the DB2 Setup wizard
Procedure
Related tasks
Related tasks
DASPASSWORD = ENCRYPTED = DASPASSWORD
Appendix A. Installing DB2 servers using response files
Related reference
64 Getting started with DB2 installation and administration
Procedure
Appendix B. Language support
Changing the DB2 interface language Windows
Prerequisites
Prerequisites
Changing the DB2 interface language Linux
Procedure
Related tasks
Related reference
Supported DB2 interface languages
Related tasks
Language
bourne sh, korn ksh, and bash shells
Displaying the db2setup command in your national language
Related reference
C shell
v “Supported DB2 interface languages” on page
v “db2setup - Install DB2 command” in Command Reference
v “setup - Install DB2 command” in Command Reference
Appendix B. Language support
70 Getting started with DB2 installation and administration
Procedure
Appendix C. Installing DB2 fix packs
Applying fix packs
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
Procedure
Appendix D. Uninstalling your DB2 product
Uninstalling your DB2 product Windows
db2unins command
Related reference
Uninstalling your DB2 products Linux
Procedure
Prerequisites
Procedure
Stopping the DB2 administration server Linux
Stopping DB2 instances Linux
Procedure
v “DB2 Administration Server” in Administration Guide Implementation
Removing the DB2 administration server Linux
Removing DB2 instances Linux
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
Related tasks
DB2 technical library in hardcopy or PDF format
Related concepts
Related reference
Form Number
Table 4. DB2 technical information continued
Name
Available in print
Related tasks
Ordering printed DB2 books
Related concepts
Table 5. DB2 Connect-specific technical information continued
Procedure
Displaying SQL state help from the command line processor
Procedure
Related concepts
84 Getting started with DB2 installation and administration
Accessing different versions of the DB2 Information Center
Procedure
Related tasks
etc/init.d/db2icdv9 stop
Procedure
Related concepts
DB2 Information Center dir\doc\bin\helpstart.bat
Related tasks
86 Getting started with DB2 installation and administration
Related concepts
DB2 Information Center dir/doc/bin/helpstart
v “Visual Explain overview” in Administration Guide Implementation
DB2 troubleshooting information
DB2 tutorials
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
