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