DB2 Connect At.J..public.dhe.ibm.com/ps/products/db2/info/vr9/pdf/letter/... · 2006. 11. 13. ·...

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.

http://www.ibm.com/shop/publications/order

http://www.ibm.com/planetwide

²

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

\






ϕ 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

http://www-912.ibm.com/s_dir/sline003.NSF/GroupPTFs?OpenView&view=GroupPTFs

http://www-912.ibm.com/s_dir/sline003.NSF/GroupPTFs?OpenView&view=GroupPTFs

http://www.ibm.com/software/data/db2/vse-vm/support/dwnldsfs.html

http://www.ibm.com/software/data/db2/vse-vm/support/dwnldsfs.html

http://www.ibm.com/support/docview.wss?rs=71&context=SSEPGG&dc=D600&uid=swg21233566

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


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

http://java.sun.com/products/jdbc/

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


Windows)z


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:


http://www.ibm.com/support/docview.wss?rs=64&context=SSEPEK&q1=jdb881d&uid=swg27006262

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

÷@:


Ω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


2 g α DB2 Connect


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


http://www.ibm.com/software/data/db2/db2connect/sysreqs.html

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


http://publib.boulder.ibm.com/infocenter/db2luw/v8/topic/com.ibm.db2.udb.doc/conn/t0008566.htm

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


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 69 y CLP tmsD≈ iSeries Ωw°Asuz


Windows)z

v DB2 ßtJñyw DB2 ß (UNIX Linux)z


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


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\


Ynw DB2 Connect °Aú (p DB2 Connect Enterprise Edition)AXU

CDG

wΘD

Intel® AMD Bzúα≈⌡µΣ Windows @t (32

64 )



@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:


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


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\



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

÷:


DB2 Connect °AúwD (HP-UX)

psΩTA\


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

÷:


DB2 Connect °AúwD (Linux)

psΩTA\



CwΘBeBnΘqTDG

wΘD

BziG

v x86 (Intel Pentium®BIntel Xeon® AMD Athlon)




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

÷@:


÷:


DB2 Connect °AúwD (Solaris)

psΩTA\



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

http://www.ibm.com/db2/linux/validate


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

÷:



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


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


5. bΣ¡xW (úF Windows x86Bx86 W Linux IPF W Linux º

)G

v Σ 32 í


http://www.ibm.com/developerworks/views/java/downloads.jsp

v úΣ 32 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


∩í (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≤:


:

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ñ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≤:


:

Yn]wíAb /etc/system [JpU@µG


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

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


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


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



÷úσ≤C\uDB2 wvδFwuDB2 ΩTñ (UNIX)C

÷º:



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 btWⁿ DB2 ú CDA\b HP-UX Wⁿ CDCz]iHN CD



(Linux UNIX)C

:

Ynb HP-UX Ww DB2 Connect °AúAp DB2 Connect Enterprise EditionG

1. ΘJUCⁿOA½ⁿ CD ²G

cd /cdrom



uIBM DB2 wívC





¿ßADB2 stC

¿wßANw D B 2 C o n n e c t °AúCw]w⌠O

/opt/IBM/db2/V9.1




÷º:




÷@:

v 82 yⁿ CD-ROM (HP-UX)z



v 51 yMM≤z


UNIX)z


÷:

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 btWⁿ DB2 ú CDA\b Linux Wⁿ CDCz]iHN CD



(Linux UNIX)C

:

Ynb Linux Ww DB2 Connect °AúAp DB2 Connect Enterprise EditionG


cd /cdrom



uIBM DB2 wívC





¿ßADB2 stC

¿wßANw DB2 Connect °AúCw]w⌠ /opt/ibm/db2/V9.1



÷úσ≤C\yuDB2 wvδFwuDB2 ΩTñv(Linux)zC

÷º:



8 w@ 45


÷@:

v 82 yⁿ CD-ROM (Linux)z




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


4. q⌡µ Linux IBM zSeries qúWA½ⁿ CD ²CziHΘJ cd/local_directory_name ⁿO⌡µ@AΣñ local_directory_name Nϕú CD

ⁿIC

÷@:


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 btWⁿ DB2 ú CDA\ⁿ CD-ROM (Solaris Operating

Environment)Cz]iHN CD estA\h CD w (Linux

UNIX)C


(Linux UNIX)C

