Manuals / IBM / Kitchen Appliance / Frozen Dessert Maker

IBM VERSION 9 manual Getting started with DB2 installation and administration

Models: VERSION 9

1 109

Download 109 pages 12.57 Kb

Page 24

16Getting started with DB2 installation and administration

Image 24

IBM VERSION 9 manual Getting started with DB2 installation and administration

Contents

Getting started with DB2 installation and administration on Linux and WindowsDB2 Version for Linux, UNIX, and WindowsPage Getting started with DB2 installation and administration on Linux and WindowsDB2 Version for Linux, UNIX, and WindowsEdition Notice Contents Part 1. Getting started with DB2 installationPart 2. Getting started with DB2 administration Part 3. AppendixesAppendix F. Notices IndexContacting IBM About this book vi Getting started with DB2 installation and administration Part 1. Getting started with DB2 installation Copyright IBM Corp. 19932 Getting started with DB2 installation and administration Chapter 1. Installation prerequisites Disk and memory requirementsGetting started with database authorities Disk requirementsv “LOAD authority” in Administration Guide Implementation 4 Getting started with DB2 installation and administrationRelated concepts Windows installation prerequisites Installation requirements for DB2 clients and servers WindowsAdditional client considerations Security issues when installing the DB2 database manager Additional software considerationsRelated concepts Related tasksprogram 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 Planningv “Authorization” in Administration Guide Planning UNIX platformsDB2 system administrator group considerations Windows Granting user rights WindowsProcedure PrerequisitesExtending the directory schema Windows ProcedureRelated concepts Related referenceLinux installation prerequisites Installation requirements for DB2 clients and servers LinuxRelated reference Package requirements server only12 Getting started with DB2 installation and administration Package requirements for SUSE LinuxPackage requirements for Red Hat DB2 product installation on NFS Network File System Software considerationsCentralized user-management considerations Linux Related conceptsRelated tasks Related referencev “Installation requirements for DB2 clients and servers AIX” in Quick Beginnings for DB2 Servers Related reference16 Getting started with DB2 installation and administration Chapter 2. Installation Installing DB2 servers WindowsProcedure Prerequisitesv Click Install New to create a newDB2 copy Installing DB2 servers Linux Related conceptsRelated tasks Related referenceProcedure 20 Getting started with DB2 installation and administrationcd /cdrom Related concepts Related tasksRelated reference 22 Getting started with DB2 installation and administration Chapter 3. Verifying your installation ProcedurePrerequisites Related tasksVerifying the installation using the command line processor CLP ProcedureRelated reference PrerequisitesChapter 4. DB2 product licensing DB2 product license filesv “License Center overview” in Administration Guide Implementation v “DB2 installation methods” in Quick Beginnings for DB2 ServersChecking DB2 license compliance v “License management” in Administration Guide ImplementationProcedure Related conceptsUpgrading a Try and Buy license v “License Center overview” in Administration Guide ImplementationProcedure v “License Center overview” in Administration Guide Implementation28 Getting started with DB2 installation and administration Part 2. Getting started with DB2 administration Copyright IBM Corp. 199330 Getting started with DB2 installation and administration Chapter 5. Basic administration Creating your own database Database basicsRelated concepts Related tasksVerifying your new database ProcedurePrerequisites Related conceptsv “Control Center overview” in Administration Guide Implementation Related conceptsRelated tasks Figure 1. Control Center with a database selected34 Getting started with DB2 installation and administration Chapter 6. Automatic maintenance Automatic database backupAutomatic statistics collection Related conceptsv “Health monitor” in System Monitor Guide and Reference Related referenceChapter 6. Automatic maintenance Related conceptsRelated tasks Related reference38 Getting started with DB2 installation and administration Chapter 7. DB2 administration and development tools Basic GUI navigation conceptsStart Menu Control Center menu barsContents Pane Details view 40 Getting started with DB2 installation and administrationToolbars WizardsFigure 2. Contents Pane view Object filteringInfopops Getting started with the Control Center 42 Getting started with DB2 installation and administrationMandatory fields HelpAdvanced Customv Configure and tune instances and databases v “Control Center overview” in Administration Guide Implementation To customize objects and actionsRelated concepts Figure 5. Control Center advanced view with a database selectedSetting up notification and contact lists Getting started with the Command EditorProcedure Related referencev Work with query results To run commands and SQL statements 48 Getting started with DB2 installation and administrationGetting started with the Health Center Related conceptsFigure 7. Health Center window Getting started with the Task Center 50 Getting started with DB2 installation and administrationRelated concepts For each task, you can do the following v Schedule the task Getting started with the Journal 52 Getting started with DB2 installation and administrationRelated concepts Database History Getting started with the Configuration Assistant Related conceptsFigure 10. Database History Getting started with the Replication Center Related conceptsGetting started with the Web Command Center Related conceptsFigure 11. Replication Center window Getting started with the Web Health Center Related conceptsRelated tasks 58 Getting started with DB2 installation and administration Related conceptsRelated tasks Part 3. Appendixes Copyright IBM Corp. 199360 Getting started with DB2 installation and administration Appendix A. Installing DB2 servers using response files Response file installation basicsResponse file considerations Related conceptsCreating a response file using the DB2 Setup wizard ProcedureRelated concepts Related tasksDASPASSWORD = ENCRYPTED = DASPASSWORD Appendix A. Installing DB2 servers using response filesRelated tasks Related reference64 Getting started with DB2 installation and administration Appendix B. Language support Changing the DB2 interface language WindowsProcedure PrerequisitesChanging the DB2 interface language Linux ProcedurePrerequisites Related tasksSupported DB2 interface languages Related tasksRelated reference LanguageDisplaying the db2setup command in your national language Related referencebourne sh, korn ksh, and bash shells C shellv “db2setup - Install DB2 command” in Command Reference v “setup - Install DB2 command” in Command Referencev “Supported DB2 interface languages” on page Appendix B. Language support70 Getting started with DB2 installation and administration Appendix C. Installing DB2 fix packs Applying fix packsProcedure Prerequisitesv “db2setup - Install DB2 command” in Command Reference v “setup - Install DB2 command” in Command Reference72 Getting started with DB2 installation and administration Appendix D. Uninstalling your DB2 product Uninstalling your DB2 product WindowsProcedure db2unins commandUninstalling your DB2 products Linux ProcedureRelated reference PrerequisitesStopping the DB2 administration server Linux Stopping DB2 instances LinuxProcedure ProcedureRemoving the DB2 administration server Linux Removing DB2 instances Linuxv “DB2 Administration Server” in Administration Guide Implementation ProcedureRelated tasks Related referenceDB2DIR/instance/db2idrop InstName 78 Getting started with DB2 installation and administration Appendix E. DB2 Database technical information Overview of the DB2 technical informationDocumentation feedback DB2 technical library in hardcopy or PDF format Related conceptsRelated tasks Related referenceTable 4. DB2 technical information continued NameForm Number Available in printOrdering printed DB2 books Related conceptsRelated tasks Table 5. DB2 Connect-specific technical information continuedDisplaying SQL state help from the command line processor ProcedureProcedure Related conceptsAccessing different versions of the DB2 Information Center Procedure84 Getting started with DB2 installation and administration Related tasksProcedure Related conceptsetc/init.d/db2icdv9 stop DB2 Information Center dir\doc\bin\helpstart.bat86 Getting started with DB2 installation and administration Related conceptsRelated tasks DB2 Information Center dir/doc/bin/helpstartDB2 troubleshooting information DB2 tutorialsv “Visual Explain overview” in Administration Guide Implementation Before you beginTerms and Conditions 88 Getting started with DB2 installation and administrationAppendix 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 to98 Getting started with DB2 installation and administration Page Part Number CT3ZKNA Printed in Ireland GC10-4247-001P P/N CT3ZKNA Getting started with DB2 installation and administration Spine informationIBM DB2 DB2 Version