TP1/EE/Extended Data Cache 使用の手引
|
|
|
- なぎさ つつの
- 5 years ago
- Views:
Transcription
1 OpenTP1 Version 7 TP1/EE/Extended Data Cache F55
2 P-9V ucosminexus TP1/EE/Extended Data Cache OS Red Hat Enterprise Linux 5.1 IPF ISO9001 TickIT Linux Linus Torvalds Red Hat Red Hat, Inc F55 All Rights Reserved. Copyright (C) 2008, Hitachi, Ltd.
3 P-9V ucosminexus TP1/EE/Extended Data CacheXDB XDB Linux(R) SQL TP1/Server Base TP1/Server Base Enterprise Option 1 XDB TP1 XDB XDB 2 XDB XDB XDB 3 DB DB 4 SQL 5 XDB 6 7 XDB XDB 8 I
4 9 10 XDB A XDB B XDB XDB C II
5 III
6 IV
7 V
8 1 - ID -r eexdbshmrm -g, eexdbshmrm -p -l -p -l eexdbarea -n DB eexdbarea -n DB eexdbarea -n DB syntax detail all syntax detail all VI
9 xdb_memory_fixed = Y N xdb_memory_fixed Y 2 (()) 3 16 DB A Z a z _ A F a f " /. OS A Z a z 0 9- _ " VII
10 MAX MIN MAX MIN Itanium(R) Processor Family ucosminexus TP1/EE/Extended Data Cache ucosminexus TP1/EE/Extended Transaction Controller ucosminexus TP1/EE/Message Control Extension ucosminexus TP1/Server Base ucosminexus TP1/Server Base Enterprise Option IPF XDB XTC MCP TP1/Server Base TP1/EE AP API CR CSV DB DBMS EOF ID Application Programming Application Programming Interface Carriage Return Comma Separated Value Database Database Management System End of File Identifier VIII
11 LRU NL OS RPC SPP SUP TAR UAP Least Recently Used New Line Operating System Remote Procedure Call Service Providing Program Service Using Program Tape Archival and Retrieval format User Application Program KB 1KB1MB1GB1TB 1,024 1, , ,024 4 IX
12
13 XDB XDB XDB TP1 XDB TP XDB OS TP XDB 8 2 XDB DB DB DB DB DB DB XDB SQL TP1/EE TP1/EE 35 i
14 DB DB DB DB DB DB DB DB SQL SQL SQL SQL SQL SQL ii
15 SQL XDB XDBPOOL TP1/EE XDB TP1/Server Base XDB SQL XDB XDB XDB iii
16 7.3.1 TASKTM XDB XDB XDB XDB XDB XDB SQL SQL SQL SQL SQL SQL DB DB DB SQL eetrbwtor 188 eexdbdefchk XDB 189 iv
17 eexdbdump XDB 192 eexdbed XDB 194 eexdbexport 202 eexdbexttbl 206 eexdbfput XDB 210 eexdbimport 211 eexdbmemdmp 216 eexdbrasget 218 eexdbshmrm 220 eexdbsql SQL 222 eexdbsta A 244 A A.2 SQL_TABLES 244 A.3 SQL_COLUMNS 246 A.4 SQL_INDEXES 247 A.5 SQL_DIV_TABLE 248 A.6 SQL_DIV_INDEX 249 A.7 SQL_DBAREAS 250 A B XDB 252 C v
18 1-1 TP XDB DB DB DB TP1/EE TP1/EE DB ID XDB 112 A-1 ID 248 vi
19 2-1 DB SQL SQL SQL xdb_default_service_mem_size eexdbsrv -m XDB XDB TASKTM XDB TP1/EE XDB SQL SQL COD LEN DB DB SQL 180 vii
20 XDB KFSB56208-Q eexdbed e r e f V -o SQL eexdbsql A A-2 SQL_TABLES 245 A-3 SQL_COLUMNS 246 A A-5 SQL_INDEXES 247 A-6 SQL_DIV_TABLE 249 A-7 SQL_DIV_INDEX 249 A-8 SQL_DBAREAS 250 A B B viii
21 1 XDB TP1 XDB XDB 1.1 XDB 1.2 TP1 XDB 1.3 XDB 1
22 XDB XDB XDB 1 XDB XDB 64 OS XDB XDB XDB 1 XDB XDB DB 2
23 1. 2 TP1/EE TP1/EE OpenTP1 DBMS 3 READ COMMITTED XDB READ COMMITTED 4 XDB XDB 3
24 TP1 XDB XDB TP1 TP1/EE XTC TP1 XDB TP1/EE/Extended Transaction Controller TP TP1 TP1 TP1 TP1/Server Base Enterprise Option TP1/EE ucosminexus TP1/EE/Extended Transaction Controller XTC ucosminexus TP1/EE/Extended Data Cache XDB 2 TP1 TP1 TP1/EE/Extended Transaction Controller XDB OS XDB OS 1 OS Red Hat Enterprise Linux 5.1 IPF 2 P-9V ucosminexus TP1/Server Base P-9V64-2A21 ucosminexus TP1/Server Base Enterprise Option P-9V ucosminexus TP1/EE/Extended Transaction Controller P-9V2C-E111 HA 4
25 1. 3 XDB UAP P-9V COBOL2002 Net Server Suite TP1 TP1 5
26 TP1 CL XDB CL 6
27 1. 1. HA CL 2. HA HA TP1/EE/Extended Transaction Controller TP1 CL CL HA HA HA TP1 RPC XTC HA CL CL TP1 RPC XTC XDB XDB CL CL HA
28 XDB XDB XDB XDB XDB 1-2 XDB 8
29 1. 1. XDB XDB 2. XDB 3. XDB XDB XDB XDB XDB 1 DB DB a XDB b XDB XDB c XDB CL XTC CL CL 2 XDB XDB 9
30 1. XDB 10
31 2 XDB XDB XDB DB XDB
32 2. XDB 2.1 XDB XDB XDB B-tree UAP XDB XDB XDB XDB XDBUSER XDB XDBUSER XDB XDBUSER MASTER MASTER MASTER XDB 1 12
33 2. XDB 2.2DB DB DB XDB DB DB DB DB DB 13
34 2. XDB 2-1 DB DB DB DB DB 2-1 DB DB 1 DB DB 2 DB DB 14
35 2. XDB DB 3 DB SQL XDB DB SQL 4 DB 5 DB DB DB A XDB SQL DB DB 3.4 DB DB DB XDB XDB DB DB DB DB 2-2 DB DB 1 15
36 2. XDB 2-3 DB DB 2-2 DB 1 DB DB 2 DB DB 3 ID 16
37 2. XDB XDB VARCHAR DB CREATE TABLE DB CREATE INDEX eexdbimport 2 XDB a b ID 17
38 2. XDB XDB B-tree B-tree ID 256 c DB DB CREATE TABLE DB CREATE INDEX 3.3.3(1) DB DB XDB DB DB DB 1 DB DB XDB DB 18
39 2. XDB DB DB DB XDB DB DB DB XDB SQL SQL DB DB XDB DB DB DB 1 DB 2-4 DB DB 1 XDB eexdbarea -l XDB 6.5 XDB 19
40 2. XDB 2.3 XDB XDB XDB XDB XDB XDB XDB 20
41 2. XDB XDB eexdbarea DB 2. SQL 3. DB 21
42 2. XDB DB XDB eexdbarea DB DB 6.5 XDB SQL CREATE TABLE CREATE INDEX XDB 6.6 SQL CSV XDB XDB 6.7 XDB XDB XDB XDB
43 2. XDB XDB DB DB XDB DB XDB XDB 6.7 XDB XDB DB eexdbshmrm XDB xdb_memory_terminate_remove Y 23
44 2. XDB 2.4 XDB XDB INSERT UPDATE DELETE DB 1 24
45 2. XDB DB 25
46 2. XDB DB 3. DB SELECT DB XDB 3 DB 26
47 2. XDB UAP XDB READ COMMITTED 1 A SELECT C1 FROM T1 B UPDATE T1 SET C1=200 A SQL B SQL 1. A 1 C B 3. A 2 C A UPDATE T1 SET WHERE C1=100 B UPDATE T1 SET C1=100 WHERE C1=200 A SQL B SQL DB 27
48 2. XDB 2-9 DB A A 1 28
49 2. XDB A 1 A 1 2 A DB 3 A 3 A
50 2. XDB A 2 A 1 DB SQL SQL XDB SQL SQLWARN6 'W' UAP SQLWARN6 'W' TP1/EE SQL SQL TP1/EE RPC 30
51 2. XDB 2.5 XDB XTC XDB XDB DB XDB XTC 3. XDB 31
52 2. XDB 1 TP1/EE XDB TP1/EE 2 XTC TP1/EE/Extended Transaction Controller CL 3 CL 4 32
53 2. XDB 33
54 2. XDB 2.6 XDB 2 1 TP1/EE 3 2 XTC HA XTC TP1/EE/Extended Transaction Controller CL HA HA Linux(R) XTC HA CL CL TP1/EE/Extended Transaction Controller TP1/EE TP1/EE HA TP1/EE 34
55 2. XDB TP1/EE TP1/EE HA 2 1 HA HA TP1/EE TP1/EE XDB HA TP1/EE TP1/EE XDB 35
56 2. XDB 2 TP1/EE TP1/EE TP1/EE 1 eexdbexttbl XDB
57 3 DB DB DB 3.5 DB 3.6 DB 3.7 DB 3.8 DB 3.9 DB 37
58
59 INTEGER 2 DECIMAL 3 CHARACTER 4 TIMESTAMP TP1/EE/Extended Data Cache SQL XDB CREATE TABLE SEGMENT REUSE 39
60 3. 3 SEGMENT REUSE
61 3. DB DB DB DB 2 CREATE TABLE SEGMENT REUSE 1 2 SEGMENT REUSE SEGMENT REUSE 1,1 3 41
62 3. SEGMENT REUSE NOUSE SEGMENT REUSE 42
63 UAP 4.3 SQL a WHERE b FROM c ORDER BY
64 3. WHERE ORDER BY WHERE d COUNT(*) COUNT e
65 ORDER BY 1 C1 C1 T1IX1 SQL SELECT * FROM "T1" WHERE "C1" = 1 SELECT * FROM "T1" ORDER BY "C1" ASC CREATE INDEX "T1IX1" ON "T1"("C1" ASC) IN DBAREA01 2 ORDER BY C1 C2 C1 C2 T1IX1 SQL 45
66 3. SELECT * FROM "T1" WHERE "C1" = 1 AND "C2" = 'A' SELECT * FROM "T1" ORDER BY "C1" ASC, "C2" ASC CREATE INDEX "T1IX1" ON "T1"("C1" ASC,"C2" ASC) IN DBAREA01 3 a WHERE WHERE CREATE INDEX "T1IX1" ON "T1"("C1" ASC,"C2" ASC,"C3" ASC) IN DBAREA01 46
67 3. WHERE 1 C2 = C3 2 C2 C3 3 C1 = C2 C3 4 47
68 3. = b ORDER BY ORDER BY CREATE INDEX "T1IX1" ON "T1"("C1" ASC,"C2" ASC,"C3" ASC) IN DBAREA01 CREATE INDEX "T1IX2" ON "T1"("C4" ASC) IN DBAREA SELECT * FROM "T1" ORDER BY "C1" ASC,"C2" ASC,"C3" ASC 2 SELECT * FROM "T1" ORDER BY "C1" DESC,"C2" DESC,"C3" DESC 3 SELECT * FROM "T1" ORDER BY "C1" DESC,"C2" ASC,"C3" ASC 1 4 SELECT * FROM "T1" ORDER BY "C1" ASC,"C2" ASC 2 5 SELECT * FROM "T1" ORDER BY "C1" ASC,"C2" ASC,"C3" ASC,"C4" ASC 6 SELECT * FROM "T1" WHERE "C1" > 0 ORDER BY "C1" ASC,"C2" ASC,"C3" ASC 7 SELECT * FROM "T1" WHERE "C4" > 0 ORDER BY "C1" ASC,"C2" ASC,"C3" ASC 3 48
69 ORDER BY 3 WHERE T1IX % 20% CREATE INDEX PCTFREE % 0 99% 30% 49
70 3. 50
71 XDB 0% 51
72 % INSINITROW INS 100% INITROW INS 52
73 DB DB DB DB DB DB 1 DB DB DB DB DB DB XDB eexdbarea eexdbarea 6.5 XDB 2 DB DB DB DB DB DB DB DB DB DB 53
74 3. DB DB DB XDB DB DB DB XDB eexdbarea -p 1 DB DB DB XDB XDB 3.5(3)(b) DB SQL 3 DB DB SQL DB 54
75 3. XDB eexdbarea -s 1 1 DB DB DB DB DB DB DB DB DB DB DB DB DB 1 XDB DB DB 1 DB 1 55
76 DB 1 XDB DB 1 DB DB 1 eexdbarea -l XDB XDB eexdbarea -a 1 DB eexdbarea -a DB DB DB xdb_memory_fixed Y 56
77 3. DB DB DB DB OS xdb_memory_fixed TP1/Server Base setrlimit_memlock OS setrlimit_memlock 6.4 TP1/Server Base set 57
78 DB DB 1 DB DB PGSZ DB ASZ DB 1 DB DB 2 DB DB PGSZ DB SS DB bf SG DB 58
79 3. TS DB Bi Ri Bi Ri (3) 3 a a PGSZ DB pf CREATE TABLE PCTFREE % 0% 0% ci 3-3 vi VARCHAR 3-4 vn VARCHAR e b
80 INTEGER 4 2 SMALLINT 2 3 DECIMAL(m,n) m CHARACTER(n) n 5 VARCHAR(n) 7 6 TIMESTAMP(p) 7 p 2 m n p m n m VARCHAR(n) d n d c Bi Bi Bi BL 60
81 e pf d Ri Ri 61
82 DB DB 1 DB DB PGSZ DB ASZ DB 1 DB DB SQL DB DB DB XDB 2 DB DB PGSZ DB SS DB bf 62
83 3. SG DB IS DB IPi (3) 3 a PGSZ DB pf CREATE INDEX PCTFREE % 30% 0% k 255 kn 255 dk 256 dkn 256 kl DB 3-5 klb klklb 22 63
84 3. klb 3-5 b INTEGER a 2 SMALLINT a 3 DECIMAL m,n 3 m 2 1 m 2 1 m 2 1 a 4 CHARACTER n n n n a 5 VARCHAR n d a d a 6 TIMESTAMP(p) 7 p 2 7 p 2 7 p 2 a a TP1/EE/ Extended Data Cache SQL CREATE INDEX d m n p
85 TP1/EE/Extended Data Cache SQL CREATE INDEX 3 m n m 29 c 1 pk Pi 1 Pn 1 Pi 1 Q 2 R
86
87 DB DB 1 DB DB DB DBDB DB TASKTM 2 DB TS IS Bi Ri Bi Ri 3.5(3) IPi 3.6(3) 3 TASKTM DB TASKTM 67
88 3. TASKTM
89 DB DB DB a a 888b b DB 69
90 DB DB DBa a DB DB 12b 84 b b A C 1 A a b c 1 70
91 3. d e 2 B a b c d e 3 C a DB b DB 71
92
93 4 SQL 4.1 SQL SQL 73
94 SQL SQL SQL SQL SQL XDB SQL SQL SQL SQL XDB SQL SQL SQL SQL SQL SQL SQL SQL LRU SQL SQL SQL XDB xdb_sqlpool_size SQL SQL SQL SQL SQL SQL SQL SELECT INSERT UPDATE DELETE 74
95 4. SQL SQL SQL SQL SQL SQL SQL SQL SQL SQL SQL SQL SQL SQL SQL SQL XDB SQL SQL 1 XDB SQL SQL SQL SQL XDB XDB SQL SQL SQL SQL SQL SQL SQL 1 SQL SELECT * FROM "T1" SELECT * FROM "T1" 2 SQL SELECT * FROM "T1" SELECT* FROM "T1" SQL 2 SQL SQL SQL SQL SQL 75
96 SQL SQL 1 SQL 2 DECLARE CURSOR DECLARE CURSOR FOR 3 1 SELECT INTO [ ] [ [ ]] SQL SQL a SQL SQL DECLARE CR1 CURSOR FOR SELECT * FROM "T1" DECLARE CR2 CURSOR FOR SELECT * FROM "T1" b SQL SQL SQL 1 SQL SELECT * FROM "T1" WHERE "C1"=1 SELECT * FROM "T1" WHERE "C1"=2 SQL SQL SQL 2 SQL X1=1; SELECT * FROM "T1" WHERE "C1"=:X1 X2=2; SELECT * FROM "T1" WHERE "C1"=:X2 SQL SQL 3 SQL SQL SQL SQL SQL 76
97 4. SQL SQL 2 SQL SQL 2 SQL SQL SQL 1 SELECT 1 SELECT SQL 1 SELECT SQL SQL SQL SQL SQL XDB xdb_sqlpool_size a SQL SQL SQL SQL b SQL c n SQL SQL SQL SQL 77
98 d xdb_sqlpool_size e SQL 1024 SQL 1023 SQL SQL TP1/EE SQL SQL 4-2 SQL 1 SQL 2 SQL 3 SQL 4 SQL SQL SQL SQL SQL SQL SQL SQL 1 4 SQL SQL SQL 0 SQL 78
99 4. 5 SQL 6 SQL SQL SQL SQL SQL SQL SQL SQL 0 0 SQL XDB 79
100 SQL SQL XDB SQL SQL LRU XDB xdb_tabledefpool_size SQL 1. SQL
101 XDB xdb_tabledefpool_size SQL TP1/EE
102 SQL 80% 0 0 XDB 100% XDB XDB SQL XDB XDB SQL XDB 82
103 4. XDB xdb_table_preread Y XDB 83
104 SQL XDB SQL
105
106 ID ID ID ID SQL ID ID ID 4-4 ID 86
107 XDB FROM XDB 87
108 4. WHERE WHERE 4-4 SQL 1 = 2 = 3 WHERE "C1" = 1 WHERE "C1" = 1 WHERE "C1" >= 1 WHERE "C1" BETWEEN 1 AND SELECT * FROM "T1" ORDER BY "C1" 5 COUNT(*) COUNT 2 SELECT COUNT(*) FROM "T1" SELECT COUNT("C1") FROM "T1" SELECT COUNT(DISTINCT "C1") FROM "T1" 6 3 SELECT "C1" FROM "T1" WHERE "C1" <> 1 WHERE "C1" NOT BETWEEN 1 AND 10 OR NOT WHERE "C1" = 1 OR "C1" = 2 WHERE NOT "C1" = (1)
109 4. eexdbsql #SET OPT REPORT eexdbsql #SET OPT REPORT 10eexdbsql SQL #SET OPT REPORT CREATE FIX TABLE "T1"("C1" INT,"C2" CHAR(10),"C3" INT,"C4" INT) IN DBAREA01 CREATE INDEX "T1IX1" ON "T1"("C1") IN DBAREA02 CREATE INDEX "T1IX2" ON "T1"("C2") IN DBAREA03 SQL SELECT * FROM "T1" WHERE "C1"=1 AND "C2">'ABC' T1IX1 T1IX1 2 T1IX CREATE FIX TABLE "T2"("C1" INT,"C2" CHAR(10),"C3" INT,"C4" INT) IN DBAREA01 CREATE INDEX "T2IX1" ON "T2"("C1") IN DBAREA02 CREATE INDEX "T2IX2" ON "T2"("C2") IN DBAREA03 SQL SELECT * FROM "T2" WHERE "C1"<=1 AND "C2">'ABC' T2IX1 T2IX1 89
110 4. T2IX2 3 WHERE 3 3 CREATE FIX TABLE "T3"("C1" INT,"C2" CHAR(10),"C3" INT,"C4" INT) IN DBAREA01 CREATE INDEX "T3IX1" ON "T3"("C1","C2") IN DBAREA02 CREATE INDEX "T3IX2" ON "T3"("C1","C3") IN DBAREA03 SQL SELECT * FROM "T3" WHERE "C1"=1 AND "C2"='ABC' AND "C3">10 T3IX1 4 4 CREATE FIX TABLE "T4"("C1" INT,"C2" CHAR(10),"C3" INT,"C4" INT) IN DBAREA01 CREATE INDEX "T4IX1" ON "T4"("C1","C2") IN DBAREA02 CREATE INDEX "T4IX2" ON "T4"("C1","C3") IN DBAREA03 SQL SELECT * FROM "T4" WHERE "C1"=1 T4IX1 T4IX
111 4. CREATE FIX TABLE "T5"("C1" INT,"C2" CHAR(10),"C3" INT,"C4" INT) IN DBAREA01 CREATE INDEX "T5IX1" ON "T5"("C1") IN DBAREA02 CREATE INDEX "T5IX2" ON "T5"("C2") IN DBAREA03 SQL SELECT * FROM "T5" WHERE "C1"=1 ORDER BY "C2" T5IX1 T5IX1 2 T5IX CREATE FIX TABLE "T6"("C1" INT,"C2" CHAR(10),"C3" INT,"C4" INT) IN DBAREA01 CREATE INDEX "T6IX1" ON "T6"("C1","C2") IN DBAREA02 CREATE INDEX "T6IX2" ON "T6"("C3") IN DBAREA03 SQL SELECT "C1","C2" FROM "T6" T6IX1 T6IX1 6 T6IX2 7 7 CREATE FIX TABLE "T71"("C1" INT,"C2" CHAR(10),"C3" INT,"C4" INT) IN DBAREA01 CREATE INDEX "T71IX1" ON "T71"("C1") IN DBAREA02 CREATE INDEX "T71IX2" ON "T71"("C2") IN DBAREA03 CREATE FIX TABLE "T72"("C1" INT,"C2" CHAR(10),"C3" INT,"C4" INT) IN DBAREA04 CREATE INDEX "T72IX1" ON "T72"("C2") IN DBAREA05 CREATE INDEX "T72IX2" ON "T72"("C3") IN DBAREA06 SQL 91
112 4. SELECT * FROM "T71","T72" WHERE "T71"."C1">=1 AND "T72"."C2"="T71"."C2" AND "T72"."C3"<=10 T71IX1 T72IX1 XDB FROM T71 T71. C1 >=1 T72 T72. C2 = T71. C2 T72. C3 <=10 XDB XDB TP1/EE/Extended Data Cache SQL SQL XDB SQL DB 1 SQL SQL 4-5 SQL SQL 1 ORDER BY SQL 2 DISTINCT SQL ORDER BY DISTINCT 92
113 4. eexdbsql #SET OPT REPORT eexdbsql #SET OPT REPORT 10eexdbsql SQL #SET OPT REPORT DB ORDER BY 2 DISTINCT ORDER BY FROM ID DISTINCT ORDER BY DISTINCT SQL TP1/EE/Extended Data Cache SQL CREATE TABLE SQL TP1/EE/Extended Data Cache SQL CREATE INDEX
114 4. CREATE INDEX "T1IX1" ON "T1"("C1" ASC,"C2" ASC) IN DBAREA SELECT COUNT(*) FROM "T1" 2 SELECT COUNT("C1") FROM "T1" 3 SELECT COUNT(DISTINCT "C1") FROM "T1" 4 SELECT COUNT("C2") FROM "T1" 1 5 SELECT COUNT("C1") FROM "T1" WHERE "C1"<>1 2 6 SELECT COUNT(*) FROM "T1","T2"
115 5 XDB 5.1 XDB XDBPOOL TP1/EE
116 XDB XDBPOOL XDB XDBPOOL AFN 2 ARN DB 3 BON 4 BTN BETWEEN 5 CLN SQL 6 COLLE N 7 CST SQL 8 CTN CURRENT_TIMESTAMP 9 DTS SQL 10 EXN SQL 11 HVN 12 ICL1 ICL MAX KL 256 IPL KL 3.6(3)(b) IPL DB 13 ICL2 14 ICN 15 IDN SQL 16 IUC INSERT UPDATE 17 KL 3.6(3)(b) 18 LFD SQL 19 LFE 20 LFI 96
117 5. 21 LSQ 1 SQL 22 LUR UPDATE 3.5(3)(b) 23 MCL 24 MIX 25 MXR MXR TIN 12 MXCI IOAICN MAX1 TIN MXCI ID IOAICN IOAn n ICN ICN n 1 2 ICN IOAn IOAn 1 DTLn 4 4 IOA 0 0 DTLn n (3)(b) MAX1 26 NCOL 27 NIX 28 NN AND OR 29 NSQ 30 PDN SQL NOT OR 31 PL DB 32 PS DB 33 PSW DB 34 RID DECIMAL TIMESTAMP ROW INSERT UPDATE 35 RIN SQL ROWID 36 RWN SQL ROW 37 SCL 38 SCN DB 39 SIX 40 SLN 41 SQP SQL xdb_sqlpool_size 42 SUB TBN 97
118 5. 44 TCN 45 TCNV VARCHAR 46 TDP xdb_tabledefpool_size 47 TIN 48 TM thread_no reserve_thread_no reserve_start_pce_no 0 reserve_thread_no TP1/EE 49 TRL 3.5(3)(b) 50 UCL 51 VCL VARCHAR 52 VR1 SQL 53 WCL 1SQL 54 WIN 1SQL 55 WIX 1SQL 56 WNP DB 57 WTN 1SQL 58 XM 0 XM PL 3 KL 1601 VARCHAR XDB XDBPOOL XTC memory_xdb_area_size memory_xdb_area_size TP1/EE/Extended Transaction Controller memory_xdb_area_size MAXABCDEF 98
119 5. A B C D E F 1 A A TM4097 TDP SQP 160 MCL 496 MIX 888ARN SCN 4096 ICL1 MXR LFD LFI LFE TRL NIX 2 B BB11B2 a B1 B TM4097 TDP SQP SCN 4096 b B2 B MAX2 B2P 1.05 MAX 0 2 B2S 1.05SQP TM819 MAX VR14 VCL TBN 16 SCL 16 SIX MAX WCL MAX WIX 320 NSQ LSQ SUB2 B2H c B2P B2P IUC 24 CLN 16 IDN 16 VR1 99
120 5. d B2S B2S BON 158 SLN 8 TBN 16 IUC 16 EXN 32 CLN TBN8 160 TCN 496 TIN64 ICN 624 WTN 272 WIN 168 CLN 120 ICL2 64 UCL 112 RWN 104 RIN 200 AFN 72 HVN 64 CTN 24 CST93112 IDN 40 PDN 12 DTS 16 BTN 16 RID e B2H B2H B2HS B2HI B2HU B2HD B2HW B2HS SELECT B2HI INSERT B2HU UPDATE B2HD DELETE B2HW B2HS 1408 COLLEN KL 16 NCOL 10 NN B2HI 1024 PS 8 TCN 12 TCNV XM B2HU 1496 PS COLLEN KL 16 NCOL 10 NN 2 PS 12 TCNV XM B2HD 472 COLLEN KL 16 NCOL 10 NN PS XM B2HW WTN 76 WIX10968 PSW WNP PSW832WNP 8 WNP 128 COLLEN KL 16 NCOL 10 NN 8 TCN 12 TCNV XM f 1 2 SQL 3 SQL 4 SQL VARCHAR MAX2 SQL B2P B2P B2S B2S B2H SQL SQL B2H 5 SQL
121 INSERT UPDATE SQL 0 9 SQL INTEGER 4 2 SMALLINT 3 DECIMAL(m,n) m CHAR(n) n 5 VARCHAR(n) n TIMESTAMP(p) 7 p 2 7 ROWID 12 m n p C C TM4097 TDP SQP SCN D D TM4097 TDP SQP 160 MCL 496 MIX SCN 4096 LFE 5 E E TM4097 TDP SQP SCN 4096 LUR 56 TCN PL 3 KL 101
122 5. 6 F F C 102
123 TBL TBL 8448 TBL 2 TBL IDX INS DEL IDX UPD 103
124 5. IDX INS INSERT UPD UPDATE DEL DELETE 3.5(3)(b) 104
125 TP1/EE TP1/EE max_mem_size TP1/EE max_mem_size TP1/Server Base Enterprise Option max_mem_size tpc 8512 ARN XTS 1 T thread_no reserve_thread_no recover_thread_no send_thread_no 1 2 tpc trn_tran_process_count 3 ARN eexdbarea 4 XTS XDB XBS 1024 XBN 128 XFN 128 XBS XES 1024 TA XDB xdb_trace_out 5 XBS XDB xdb_trace_buffer_size 6 XBN XDB xdb_trace_buffer_number 7 XFN XDB xdb_trace_file_number 8 XES xdb_trace_entry_size 9 TA 8 TS TR TM TV TL TK TN TX TU TF TP TH TJ TT 10 TF MCP TFts TFtc TFu 105
126 5. 11 TFts MCP TCP Server eemcpcn -y mode=server -r ipaddr -r portno -r hostname IP 12 TFtc MCP TCP Client eemcpcn -y mode=client TFu MCP UDP eemcple UDP TH xtc_use=y 1 N 0 15 TJ XDB xdb_use=y 1 N 0 16 TK trb_stc_use=y 1 N 0 17 TL rap rap_listen_port TM thread_no reserve_thread_no reserve_start_pce_no=0 reserve_thread_no 19 TN name_use=y 1 N 0 20 TP UDP xtc_use=y myudprcvdef clgrpdef xtc_use=n 0 cluster_mode=n clgrpdef 21 TR mysvgdef 22 TS xtc_use=y send_thread_no xtc_use=n rpc_cmtsend_retry=y 1 N 0 23 TT PP mcp_use=y 1 N 0 24 TV recover_thread_no 106
127 5. 25 TX name_use Y rpc_loadbalance rpc_transfer_othersvg Y TU rap eesvgdef -t RAP 1 0 TP1/EE MCP MCP TP1/EE TP1/Server Base Enterprise Option MCP TP1/EE/Message Control Extension 107
128 system_work_size system_work_sizea B A eexdbsql SL OL B 4096 eexdbsql SL eexdbsql SQL OL eexdbsql -o A eexdbsql 4097 TP1/EE system_work_size system_work_size TP1/Server Base Enterprise Option 108
129 NI INSERT NU UPDATE ND DELETE Lk k INSERT Mk k UPDATE 109
130
131 6 XDB XDB 6.4 TP1/Server Base 6.5 XDB 6.6 SQL
132 XDB 6-1 XDB XDB 112
133 XDB DB SHMALL DB DB ENOSPC 2 SHMMNI DB XDB DB 1 DB ENOSPC 3 SHMMAX 1 2 DB 1 DB EINVAL 4 SHMMIN 1 2 DB 1 DB EINVAL 1 XDB eexdbarea -a 2 1 XDB eexdbarea -l 113
134 XDB XDB XDB TP1/EE/Extended Transaction Controller XDB XDB UAP UAP TP1/EE/Extended Data Cache SQL 114
135 TP1/Server Base XDB TP1/Server Base putenv putenv EEXDBDEFFILE XDB set set setrlimit_memlock = putenv EEXDBDEFFILE XDB XDB XDB 6.5 XDB set setrlimit_memlock = setrlimit RLIMIT_MEMLOCK setrlimit 115
136 XDB XDB XDB XDB XDB TP1/EE TP1/Server Base Enterprise Option XDB eexdbdefchk XDB set set xdb_memory_fixed = Y N set xdb_memory_terminate_remove = Y N set xdb_schema_definition_file = " SQL" set xdb_start_import_control_file = "" set xdb_stop_export_control_file = " " set xdb_trace_out= Y N set xdb_trace_file_size = XDB set xdb_trace_file_number = XDB set xdb_trace_buffer_size = XDB set xdb_trace_buffer_number = XDB set xdb_trace_entry_size = set xdb_sql_trace_out = Y N set xdb_sql_param_trace = NO IN OUT INOUT set xdb_sql_accesspath_out = Y N set xdb_sql_text_size = SQL set xdb_sql_param_size = set xdb_tabledefpool_size = set xdb_table_preread = Y N set xdb_sqlpool_size = SQL set xdb_lang = set xdb_forward_time_limit = DB set xdb_import_work_directory = set xdb_wtor_interval_time = eetrbwtor set xdb_default_service_mem_size = XDB XDB eexdbarea -n DB -t DB -a -l 1 -p 116
137 6. -s -m 1 2 eexdbsrv -s -m XDB XDB XDB set xdb_memory_fixed = Y N N DB Y DB Y DB DB N DB DB Y setrlimit_memlock setrlimit_memlock 6.4 TP1/Server Base set xdb_memory_terminate_remove = Y N N XDB DB Y DB N 117
138 6. DB XDB XDB DB xdb_schema_definition_file = " SQL " ((1 510 )) CREATE TABLE CREATE INDEX SQL XDB XDB SQL SQL 6.6 SQL xdb_start_import_control_file = " " ((1 510 )) XDB XDB 6.7 XDB xdb_stop_export_control_file = " " ((1 510 )) XDB XDB 6.7 XDB 118
139 6. xdb_trace_out = Y N N XDB XDB 7.4 XDB Y XDB N XDB xdb_trace_file_size = XDB (( )) XDB 1 xdb_trace_file_size xdb_trace_buffer_size xdb_trace_entry_size xdb_sql_text_size xdb_sql_param_size XDB 7.4.2(2)XDB xdb_trace_file_number = XDB ((3 100)) 3 XDB $DCDIR/spool/dceeinf/xdb XDB xdb_trace_buffer_size = XDB (( )) 400 XDB XDB XDB xdb_trace_file_size xdb_trace_buffer_number = XDB ((3 200)) 3 119
140 6. XDB xdb_trace_entry_size = (( )) 40 XDB XDB xdb_trace_entry_size XDB xdb_trace_file_size xdb_sql_trace_out = Y N N SQL SQL SQL SQL 7.5 SQL SQL Y SQL SQL N SQL SQL xdb_trace_out Y xdb_sql_param_trace = NO IN OUT INOUT NO NO IN OUT INOUT xdb_trace_out Y 120
141 6. xdb_sql_accesspath_out = Y N N 7.6 Y N xdb_trace_out Y xdb_sql_trace_out N SQL xdb_sql_text_size = SQL (( )) 4096 SQL SQL xdb_trace_file_size xdb_sql_param_size = (( )) xdb_trace_out Y xdb_sql_param_trace NO XDB xdb_trace_file_size xdb_trace_file_size xdb_tabledefpool_size = (( ))
142 xdb_table_preread = Y N N XDB Y XDB N XDB xdb_sqlpool_size = SQL (( )) 0 SQL 0 SQL SQL 4.1 SQL xdb_lang = SJIS XDB SJIS JIS TP1/Server Base LANG xdb_lang xdb_forward_time_limit = DB (( )) 1800 XDB xdb_import_work_directory = ((1 400 )) 122
143 6. 10eexdbimport -w xdb_wtor_interval_time = eetrbwtor ((0 60)) 5 eetrbwtor KFSB56208-Q 0 KFSB56208-Q xdb_default_service_mem_size = XDB XDB XDB (( )) 256 XDB (( )) 256 XDB XDB eexdbsrv TP1/EE UAP 6-2 xdb_default_service_mem_size 1 MI 2 ME 3 E1 1 4 E2 2 5 E3 3 6 E4 4 7 ES S 8 ER R 9 UI 123
144 6. XDB XDB XDB XDB XDB XDB XDB XDB XDB XDB XDB XDB XDB XDB XDB XDB XDB 5.1.2(2)(b) B2 B2 XDB XDB XDB XDB XDB XDB XDB TASKTM XDB XDB_ XDB XDB_ XDB TASKTM TASKTM XDB XDB 1. XDB_ XDB XDB_ 0 XDB 124
145 6. 2. XDB_ XDB XDB_ 1 XDB XDB XDB 3. XDB_ XDB XDB_ 1 XDB XDB XDB XDB XDB XDB XDB XDB XTC memory_xdb_area_size memory_xdb_limit_size eexdbarea eexdbarea -n DB -t DB -a -l 1 -p -s -m 1 2 DB DB DB 2.2DB -n DB DB ((1 30 )) DB DB -_ DB EDMST DB EDDIC DB DB 125
146 6. -t DB DATA DB DATA DATA DB DB DB INDEX DB DB WORK DB DB DB DB WORK DB -n -p -a DB (( )) 1 XDB XDB 1 -l XDB 1 (( )) DB XDB -a 2,10 XDB 2 DB l 1 126
147 6. (( )) 3200 DB 1 DB 1 -p (( )) DB XDB s ((1 80)) m 1 2 -a 1 2 eexdbarea 127
148 6. eexdbarea -n DBDATA01 -t DATA -a 10,50 -l p s 10 -m 40,45 eexdbarea -n DBINDX01 -t INDEX -a 5,20 -l p s 10 -m 15,18 eexdbarea -n DBWORK01 -t WORK -p eexdbsrv eexdbsrv -s -m XDB XDB XDB XDB -s ((1 31 )) TP1/EE service xdb_default_service_mem_size -m XDB XDB XDB (( )) XDB (( )) -s XDB XDB XDB xdb_default_service_mem_size eexdbsrv -m XDB 128
149 eexdbsrv -m XDB eexdbsrv -m XDB XDB XDB 1 a b 2 a b 3 c b 4 c d a xdb_default_service_mem_size XDB b xdb_default_service_mem_size XDB c eexdbsrv XDB d eexdbsrv XDB XDB XDB DCCONFPATH DCUAPCONFPATH DCCONFPATH DCUAPCONFPATH OpenTP1 OpenTP1 EEXDBDEFFILE XDB DCCONFPATH DCUAPCONFPATH XDB 1023 DCCONFPATH DCUAPCONFPATH XDB DCCONFPATH XDB DCCONFPATH DCUAPCONFPATH DCCONFPATH XDB DCUAPCONFPATH XDB 129
150 6. DCCONFPATH DCUAPCONFPATH XDB XDB 130
151 SQL XDB CREATE TABLE CREATE INDEX SQL SQL SQL XDB 1 SQL CREATE TABLE CREATE INDEX CREATE TABLE CREATE INDEX TP1/EE/Extended Data Cache SQL 2 SQL #COMMENT ; #COMMENT ; JIS SQL ; SQL ; SQL #COMMENT Table Definition; CREATE FIX TABLE "INSHOKU" ("SID" INT, "TEL_NO" CHAR(10), "POST_CODE" CHAR(7), "ADDRESS" CHAR(300)) IN DBAREA01; 131
152 6. 4 SQL SQL SQL SQL SQL XDB XDB 132
153 XDB #COMMENT ; #COMMENT ; JIS T1= " 2 2 """", XDB 133
154 6.,,,,, KFSB66054-E ((1 510 )) " /. ~ : " " " 2 * 134
155 6.,, " 2 A Z a z 0 9 * " _ (( )) 1024 ((0 1000)) TP1/EE TP1/EE 0 ((1 400 )) / 1. XDB xdb_import_work_directory 2. TP1/EE " /. ~ : 135
156 6. D S MAX B 1 B 2 Bn 80 b D n di 3.6(3)(a) DB b e 0 eexdbimport -d S D 4b e 2 Bi Bidi 3 P1 P212 P1 P2 2 P1 3.6(3)(c) 1 P2 1 Pi 136
157 6. #COMMENT ; T1="/tmp/inputdb.dat" #COMMENT ; T2="/home/xdbuser/tmp/table_a.dat", " ", "$", 256, 1, "/home/xdbuser/tmp" XDB XDB xdb_stop_export_control_file XDB,,, ((1 510 )) 137
158 6. " /. ~ : " " CHARACTER TIMESTAMP ' 'hitachi' " 2 *,, -s, 'hitachi',5,'database' " 2 A Z a z 0 9 * " 138
159 6. _ ((0 1000)) TP1/EE TP1/EE 0 #COMMENT ; T1="/tmp/outputdb.dat" #COMMENT ; T2="/home/xdbuser/tmp/table_b.dat", " ", " ", 1 139
160 XDB DB CSV 1 XDB XDB XDB NL CR/NL EOF CHARACTER TIMESTAMP 2 ' 2 '''' XDB xdb_lang 3 " 140
161 INTEGER 1, 2 2 DECIMAL 3 2 " " TIMESTA MP 4 CHARACT ER 5 "YYYY-MM-DD hh:mm:ss.nn n " :03:58 " :03:58.12" YYYYMMDD - hhmmss: YYYYMMDD hhmmss 0 ssnn n abcdef ABCDEF "abcdef" "ABCDEF" 1 INTEGER 2 3 DECIMAL TIMESTAMP 141
162 XDB eexdbexport eexdbexttbl XDB CSV 1 1 CHARACTER TIMESTAMP
163 7 XDB XDB XDB 7.5 SQL SQL
164 XDB 7-1 XDB 1 XDB XDB XDB XDB 7.4 XDB 7.5 SQL SQL
165 XDB XDB XDB XDB TP1/EE TP1/EE/Extended Transaction Controller CL XTC XDB XDB XDB XDB xdb_lang eexdbarea XDB 2 CL XTC standby_start_error_switch standby_start_error_switch TP1/ EE/Extended Transaction Controller DB DB XDB XDB TP1/EE TP1/EE/Extended Transaction Controller CL XTC XDB DB 145
166 XDB TP1/EE TASKTM TASKTM XDB TASKTM XDB TASKTM XDB TP1/EE TASKTM XDB TP1/EE TASKTM XDB TASKTM TASKTM TP1/Server Base Enterprise Option 7-2 TASKTM XDB TASKTM XDB 1 XDB_SQL SQL 2 XDB_ XDB_ 4 XDB_ SQL SQL XDB_ SQL SQL XDB_COMMIT COMMIT TP1/EE XDB COMMIT XDB COMMIT 11 XDB_COMMIT COMMIT
167 7. TASKTM XDB 13 XDB_ COMMIT ROLLBACK 14 XDB_ 15 XDB_ XDB XDB XDB XDB 1 1 SELECT SELECT OPEN FETCH CLOSE 1 SELECT 1 OPEN FETCH CLOSE 4 SQL 5 1 SELECT INSERT UPDATE DELETE XDB TP1/EE XDB TP1/EE XDB TP1/Server Base Enterprise Option 147
168 TP1/EE XDB XDB DB 3 1 DB 4 SQL 2 SQL SQL 5 SQL 6 SQL 7 SQL 8 SQL 9 SQL SQL SQL SQL SQL SQL SQL SQL SQL SQL SQL SQL SQL 3 SQL SQL SQL 148
169 7. XDB DB DB 2 SQL SQL 3 SQL SQL
170 XDB XDB XDB XDB SQL XDB XDB XDB SQL SQL SQL SQL SQL SQL 7.5 SQL SQL XDB XDB XDB XDB $DCDIR/spool/dceeinf/xdb XDB xdb_trace_file_number XDB xdbxxx xxx 3 svr xdb_trace_file_number 3 $DCDIR/spool/dceeinf/xdb XDB svrxdb001 svrxdb002 svrxdb003 2 XDB XDB XDB XDB 150
171 7. svrxdb001 svrxdb002 svrxdb003 XDB svrxdb001 svrxdb002 XDB svrxdb002 svrxdb003 svrxdb003 svrxdb001 XDB svrxdb001 XDB 1 XDB xdb_trace_file_size 3 XDB XDB KFSB85400-I XDB XDB XDB XDB XDB XDB XDB XDB XDB XDB 1 XDB XDB xdb_trace_out Y xdb_sql_trace_out=y SQL SQL xdb_sql_param_trace=in OUT INOUT xdb_sql_accesspath_out=y 2 XDB XDB XDB XDB 151
172 xdb_trace_file_size xdb_trace_file_number a TP1/EE service n XDB T XDB SQLSQL (a) a SQL SQL a n SQL SQL SQL 1 FETCH 3 SQL SQL 1 2 SQL SQL 152
173 7. SQL 1 1 SELECT 1 SQL INSERT UPDATE DELETE 1 b SQL SQL a n SQL c a SQL b 1SQL c FETCH d 1SQL MIN
174 7. d SQL xdb_sql_accesspath_out=y xdb_sql_trace_out=n n SQL 1SQL 1300 SQL130 WHERE XDB XDB eexdbed eexdbdump eetrbtbldump 1 eexdbed XDB eexdbed XDB 10eexdbed XDB XDB eexdbfput XDB XDB eexdbed 154
175 7. XDB XDB XDB eexdbfput XDB XDB XDB xdb_trace_buffer_size 2 eexdbdump XDB TP1/EE eexdbdump XDB eexdbed 10 eexdbed XDB 3 eetrbtbldump TP1/EE eetrbtbldump XDB eetrbtbldump TP1/Server Base Enterprise Option 155
176 SQL SQL SQL SQL SQL SQL XDB SQL SQL SQL eexdbed SQL SQL XDB 7.4 XDB eexdbed XDB SQL SQL 7-4 SQL 1 2 UAP UAP yyyy/mm/dd hh:mm:ss mmm.mmm 3 UAP 4 UAP ID UAP CNCTNO CNCTHDL IFA ID 5 SQL SQL SQLCODE SQLWARN SQL 156
177 7. 6 CC ED SQL EX SQL FT FETCH PR SQL SQL SQL 7-5 SQL 7 SQL 8 SQLCODE SQLCODE 9 SQLWARN 'W' 1 SQLWARN3 SQLWARN6 'WWW ' 2 '' 10 SQL 11 SQL SQL yyyy/mm/dd hh:mm:ss mmm.mmm SQL yyyy/mm/dd hh:mm:ss mmm.mmm 157
178 7. 12 SQL PR ED SQL XDB xdb_sql_text_size SQL *SQL* SQL PR ED SQL 1 SELECT INTO PR SQL DECLARE CURSOR FOR SQL JIS SQL SQL SQL hh:mm:ss mmm.mmm 7-5 SQL SQL 1 CLOSE CC 2 DELETE PR EX 3 ED 4 FETCH FT 5 INSERT PR EX 6 ED 7 OPEN PR EX 8 SELECT PR EX FT FT CC EX CC CC 9 1 SELECT PR EX FT FT CC FT 2 FT EX CC CC 10 UPDATE PR EX 11 ED 158
179 NO SQL 1 2 COD 7-7 COD LEN 3 LEN 7-7 COD LEN 4 IND 5 DATA 7-7 COD LEN COD TP1/ EE/Extended Data Cache SQL ROW 7-7 COD LEN COD LEN 1 INTEGER f1 4 2 DECIMAL(m,n) e5 m,n 3 SMALLINT f5 2 4 CHARACTER(n) c5 n 5 VARCHAR(n) c1 n 6 TIMESTAMP(p) 7d p 0 7 p 2 8 p 4 9 p ROWID 4d 12 8 ROW 45 m n p SQL ROW 159
180 7. XDB xdb_sql_param_size a INSERT *SQL* INSERT INTO TBL01(C1,C2) VALUES(?,?) : *INPRM* NO= 1 COD=f1 LEN= 4 IND= 0 DATA= *d... * *INPRM* NO= 2 COD=c5 LEN= 10 IND= 0 DATA= *aaabbbccc * : INTEGER CHAR(10) INSERT xdb_sql_param_trace=out *INPRM* VARCHAR DATA 2-1 "DATA=" 2 "--- SAME x LINES ---" x b *SQL*SELECT * FROM TBL01 WHERE C1=? : *INPRM* NO= 1 COD=f1 LEN= 4 IND= 0 DATA= *d... * : *OUTPM* NO= 1 COD=f1 LEN= 4 IND= 0 DATA= *d... * *OUTPM* NO= 2 COD=c5 LEN= 10 IND= 0 DATA= *aaabbbccc * : OPEN FETCH 160
181 7. *INPRM* WHERE *OUTPM* FETCH FETCH SQLCODE 0 xdb_sql_param_trace=out xdb_sql_param_trace=in SQL SQL SQL SQL 0 2 SQL 10eexdbed XDB SQL SQL SQL SQL XDB SQLCODE SQLWARN SQL SQL SQL SQL 1 SELECT 2 SQL SQLWARN3 'W' SQL SQL SQL 161
182 XDB SQL SQL SQL eexdbed SQL XDB 7.4 XDB eexdbed XDB a 162
183 7. # Select process # Table search methods schema name = aa...aa table name = bb...bb correlation name = cc...cc index name = dd...dd index type = ee...ee list number = ff...ff scan type = gg...gg search direction = hh...hh search condition[ 1] = ii...ii : search condition[ n] = ii...ii key condition = jj...jj row data condition = kk...kk set function = ll...ll aa...aa * WORK SCHEMA * bb...bb * WORK TABLE * cc...cc dd...dd * NONE * * WORK INDEX * ee...ee B-TREE INDEX UNIQUE B-TREE INDEX ff...ff gg...gg TABLE SCAN SINGLE INDEX SCAN SINGLE KEY SCAN 163
184 7. MULTI INDEX SCAN MULTI KEY SCAN ROWID FETCH ID hh...hh ASC DESC ii...ii [ = ] = [ > ] > [ < ] < [ >= ] >= [ <= ] <= [ BETWEEN ] BETWEEN [ RANGE ] RANGE 1 <=X <Y X<= <Y 2 < <= X< <=Y 3 < < X< <Y * NONE * * NONE * jj...jj [ = ] = [ > ] > [ < ] < [ >= ] >= [ <= ] <= [ <> ] <> [ BETWEEN ] BETWEEN 164
185 7. [ NOT BETWEEN ] NOT BETWEEN [ RANGE ] RANGE 1 <=X <Y X<= <Y 2 < <= X< <=Y 3 < < X< <Y [ OR ] OR OR [ NOT ] NOT NOT kk...kk EXISTENCE ll...ll ACCELERATION b # Select process # Table join methods # Nested-loop join (outer table) # Table search methods : # Nested-loop join (inner table) # Table search methods : # Nested-loop join (outer table) # Nested-loop join (inner table) # Table search methods (a) 165
186 7. XDB 2 # Insert process # Insert table information schema name = aa...aa table name = bb...bb aa...aa bb...bb 3 # Update process # Update table information schema name = aa...aa table name = bb...bb aa...aa bb...bb 4 # Delete process # Delete table information schema name = aa...aa table name = bb...bb 166
187 7. aa...aa bb...bb 5 # Create work table process # Create table information schema name = aa...aa table name = bb...bb [ cc...cc columns ] index name = dd...dd [ ee...ee columns ] index type = ff...ff list type = gg...gg list number = hh...hh aa...aa * WORK SCHEMA * bb...bb * WORK TABLE * cc...cc dd...dd * WORK INDEX * ee...ee ff...ff B-TREE INDEX gg...gg GROUP DISTINCT ORDER ORDER BY hh...hh 6 167
188 7. # Insert work table process # Insert table information schema name = aa...aa table name = bb...bb list number = cc...cc # Get insert data # Table search methods... 1 : # Insert work table process # Insert table information schema name = aa...aa table name = bb...bb list number = cc...cc # Get insert data # Table join methods... 2 : 1 # Table search methods (1)(a) 2 # Table join methods (1)(b) aa...aa * WORK SCHEMA * bb...bb * WORK TABLE * cc...cc SELECT SQL SQL SELECT * FROM "T1" WHERE "C1"=10 168
189 7. ******* ACCESS PATH ******* # Select process # Table search methods schema name = XDBUSER table name = T1 index name = T1IX1 index type = B-TREE INDEX scan type = SINGLE INDEX SCAN search direction = ASC search condition[ 1] = [=] 2 SELECT ORDER BY SQL SQL SELECT * FROM "T1" WHERE "C1">=10 ORDER BY "C2" ASC 169
190 7. ******* ACCESS PATH ******* # Create work table process # Create table information schema name = * WORK SCHEMA * table name = * WORK TABLE * [ 2 columns ] index name = * WORK INDEX * [ 1 columns ] index type = B-TREE INDEX list type = ORDER list number = 1 # Insert work table process # Insert table information schema name = * WORK SCHEMA * table name = * WORK TABLE * list number = 1 # Get insert data # Table search methods schema name = XDBUSER table name = T1 index name = T1IX1 index type = B-TREE INDEX scan type = SINGLE INDEX SCAN search direction = ASC search condition[1] = [>=] # Select process # Table search methods schema name = * WORK SCHEMA * table name = * WORK TABLE * index name = * WORK INDEX * index type = B-TREE INDEX list number = 1 scan type = SINGLE INDEX SCAN search direction = ASC # Table search methods schema name = XDBUSER table name = T1 index name = * NONE * scan type = ROWID FETCH # Create work table process ORDER BY # Insert work table process # Select process 3 INSERT SQL SQL 170
191 7. INSERT INTO "T1" VALUES(10,'ABC',1) ******* ACCESS PATH ******* # Insert process # Insert table information schema name = XDBUSER table name = T1 4 UPDATE SQL SQL UPDATE "T1" SET "C2"='XYZ' WHERE "C1"=10 ******* ACCESS PATH ******* # Select process # Table search methods schema name = XDBUSER table name = T1 index name = T1IX1 index type = B-TREE INDEX scan type = SINGLE KEY SCAN search direction = ASC search condition[1] = [=] # Update process # Update table information schema name = XDBUSER table name = T1 # Select process # Update process 5 DELETE SQL SQL 171
192 7. DELETE FROM "T1" WHERE "C1"=10 ******* ACCESS PATH ******* # Select process # Table search methods schema name = XDBUSER table name = T1 index name = T1IX1 index type = B-TREE INDEX scan type = SINGLE KEY SCAN search direction = ASC search condition[1] = [=] # Delete process # Delete table information schema name = XDBUSER table name = T1 # Select process # Delete process 172
193 XDB XDB 2. DB 3. XDB DB eexdbarea DB eexdbarea 4. SQL CREATE TABLE CREATE INDEX XDB 173
194
195 DB SQL 175
196 DB eexdbsta 10eexdbsta DB eexdbsta 10eexdbsta 3 TASKTM SQL TASKTM XDB 4 SQL XDB 176
197 DB DB DB eexdbsta 8-2 DB 1 2 DB DB 3 CREATE TABLE PCTFREE 4 CREATE TABLE PCTFREE DB DB DB DB DB DB DB
198 DB eexdbsta 8-3 DB 1 ID 256 ID 255 DB 178
199 eexdbsta ID DB 179
200 SQL TASKTM 8-5 SQL SQL SQL SQL 5 SQL SQL SQL SQL SQL SQL 3.3.1(1)(c) 4.3 SQL 3.3 SQL SQL xdb_tabledefpool_size SQL SQL SQL xdb_sqlpool_size 4.1 SQL SQL SQL SQL xdb_sqlpool_size SQL SQL 180
201
202 SQL SQL XDB SQL $DCDIR/spool/dceeinf/xdb/ xdbxxx 2 syslog syslogfile XDB 3 XDB /etc/syslog.conf $DCDIR/spool/dceeinf/log/ xxx 4 TP1/Server Base TP1/Server Base UAP TP1/Server Base OpenTP1 /tmp/ betran.log prcout xxx 3 TP1/EE eerasget TP1/Server Base dcrasget eerasget dcrasget XDB eexdbrasget XDB DB 10 eexdbrasget eerasget TP1/Server Base Enterprise Option dcrasget OpenTP1 TP1 TP1/EE/ Extended Transaction Controller 182
203 9. XDB 183
204 XDB eexdbexttbl -f -k -s eexdbexttbl 10eexdbexttbl eexdbexttbl $DCDIR/spool/dceeinf/hamdump _ ID_ ID_CL _xdb_ ID 16 8 CL DB TP1/EE/Extended Transaction Controller 184
205 10 XDB eetrbwtor eexdbdefchk XDB eexdbdump XDB eexdbed XDB eexdbexport eexdbexttbl eexdbfput XDB eexdbimport eexdbmemdmp eexdbrasget eexdbshmrm eexdbsql SQL eexdbsta 185
206 10. XDB 10-1 XDB API 1 XDB eexdbdefchk 2 eexdbexport eexdbexttbl eexdbimport eexdbmemdmp XDB eexdbsta eexdbshmrm eexdbdump 9 XDB 10 XDB eexdbed eexdbfput eexdbrasget eetrbwtor 13 SQL eexdbsql TP1/EE 186
207 10. TP1/EE API ee_adm_call_command CL CL TP1/EE XDB TP1/Server Base Enterprise Option TP1/Server Base Enterprise Option eexdbimport XTC CL CL TP1/EE/Extended Transaction Controller 187
208 10. eetrbwtor eetrbwtor eetrbwtor eetrbwtor TP1/EE XDB eetrbwtor TP1/Server Base Enterprise Option XDB KFSB56208-Q KFSB56208-Q 10-2 KFSB56208-Q ID 1 KFSB Q -r -c -r -c 188
209 10. eexdbdefchk XDB eexdbdefchk XDB XDB XDB XDB XDB XDB XDB eexdbdefchk -t syntax detail XDB -t syntax detail XDB syntax eexdbarea detail syntax eexdbarea SHMALL SHMMAX SHMMNI eexdbarea xdb_memory_fixed eexdbarea 189
210 10. eexdbdefchk XDB eexdbarea 1 2 xdb_trace_file_size xdb_trace_buffer_size xdb_trace_entry_size xdb_sql_text_size xdb_sql_param_size DB EDMST EDDIC eexdbarea DB DB DB eexdbarea 2048 eexdbarea DB XDB (( )) XDB 190
211 10. eexdbdefchk XDB eexdbdefchk XDB eexdbdefchk eexdbdefchk XDB XDB -t detail XDB syntax syntax detail 191
212 10. eexdbdump XDB eexdbdump XDB TP1/EE XDB TP1/EE XDB XDB eexdbdump -r ID -s sql -x -v -r ID 16 ((8 )) ID -s sql sql SQL SQL -x 16 ((0 ffffffff)) XDB XDB -v ((1 31 ))
213 10. eexdbdump XDB (( )) TP1/EE XDB eexdbdump eexdbed 10eexdbed XDB -e r XDB eexdbdump TP1/EE * XDB XDB XDB * XDB XDB 0 * eexdbdump 0 0 eexdbdump 193
214 10. eexdbed XDB eexdbed XDB XDB XDB eexdbed -e -t -r ID -s sql -x -v XDB XDB 10-3 eexdbed -e -t -r -s -x -v XDB r f sql -e r f -t -r -s sql -x -v XDB 194
215 10. eexdbed XDB -e f r f XDB XDB -t XDB XDB XDB hhmmss MMDD YYYY hh 00 hh 23 mm 00 mm 59 ss 00 ss 59 MM 01 MM 12 DD 01 DD 31 YYYY 1970 YYYY
216 10. eexdbed XDB -r ID 16 ((8 )) ID -s sql sql SQL -x 16 ((0 ffffffff)) XDB XDB -v ((1 31 )) 10 XDB XDB (( )) XDB -e f XDB 1024 eexdbed -e r XDB -e r eexdbed 196
217 10. eexdbed XDB 1 xdb_sql_param_trace NO 2 SQL SQLCODE 0 SQL SQL SQL 3 SQL xdb_sql_trace_out Y 197
218 10. eexdbed XDB 4 xdb_sql_accesspath_out Y e r 1 aa-aa[-aa] TP1/EE 2 AA-AA-[AA] XDB 3 bb...bb 4 cc...cc XDB 5 dddd/dd/dd dd:dd:dd ddd.ddd XDB XDB 6 ee-ee[-ee] XDB TP1/EE 7 EE-EE[-EE] XDB XDB 8 T1 XDB 9 ff...ff gggggggg TP1/EE ID hhhh/hh/hh hh:hh:hh hhh.hhh SQL 12 i1...i i2...i jjjj/jj/jj jj:jj:jj jjj.jjj UAP 15 kk...kk ll...ll nn...nn IFA oo...oo ID pp...pp SQL qq...qq 4 21 rr...rr ss...ss SQLCODE tt...tt SQLWARN
219 10. eexdbed XDB 24 uuuu/uu/uu uu:uu:uu uuu.uuu SQL 25 vvvv/vv/vv vv:vv:vv vvv.vvv SQL 26 ww:ww:ww SQL 27 xx...xx SQL 28 yy...yy INPRM OUTPM 29 zz...zz 30 a1 31 d1...d1 32 e1...e1 33 h1...h1 16 XDB xdb_sql_param_size 34 j1...j k1...k l1...l m1...m n1...n o1 40 pppp/pp/pp pp:pp:pp ppp.ppp XDB 41 qq XDB -e f XDB -e f eexdbed 199
220 10. eexdbed XDB 1 2 XDB e f 1 aa-aa[-aa] TP1/EE 2 AA-AA[-AA] XDB 3 bb...bb 4 cc...cc XDB 5 dddd/dd/dd dd:dd:dd ddd.ddd XDB XDB 6 ee-ee[-ee] XDB TP1/EE 7 EE-EE[-EE] XDB XDB 8 T1 XDB 9 ff...ff gggggggg TP1/EE ID 16 8 * 200
221 10. eexdbed XDB eexdbed 0 0 eexdbed 201
222 10. eexdbexport eexdbexport XDB eexdbimport eexdbexport -g -k -s -i -r -g ((1 31 )) TP1/EE -k " " CHARACTER TIMESTAMP -k ' 'hitachi' "' 2 202
223 10. eexdbexport * -s eexdbexport -k ' ' -s,, -s, 'hitachi',5,'database' "' 2 A Z a z 0 9 * " _ -k eexdbexport -s ' ' -i ((0 1000)) TP1/EE TP1/EE 0 203
224 10. eexdbexport -r ((1 6000)) TP1/EE / " '" '"table/shouhin"' ((1 510 )) /. ~ : ' eexdbexport 0 0 eexdbexport 204
225 10. eexdbexport eexdbexport eexdbexport eexdbexport eexdbexport LANG ja_jp.sjis eexdbexport 205
226 10. eexdbexttbl eexdbexttbl eexdbmemdmp eexdbexttbl -f -k -s -f ((1 510 )) /. ~ : ' -k " " 206
227 10. eexdbexttbl CHARACTER TIMESTAMP -k ' 'hitachi' "' 2 * -s eexdbexttbl -k ' ' -s,, -s, 'hitachi',5,'database' "' 2 A Z a z 0 9 * " _ -k 207
228 10. eexdbexttbl eexdbexttbl -s ' ' / " '" '"table/shouhin"' ((1 510 )) /. ~ : ' eexdbexttbl 0 0 eexdbexttbl eexdbexttbl eexdbexttbl eexdbexttbl eexdbexttbl LANG ja_jp.sjis 208
229 10. eexdbexttbl eexdbexttbl 209
230 10. eexdbfput XDB eexdbfput XDB XDB XDB XDB SQL XDB eexdbfput -g -g ((1 31 )) TP1/EE eexdbfput
231 10. eexdbimport eexdbimport XTC CL CL TP1/ EE/Extended Transaction Controller eexdbexport -g -d -k -s -b -i -w -R -g ((1 31 )) TP1/EE -d 211
232 10. eexdbimport -k " " "' 2 * -s eexdbimport -k ' ' -s,, "' 2 A Z a z 0 9 * " _ -k eexdbimport -s ' ' 212
233 10. eexdbimport -b (( )) i ((0 1000)) TP1/EE TP1/EE 0 -w ((1 400 )) / 1. XDB xdb_import_work_directory 2. XDB /. ~ : '" 6.7 -R ((1 6000))
234 10. eexdbimport TP1/EE / " '" '"table/shouhin"' ((1 510 )) /. ~ : '" eexdbimport 0 0 eexdbimport SQL eexdbimport DB eexdbimport eexdbmemdmp XDB 214
235 10. eexdbimport eexdbimport eexdbimport LANG ja_jp.sjis 215
236 10. eexdbmemdmp eexdbmemdmp TP1/EE TP1/EE eexdbexttbl eexdbmemdmp -g -s -r -g ((1 31 )) TP1/EE -s (( )) 10 TP1/EE TP1/EE eexdbmemdmp TP1/EE -r ((1 6000)) 60 TP1/ EE TP1/EE 216
237 10. eexdbmemdmp $DCDIR/spool/dceeinf/hamdump _ ID_ ID_CL _xdb_ ID 16 8 CL eexdbmemdmp 0 0 eexdbmemdmp eexdbmemdmp eexdbmemdmp DB 217
238 10. eexdbrasget eexdbrasget XDB TP1/EE eerasget TP1/Server Base dcrasget eexdbrasget TP1/EE eerasget TP1/Server Base dcrasget TP1/EE eerasget eexdbrasget XDB eerasget -l eexdbrasget -l eerasget -s TP1/Server Base dcrasget eexdbrasget XDB dcrasget eexdbrasget -l -s eexdbrasget -l -s -l -s -l XDB -s XDB -l -s 218
239 10. eexdbrasget TAR tar eexdbrasget eexdbrasget OpenTP1 eexdbrasget 0 0 eexdbrasget eexdbrasget OpenTP1 eexdbrasget DB tar DB 2 eexdbrasget PATH LD_LIBRARY_PATH DCDIR DCCONFPATH TP1/Server Base Enterprise Option OpenTP1 219
240 10. eexdbshmrm eexdbshmrm XDB XDB DB TP1/EE DB XDB XDB DB eexdbshmrm -g, -g, ((1 31 )) TP1/EE 10 0 eexdbshmrm 0 0 eexdbshmrm eexdbshmrm TP1/EE eexdbshmrm 220
241 10. eexdbshmrm 221
242 10. eexdbsql SQL eexdbsql SQL SQL eexdbsql SQL eexdbsql #EXIT eexdbsql SQL SQL eexdbsql -g -V -o -r -g ((1 31 )) TP1/EE -V SQL SQL SQL eexdbsql -g srvl < infile SQL eexdbsql -g srvl -V < infile SQL SQL SQL 222
243 10. eexdbsql SQL eexdbsql -g srvl > outfile SQL eexdbsql -g srvl -V > outfile SQL SQL SQL SQL -o ((1 510 )) SQL SQL SQL eexdbsql /. ~ : ' SQL eexdbsql -V -o -V -o V -o -V -o 1 SQL SQL 2 60 SQL SQL 223
244 10. eexdbsql SQL -o -V -o -V -r ((1 6000)) TP1/EE SQL SQL SQL SQL 10-7 SQL SQL SQL 1 SQL DELETE 2 INSERT 3 SELECT 4 UPDATE SQL 1SQL eexdbsql SQL eexdbsql 10-8 eexdbsql 1 #COMMENT eexdbsql 2 #EXIT eexdbsql 3 #SET DUMPMODE 16 4 #SET OPT REPORT 224
245 10. eexdbsql SQL SQL SQL eexdbsql SQL COMMAND? 2 NEXT? SQL ; eexdbsql #EXIT SQL X'0A' SQL X'00' X'1F' eexdbsql #EXIT #EXIT EOF eexdbsql eexdbsql -g srvl -V < infile infile 225
246 10. eexdbsql SQL SELECT "C1","C2" FROM "T1"; #EXIT; SQL 1 ; SQL SELECT "C1", "C2" FROM "T1"; SQL eexdbsql eexdbsql #COMMENT #COMMENT #EXIT eexdbsql eexdbsql #EXIT #SET DUMPMODE
247 10. eexdbsql SQL A F #SET DUMPMODE ON OFF ON 16 OFF eexdbsql OFF #SET OPT REPORT #SET OPT REPORT ON OFF ON SQL OFF eexdbsql OFF SELECT #SET OPT REPORT ON; SELECT * FROM "T1" WHERE C1=100 ORDER BY C2; KFSB96104-I The index "IX#T1C1" of table "XDBUSER"."T1" will be used. KFSB96105-I Executing this SQL will create 1 work tables. SQL SQL 227
248 10. eexdbsql SQL SQL eexdbsql SQL 60 -o -o eexdbsql -g srvl -V tee outlog -o eexdbsql -g srvl -o outlog SQL SELECT SELECT SELECT 'C1 = ',"C1" FROM "T1"; (1) EXP C (2) C1 = (3) C1 = *************** (4) KFSB96103-I 2 rows were selected. 1. EXP
249 10. eexdbsql SQL ' : 3 ' 4 ID 16? ROW * 4. SELECT SQL SELECT SQL DELETE INSERT UPDATE * SELECT SQL COMMAND? DELETE FROM "T1" WHERE "C1"=0; KFSB96103-I 1 rows were deleted. COMMAND? INSERT INTO "T1"("C1","C2") VALUES( ,'abc'); KFSB96103-I 1 rows were inserted. COMMAND? UPDATE "T1" SET "C1"=0 WHERE "C1"<0; KFSB96103-I 2 rows were updated. eexdbsql JIS SQL JIS 229
250 10. eexdbsql SQL LANG ja_jp.sjis eexdbsql
251 10. eexdbsta eexdbsta DB eexdbsta -g -p -l -r -g ((1 31 )) TP1/EE -p -l -p -p DB -l DB -p -r ((1 6000)) TP1/EE 231
252 10. eexdbsta eexdbsta 0 0 eexdbsta eexdbsta VV-RR ** Physical Analysis ** YYYY-MM-DD hh:mm:ss Service Group name : tp1ee Area name : DBAREA_001 Area Type : DATA Block size : 70.1 MB Initial blocks : 1 Extension count : 1 Block count : 1 Max Block count : 65,535 Area size : 70.1 MB Free space : 5.22 MB System space : 120 KB [Segment information] Size : 8 Pages Used : 691 Segments : 747 Usage rate : 92.5 % [Page information] Size : 12,288 B Used : 5,460 Pages : 5,974 Usage rate : 91.3 % Area name : DBAREA_002 Area Type : DATA : 3 20 DB DB
253 10. eexdbsta XDB YYYY-MM-DD hh:mm:ss YYYY MM DD hh mm ss 2 TP1/EE 3 DB DB DB 4 DB DB MASTER DB DIC DB DATA DB INDEX DB DB 1 DB 1 DB 8 9 DB XDB eexdbarea -a 0 10 DB
254 10. eexdbsta DB 16 % DB 20 % eexdbsta VV-RR ** Logical Analysis (DB area)** YYYY-MM-DD hh:mm:ss Service Group name : tp1ee01 Area name : DBAREA_001 <Table Information> Table identifier : T001 Table ID : Schema : XDBUSER Rows : 550 Allocated : 6.56 MB Used space : 6.45 MB Unused space : 110 KB Segments : 70 Pages : 560 Full pages : 2 Unused space in full pages : 14.9 KB [Basic row segment information] Allocated : 6.46 MB Used space : 6.44 MB Unused space : 24.0 KB Segments : 69 Pages : 552 Full pages : 0 Unused space in full pages : 0 B Table identifier : T
255 10. eexdbsta <Index Information> Index identifier : IDX1 Index ID : Table identifier : T001 Schema : XDBUSER Allocated : 30.0 MB Used space : 12.6 MB Unused space : 17.4 MB Segments : 321 Pages : 2,568 Index level : [Upper page segment information] Allocated : 26.8 MB Used space : 10.4 MB Unused space : 16.3 MB Segments : 286 Pages : 2, [Lower page segment information] Allocated : 3.28 MB Used space : 2.23 MB Unused space : 1.04 MB Segments : 35 Pages : [Leaf page information] Allocated : 3.21 MB Used space : 2.23 MB Unused space : 997 KB Pages : [Row ID list page information] Allocated : 12.0 KB Used space : 1.46 KB Unused space : 10.5 KB Pages : 1 Index identifier : IND2 235
256 10. eexdbsta Area Type : DATA Block size : 70.1 MB Initial blocks : 1 Extension count : 1 Block count : 1 Max Block count : 65,535 Area size : 70.1 MB Free space : 5.22 MB System space : 120 KB Used space : 45.7 MB Unused space : 18.9 MB Usage rate : 65.4 % [Segment information] Size : 8 Pages Used : 691 Segments : 747 Usage rate : 92.5 % [Page information] Size : 12,288 B Used : 5,460 Pages : 5,974 Usage rate : 91.3 % [Table information] Tables : 80 Segments : 518 Used pages : 3,315 Full pages : 6 Full page rate : 0.18 % Used space : 48.5 MB [Index information] Indexes : 135 Segments : 172 Used pages : 1,100 Full pages : 3 Full page rate : 0.18 % Used space : 10.3 MB DB DB DB DB DB 236
1,.,,,., RDBM, SQL. OSS,, SQL,,.
1,.,,,., RDBM, SQL. OSS,, SQL,,. 3 10 10 OSS RDBMS SQL 11 10.1 OSS RDBMS............................ 11 10.1.1 PostgreSQL................................. 11 10.1.2 MySQL...................................
~~~~~~~~~~~~~~~~~~ wait Call CPU time 1, latch: library cache 7, latch: library cache lock 4, job scheduler co
072 DB Magazine 2007 September ~~~~~~~~~~~~~~~~~~ wait Call CPU time 1,055 34.7 latch: library cache 7,278 750 103 24.7 latch: library cache lock 4,194 465 111 15.3 job scheduler coordinator slave wait
はじめての帳票作成
ucosminexus EUR 3020-7-532 OS Windows Vista Windows XP P-26D2-5684 ucosminexus EUR Designer 08-00 P-26D2-5784 ucosminexus EUR Developer 08-00 ISO9001 TickIT Microsoft Microsoft Corp. Microsoft Excel Microsoft
橡j_Oracle_whitepaper.PDF
Pervasive-Oracle 1 1 Pervasive Software Pervasive-Oracle / Pervasive Oracle Pervasive-Oracle ISV Pervasive-Oracle Pervasive.SQL Oracle 2 Pervasive-Oracle Pervasive-Oracle Pervasive.SQL Oracle Open Database
A book
Hitachi Multi Payment Network communications server 3000-3-493-40 P-1B43-6111 Hitachi Multi Payment Network communications server Base 01-03( OS HP-UX 11.0 HP-UX 11i) P-1B43-6311 Hitachi Multi Payment
0226_ぱどMD表1-ol前
No. MEDIA DATA 0 B O O K 00-090-0 0 000900 000 00 00 00 0000 0900 000900 AREA MAP 0,000 0,000 0,000 0,000 00,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 00,000 0,000
,, create table drop table alter table
PostgreSQL 1 1 2 1 3,, 2 3.1 - create table........................... 2 3.2 - drop table............................ 3 3.3 - alter table............................ 4 4 - copy 5 4.1..................................
VNSTProductDes3.0-1_jp.pdf
Visual Nexus Secure Transport 2005/10/18 Visual Nexus http:// www.visualnexus.com/jp/support.htm Visual Nexus Secure Transport 2005/02/25 1 2005/10/18 Ver3.0-1 2005 10 18 108-0075 21119 2 Visual Nexus
MultiPASS Suite 3.20 使用説明書
TM MultiPASS Suite Ver.3.20 for Windows ii iii Copyright 2000 Canon Inc. ALL RIGHTS RESERVED iv v vi vii viii ix x 1 1 1-1 1 1 2 3 1-2 4 5 1 1-3 1 6 1-4 7 1 8 9 1-5 10 1 11 1-6 1 1-7 1 1-8 2 1 1-9 1 1
1 SQL Server SQL Oracle SQL SQL* Plus PL/SQL 2 SQL Server SQL Server SQL Oracle SQL SQL*Plus SQL Server GUI 1-1 osql 1-1 Transact- SQL SELECTFROM 058
1 SQL Server SQL Oracle SQL SQL* Plus PL/SQL 2 SQL Server SQL Server SQL Oracle SQL SQL*Plus SQL Server GUI 1-1 osql 1-1 Transact- SQL SELECTFROM 058 2 Excel 1 SQL 1 SQL Server sp_executesql Oracle SQL
CAC
VOL.24NO.1 61 IMS Transaction 3270 DataBase Transaction OS/370 IMS Traditional Transaction Web Browser Transaction Internet WWW AP IIS APache WebLogic Websphere DataBase Oracle DB2 SQL Server Web Browser
: ORDER BY
11 7 8 1 : ORDER BY 1 1.1......................................... 1 1.2......................................... 1 1.3................................ 1 1.4 WHERE SELECT ORDER BY.................. 2 2
JP1/Integrated Management - Service Support 操作ガイド
JP1 Version 9 JP1/Integrated Management - Service Support 3020-3-R92-10 P-242C-8F94 JP1/Integrated Management - Service Support 09-50 OS Windows Server 2008 Windows Server 2003 OS JP1/Integrated Management
book
Bibliotheca21 Personal 3020-7-245-30 P-26D3-A114 Bibliotheca21 Personal 01-30 OS Windows 2000 Windows Server(R) 2003 Windows XP Windows Server(R) 2008 Windows Vista(R) Windows 7 Adobe Adobe Systems Incorporated
Page 1
... 1... 3... 4... 6 0100... 8 0102... 11 0103 FTP... 12 0105... 13 0109... 14... 15 0130... 16 0150 STD... 17 0154 TXT... 18 0170... 19 0180 1... 20 0190 2... 21 0196 3... 22 0200... 23 0300... 24 0500
高信頼化システム監視機能 HAモニタ kit for Oracle
HA kit for Oracle 3000-9-135 P-F9S2C-E1111 HA kit for Oracle 01-00 OS Red Hat Enterprise Linux AS 4(x86) Red Hat Enterprise Linux ES 4(x86) Red Hat Enterprise Linux AS 4(AMD64 & Intel EM64T) Red Hat Enterprise
ストラドプロシージャの呼び出し方
Release10.5 Oracle DataServer Informix MS SQL NXJ SQL JDBC Java JDBC NXJ : NXJ JDBC / NXJ EXEC SQL [USING CONNECTION ] CALL [.][.] ([])
1 ex01.sql ex01.sql ; user_id from (select user_id ;) user_id * select select (3+4)*7, SIN(PI()/2) ; (1) select < > from < > ; :, * user_id user_name
SQL mysql mysql ( mush, potato) % mysql -u mush -p mydb Enter password:****** mysql>show tables; usertable mysql> ( ) SQL (Query) : select < > from < > where < >; : create, drop, insert, delete,... ; (
tkk0408nari
SQLStatement Class Sql Database SQL Structured Query Language( ) ISO JIS http://www.techscore.com/tech/sql/02_02.html Database sql Perl Java SQL ( ) create table tu_data ( id integer not null, -- id aid
untitled
Oracle Direct Seminar SQL Agenda SQL SQL SQL SQL 11g SQL FAQ Oracle Direct SQL Server MySQL PostgreSQL Access Application Server Oracle Database Oracle Developer/2000 Web Oracle Database
CRA3689A
AVIC-DRZ90 AVIC-DRZ80 2 3 4 5 66 7 88 9 10 10 10 11 12 13 14 15 1 1 0 OPEN ANGLE REMOTE WIDE SET UP AVIC-DRZ90 SOURCE OFF AV CONTROL MIC 2 16 17 1 2 0 0 1 AVIC-DRZ90 2 3 4 OPEN ANGLE REMOTE SOURCE OFF
31 33
17 3 31 33 36 38 42 45 47 50 52 54 57 60 74 80 82 88 89 92 98 101 104 106 94 1 252 37 1 2 2 1 252 38 1 15 3 16 6 24 17 2 10 252 29 15 21 20 15 4 15 467,555 14 11 25 15 1 6 15 5 ( ) 41 2 634 640 1 5 252
橡実践Oracle Objects for OLE
THE Database FOR Network Computing 2 1. 2 1-1. PL/SQL 2 1-2. 9 1-3. PL/SQL 11 2. 14 3. 16 3-1. NUMBER 16 3-2. CHAR/VARCHAR2 18 3-3. DATE 18 4. 23 4-1. 23 4-2. / 24 26 1. COPYTOCLIPBOARD 26 III. 28 1.
XML Consortium & XML Consortium 1 XML Consortium XML Consortium 2
& 1 2 TCO DB2 DB2 UDB DB DB V8.2 V8.2 DB2 DB2 UDB V8.1 V8.1 DB2 9 3 CLOB XML XML DB2 9 purexml XML XML DOC XML DOC XML DOC XML DOC VARCHAR/CLOB XML ( ) 4 XML & XML ( & ) DB2 XML SQL/XML DB2 DB2 : DB2 /
ESMPRO/DeliveryManager
DeliveryManager Standard Edition [] (1) (2) (3) (4) (3) Microsoft MSMS-DOS Microsoft Windows Microsoft Corporation ESMPRO TM HP-UX Hewlett-Packard UNIX X/Open Motif Open Software Foundation,Inc. X Window
MultiPASS B-20 MultiPASS Suite 3.10使用説明書
TM MultiPASS Suite Ver.3.10 for Windows ii iii Copyright 1999 Canon Inc. ALL RIGHTS RESERVED iv v vi vii viii ix x 1 2 3 4 5 6 7 8 9 xi xii 1 1 1-1 1 2 3 1-2 4 5 1 1-3 6 1-4 1 7 8 1-5 9 10 11 1-6 1 1-7
devkit.book
Bibliotheca21 Development Kit Version 2 3020-7-244 P-24D3-AC24 Bibliotheca21 Development Kit for ASP Version 2 02-00 OS Windows 2000 Windows Server 2003 Windows XP Microsoft Microsoft Corp. Microsoft Internet
COBOLソース解析支援 導入・運用ガイド
COBOL 3020-3-C10-10 P-2651-1214 COBOL 01-01 OS Windows XP Windows Vista Windows 7 InstallShield Macrovision Corporation / Internet Explorer Microsoft Corporation Microsoft Microsoft Corporation Microsoft
ii II Web Web HTML CSS PHP MySQL Web Web CSS JavaScript Web SQL Web 2014 3
Web 2.0 Web Web Web Web Web Web Web I II I ii II Web Web HTML CSS PHP MySQL Web Web CSS JavaScript Web SQL Web 2014 3 1. 1.1 Web... 1 1.1.1... 3 1.1.2... 3 1.1.3... 4 1.2... 4 I 2 5 2. HTMLCSS 2.1 HTML...
…l…b…g…‘†[…N…v…“…O…›…~…fi…OfiÁŸ_
13 : Web : RDB (MySQL ) DB (memcached ) 1: MySQL ( ) 2: : /, 3: : Google, 1 / 23 testmysql.rb: mysql ruby testmem.rb: memcached ruby 2 / 23 ? Web / 3 ( ) Web s ( ) MySQL PostgreSQL SQLite MariaDB (MySQL
IBM Software Group DB2 Information Management Software DB2 V8 XML SQL/XML 2 XML XML UDF XMLExtender XML XML XMLCollection, XMLColumn XML UDF Informati
IBM Software Group XML Features in DB2 UDB V8 IBM Software Group DB2 Information Management Software DB2 V8 XML SQL/XML 2 XML XML UDF XMLExtender XML XML XMLCollection, XMLColumn XML UDF Information Integrator
RAID RAID 0 RAID 1 RAID 5 RAID * ( -1) * ( /2) * RAID A. SATA B. BIOS SATA ( 1) C. RAID BIOS RAID D. SATA RAID/AHCI 2 SATA M.2 SSD ( 2) ( (
RAID RAID 0 RAID 1 RAID 5 RAID 10 2 2 3 4 * ( -1) * ( /2) * RAID A. SATA B. BIOS SATA ( 1) C. RAID BIOS RAID D. SATA RAID/AHCI 2 SATA M.2 SSD ( 2) ( ( 3) 2 ) Windows USB 1 SATA A. SATA SATA Intel SATA
まえがきIntroduction
Array Corporation DICOM Pro Server DICOM 3.0 Conformance Statement 0. INTRODUCTION...3 1. IMPLEMENTATION MODEL...4 1.1...4 1.2...4 1.3...5 2. AE SPECIFICATIONS...6 2.1 DICOM Pro Server...6 2.1.1... 7 2.1.2...
ハイウォーターマークを知る
THE Database FOR Network Computing Oracle Oracle Oracle7 Oracle8 Oracle8 Enterprise Edition R8.0.4 for Windows NTOracle7 Server R7.3.4 for Windows NT Oracle7Oracle8 Oracle,Oracle7,Oracle8 1.5.1.... 6 1.5.2.
u302.book
Text Search Filter Library Version 3 3000-6-302-10 P-1MD3-3831* Text Search Filter Library Version 3 03-10 OS AIX 5L V5.2 AIX 5L V5.3 P-24D3-3834 Text Search Filter Library Version 3 03-10 OS Windows 2000
Microsoft PowerPoint - db03-5.ppt
データベース言語 SQL リレーショナルデータモデルにおけるデータ操作言語 : リレーショナル代数 少なくともリレーショナル代数と同等のデータ検索能力をもつときリレーショナル完備という. リレーショナル代数はユーザフレンドリではない. 自然な英文による質問の表現が必要になる. リレーショナルデータベース言語 SQL 英文による簡単な構文 リレーショナル代数でできない, 合計, 平均, 最大などの計算機能の組み込み.
自動シャットタ<3099>ウンクイックインストールカ<3099>イト<3099>.indb
OMRON Corporation. 2011 All Rights Reserved. 2 3 4 5 6 7 8 9 10 11 12 13 14 15 title Red Hat Enterprise Linux Server (2.6.18-8.el5xen serial) root (hd0,1) kernel /xen.gz-2.6.18-8.el5 console=vga xencons=ttys16
日本オラクル株式会社
FISC 6 Oracle Database 10g ~ ~ : 2005 7 26 : 2005 7 31 : 1.0 2004 4 (* ) FISC ) (* ) FISC 6 (* FISC 6 ) FISC 6 Oracle g Database 10 (FISC) http://www.fisc.or.jp FISC http://www.fisc.or.jp/info/info/050307-1.htm
Oracle XML DB によるスケーラビリティおよびパフォーマンス検証 - MML v.3.0
Oracle XML DB MML v3.0 2004 5 27 1 Memo 1 Agenda XML MML v3.0 2 Oracle XML Oracle XML DB XML API Oracle XML DB W3C XML Schema 1.0 XPath 1.0 XSLT 1.0 Oracle W3C XML Schema Oracle 2 XML Oracle XML Developer
０
第 4 書データベース操作 i 4.1 データベースへの接続 (1) データベースチェックポイントの追加 データベースチェックポイントを追加します (2)ODBC による接続 ODBC を使用してデータベースへ接続します SQL 文を手作業で指定する場合 最大フェッチ行数を指定する場合はここで最大行数を指定します ii 接続文字列を作成します 作成ボタンクリック > データソース選択 > データベース接続
領域サイズの見積方法
White Paper 1998 3 1998 7 NULL 1998 9 2 8.03 Design & Migration Services Oracle Corporation Japan 1998 Printed in Japan Oracle and SQL*Loader are registered trademarks. Oracle7 Oracle Corporation Oracle
無線LANフレーム構成について
無線 LAN フレーム構成について 2016 年 7 月 8 日 梅原大祐 MAC フレームフォーマット IEEE 802.11n QoS フィールド : QoS, A-MSDU, メッシュ関連 2 2 Duration /ID 6 6 6 2 6 2 0 7951 1 2 3 MAC header Sequence QoS HT body FCS メッシュネットワークでないケース : IP frame
<4D6963726F736F667420506F776572506F696E74202D208376838C835B83938365815B835683878393312E707074205B8CDD8AB78382815B83685D>
i i vi ii iii iv v vi vii viii ix 2 3 4 5 6 7 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60
SC-85X2取説
I II III IV V VI .................. VII VIII IX X 1-1 1-2 1-3 1-4 ( ) 1-5 1-6 2-1 2-2 3-1 3-2 3-3 8 3-4 3-5 3-6 3-7 ) ) - - 3-8 3-9 4-1 4-2 4-3 4-4 4-5 4-6 5-1 5-2 5-3 5-4 5-5 5-6 5-7 5-8 5-9 5-10 5-11
意外と簡単!?
!?Access Oracle Oracle Migration Workbench MS-Access Oracle Creation Date: Oct 01, 2004 Last Update: Mar 08, 2005 Version: 1.1 !? Oracle Database 10g / GUI!? / Standard Edition!? /!?!? Oracle Database
PGECons技術ドキュメントテンプレート Ver.3
付録. パーティションツール 1. pg_part 1.1. 環境構築検証環境は下記で実施しました CPU RAM 表 1.1: 環境 Intel(R) Xeon(R) CPU L5520 @ 2.27GHz 8GB OS Red Hat Enterprise Linux Server release 6.6 PostgreSQL サーバ PostgreSQL 9.4.0 環境構築は以下の手順で実施しています
Nios® II HAL API を使用したソフトウェア・サンプル集 「Modular Scatter-Gather DMA Core」
ALTIMA Company, MACNICA, Inc Nios II HAL API Modular Scatter-Gather DMA Core Ver.17.1 2018 8 Rev.1 Nios II HAL API Modular Scatter-Gather DMA Core...3...3...4... 4... 5 3-2-1. msgdma... 6 3-2-2. On-Chip
1999 02 03 Ver. 1.00 1999 07 09 Ver. 1.01 UID, 2003 10 01 Ver. 1.02 Storage SCU DICOM 3.0 Conformance Statement Ver.1.01 1999/07/09 1 0... 3 1... 3 1.1... 3 1.2... 3 1.3... 3 2... 4 2.1... 4 2.1.1... 4
Systemwalker IT Service Management Systemwalker IT Service Management V11.0L10 IT Service Management - Centric Manager Windows
Systemwalker IT Service Management Systemwalker IT Service Management V11.0L10 IT Service Management - Centric Manager Windows Systemwalker IT Service Management Systemwalker Centric Manager IT Service
スライド 1
2005 3 26 (MATSUNOBU Yoshinori MySQL mysqldump FLUSH TABLES WITH READ LOCK SQL (InnoDB Linux,Solaris,HP-UX,AIX,Windows C/C++( SQL92 SQL99 Core 4.1 5.0 InnoDB MyISAM ( B-Tree ( 5.0 4 (InnoDB ( (InnoDB (4.1
Web Web Web Web Web, i
22 Web Research of a Web search support system based on individual sensitivity 1135117 2011 2 14 Web Web Web Web Web, i Abstract Research of a Web search support system based on individual sensitivity
Oracleの領域管理～トラブル防止のテクニック～
THE Database FOR Internet Computing Oracle ... 3... 4... 4... 5... 5... 7... 8... 9... 12... 13... 13... 16... 17... 18... 20... 22... 23... 23... 24... 25... 25... 26... 28... 31... 31... 31... 33...
cover1.indd
OMRON Corporation. 2010 All Rights Reserved. Power Credit UPS PowerAct Pro Ver.4.x PA PowerAct Pro PA UPS Power Credit 2 3 4 5 6 7 8 9 10 11 12 13 title Red Hat Enterprise Linux Server (2.6.18-8.el5xen
DICOM Conformance Statement Carino
Carino 2016,03,17 E1J-HC0010-01 Copyright Hitachi, Ltd. 2016. All rights reserved. 1 1 1 2 3 3 AE 3 3 AE 4 4 4 4 4 4 5 5 5 5 SOP SOP 6 6 6 TCP/IP 6 API 6 6 7 SOP 7 7 7 AE 7 7 7 A 8 ( 2 ) E1J-HC0010 DICOM
※サンプルアプリケーションを固めたファイル（orcasample
SDK XML... 3... 4 orca... 4 table-name...4 method... 4 functions... 4 function... 5 function-params... 5 function-param... 5... 6... 6... 8... 10... 12... 14 dbs... 18 dbs... 18 dbs... 18... 18... 19...
TM-m30 詳細取扱説明書
M00094100 Rev. A Seiko Epson Corporation 2015. All rights reserved. 2 3 4 5 6 Bluetooth 7 Bluetooth 8 1 9 Bluetooth 10 1 11 1 2 6 5 4 3 7 12 1 13 14 ONF 1 N O O N O N N N O F N N F N N N N N N F F O O
Wiki Wiki Wiki...
21 RDB Wiki 0830016 : : 2010 1 29 1 1 5 1.1........................................... 5 1.2 Wiki...................................... 7 1.2.1 Wiki.................... 7 1.2.2 Wiki.................. 8
データベース移行ツール操作説明書 日本ブレイディ株式会社
データベース移行ツール操作説明書 日本ブレイディ株式会社 本書に記載されている情報は契約の対象とはなりません 本書の内容は事前の予告なく変 更される可能性があります 本書に記載されているソフトウェアの使用には ユーザーライセンス契約の条項が適用され ます 本ソフトウェアは このライセンス契約の条項に準拠する場合を除き それを無断で使 用することは禁止されており いかなる媒体への複写および複製もできません
\\afs001-0m0005\project02\A32\M
Technical Information 2004.09 2009.04 Store Request Query Request Retrieve Request DICOM Client Application Remote SCP Remote Query/Retrieve SCP Image Stored * DICOM Server Application Remote SCU Print
eラーニング資料 e ラーニングの制作目標 データベース編 41 ページデータベースの基本となる概要を以下に示す この内容のコースで eラーニングコンテンツを作成予定 データベース管理 コンピュータで行われる基本的なデータに対する処理は 次の 4 種類です 新しいデータを追加する 既存のデータを探索
eラーニング資料 e ラーニングの制作目標 データベース編 41 ページデータベースの基本となる概要を以下に示す この内容のコースで eラーニングコンテンツを作成予定 データベース管理 コンピュータで行われる基本的なデータに対する処理は 次の 4 種類です 新しいデータを追加する 既存のデータを探索する 違うデータに変更する 要らなくなったデータを削除する 各システムごとに障害対策も含めて 正確にこのようなデータ処理のプログラムを作ることは大変なことです
untitled
B B 2.1.2.3.2 SOP B 1 1 1.1 1 1.2 2 2. 3 2.1 Query 3 2.1.1 3 2.1.1.1 3 2.1.1.2 3 2.1.1.3 3 2.1.2 3 2.1.2.1 3 2.1.2.2 4 2.1.2.3 SOP 4 2.1.2.3.1 SOP 4 2.1.2.3.1.1 4 2.1.2.3.1.2 5 2.1.2.3.2 Modality Performed
TM-m30 詳細取扱説明書
M00094106 Rev. G Seiko Epson Corporation 2015-2018. All rights reserved. 2 3 4 5 6 7 8 Bluetooth 9 ... 71 10 1 11 Bluetooth 12 1 13 1 2 6 5 4 3 7 14 1 1 2 3 4 5 15 16 ONF 1 N O O N O N N N O F N N F N
. (.8.). t + t m ü(t + t) + c u(t + t) + k u(t + t) = f(t + t) () m ü f. () c u k u t + t u Taylor t 3 u(t + t) = u(t) + t! u(t) + ( t)! = u(t) + t u(
3 8. (.8.)............................................................................................3.............................................4 Nermark β..........................................
RX600 & RX200シリーズ アプリケーションノート RX用仮想EEPROM
R01AN0724JU0170 Rev.1.70 MCU EEPROM RX MCU 1 RX MCU EEPROM VEE VEE API MCU MCU API RX621 RX62N RX62T RX62G RX630 RX631 RX63N RX63T RX210 R01AN0724JU0170 Rev.1.70 Page 1 of 33 1.... 3 1.1... 3 1.2... 3
untitled
Caché Agenda InterSystems Caché 2009.1.NET Gateway (2009.1) Truncate Caché Databases ( ( Studio Caché ObjectScript SQL Object Security InterSystems (200x.1, 200x.2) 5.2 : 2006/6 2007.1 : 2007/6 2008.1
日本語タイトルを入力
Oracle Application Server Infrastructure 2004 6 Oracle Application Server Infrastructure Oracle Application ServerInfrastructure Oracle Application Server 10g Release 9.0.4... 3... 3 i.... 4 ii.... 4...
DB2 UDB For LinuxのCLUSTERPRO上での稼動確認
DB2 UDB for Linux CLUSTERPRO 2002/03/29 IBM NEC...2...2...4 DB2_G1: (start.bat)...6 DB2_G1: DB2 (db2start.sh)...7 DB2_G1: DB2 (db2poling. sh)...9 DB2_G1: (stop.bat )... 11 DB2_G1: DB2 (db2stop. sh)...13...15...16...17
Microsoft Word - Live Meeting Help.docx
131011 101919 161719 19191110191914 11191417 101919 1915101919 Microsoft Office Live Meeting 2007 191714191412 1913191919 12 151019121914 19151819171912 17191012151911 17181219 1610121914 19121117 12191517
OM.indd
_ INDEX 3 4 5 6 7 8 9 Platinum 10 Gold 12 Silver 14 Bronze 16 18 20 FAQ 21 22 1997 10 15 Platinum Platinum IT 保々雅世 3 IT Control Real Application Cluster Grid Oracle Application Server 10g CLE MASTER ORA
GA-1190J
GA-1190J 1 1. 2. 3. 4. 2 5. 3 PDF 4 PDF PDF PDF PDF PDF PDF PDF PDF 5 6 ...1...2...4 1...12 2...16...18 3...22 PCL/PS...23 4...26 5...30 ETHERNET...31 TCP/IP...33 IPX/SPX...38 AppleTalk...40 HTTP...42
N Express5800/R320a-E4 N Express5800/R320a-M4 ユーザーズガイド
7 7 Phoenix BIOS 4.0 Release 6.0.XXXX : CPU=Pentium III Processor XXX MHz 0640K System RAM Passed 0127M Extended RAM Passed WARNING 0212: Keybord Controller Failed. : Press to resume, to setup
Express5800/R320a-E4, Express5800/R320b-M4ユーザーズガイド
7 7 Phoenix BIOS 4.0 Release 6.0.XXXX : CPU=Pentium III Processor XXX MHz 0640K System RAM Passed 0127M Extended RAM Passed WARNING 0212: Keybord Controller Failed. : Press to resume, to setup
com.ibm.etools.egl.jsfsearch.tutorial.doc.ps
EGL JSF ii EGL JSF EGL JSF.. 1................. 1 1:.... 3 Web.......... 3........... 3........ 4......... 7 2:...... 7..... 7 SQL.... 8 JSF.... 10 Web.... 12......... 13 3: OR....... 14 OR... 14.15 OR.....
Express5800/R110a-1Hユーザーズガイド
4 Phoenix BIOS 4.0 Release 6.0.XXXX : CPU=Xeon Processor XXX MHz 0640K System RAM Passed 0127M Extended RAM Passed WARNING 0B60: DIMM group #1 has been disabled. : Press to resume, to
untitled
i ii iii iv v 43 43 vi 43 vii T+1 T+2 1 viii 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 a) ( ) b) ( ) 51
2
1 2 3 4 5 6 7 8 9 10 I II III 11 IV 12 V 13 VI VII 14 VIII. 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 _ 33 _ 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 VII 51 52 53 54 55 56 57 58 59
これわかWord2010_第1部_100710.indd
i 1 1 2 3 6 6 7 8 10 10 11 12 12 12 13 2 15 15 16 17 17 18 19 20 20 21 ii CONTENTS 25 26 26 28 28 29 30 30 31 32 35 35 35 36 37 40 42 44 44 45 46 49 50 50 51 iii 52 52 52 53 55 56 56 57 58 58 60 60 iv
パワポカバー入稿用.indd
i 1 1 2 2 3 3 4 4 4 5 7 8 8 9 9 10 11 13 14 15 16 17 19 ii CONTENTS 2 21 21 22 25 26 32 37 38 39 39 41 41 43 43 43 44 45 46 47 47 49 52 54 56 56 iii 57 59 62 64 64 66 67 68 71 72 72 73 74 74 77 79 81 84
これでわかるAccess2010
i 1 1 1 2 2 2 3 4 4 5 6 7 7 9 10 11 12 13 14 15 17 ii CONTENTS 2 19 19 20 23 24 25 25 26 29 29 31 31 33 35 36 36 39 39 41 44 45 46 48 iii 50 50 52 54 55 57 57 59 61 63 64 66 66 67 70 70 73 74 74 77 77
III
III 1 1 2 1 2 3 1 3 4 1 3 1 4 1 3 2 4 1 3 3 6 1 4 6 1 4 1 6 1 4 2 8 1 4 3 9 1 5 10 1 5 1 10 1 5 2 12 1 5 3 12 1 5 4 13 1 6 15 2 1 18 2 1 1 18 2 1 2 19 2 2 20 2 3 22 2 3 1 22 2 3 2 24 2 4 25 2 4 1 25 2
iii iv v vi vii viii ix 1 1-1 1-2 1-3 2 2-1 3 3-1 3-2 3-3 3-4 4 4-1 4-2 5 5-1 5-2 5-3 5-4 5-5 5-6 5-7 6 6-1 6-2 6-3 6-4 6-5 6 6-1 6-2 6-3 6-4 6-5 7 7-1 7-2 7-3 7-4 7-5 7-6 7-7 7-8 7-9 7-10 7-11 8 8-1
TM-T88VI 詳細取扱説明書
M00109801 Rev. B 2 3 4 5 6 7 8 9 10 Bluetooth 11 12 Bluetooth 13 14 1 15 16 Bluetooth Bluetooth 1 17 1 2 3 4 10 9 8 7 12 5 6 11 18 1 19 1 3 4 2 5 6 7 20 1 21 22 1 23 24 1 25 SimpleAP Start SSID : EPSON_Printer
Express5800/320Fa-L/320Fa-LR
7 7 Phoenix BIOS 4.0 Release 6.0.XXXX : CPU=Pentium III Processor XXX MHz 0640K System RAM Passed 0127M Extended RAM Passed WARNING 0212: Keybord Controller Failed. : Press to resume, to setup
Compiled MODELSでのDFT位相検出装置のモデル化と評価
listsize TPBIG.EXE /Mingw32 ATP (Alternative Transients Program)- EMTP ATP ATP ATP ATP(TPBIG.EXE) EMTP (ATP)FORTAN77 DIMENSION C malloc listsize TACS DIMENSIONEMTP ATP(TPBIG.EXE) listsize (CPU ) RL 4040
Oracle Rdb: PowerPoint Presentation
Day2-3 Itanium: T S Oracle Rdb 2006 4 4 2006 4 6 2005-2006, Oracle Corporation VAX/Alpha IEEE Rdb IEEE SQL SQL SQL 2 : 12340000 = 1.234 x 10 7 ( ) -1.234 x 10 7-1.234 x 10 7-1.234 x 10 7 (10-2 = 1/100)
PowerRDBconnector説明書(SQLServer編）
COBOL COBOL SQL COBOL COBOL COBOL OPEN REWRITE REWRITE SQL Server SQL Server PowerRDBconnector or NetCOBOL C C COBOL C C NetCOBOL [] NetCOBOL [] NetCOBOL SQL Server SQL Server NetCOBOL []
TM-m30 詳細取扱説明書
M00094101 Rev. B Seiko Epson Corporation 2015-2016. All rights reserved. 2 3 4 5 6 7 8 Bluetooth 9 Bluetooth 10 1 11 Bluetooth 12 1 13 1 2 6 5 4 3 7 14 1 1 2 3 4 5 15 16 ONF 1 N O O N O N N N O F N N F
HA8000シリーズ ユーザーズガイド ～BIOS編～ HA8000/RS110/TS10 2013年6月～モデル
P1E1M01500-3 - - - LSI MegaRAID SAS-MFI BIOS Version x.xx.xx (Build xxxx xx, xxxx) Copyright (c) xxxx LSI Corporation HA -0 (Bus xx Dev
平成18年版 男女共同参画白書
i ii iii iv v vi vii viii ix 3 4 5 6 7 8 9 Column 10 11 12 13 14 15 Column 16 17 18 19 20 21 22 23 24 25 26 Column 27 28 29 30 Column 31 32 33 34 35 36 Column 37 Column 38 39 40 Column 41 42 43 44 45
December 28, 2018
e-mail : kigami@i.kyoto-u.ac.jp December 28, 28 Contents 2............................. 3.2......................... 7.3..................... 9.4................ 4.5............. 2.6.... 22 2 36 2..........................
FileMaker ODBC and JDBC Guide
FileMaker 13 ODBC JDBC 2004-2013 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker Bento FileMaker, Inc. FileMaker WebDirect Bento FileMaker,
HA8000-bdシリーズ RAID設定ガイド HA8000-bd/BD10X2
HB102050A0-4 制限 補足 Esc Enter Esc Enter Esc Enter Main Advanced Server Security Boot Exit A SATA Configuration SATA Controller(s) SATA Mode Selection [Enabled] [RAID] Determines how
Express5800/R320a-E4/Express5800/R320b-M4ユーザーズガイド
7 7 障害箇所の切り分け 万一 障害が発生した場合は ESMPRO/ServerManagerを使って障害の発生箇所を確認し 障害がハー ドウェアによるものかソフトウェアによるものかを判断します 障害発生個所や内容の確認ができたら 故障した部品の交換やシステム復旧などの処置を行います 障害がハードウェア要因によるものかソフトウェア要因によるものかを判断するには E S M P R O / ServerManagerが便利です
<Documents Title Here>
Oracle9i Database R9.2.0 for Windows Creation Date: Mar 06, 2003 Last Update: Mar 24, 2003 CD 1 A99346-01 Oracle9i Database Release 2 (9.2.0.1.0) for Microsoft Windows NT/2000/XP CD 1 of 3 2 A99347-01
橡PervasiveSQL2000ReviewersGuide.PDF
Pervasive.SQL 2000 Reviewer s Guide Pervasive.SQL TM 2000 Reviewer s Guide Rev.1 11/99 Pervasive Software Inc. The Freedom to Create Applications for Everyone, Everywhere ...3 Pervasive.SQL 2000...4 Pervasive.SQL