DB2® Getting started with DB2 installation and administration on Linux and Windows

109 Pages·2011·1.2 MB·English

!"#
DB2
®
DB2Version9

forLinux,UNIX,andWindows

GettingstartedwithDB2installationandadministrationonLinuxand

Windows

GC10-4247-00

!"#
DB2
®
DB2Version9

forLinux,UNIX,andWindows

GettingstartedwithDB2installationandadministrationonLinuxand

Windows

GC10-4247-00
Beforeusingthisinformationandtheproductitsupports,besuretoreadthegeneralinformationunderNotices.

EditionNotice

ThisdocumentcontainsproprietaryinformationofIBM.Itisprovidedunderalicenseagreementandisprotected

bycopyrightlaw.Theinformationcontainedinthispublicationdoesnotincludeanyproductwarranties,andany

statementsprovidedinthismanualshouldnotbeinterpretedassuch.

YoucanorderIBMpublicationsonlineorthroughyourlocalIBMrepresentative.

v Toorderpublicationsonline,gototheIBMPublicationsCenteratwww.ibm.com/shop/publications/order

v TofindyourlocalIBMrepresentative,gototheIBMDirectoryofWorldwideContactsatwww.ibm.com/

planetwide
ToorderDB2publicationsfromDB2MarketingandSalesintheUnitedStatesorCanada,call1-800-IBM-4YOU

(426-4968).

WhenyousendinformationtoIBM,yougrantIBManonexclusiverighttouseordistributetheinformationinany

wayitbelievesappropriatewithoutincurringanyobligationtoyou.

©CopyrightInternationalBusinessMachinesCorporation1993,2006.Allrightsreserved.

USGovernmentUsersRestrictedRights–Use,duplicationordisclosurerestrictedbyGSAADPScheduleContract

withIBMCorp.
Contents

About this book . . . . . . . . . . . v Automaticdatabasebackup . . . . . . . . . 35

Automaticstatisticscollection . . . . . . . . 36

Part 1. Getting started with DB2
Chapter7. DB2 administration and
installation . . . . . . . . . . . . . 1
development tools. . . . . . . . . . 39

BasicGUInavigationconcepts . . . . . . . . 39
Chapter1. Installation prerequisites. . . 3
GettingstartedwiththeControlCenter . . . . . 42
Diskandm em oryrequireme nts . . . . . . . . 3 Setting upnotif icatio na ndconta ctlists . . . . . 46
Getti ngs tartedwi thdatabaseau t hor itie s . . . . . 3 Getting sta rtedwithth eCo mmand Edi to r . . . . 46
Window sinstal lation prerequ isites . . . . . . . 5 Getting started with the HealthCen ter . . . . . 49
Installa tionrequire mentsforDB 2 cli ent sa nd Getting started with the TaskC enter . . . . . . 50
servers(Wi ndows) . . . . . . . . . . . 5 Getting started with the Journ al . . . . . . . 52
Security issueswhe n ins tall ing th eD B2 da tab ase Getting started with the Configu rat ion As sis tan t . . 54
manager . . . . . . . . . . . . . . . 6 Getting started with the ReplicationCe nter. . . . 55
Granting u se rri gh ts( Wi ndo ws ) . . . . . . . 9 Getting started with the WebComm andCe n ter . . 56
DB2syste mad minis tratorgroup con sid era tio ns Getting started with the Web HealthCen ter . . . 57
(Win dows) . . . . . . . . . . . . . . 9

Extendingthedirectoryschema(Windows). . . 10
Part 3. Appendixes. . . . . . . . . 59
Linuxinstallationprerequisites . . . . . . . . 11

InstallationrequirementsforDB2clientsand
servers(Lin ux) . . . . . . . . . . . . 11 AppendixA. Installing DB2 servers

Centralizeduser-managementconsiderations using response files. . . . . . . . . 61

(Linux). . . . . . . . . . . . . . . 14 Responsefileinstallationbasics. . . . . . . . 61

Responsefileconsiderations. . . . . . . . . 61
Chapter2. Installation . . . . . . . . 17 Creatinga res ponsefileusin g th eD B2 Se tup w iza rd 62

