HP 3000 Manuals HP 3000 Manuals
E : Configuring Databases Your first task is to configure the database named SAMPL2, which you'll find listed on Worksheet 1 (Figure 2-2). SAMPL2 contains datasets of information you want to make available to PC users. You must tell Access Server where to find that database. Defining the database in the data dictionary is the first step in making the dataset information accessible to PC users. Although the recommended configuration sequence begins with remote systems, you'll skip this because SAMPL2 is on the host system. Here's what the system will look like when you configure database SAMPL2 into Information Access Server:Figure 2-6. SAMPL2 Database Added ___________________________________________________________ | | | References in this Learning manual: | | Lesson 1:D, How the Data Dictionary is Configured| | Appendix B, Schema for SAMPL2 Database | | | | References in Information Access Server: Database | | Administration: | | Chapter 2, Getting Started: | | How to Use the Screens | | Configuration Main Menu | | Chapter 4, Configuring Data Sources: | | Data Sources Menu | | Defining Databases on the HP 3000 | | Adding a Database | ___________________________________________________________ Using the Menu Path--------------------------------------------------------------------------------------------- | | | | What You Do | What Happens | | | | --------------------------------------------------------------------------------------------- | | | | You configure databases at the Add IMAGE | | | Database screen. | | | | | | To get a feel for how the Administrator | | | Utility is organized, use the menu path | | | pictured above to go to that screen in four | | | steps: | | | | | | E-1. First, choose function label: | Choosing Config f1 tells the | | | Administrator Utility you want to configure | | Config f1 | something. The Configuration Main Menu | | | appears on the terminal. | | | | | E-2. Then, choose: | The Data Sources Menu appears. Here you | | | can choose one of two operations to | | Data f2 | perform. | | Sources | | | | | | E-3. Next, choose: | The IMAGE Database Menu appears. Here you | | | can choose one of five operations. | | IMAGE f1 | | | Database | | | | | | E-4. Finally, choose: | The Add IMAGE Database screen appears. | | | Here you identify the database you're | | Add f1 | interested in. (The database is listed in | | Database | the DATABASE or FILE column of Worksheet 1, | | | shown in Figure 2-2.) | | | | --------------------------------------------------------------------------------------------- Adding a Database --------------------------------------------------------------------------------------------- | | | | What You Do | What Happens | | | | --------------------------------------------------------------------------------------------- | | | | E-5. Type the database name, group, and | | | account into the first three fields, | | | tabbing as required (the periods are | | | provided for you): | | | | | | SAMPL2.PPCDICT.HPOFFICE | | | | | | Tab over the HP 3000 Systems field. Type | | | MGR (all uppercase) for the Database | | | Password. Leave the default Open Mode. | | | | | | Check your entries carefully, then press | The screen clears. You have configured the | | Enter. | database SAMPL2. | | | | | | Requests for information from this database | | | will be governed by an open mode of 5, | | | which allows shared read access with other | | | applications running with an open mode of 1 | | | or 5. | | | | ---------------------------------------------------------------------------------------------
NOTE If a message appears saying that SAMPL2 is already configured, the UDC TUTORIAL was not issued to delete the setup from a previous lesson taker. Go to Lesson 6 and follow the instructions to run TUTORIAL. Then return to Step D-1 in this lesson to continue.
--------------------------------------------------------------------------------------------- | | | | What You Do | What Happens | | | | --------------------------------------------------------------------------------------------- | | | | If you wanted to derive a table from a | | | dataset in another database, for example | | | SAMPL1, you could do so now. However, you | | | need only one database for this lesson. | | | | | | To configure tables, return to the | | | Configuration Main Menu in three steps: | | | | | | E-6. Return to the previous menu by | The IMAGE Database Menu appears. | | choosing: | | | | | | Done f8 | | | | | | | | --------------------------------------------------------------------------------------------- | | | | E-7. Step back one more menu by choosing: | The Data Sources Menu appears. | | | | | | | | Done f8 | | | | | | | | | E-8. Step back yet another menu by | The Configuration Main Menu appears. | | choosing: | | | | You have configured a database and are | | Done f8 | ready for the next task. | | | | | | | ---------------------------------------------------------------------------------------------
![[]](../../pic3k/M012040/FFN243c50.gif)
![[]](../../pic3k/M012040/FFN263c50.gif)