"Symfoware NATIVE" Create an instance

Symfoware Native Department
"Pkg Installation"
Fool-Type one-click installation (default), you can see the location of each directory in the installation, you can also specify the location and parameters in the installation.
By default, the installation directory:
Symfoware Server installation directory:
C:\SFWSV
Symfoware Server Control File warehouse directory:
C:\SFWETC
Database encoding:
Shift_JIS
Symfoware Server Client installation directory:
C:\SFWCLNT
Symfoware Server Connection Manager installation directory:
C:\SFWCM
Connection Manager function control file repository directory:
C:\SFWETC
Installation function:
Basic machine can
Webadmin/webdbtools Setup:
Web Service port number: 26510
Webadmin/webdbtools Internal Port number 1:26,511
Webadmin/webdbtools Internal Port number 2:26,512
Webadmin/webdbtools Internal Port number 3:26,513
Webadmin/webdbtools Internal Port number 4:26,514
Registration of the JDBC-driven naming service:
The JDBC Naming service is registered later.

"Create an Rdb"
Prepare before creating
Action environment: OS resource or SYMFOWARE/RDB resource
OS: Shared memory, セマフォ; (RDB program and external intelligence Exchange)
SYMFOWARE/RDB Resources:
1, RDB Dictionary: Save the Database definition information;
2, Rdb directory file: Save in order to access the database configuration and operation of information;
3. Log group Management file: Save the Log group management configuration file;
4, log management files: To save temporary log files such as configuration location information;
5. Temporary log file: Save the temporary log and log information for roll back;
6, アーカイブログファイル: Save the log information for resource recovery;
7, Database: User-defined database;
8, monitoring Log database: Monitoring log table composed of the database;
9, Performance Data Warehouse file: Save performance statistics;
10, the RDB constitutes a parameter file: The preservation of SYMFOWARE/RDB work environment provisions of various information;
11, working environment file: The application run time work environment adjustment;
12. Backoff Disk: Save the Backoff information of the database;
13. Job Domain: The domain space used by application running and RDB command running;
14. Core file: Symfoware server exception, save exception information.

Note: The above is a work (action) environment where you can use multiple work environments by setting the work environment name.

Using WebAdmin
In order to make the system work generated files are: Log group management files, log management files, temporary log files, Rdb directory files, RDB dictionary, monitoring log management files, monitoring with temporary log files, monitoring log database, implementation of database warehouse files.
In order to use the system, you can set up: Rdb composition parameter file, System workspace file, default common buffer file, services file (port list).

Start WebAdmin, set
Web service port (default 26510): 1024~49151;
WebAdmin Run Environment Port 1 (default 26511): 1024~49151;
WebAdmin Run Environment Port 2 (default 26512): 1024~49151.

Rdb as
1. RDB system Administrator authentication   [login] screen
  access http://localhost:26510/, login (System user name and password)
 
2. System composition   [Rdb made (1/3)-System composition] Screen  
 RDB system Name (*):   rdb00001
 rdb Name: 8 digits in the beginning of the English letter half-width English number named, Case insensitive. (Example: RDB00001)
  System scale:    large scale (number of connections)
         Medium scale (number of connections)
         Small size (number of connections)
  System composition:     Single System
  Auto start stop         auto start stop

3. Resource allocation preparation   [RDB make (2/3)-Resource allocation] screen
4. File and port preparation   [RDB make (3/3)-compose-environment] screen
 
Confirmation:
Log management file        f:\wangsj\ log  
BI log field         F:\wangsj\BI_log  
AI log field         F:\wangsj\AI_log  
Log Index field         F:\wangsj\logindex  
RDB catalog Files     F:\wangsj\RDB  
RDB dictionary     F:\wangsj\RDBword  
Rdb constituent parameter file    c:\sfwetc\rdb\etc\ rdb00001.cfg  
System Run environment file       C:\SFWETC\RDB\ETC\RDB00001.env  
Default shared buffer definition file  C:\SFWETC\RDB\ETC\RDB00001\rdbbuf  
Remote connection port number      26518 (Specify a not used,
       can see the used port number in C:\WINDOWS\SYSTEM32\DRIVERS\ETC\SERVICES)

Use command
In order to use Rdbcommand, set environment variables and core files
> SET rdbname=rdb001 (Note)
> SET Rdbcorepath=c:\sfwsv\rdb\core (Note)

Note: The RDB named Rdb001,core file is specified here to save the directory as C:\SFWSV\RDB\CORE.
If the core path is not set, the current directory is assumed to be default.

Create an RDB to run C:\SFWSV\SYSSETUP directly. EXE, set parameters, complete.

