IBM VERSION 9 manual Getting started with DB2 installation and administration

Page 26

If you have at least one existing DB2 product installed on your computer, you can:

vClick Install New to create a newDB2 copy

vClick Work with Existing to upgrade an existing DB2 copy, to add functionality to an existing DB2 copy, or to install an add-on product.

vClick Migrate to migrate an existing DB2 Version 8 copy.

5.The DB2 Setup wizard will determine the system language, and launch the setup program for that language. Online help is available to guide you through the remaining steps. To invoke the online help, click Help or press F1. You can click Cancel at any time to end the installation.

Your DB2 product will be installed, by default, in the x:\Program Files\IBM\sqllib directory, where x: represent the drive letter of the drive where you have installed your DB2 product.

If you are installing on a system where this directory is already being used, the DB2 product installation path will have _xx added to it, where _xx are digits, starting at 01 and increasing depending on how many DB2 copies you have installed.

You can also specify your own DB2 product installation path.

For information on errors encountered during installation, review the installation log file located in the My Documents\DB2LOG\ directory. The log file uses the following format: DB2-ProductAbrrev-DateTime.log, for example, DB2-ESE-Tue Apr 04 17_04_45 2006.log.

If you want your DB2 product to have access to DB2 documentation either on your local computer or on another computer on your network, then you must install the DB2 Information Center. TheDB2 Information Center contains documentation for the DB2 database system and DB2 related products. By default, DB2 information will be accessed from the web if the DB2 Information Center is not locally installed.

DB2 Express memory limits and the DATABASE_MEMORY configuration parameter:

If you are installing DB2 Express Edition or DB2 Express-C Edition on a system that has more memory than the maximum memory limit of 4GB, as outlined in the terms and conditions of the product, you need to explicitly set the DATABASE_MEMORY configuration parameter to 4GB or less, so that the Self Tuning Memory Manager will work within your licensed memory limits.

Note: If you have more than one database on that server, the sum of all database memory usage cannot exceed 4GB.

You can use the Control Center or the UPDATE DATABASE CONFIGURATION command to make this change. For example, to set the DATABASE_MEMORY limit to 4GB, enter the following command:

DB2 UPDATE DATABASE CONFIGURATION using DATABASE_MEMORY 1000000 IMMEDIATE; CONNECT RESET;

Also, when using the Configuration Advisor to assist you in configuring the performance of your database, you need to set the Target Memory on the Server page to a percentage of your total system memory that will ensure you stay under the 4GB memory limit.

18Getting started with DB2 installation and administration

