1 / 22

DB2 (Express C Edition) Installation and Using a Database

DB2 (Express C Edition) Installation and Using a Database. Unit objectives. After completing this unit, you should understand: Steps to install DB2-Express C database. Use the Control Center to manage systems, DB2 instances, databases, database objects, and more.

gram
Download Presentation

DB2 (Express C Edition) Installation and Using a Database

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. DB2 (Express C Edition) Installation and Using a Database

  2. Unit objectives After completing this unit, you should understand: • Steps to install DB2-Express C database. • Use the Control Center to manage systems, DB2 instances, databases, database objects, and more. • Identify how the Configuration Assistant lets you maintain a list of databases to which your applications can connect, manage, and administer.

  3. Introduction to DB2 Express-C • DB2 Express-C data server software ("DB2 Express-C") is a member of the IBM DB2 family of powerful data server software for managing both relational and XML data. • DB2 Express-C is a free, no-limits, and easy to use edition of DB2. • The ‘C’ in DB2 Express-C stands for the Community. A community of DB2 Express-C users that bands together to assist each other, both online and offline. • You can download DB2 express edition from the following website: • http://www-01.ibm.com/software/data/db2/express/download.html

  4. Installation Prerequisites • DB2 Express-C is available on Linux®, Sun Solaris (x64), and Microsoft Windows® 2003, XP, and Vista. It is also available as a beta on Mac OS X. The processor architectures available are 32-bit, 64-bit and PowerPC (Linux). • For the latest information on DB2 Express-C hardware requirements, review the DB2 Express-C web page at http://www.ibm.com/software/data/db2/express/about.html • To install DB2 on Windows, you must have an operating system user with sufficient authority. • For Windows, the user account must belong to the Administrators group on the machine where you will perform the installation. • Alternatively, on Windows 2008, Windows Vista, or higher, a non-administrator can perform an installation, but will be prompted for administrative credentials by the DB2 Setup wizard.

  5. Installation requirements for DB2 • Before you install a DB2® database product on Windows operating systems, ensure that the system you choose meets the necessary operating system, hardware, and software requirements.

  6. Installation wizard • Although there are several methods to install DB2 Express-C, the easiest method is to use the GUI-based DB2 Installation wizard. • After downloading and uncompressing the DB2 Express-C image, you can launch the wizard as follows: • Execute the setup.exe file located in the EXP/image/directory • DB2 Express-C is straightforward to install by following the instructions in the DB2 installation wizard. • In most cases, the default settings are sufficient, so all you need to do is accept the license, click the Nextbutton until the “Finish” button is active, and then click the Finishbutton. • After a few minutes, your installation is complete and DB2 will be up and running.

  7. Steps for installation DB2 • After run setup.exe, the DB2 Setup Launchpad will display. Click on Install a Productand then choose Install New to install a new copy of DB2 Express-C on your system

  8. After accepting the license, it is usually sufficient to choose the “Typical” installation

  9. In the next step, Choosing “Install IBM DB2 Express Edition on this computer”

  10. Then, select directory to install DB2

  11. When you arrive at the following panel,you will need to type in a user ID which will be used to setup and run the instance and other services. • The default user ID name is db2admin, enter password for db2admin

  12. Then, click next after the following window appeared

  13. Finally, the installation wizard displays a summary of what will be installed, and the different configuration values provided in the previous steps. When you click the “Finish” button, the installation begins, and the program files will be laid down on your system.

  14. After click “install” button, it will display the following windows • After finished installation, click next button

  15. When the installation completes, the following window appears, informing you of the results of the installation wizard process, as well as any further steps that are required to complete your installation. Click “Finish” button.

  16. After you click “Finish” in the installation results window will display as following. • Note: If you install DB2 Express-C it will automatically created a sample database

  17. Validating your installation • After installing DB2, you can run three commands from the DB2 Command Window to verify that your installation is in good shape: • db2level: This command displays information about the DB2 product installed, fix pack level, and other details. • db2licm -l: This command lists all the licensing information specific to your installed DB2 products • db2val: This is a new command available in DB2 9.7. It validates your installation by verifying the core functionality of your DB2 copy. It makes sure your instances are consistent, and that database creation and database connections work

  18. The following window provides an example of the output of these three commands.

  19. DB2 command editor • To run DB2 command editor click, <Start>/<All Program>/<IBM DB2>/<DB2COPY1>/<General Administrator>/<Control Centre> • Then, click ‘Advanced’

  20. Control Center • After that Control Center window will display. Contents Pane Object Tree Pane Object Detail Pane

  21. SQL Assist Command Editor: to type SQL command

  22. Exercise • In this exercise, you will install DB2 Express-C and create the SAMPLE database • Objective • Before you can begin exploring all the features and tools that come with DB2 Express-C, you must first install it on your system. • In this exercise, you will perform a basic installation of DB2 Express-C on Windows. • Refer file Ex0-Installation DB2

More Related