You can modify or set the following files directly
1, can directly modify the configuration parameters:
~\sfwetc\rdb\etc\rdb001.cfg
Example
Rdb001.cfg:
rdblog=256,256
Rdbdbsnum=16
Rdbnetdbsnum=16
rdbreportsize=10485760
Rdbloggroupmanage=e:\rdb001\rdb\rdb\usr\log
Rdblogmanage=e:\rdb001\rdb\rdb\usr\log
Rdbdirspace1=e:\rdb001\rdb\rdb\usr\dir
Rdbdirspace2=e:\rdb001\rdb\rdb\usr\dir
Rdbcore=e:\rdb001\rdb001_server\workdir
Rdbpm=e:\rdb001\rdb001_server\workdir
Rdbreport=e:\rdb001\rdb001_server\workdir
rdbextmem=7124
rdbcntnum=400
Rdbsystemid=1
Rdbsysbuf=e:\rdb001\rdb001_server\workdir
Rdbsqlenv=e:\rdb001\rdb001_server\etc\rdb001.env

2. Log Group Management files:
1) file path specified by Rdbloggroupmanage;
2) create using the > Rdblog-m command.

3. Log Management file:
1) file path specified by Rdblogmanag;
2) Use the > Rdblog-i command to create

4. Temporary log file (must be created, otherwise the RDB cannot be started):
Example:
> rdblog-g-t-c 10M E:\rdb001\rdb001_Server\workdir\TMPLOG-in-in 30M 20M 20

Note: bilog domain 30M; Ailog domain 20M; The number of transaction entries is 20, the amount of recycle log is 10M, Ailog and Bilog are saved in E:\rdb001\rdb001_Server\workdir\TMPLOG.

5. Create an RDB dictionary:
In order to make database environment, create RDB Dictionary, rdb file directory;
RDB Dictionary:
> Rdbcrdic-f E:\rdb001\rdb001_Server\workdir\DICTIONARY-c 70m-a 60M
Create 60M capacity in E:\rdb001\rdb001_Server\workdir\DICTIONARY, automatically create Dir_file1 and dir_file2;

6. Monitor log database for:
To get the monitoring log, do the following:
1) Start Symfoware/rdb;
> Rdbstart

2) monitoring log database;
> Rdbaudit-c-n 3-s 200m-f E:\rdb001\rdb001_Server\workdir\ADTLOG\AUDIT_FILE001
Generate 3 units, each 200M.

You can continue to append units
> rdbaudit-a-N 2-f E:\rdb001\rdb001_Server\workdir\ADTLOG\AUDIT_FILE002

3) Close the Symfoware/rdb.
> Rdbstop

"CREATE DATABASE"
Symfoware/rdb, there are the following three ways: Rdbcommand, SQL Embedded program, Webdbtools.

Rdbcommand
Rdbddlex command
Form one: with a semicolon end;
CREATE DATABASE rdbdb;
Form two:
EXEC SQL
CREATE PROCEDURE PROC01
:
End-exec;

To create a database sample from a definition file:
Create command
Solaris:rdbddlex-d Rdbdb/home/rdb/ddl/ddl.dat
Linux:rdbddlex-d Rdbdb/home/rdb/ddl/ddl.dat
Note: Database space definition: CREATE DBSPACE DBSPACE1 ALLOCATE rawdevice/dev/raw/raw1
Windows:rdbddlex-d rdbdb C:\USERS\DEFAULT\DDL. Dat
Note: Database space definition: CREATE DBSPACE DBSPACE1 ALLOCATE FILE E:\rdb002\DIR_FILE3 ATTRIBUTE SPACE (3M)

Note: The database space is different from the table space and is used to hold the actual data, Dir_file1, Dir_file2 are created by default, if you want to create a new database space: FILE e:\rdb002\dir_file3,rdb002 is the RDB warehouse directory.

Note:-D RDBDB indicates that the database name is rdbdb,/home/rdb/ddl/ddl.dat as the definition file.
Definition file (Solaris, other systems only need to change the database space definition):

/home/rdb/ddl/ddl.dat (Here is a detailed version) the Rdb_example.dat is the tested version in the attachment.
==========================================================================
--The database definition database is named "RDBDB"
CREATE DATABASE rdbdb;

--Database space definition database space named "DBSPACE1"
CREATE DBSPACE DBSPACE1 ALLOCATE rawdevice/dev/rdsk/c0t1d0s1;
Explain:
--allocate: Specify
--rawdevice: Native Equipment

