Share
Explore BrainMass

Relational Data Model (case 2)

Install DB2 Express-C, create the SAMPLE database, and validate your installation, following the detailed installation instructions in Chapter 3 of the DB2 book. Write a short paper describing the following:

Your experience with the installation.
Open the Control Center and the SAMPLE database, make screen shots of the database and copy them into your paper;
Open the SAMPLE database and its Tables folder, describe what information you see there, using the terms introduced in this module, such as table, schema and key. Describe the EMPLOYEE and EMP_PHOTO tables in detail.

Solution Preview

See the attached file.

Subject Category: Computer Science / Computing and Communications Software
Date of Response: 09/01/2011
Keywords: Database, Installation, IBM DB2, DB2 Express-C, SAMPLE Database, Install Validation, db2level, Database Administration

Page Title: Installing DB2 Express-C and Validate Install

Solution Abstract: The goal of this solution is to show the student how the install process behaves in relation to Vendor Instructions and the resolution pathways they should take to validate and diagnose Install related issues. The solution also shows the student what the DB2 Control center should look like and how some of the information is organized in the Control Center's views.

Description: The solution is comprised of a Microsoft Word document The document 421855Express-C Install.docx is attached.

Attachment Description: Microsoft Word 2007 document 421855Express-C Install.docx. In line solution also contains step by step explanation.

Brief Description:
Install DB2 Express-C, create the SAMPLE database, and validate your installation, following the detailed installation instructions in Chapter 3 of the DB2 book.

Full Problem Description:
Relational Data Model (case 2)
Install DB2 Express-C, create the SAMPLE database, and validate your installation, following the detailed installation instructions in Chapter 3 of the DB2 book. Write a short paper describing the following:

Your experience with the installation.
Open the Control Center and the SAMPLE database, make screen shots of the database and copy them into your paper;
Open the SAMPLE database and its Tables folder, describe what information you see there, using the terms introduced in this module, such as table, schema and key. Describe the EMPLOYEE and EMP_PHOTO tables in detail.
Solution Description:

Experience with the installation:
The download and the install ran smoothly as expected after watching the video: http://www.channeldb2.com/video/video/show?id=807741:Video:4442
and also the Install Video:
"Lunch with DB2" Series Installation 1: http://www.channeldb2.com/video/video/show?id=807741%3AVideo%3A2562

To make sure that the install proceeds as planned make sure that the system login has Administrative privileges.
The install runs like any other install with approving the license agreement, selecting an install type typical, limited, custom [selected typical], then moves to a unique option set:
a) Install exp C on this computer
b) Save my installation settings in a response file - No software will be installed on this computer
c) Install DB2 Express C on this computer and save my settings ina response file

[Selected option c)] Reponse file name: C:usersmyUserDocumentsPROD_EXPC.rsp
The install then opens dialog to select which folder. [Selected the default option C:Program FilesIBMSQLLIB
Then the install asks for setup on the user information for the DB2 Administration Server. The DB2 Admin Server (DAS) runs on your computer to provide support required by the DB2 tools. Specify the required user information for the DAS. It is highly recommended that you use a local user or a domain user account instead of the LocalSystem account. Further details are available by clicking Help.
[Selected Local User - No Domain - Username: xxxxxxxxxxxx9999 pwd: xxxxx999xxxxx
Next dialog configures the instances, select default by clicking Next
Next dialog is Configure DB2 instance authority groups. Local is preselected with the authority group name already assigned: instauthgroup0
Click Next
Next dialog Start copying files and create response file lists the current settings and features as follows:
Product to install: DB2 Express-C - DB2COPY1
Installation type: ...

Solution Summary

The solution discusses the Relational Data Model for a case.

$2.19