IBM VERSION 9 manual Basic administration, Creating your own database Database basics

Page 39

Chapter 5. Basic administration

Now that you have installed your DB2 product and verified its successful installation, you are ready to create your own database. The following sections will guide you through the steps of creating a new database that will take advantage of DB2 automatic maintenance features.

Creating your own database

Database basics

A relational database presents data as a collection of tables. A table consists of a defined set of columns and any number of rows. The data in each table is logically related, and relationships can be defined between tables. Data can be viewed and manipulated based on mathematical principles and operations called relations (such as, INSERT, SELECT, and UPDATE).

A database is self-describing in that it contains, in addition to data, a description of its own structure. It includes a set of system catalog tables, which describe the logical and physical structure of the data; a configuration file, which contains the parameter values associated with the database; and a recovery log, which records ongoing transactions and transactions that can be archived.

Databases can be local or remote. A local database is physically located on the workstation in use, while a database on another machine is considered remote.

You can:

vCreate a database using the Control Center

vAdd a database using the Control Center or Configuration Assistant

vDrop a database from the Control Center

vBackup a database using the Control Center

vRestore a database using the Control Center

vConfigure a database using the Control Center

vConnect to a database using the Control Center

vResolve database health alerts with the Health Center

Related concepts:

v“Getting started with the Configuration Assistant” on page 54

v“Getting started with the Control Center” on page 42

v“Getting started with the Health Center” on page 49

Related tasks:

v“Verifying your new database” on page 32

Creating your own database using the Create Database with the Automatic Maintenance wizard

The Create Database with Automatic Maintenance wizard is the quickest way to set up your own database. Based on basic information that you provide, the wizard:

© Copyright IBM Corp. 1993, 2006

31

Image 39
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 Installation prerequisites Disk and memory requirementsGetting started with database authorities Load authority in Administration Guide Implementation Additional client considerations Operating System Service Pack HardwareRelated reference Security issues when installing the DB2 database managerAdditional software considerations Related tasksInstallation prerequisites Unix platforms Prerequisites DB2 system administrator group considerations WindowsProcedure Granting user rights WindowsExtending the directory schema Windows Distribution Requirements Hardware Package requirements server onlyPackage name Description Software considerations DB2 product installation on NFS Network File SystemCentralized user-management considerations Linux Related reference Getting started with DB2 installation and administration Installation Installing DB2 servers WindowsRestrictions 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 license files DB2 product licensingLicense→Generate Compliance Report Checking DB2 license complianceUpgrading 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 Creating your own database Database basics Basic administrationVerifying your new database Control Center with a database selected Getting started with DB2 installation and administration Automatic database backup Automatic maintenanceAutomatic statistics collection Using automatic statistics collection in Performance Guide Getting started with DB2 installation and administration Control Center menu bars DB2 administration and development toolsBasic GUI navigation concepts Start MenuObject trees Contents Pane Details viewToolbars WizardsInfopops Object filteringGetting started with the Control Center Mandatory fieldsHelp Custom AdvancedControl Center advanced view with a table selected Control Center advanced view with a database selected To customize objects and actionsGetting started with the Command Editor Setting up notification and contact listsCommand Editor window To run commands and SQL statements Health Center window Getting started with the Health CenterGetting started with the Task Center Task Center window Getting started with the Journal Journal window Database HistoryDatabase History Getting started with the Configuration AssistantGetting started with the Replication Center Replication Center window Getting started with the Web Command CenterGetting started with the Web Health Center Related concepts Part 3. Appendixes Getting started with DB2 installation and administration Appendix A. Installing DB2 servers using response files Response file installation basicsResponse file considerations Creating a response file using the DB2 Setup wizard Encrypted = Daspassword Getting started with DB2 installation and administration Changing the DB2 interface language Windows Appendix B. Language supportChanging the DB2 interface language Linux Language Language identifier Supported DB2 interface languagesDisplaying the db2setup command in your national language Bourne sh, korn ksh, and bash shellsShell Appendix B. Language support Getting started with DB2 installation and administration Appendix C. Installing DB2 fix packs Procedure Related referenceApplying fix packs Getting started with DB2 installation and administration Add/Remove Programs Appendix D. Uninstalling your DB2 productUninstalling your DB2 product Windows Db2unins commandRelated reference Stopping DB2 instances Linux Stopping the DB2 administration server LinuxRemoving DB2 instances Linux Removing the DB2 administration server LinuxDb2idrop Remove instance command in Command Reference Getting started with DB2 installation and administration Appendix E. DB2 Database technical information Overview of the DB2 technical informationDocumentation feedback 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 tutorials DB2 troubleshooting informationTerms and Conditions Appendix F. Notices Canada Trademarks Getting started with DB2 installation and administration DB2 IndexDAS Page Getting started with DB2 installation and administration To learn more about DB2 products, go to Contacting IBMGetting 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.