--schema Definition schema named "STOCKS"
CREATE SCHEMA STOCKS
Note: If you use Administrator user action, you need to create a mode administrator;

--In the Library Commodity management table
CREATE table in the library table (
Item number SMALLINT not NULL,
Product Name National CHARACTER (TEN) not NULL,
Inventory Quantity INTEGER,
Warehouse Number SMALLINT,
PRIMARY KEY (Product code)
)

CREATE VIEW lots in library table (item number, quantity)
As SELECT product number, inventory quantity from STOCKS. In the library table
WHERE Inventory Quantity >= 50

--Commodity order Management form
CREATE table order Form (transaction number SMALLINT not NULL,
Trade commodity SMALLINT not NULL,
Purchase Price INTEGER,
Order Quantity SMALLINT,
PRIMARY KEY (transaction number, trading item)
)

CREATE VIEW Large order form (trade goods, purchase price)
As SELECT traded goods, purchase price from STOCKS. Order Form
WHERE Order Quantity >= 100

--Trading Company management chart
The CREATE Table Company table (company number SMALLINT not NULL,
Company Name National CHARACTER (TEN) not NULL,
Company Phone CHARACTER (14),
Address National CHARACTER (20),
PRIMARY KEY (company number)
)

CREATE VIEW Company Table 1 as SELECT company number, company name from STOCKS. company table;

--In the library table storage warehouse structure definition
CREATE DSO in the Library table DSO--DSO in the library table
From STOCKS. In the library table
TYPE Sequential (PAGESIZE (4), ORDER (1));
Explain:
1. Type
Sequential: The data order is appended to the warehouse, Pagesiz represents the page size, and order (0) indicates that the deletion realm cannot be reused, and order (1) indicates that the deletion realm can be used again.
Random: Data is not ordered and is randomly appended to the warehouse.

CREATE DSi in the Library table DSi--DSI in the library table
DSO in library table DSO
ALLOCATE DATA on DBSPACE1 SIZE 280K;

--The index of the product number in the library table
CREATE DSO Product number IXDSO--Index of DSO
INDEX on STOCKS. In the library table (product code)
TYPE BTREE (PAGESIZE1 (+), PAGESIZE2 (1), realignment) by ADDRESS;

CREATE DSI Product number IXDSI--Index DSi
INDEX
DSO Product ID IXDSO
ALLOCATE BASE on DBSPACE1 SIZE 200K,
INDEX on DBSPACE1 SIZE 40K;

--storage warehouse structure definition for order form
CREATE DSO Order DSO--order Form DSO
From STOCKS. Order
TYPE Sequential (PAGESIZE (4), ORDER (1))
WHERE (transaction number) between (?) and (?); --Retrieving the transaction number

--Data partition configuration
CREATE DSi Kanto Order Form DSI-Kanto Company use
DSO ORDER Form DSO
USING (60,69)--60 begins with the Kanto Company
ALLOCATE DATA on DBSPACE1 SIZE 280K;

CREATE DSi Kansai Order Form DSI-Kansai Company use
DSO ORDER Form DSO
using (70,79)-70 begins with the Kansai Company
ALLOCATE DATA on DBSPACE1 SIZE 280K;
Note: A search condition is defined in the DSO and then passed to the retrieval expression by using the use of the DSI when it is defined, returning the result of the search.

--The trade number of the order form and the index of the traded commodity
CREATE DSO Trading IXDSO--Index of DSO
INDEX on STOCKS. Order form (transaction number, trading item)
TYPE BTREE (PAGESIZE1 (+), PAGESIZE2 (1), realignment) by ADDRESS;
CREATE DSi Kanto Index IXDSI--Index DSi
INDEX
DSO Trading Ixdso
BASE Kanto Order Form DSi
ALLOCATE BASE on DBSPACE1 SIZE 200K,
INDEX on DBSPACE1 SIZE 40K;
CREATE DSi Kansai Trading Ixdsi--Index DSi
INDEX
DSO Trading Ixdso
BASE Kansai Order Table DSi
ALLOCATE BASE on DBSPACE1 SIZE 200K,
INDEX on DBSPACE1 SIZE 40K;

--The warehouse structure definition of the company table
CREATE DSO Company Table DSO--Company Table of DSO
From STOCKS. Company table
TYPE Sequential (PAGESIZE (4), ORDER (1));
CREATE DSI Company Table DSi-Company Table DSi
DSO Company Table DSO
ALLOCATE DATA on DBSPACE1 SIZE 280K;