:

Ynb Solaris @tWw DB2 Connect °AúAp DB2 Connect Enterprise

EditionG


cd /cdrom


2. ΘJ ./db2setup ⁿOAHuDB2 wvδFC

ΦíßAeWuIBM DB2 wívC




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




÷º:




÷@:

v wPtmRΩñyHΓΦíw DB2 úz

v 83 yⁿ CD-ROM (Solaris @⌠)z



v 51 yMM≤z


UNIX)z


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


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


http://www.ibm.com/software/data/db2/udb/support.html


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




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


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





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


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


ϕ 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/

÷@:



Windows)z

11 DB2 Connect qT DB2 for OS/390 and z/OS Ωw 59

http://www.ibm.com/servers/eserver/support/zseries/

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

÷@:






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


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


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


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


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 DB2 ßtJñyß]wfttmUítmΩwsuz

v 91 yutmUívΩwsuz


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

÷@:



Windows)z


÷:

v Command Reference ñyCATALOG DATABASE commandz

v Command Reference ñyCATALOG DCS DATABASE commandz

v Command Reference ñyCATALOG TCPIP/TCPIP4/TCPIP6 NODE commandz


v SQL ReferenceAVolume 2 ñyCONNECT (Type 1) statementz


6 g DB2 Connect


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


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"


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


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


7 g Ω


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ñyDB2 ß°AwD (AIX)z

ⁿ CD-ROM (HP-UX)

UCBJi²zQaⁿ DB2 for HP-UX ú CD-ROMC

²Mn≤:


:

Ynⁿ DB2 for HP-UX ú CD-ROMAG


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


ⁿ CD-ROM (Linux)

²Mn≤:


:

Ynb Linux Wⁿ CD-ROMA⌡µUCBJG


2. N CD-ROM íJ≈AMßΘJUCⁿOG

mount -t iso9660 -o ro /dev/cdrom /cdrom

Σñ /cdrom Nϕ CD-ROM ⁿIC

3. nXC




÷:


ⁿ CD-ROM (Solaris @⌠)

²Mn≤:

pGz NFS qtⁿ≈Ah root svXqúW

CD-ROM tCz]qúW root svⁿtC

:

YnbuSolaris @⌠vWⁿ CD-ROMAG


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



÷@:


÷:

v DB2 °AtJñyDB2 ß°AwD (Solaris @t)z

19 ⁿ DB2 ú CD 83

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


÷:

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


8 g ²PßO


² 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


÷º:


÷@:


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


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 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 89 yutmUívjM⌠⌠tmΩwsuz


² A. utmUívtmΩwsu 91

² 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≤:


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


Σ 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


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


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

÷:



² 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 [email protected] σ≤ñ\¬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


http://www.ibm.com/software/data/sw-library/

÷@:

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



ϕ 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Ω


ASNCLP Program Reference for

Replication and Event Publishing

SC19-1018 O


Configuration Guide for Federated

Data Sources

SC19-1034


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


http://publib.boulder.ibm.com/infocenter/db2help/



- 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



http://publib.boulder.ibm.com/infocenter/db2luw/v9/

http://publib.boulder.ibm.com/infocenter/db2luw/v8/

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


http://www.ibm.com/software/data/db2/udb/support/icupdate.html

: 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


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 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


http://publib.boulder.ibm.com/infocenter/db2help/

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


÷º:

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



² 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


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


http://www.ibm.com/legal/copytrade.shtml

Linux O Linus Torvalds bⁿΩ () ΣLΩaC

ΣLqBúAWiαOΣLqAxC

² D. N 109

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


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


°

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ú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


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


wD


∩

í 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


w DB2 Ωw

b zSeries W 46

wD


∩

í 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


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


wD


ú 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


ó IBM

YnpzΩaa IBMAd\ IBM Directory of Worldwide ContactsA⌠


YnA≤h DB2 úΩTAyX http://www.ibm.com/software/data/db2/C



http://www.ibm.com/software/data/db2/udb/

GC40-2081-00

DB2 Connect At.J..public.dhe.ibm.com/ps/products/db2/info/vr9/pdf/letter/... · 2006. 11. 13. ·...

Documents

Transcript of DB2 Connect At.J..public.dhe.ibm.com/ps/products/db2/info/vr9/pdf/letter/... · 2006. 11. 13. ·...