Fujitsu J2X0-2273-01EN user manual

User manual for the device Fujitsu J2X0-2273-01EN

Device: Fujitsu J2X0-2273-01EN
Category: Server
Manufacturer: Fujitsu
Size: 13.16 MB
Added : 11/5/2013
Number of pages: 225
Print the manual

Download

How to use this site?

Our goal is to provide you with a quick access to the content of the user manual for Fujitsu J2X0-2273-01EN. Using the online preview, you can quickly view the contents and go to the page where you will find the solution to your problem with Fujitsu J2X0-2273-01EN.

For your convenience

If looking through the Fujitsu J2X0-2273-01EN user manual directly on this website is not convenient for you, there are two possible solutions:

  • Full Screen Viewing - to easily view the user manual (without downloading it to your computer), you can use full-screen viewing mode. To start viewing the user manual Fujitsu J2X0-2273-01EN on full screen, use the button Fullscreen.
  • Downloading to your computer - You can also download the user manual Fujitsu J2X0-2273-01EN to your computer and keep it in your files. However, if you do not want to take up too much of your disk space, you can always download it in the future from ManualsBase.
Fujitsu J2X0-2273-01EN User manual - Online PDF
Advertisement
« Page 1 of 225 »
Advertisement
Print version

Many people prefer to read the documents not on the screen, but in the printed version. The option to print the manual has also been provided, and you can use it by clicking the link above - Print the manual. You do not have to print the entire manual Fujitsu J2X0-2273-01EN but the selected pages only. paper.

Summaries

Below you will find previews of the content of the user manuals presented on the following pages to Fujitsu J2X0-2273-01EN. If you want to quickly view the content of pages found on the following pages of the manual, you can use them.

Abstracts of contents
Summary of the content on the page No. 1








J2X0-2273-01EN



SymfoWARE(R)Server
RDB User's Guide: Database Definition


















Summary of the content on the page No. 2

Preface Purpose This manual is a user's guide for SymfoWARE Server RDB. The manual explains how to create and define databases. Intended reader This manual is for users who design and define SymfoWARE/RDB databases. Readers should have the following skills and knowledge: · A general understanding of SymfoWARE/RDB functions and databases · A working knowledge of applications to which SymfoWARE/RDB is applied · The ability to develop application programs using C or COBOL · Working kno

Summary of the content on the page No. 3

Reading this manual The purpose of this manual is to give readers a basic introduction to databases and their creation to make it easier to use SymfoWARE/RDB. Unless otherwise noted, application programs and SQL statement in this manual are written in C. Title Notation of Related Manual The table below lists the manuals related to this manual and their title notation in this manual. Position of this manual Manual system and position of this manual in the system ii

Summary of the content on the page No. 4

Besides the preceding manuals, SymfoWARE provides an online manual. Command syntax UNIX The man command is used to display the syntax of RDB commands. For details on the man command, refer to AnswerBook2 of the Reference Manual Collection. The copyright of the online manual is the property of UNIX System Laboratories, Inc. and Fujitsu. Follow the items in the written contract to use the product properly. Windows NT/2000/XP The command syntax is included in the Windows NT/2000/XP o

Summary of the content on the page No. 5

Windows NT/2000/XP Action in response to displayed messages is included in the Windows NT/2000/XP online help. Related manuals The related manuals are as follows: · Reference Manual Collection of AnswerBook 2 · Fujitsu COBOL User's Guide for Windows · COBOL85 User's Guide · Fujitsu COBOL Language Reference Comments on this manual Products covered by this manual UNIX · SymfoWARE Server Enterprise Edition 5.0 or later · SymfoWARE Server Hot Standby Option 5.0 or later Windows N

Summary of the content on the page No. 6

July 2002 Microsoft, MS, MS-DOS, Windows, and Windows NT are trademarks or registered trademarks of Microsoft Corporation in the United States and other countries. v

Summary of the content on the page No. 7

UNIX is a registered trademark in the United States and other countries, licensed exclusively through X/Open Company Limited. Solaris is a trademark of Sun Microsystems, Inc. in the United States. Lotus is a registered trademark of Lotus Development Corporation. SymfoWARE is a registered trademark of Fujitsu Limited. Other company and product names used in this manual are trademarks or registered trademarks of their respective owners. The symbols of (R) and TM are omitted in this manual.

Summary of the content on the page No. 8

Chapter 1 SymfoWARE/RDB Overview SymfoWARE/RDB provides functions for creating a database, managing a database, and manipulating database data. Before creating a database, the user must design the database structure and define the database based on this database structure design specifications. Then, the user must generate the database based on this database definition. Database management is required for checking database usage conditions and handling database damage. Structured query lang

Summary of the content on the page No. 9

[Figure: SymfoWARE/RDB functions configuration] Functions for defining table formats (database definition) To create a database, first define the table formats. 2.2 "Designing a Database," explains the kinds of formats used for tables. RDB commands are used to execute database definitions. For information about how to use actual RDB commands to define a database, see Chapter 2 "Database Creation." Functions for maintaining and managing databases (database management) SymfoWARE/RDB ha

Summary of the content on the page No. 10

