Table Of Content!"#
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
Description:Getting started with the Web Health Center . 57. Part 3. For a complete look at the DB2 documentation library, see the DB2 Information. Center at .. v SUSE Linux Enterprise Server 9 (SLES9) Service Pack 2. To install a DB2
