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 104

96Getting started with DB2 installation and administration

Image 104

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. AppendixesContacting IBM Appendix F. NoticesIndex 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 requirementsRelated concepts v “LOAD authority” in Administration Guide Implementation4 Getting started with DB2 installation and administration Additional client considerations Windows installation prerequisitesInstallation requirements for DB2 clients and servers Windows 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 onlyPackage requirements for Red Hat 12 Getting started with DB2 installation and administrationPackage requirements for SUSE Linux 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 referencecd /cdrom Procedure20 Getting started with DB2 installation and administration Related reference Related conceptsRelated tasks 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 WizardsInfopops Figure 2. Contents Pane viewObject filtering 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 administrationFigure 7. Health Center window Getting started with the Health CenterRelated concepts Related concepts Getting started with the Task Center50 Getting started with DB2 installation and administration For each task, you can do the following v Schedule the task Related concepts Getting started with the Journal52 Getting started with DB2 installation and administration Database History Figure 10. Database History Getting started with the Configuration AssistantRelated concepts Getting started with the Replication Center Related conceptsFigure 11. Replication Center window Getting started with the Web Command CenterRelated concepts Related tasks Getting started with the Web Health CenterRelated concepts Related tasks 58 Getting started with DB2 installation and administrationRelated concepts 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 Prerequisites72 Getting started with DB2 installation and administration v “db2setup - Install DB2 command” in Command Referencev “setup - Install DB2 command” in Command Reference 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 ProcedureDB2DIR/instance/db2idrop InstName Related tasksRelated reference 78 Getting started with DB2 installation and administration Documentation feedback Appendix E. DB2 Database technical informationOverview of the DB2 technical information 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 1P P/N CT3ZKNA Part Number CT3ZKNA Printed in IrelandGC10-4247-00 IBM DB2 DB2 Version Getting started with DB2 installation and administrationSpine information