Image 26
Contents DB2 Page DB2 Edition Notice Contents Appendix F. Notices About this book Vi Getting started with DB2 installation and administration Part 1. Getting started with DB2 installation Getting started with DB2 installation and administration Getting started with database authorities Installation prerequisitesDisk and memory requirements Load authority in Administration Guide Implementation Operating System Service Pack Hardware Additional client considerationsRelated tasks Security issues when installing the DB2 database managerAdditional software considerations Related referenceInstallation prerequisites Unix platforms Granting user rights Windows DB2 system administrator group considerations WindowsProcedure PrerequisitesExtending the directory schema Windows Package requirements server only Distribution Requirements HardwarePackage name Description DB2 product installation on NFS Network File System Software considerationsCentralized user-management considerations Linux Related reference Getting started with DB2 installation and administration Restrictions InstallationInstalling DB2 servers Windows Getting started with DB2 installation and administration Installing DB2 servers Linux Cd /cdrom Related concepts Getting started with DB2 installation and administration Verifying your installation Db2fs First steps command in Command Reference DB2 product licensing DB2 product license filesChecking DB2 license compliance License→Generate Compliance ReportUpgrading a Try and Buy license Getting started with DB2 installation and administration Part 2. Getting started with DB2 administration Getting started with DB2 installation and administration Basic administration Creating your own database Database basicsVerifying your new database Control Center with a database selected Getting started with DB2 installation and administration Automatic maintenance Automatic database backupAutomatic statistics collection Using automatic statistics collection in Performance Guide Getting started with DB2 installation and administration Start Menu DB2 administration and development toolsBasic GUI navigation concepts Control Center menu barsWizards Contents Pane Details viewToolbars Object treesObject filtering InfopopsHelp Getting started with the Control CenterMandatory fields Advanced CustomControl Center advanced view with a table selected To customize objects and actions Control Center advanced view with a database selectedSetting up notification and contact lists Getting started with the Command EditorCommand Editor window To run commands and SQL statements Getting started with the Health Center Health Center windowGetting started with the Task Center Task Center window Getting started with the Journal Database History Journal windowGetting started with the Configuration Assistant Database HistoryGetting started with the Replication Center Getting started with the Web Command Center Replication Center windowGetting started with the Web Health Center Related concepts Part 3. Appendixes Getting started with DB2 installation and administration Response file considerations Appendix A. Installing DB2 servers using response filesResponse file installation basics Creating a response file using the DB2 Setup wizard Encrypted = Daspassword Getting started with DB2 installation and administration Appendix B. Language support Changing the DB2 interface language WindowsChanging the DB2 interface language Linux Supported DB2 interface languages Language Language identifierShell Displaying the db2setup command in your national languageBourne sh, korn ksh, and bash shells Appendix B. Language support Getting started with DB2 installation and administration Applying fix packs Appendix C. Installing DB2 fix packsProcedure Related reference Getting started with DB2 installation and administration Db2unins command Appendix D. Uninstalling your DB2 productUninstalling your DB2 product Windows Add/Remove ProgramsRelated reference Stopping the DB2 administration server Linux Stopping DB2 instances LinuxRemoving the DB2 administration server Linux Removing DB2 instances LinuxDb2idrop Remove instance command in Command Reference Getting started with DB2 installation and administration Documentation feedback Appendix E. DB2 Database technical informationOverview of the DB2 technical information Name Form Number Available in print DB2 Connect-specific technical information Ordering printed DB2 books Displaying SQL state help from the command line processor Accessing different versions of the DB2 Information Center On Linux, enter the following command Restart the DB2 Information Center service DB2 troubleshooting information DB2 tutorialsTerms and Conditions Appendix F. Notices Canada Trademarks Getting started with DB2 installation and administration Index DB2DAS Page Getting started with DB2 installation and administration Contacting IBM To learn more about DB2 products, go toGetting started with DB2 installation and administration Page Part Number CT3ZKNA Spine information

VERSION 9 specifications

IBM VERSION 9 is a significant advancement in IBM's product line, boasting a range of features and technologies designed to enhance performance, security, and usability in enterprise environments. This version marks a pivotal shift, focusing on integrating artificial intelligence, cloud computing, and advanced data analytics into its core functionalities.

One of the standout features of IBM VERSION 9 is its enhanced artificial intelligence capabilities. With built-in AI tools, users can leverage machine learning algorithms and natural language processing to automate tasks, gain insights from data, and improve decision-making processes. These capabilities are not only geared towards data scientists but are also accessible to business analysts who may not possess deep technical skills, thereby democratizing access to AI-driven analytics.

Another defining characteristic is the robust cloud integration. IBM VERSION 9 seamlessly supports hybrid cloud architectures, allowing organizations to operate across private and public cloud environments with ease. This flexibility enables businesses to optimize their resources, manage workloads more efficiently, and ensure data is stored and processed in the most suitable environment. Enhanced security protocols and data encryption mechanisms further ensure that sensitive information remains protected both on-premises and in the cloud.

The release also emphasizes improved performance optimizations, utilizing cutting-edge technologies such as in-memory computing and parallel processing. These enhancements result in faster data processing speeds and reduced latency, ultimately leading to improved user experiences across applications. Additionally, the system supports a variety of programming languages, allowing developers to use their preferred tools while building applications that harness the full potential of IBM VERSION 9.

User experience is another area that received attention in this version. The interface has been streamlined and made more intuitive, enabling users to navigate through features and functionalities easily. Training resources and documentation have also been improved, providing comprehensive support to ensure users can maximize the capabilities of IBM VERSION 9 without steep learning curves.

In summary, IBM VERSION 9 brings together a suite of advanced features, including enhanced AI capabilities, robust cloud integration, improved performance, and a user-friendly interface, making it a powerful tool for modern enterprises seeking to harness technology for competitive advantage. With these innovations, IBM continues to position itself as a leader in the tech industry, addressing the evolving needs of businesses worldwide.