Functions for manipulating tables (table manipulation) Data manipulation SQL statements are used to insert, alter, delete, and reference data in tables. These SQL statements are used within application programs. For information about how to develop application programs that use data manipulation SQL statements, refer to the "RDB User's Guide: Application Program Development." For information about how to use data manipulation SQL statements, refer to the "SQL Beginner's Guide." 1.2 Overview

Summary of the content on the page No. 11

[Figure: Relationship of logical, storage, and physical structures within databases] 1.2.1 Physical structure The physical structure consists of database spaces. Database space Under UNIX, a database space is defined on a raw device created on a magnetic disk; under Windows NT/2000/XP, a database space is defined in a local file created on a magnetic disk. A SymfoWARE/RDB system enables multiple database spaces to be defined so that the hard disk I-O load balance can be adjusted. In

Summary of the content on the page No. 12

[Figure: Example of correspondence between schemas and database spaces] Base table A base table consists of columns and rows. Figure: Base table format example is a base table format example. In this figure, one row consists of the data for one product. The data of a single row consists of several columns. A column corresponds to a data item. The data for one product (one row) consists of the four data items (columns): ITMNO, PRODUCT, STOCKQTY, and WHCODE. The base table configuratio

Summary of the content on the page No. 13

updated. Column constraint: A column constraint defines a constraint condition on table creation. One such condition may be "each row must have a value stored in the relevant column." Another condition may be "more than one row cannot have the same value in the relevant column." Table constraint A table constraint enables the user to define whether or not a constraint is to be applied to a table. Such a constraint may be "more than one row cannot have the same values in one or more column

Summary of the content on the page No. 14

index for each column of a table. Multiple columns also can be combined and specified as a single index. Searching a column for which no index has been created is less efficient than searching a column having an index. Thus, an index must be created for a column used as a data search key. However, whenever an index is created, additional database capacity is required for the storage. Carefully consider the space required for each index when determining the size of a database space. Although

Summary of the content on the page No. 15

1.2.3 Storage structure The storage structure consists of DSOs and DSIs. DSO A DSO defines the storage structure of the data for a base table. The two types of DSOs are as follows: · Table · Index Table DSO A table DSO defines the type of storage structure for storing data, and, if data is subdivided for storage, the subdivision method. Index DSO An index DSO defines how the index is created for the table. DSI A DSI defines an area for storing base table data so that it can be allo

Summary of the content on the page No. 16

[Figure: Example in which DSOs and DSIs are associated in a 1:n correspondence] As Figure: Storage structure components shows, the four types of storage structures are SEQUENTIAL, RANDOM, OBJECT, and BTREE. The SEQUENTIAL, RANDOM, and OBJECT structures are used as storage structures for tables. The BTREE structure is used as a storage structure for indexes. Each of these storage structures consists of one or more components as shown in Figure: Storage structure components. [Figure: St

Summary of the content on the page No. 17

[Figure: Example in which a database space is allocated to each component] 10

Summary of the content on the page No. 18

[Figure: Example of allocating multiple database spaces to increase the size of each compon ent] 1.3 Overview of Database Creation Tasks A SymfoWARE/RDB database can be created in one of the following two ways: · Using RDB commands · Creating a SQL-embedded program 11

Summary of the content on the page No. 19

Using RDB commands The user can create databases by executing RDB commands at the command prompt of UNIX or Windows NT/2000/XP. The user can define databases by specifying the file containing various SQLs for defining databases and using the rdbddlex command. The user can also create databases by using the rdbsloader command. This method is suitable for operation in which database logical and storage structures are defined in detail. For details of how to create databases by using the RDB

Summary of the content on the page No. 20

Chapter 2 Database Creation This chapter covers procedures ranging from the design and creation of a SymfoWARE/RDB database to database operation. 2.1 Overview of Tasks From Database Design To Operation 2.2 Designing a Database 2.3 Creating a Database 2.4 Entering a Database Name 2.5 Creating a Database Space 2.6 Defining a Logical Structure 2.7 Defining a Storage Structure 2.8 Applying a Storage Structure Definition 2.9 Simplifying a Storage Structure Definition 2.10 Defining a Temp


Alternative user manuals
# User manual Category Download
1 Fujitsu BX900 S1 User manual Server 23
2 Fujitsu 2000 User manual Server 1
3 Fujitsu CM71-00101-5E User manual Server 1
4 Fujitsu 5.0L10 User manual Server 1
5 Fujitsu 2000 SERIES User manual Server 1
6 Fujitsu Cloud Edition V3.1.0 User manual Server 0
7 Fujitsu C122-E180-01EN User manual Server 0
8 Fujitsu C120-E361-04EN User manual Server 2
9 Fujitsu M10-4S User manual Server 0
10 Fujitsu M10 User manual Server 1
11 Fujitsu M10-4 User manual Server 0
12 Fujitsu C122-H007-01EN User manual Server 0
13 Fujitsu M8000 User manual Server 0
14 Fujitsu RX300 S2 User manual Server 25
15 Fujitsu M3000 User manual Server 3
16 Edelbrock 1921 User manual Server 0
17 Sony VAIO VGF-HS1 User manual Server 11
18 Sony NAS-SV20DI User manual Server 1
19 3Com 10031370-01 User manual Server 1
20 3Com SuperStack 3 User manual Server 9