---the company number index of the company table
CREATE DSO Company Number IXDSO--Index of DSO
INDEX on STOCKS. Company table (company number)
TYPE BTREE (PAGESIZE1 (+), PAGESIZE2 (1), realignment) by ADDRESS;
CREATE DSI Company Number IXDSI--Index DSi
INDEX
DSO Company No. ixdso
ALLOCATE BASE on DBSPACE1 SIZE 200K,
INDEX on DBSPACE1 SIZE 40K;
======================================================================

Rdb_example.dat

CREATE DATABASE RDBDB6;

CREATE DBSPACE DBSPACE1 ALLOCATE FILE E:\rdb002\DIR_FILE6 ATTRIBUTE SPACE (3M);

CREATE SCHEMA ADMINISTRATOR;

CREATE TABLE Repertorygoods (
Goodsnum SMALLINT not NULL,
Goodsname National CHARACTER (Ten) is not NULL,
Goodssum INTEGER,
Repertorynum SMALLINT,
PRIMARY KEY (Goodsnum)
);

CREATE VIEW bigrepertorygoods (goodsnum,goodssum)
As SELECT Goodsnum, goodssum from Administrator.repertorygoods
WHERE Goodssum >= 50;

CREATE TABLE ordertable (ordernum SMALLINT not NULL,
Ordergoods SMALLINT not NULL,
Orderprice INTEGER,
Ordersum SMALLINT,
PRIMARY KEY (Ordernum,ordergoods)
);

CREATE VIEW Bigorder (ordergoods, Orderprice)
As SELECT Ordergoods, Orderprice from administrator.ordertable
WHERE ordersum >= 100;

CREATE TABLE Company (Companynum SMALLINT not NULL,
CompanyName National CHARACTER (TEN) is not NULL,
Companytel CHARACTER (14),
COMPANYADDR National CHARACTER (20),
PRIMARY KEY (Companynum)
);

CREATE VIEW Company1 as SELECT companynum,companyname from Administrator.company;

CREATE DSO Repertorydso
From Administrator.repertorygoods
TYPE Sequential (PAGESIZE (4), ORDER (1));

CREATE DSI Repertorydsi
DSO REPERTORYDSO
ALLOCATE DATA on DBSPACE1 SIZE 280K;

CREATE DSO Goodsnumixdso
INDEX on Administrator.repertorygoods (goodsnum)
TYPE BTREE (PAGESIZE1 (+), PAGESIZE2 (1), realignment) by ADDRESS;

CREATE DSI Goodsnumixdsi
INDEX
DSO GOODSNUMIXDSO
ALLOCATE BASE on DBSPACE1 SIZE 200K,
INDEX on DBSPACE1 SIZE 40K;

CREATE DSO Orderdso
From administrator.ordertable
TYPE Sequential (PAGESIZE (4), ORDER (1))
WHERE (Ordernum) between (?) and (?);

CREATE DSI Guandongorderdsi
DSO ORDERDSO
USING (60,69)
ALLOCATE DATA on DBSPACE1 SIZE 280K;

CREATE DSI Guanxiorderdsi
DSO ORDERDSO
USING (70,79)
ALLOCATE DATA on DBSPACE1 SIZE 280K;

CREATE DSO Orderixdso
INDEX on administrator.ordertable (ordernum,ordergoods)
TYPE BTREE (PAGESIZE1 (+), PAGESIZE2 (1), realignment) by ADDRESS;

CREATE DSI Guandongindexixdsi
INDEX
DSO ORDERIXDSO
BASE Guandongorderdsi
ALLOCATE BASE on DBSPACE1 SIZE 200K,
INDEX on DBSPACE1 SIZE 40K;

CREATE DSI Guanxiorderixdsi
INDEX
DSO ORDERIXDSO
BASE Guanxiorderdsi
ALLOCATE BASE on DBSPACE1 SIZE 200K,
INDEX on DBSPACE1 SIZE 40K;

CREATE DSO Companydso
From Administrator.company
TYPE Sequential (PAGESIZE (4), ORDER (1));

CREATE DSI Companydsi
DSO COMPANYDSO
ALLOCATE DATA on DBSPACE1 SIZE 280K;

CREATE DSO Companynumixdso
INDEX on Administrator.company (companynum)
TYPE BTREE (PAGESIZE1 (+), PAGESIZE2 (1), realignment) by ADDRESS;

CREATE DSI Companynumixdsi
INDEX
DSO COMPANYNUMIXDSO
ALLOCATE BASE on DBSPACE1 SIZE 200K,
INDEX on DBSPACE1 SIZE 40K;

This article is from the "Night" blog, be sure to keep this source http://icyore.blog.51cto.com/8486958/1596299

"Symfoware NATIVE" Create an instance