InstallingDB2servers(Windows) . . . . . . . 17

InstallingDB2servers(Linux) . . . . . . . . 19 AppendixB. Language support . . . . 65

ChangingtheDB2interfacelanguage(Windows). . 65
Chapter3. Verifying your installation 23 Changing the DB2 interface language (Linux) . . . 66

VerifyingtheinstallationofDB2serversusingFirst SupportedDB2interfacelanguages . . . . . . 67

Steps(LinuxandWindows) . . . . . . . . . 23 LanguageidentifiersforrunningtheDB2Setup

Verifyingtheinstallationusingthecommandline wizardinanotherlanguage . . . . . . . . . 67

processor(CLP) . . . . . . . . . . . . . 24 Displayingthedb2setupcommandinyournational

language . . . . . . . . . . . . . . . 68

Chapter4. DB2 product licensing . . . 25
AppendixC. Installing DB2 fix packs 71
DB2productlicensefiles . . . . . . . . . . 25

RegisteringaDB2productorfeaturelicensekey Applyingfixpacks. . . . . . . . . . . . 71

usingtheLicenseCenter . . . . . . . . . . 25

CheckingDB2licensecompliance . . . . . . . 26 AppendixD. Uninstalling your DB2

UpgradingaTryandBuylicense . . . . . . . 27 product . . . . . . . . . . . . . . 73

UninstallingyourDB2product(Windows) . . . . 73
Part 2. Getting started with DB2 Uninstalling your DB2 products (Linux). . . . . 74

administration. . . . . . . . . . . 29 RemovingDB2productsusingthedb2_deinstall

ordoce_deinstallcommand(Linux) . . . . . 74

StoppingDB2instances(Linux). . . . . . . 75
Chapter5. Basic administration . . . . 31
StoppingtheDB2administrationserver(Linux) 75
Creatingyourowndatabase. . . . . . . . . 31 Removing th eDB 2administration serve r(Linux ) 76
Datab aseb asics . . . . . . . . . . . . 31 Removing DB2 inst ances(Linux) . . . . . . 76
Creating youro w nd ata ba seu sin g the Cr eat e

DatabasewiththeAutomaticMaintenance
AppendixE. DB2 Database technical

wizard . . . . . . . . . . . . . . . 31
information. . . . . . . . . . . . . 79
Verifyingyournewdatabase . . . . . . . 32
OverviewoftheDB2technicalinformation. . . . 79

Documentationfeedback . . . . . . . . . 79
Chapter6. Automatic maintenance. . . 35

DB2technicallibraryinhardcopyorPDFformat. . 80

©CopyrightIBMCorp.1993,2006 iii
OrderingprintedDB2books. . . . . . . . . 82 DB2troubleshootinginformation . . . . . . . 87

DisplayingSQLstatehelpfromthecommandline TermsandConditions. . . . . . . . . . . 88

processor . . . . . . . . . . . . . . . 83

AccessingdifferentversionsoftheDB2Information AppendixF. Notices . . . . . . . . . 89
Center . . . . . . . . . . . . . . . . 84 Trademarks . . . . . . . . . . . . . . 91
Display in g top ics in you rp re ferr ed lan gu ag ein th e

DB2InformationCenter . . . . . . . . . . 84
Index . . . . . . . . . . . . . . . 93

UpdatingtheDB2InformationCenterinstalledon

yourcomputerorintranetserver . . . . . . . 85
Contacting IBM . . . . . . . . . . . 97
DB2tutorials. . . . . . . . . . . . . . 87

iv GettingstartedwithDB2installationandadministration
About this book

This book provides information on how to install your DB2® product. It also

introduces DB2 maintenance, administration, and development.

For a complete look at the DB2 documentation library, see the DB2 Information

Center at http://publib.boulder.ibm.com/infocenter/db2help/.

©CopyrightIBMCorp.1993,2006 v
vi GettingstartedwithDB2installationandadministration
Part 1. Getting started with DB2 installation

©CopyrightIBMCorp.1993,2006 1
2 GettingstartedwithDB2installationandadministration