HiRDB Version 9 09-50 新機能解説（PDF形式、6.31M
Contents
1. 2 Windows HHRDB HiRDB HiRDB HiRDB HiRDB Hitachi Ltd 2015 All rights reserved 62 HITACHI Inspire the Next 5 5 2 UAP Hitachi Ltd 2015 All rights reserved 63 5 2 1 UAP HITACHI DB DB2. Hitachi Ltd 2015 All rights reserved 10 2 2 2 1 Baal soc Baad RA 09 50 hte ag GM get lah tp 024 RD UNTIL DISCON NECT 809
3. IP IP aaa aaa aaa aaa bb HiRDB aaa gt 0 0 0 255 IP bb gt 24 30 enay ate sis HiRDB ita PUBLIC ae cow RREN ORRE o 30 mare HiDDR 5 ens 3 bi ie as irl HiRDB
4. PDBLKF PDBLKBUFFSIZE PDBLKBUFFSIZE 10 BRE UAP SQL Be SQL SQL Les UAP SQL _
5. F I AAE FEARS SAAI Db Hitachi Ltd 2015 All rights reserved 32 2 4 4 HiRDB CA 1 Blaha Best HiRDB Configuration Assistant HiIRDB 09 50 Ss New HiRDB HiRDB Configuration Assistant
6. Hitachi Ltd 2015 All rights reserved 2 1 3 Badal aoe Bush iA 09 50 HiRDB SQL Windows o e DB Hitachi Ltd 2015 All rights reserved 8 HITACHI Inspire the Next 2 2 2 Hitachi Ltd 2015 All rights reserved 9 2 2 1 HITACHI 09 50
7. pd_watch resource Hitachi Ltd 2015 All rights reserved 11 2 2 3 2 Badal anc Baad _ pdreclaim
8. SQL user eee ay RC 123 456 99 minal OK ime ee n 234 567 890 123 user2 d4e5f6 xxxxx Hitachi Ltd 2015 All rights reserved 64 5 2 2 Pa HIRDB
9. Configuration Assistant Hitachi Ltd 2015 All rights reserved 33 2 4 5 HiRDB CA 2 HITACHI Inspire the Next re HIRDB 0 HiRDB Configuration Assistant F E T H A DIC RTN SRC gj DIC RTN_OBJ ig L RDDATA STACK G L RDDATA STACK og LRDDATA STACK gj LRDDATA STACK oj LRDDATA STACK E L_RDINDX STACK i L_RDINDX STACK Ta M 4 gt EEEk E RD Za a HRD1 EE HRD1 xylophonev3 unt unt1 E RDMAST Aa L_RDINDX CYCLE LRDDATA RENEW _RENEW ia L_RDDATA_RENEW Aa L_RDDaATA RENEW og L_RDDATA_RENEW K_0001
10. SQLSTATE SQL SQLSTATE SQLSTATE Hitachi Ltd 2015 All rights reserved Inspire the Next 2 2 6 HITACHI 09 50 FOR UPDATE SQL FOR UPDATE SQL WITH EXCLUSIVE LOCK
11. me 11RD DB 0 P Hitachi Ltd 2015 All rights reserved 55 4 3 6 2 HITACHI DAT pd statistics A A
12. IP 123 456 789 012 user1 a 2015 12 31 23 59 59 abcxyz 123 456 789 012 user1 abcxyz 2015 12 31 Hitachi Ltd 2015 All rights reserved 6 HITACHI Inspire the Next 6 Hitachi Ltd 2015 All rights reserved 68 6 1 UP HIRD HiRDB Hitachi Ltd 2015 All rights reserved 69 RE MHIRDBVAT LEX HiRDB SQL SQL SQ
13. pd os authenticate pd os_authenticate Y N 0S Y 06 N 065 CONNECT SQL GRANT GRANT GRANT CONNECT TO IDENTIFIED BY USING OS Administrator CONNECT GRANT GRANT CONNECT TO Administrator IDENTIFIED USING OS Hitachi Ltd 2015 All rights reserved 42 3 2 5 0S HiRDB TACHI C
14. UNIX The Open Group X 0pen The Open Group Hitachi Ltd 2015 All rights reserved 11 HITACHI Inspire the Next END HIRDB Version 9 09 50 2015 01 IT DB Hitachi Ltd 2015 All rights reserved 12 Human Dreams Make IT Real IT HITACHI Inspire the Next
15. Linux Ii 09 50 HiRDB Linux 0S 4KB HugePage 2MB Hitachi Ltd 2015 All rights reserved 30 2 4 2 2 7 HITACHI Inspire the Next _ SQL SQL SQLSTATE
16. 09 50 pd_sysdef_default_option Hitachi Ltd 2015 All rights reserved 20 2 3 3 HIRDB HITACHI HiIRDB 0904 BM HiRDB FIybI4A L v pdsetup v 0904
17. Hitachi Ltd 2015 All rights reserved 34 2 4 6 pdconfchk LE DB HiRDB pdconfchk KFPS05632 W 4 Tips E pdconfchk HiRDB 1 ORR a 2048 HiRDB aeee ike e pd log write_buff count 10 4 pdlog max data size 523 000 Hitachi Ltd 2015 All rights reserved 35 HITACHI Inspire the Next 3 3 1
18. O Hitachi Ltd 2015 All rights reserved 40 PDUSER CONNECT u001 SQL GRANT 3 2 3 Badal one Bask CONNECT a RD DBA X A GRANT Hitachi Ltd 2015 All rights reserved 41 3 2 4 0S HLTACHL 0S pd os authenticate Y 0S
19. 09 04 0904 Hitachi Ltd 2015 All rights reserved 19 2 3 2 RE 09 50 09 50
20. Dead Ladd Installshield lt B Fert Hitachi Ltd 2015 All rights reserved 24 2 3 7 Windows HITACHI Windows HiRDB Ddntenv pdntenv vV pdntenv hc on off pn a os sc auto manual ce ro on off shmfile regular page sr d wd sw v recom v09041 J V recom v0904 recom vV0904 0904 1 HiRDB Hitachi Ltd 2015 All rights reserved 25 2 3 8 i st
21. DECIMAL Oon Hitachi Ltd 2015 All rights reserved 31 Bah Lec BP a I
22. 3 HiRDB PDDIR PDCONFPATH LD LIBRARY_PATH eran AIX LIBPATH pdsetenv Hitachi Ltd 2015 All rights reserved 23 2 3 6 Windows HITACHI 7 WindOows HiRDB Windows 9 1 Windows 2 HiRDG Sinele Server Version 9 a was ERT FOER VAT ATES OU BT DAI a SOLDA e a OTE r Z A ER Moe TIER FEL SERIE PAC CRT FL RARER AT VEC bh os BS Sold na 8 BEJA E ERT E ARDENTES do BENE EEH d Oo PATAN Orel ae 0 4 aT Ee ERA D AORE EIR TEHES LAL R SR New 9
23. PDTPYRCEDKEY 2 3 PDTPYRCEDKEY pd tpyrced key N ALTER ROUTINE Hitachi Ltd 2015 All rights reserved 66 5 2 4 la Mi pdregtpyrcedkeyD 32774 DBA DdregtDVyrcedkey pdregtpyrcedkey f D f D IP 1 PUBLIC 1 2 3 4 5 1 4 1 2
24. 3 2 0S5 Hitachi Ltd 2015 All rights reserved 38 3 2 1 0S 1 Badal oe Bush LES HiRDB SAL Executer pdsql ool HiRDB Se 0S HiRDB DB New DB HiRDB ac u001 p001 lu002 p002 u100 p100 ciiRDB ciiRDB 0S C HIRDB AP 0S bp 7 0807 4Y1 F 4 OAHIRDBIK BER HiRDB HiRDB Hitachi Ltd 2015 All
25. RD 1 RD RD Hitachi Ltd 2015 All rights reserved 1 2 2 8 DB HITACHI 1 2 pd table def cache size w 7 assurance table no 09 50 3 2500 iod assurance index no
26. pdstbegin pdstbegin pd statistics pdstbegin 4 3 7 4 3 8 4 3 9 Hitachi Ltd 2015 All rights reserved 56 4 3 7 HLTACHL l NN diO pdstDpegin pdstbegin k sys buf dfw dio m 1 pdlogsync ee pdlogsync PDDIR spool pdsti1 pdstj2 pdstend
27. HIRDB Version9 09 02 2011 7 HiRDB Hitachi Ltd 2015 All rights reserved 3 1 2 HiRDB Version 9 09 50 HITACHI Inspire the Next A HiRDB Version 9 09 50 ameme aiea Ea 0S aaa HiRDB for Microsoft R NET Framework NET Framework4 5 PRF Hitachi Application Server 6 SQL 8 UAP 9 Windows Microsoft NET Hitachi Ltd 2015 All rights reserved HITACHI Inspire the Next E i 2 2 1 2 2 2 3 2 4 Hitachi Ltd 2015 All rights reserved
28. Hitachi Ltd 2015 All rights reserved 2 2 4 1 HITACHI Inspire the Next pets 09 50 ET HIRDB 1 1 5 pdstedit SQL SGQL SQL SQL
29. A Z a 2 0 9 FO a Mk a PSS gt HiRDB at ee Dr eon ii 1 hhimm ss 23 59 59 Hitachi Ltd 2015 All rights reserved 65 5 2 3 UAP HITACHI UAP HiRDB pd tpyrced key Y 1 HIRDB pd tpyrced key YIN Y UAP N UAP pdregtpyrcedkey 2 5 2 4
30. Hitachi Ltd 2015 All rights reserved 36 3 1 Badal ne Bush eS 0 08 HIRDB 08 EER 64 ye e AAPA STAI DBMS NET Framework4 HIRDB for NET Framework HiRDB for NET Framework useLegacyV2RuntimeActivationPolicy true NET Framework4 NET Framework4 4 5 4 5 1 HiRDB FJ Hitachi Ltd 2015 All rights reserved HITACHI Inspire the Next 3
31. SQL SQL 1 SQL UAP SQL Hitachi Ltd 2015 All rights reserved 13 2 2 5 2 Badal aoc Bash EE SQL SQL SQL SQL SQL SQL SQL SQL SQL
32. odsetup v recom v0904 PARES MIS gt Pee E HiRDB y pdsetenv UNIX pdsetenv v recom v0904 2 3 5 8 v pdntenv pdntenv v recom v0904 Peer Hitachi Ltd 2015 All rights reserved 21 2 3 4 UNIX RE UNIX HiIRDB UNIX HiRDB HiRDB 0S pdsetub v HiRDB opt HiRDB_P bin pdsetup opt HiRDB_S bin pdsetup C d f Co vV recom v0904 J J HiRDB V recom v0904 recom vV0904 090
33. PDUSER HiRDB ini UNIX PDUSER export PDUSER HIRDB 0DBC JDBC NET 0LE 0DBC SQLConnect hdbc DSN 3 1 1 SQL C C COBOL SQLJ SQL C C SQL char xuserid 31 BABA char xpasswd 31 EXEC SQL CONNECT USER xuserid IDENTOFIED xpasswd Connect Hitachi Ltd 2015 All rights reserved 43 3 2 6 0S HITACHI 0S5 DO HiR
34. x pd auth_cache size pd auth cache size set f loo Ocormment ig Cr OOOO Opd_table_def_cache size H Qpdwork E Opd_log_auto_unload path Opd_log_dual i Apd sts initial error EI WORK HiRDB 4 IVAT LER HiRDB a ak J 2 o SVR HiRDB VAT LPB RD DT RD RD RD 7 LOB RD Le LOB RD fh UTL HiRDB RD lt MYAT Ls FRR 2 IEaPNUMIEGRL 2
35. pdadmvr HIiRDB KFPS01826 E pdadmvr pdadmvr c single 09 50 Object Option 64bit POSIX 00093200 ujis Staticizer Option No Exd Advanced Hi gh Avai lability Advanced Partitioning Option Non Recover FES No Disaster Recovery Light Edition Plus facilities Accelerator sysdef recom sysdef recom sVsdef v0904 0904 E KFPS01826 HiRDB dir aa aa HIRDB vrs bb bb unit run ID cc cc HiRDB ID dddd unit ID eeee sysdef fffff fffff recom V0904 0904 Hitachi Ltd 2015 All rights reserved 26 2 3 9 HiRDB HITACHI HiRDB PDDEFAULTOPTION PDDEFAULTOPTION RECOM V0904 RECOM
36. V0904 0904 Hitachi Ltd 2015 All rights reserved 2 2 3 10 09 50 UE 09 50 use od rdarea extension timing pd rdarea_extension_timing use RD
37. SQL Hitachi Application Server Type4 JDBC 2 SEEE x ae Hitachi Application Server 10 AP Hitachi Se ene Application Server AP Hitachi Ltd 2015 All rights reserved 53 4 3 4 SQL 2 HITACHI SQL n SQL SQL 11 SQL SQL RI Be te ee X 0pen API 3 A es an 12 Aa eases i el ee Dea A SQL SQL 13 _
38. T 8 HiRDB ini HIRDB ini PR HiRDB ini nn HiRDB 4 5 SQL PDSQLTRCFMT 2 SQL SQL 6 SQL YYYY MM DD hhimm ss fff SQL SQL SQL 8 UAP UAP 9 UAP
39. pdstedit A pdstend a oo eo pdstedit k sys buf dfw dio m1 k i PDDIR spool pdstj1 dio O tmp statisticsu b e sec gt pdstj1 out s a ene a 2 buf dfw HiRDB pdstbegin pdstedit Hitachi Ltd 2015 All rights reserved 4 3 8 1 HITACHI RD HiRDB dio DA Oo ere ah 1 HOST SERVER RD RDAREA NAME 4 3 RD HiRDB Saf d
40. SQL SQL Pipette dete MR Prk Pa os Pena SQL 16 SQL SQL 17 ee HiRDB UAP SQL Hitachi Ltd 2015 All rights reserved 54 4 3 5 1 HITACHI HiRDB
41. ee pd_table_def_cache_size Ee d tehe deh saoe si 5 100 lpdroutinedefcachesiee Hitachi Ltd 2015 All rights reserved 17 HITACHI Inspire the Next 2 2 3 Hitachi Ltd 2015 All rights reserved 18 2 3 1 MS OC 09 50 0 _
42. UAP TRACE CLT 09 50 Nov 5 2013 SVR 09 04 US WIN32 WIN32 CNCT CLPID CLTID NO OP SEC SQL SQL START TIME END TIME OP EXEC TIME NO TION CODE NO CODE WARN SQL SQL SELECT GNO GNAME KIKAKU TANKA SURY0 GENKA FROM ZAIKO 9155 0 4 OPEN 2 0 0000 16 04 02 090 16 04 02 800 M000 109123 9155 0 5 FETC 2 204 0000 16 04 03 080 16 04 03 790 M000 108902 9155 0 6 SET 2 0 W8800 16 04 04 060 16 04 04 830 M000 165147 k UAP TRACE TPE CLTI05 50 01 how 5 2013 SRA US WA HEZ OMA H HEZ SOCKET STATUS 20134711713 15 20 14 540 CLT 10 196120 Ft 1071 gt HCiD_ 19710 2440 aes 2013711713 15 20 14_545 OT 2013711713 13220514545 CLIC 196 120 171 1072 gt Whio 197 10241 hy 2013711713 15 20 14_550 CLT WhO 2013711713 13220514550 CLT C10_196_120_ 171 1075 gt SCC 197 10s AED 20134711713 15 20 14 560 CLT 10 196120 171 3000 WE 197 10 231 IHM 00 EDETEN EON eR AP SQLLIF BAOREMARA CHET CLPID CLTID MI on SEC SAL Sa 0s START T IE El TRACE PREPROCESS FILE PREPROCESS ROOT AP wo CODE wo COE TRH DUT PUT TIE TIE 11 2761 TIER SET amp 0 hi 2013711713 15 20214979 21 1 test ec Te TED 10 196 1 171 ITE A oh oO ee G SELECT FRiki Ti 5 GLLEME 16 EXSTHE PRES 11 2764 et 11 ACR a 0 Im 2013711713 15 20 14 979 21 D 10 196 120_ 1717
43. 2 write WC write WS write WM 1 RD HiRDB 60 1 100 RD 10 read read read write write write Hitachi Ltd 2015 All rights reserved 59 4 3 10 HITACHI PEN READ s WRITE 4 s READ s READ TIME MICRO SUM READ MEAS
44. 5 2 1 1 Badal gnc Bul HiRDB HiRDB Version9 09 50 09 50 Hitachi Ltd 2015 All rights reserved 6 2 1 2 Banh pec BP pa FRDB ales SE i RO
45. UAP DECIMAL 8 SQL Hitachi Ltd 2015 All rights reserved 15 2 2 7 Baal soe Baad 09 50 HiRDB HiRDB HIRDB RD
46. 07 13 40 36 201194 PRF ID unt10000043E Hitachi Application Server i AP F GES aa aa bb bb cc cc ev 10 209 13 123 2200 0x0000000000000104 user Mele tee wae bb bb ID h CC CC 02004155 49320000 00000000 ee _ AUI2 time svname pid tid eid no ip len c_ip c_pid c_port c_conn c_no r_id r binary text 2014 11 07 13 40 36 201194 fes1 30089 1 0x10012002 125 10 208 175 34 100 10 208 175 35 31884 30142 3 unt10000043E 02004155 49320000 00000000 AUI2 Hitachi Ltd 2015 All rights reserved 49 HITACHI Inspire the Next 4 4 3 Hitachi Ltd 2015 All rights reserved 50 4 3 1 SQL flied Be Inspire the Next UAP SQL SQL SQL
47. 2 2 HiRDB SQL Tuning Advisor 2 SQL 1 UAP SQL Hitachi Ltd 2015 All rights reserved 52 4 3 3 SQL 1 HITACHI iA SQL SQL l abe 1 SQL SQL oe HiRDB Sok ee eres HIRDB PDSQLTRCFMT 1 VV RR HiRDB 3 ae PDSQLTRCFMT 2 VV RR XX
48. 276 170 no oI EXSTHE PRES EXCURSOLS CR 1 35 HLICURS OL USE 37 11 2761 et 12 OPEN 10 0 mh 2013711713 15 230 14_975 21 0 test_ec 138452 7820 10 196 120 11s 296 re oO ey ee 1 SEXCURGOLS CUI 1 2764 eat it 13 FETC 11 0 W00 2013711713 15 20 14 979 21 71 10 196 120_1717 276 170 neo ECKL CUI 0 UTP ae b 1 C MORE 1 LER A Ih oO DAT AEA 00 00 OO a w 11 2761 TIER 14 FE WS 12 0 mh 2013711713 15230714995 21 0 test_ ec EA Th 10196 1 171s TE A Ox ey ey oo Ek CUR 1 Hitachi Ltd 2015 All rights reserved 51 4 3 2 SQL Pa SQL SQL SQL PDSQLTRCFMT PDSQLTRCFMT 1 2 0904 1 SQL 1 1 2 2 1
49. SQL SQL sa a tzo zm EED Hitachi Ltd 2015 All rights reserved 46 HITACHI Inspire the Next 4 4 2 PRF Hitachi Application Server Hitachi Ltd 2015 All rights reserved 4 4 2 1 PRF Badal ne Bush Hitachi Application Server HiRDB HiRDB Hitachi Application Server HiRDB PRF
50. t FILE NUMBER 5 LOG GET TIME 6 HIRDB PAGE SIZE K 7 read READ CNT YYYY MM DD hh mm ss a e 0 6 read READ MEASURE CNT 9 read SUM READ TIME MICRO PPT 2 Hitachi Ltd 2015 All rights reserved 58 nspire the Next 4 3 9 2 horiena DAT r a 1 write WRITE CNT 12 write WRITE MEASURE CNT a al write SUM 14 WRITE TIME MICRO MAX 10 read RC ead RS S ei read RM RANK KIND
51. 4 1 KFPS00073 Q Specify use of system definition operand s default values recom Recently recommendable v0904 Version 09 04 compatible 2 HIRDB Hitachi Ltd 2015 All rights reserved 22 2 3 5 UNIX TE UNIX pdsetup 0S pdsetenv UNIX HIRDB pdsetenv pdsetenv v pdsetenv v recom v0904 v recom v0904 recom v0904 0904 1 pdsetenv HiRDB 2 pdsetenv
52. DB OLTP UAP 0S LJ 08S BIK ViA Ea o a Wi A SQL SET SESSION AUTHORIZATION Hitachi Ltd 2015 All rights reserved 44 HITACHI Inspire the Next 4 4 1 Hitachi Ltd 2015 All rights reserved 45 4 1 Ln Inspire the Next HiRDB PRF Hitachi Application Server DB Hitachi Application Server HiRDB Hitachi Application Server Loe i PRF JE cae 4 26 i
53. HITACHI Inspire the Next HiRDB HiRDB Version 9 09 50 Ai tee Be Fit ae 2015 01 AIRE IT DB Human Dreams Make IT Real Hitachi Ltd 2015 All rights reserved HITACHI Inspire the Next Contents 1 2 3 4 5 6 Hitachi Ltd 2015 All rights reserved 1 HITACHI Inspire the Next 1 Hitachi Ltd 2015 All rights reserved 2 1 1 HiRDB Version 9 mnapine the New 2011 2012 2013 2014 ciiRDBjg HiRDB Version 9 09 50 2014 11 _e DB HIRDB Version9 09 03 2012 5 SQL lt z Bi a T Hitachi Dynamic Provisioning HDP
54. Hitachi Application Server AP le DB MM SHANA RONE PRF PRF HiRDB Hitachi Application Server 3 1 Hitachi Application Server 10 00 HIRDB 09 50 Hitachi Ltd 2015 All rights reserved 48 4 2 2 PRF amp Ia AP Hitachi Application Server 7M Hitachi Application Server Hitachi Application Server PRF amp OF 1 7 2014 11
55. L UAP Windows Windows Hitachi Ltd 2015 All rights reserved 70 ME HP UX Hewlett Packard Development Company L P IBM AIX International Business Machines Corporation Linux Linus Torvalds Microsoft Windows Microsoft Corporation O0DBC Microsoft Corporation OLE Microsoft Corporation Oracle Java Oracle Corporation
56. URE CNT WRITE s F WRITE TIME MICR0 SUMJ WRITE MEASURE CNT Mi WRITEA 100 000 u s EXEL TUS HI e WRITE WRITE MEASURE TIME MICRO CNT SUM WRITE us WRITE LOG GET TIME CNT WRirE ALAM 150034 1 304 643 UI 2 11 10 23 29 44 441211 3 870 272 4 11 10 23 29 44 133806 1 173 737 J 103 224 713 101 572 307 101 873 184 es ee ee ee po 109 109 944923 ee ee pe Hitachi Ltd 2015 All rights reserved 60 HITACHI Inspire the Next 5 5 1 Hitachi Ltd 2015 All rights reserved 61 5 1 UAP Windows UAP IP COA
57. pd rdarea_extension_timing nouse nouse od rdarea_extension timing Hitachi Ltd 2015 All rights reserved 28 HITACHI Inspire the Next 2 2 4 Hitachi Ltd 2015 All rights reserved 29 2 4 1 1 Banh gnc BP SA D gt 4
58. rights reserved 39 3 2 2 0S 2 UN 0S HiRDB pgn 0S HiRDB 0S CONNECT DB HIRDB HiRDB mY 0S u001 New 09 50 30 Administrator O DBA 0S5
Download Pdf Manuals
Related Search