Post on 05-Sep-2020
DB2®
DB2 Connect °AtJ
DB2 Connect 9
GC40-2081-00
DB2®
DB2 Connect °AtJ
DB2 Connect 9
GC40-2081-00
ΩTΣΣúºeA²\¬NU@δΩTC
N
σ≤t IBM vΩTCªOnΘvPNúAⁿ@vkO@CñΩTú]A⌠
≤úOABΣ»z]úoC
ziHuWq IBM XAzLϕa IBM NϕqC
v YnuWqXAyX≤ www.ibm.com/shop/publications/order uIBM Xñ (IBM Publications
Center)vC
v YnMΣzϕa IBM NϕAyX≤ www.ibm.com/planetwide uIBM ypW² (IBM Directory of
Worldwide Contacts)vC
YnqⁿΩ[juDB2 ½⌡PΓ (DB2 Marketing and Sales)vñq DB2 XAqóG1-800-IBM-4YOU(426-4968)C
ϕzeΩT IBM AzYv IBM HΣAϕΦíeΩTAú∩zt⌠≤d⌠C
© Copyright International Business Machines Corporation 1993, 2006. All rights reserved.
²
1 g DB2 Connect . . . . . 1
1 ÷≤ DB2 Connect . . . . . . 3DB2 Connect úú . . . . . . . . . . . 3DB2 Connect D≈ iSeries Σ . . . . . . . 3
2 DB2 Connect Ω . . . . . . 5 DB2 Connect sD≈ iSeries DB2 Ω . . 5qßs DB2 Ω. . . . . . . . . 10 Java s Web W DB2 D≈Ω . . . . 10utmUívzΩwsu (Linux Windows) . . . . . . . . . . . . . . . 12Fz°A . . . . . . . . . . . . . 13 DB2 zuπzΩΩw (Linux Windows) . . . . . . . . . . . . . . . 13Ωwío DB2 Client Σ . . . . . 15
2 g α DB2 Connect . . . . 17
3 α DB2 Connect . . . . . . 19
3 g w DB2 Connect . . . . 21
4 wº[ . . . . . . . . . . 23DB2 Connect °AúGwPtmº[ . . . . 23
5 w≥D . . . . . . . . 25OΘD . . . . . . . . . . . . 25wD (Windows) . . . . . . . . . . . 25
DB2 Connect °AúwD (Windows) 25w DB2 °Aúnbß(Windows) . . . . . . . . . . . . . . 26
wD (UNIX) . . . . . . . . . . . . 29DB2 Connect °AúwD (AIX) . . . 29DB2 Connect °AúwD (HP-UX) . . 30DB2 Connect °AúwD (Linux) . . 30DB2 Connect °AúwD (Solaris) . . 31
6 Windows iµ LDAP . . 33XR²⌡ (Windows) . . . . . . . . . . 33
7 emw@ . . . . . . . . 35DB2 ú IBM Software Development Kit for Javah . . . . . . . . . . . . . . . . . 35í (UNIX) . . . . . . . . . . . 36∩í (HP-UX) . . . . . . . . 36ítm (HP-UX) . . . . 36∩í (Linux). . . . . . . . . 37∩í (Solaris @⌠) . . . . . 38
8 w@ . . . . . . . . . . 41w DB2 Connect (Windows) . . . . . . . . 41w DB2 Connect °Aú (Windows) . . . 41
w DB2 Connect (UNIX) . . . . . . . . . 42w DB2 Connect °Aú (AIX) . . . . . 42w DB2 Connect °Aú (HP-UX) . . . . 43w DB2 Connect °Aú (Linux) . . . . 45b zSeries Ww DB2 for Linux. . . . . 46w DB2 Connect °Aú (Solaris) . . . . 47
9 ID z . . . . . . . . . . . 49Nz ID sW DB2ADMNS DB2USERS sñ (Windows) . . . . . . 49
10 ßmw@ . . . . . . . . 51MM≤ . . . . . . . . . . . . . . 51DB2 Connect v. . . . . . . . . . . 52 db2licm ⁿOn² DB2 ú\αvX 52uvñvn² DB2 ú\αvX. . 52 db2licm ⁿO]w DB2 vh . . . . 53uvñv]w DB2 vh. . . . . 54
4 g DB2 Connect qT
D≈ iSeries Ωw . . . . . . 55
11 DB2 Connect qT
DB2 for OS/390 and z/OS Ωw . . . 57 DB2 Connect su DB2 UniversalDatabase for OS/390 and z/OS . . . . . . . . 57tm DB2 Universal Database for OS/390 and z/OS TCP/IP . . . . . . . . . . . . . . . 57tm DB2 Universal Database for OS/390 and z/OS 60
12 DB2 Connect qT
DB2 UDB for iSeries Ωw . . . . . 61 DB2 Connect su DB2 UniversalDatabase for iSeries . . . . . . . . . . . . 61
13 DB2 Connect qT
DB2 for VM VSE Ωw . . . . . 63 DB2 Connect su DB2 for VSE &VM . . . . . . . . . . . . . . . . . 63
5 g tmsD≈ iSeries Ωw. . . . . . . . . . . . . . . . 65
14 utmUív . . . . 67 CA tmsD≈ iSeries Ωw°Asu (Linux Windows) . . . . . . . . . . 67
© Copyright IBM Corp. 1993, 2006 iii
15 CLP . . . . . . . . . 69 CLP tmsD≈ iSeries Ωw°Asu . . . . . . . . . . . . . . . . . 69
6 g DB2 Connect . . . . 71
16 ⌡µzví . . . . 73
17 b DB2 Connect WsΩ
wí . . . . . . . . . . . . . 75
18 i@B\¬ . . . . . . . . . 77
7 g Ω . . . . . . . . . 79
19 ⁿ DB2 ú CD . . . . . 81ⁿ CD-ROM (AIX) . . . . . . . . . . . 81ⁿ CD-ROM (HP-UX) . . . . . . . . . . 82ⁿ CD-ROM (Linux) . . . . . . . . . . . 82ⁿ CD-ROM (Solaris @⌠) . . . . . . . 83
20 úw DB2 Connect . . . 85úw DB2 ú (Windows) . . . . . . . . 85úw DB2 ú (Linux UNIX) . . . . . 86
8 g ²PßO . . . . . . . . 87
² A. utmUívtm
Ωwsu . . . . . . . . . . . . . 89utmUívjM⌠⌠tmΩwsu . . 89
utmUívΓtmΩwsu . . . . 90utmUívΩwsu . . . . . 91
² B. yÑΣ . . . . . . . . . . 93≤ DB2 yÑ (Windows) . . . . . . . . 93≤ DB2 yÑ (Linux UNIX) . . . . . 93Σ DB2 yÑ . . . . . . . . . . . 94HΣLyÑ⌡µuDB2 wvδFyÑOr 95rΩα½ . . . . . . . . . . . . . 96
² C. DB2 ΩwNΩT . . . . . 97DB2 NΩTº[ . . . . . . . . . . . . 97σ≤Núd . . . . . . . . . . . . . 97
PDF µí DB2 NO . . . . . . . . . 98q DB2 LΩy . . . . . . . . . . . 100qⁿOµBzπ SQL ¼Aí . . . . . . 101súP DB2 ΩTñ . . . . . . . 101YnbuDB2 ΩTñvñAHznyÑπDD . . . . . . . . . . . . . . . . 101≤sqú°í⌠⌠°AWwuDB2 ΩTñv . . . . . . . . . . . . . . . 102DB2 . . . . . . . . . . . . . 104DB2 °ΩT. . . . . . . . . . . . 104° . . . . . . . . . . . . . . . . 105
² D. N . . . . . . . . . . 107 . . . . . . . . . . . . . . . . 108
. . . . . . . . . . . . . . . 111
ó IBM . . . . . . . . . . . . . 115
iv DB2 Connect °AtJ
1 g DB2 Connect
U]t DB2 Connect™ º[ (]AúP DB2 Connect ⌠d)CQDD]
AG
v i DB2 Connect
v C∩úP⌠XAP
v P DB2 Connect @zßuπ
v DB2 Connect P Java™BWeb íµ÷BzΩd÷
AX\¬∩H
v tdp≤N DB2 Connect PW@πXz
v w DB2 Connect NH
© Copyright IBM Corp. 1993, 2006 1
2 DB2 Connect °AtJ
1 ÷≤ DB2 Connect
DB2 Connect úq Linux®BUNIX® Windows® ¼¡xsj¼qúPñ¼Ωw
αOCziHs OS/390® z/OS®BiSeries™BVSE VM W DB2® ΩwC
ziHsP Distributed Relational Database Architecture™ (DRDA®) eD IBM
ΩwC
DB2 Connect úú
DB2 Connect úsuMΦ (]A DB2 Connect Personal Edition) U DB2
Connect °AúG
v DB2 Connect Enterprise Edition
v DB2 Connect Application Server Edition
v DB2 Connect Unlimited Edition for zSeries™
v DB2 Connect Unlimited Edition for iSeries
p DB2 Connect úΩA\
http://www.ibm.com/support/docview.wss?rs=73&uid=swg21219983
÷@:
v 42 yw DB2 Connect °Aú (AIX)z
v 43 yw DB2 Connect °Aú (HP-UX)z
v 45 yw DB2 Connect °Aú (Linux)z
v 47 yw DB2 Connect °Aú (Solaris)z
v 41 yw DB2 Connect °Aú (Windows)z
v DB2 Connect Personal Edition tJñyw DB2 Connect Personal Edition
(Linux)z
v DB2 Connect Personal Edition tJñyw DB2 Connect Personal Edition
(Windows)z
DB2 Connect D≈ iSeries Σ
DB2 Connect Σ∩UCD≈ iSeries Ω°AsuG
ϕ 1. ΣD≈ iSeries Ω°A
A (RSU)
DB2 UDB for OS/390 and z/OS 7.1
RSU0606
\
http://www.ibm.com/servers/eserver/zseries/zos/servicetst/
DB2 UDB for z/OS 8 RSU0606
\
http://www.ibm.com/servers/eserver/zseries/zos/servicetst/
© Copyright IBM Corp. 1993, 2006 3
ϕ 1. ΣD≈ iSeries Ω°A (≥)
A (RSU)
DB2 UDB for iSeries V5R1B
V5R2BV5R3 V5R4
II13348 (ΩT APAR)
puiSeries wAWvA\
http://www-912.ibm.com/s_dir/sline003.NSF/GroupPTFs?
OpenView&view=GroupPTFs
DB2 Server for VM/VSE 7 P
HW
\ http://www.ibm.com/software/data/db2/vse-vm/support
/dwnldsfs.html
pΩTA\G
http://www-1.ibm.com/support/docview.wss?rs=71&context=SSEPGG&dc=D600&uid=swg21233566
ּ:
v DB2 Connect ΓUñyDB2 Connectz
v 5 y DB2 Connect sD≈ iSeries DB2 Ωz
÷@:
v 67 y CA tmsD≈ iSeries Ωw°Asu (Linux
Windows)z
÷:
v DB2 Connect ΓUñyD≈Ωwz
4 DB2 Connect °AtJ
2 DB2 Connect Ω
DB2 Connect sD≈ iSeries DB2 Ω
DB2 Connect °AiH² LAN W DB2 ßsD≈ iSeries txs
ΩC
bjqΩñAq DB2 UDB for iSeriesBDB2 UDB for OS/390A
H z/OS DB2 Server for VSE & VM zΩCb⌠@Σº¡xW⌡µ
ííioΩApPΩw°Az@δCn DB2
Connect °Aú (p DB2 Connect Enterprise Edition)AαΣísD≈
iSeries ΩQµ÷°AHΣíϕ¿ Java ⁿOwqΩ@C
AziHjí≈ºπ DB2 Connect UíµoΩwíA
HΣ÷uπCpAziHπUC DB2 ConnectG
v ΓϕAp Microsoft® Excel Lotus® 1-2-3®AHRYΩAhXJ
Ω¿P°C
v MªΣuπAp BusinessObjectsBBrio M ImpromptuAH Crystal ReportsAi
úYΩTC
v ΩwúAp Lotus Approach® Microsoft AccessC
v ouπAp PowerSoft PowerBuilderBMicrosoft Visual Basic Borland DelphiA
H D/qMΦC
DB2 Connect °Aú (p DB2 Connect Enterprise Edition) AX≤UC¼p
⌠G
v QΩP Java Applet wqΩ@íC (\ 11 5)
v Web °A⌡µ Web ¼í (\ 9 4 11 5)
v wñíÑqí°AC
v µ÷° (p IBM® TXSeries® CICS® Encina® °BWebSphere
Application ServerBWebSphere MQBMicrosoft Transaction Server (MTS) BEA
Tuxedo)C(\ 7 2)
DB2 Connect zL[cúzqsD≈ iSeries ΩAHzíΩC
Distributed Relational Database Architecture (DRDA)CDRDA i²z
íPD≈ iSeries Ωw tsuAúUQD≈ iSeries ≤M
hDC
÷M DB2 Connect qwbñí°A≈WAHs DB2 ßPD≈ iSeries
ΩwA²]iHwbhQnsD≈ iSeries °A≈WC
pADB2 Connect iHwb\hj¼≈WC
DB2 Connect ]iHwb Web °ABuµ÷Bz (TP)v°AΣLh½
SQL íBz⌡µⁿ 3 hí°A≈WCboípñAzi
∩N DB2 Connect wbP@x≈AHDΦKAwbúP≈WHε CPU
tⁿC
© Copyright IBM Corp. 1993, 2006 5
DB2 Connect °AihßsD≈ iSeries ΩABijjaε
b @°ΩsδOC 1 íb DB2 ßzL DB2 Connect
°AúAísD≈ iSeries Ωw°A⌠ñAIBM ÷MΦC
Yns IBM D≈ iSeries Ωw°AAzn@wv DB2 Connect ú
Czúα DB2 ßs IBM D≈ iSeries Data ServerC
1. DB2 ConnectANßsD≈ iSeries Ω°A
6 DB2 Connect °AtJ
2. DB2 Connect µ÷°.
2 DB2 Connect Ω 7
3. DB2 Connect ñ WebSphere Java °A\α
8 DB2 Connect °AtJ
ּ:
v 23 yDB2 Connect °AúGwPtmº[z
÷:
v 3 yDB2 Connect úúz
4. DB2 Connect ft Microsoft Internet Information Server (IIS) @
2 DB2 Connect Ω 9
qßs DB2 Ω
DB2 ßú⌡µ⌠AiH²ßís@hΩwC DB2
ßAziHqz DB2 DB2 Connect °ACíúzL DB2
ßsΩwCJava ⁿOwqiHzL Java s²sΩwC
LinuxBUNIX Windows ¡xΣ DB2 ßC
ּ:
v DB2 ßtJñyDB2 ßwº[z
v DB2 ßtJñyß¼ - DB2 Runtime Client DB2 Clientz
Java s Web W DB2 D≈Ω
DB2 Connect ú]A IBM DB2 Driver for JDBC and SQLJAi²z í
Hs Web W DB2 ΩwΩC
]tOí SQL í]pyÑNsDyÑ (host language)CJava PDyÑ
CBCOBOL FORTRAN úPaΦAb≤ªOí SQL WSΦíC
v SQLJ JDBC O±íAi²z÷aN SQLJ JDBC íqΣL
eΩwtα DB2 ΩwC
v NϕXΩ Java ¼AHUjpΩú@O nullAi
Nϕ SQL NULL ¼AA² Java íiH∩ΣLDyÑTw]w NULL ⁿ
C
v Java ]pOFnΣNπUiΓí (τuWiΓv
uiUⁿv)CúF Java O¼tºA\α]i≤n
ΘCSOOH Java g SQLJ α½íiHIsΩwtS≤AHKv
Ωw\α (pvB⌡dB¼dBµ÷\α)AHúS
wΩwíXC
v Java Ow∩ºΦ⌠⌠ñGiiΓ]pAHK²RA SQL Ωw
íπGiiΓC
v bπ Java \αs²tWALzß¡x≤AúiHb Web ⌠
W⌡µ JDBC AppletCßtúns²HΣLnΘCßM°A@
JDBC SQLJ Applet MíBzC
10 DB2 Connect °AtJ
iHq⌠≤w DB2 ßt⌡µ JDBC SQLJ íFún Web
s²M Web °AC
p JDBC API ÷ΩTA\ http://java.sun.com/products/jdbc/ ⌠C
ּ:
5. JDBC DB2 Connect
2 DB2 Connect Ω 11
v 12 yutmUívzΩwsu (Linux Windows)z
v Developing Java Applications ñySupported drivers for JDBC and SQLJz
utmUívzΩwsu (Linux Windows)
utmUí (CA)vi≤Uzz°AΩwsuCCA iHϕ¿ DB2
ß≤C CA ]w⌠≤ßP°AqTC
: bºeñA¡xúΣ uDB2 zuπv(p CA)Cb 9 Au
Windows x86BWindows x64 (AMD64/EM64T)Bx86 LinuxAH
AMD64/EM64T Linux ΣuDB2 zuπvCb¡xñAzúiH
DB2 ⁿOµBz (CLP) zsuC
F CA ºßAziHG
v NΩwsíiªCTΦkiG
– Ωwzú]wwqsCßsΩw
]wC
– b⌠⌠ñjMiΩw∩@C]wñwqΩw]
wßsCúDzLwwqD≈ iSeries Ωw DB2 Connect °AA
h DB2 Connect Personal Edition LkjMD≈ iSeries ΩwC
– ΘJnsuAHHu@ΦítmPΩwºísuC
v úhwsΩwA≤wsΩweC
v XJtßΩwtmΩTß]wC
v gLtOΩwsC
v g∩íAOsMµñAíPΩwsC
v sWB≤úh CLI/ODBC ΩAHtm CLI/ODBC tm]wC
v πztWßtmCHΦΦíB∩ºß
ú]wC
v ≤sΩw°AKXC
ּ:
v DB2 ßtJñyß°AqTtmº[z
÷@:
v 90 yutmUívΓtmΩwsuz
v DB2 ßtJñyß]wfttmUítmΩwsuz
v 75 17 , yb DB2 Connect WsΩwíz
v 67 y CA tmsD≈ iSeries Ωw°Asu (Linux
Windows)z
12 DB2 Connect °AtJ
Fz°A
uDB2 z°A (DAS)vuDB2 zuπv tmUí (CA) nDC
pAuDB2 zuπvi²zBε]w°AΩwzítmC
CA uz°AvA≤UbßWiµΩwsCDAS A≤
Σ LinuxBWindows UNIX @tAH zSeries (¡ OS/390 z/OS)
@tC
uz°Av≤znzC@x°AWCuz°Av
C]wíbΩ≈W uz°AvABb≈
NªCw]ADAS ΩO DB2ASAoOQuDB2 wvδF
w] IDC
ּ:
v Administration Guide: Implementation ñyDB2 Administration Serverz
÷@:
v Administration Guide: Implementation ñyCreating a DB2 administration server
(DAS)z
DB2 zuπzΩΩw (Linux Windows)
ziH DB2 zuπz°ACuεñv⌡µz@
Aptm DB2 ΩΩwB≈ΩBu@AHzCΘ (íz
Lí⌡µ)C
: bºeñA¡xúΣuDB2 zuπvApuεñvCb 9
Au Windows x86BWindows x64 (AMD64/EM64T)Bx86 LinuxAH
AMD64/EM64T Linux ΣuDB2 zuπvCb¡xñAzúiH
DB2 ⁿOµBz (CLP) zΩΩwC
uεñvΣUCG
v DB2 UDB for OS/390 and z/OS 7
v DB2 UDB for z/OS 8
DDΣlí≈Noú DB2 UDB for z/OSAúDePSw÷C
pGznquεñvs DB2 UDB for z/OS \αG
1. τG
v z DB2 UDB for z/OS v
v zwbßu@WwF DB2 Connect ú
v wbD≈WuíΩ≈α (DDF)v
v wbßWs DB2 lt
v DB2 Connect í DB2 CLI íwsD≈
2. M DB2 Management Clients Package (DB2 UDB for z/OS @\α) DB2
Administration Server (DAS) for OS/390 and z/OS FMIDCDAS O DB2 for OS/390
and z/OS °Aú@∩\αC¬ DB2 UDB for z/OSBDB2
2 DB2 Connect Ω 13
Management Clients Package DB2 Administration Server for OS/390 and z/OS
í²Cí²OíC@adX FMID eCí²]ú
wDPⁿC
3. í²íANΣLAM≤ DB2 UDB for z/OSC
4. uDB2 εñvΣzbh¡xWz DB2 ΩwCz DB2 UDB for z/OS
ltAzbC@ DB2 ltñw@xsBwqτ
σíG
DB2 UDB for z/OS 8
pGzww DB2 UDB for z/OS 8 Ahw z/OS ßα\α
(JDB881D)C
DB2 UDB for OS/390 and z/OS 7
pGzww DB2 UDB for OS/390 and z/OS 7 Ahw 390
ßα\α (JDB771D)C
pGQnR≈Q DB2 UDB for z/OS uDB2 εñv\αA (]As
JCL mP )Azw DB2 Administration Server (DAS) for OS/390 and
z/OS 8 (HDAS810) (\α DB2 UDB for z/OS ú)C
:
a. bznzLuεñvC@ DB2 ltWAw FMID
JDB881D JDB771DC
b. znzLuεñv DB2 ltb@t LPAR CM
Auαw@ FMID HDAS810C
c. pUwⁿA\Aϕú DB2 Management Clients Package
ñuí²vCpAw DAS (HDAS810) ⁿ≤ IBM DB2 UDB
for z/OS DB2 Management Clients Package 8 uí²vñC
d. Ctw@ DB2 Administration ServerC
5. TwzwwsíC
6. Tww DB2 Administration ServerC
puεñvH DB2 UDB for z/OS ⁿA\G
http://www.ibm.com/support/docview.wss?rs=64&context=SSEPEK&q1=jdb881d&uid=swg27006262
z°AWqT:
uεñvi²z°B≤s½]Ωwzítmñ°AqT≤w]
wC½kΣ÷@UΩAMßq\αϕ∩]wqT∩Aso\
αC w]A]wítmbztWjí≈qT≤wC
z]iHuεñv⌡µUC@G
v ½kΣ÷@UΩAq\αϕñ∩tm∩AtmΩwz
íC
v btW÷@U½kΣAq\αϕñ∩X°A]w∩ANi
tmߺ]wñΩwΩTXC
Visual Explain ° SQL sp:
14 DB2 Connect °AtJ
Lk Visual Explain úD≈ iSeries ΩwWspC
Visual Explain iUΩwzíoiuvqUC@G
v °ⁿwº SQL »zíΩwzíuπ∩wspC
v π SQL »zíH≥P≤nαC
v ]píPΩwC
v °spAΣñ]At²ñpΩC
v MwOnbϕµñsWC
v zLRsp SQL »zíαO D]C
v iº snapshot \α° DB2 °A snapshotC
v πdíΣ DB2 tmspC
÷@:
v 75 17 , yb DB2 Connect WsΩwíz
Ωwío DB2 Client Σ
Γ DB2 ßGDB2 Client DB2 Runtime ClientCboΓßñAu
DB2 Client A≤ΩwíoC
DB2 Client ]AUCG
v C/C++BCOBOL Fortran ems (]¡xΣyÑ)C
v Oí SQL íΣ (]Aí]píw) ]AíXdC
v uODBC DB2 Ish (DB2 CLI)víΣ (]Aí]píw)
]AoííXdAoíXdiH÷
α ODBCA ODBC SDK iµsCiHq Microsoft o Windows @
t ODBC SDKA]iHqΣLUo\hΣLΣ¡x ODBC
SDKCb Windows @tWADB2 Client (Σ Microsoft ODBC SDK
oí) w]w ODBC CLI XíCYΣL¡xAh
ODBC CLI Xíi∩aP DB2 Client @wAßΣiH
¡xº ODBC SDK oí (pG)C
v IBM DB2 Driver for JDBC and SQLJA]AG
– JDBC ΣA≤A SQL o Java í
– SQLJ ΣA≤RA SQL o Java í
v Java SDK H≤Σ@t DB2 ßC
v Windows @tW ActiveX Data Object (ADO) u½≤sMO (OLE)ví (UDF uxsv) (]A Microsoft Visual Basic Microsoft
Visual C++ Ω@íXd)CHA Microsoft Visual Basic Ω@π
Remote Data Object (RDO) íXdC
v Windows @tWu½≤sMOΩw (OLE DB)vϕµτC
v Windows @tW C# Visual Basic .NET íM CLR .NET íC
v DB2 Developer Workbench O Eclipse ¼uπAN DB2 Universal Database™
(DB2 UDB) for Linux, UNIX, and Windows 8 uoñvCDeveloper
Workbench OεXo⌠Ai BsΦBúBíp DB2 xs
2 DB2 Connect Ω 15
MwqτCz]iH Developer Workbench o SQLJ
íAH BsΦM⌡µ SQL »zí XML dC
v zLuⁿOsΦvuⁿOµBz (CLP)v¼í SQLA SQL »zí
¼w∩Ωw⌡µSOdC
v @Oⁿ APIAiHΣLíouπAbªúΩ@ DB2
emsΣCpAAIX® W IBM COBOL C
ּ:
v DB2 ßtJñyß¼ - DB2 Runtime Client DB2 Clientz
÷:
v Getting Started with Database Application Development ñySupport for elements of
the database application development environmentz
16 DB2 Connect °AtJ
2 g α DB2 Connect
© Copyright IBM Corp. 1993, 2006 17
18 DB2 Connect °AtJ
3 α DB2 Connect
DB2 Connect 9 °AΣα DB2 Connect 8 °A DB2
ΩΩwCw DB2 Connect 9 ºeAz²nΩwΩC
] DB2 Connect °AúOD≈Ωwsu\α°AA@iHsb≤ DB2
Connect °AΩñΩwO DB2 µ÷zíΩwCoΩwO DB2
xs DB2 ≤µ÷µ÷¼AΩTC
b Linux UNIX ¡xWAzbw DB2 Connect 9 ßAHΓΦíα DB2
Connect ΩCzb DB2 ßWsIΩwAíoΩC
pG sΩAPaAz½ssIBDCS ΩwAHgsb≤ DB2
8 Ωñº DB2 ßΩwC
b Windows @tWAziHbwí∩αs DB2 Connect 8
CYα DB2 Connect ΩCtAz]iHw DB2 Connect 9
sAMßHΓΦíα DB2 Connect ΩC
²Mn≤:
αs DB2 Connect ºeG
v TwzπAϕ@tv¡G
– UNIX W¬sv
– Windows Wz
v Twzπ SYSADM v¡C
v \tD⌠A⌠
http://www.ibm.com/software/data/db2/db2connect/sysreqs.htmlC
v \ DB2 °AαDDC
v \ DB2 °AαíDDDC
v ⌡µ DB2 °Aemα@DDíemα@C
v ⌡µ db2imigr ⁿOºeAzG
– Linux UNIX t /tmp ² n 20 MB iíCΩαl
NgJ /tmpC
– Γ⌡µ db2ckmig ⁿOAHMΣM⌠≤y¿αó DCundb2ckmig ⁿOΣ DAdb2imigr ⁿONúαC
¡ε:
uΣq DB2 Connect 8 αC²OAUCΣsu\αAuA≤ DB2
8 \αG
v 32 64 DB2 8 ßiHs 32 64 DB2 Connect
9 °AC
v 32 64 DB2 9 ßiHs 32 64 DB2 Connect
8 °AC
© Copyright IBM Corp. 1993, 2006 19
Y DB2 Connect 6 DB2 Connect 7 Ah²α DB2 Connect
8 CpΩTA\UCDDG
http://publib.boulder.ibm.com/infocenter/db2luw/v8/topic/com.ibm.db2.udb.doc/start/t0008566.htm
:
Ynα DB2 Connect ΩΩwG
1. N DB2 Connect °Asu\αtmΩTXX]wC db2cfexp uπH tm]wG
$ db2cfexp cfg_profile backup
]ⁿwF∩ backupAH]wtΩtmΩTA]AΩwz
ítmn²]wCnAziH]w½su\αC
2. αeA² BACKUP DATABASE ⁿO≈zΩwC
3. w DB2 Connect 9 C
4. db2imigr ⁿOαΩC
5. MIGRATE DATABASE ⁿOAbwαΩUαΩwCz]iHDB2 Connect 8 ≈αΩwC
6. ∩wsΩwiµsuG
$ db2 CONNECT TO DATABASE sample user mickey using mouse
sΩwAzⁿwKXCTwsuú¿\C
ּ:
v αΓUñyDB2 ßαº[z
v αΓUñyDB2 °Aαz
v αΓUñyDB2 °Aα¡εz
÷@:
v wPtmRΩñy DB2 z
v αΓUñybαºe≈Ωwz
v αΓUñyα DB2 °A (Linux UNIX)z
v αΓUñyα DB2 °A (Windows)z
v αΓUñyαΩwz
v αΓUñyαΩz
v αΓUñyτΩwwαz
÷:
v Command Reference ñydb2imigr - Migrate instance commandz
v Command Reference ñyMIGRATE DATABASE commandz
v αΓUñyDB2 °AαíDz
v αΓUñyDB2 °Aemα@z
20 DB2 Connect °AtJ
3 g w DB2 Connect
iH≤UzWC@wBJCnΘíhB@tqT≤
wDAúCbíϕµñCziH²τtOXΩ@W DB2 Connect
DAMßiJwC
pGzpnqe@ DB2 Connect αA\ 19 3 , yα DB2
ConnectzC
YnΓw DB2 Connect úA\wPtmRΩñHΓΦíw DB2
úDDC
AX\¬∩H
v tdwtm DB2 Connect tNH
© Copyright IBM Corp. 1993, 2006 21
22 DB2 Connect °AtJ
4 wº[
DB2 Connect °AúGwPtmº[
w DB2 Connect °Aú (p DB2 Connect Enterprise Edition) ]th
BJCDB2 Connect °AúqPdsD≈ iSeries Ωw°A
ß@wC]AzUzBJwCTwtm¡wºßAz
Hª@w@OAwπq DB2 Connect ßC
wtm DB2 Connect °Aú@δBJpUG
1. Mwznp≤bz⌠⌠ñ DB2 ConnectC
2. τzu@D≈Ωw°AWúwπTwΘnΘ≥DC
3. τzwtmnD≈ iSeries Ωw°AAiⁿ DB2 Connect °A
suC
4. w DB2 Connect nΘCzNu@tmτzD≈P iSeries s
uC
5. wºßA DB2 Connect PzD≈ iSeries ΩwtºísuC
DB2 Connect zMΣtm TCP/IP suCiHutmUí
(CA)v DB2 ⁿOµBz (CLP) tmD≈ iSeries ΩwC
6. N DB2 Connect úííszD≈ iSeries ΩwC
7. suC
8. (∩) uhm≤svSC
9. pGzp WebSphere®Bµ÷°Azví°AnΘAw
oúíC pw WebSphere ÷ΩTA\oúb
DB2 Connect °AúΩ]ñúσ≤CΣªú÷ΩTA\ú
úíσ≤C
10. wtm DB2 ßCu@q DB2 ßD≈P iSeries °
AºísAsíC
11. utmUívAzL DB2 Connect ßsD≈ iSeries tC
12. N DB2 ßwbNnsD≈ iSeries Ωw°Aºí
@δu@WC
13. zbwAiN DB2 Connect bzíWC≤ío
u@w DB2 ßC
14. pGnzu@z DB2 UDB for OS/390 and z/OS DB2 Database
for Linux, UNIX, and WindowsAw DB2 ßC
÷@:
v 75 17 , yb DB2 Connect WsΩwíz
v 69 y CLP tmsD≈ iSeries Ωw°Asuz
v 67 y CA tmsD≈ iSeries Ωw°Asu (Linux
Windows)z
v DB2 ßtJñyw DB2 ß (UNIX Linux)z
© Copyright IBM Corp. 1993, 2006 23
v DB2 ßtJñyw DB2 ß (Windows)z
v 57 y DB2 Connect su DB2 Universal Database for OS/390
and z/OSz
v 91 yutmUívΩwsuz
v DB2 Connect ΓUñyuεñvuhm≤svz
24 DB2 Connect °AtJ
5 w≥D
OΘD
≥D:
úí°z∩w¼zt¼wCuDB2 w
vδFbiµ@δwBúYwqwí∩≤Aú
Ajp⌠pC
b Windows WAj¼O FAT (tmϕµ) ≈iα± NTFS (sN
t) ≈n≤ejíC
Oon]AnnΘqTúíC
OΘD:
DB2 Ωwt n 256 MB RAMC∩≤⌡µ DB2 DB2 GUI uπ
tA n 512 MB RAMCMAFπWiαA 1 GB
RAMCoDú]AtW⌡µºΣLnΘ⌠≤BOΘDC
PwOΘDANUCG
v b Itanium ¼tº HP-UX Version 11i v2 (B.11.23) W⌡µ DB2 ú
n 512 MB RAMC
v Y DB2 ßΣAhoOΘDOH 5 µßsu≥ªCCh 5
ßsuNnB 16 MB RAMC
v OΘDⁿΩwtjp°AHΩwíd≥Pst
ºßvTC
v b Linux WA SWAP í O RAM jpΓC
ּ:
v Performance Guide ñySelf tuning memoryz
wD (Windows)
DB2 Connect °AúwD (Windows)
psΩTA\
http://www.ibm.com/software/data/db2/db2connect/sysreqs.htmlC
Ynw DB2 Connect °Aú (p DB2 Connect Enterprise Edition)AXU
CDG
wΘD
Intel® AMD Bzúα≈⌡µΣ Windows @t (32
64 )
© Copyright IBM Corp. 1993, 2006 25
@tD
UCΣñ@G
v Windows XP Professional Edition (32 64 ) [ Service Pack 2
≤s
v Windows 2003 [ Service Pack 1 ≤sG
– Standard Edition (32 64 )
– Advanced Edition (32 64 )
– Datacenter Edition (32 64 )
nΘD
v n MDAC 2.8CuDB2 wvδFNw MDAC 2.8 (pGw)C
v ns²duWíC
qTD
v @tΣú TCP/IPC
Windows (64 ) N
v Σ 32 UDF xsC
v Σ 32 ßqe SQL nDC
ּ:
v DB2 Connect Personal Edition tJñyDB2 Connect Dzw
(Windows)z
÷@:
v 41 yw DB2 Connect °Aú (Windows)z
÷:
v 35 yDB2 ú IBM Software Development Kit for Java hz
w DB2 °Aúnbß (Windows)
pGzOb Windows Ww DB2 °AúAhnUCbßG
v wbßA
v (∩) @h]wbßCziHbwí obßC
– uDB2 z°A (DAS)vbß
– DB2 ΩbßCz]iHNutvbß≤D DB2 Enterprise Server
Edition úC
wbßO⌡µwºbßCb⌡µuDB2 wvδFºeA²w
qwbßCziHbwºewq]wbßA]iH²uDB2 wvδ
Fz bßC
bßWϕutRWWh DB2 RWWhC
Windows Ww:
26 DB2 Connect °AtJ
DB2 úú Windows wCziHQ ID w DB2A²OúD
ID ≤ DB2ADMNS DB2USERS sAh ID NLk⌡µ
⌠≤ DB2 ⁿOC
DB2 wíi oΓssCziHbqwíⁿwsWⁿw]W
C
Ynw\αAbw DB2 íA∩ DB2 ½≤@twe
W@tw∩CⁿuDB2 Administrators svµuDB2 Users s
vµw]Cw]sW DB2ADMNS DB2USERSCpGPss
W≡AtNúz≤sWCpnAz]iHµⁿwC
DB2 °Abß:
wbß
n⌠bß⌡µwC@δÑAbn⌡µw≈WA
bß≤ Administrators sC
]iD Administrator bßC∩Φn Windows Administrators
s¿²tm Windows ¬Mv]wAHe\D Administrator bß
⌡µwC
wbßnvQuq⌠⌠sqúvC
∩≤⌠b íAYnτ DB2 °AW IDAhw ID
≤n bߺ⌠Wu⌠zvsC
z]iHutvbßú⌡µwC
DB2 wíPvQ:
DB2 wíPuúívvQCDB2 wíPUC
vQG
v @@t@í≈
v O ½≤
v ΩwOΘ
v HAΦínJ
v W[tB
v ≤½hO
uDB2 z°A (DAS)vbß
uDB2 z°A (DAS)vn⌠bßC
pGz⌡µOwA]iHbñⁿwutvbßCp
ΩTA\ db2\windows\samples ²ñdC
utvbßi≤ú (² DB2 Enterprise Server Edition ú)A
iHzLuDB2 wvδF[H∩C
uDB2 z°A (DAS)vO@Sϕ DB2 zAAΣ GUI u
πUP DB2 °AWz@CDAS πwⁿwb
ßAϕ DAS AAVqúnJ DAS AC
ziHbw DB2 ºe DAS bßA]iH²uDB2 wvδF
z bßCpGzn²uDB2 wvδF s⌠bßAh
5 w≥D 27
⌡µwbßπ ⌠bßv¡Cbn⌡µw
≈WAbß≤zsCNPbßUCv¡G
v @@t@í≈
v úí
v O ½≤
v ΩwOΘ
v HAΦínJ
v W[tB (b Windows XP Windows Server 2003 @tWAπ
OΘtB)
v ≤½hO
pGwwAh DB2ADMNS sπoMvCzuN
sWsAúTsWoMvCMAO
Local Administrators s¿C
AWE (Advanced Windowing Extensions) ΣnuΩwOΘvMvC
ubTⁿw DB2 sd\HsO AnuúívM
vC
pGbßOwí AhNoMvPbßAB
pGbßwgsbA]NoMvPbßCpGwíP
FMvAhíMvubQPMvbßnJ½s≈
C
DAS b⌠ñC@ DB2 tWíπ SYSADM v¡AH
KbnAiHεΣªΩCw]A≤zs⌠≤
úπ SYSADM v¡C
DB2 Ωbß
bn⌡µw≈WAbß≤zsC
DB2 Ωn⌠bßCC@ DB2 Ωú@b Ω
ⁿwCΩADB2 HWnJC
z]iHutvbßAú (úF DB2 Enterprise
Server Edition º) ⌡µwC
ziHbw DB2 ºe DB2 ΩbßA²uDB2 wvδF
z bßCpGzn²uDB2 wvδF s⌠bßAh
⌡µwbßπ ⌠bßv¡CNPbß
UCv¡G
v @@t@í≈
v úí
v O ½≤
v W[tB
v ΩwOΘ
v HAΦínJ
v ≤½hO
28 DB2 Connect °AtJ
pGwwAh DB2ADMNS sπoMvCzuN
sWsAúTsWoMvCMAO
Local Administrators s¿C
AWE (Advanced Windowing Extensions) ΣnuΩwOΘvMvC
ubTⁿw DB2 sd\HsO AnuúívM
vC
pGbßOwí AhNoMvPbßAB
pGbßwgsbA]NoMvPbßCpGwíP
FMvAhíMvubQPMvbßnJ½s≈
C
ּ:
v Administration Guide: Implementation ñyUser, user ID and group naming rulesz
÷@:
v DB2 °AtJñyw DB2 úº[ (Windows)z
v DB2 °AtJñybw DB2 úºe]w Windows ¬Mv
(Windows)z
wD (UNIX)
DB2 Connect °AúwD (AIX)
psΩTA\
http://www.ibm.com/software/data/db2/db2connect/sysreqs.htmlC
Ynw DB2 Connect °Aú (p DB2 Connect Enterprise Edition)AXU
CDG
wΘD
v IBM RISC/6000
v eServer™ pSeries®
@tD
DB2 Connect °AúA≤UCtG
5.2.0
n 64 íC
5.3.0
n 64 íC
nΘD
v bosboot ⁿO½ 64 íC
v ns²duWíC
qTD
ziH TCP/IP
v pn TCP/IP sAhúnΣªnΘC
5 w≥D 29
v p LDAP (Lightweight Directory Access Protocol) ΣAzn IBM
SecureWay® Directory Client V3.2.1 ≤sC
÷@:
v 42 yw DB2 Connect °Aú (AIX)z
÷:
v 35 yDB2 ú IBM Software Development Kit for Java hz
DB2 Connect °AúwD (HP-UX)
psΩTA\
http://www.ibm.com/software/data/db2/db2connect/sysreqs.htmlC
Ynb HP-UX Ww DB2 Connect °Aú (p DB2 Connect Enterprise Edition)A
XUC@tBnΘqTDG
wΘD
v HP 9000 Series 700 800 t
v HP Integrity Series °A
@tD
YUC Itanium ¼tAh DB2 Connect °AúiHb
HP-UX 11i v2 (11.23.0505) W⌡µG
v 2005 ¡δ Base Quality (QPKBASE) nΘ
v 2005 ¡δ Applications Quality (QPAPPS) nΘ
nΘD
ns²duWíC
qTD
ziH TCP/IP
v pn TCP/IP sAhúnΣªnΘC
÷@:
v 43 yw DB2 Connect °Aú (HP-UX)z
÷:
v 35 yDB2 ú IBM Software Development Kit for Java hz
DB2 Connect °AúwD (Linux)
psΩTA\
http://www.ibm.com/software/data/db2/db2connect/sysreqs.htmlC
Ynw DB2 Connect °Aú (p DB2 Connect Enterprise Edition)AXU
CwΘBeBnΘqTDG
wΘD
BziG
v x86 (Intel Pentium®BIntel Xeon® AMD Athlon)
30 DB2 Connect °AtJ
v x86-64 (Intel EM64T AMD64)
v POWER™ (⌠≤Σ Linux iSeries pSeries)
v eServerzSeries
oµD
pΣº Linux oµsΩTANs²ⁿV
http://www.ibm.com/db2/linux/validateC
iαnDz≤sítmCítm]≤
/etc/sysctl.confC\uDB2 ΩTñvu∩í (Linux)v
qCp sysctl ⁿO]wo÷ΩTA\@tΓUC
nΘD
v pGnuDB2 wvδFw DB2 ConnectAQn⌠≤ DB2
uπAhnα≈eí X Window System nΘC
v ns²duWíC
qTD
pn TCP/IP sAhúnΣªnΘC
÷@:
v 45 yw DB2 Connect °Aú (Linux)z
÷:
v 35 yDB2 ú IBM Software Development Kit for Java hz
DB2 Connect °AúwD (Solaris)
psΩTA\
http://www.ibm.com/software/data/db2/db2connect/sysreqs.htmlC
Ynw DB2 Connect °Aú (p DB2 Connect Enterprise Edition)AXU
C@tBnΘqTDG
wΘD
Solaris UltraSPARC ¼qú
@tD
UC Solaris Σ DB2 Connect °AúG
v Solaris 9 (64 )
v Solaris 10 (64 )
″Recommended & Security Patches″ iHq http://sunsolve.sun.com ⌠oC
q SunSolve Online ⌠÷@U¬Σeñ ″Patches″ \αϕC
P]n J2SE Solaris Operating Environment Patch ClustersC
∩≤ 64 Fujitsu PRIMEPOWER W DB2AznUCG
v Solaris 9 ≤sí 112233-01 ≤sAHoí
912041-01 íC
ziHq FTSI ⌠Uⁿ Solaris @⌠ Fujitsu PRIMEPOWER íA
⌠G http://download.ftsi.fujitsu.com/C
5 w≥D 31
UCnΘOb Solaris @⌠ñw DB2 nG
v SUNWlibC
nΘD
ns²duWíC
qTD
ziH TCP/IP
v pn TCP/IP sAhúnΣLnΘC
v Sun Cluster 2.2 Σ DB2 Connect °≤OG
– D≈qT≤wO TCP/IP
– úOΓÑqTwCpGN SPM Θxtmb@W (o
iHzL spm_log_path Ωwzítm¿)ABóΓt
P TCP/IP tm (PD≈WBIP ÑÑ)A≥¡εi
±eC
÷@:
v 47 yw DB2 Connect °Aú (Solaris)z
÷:
v 35 yDB2 ú IBM Software Development Kit for Java hz
32 DB2 Connect °AtJ
6 Windows iµ LDAP
XR²⌡ (Windows)
pGzpft Windows 2000 Windows Server 2003 Lightweight Directory
Access Protocol (LDAP) ²°A\αAhXR Active Directory ⌡AH]t
DB2 ½≤OwqCbw⌠≤ DB2 úºeAz⌡µ@C
XR²⌡iHTOG
v ϕw ID π¼≈MviHgJ Active Directory ANwí
w] DB2 Ωs Active Directory ñ DB2 IC
v bwºß ⌠≤ΩwNs Active Directory ñC
pGzMwbXR²⌡ºeAw DB2 ú ΩwAhΓn²I
sΩwC
²Mn≤:
z Windows bßπu⌡zvv¡C
:
YnXR²⌡AG
1. nJ⌠εC
2. Hπu⌡zvv¡bßAqw CD ⌡µ db2schex.exe íCziH÷UCΦí⌡µíAúnnXßAnJG
runas /user:MyDomain\Administrator x:\db2\Windows\utilities\db2schex.exe
Σñ x: Nϕ CD ≈N C
ϕ db2schex.exe ¿AYi≥w DB2 úC
÷:
v DB2 °AtJñyDB2 ß°AwD (Windows)z
v Command Reference ñyCATALOG LDAP DATABASE commandz
v Command Reference ñyREGISTER commandz
© Copyright IBM Corp. 1993, 2006 33
34 DB2 Connect °AtJ
7 emw@
DB2 ú IBM Software Development Kit for Java h
znHUCAϕ IBM Software Development Kit (SDK) for Java hAα
Java ¼uπAH P⌡µ Java íA]AxswqτC
pGw≤n IBM SDK for JavaA²b⌠ñw SDK for JavaAh
pGzOuDB2 wvδFwúANw SDK for JavaC
SDK for Java úP DB2 Runtime Client @wC
Uϕ@t¡xCX DB2 ww SDK for Java hG
@t¡x SDK for Java h
Windows x86 SDK 5 Service Release 1
Windows x64 SDK 5 Service Release 1
AIX 5 SDK 5 Service Release 1
Solaris @⌠ SDK 1.4.2_07
HP-UX for Itanium(R) ¼t HP-UX SDK 1.4.2 SR3
x86 W Linux SDK 5 Service Release 1
AMD64/EM64T W Linux SDK 5 Service Release 1
zSeries W Linux SDK 5 Service Release 1
POWER W Linux SDK 5 Service Release 1
:
1. úF HP-UXBIPF W LinuxBSolaris @⌠ Windows IA64 A÷MWϕ
CXww SDK for Java hA²OOΣ SDK 1.4.2 SDK 5CziH
q developerWorks® ⌠ (http://www.ibm.com/developerworks/java/jdk/index.html) U
ⁿ SDK for Java h
: Y Windows @t¡xA IBM Development Package for Eclipse U
ⁿC
2. DB2 GUI uπb x86 W LinuxBAMD64/EM64T W LinuxBWindows x86
Windows x64 W⌡µC
3. b Windows x86 x86 W Linux WG
v ww 32 SDK
v Σ 32 í Java íí
4. b IPF W Linux WG
v Σ 64 í Java íí
5. bΣ¡xW (úF Windows x86Bx86 W Linux IPF W Linux º
)G
v Σ 32 í
© Copyright IBM Corp. 1993, 2006 35
v úΣ 32 Java íí
v Σ 64 í Java íí
÷@:
v DB2 °AtJñyw DB2 °A (Linux UNIX)z
v DB2 °AtJñyw DB2 °A (Windows)z
í (UNIX)
∩í (HP-UX)
F² DB2 úb HP-UX WB@Aziαn≤stítmC
pG≤sítmAh½sqúC
²Mn≤:
zπ root v¡α∩íC
:
Yn∩íAG
1. ΘJ sam ⁿOAutzí (SAM)vC
2. ÷ΓUítmC
3. ÷ΓUitmC
4. ÷ΓUzn≤Abí/µñΣJsC
5. ÷@UTwC
6. ½WzBJAH≤n≤ºítmC
7. ϕz¿ítm]wAq@\αϕCñ∩@ --> Bz
síC
≤ítmºßAHP-UX @t½sC
÷:
v Command Reference ñydb2osconf - Utility for kernel parameter values commandz
ítm (HP-UX)
Y⌡µ DB2 64 Ωwt HP-UX tA⌡µ db2osconf ⁿOAtAϕítmCdb2osconf íuαq $DB2DIR/bin ⌡µA
Σñ $DB2DIR Ozw DB2 ú²C
÷@:
v 36 y∩í (HP-UX)z
36 DB2 Connect °AtJ
∩í (Linux)
w DB2 ΩwtºeA≤s Linux íC⌡µ DB2 ΩwtA
Linux WSwíw]Oú≈CDB2 DB2 ΩwtD
ú¬ IPC ¡εCMApGD DB2 ΩwtúíAhb Linux
tW[]w¡ε±ΩC
²Mn≤:
zπ root v¡α∩íC
:
Yn≤síAG
Red Hat P SUSE LinuxiHUCΩTMwtOn⌠≤n≤C
UC ipcs -l ⁿOΘXCwgb // ßsWAHπW≤C
# ipcs -l
------ Shared Memory Limits --------max number of segments = 4096 // SHMMNImax seg size (kbytes) = 32768 // SHMMAXmax total shared memory (kbytes) = 8388608 // SHMALLmin seg size (bytes) = 1
------ Semaphore Limits --------max number of arrays = 1024 // SEMMNImax semaphores per array = 250 // SEMMSLmax semaphores system wide = 256000 // SEMMNSmax ops per semop call = 32 // SEMOPMsemaphore max value = 32767
------ Messages: Limits --------max queues system wide = 1024 // MSGMNImax size of message (bytes) = 65536 // MSGMAXdefault max size of queue (bytes) = 65536 // MSGMNB
q Shared Memory Limits @qlASHMMAX P SHMALL O
ndCSHMMAX O Linux tW@OΘqjpW¡A
SHMALL OtW@OΘtmW¡C
∩≤ SHMMAXAx86 tCDO 268435456 (256 MB)Ab 64
tñAh 1073741824 (1 GB)C
SHMALL w]] 8 GB (8388608 KB = 8 GB)CpGzΩΘOΘj
≤ABN≤ DB2AhW[jΦñΩΘOΘ 90%C
pApGzqútW 16 GB OΘDn≤ DB2Ah 16 GB 90%
14.4 GBAAúH 4 KB (≥jp) 3774873Cipcs ΘXwN
SHMALL ૨ KBCín@C
U@q]t@tiº xqCí sem 4 O
¿AY SEMMSLBSEMMNSBSEMOPM SEMMNICSEMMNS O
SEMMSL H SEMMNI GCΩwzínD°nW[C
7 emw@ 37
(SEMMNI)C@δÑA SEMMNI Oe\suW¡ (MAXAGENTS)
HΩw°AqúWºΦΓAA[WΩw°AqúW
ísuC
Tq]ttTºC
MSGMNI vTiºNzíAMSGMAX vTεCñieº
TºjpA MSGMNB vTεCjpC
MSGMAX ≤ 64 KB (Y 65535 )A MSGMNB b°At
WW[ 65535C
Yn∩oíAnsΦ /etc/sysctl.conf CpGú
sbAh CUCⁿOµOñ±mºedG
kernel.sem=250 256000 32 1024#Example shmmax for a 64-bit systemkernel.shmmax=1073741824#Example shmall for 90 percent of 16 GB memorykernel.shmall=3774873kernel.msgmax=65535kernel.msgmnb=65535
⌡µ sysctl (ft -p ) Hqw] /etc/sysctl.conf ⁿJ sysctl ]wC
sysctl -p
Yn²≤bC½s≈ßAboot.sysctl nb SUSE Linux WB≤
@ñCb Red Hat WArc.sysinit l]w Script ¬
/etc/sysctl.conf C
÷@:
v DB2 °AtJñyw DB2 °A (Linux UNIX)z
÷:
v DB2 °AtJñyDB2 ß°AwD (Linux)z
∩í (Solaris @⌠)
F² DB2 ΩwtB@Az≤stítmCziH
db2osconf ííC
Yn db2osconf ⁿOAz²w DB2 ΩwtCdb2osconf íuαq $DB2DIR/bin ⌡µAΣñ $DB2DIR Ozw DB2 ú²C
∩íºßAz½stC
²Mn≤:
zπ root v¡α∩íC
:
Yn]wíAb /etc/system [JpU@µG
38 DB2 Connect °AtJ
set parameter_name = value
pAYn]w msgsys:msginfo_msgmax Ab /etc/system [Jp
U@µG
set msgsys:msginfo_msgmax = 65535
≤s /etc/system ºßA½stC
÷:
v Command Reference ñydb2osconf - Utility for kernel parameter values commandz
7 emw@ 39
40 DB2 Connect °AtJ
8 w@
w DB2 Connect (Windows)
w DB2 Connect °Aú (Windows)
@íp≤b Windows @tWw DB2 Connect °AúAp DB2
Connect Enterprise EditionC
²Mn≤:
uDB2 wvδFºeG
v TwztXG
– OΘD
– wΘBenΘD
v pGzp LDAPAhXR²⌡C
v zuzvbß⌡µw@CuzvbßOznw DB2 ú
Windows qúWzsbßABπUCiÑvQG
– @@t@í≈
– O ½≤
– W[tB
– ≤½hO
pGSiÑvQAOiH⌡µwA²wíiαLkτbßC
:
Ynb Windows Ww DB2 Connect °AúAp DB2 Connect Enterprise EditionG
1. Hπzv¡¡nJtC
2. ÷¼íA²wíαbn≤sC
3. N CD íJ≈ñC⌡µ\αuDB2 wvδFCuDB2 wv
δFMwtyÑAMßyÑwíCpGnHúPyÑ⌡µw
íAwíLkAhiHΓ⌡µuDB2 wvδFC
4. eWuDB2 ívCziHb°íñ°w²Mn≤N
A≥w@C
5. @lw@AϕwíúiµwCuWíⁿz⌡µΣ
lBJC÷@UíIsuWíCziHH÷@U°A⌠wC
Θxxs@δΩTAHwúwíy¿TºCΘxWϕ
DB2-<úYg>-<Θí>.log µíAp DB2-CEE-10-06-2006_17_23_42.logC
w]AΘx≤ My Documents\DB2LOG ²ñC
ΓuDB2 wvδF:
YnHΓΦíIsuDB2 wvδFG
1. ÷@UlAMß∩⌡µ∩C
© Copyright IBM Corp. 1993, 2006 41
2. bµñAΘJUCⁿOG
x:\setup /i language
ΣñG
v x: Nϕz CD ≈
v language NϕzyÑaX (pAEN Nϕσ)C
3. ÷@UTwC
pGn²z DB2 úiHsqúzL⌠⌠st@xqúW DB2 σ≤A
hwuDB2 ΩTñvCuDB2 ΩTñvtA≤ DB2 Ωw DB2
÷úσ≤C\yuD B 2 wvδFwuD B 2 ΩTñv
(Windows)zC
ּ:
v DB2 °AtJñyDB2 wΦkz
v DB2 °AtJñyuDB2 ΩTñvw∩z
÷@:
v 33 yXR²⌡ (Windows)z
v DB2 °AtJñyuDB2 wvδFwuDB2 ΩTñv
(Windows)z
v 51 yMM≤z
÷:
v 25 yDB2 Connect °AúwD (Windows)z
w DB2 Connect (UNIX)
w DB2 Connect °Aú (AIX)
zuDB2 wvδFAb AIX Ww DB2 úCuDB2 wívO@
Java ¼wuπAiHN⌠≤ DB2 úwPtmCpGzúQ
íAhiH db2_install ⁿOAHΓΦíw DB2 úCzúα@t
wí SMITAΓw DB2 úCz²≤⌠≤to
wí ScriptAMßαP DB2 w¼⌡µdC
²Mn≤:
lwºeG
v TwztXG
– OΘD
– wΘBenΘD
v Hπ root v¡¡nJtC
v btWⁿ DB2 ú CDA\b AIX Wⁿ CDCz]iHN CD
estA\h CD w (Linux UNIX)C
v TwwDPB I/OF²ªAMßαQw DB2 Connect °A
úC
42 DB2 Connect °AtJ
v YnMΣwgwbtW DB2 úA\CXwbtW DB2 ú
(Linux UNIX)C
:
Ynb AIX Ww DB2 Connect °AúAp DB2 Connect Enterprise EditionG
1. N²½ⁿ CD ²G
cd /cdrom
Σñ /cdrom Nϕ CD ⁿIC
2. ΘJ ./db2setup ⁿOAHuDB2 wvδFCΦíßAeW
uIBM DB2 wívC
°íñAziH°w²Mn≤PNAiJwC
lw@ßA≥¿uDB2 wvδFwe∩∩CziH
wíAHz¿uDB2 wvδFC÷@UíIsuWíCz
iHH÷@U°H⌠wCϕz÷Uß@uDB2 wvδFweW
¿ßADB2 stC
¿ßANQ /opt/IBM/db2/V9.1 w]w⌠w DB2 Connect °A
úC
pGn²z DB2 úiHsqúzL⌠⌠st@xqúW DB2 σ≤A
hwuDB2 ΩTñvCuDB2 ΩTñvtA≤ DB2 Ωw DB2
÷úσ≤C\uDB2 wvδFwuDB2 ΩTñ (UNIX)C
ּ:
v DB2 °AtJñyDB2 wΦkz
v DB2 °AtJñyuDB2 ΩTñvw∩z
v DB2 °AtJñyh CD w (Linux UNIX)z
÷@:
v 81 yⁿ CD-ROM (AIX)z
v DB2 °AtJñyuDB2 wvδFwuDB2 ΩTñv(Linux)z
v 51 yMM≤z
v DB2 °AtJñyCtw DB2 ú (Linux UNIX)z
v wPtmRΩñy db2_install doce_install ⁿOw DB2 ú (Linux
UNIX)z
÷:
v 29 yDB2 Connect °AúwD (AIX)z
w DB2 Connect °Aú (HP-UX)
zuDB2 wvδFAb HP-UX Ww DB2 úCuDB2 wívO
@ Java ¼wuπAiHN⌠≤ DB2 úwPtmCpGzúQ
íAhiH db2_install ⁿOAHΓΦíw DB2 úCzúα
@twí swinstallAΓw DB2 úCz²≤⌠≤t
owí ScriptAMßαP DB2 w¼⌡µdC
8 w@ 43
²Mn≤:
lwºeG
v TwztXG
– OΘD
– wΘBenΘD
v Hπ root v¡¡nJtC
v btWⁿ DB2 ú CDA\b HP-UX Wⁿ CDCz]iHN CD
estA\h CD w (Linux UNIX)C
v YnMΣwgwbtW DB2 úA\CXwbtW DB2 ú
(Linux UNIX)C
:
Ynb HP-UX Ww DB2 Connect °AúAp DB2 Connect Enterprise EditionG
1. ΘJUCⁿOA½ⁿ CD ²G
cd /cdrom
Σñ /cdrom Nϕ CD ⁿIC
2. ΘJ ./db2setup ⁿOAHuDB2 wvδFCΦíßAeW
uIBM DB2 wívC
°íñAziH°w²Mn≤PNAiJwC
lw@ßA≥¿uDB2 wvδFwe∩∩CziH
wíAHz¿uDB2 wvδFC÷@UíIsuWíCz
iHH÷@U°H⌠wCϕz÷Uß@uDB2 wvδFweW
¿ßADB2 stC
¿wßANw D B 2 C o n n e c t °AúCw]w⌠O
/opt/IBM/db2/V9.1
pGn²z DB2 úiHsqúzL⌠⌠st@xqúW DB2 σ≤A
hwuDB2 ΩTñvCuDB2 ΩTñvtA≤ DB2 Ωw DB2
÷úσ≤C\uDB2 wvδFwuDB2 ΩTñ (UNIX)C
ּ:
v DB2 °AtJñyuDB2 ΩTñvw∩z
v DB2 °AtJñyh CD w (Linux UNIX)z
v DB2 °AtJñyDB2 wΦkz
÷@:
v 82 yⁿ CD-ROM (HP-UX)z
v DB2 °AtJñyuDB2 wvδFwuDB2 ΩTñv(Linux)z
v DB2 °AtJñyCtw DB2 ú (Linux UNIX)z
v 51 yMM≤z
v wPtmRΩñy db2_install doce_install ⁿOw DB2 ú (Linux
UNIX)z
44 DB2 Connect °AtJ
÷:
v 30 yDB2 Connect °AúwD (HP-UX)z
w DB2 Connect °Aú (Linux)
zuDB2 wvδFAb Linux Ww DB2 úC uDB2 wvδFO
@ Java ¼wuπAiHN⌠≤ DB2 úwPtmCpGzúQ
íAhiH db2_install ⁿOAHΓΦíw DB2 úCzúα
@twí rpmAΓw DB2 úCz²≤⌠≤to
wí ScriptAMßαP DB2 w¼⌡µdC
²Mn≤:
lwºeG
v TwztXG
– OΘD
– wΘBenΘD
v Hπ root v¡¡nJtC
v btWⁿ DB2 ú CDA\b Linux Wⁿ CDCz]iHN CD
estA\h CD w (Linux UNIX)C
v YnMΣwgwbtW DB2 úA\CXwbtW DB2 ú
(Linux UNIX)C
:
Ynb Linux Ww DB2 Connect °AúAp DB2 Connect Enterprise EditionG
1. ΘJUCⁿOA½ⁿ CD ²G
cd /cdrom
Σñ /cdrom Nϕ CD ⁿIC
2. ΘJ ./db2setup ⁿOAHuDB2 wvδFCΦíßAeW
uIBM DB2 wívC
°íñAziH°w²Mn≤PNAiJwC
lw@ßA≥¿uDB2 wvδFwe∩∩CziH
wíAHz¿uDB2 wvδFC÷@UíIsuWíCz
iHH÷@U°H⌠wCϕz÷Uß@uDB2 wvδFweW
¿ßADB2 stC
¿wßANw DB2 Connect °AúCw]w⌠ /opt/ibm/db2/V9.1
pGn²z DB2 úiHsqúzL⌠⌠st@xqúW DB2 σ≤A
hwuDB2 ΩTñvCuDB2 ΩTñvtA≤ DB2 Ωw DB2
÷úσ≤C\yuDB2 wvδFwuDB2 ΩTñv(Linux)zC
ּ:
v DB2 °AtJñyDB2 wΦkz
v DB2 °AtJñyuDB2 ΩTñvw∩z
8 w@ 45
v DB2 °AtJñyh CD w (Linux UNIX)z
÷@:
v 82 yⁿ CD-ROM (Linux)z
v DB2 °AtJñyuDB2 wvδFwuDB2 ΩTñv(Linux)z
v DB2 °AtJñyCtw DB2 ú (Linux UNIX)z
v wPtmRΩñy db2_install doce_install ⁿOw DB2 ú (Linux
UNIX)z
÷:
v 30 yDB2 Connect °AúwD (Linux)z
v Administration Guide: Planning ñyAvailability of Asian fonts (Linux)z
b zSeries Ww DB2 for Linux
Ynb⌡µ Linux IBM zSeries Ww DB2 úAz² Linux @tis
wMCziH FTP NwMe@tA NFS ⁿ²@
tiHú CDC
²Mn≤:
zwo DB2 úwMC
FTP swM:
q⌡µ Linux IBM zSeries qúWG
1. ΘJUCⁿOG
ftp yourserver.com
Σñ yourserver.com Nϕ DB2 úwMb FTP °AC
2. ΘJz ID MKXC
3. ΘJUCⁿOG
binget product file
Σñ product file NϕAϕúM≤WC
zL NFS DB2 ú CD swM:
Ynb Linux @tWú CDA⌡µUCBJG
1. ⁿAϕú CDC
2. Xzⁿ CD ²CpApGzb /cdrom Uⁿ CDAhX /cdrom
²C
3. b⌡µ Linux IBM zSeries qúWAUCⁿO NFS ⁿ²G
mount -t nfs -o ro nfsservername:/cdrom /local_directory_name
Σñ nfsservername Nϕ NFS °AD≈WAcdrom Nϕb NFS °AW
X²WA local_directory_name Nϕ²WC
46 DB2 Connect °AtJ
4. q⌡µ Linux IBM zSeries qúWA½ⁿ CD ²CziHΘJ cd/local_directory_name ⁿO⌡µ@AΣñ local_directory_name Nϕú CD
ⁿIC
÷@:
v 45 yw DB2 Connect °Aú (Linux)z
v 82 yⁿ CD-ROM (Linux)z
w DB2 Connect °Aú (Solaris)
zuDB2 wvδFAb Solaris @tWw DB2 úCuDB2 w
ívO@ Java ¼wuπAiHN⌠≤ DB2 úwPtmCpGzú
QíAhiH db2_install ⁿOAHΓΦíw DB2 úCzú
α@twí pkgaddAΓw DB2 úCz²≤⌠≤
towí ScriptAMßαP DB2 w¼⌡µdC
²Mn≤:
lwºeG
v TwztXG
– OΘD
– HΓΦíw DB2 ú
v Hπ root v¡¡nJtC
v btWⁿ DB2 ú CDA\ⁿ CD-ROM (Solaris Operating
Environment)Cz]iHN CD estA\h CD w (Linux
UNIX)C
v YnMΣwgwbtW DB2 úA\CXwbtW DB2 ú
(Linux UNIX)C
:
Ynb Solaris @tWw DB2 Connect °AúAp DB2 Connect Enterprise
EditionG
1. ΘJUCⁿOA½ⁿ CD ²G
cd /cdrom
Σñ /cdrom Nϕ CD ⁿIC
2. ΘJ ./db2setup ⁿOAHuDB2 wvδFC
ΦíßAeWuIBM DB2 wívC
°íñAziH°w²Mn≤PNAiJwC
lw@ßA≥¿uDB2 wvδFwe∩∩CziH
wíAHz¿uDB2 wvδFC÷@UíIsuWíCz
iHH÷@U°÷sA⌠w@Cϕz÷Uß@uDB2 wvδFw
eW¿ßADB2 stC
¿wßANw D B 2 C o n n e c t °AúCw]w⌠O
/opt/IBM/db2/V9.1
8 w@ 47
pGn²z DB2 úiHsqúzL⌠⌠st@xqúW DB2 σ≤A
hwuDB2 ΩTñvCuDB2 ΩTñvtA≤ DB2 Ωw DB2
÷úσ≤C\uDB2 wvδFwuDB2 ΩTñ (UNIX)C
ּ:
v DB2 °AtJñyDB2 wΦkz
v DB2 °AtJñyuDB2 ΩTñvw∩z
v DB2 °AtJñyh CD w (Linux UNIX)z
÷@:
v wPtmRΩñyHΓΦíw DB2 úz
v 83 yⁿ CD-ROM (Solaris @⌠)z
v DB2 °AtJñyCtw DB2 ú (Linux UNIX)z
v DB2 °AtJñyuDB2 wvδFwuDB2 ΩTñv(Linux)z
v 51 yMM≤z
v wPtmRΩñy db2_install doce_install ⁿOw DB2 ú (Linux
UNIX)z
48 DB2 Connect °AtJ
9 ID z
Nz ID sW DB2ADMNS DB2USERS sñ (Windows)
Q¿ DB2 wºßAbzNsW DB2ADMNS DB2USERS s
ñAH²Σisz DB2 úCDB2 wí ΓssCziHs
Wⁿw]WCw]sW DB2ADMNS DB2USERSC
²Mn≤:
v zwwF DB2 úC
v zbw DB2 úíA∩Fu DB2 ½≤@twveW
u@twv∩C
:
YnNsWAϕsñAG
1. qúzuπC÷@UlA∩]w -> εx -> tzuπ -> q
úzC
2. ∩MsC
3. ∩C
4. ∩znsWC
5. ÷@UeC
6. ÷@U⌡≤C
7. ÷@UsWC
8. ∩AϕsC
9. ÷@UTwC
pGziµFwBw∩úsw\αAi⌡µ db2extsec.exe ⁿOAbwºß⌡µ@C
db2extsec.exe ⁿOw\αºßAzΓ∩iH°\αG
1. ΦA⌡µ db2extsec.exe ⁿOAuúv∩tiµ⌠≤ΣL≤CpGzwg∩tiµF≤Ah∩ 2C
2. NuCHvssW DB2ADMNS DB2USERS sñC
ּ:
v Administration Guide: Implementation ñyExtended Windows security using
DB2ADMNS and DB2USERS groupsz
÷:
v 26 yw DB2 °Aúnbß (Windows)z
v Command Reference ñydb2extsec - Set permissions for DB2 objects commandz
© Copyright IBM Corp. 1993, 2006 49
50 DB2 Connect °AtJ
10 ßmw@
MM≤
DB2 M≤]tb IBM íoº D≤sí (uvíR
°ivA APAR)AHß°iº DíCCM≤úH@≈σ
≤A APARLIST.TXTAíΣñtíC
C@M≤ú]t ReadMe @MuNvG
v M≤ ReadMe úwúwM≤ⁿC
v uNv]tú≤÷ΩTC
bw DB2 úºeAziHquDB2 Σñv⌠W∩M≤UⁿA
Hs\¬M≤ ReadMe uNvCuDB2 Σñv⌠⌠
O http://www.ibm.com/software/data/db2/udb/support.htmlC
M≤O[Coϕb⌠≤ DB2 wsM≤ñAút DB2 P
@ºeM≤ñ≤sCzbsM≤hW⌡µ DB2 ⌠A
HTO@S DC
ΓM≤MG
v C@O DB2 úM≤CM≤iHbsúwWMA
≤⌡µSs DB2 wπúwC
v qM≤ (¡ Linux UNIX)CqM≤iH≤wwh DB2 ú
wC
pGwwΩayÑAhznOΩayÑM≤CϕΩayÑM≤
Pw DB2 úOP@M≤hAiHMΩayÑM≤CpGzM
OqM≤AhPMqM≤ΩayÑM≤AH≤s DB2
úC
bh½ΩwtWwM≤AtB≤≈u¼AABPΩ
qúúP@M≤hC
²Mn≤:
C@M≤úSw²Mn≤CpΩTA\M≤H ReadMeC
:
1. quDB2 Σñv⌠ http://www.ibm.com/software/data/db2/udb/support.html ñ
∩M≤UⁿAHsUⁿs DB2 M≤C
÷:
v Command Reference ñydb2setup - Install DB2 commandz
v Command Reference ñyinstallFixPack - Update installed DB2 products commandz
v Command Reference ñysetup - Install DB2 commandz
© Copyright IBM Corp. 1993, 2006 51
DB2 Connect v
wwv DB2 Connect °AúíAwín² DB2 Connect vC
MApGnΓ DB2 Connect úvAhiHuDB2 vñv
db2licm ⁿOC
db2licm ⁿOn² DB2 ú\αvX
zbC@wF DB2 ú\αqúWAn² DB2 ú\αvXCp
oú∩ΩTA\ Web W DB2 9 MΩTC
pGQnbwísWú\αvXAhbuDB2 wvδFºeA
nNvXswM /db2/license ²ñC
:
Ynn² DB2 vXAΘJG
db2licm -a filename
Σñ filename O∩≤ú\αvπ⌠WWCv≤P
DB2 ú\α÷pºu CDvW /db2/license ²ñC
Ynn² DB2 ú\αvX@ΩG
1. Ω⌠¿ΩC
2. QAϕⁿOn² DB2 vG
v Y Linux UNIX @tG
db2instance_path/adm/db2licm -a filename.lic
v Y Windows @tG
db2instance_path\adm\db2licm -a filename.lic
Σñ db2instance_path O DB2 ΩmA filename O∩≤zwR
úºvπ⌠WWCv≤zú\αu CDv
² /db2/license ²C
ּ:
v Administration Guide: Implementation ñyLicense managementz
÷@:
v wPtmRΩñyd DB2 vz
v 52 yuvñvn² DB2 ú\αvXz
÷:
v wPtmRΩ ñyDB2 úvz
uvñvn² DB2 ú\αvX
zbw DB2 ú\αmBn² DB2 ú\αvXCpoú
∩ΩTA\ Web W DB2 9 MΩTC
52 DB2 Connect °AtJ
pGQnbwísWú\αvXAhbuDB2 wvδFºeA
nNvXswM /db2/license ²ñC
:
Ynn² DB2 vXG
1. uDB2 εñvAquπ\αϕñ∩vñC
2. ∩znwΣvtC∩ztWΩCqwwú∩úCw
úµNπwwúWC
3. qv\αϕ∩sWC
4. busWvv°íñA∩vG
v b Windows °AWGx:\db2\license\license_filename.lic
v b Linux UNIX °AWG/cd/db2/license/license_filename.lic
Σñ x: /cd Nϕ]t DB2 ú\αº DB2 CD CD ≈
ⁿIC
5. ÷@UMHsWvXC
ּ:
v Administration Guide: Implementation ñyLicense managementz
÷@:
v wPtmRΩñyd DB2 vz
v 52 y db2licm ⁿOn² DB2 ú\αvXz
÷:
v wPtmRΩñyDB2 úvz
db2licm ⁿO]w DB2 vh
vhε°iHPsµ@ DB2 °AC
:
b db2licm ⁿO]wvhAznú IDCYnCXú ID ΩTAΘ
JUCⁿOG
db2licm -l
uúOvµCú IDC
Yn]wvhARv¼A⌡µUCΣñ@CpG
v pGzRO WebSphere Information IntegratorusµvvAΘ
JUCⁿOG
db2licm -c wsiif concurrent
v pGzRO DB2 Connect ServeruµvvAΘJUCⁿOG
db2licm -p db2consv concurrent
÷@:
v 52 y db2licm ⁿOn² DB2 ú\αvXz
10 ßmw@ 53
÷:
v Command Reference ñydb2licm - License management tool commandz
uvñv]w DB2 vh
vhε°iHPsµ@ DB2 °A DB2 Connect °A
C
:
Ynuvñv]wvhARv¼A⌡µUC@G
1. buvñvAqv\αϕ∩≤C
2. bu≤vv°íñA∩zRv¼CpG
v pGzRO WebSphere Information IntegratorusµvvA
∩sAAΘJRvC
v pGzRO DB2 Connect ServeruµvvA∩µ
µsAAΘJRvC
÷@:
v 52 yuvñvn² DB2 ú\αvXz
54 DB2 Connect °AtJ
4 g DB2 Connect qTD≈ iSeries Ωw
oDDítmD≈ iSeries Ωw°AnBJAHⁿ DB2 Connect
u@suCoBJπnºtMvSϕMN⌡
µ (pA⌠⌠Bt DB2 z)C
ptmD≈ iSeries Ωw°A÷ΩTA\ DB2 for z/OS wσ≤A
σ≤iHUCmoG
http://www.ibm.com/software/data/db2/zos/v8books.html
]\UCmñ Distributed Database Programming ΩTG
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/ddp/rbal1kickoff.htm
dAXOBdCϕúⁿA½W
zv (p⌠⌠WíW)C
© Copyright IBM Corp. 1993, 2006 55
56 DB2 Connect °AtJ
11 DB2 Connect qT DB2 for OS/390 and z/OS Ω
w
DB2 Connect su DB2 Universal Database for OS/390 and z/OS
DDúb DB2 Connect DB2 Universal Database for z/OS and OS/390 ºí
TCP/IP ⌠⌠su÷ⁿC
pGzw DB2 for OS/390 z/OS NPhm≤sµ÷ (ΓÑqTw)A\
uεñvuhm≤svDDC
:
Yn DB2 Universal Database for z/OS and OS/390 ¼ DB2 Connect su
nDAzzLUCΦítmqT≤wG
v tm TCP/IP for DB2 Universal Database for OS/390 and z/OS
v tm DB2 Universal Database for OS/390 and z/OS
÷@:
v 57 ytm DB2 Universal Database for OS/390 and z/OS TCP/IPz
v 60 ytm DB2 Universal Database for OS/390 and z/OSz
v DB2 Connect ΓUñyuεñvuhm≤svz
tm DB2 Universal Database for OS/390 and z/OS TCP/IP
DDíp≤tm DB2 Connect u@ DB2 UDB for OS/390 DB2 UDB for
z/OS 7 ≤sºí TCP/IP qTCoⁿON]UC¼pG
v zzL TCP/IP Pµ@D≈ΩwsChD≈suHPΦíBzA
÷MC@íp≡ A XúPC
v Ωw≤ DB2 UDB for OS/390 DB2 UDB forz/OS 7 ≤sC
v nΘúwwC
v DB2 ßú]wnC
¼ΩT:
bziHzL TCP/IP su DB2 Connect ºeAz¼÷D≈Ωw°
A DB2 Connect °AΩTCw∩zzL TCP/IP sC@íD≈°AA
z²FUCΩTG
v TCP/IP services hosts b DB2 Connect u@WmG
b UNIX Linux W
/etc/
b Windows XP Windows Server 2003 W
qO %SystemRoot%\system32\drivers\etc\AΣñ %SystemRoot% Nϕ
Windows w⌠²C
© Copyright IBM Corp. 1993, 2006 57
ziαQsWD≈ΩT⌠W°AAHKbhtW@oC
v DB2 Universal Database for z/OS and OS/390 D≈WºÑmC
v wq DB2 Universal Database for z/OS and OS/390 TCP/IP ≡ C
: ÷AWΩTúb DB2 Connect u@P DB2 Universal Database for
z/OS and OS/390 ºíµ½C
≡ 446 wn² DB2 Connect u@qTw]C
v D≈ DB2 Connect u@ TCP/IP D≈WC
v DB2 for OS/390 Ωw°A LOCATION NAMEC
v bD≈ iSeries °AWVΩwoX CONNECT nDA ID P
KXC
óz⌠⌠z DB2 for OS/390 z/OS zAnD≤UoΩTC
UCϕµ@u@ϕAHW DB2 Connect D≈Ωw°AºíC@
TCP/IP suC
ϕ 2. ΩT
í d z
TCP-1 W A.D.B.User
TCP-2 pΩT (123)-456-7890
TCP-5 ID ADBUSER
TCP-6 Ωw¼ db2390
TCP-7 s¼ (O
TCPIP)C
TCPIP TCPIP
ϕ 3. D≈W⌠⌠
í d z
TCP-8 D≈W MVSHOST
TCP-9 D≈ IP 9.21.152.100
TCP-10 AW db2inst1c
TCP-11 ≡ 446 446
TCP-12 mW NEW_YORK3
TCP-13 ID
TCP-14 KX
:
1. noD≈ IP TCP-9AbD≈WΘJG
TSO NETSTAT HOME
2. no≡ X TCP-11Ab DB2 DnítΘxñjM
DSNL004IC
ϕ 4. DB2 Connect u@W⌠⌠
í d z
TCP-18 D≈W mcook02
TCP-19 IP 9.21.27.179
TCP-20 AW db2inst1c
TCP-21 ≡ 446 446
58 DB2 Connect °AtJ
ϕ 5. DB2 Connect u@W DB2 ²
í d z
TCP-30 IW MVSIPNOD
TCP-31 ΩwW nyc3
TCP-32 ΩwOW mvsipdb1
TCP-33 DCS ΩwW nyc3
tm TCP/IP su:
ziHñoBJA¿tmsC
¿u@ϕ:
¿C@ TCP/IP D≈u@ϕdG
1. ±J≤ DB2 Universal Database for z/OS and OS/390 D≈ºD≈W IP
(TCP-8 TCP-9)C
2. ±J≤ DB2 Connect u@ºD≈W IP (TCP-18 TCP-19)C
3. Mwn≤suAW≡ (TCP-10 TCP-20AO TCP-11 TCP-21)C
4. Mwzns DB2 for OS/390 and z/OS Ωw°A LOCATION NAMEC
5. MwsD≈Ωwn ID KXC
≤s DB2 Universal Database for z/OS and OS/390 D≈:
bz zSeries °AWG
1. τD≈D≈WC
2. τ≡ AWC
3. nAHT≡ AW≤s Services C
4. nAH DB2 Connect u@D≈W IP A≤s hosts ( DB2
Universal Database for z/OS and OS/390 tu⌠W°Av)C
5. TbsºeAswqw@CóD≈⌠⌠zA≤
εH (pGn)C
6. ó DB2 Universal Database for z/OS and OS/390 zAHdzOπ
IDBKXΩw LOCATION NAMEC
7. pGD≈tW TCP/IP Σ∩AT≡ ∩ DB2 Connect °
Aiµ PING @CpG
ping remote_host_name -p port_number
: DB2 Connect úΣq 7 ßzL 9 hD∩D≈oX PING ⁿOC
p zSeries OS/390 °AΣAyX
http://www.ibm.com/servers/eserver/support/zseries/
÷@:
v 69 y CLP tmsD≈ iSeries Ωw°Asuz
v 67 y CA tmsD≈ iSeries Ωw°Asu (Linux
Windows)z
11 DB2 Connect qT DB2 for OS/390 and z/OS Ωw 59
v 57 y DB2 Connect su DB2 Universal Database for OS/390
and z/OSz
tm DB2 Universal Database for OS/390 and z/OS
bziH DB2 Connect ºeAz DB2 Universal Database for z/OS and OS/390
ztm DB2 Universal Database for z/OS and OS/390AH\q DB2 Connect
u@sCqNⁿz≤sU¡AH\ DB2 Connect ßP DB2
Universal Database for z/OS and OS/390 Ωw°A suCpdA
\ DB2 for z/OS wσ≤G
v 7 σ≤iHqUCmoGhttp://www.ibm.com/software/data/db2/zos/v7books.html
v 8 σ≤iHqUCmoGhttp://www.ibm.com/software/data/db2/zos/v8books.html
@h:
Y DB2 UDB for OS/390 and z/OS 7 AM APAR PQ50016BPQ50017
PK05198 íC
t\ http://www.ibm.com/servers/eserver/zseries/zos/servicetst/AHosuX
AvC
÷@:
v 57 ytm DB2 Universal Database for OS/390 and z/OS TCP/IPz
60 DB2 Connect °AtJ
12 DB2 Connect qT DB2 UDB for iSeries Ωw
DB2 Connect su DB2 Universal Database for iSeries
DB2 Connect iH²tís DB2 UDB for iSeries tWΩC
:
Yn]wsuAznFUCΩTG
1. ⌠⌠WCziHΘJ DSPNETAAYiooΩTC
2. tdCziHQUCΣñ@ΦíΘJ WRKLIND ⁿOAYioΩ
TG
WRKLIND (*elan)CXA⌠⌠td
WRKLIND (*trlan)CXO ⌠td
WRKLIND (*all)CXtd
3. D≈WCziHΘJ DSPNETAAYioΩTC
4. TCP/IP ≡AWCw] X'07'6DB (X'07F6C4C2')CDB2 UDB for iSeries @
ww]CpGΘJQirúΦKAhOWO QCNTEDDMC
5. ÷píΩwWCziHΘJ DSPRDBDIREAYiooΩTCπ@
MµCbumvµñAt *LOCAL rµOOwqß
RDBNAMECpGS *LOCAL n²AziHsW@n²Aq°AW
DSPNETA ⁿOotWC
UO@dG
© Copyright IBM Corp. 1993, 2006 61
Display Relational Database Directory Entries
Position to . . . . . .
Type options, press Enter.5=Display details 6=Print details
Relational Remote
Option Database Location Text
_ ____________________
_ DLHX RCHAS2FA
_ JORMT2FA JORMT2FA
_ JORMT4FD JORMT4FD
_ JOSNAR7B RCHASR7B
_ RCHASR7B *LOCAL
_ RCHASR7C RCHASR7C
_ R7BDH3SNA RCH2PDH3
_ RCHASDH3 RCHASDH3
ϕzq iSeries °AooAbUCu@ϕñΘJG
ϕ 6. iSeries tm
d z
A-1 ⌠⌠W SPIFNET
A-2 td 400009451902
A-4 D≈W SYD2101A
A-5 TCP/IP ≡AW X'07F6C4C2'(w])
A-6 ÷píΩwW NEW_YORK3
p÷ΩTA\ DB2 Server for VSE & VM SQL Reference yDRDA
Considerations Guidez(SC09-2989)C
÷@:
v 63 y DB2 Connect su DB2 for VSE & VMz
62 DB2 Connect °AtJ
13 DB2 Connect qT DB2 for VM VSE Ωw
DB2 Connect su DB2 for VSE & VM
pp≤N DB2 Server for VSE & VM ]í°A÷ΩTA\ DB2
Server for VSE & VM SQL Reference yDRDA Considerations Guidez (SC09-2989)C
© Copyright IBM Corp. 1993, 2006 63
64 DB2 Connect °AtJ
5 g tmsD≈ iSeries Ωw
w DB2 Connect BtmΩw°A²ªⁿqTºßAzbΓt
ºí suB[HπCíp≤utmUí (CA)v DB2 ⁿOµ
Bz (CLP) MΣBssΩw°AC
AX\¬∩H
v ⌠⌠tz
v tdwtm DB2 Connect tNH
© Copyright IBM Corp. 1993, 2006 65
66 DB2 Connect °AtJ
14 utmUív
CA tmsD≈ iSeries Ωw°Asu (Linux Windows)
@íp≤utmUí (CA)vAq DB2 Connect u@sΩw
D≈ iSeries Ωw°AC CA O@ DB2 GUI uπAitmΩwsu
ΣLΩw]wC
: bºeñA¡xúΣuDB2 zuπv(p CA)Cb 9 Au
Windows x86BWindows x64 (AMD64/EM64T)Bx86 LinuxAH AMD64/EM64T
Linux ΣuDB2 zuπvCb¡xWAzúiH DB2 ⁿOµB
z (CLP) tmsD≈ iSeries Ωw°AsuC
z DB2 Connect u@iHOUC䤧@G
DB2 ß
DB2 ßiHzL DB2 Connect °AúAísD≈ iSeries Ω
wC
DB2 Connect Personal EditionziH DB2 Connect Personal EditionAsD≈ iSeries ΩwC
]iHzL DB2 Connect °AúsC
²Mn≤:
v utmUívwb DB2 Connect u@WCutmUíviHϕ¿
DB2 ß≤C
v tm°AⁿJ≡ßnDCw]A°Awít
m°AWjí≈qT≤wAHⁿJ≡ßsuC
:
ziHUCΦkAQ CA tmΩwsu (\DDu÷@
v)G
v ß]wsΩw
v CA ΓsΩw
÷@:
v 69 y CLP tmsD≈ iSeries Ωw°Asuz
v 90 yutmUívΓtmΩwsuz
v DB2 ßtJñyß]wfttmUítmΩwsuz
v 91 yutmUívΩwsuz
© Copyright IBM Corp. 1993, 2006 67
68 DB2 Connect °AtJ
15 CLP
CLP tmsD≈ iSeries Ωw°Asu
ziH DB2 ⁿOµBz (CLP)AHΓΦítm DB2 Connect °AD≈
iSeries Ωwºí TCP/IP suC
²Mn≤:
b DB2 Connect PD≈ iSeries Ωw°AºíΓtm TCP/IP suºeAT
wG
v TCP/IP b DB2 Connect °APD≈ iSeries tWB@C
v zwOUCG
– D≈W (hostname) IP (ip_address)
– suAW (svcename) ≡ /qT≤w ( port_number/tcp)
– ΩwW (target_dbname)
– ΩwW (local_dcsname)
– IW (node_name)
:
Ynb DB2 Connect °APD≈ iSeries ΩwºíΓtm TCP/IP suAG
1. b DB2 Connect °AWtm TCP/IPC
2. s TCP/IP IC
3. ND≈ iSeries Ωws¿ΩwsuA (DCS) ΩwC
4. sD≈ iSeries ΩwC
5. NíísD≈ iSeries Ωw°AC
6. D≈ iSeries su.
: ≤ TCP/IP qT≤wΦAHiαLkNt@í∩ÑD≈ iSeries ó
Yq TCP/IPC]A TCP/IP s DB2 °AßíA
°AW∩NzíAiαXϕ≈ípCoó TCP/IP s
uwAiH TCP/IP SO_KEEPALIVE Socket ∩iµC
÷@:
v 75 17 , yb DB2 Connect WsΩwíz
v 67 y CA tmsD≈ iSeries Ωw°Asu (Linux
Windows)z
v 57 ytm DB2 Universal Database for OS/390 and z/OS TCP/IPz
÷:
v Command Reference ñyCATALOG DATABASE commandz
v Command Reference ñyCATALOG DCS DATABASE commandz
v Command Reference ñyCATALOG TCPIP/TCPIP4/TCPIP6 NODE commandz
© Copyright IBM Corp. 1993, 2006 69
v SQL ReferenceAVolume 2 ñyCONNECT (Type 1) statementz
70 DB2 Connect °AtJ
6 g DB2 Connect
© Copyright IBM Corp. 1993, 2006 71
72 DB2 Connect °AtJ
16 ⌡µzví
ziHQww DB2 ßm⌡µ DB2 íC
UCXíúiHs DB2 ΩwG
v DB2 ßoíA]AOí SQLBAPIBxsBwq
τ DB2 CLI Is
v ODBC í
v JDBC í Applet
v t HTML SQL Net.Data® ¿
b Windows @tWAUC]iHs DB2 ΩwG
v H Microsoft Visual Basic Microsoft Visual C++ Ω@ ActiveX Data Objects (ADO)
v H Microsoft Visual Basic Ω@ Remote Data Objects (RDO)
v ½≤sMO (OLE) í (UDF xs)
v ½≤sMOΩw (OLE DB) ϕµτ
DB2 ßWíiHsΩwAú@wnDªΩΘmC DB2
ßiPwΩwmBz∩Ωw°AnDΘAHGC
Yn⌡µΩwßíAG
1. Tw°Awtm¿Ab⌡µñC
2. b DB2 °AWATwΩwzíwbíPΣsΩw°AW
CYΣAbíºeAb°AoX db2start ⁿOC
3. TwziPíºΩwsC
4. sííΩwC
5. ⌡µíC
ּ:
v Getting Started with Database Application Development ñySupported database
application programming interfacesz
÷@:
v Call Level Interface Guide and Reference, Volume 1 ñySetting up the CLI
environmentz
v Call Level Interface Guide and Reference, Volume 1 ñySetting up the UNIX ODBC
environmentz
v Call Level Interface Guide and Reference, Volume 1 ñySetting up the Windows
CLI environmentz
÷:
v 15 yΩwío DB2 Client Σz
© Copyright IBM Corp. 1993, 2006 73
74 DB2 Connect °AtJ
17 b DB2 Connect WsΩwí
zNΩwí (JBXB½BuⁿOµBzv) M DB2 CLI s
AsC@ΩwºßAαPΩw@oíCb⌠⌠⌠
ñApGzhßObúP@tW⌡µA≤úP DB2
AhAhbC@t DB2 Xñsí@C
sí Ω]AªO@½≤A½≤]Aqµ@BzSw SQL »
zínΩTC
sbúP .lst ñAo≤w² (Y WindowsAq
O sqllib) U bnd ²C C∩°AíO@C
:
sD≈ iSeries Ωw
YnNíísD≈ iSeries Ωw°AAsD≈
iSeries °AAUCd@dG
connect to dbalias user userid using passwordbind path/bnd/@ddcsmvs.lst blocking all sqlerror continue
messages mvs.msg grant publicconnect reset
Σñ path ∩ DB2PATH n²C
s DB2 Ωw
zp≤ΩwíPΩwsA°zu@@twC
v utmUívG
1. utmUí (CA)vC
2. ∩zQníPΣsΩwC
3. ½kΣ÷@UA∩sC
4. ∩nsíC
5. sW⌠≤Qns∩C
6. ΘJNPΩws ID KXC ID vNsΩ
]sΩwWC÷@UsC
v ⁿOµBzG
1. ≤ bnd ²AoO x:\sqllib\bndAΣñ x: Nϕww DB2
≈C
2. YnsuΩwAbuⁿOñvuⁿOµBzvñΘJUC
ⁿOG
connect to database_alias
Σñ database_alias NϕzQnsuΩwOWC
3. buⁿOñvuⁿOµBzvñΘJUCⁿOG
"bind @db2ubind.lst messages bind.msg grant public""bind @db2cli.lst messages clibind.msg grant public"
© Copyright IBM Corp. 1993, 2006 75
bolñAbind.msg clibind.msg OΘXTºA EXECUTE
BINDADD MvN publicC
4. oXUCⁿOAi½]PΩwsG
connect reset
:
1. db2ubind.lst tb ΩwíΩ]s
(.bnd) MµC db2cli.lst tb DB2 CLI M DB2 ODBC X
íΩ]s (.bnd) MµC
2. siαnßWXα¿C
3. pGz BINDADD v¡Ah@ DB2 CLI ODBC X
íA DB2 CLI Ω]sCpGzísΩ
wAhiutmUívusv≈α (ⁿOµBz) ⌡µ
s@C
÷:
v Command Reference ñyBIND commandz
v Call Level Interface Guide and Reference, Volume 1 ñyDB2 CLI bind files and
package namesz
76 DB2 Connect °AtJ
18 i@B\¬
Yni@B\¬A\ DB2 Connect ΓUAª[\DDpUG
v í÷pΩw[c (DRDA)
v DB2 Connect Ω
v ≤sΩw²
v w
v síí
v hm≤s
v SQLCODE ∩M
v Ωwt°
v α
v su@
v suñ
v DB2 Connect Sysplex Σ
v WebSphere Information Integrator iµsu
YqßsD≈Ω 3 h⌠AhiHb DB2 ßtJ@ñΣ
DB2 ßwtmΩTC
© Copyright IBM Corp. 1993, 2006 77
78 DB2 Connect °AtJ
7 g Ω
© Copyright IBM Corp. 1993, 2006 79
80 DB2 Connect °AtJ
19 ⁿ DB2 ú CD
ⁿ CD-ROM (AIX)
²Mn≤:
Yn⌡µ@An Root v¡C
:
Ynutzuπ (SMIT)vb AIX Wⁿ CD-ROMA⌡µUCBJG
1. Hπ root v¡¡nJC
2. N CD-ROM íJ≈C
3. ΘJ mkdir -p /cdrom ⁿOH CD-ROM ⁿIAΣñ cdrom Nϕ CD-ROM
ⁿI²C
4. ΘJ smit storage ⁿOA SMIT tm CD-ROM tC
5. SMIT ºßA∩t —> sW / ≤ / π / Rút —>CDROM t —> sW CDROM tC
6. busWtv°íñG
v bmWµñAΘJ CD-ROM tmWCCD-ROM t
mWO@CpG½mWAhziαRú²ewq
CD-ROM tAO²z²t@WCbdñAN
/dev/cd0 @mWC
v bⁿI°íñAΘJ CD-ROM ⁿI²CbdñAⁿI²O /cdromC
v bt½sⁿµñA∩OHtⁿC
v ÷@UTwH÷¼°íAMß÷T°H⌠ SMITC
7. ΣAΘJ smit mountfs ⁿOHⁿ CD-ROM tC
8. buⁿtv°íñG
v btWµñAΘJ CD-ROM tmWCbdñAm
WO /dev/cd0C
v bnⁿ²µñAΘJ CD-ROM ⁿICbdñAⁿIO /cdromC
v bt¼µñAΘJ cdrfsCYn°ziHⁿΣªtA
÷@UCC
v bⁿ¬tµñA∩OC
v ⁿlw]AA÷@UuTwvH÷¼°íC
z CD-ROM tbw¿ⁿCYn° CD-ROM eANm
≤≈AMßΘJ cd /cdrom ⁿOAΣñ cdrom O CD-ROM ⁿI²C
÷@:
v DB2 °AtJñyw DB2 °A (Linux UNIX)z
÷:
© Copyright IBM Corp. 1993, 2006 81
v DB2 °AtJñyDB2 ß°AwD (AIX)z
ⁿ CD-ROM (HP-UX)
UCBJi²zQaⁿ DB2 for HP-UX ú CD-ROMC
²Mn≤:
Yn⌡µ@An Root v¡C
:
Ynⁿ DB2 for HP-UX ú CD-ROMAG
1. Hπ root v¡¡nJC
2. N CD-ROM íJ≈C
3. °nNs²wq≈ⁿIC mkdir /cdrom ⁿON /cdrom wq
ⁿIC
4. °n ioscan -fnC disk ⁿOO≈mCⁿOiCwO≈Σ÷mCWⁿ /dev/dsk/c1t2d0C
5. N≈ⁿⁿI²G
mount -F cdfs -o rr /dev/dsk/c1t2d0 /cdrom
6. ls /cdrom ⁿOoMµHτⁿC
7. nXC
z CD-ROM tbw¿ⁿCYn° CD-ROM eAN CD m≤
≈AMßΘJ cd /cdrom ⁿOAΣñ cdrom O CD-ROM ⁿI²C
÷:
v DB2 °AtJñyDB2 ß°AwD (HP-UX)z
v wPtmRΩñyDB2 úvz
ⁿ CD-ROM (Linux)
²Mn≤:
Yn⌡µ@An Root v¡C
:
Ynb Linux Wⁿ CD-ROMA⌡µUCBJG
1. Hπ root v¡¡nJC
2. N CD-ROM íJ≈AMßΘJUCⁿOG
mount -t iso9660 -o ro /dev/cdrom /cdrom
Σñ /cdrom Nϕ CD-ROM ⁿIC
3. nXC
82 DB2 Connect °AtJ
z CD-ROM tbw¿ⁿCYn° CD-ROM eANm
≤≈AMßΘJ cd /cdrom ⁿOAΣñ cdrom O CD-ROM ⁿI²C
÷:
v wPtmRΩñyDB2 úvz
ⁿ CD-ROM (Solaris @⌠)
²Mn≤:
pGz NFS qtⁿ≈Ah root svXqúW
CD-ROM tCz]qúW root svⁿtC
:
YnbuSolaris @⌠vWⁿ CD-ROMAG
1. Hπ root v¡¡nJC
2. N CD-ROM íJ≈ñC
3 . pGtb⌡µueΘzív (vo ld )Ah CD-ROM Nⁿ¿
/cdrom/cd_label (pG) /cdrom/unnamed_cdrom (pGS)C
pGzt⌡µueΘzívA¿UCBJⁿ CD-ROMG
a. ΘJUCⁿOHPmWG
ls -al /dev/sr* |awk ’print "/" $11’
ⁿO CD-ROM mWCbdñAⁿOrΩ
/dev/dsk/c0t6d0s2C
b. ΘJUCⁿOHⁿ CD-ROMG
mkdir -p /cdrom/unnamed_cdrommount -F hsfs -o ro /dev/dsk/c0t6d0s2 /cdrom/unnamed_cdrom
Σñ / d e v / d s k / c 0 t 6 d 0 s 2 NϕW@BJmWA
/cdrom/unnamed_cdrom Nϕ CD-ROM ⁿ²C
: pGzOq NFS tⁿ≈Ah root sv
X≈W CD-ROM tCzτ root svNt
w≈WC
4. nXC
z CD-ROM tbw¿ⁿCYn° CD-ROM eANm
≤≈AMßΘJ cd /cdrom ⁿOAΣñ cdrom O CD-ROM ⁿI²C
÷@:
v DB2 °AtJñyw DB2 °A (Linux UNIX)z
÷:
v DB2 °AtJñyDB2 ß°AwD (Solaris @t)z
19 ⁿ DB2 ú CD 83
84 DB2 Connect °AtJ
20 úw DB2 Connect
úw DB2 ú (Windows)
@úq Windows @tú DB2 úBJCϕúAns DB2
ΩΩwA⌡µ@C
pGúwO DB2 w]ABbtWΣL DB2 Ahb≥iµ
úwºeA db2swtch ⁿO∩sw]CBApGΩwz°A (DAS) ObwúU⌡µAhN DAS úñChA
búwºßA db2admin create ⁿO½ DASABiαn½stm
DASAY\ααB@C
:
Ynq Windows ú DB2 úA⌡µUCBJG
1. ≤ΩwCziHuεñv drop database ⁿO≤ΩwCpG≤ΩwAzNóhΩC
2. ε DB2 ACoiHzLuWindows AveoX db2stop ⁿO¿Cbú DB2 úºeApG DB2 AεAzN¼
@iAΣñtbOΘñOd DB2 DLL AMµC
3. ú DB2 úΓ∩G
sW/úí
izLuWindows εxvsusW/úív°íú DB2
úCpq Windows @túnΘúΩTA\@t
íC
db2unins ⁿO
ziH⌡µ db2unins ⁿOú DB2 úCⁿOAiHQ /p Púwh DB2 úC]iH /u (ΣNúñ
ⁿw DB2 ú)ALnúw DB2 úCp÷ΩTA\
db2unins ⁿODDC
≥OAuεx - sW/úív≈αA db2unins /p ⁿOdb2unins /u ⁿOAú@wα≈ú DB2 úCϕWΦkóA
UCúw∩C
Ynq Windows tWjεúí DB2 A⌡µ db2unins /f ⁿOCⁿOjεúwtWí DB2 CúFΩ (p DB2 Ωw) HA
jεRúíeC
÷@:
v 86 yúw DB2 ú (Linux UNIX)z
v wPtmRΩñyúw DB2 ú (Windows)z
v Administration Guide: Implementation ñyChanging the Default DB2 copy after
installation (Windows)z
© Copyright IBM Corp. 1993, 2006 85
÷:
v Command Reference ñydb2swtch - Switch default DB2 copy commandz
v Command Reference ñydb2unins - Uninstall DB2 database product commandz
v Command Reference ñyDROP DATABASE commandz
úw DB2 ú (Linux UNIX)
@úq Linux UNIX @tú DB2 úBJCún@AYi
ws DB2 úCLinux UNIX WC@ DB2 úúπúPw
⌠A]iHsbP@íqúWC
:
Ynú DB2 úA⌡µUCBJG
1. ∩G≤ΩwCziHuεñv drop database ⁿO≤ΩwC≤Ω²²≤ΩwAtWΩwOdπC
2. ε DB2 z°AC
3. úz°AC
4. ε DB2 ΩC
5. úh DB2 ΩC
6. úh DB2 úC
ּ:
v Administration Guide: Implementation ñyDB2 Administration Serverz
÷@:
v DB2 °AtJñyε DB2 z°A (Linux UNIX)z
v DB2 °AtJñyú DB2 z°A (Linux UNIX)z
v DB2 °AtJñyε DB2 Ω (Linux UNIX)z
v DB2 °AtJñyú DB2 Ω (Linux UNIX)z
v DB2 °AtJñy db2_deinstall doce_deinstall ⁿOú DB2 ú
(Linux UNIX)z
v 85 yúw DB2 ú (Windows)z
÷:
v Command Reference ñyDROP DATABASE commandz
86 DB2 Connect °AtJ
8 g ²PßO
© Copyright IBM Corp. 1993, 2006 87
88 DB2 Connect °AtJ
² A. utmUívtmΩwsu
utmUívjM⌠⌠tmΩwsu
ziHutmUí (CA)vjM⌠⌠ñΩwC
²Mn≤:
bzjM⌠⌠tmΩwsuºeG
v Twzπ@ DB2 IDC
v pGzqwF DB2 Server DB2 Connect °AúttmsuAT
Oz ID πΩ SYSADM SYSCTRL v¡C
¡ε:
bUCípñAjMΦk\αiαLktG
v DB2 Administration Server (DAS) SbtW⌡µC
v jMOCw]AjM@y⌠⌠ 1 ϕFiαú¼HtC
ziH]w DB2DISCOVERYTIME n²Hⁿw°íC
v wtm⌡µjM@⌠⌠AjM@LkΣQntC
nQbΣ IPv6 ⌠⌠WTtm IPv6 ANHUXIG
v tCbwtñC
v utmUíiÑ°vΣTatm IPv6 suC
:
jM⌠⌠tmΩwsuG
1. H DB2 ID nJtC
2. CACziHq Windows Wulv\αϕAOb Windows UNIX t
W db2ca ⁿOA CAC
3. b CA \αϕC∩UA∩δFsWΩwCYsWΩwδFC
4. ∩jM⌠⌠ΩsA÷@UU@BC
5. ÷ΓUwtΣΩ¿ACXßwtA÷ΓUΣLt
ΣΩ¿ACX⌠⌠WtC
pGCX⌠≤tAziH÷@UsWtⁿw@tCsWtºßAª
NπbwtMµñC
6. iztAzQsWΩwεC∩ΩwC÷U@
BC
7. bΩwOWµñΣJΩwOWAbµñ∩aΣJií
ΩwC
8. pGzp ODBCANoΩwn²¿ ODBC ΩCw
ODBCAΦi⌡µo@C
9. ÷@U¿CbziHwsWΩwC÷@U÷¼H⌠ CAC
© Copyright IBM Corp. 1993, 2006 89
ּ:
v DB2 ßtJñyß°AqTtmº[z
÷@:
v 90 yutmUívΓtmΩwsuz
v 91 yutmUívΩwsuz
utmUívΓtmΩwsu
pGzQnsΩwBHΩwntΩTAhziHµΘJ
tmΩTCΦkⁿⁿOµBzΘJⁿOA²OªOΦke
C
²Mn≤:
bzutmUí (CA)vΓtmΩwsuºeG
v TOzπnsuΩw DB2 IDC
v pGzqwF DB2 °A DB2 Connect °AúttmsuAT
Oz ID πΩwzíΩ SYSADM SYSCTRL v¡C
:
Yn CA ΓtmΩwsuG
1. H DB2 ID nJtC
2. CACiHq Windows ulv\αϕ db2ca ⁿO CAC
3. b CA \αϕC∩UA∩δFsWΩwC
4. ∩µtmPΩwsuΩsAMß÷@UU@BC
5. pGzn Lightweight Directory Access Protocol (LDAP)A∩Pn@
DB2 ²m∩ΩsC÷U@BC
6. qqT≤wMµ∩∩≤zQnqT≤wΩsC (G\X
APPCBAPPN NetBIOS ∩A²OwgúAΣo∩C)
pGztww DB2 Connect B∩ TCP/IPAhiH∩ΩwΩW≤
D≈ OS/400® to∩CpGz∩o∩A@∩²z∩
zn∩D≈ OS/400 Ωw su¼C
v nzL DB2 Connect hD suA∩ghDs°AΩsC
v Yn suA∩su°AΩsC
÷U@BC
7. ΘJnqT≤wAMß÷@UU@BC
8. bΩwWµñΘJznsWΩwΩwOWAMßbΩwO
WµñΘJΩwOWC
pGznsWD≈ OS/400 ΩwAbΩwWµñAΣJ OS/390
z/OS ΩwmWBOS/400 Ωw RDB WA VSE VM Ωw
DBNAMECziH∩bñsWíΩwC
÷U@BC
90 DB2 Connect °AtJ
9. pGzp ODBCANoΩwn²¿ ODBC ΩCb⌡µ@
ºeATwww ODBCC÷U@BC
10. bⁿwI∩°íñA∩@tAMßΘJzQnsºΩwt
ΩWC
11. bⁿwt∩°íñATwtWBD≈W@tOTCbo
eñΩTO≤tmzICziH∩aΘJC÷U@BC
12. bⁿww∩°íñAⁿwnOw∩C
13. ÷@U¿CzbαΩwC∩⌠\αϕ@H÷¼ CAC
ּ:
v DB2 ßtJñyß°AqTtmº[z
÷@:
v 91 yutmUívΩwsuz
utmUívΩwsu
btmΩwsuºßAz@C
:
YnΩwsuAG
1. tmUíC
2. °ñΩwAqw∩\αϕ∩suCus
uv°íC
3. ∩@hzQnsu¼ (w] CLI)CziHPh¼CΘJΩw ID MKXAMß÷@UsuCpGsu¿\Ab
uGvX@hTsuTºC
pGsuóAzN¼@híTºCYn≤⌠≤ziαúTⁿw]
wAb°ñ∩ΩwAMßq∩\αϕ∩≤ΩwC
ּ:
v DB2 ßtJñyß°AqTtmº[z
÷@:
v 89 yutmUívjM⌠⌠tmΩwsuz
v 90 yutmUívΓtmΩwsuz
² A. utmUívtmΩwsu 91
92 DB2 Connect °AtJ
² B. yÑΣ
≤ DB2 yÑ (Windows)
DB2 yÑOXbTºBííuπWyÑCw DB2 AΣ
@hyÑw∩CpGzbwºßAQN DB2 yÑ≤t@ww
yÑA@ñºzBJC
únN DB2 ΣyÑP DB2 ΣyÑVcCDB2 ΣyÑA]NOΩ
iHyÑAO DB2 ΣºyÑWC
²Mn≤:
zNn DB2 yÑwbtWCuDB2 wvδFw DB2 A
∩w DB2 yÑCpGN DB2 yÑ≤wⁿΣy
ÑAh DB2 yѲw]@tyÑAYúΣyÑAh]yC
:
b Windows W≤ DB2 yÑAn≤ Windows @tw]yÑ]wC
Yn≤ Windows W DB2 yÑA⌡µUCBJG
1. b Windows @tuεxvWA∩a∩C
2. bua∩v∩°íñANtw]yÑ]w≤n≤ DB2 yÑC
@tíAHo≤w]tyÑ[ΩTC
÷@:
v 101 yYnbuDB2 ΩTñvñAHznyÑπDDz
÷:
v 94 yΣ DB2 yÑz
v Administration Guide: Planning ñySupported territory codes and code pagesz
≤ DB2 yÑ (Linux UNIX)
DB2 úyÑOXbTºBííuπWyÑCw DB2 ú
Aw@hyÑΣ∩CpGzbwºßAQNyÑ≤t@
wwyÑA@ñºzBJC
únN DB2 úΣyÑP DB2 ΣyÑVcCDB2 úΣyÑA
]NOΩ iHyÑAO DB2 ΣºyÑWC
²Mn≤:
© Copyright IBM Corp. 1993, 2006 93
zNn DB2 yÑΣwbtWCuDB2 wvδFw
DB2 A∩w DB2 yÑΣCpGN DB2 úyÑ≤
wⁿΣyÑAh DB2 yѲw]@tyÑAYúΣyÑA
h]yC
uDB2 wvδFuΩayÑM≤vw DB2 úA∩w DB2
yÑΣC
:
YndtWiyÑ⌠A⌡µ $ locale -a ⁿOC
Yn≤ DB2 yÑAN LANG ⌠]wzQnyÑ⌠C
Y bourne (sh)Bkorn (ksh) bash ShellG
LANG=<locale>export LANG
Y C ShellG
setenv LANG <locale>
pAYnHky@ DB2 úAhwkyyÑΣABN
LANG ⌠]kyyÑ⌠Ap fr_FRC
÷@:
v 101 yYnbuDB2 ΩTñvñAHznyÑπDDz
÷:
v 94 yΣ DB2 yÑz
v Administration Guide: Planning ñySupported territory codes and code pagesz
Σ DB2 yÑ
DB2 DB2 yÑΣiH¿°AsyÑßsyÑC°As
yÑNα½jí≈TºBí DB2 CßsyÑNα½ DB2
Runtime Client ≤AΣñN]AjíTºYíσ≤C
°AsyÑ]AGΦσσB JσBªσBΓ⌡σBkσBwσBqj
QσBΘσBσB σBi⌡σBXσBΘñσBΦZσBτσσAHc
ΘñσC
ßsyÑ]AGⁿBσBO[QσBJJΦσBⁿ⌡σBσB
BσBIQσBσσB¿ºσBÑ∩JσBѺσAHg
ΣσC
únN DB2 úΣyÑP DB2 ΣyÑVcCDB2 úΣyÑA
]NOΩ iHyÑAO DB2 ΣºyÑWC
÷@:
v 93 y≤ DB2 yÑ (Linux UNIX)z
v 93 y≤ DB2 yÑ (Windows)z
94 DB2 Connect °AtJ
v αΓUñybαíEΩTz
÷:
v Administration Guide: Planning ñyConversion table files for euro-enabled code
pagesz
v Administration Guide: Planning ñyConversion tables for code pages 923 and 924z
v Administration Guide: Planning ñyNational language versionsz
v Administration Guide: Planning ñySupported territory codes and code pagesz
HΣLyÑ⌡µuDB2 wvδFyÑOr
YnPqúw]yÑúPyÑ⌡µuDB2 wvδFAiHΓuDB2 w
vδFAⁿwyÑ IDCyÑi≤n⌡µw¡xWC
ϕ 7. yÑOr
yÑ yÑOr
ⁿBσ (A≤ Windows) ar
Φσσ br
O[Qσ bg
Θñσ cn
cΘñσ tw
JJΦσ hr
Jσ cz
ªσ dk
ⁿ⌡σ nl
σ en
Γ⌡σ fi
kσ fr
wσ de
σ el
IQσ hu
qjQσ it
Θσ jp
σ kr
σ no
i⌡σ pl
σσ pt
¿ºσ ro
Xσ ru
Ñ∩Jσ sk
Ѻσ sl
ΦZσ es
τσσ se
gΣσ tr
² B. yÑΣ 95
÷:
v DB2 °AtJñyHzΩayÑπ db2setup ⁿOz
rΩα½
b≈ºíerΩA²Nªα½¿¼≈iíC
pAb DB2 Connect °AD≈ iSeries Ωw°AºíeΩAq
q°ArX૨D≈ CCSIDAºτMCpGΓx≈úPrX
CCSIDAhNrXIq@rX CCSID ∩Mt@Cα½qOb¼
B⌡µC
eΩwrΩO SQL »zíΘJΩ¿CqΩwer
ΩhOΘXΩ¿CΩΘXΩúQα½CpA FOR
BIT DATA lyiµñΩChApGΓx≈úPrX CCSIDA
ΘJΘXrΩúQα½C
±ΦíApG DB2 Connect sΩAhoUCíG
1. DB2 Connect N SQL »zíΘJΩe OS/390 z/OSC
2. DB2 Universal Database for z/OS and OS/390 NΩ૨D≈°ArXA
MßBzΩC
3. DB2 Universal Database for z/OS and OS/390 NG DB2 Connect °AC
4. DB2 Connect NG૨⌠rXC
p DB2 Connect °ArXD≈ iSeries °A CCSID ºíΣα½÷
ΩTA\ Administration Guide: Planning ñuΩayÑΣv² Supported
territory codes and code pages DDC
∩≤VyÑAIBM wwqF@Sϕ BiDi CCSIDSAB DB2 Connect ]Σo
C
pGΩw°AVúP≤ßVAzioSϕ CCSIDS
BztºC
ּ:
v Administration Guide: Planning ñyCharacter-conversion guidelinesz
÷:
v Administration Guide: Planning ñySupported territory codes and code pagesz
96 DB2 Connect °AtJ
² C. DB2 ΩwNΩT
DB2 NΩTº[
ziHzLUCuπΦko DB2 NΩTG
v DB2 ΩTñ
– DD
– uDB2 uπví
– dí
– ⁿ
v DB2 y
– PDF (iUⁿ)
– PDF (q DB2 PDF CD)
– LΩ
v ⁿOµí
– ⁿOí
– Tºí
v dí
IBM wúAσ≤≤sCpGsuDB2 ΩTñv(ibm.com®) WuW
Ah] IBM NOsAHúnwσ≤≤sCpGww
uDB2 ΩTñvAhzwσ≤≤sCsΩTAσ≤≤si²z≤sq
DB2 ΩTñ CD ñwΩTAq Passport Advantage ñUⁿΩTC
: uDB2 ΩTñvDD≤sWv¬≤ PDF LΩyCYnosΩTA
bσ≤@≤sNwªAyXuDB2 ΩTñv(ibm.com)C
ziHb ibm.com WuWsΣL DB2 NΩTAp TechnotesB
Redbooks™Cs DB2 Informat ion Management sof tware w⌠
(http://www.ibm.com/software/data/sw-library/)C
σ≤Núd
D½°z∩ DB2 σ≤NúCpG⌠≤p≤∩i DB2 σ≤AHq
ll≤e db2docs@ca.ibm.comCDB2 σ≤ñ\¬zNúA²ú
CúSwdiαmA²iH≤RAz DCpGn∩S
wDDíúNúA[WDDD URLC
oqll≤puDB2 ßΣñvCpGσ≤M DB2
N DAsϕa IBM AñHo≤UC
ּ:
v uW DB2 ΩTññyDB2 ΩTñ\αz
v dDDñySample filesz
© Copyright IBM Corp. 1993, 2006 97
÷@:
v Command Reference ñyInvoking command help from the command line processorz
v Command Reference ñyInvoking message help from the command line processorz
v 102 y≤sqú°í⌠⌠°AWwuDB2 ΩTñvz
÷:
v 98 yPDF µí DB2 NOz
PDF µí DB2 NO
UCUϕíiq IBM Publications Center (www.ibm.com/shop/publications/order) o
DB2 wC
÷MϕµⁿXLΩyA²yiαbzΩaaLkúC
oyñΩT∩ DB2 ÑD½nFúzOí]pvBΩw
zAO DB2 Connect ΣL DB2 úAúoΩTDC
ϕ 8. DB2 NΩT
W LΩ
A d m i n i s t r a t i o n G u i d e :
Implementation
SC10-4221 O
Administration Guide: Planning SC10-4223 O
Administrative API Reference SC10-4231 O
Administrative SQL Routines and
Views
SC10-4293
Call Level Interface Guide and
Reference, Volume 1
SC10-4224 O
Call Level Interface Guide and
Reference, Volume 2
SC10-4225 O
Command Reference SC10-4226
Data Movement Utilities Guide and
Reference
SC10-4227 O
D a t a R e c o v e r y a n d H i g h
Availability Guide and Reference
SC10-4228 O
Developing ADO.NET and OLE
DB Applications
SC10-4230 O
Deve lop ing Embedded SQL
Applications
SC10-4232 O
Developing SQL and External
Routines
SC10-4373
Developing Java Applications SC10-4233 O
Deve lop ing Per l and PHP
Applications
SC10-4234
Getting Started with Database
Application Development
SC10-4252 O
98 DB2 Connect °AtJ
ϕ 8. DB2 NΩT (≥)
W LΩ
Linux Windows W DB2 w
zJ
GC40-2078 O
TºΓU @U SC40-2083
TºΓU GU SC40-2084
αΓU GC40-2079 O
Net Search Extender Administration
and User’s Guide
: σ≤ HTML Dq
HTML σ≤ CD wC
SH12-6842 O
Performance Guide SC10-4222 O
Query Patroller Administration and
User’s Guide
GC10-4241 O
DB2 ßtJ GC40-2080
DB2 °AtJ GC40-2077 O
Spatial Extender and Geodetic
Data Management Feature User’s
Guide and Reference
SC18-9749 O
SQL Guide SC10-4248 O
SQL Reference, Volume 1 SC10-4249 O
SQL Reference, Volume 2 SC10-4250 O
Sys tem Moni tor Guide and
Reference
SC10-4251 O
Troubleshooting Guide GC10-4240
Visual Explain ⁿ SC40-2261
sW\α SC40-2085 O
XML Extender Administration and
Programming
SC18-9750 O
XML Guide SC10-4254 O
XQuery Reference SC18-9796 O
ϕ 9. DB2 Connect SwNΩT
W LΩ
DB2 Connect ΓU SC40-2082 O
DB2 Connect Personal Edition
tJ
GC40-2246 O
DB2 Connect °AtJ GC40-2081 O
ϕ 10. WebSphere Information Integration NΩT
W LΩ
WebSphere Information Integration:
Administration Guide for Federated
Systems
SC19-1020 O
² C. DB2 ΩwNΩT 99
ϕ 10. WebSphere Information Integration NΩT (≥)
W LΩ
WebSphere Information Integration:
ASNCLP Program Reference for
Replication and Event Publishing
SC19-1018 O
WebSphere Information Integration:
Configuration Guide for Federated
Data Sources
SC19-1034
WebSphere Information Integration:
SQL Replication Guide and
Reference
SC19-1030 O
: uDB2 NvúzúM≤hSΣLΩTCp
÷ΩTA\÷C
ּ:
v 97 yDB2 NΩTº[z
v Nñy÷≤Nz
÷@:
v 100 yq DB2 LΩyz
q DB2 LΩy
pGznq DB2 LΩyA\hΩaa⌠íúuWqAA²
DΩaa⌠OpCz@iHVϕa IBM Nϕq DB2 L
ΩyCOϕADB2 PDF σ≤ CD WYqlSLΩCpADB2
Message Reference ⌠@USLΩC
ziHV IBM KOquDB2 PDF σ≤vCD W\h DB2 yLΩCzq
µµaIAz]\iHq IBM Publications Center buWqyCpGzΩa
aúúuWqAh@wiHVϕa IBM NϕqLΩ DB2 yC
NADuDB2 PDF σ≤vCD WyúúLΩC
: psBπ DB2 σ≤AyXuDB2 ΩTñvA⌠
http://publib.boulder.ibm.com/infocenter/db2help/C
:
Ynq DB2 LΩyG
v YnAzΩaaOiHbuWqLΩ DB2 yAd\ IBM
Publications CenterA⌠ http://www.ibm.com/shop/publications/orderCz∩
ΩaBayÑαsXqΩTAϕA≤zbaqⁿC
v YnVϕa IBM Nϕq DB2 LΩyG
– qUCΣñ@⌠AΣXϕaNϕpΩTG
- IBM directory of world wide contactsA⌠ www.ibm.com/planetwide
100 DB2 Connect °AtJ
- IBM Publications ⌠A⌠ http://www.ibm.com/shop/publications/orderCz
∩ΩaBayÑAHszbaAϕXCb⌠
WAϕ ″About this site″ C
– qqAⁿwznq DB2 XC
– úNϕzQnqyD C
ּ:
v 97 yDB2 NΩTº[z
÷:
v 98 yPDF µí DB2 NOz
qⁿOµBzπ SQL ¼Aí
DB2 w∩°≤iαO SQL »zíG SQLSTATE C SQLSTATE íi
SQL ¼A SQL ¼AOrXNqC
:
YnIs SQL ¼AíAⁿOµBzΘJG
? sqlstate ? class code
Σñ sqlstate Nϕ¡ SQL ¼AAB class code Nϕ SQL ¼AeΓC
pA? 08003 iπ 08003 SQL ¼AíA ? 08 hNπ 08 OXí
÷@:
v Command Reference ñyInvoking command help from the command line processorz
v Command Reference ñyInvoking message help from the command line processorz
súP DB2 ΩTñ
Y DB2 9 DDAuDB2 ΩTñv URL ⌠G
http://publib.boulder.ibm.com/infocenter/db2luw/v9/C
Y DB2 8 DDA⌡ 8 uΩTñv URLA⌠G
http://publib.boulder.ibm.com/infocenter/db2luw/v8/C
÷@:
v 102 y≤sqú°í⌠⌠°AWwuDB2 ΩTñvz
YnbuDB2 ΩTñvñAHznyÑπDD
DB2 ΩTñHs²n]wⁿwyÑπDDCpGDD ¿
znyÑAh DB2 ΩTñHσπDDC
:
Ynb Internet Explorer s²ñAHznyÑπDDG
² C. DB2 ΩwNΩT 101
1. b Internet Explorer ñA÷@Uuπ —> ⌠⌠⌠∩ —> yÑ... ÷sCuyÑn]wv°íC
2. TwwNznyÑⁿwyÑMµñ@C
v YnNsyÑsWMµñA÷@UsW... ÷sC
: sWyÑúOqúπHnyÑπDDr¼C
v YnNyÑMµA∩yÑA÷@UW÷sAyÑ¿yÑM
µ@yÑεC
3. Mús²AMß½sπzAYHznyÑπuDB2 ΩTñ
vC
Ynb Firefox Mozilla s²ñHznyÑπDDG
1. ∩uπ —> ∩ —> yÑ÷sCun]wv°íñπuyÑveC
2. TwwNznyÑⁿwyÑMµñ@C
v YnNsyÑsWMµñA÷@UsW... ÷sAqusWyÑv°íñ∩yÑC
v YnNyÑMµA∩yÑA÷@UW÷sAyÑ¿yÑM
µ@yÑεC
3. Mús²AMß½sπzAYHznyÑπuDB2 ΩTñ
vC
bí≈s²@tXñAziαnN@ta]w≤z∩
yÑ⌠yÑC
ּ:
v 97 yDB2 NΩTº[z
≤sqú°í⌠⌠°AWwuDB2 ΩTñv
pGz⌠wuDB2 ΩTñvAh≤sDDiUⁿCbjí≈D
DΣue≤svⁿXDDµhC
YnPπuDB2 ΩTñvOi≤sAMΣuΩTñvWue
≤svCN⌠wñAP
http://www.ibm.com/software/data/db2/udb/support/icupdate.html WsiUⁿ≤sΘ
±CMßApGisUⁿ≤sANiH≤s⌠wnuΩT
ñvC
≤s⌠wuDB2 ΩTñvAznG
1. εqúWuDB2 ΩTñvAMßHW íí½suΩTñvCHW
íí⌡µuΩTñviε⌠⌠WΣLsuΩTñvAi²
zUⁿM≤sC
2. u≤sv\αP IBM Oú≤sΩ]C
102 DB2 Connect °AtJ
: CD ñ]≤sCpp≤tmuΩTñvq CD ñw≤sΩTA
\÷C
pG≤sΩ]Au≤sv\αUⁿΩ] (u≤sv\αuA≤W
íí)C
3. εW íuΩTñvA½sqúWuDB2 ΩTñvAC
:
Yn≤sqúW°í⌠⌠°AWwwuDB2 ΩTñvAG
1. εuDB2 ΩTñvAC
v bWindows WA÷@Ul → εx → tzuπ → ACMß½kΣ
÷@U DB2 ΩTñAA∩εC
v b Linux WAΘJUCⁿOG
/etc/init.d/db2icdv9 stop
2. HW ííuΩTñvC
v b Windows WG
a. ⁿO°íC
b. s²wwuΩTñv⌠Cw]A uDB2 ΩTñvw
b C:\Program Files\IBM\DB2 Information Center\Version 9 ²ñC
c. uDB2 ΩTñvπ⌠⌡µ help_start.bat G
<DB2 Information Center dir>\doc\bin\help_start.bat
v b Linux WG
a. s²wwuΩTñv⌠Cw]A uDB2 ΩTñvOw
b /opt/ibm/db2ic/V9 ²ñC
b. uDB2 ΩTñvπ⌠⌡µ help_start ScriptG
<DB2 Information Center dir>/doc/bin/help_start
tw] Web s²AHπW íuΩTñvC
3. ÷@Uu≤sv÷s ( )CbuΩTñvkΣeWA÷@UMΣ≤sCY
πsσ≤≤sMµC
4. YnlUⁿA∩QnUⁿ∩AMß÷@Uw≤sC
5. Uⁿw¿ºßA÷@U¿C
6. εW íuΩTñvC
v b Windows WAuDB2 ΩTñvπ⌠⌡µ help_end.bat G
<DB2 Information Center dir>\doc\bin\help_end.bat
: help_end σ]tnⁿOAiHwεw help_start σ
Cún Ctrl-C ΣL⌠≤Φkε help_start.batC
v b Linux WAuDB2 ΩTñvπ⌠⌡µ help_end ScriptG
<DB2 Information Center dir>/doc/bin/help_end
: help_end Script ]tnⁿOAiHwεw help_start Script
CúnΣL⌠≤Φkε help_start ScriptC
7. ½suDB2 ΩTñvAC
² C. DB2 ΩwNΩT 103
v bWindows WA÷@Ul → εx → tzuπ → ACMß½kΣ
÷@U DB2 ΩTñAA∩C
v b Linux WAΘJUCⁿOG
/etc/init.d/db2icdv9 start
≤suDB2 ΩTñvπsH≤sLDDC
ּ:
v DB2 °AtJñyuDB2 ΩTñvw∩z
÷@:
v DB2 °AtJñyuDB2 wvδFwuDB2 ΩTñv(Linux)z
v DB2 °AtJñyuDB2 wvδFwuDB2 ΩTñv
(Windows)z
DB2
DB2 í≤UzA DB2 úUíCúvBⁿC
lºe:
ziHquΩTñv°ⁿ XHTML A⌠
http://publib.boulder.ibm.com/infocenter/db2help/C
dΩíXC\ⁿAHoSw@²Mn
≤íC
DB2 :
Yn°ⁿA÷@UDC
XML Ωxsw
]w DB2 ΩwHxs XML ΩAH XML Ωxsw⌡µ
≥@C
Visual Explain ⁿ
Visual ExplainAHRBMπ SQL »zíioαC
ּ:
v Administration Guide: Implementation ñyVisual Explain overviewz
DB2 °ΩT
UíU°M DPΩTi≤Uz DB2 úC
DB2 σ≤
p°ΩTA\ DB2 Troubleshooting Guide uDB2 ΩTñv
uΣ°vqCiHbBΣp≤ DB2 Euπ
íj≈O D÷ΩTB@ú DMΦAHM
DB2 úiαoº DΣL÷C
104 DB2 Connect °AtJ
DB2 Technical Support ⌠
pGzDJ DBn≤UMΣiα]MMΦA\ DB2 Technical
Support ⌠C Technical Support ⌠is DB2 yB TechNotesB
uvíR°i (APAR í)vBM≤ΣLΩCzi
HbwñiµjMAz DMΣiαMΦC
Yns DB2 Technical Support ⌠AyX
http://www.ibm.com/software/data/db2/udb/support.html
ּ:
v Troubleshooting Guide ñyIntroduction to problem determinationz
v 97 yDB2 NΩTº[z
°
Uz°ANPz∩oXv¡C
HG zisÑuXvHDAO IBM @
vΣLvk IBM º÷σrCg IBM PNAzúoGBi
∩@ÑuXvΣ⌠≤í≈C
G ziHsBGiÑuXv°íAO IBM
@vΣLvk IBM º÷σrCg IBM PNAzúo∩@
ÑuXvA]úo≤°sBGiÑuXvΣ⌠≤í≈C
únñTº\iANuXv⌠≤]t≤ΣñºΩTB
ΩBnΘΣL z]úvAoΣL⌠≤q\º\iBnΘvv
QC
∩≤uXvºpM IBM vqA IBM wΣϕWzⁿ
uXvA IBM oHMPBº\iC
úDzϕuAº@kWA]AⁿΩXfkWAhzúoUⁿBX
fAΘXÑΩTC
IBM ∩≤ÑXºeú⌠≤OCXΣu¼vúAúa⌠≤
qºßOAΣñ]A (²ú¡≤) AΓBDIvAXSwºqßOd⌠C
² C. DB2 ΩwNΩT 105
106 DB2 Connect °AtJ
² D. N
bΣLΩañAIBM iαúúñúUúBA\αCnDzb
OioúPAAVϕa IBM ANϕdCbú IBM
úBíAAúϕtuα IBM úBíACunI
IBM z]úvA⌠≤\αϕúBíAúiHN IBM úBí
ACúLAΣLD IBM úBíAbB@WPτAΣd⌠≤
C
boσ≤ñiα]t IBM ºMQMQCú
ezMQº⌠≤vCziHΦídvAτHG
IBM Director of LicensingIBM CorporationNorth Castle DriveArmonk, NY 10504-1785U.S.A.
Ynd÷G (DBCS) ΩTvyApzΩaa IBM z]
úíAΦíHG
IBM World Trade Asia CorporationLicensing2-31 Roppongi 3-chome, Minato-kuTokyo 106, Japan
UCq¿YPΩaºk°ΦAY°úAG IBM H¼úA
úú⌠≤qºO (]A²ú¡≤iΓXSwO)CY
abYµ÷Wú\úWzOAhúLC
ñiαNWLΩWC]AIBM wqFNqß
eJsñCPAIBM oH∩i () ñúú () íC
∩≤D IBM ⌠uOFΦKúAú∩o⌠@⌠≤iC
⌠WeD IBM úe@í≈Aß⌠µß IC
ϕzúΩT IBM AzYv IBM HΣAϕΦíeΩTA
ú∩zt⌠≤d⌠C
íº≥vYµo÷ΩAHKUCΩTió IBMCΣUCΩT
ⁿOG (1) W íPΣLí (]Aí) ºíµ½ΩTΦí (2) ¼
wµ½ºΩTΦkCY⌠≤ DpG
IBM Canada LimitedOffice of the Lab Director8200 Warden AvenueMarkham, OntarioL6G 1C7CANADA
WzΩoΣSϕn≤AbYípUIOΦoC
© Copyright IBM Corp. 1993, 2006 107
yz⌠≤íΣiv@O IBM úAⁿuIBM ß
XvBuIBM ΩívXvΦºí⌠≤PÑX°ºWdC
ítº⌠≤αΩAOoε⌠ºUF]úP@⌠ºUo
GAiαjtºCí≈qiαOboñtW⌡µA]úOi
Hq@δt≥PPGCí≈qAOQíko⌠pA
ΣΩGiαúPCΣS⌠AτXAΩ
C
úºD IBM úΩTAYúAΣXnΣLD
oCIBM LoúA]LkToD IBM ú⌡µαBeB
⌠≤∩úΣLDiOLCpGz∩D IBM úα⌠≤ A
wVúdC
÷ IBM V⌠≤»zANϕ IBM wAiα≤²ní
pUMC
ñtΘíΩ°idCFúπíAod]
AHBqBtPMúWCoWΩcAYP⌠≤qWMϕ
pPAXC
@vvG
]tlyÑdíAHíU@¡xWí]pNCzi
H≥≤πoBBPΓGX@¡x (≤⌡µgdí) ºí
]píÑAH⌠≤ísB∩GodíALI
O IBMC²odgLπC]AIBM úOtoí
¡wBAαO\αC
odíO⌠≤l@C@≈⌠≤í≈AúπUC@v
nG
© (your company name) (year). Portions of this code are derived from IBM Corp. Sample
Programs. © Copyright IBM Corp. _enter the year or years_. All rights reserved.
DB2 9 σ≤wºσ≤ñOqBúAWiαO International
Business Machines Corporation ΣLqAxCIBM Corporation bⁿΩ
() ΣLΩaΩT≤ http://www.ibm.com/legal/copytrade.shtmlC
UCNyOΣLqUAB wQ≤ DB2 σ≤wΣñ@≈
σ≤ñG
MicrosoftB WindowsB Windows NT® Windows O Microsoft Corporation b
ⁿΩ () ΣLΩaC
IntelBItanium®BPentium Xeon O Intel Corporation bⁿΩ () ΣLΩaC
Java Java ¼O Sun Microsystems, Inc. bⁿΩ () ΣLΩaC
UNIX O The Open Group bⁿΩΣLΩaUC
108 DB2 Connect °AtJ
Linux O Linus Torvalds bⁿΩ () ΣLΩaC
ΣLqBúAWiαOΣLqAxC
² D. N 109
110 DB2 Connect °AtJ
HñσrAσrAS
ϕ ºCC
efyÑ 94
≤
UNIX 93
Windows 93
Oí SQL
DB2 AD Client Σ 15
í
s 75
ΓsWΩw
tmUí (CA) 90
σ≤ 97, 98
° 105
e¡fD≈Ωw°A
tm TCP/IP 69
X
q 100
≤su VSE VM
q DB2 Connect DB2 63
²⌡
XR
b Windows 2000 H Windows
.NET W 33
efrX
Σ 94
α½
º¼p 96
s
Ω
Net.Data JDBC 10
zL DB2 Connect 5
w
s 49
w
DB2 Connect °Aú 23
DB2 Ωwbß (Windows) 26
S/390 W DB2 for Linux 46
eCf°A
qT 13
≤s
ΩTñ 102
DB2 ΩTñ 102
ttm
H DB2 Connect 5
eKfbß
w (Windows) 26
Ω (Windows) 26
DB2 z°A (Windows) 26
s
w 49
DB2ADMNS 49
DB2USERS 49
Ish (CLI)
DB2 AD Client Σ 15
N 107
½≤sMO
DB2 AD Client Σ 15
ems
DB2 AD Client Σ 15
eEfⁿO
db2licm 53
db2osconf 36
db2secv82 49
ⁿOñ
º[ 13
ⁿOµBz (CLP)
DB2 AD Client Σ 15
q DB2 y 100
eQfM≤
M 51
∩
í (HP-UX) 36
í (Linux) 37
í (Solaris @⌠) 38
tm
∩ (HP-UX) 36
tm (≥)
∩ (Linux) 37
∩ (Solaris @⌠) 38
HP-UX 36
í
∩ (HP-UX) 36
∩ (Linux) 37
∩ (Solaris @⌠) 38
db2osconf (HP-UX) 36
HP-UX 36
OΘD
UNIX 25
Windows 25
tm
su\α
utmUív 67
DB2 Connect °Aú 23
TCP/IP 69
tmUí
\α 89
tmUí (CA)
tm
s iSeries Ωw°A 67
suD≈Ωw°A 67
Ωwsu, @δ 90
Ωwsu 91
eQ@f DP
ⁿ 104
uWΩT 104
ΩayÑΣ (NLS)
α½rΩ 96
MrX
Σ 96
εñ
º[ 13
\α
tmΩwsu 89
v
n² 52
vñ
]w DB2 vh 54
n²v
DB2 vX 52
ⁿ
° DP 104
Visual Explain 104
© Copyright IBM Corp. 1993, 2006 111
°
X 105
ú] 3
ú
DB2
UNIX 86
DB2 Ωw
Windows 85
α
DB2 Connect 19
]w
LANG ⌠ 93
qT
εñ 13
qT≤w
DRDA D≈stm 57
s
í 75
su
tmUí 12
zLqT°A DRDA D≈ 57
º[ 12
eQGf
Ωwsu 91
oñ
DB2 AD Client Σ 15
oí
Net.Data JDBC 10
eQTfsW
Ωw
Γ 90
ⁿ
CD-ROM
AIX 81
HP-UX 82
Linux 82
Solaris @⌠ 83
úw
DB2 Ωw
Windows 85
Ω
α½
r 96
Ωw
tm 91
Ωwsu
tm
utmUí (CA)v 90
uv 89
Ωwsu (≥)
91
Ωwzuπ
εñ 13
º[ 13
ΩTñ
HúPyÑ° 101
≤s 102
101
w]yÑ]w
Windows 93
eQf°
ⁿ 104
uWΩT 104
D
UNIX 25
Windows 25
z°A 13
yÑ
VΣ 96
yÑ⌠
Σ 94
yÑOr
uDB2 wvδF 95
í
≤ SQL »zí 101
π 101
eQ¡fA≤ DB2 SDK h 35
eQCfí
ODBC 75
ío
ODBC 73
zL Net.Data JDBC 10, 73
p IBM 113
eQKfV CCSID Σ
yÑΣ 96
eGQTf≤
Windows w]yÑ]w 93
AActiveX Ω½≤
DB2 AD Client Σ 15
AIX
w
DB2 Connect °Aú 42
DB2 Connect °AúD
29
ⁿ CD-ROM 81
CCCSID (sXrOr)
VyÑ 96
CD-ROM
ⁿ
AIX 81
HP-UX 82
Linux 82
Solaris @⌠ 83
DDB2
yÑ 94
rX 94
w
MM≤ 51
ú
UNIX 86
yÑ⌠ 94
DB2 Connect
D≈Σ 3
su DB2 for VSE & VM 63
qe@α 19
º[ 5
iSeries Σ 3
zSeries Σ 3
DB2 Connect Personal Edition
úí 3
DB2 Connect °Aú
w
AIX 42
HP-UX 43
Linux 45
Solaris @t 47
Windows 41
wtm 23
wD
AIX 29
HP-UX 30
Linux 30
Solaris @t 31
Windows 25
úí 3
112 DB2 Connect °AtJ
DB2 Connect D≈Σ 3
DB2 Universal Database for OS/390 and
z/OS
≤stϕµ 60
DB2 ß
sΩw 10
º[ 10, 12
uDB2 wvδF
yÑOr 95
DB2 vh
]w
db2licm ⁿO 53
uvñv 54
DB2 vX
n² 52
uvñv 52
DB2 Ωw
Σ¡x 13
≤ zSeries Linux
w 46
bß (Windows) 26
εñ 13
ú 85
úw 85
DB2 Snapshot ° 10
DB2 α° 13
Visual Explain 13
DB2 ΩTñ
HúPyÑ° 101
≤s 102
101
DB2 z°A (DAS)
º[ 13
DB2ADMNS
s 49
db2licm ⁿO
]w DB2 vh 53
n²v 52
db2osconf ⁿO 36
DB2USERS
s 49
HHP-UX
w
DB2 Connect °Aú 43
wD
DB2 Connect °Aú 30
∩
í 36
tm 36
ⁿ CD 82
IiSeries
tm DB2 Connect 61
tm≤ DB2 Connect DB2 61
DSPNETA 61
DSPRDBDIRE 61
WRKLIND 61
iSeries Σ
DB2 Connect 3
iSeries Ωw°A
tm TCP/IP 69
JJava
DB2 AD Client Σ 15
JDBC (Java Ωwsq)
DB2 AD Client Σ 15
LLANG ⌠
]w 93
Linux
w
DB2 Connect °Aú 45
w DB2 Ωw
b zSeries W 46
wD
DB2 Connect °Aú 30
∩
í 37
ⁿ CD-ROM 82
NNet.Data
s DB2 Ω 10
NLS (ΩayÑΣ)
α½rΩ 96
OODBC (±íΩwsq)
wí 75
OS/390
tm DB2 Ωwt 60
SSoftware Development Kit for Java
A≤ DB2 Ωwh 35
Solaris @t
w
D, DB2 Connect °Aú 31
DB2 Connect °Aú 47
Solaris @⌠
∩
í 38
ⁿ CD-ROM 83
SQL »zí
πí 101
SQL (cdyÑ)
Visual Explain ° 13
SQLJ (Oí SQL for Java)
DB2 AD Client Σ 15
S/390
w DB2 Database for Linux 46
TTCP/IP
Γtm
D≈Ωw°A 69
iSeries Ωw°A 69
tm
D≈su 57
DB2 UDB for OS/390 and z/OS tm
57
UUNIX
ú
DB2 86
≤ DB2 yÑ 93
VVisual Explain
ⁿ 104
º[ 13
VTAM
≤ DB2 Connect OS/390
z/OS 57
WWindows
w
DB2 Connect °Aú 41
wD
DB2 Connect °Aú 25
ú DB2 Ωw 85
XR²⌡
Windows 2000 Windows Server
2003 33
113
Windows (≥)
XR²⌡ (≥)
Windows Server 2003 33
≤w]yÑ]w 93
DB2 bß 26
ZzSeries
w DB2 Database for Linux 46
zSeries Σ
DB2 Connect 3
z/OS
tm DB2 Ωwt 60
114 DB2 Connect °AtJ
ó IBM
YnpzΩaa IBMAd\ IBM Directory of Worldwide ContactsA⌠
http://www.ibm.com/planetwide
YnA≤h DB2 úΩTAyX http://www.ibm.com/software/data/db2/C
© Copyright IBM Corp. 1993, 2006 115
116 DB2 Connect °AtJ
GC40-2081-00