DB2 Connect Personal Edition t.J..public.dhe.ibm.com/ps/products/db2/info/vr9/pdf/... · ² 1 g DB2...

DB2®

DB2 Connect Personal Edition tJ

DB2 Connect 9

GC40-2246-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 úú . . . . . . . . . . . 3

2 DB2 Connect Ω . . . . . . 5 DB2 Connect Personal Edition sD≈iSeries DB2 Ω . . . . . . . . . . . . . 5utmUívzΩwsu (Linux Windows) . . . . . . . . . . . . . . . 6Ωwío DB2 Client Σ . . . . . 7

3 wtm DB2 ConnectPersonal Edition @δBJ . . . 9

2 g w DB2 Connect . . . . 11

4 wD . . . . . . . . . . 13OΘD . . . . . . . . . . . . 13DB2 Connect Personal Edition (Windows) wD 13w DB2 Connect Personal Edition bß (Windows) . . . . . . . . . . . . . . 14DB2 Connect Personal Edition (Linux) wD . . 15

5 Windows iµ LDAP . . 17XR²⌡ (Windows) . . . . . . . . . . 17

6 w@ . . . . . . . . . . 19w DB2 Connect Personal Edition (Windows) . . . 19w DB2 Connect Personal Edition (Windows) . . 19DB2 Connect Dzw (Windows). . . . 20

w DB2 Connect Personal Edition (Linux) . . . . 21

7 ID z . . . . . . . . . . . 23Nz ID sW DB2ADMNS DB2USERS sñ (Windows) . . . . . . 23

3 g DB2 Connect qT

D≈ iSeries Ωw . . . . . . 25

8 DB2 Connect qT

DB2 for OS/390 and z/OS Ωw . . . 27 DB2 Connect su DB2 UniversalDatabase for OS/390 and z/OS . . . . . . . . 27tm DB2 Universal Database for OS/390 and z/OS TCP/IP . . . . . . . . . . . . . . . 27tm DB2 Universal Database for OS/390 and z/OS 30

9 DB2 Connect qT

DB2 UDB for iSeries Ωw . . . . . 31 DB2 Connect su DB2 UniversalDatabase for iSeries . . . . . . . . . . . . 31

10 DB2 Connect qT

DB2 for VM VSE Ωw . . . . . 33 DB2 Connect su DB2 for VSE &VM . . . . . . . . . . . . . . . . . 33

4 g tmsD≈ iSeries Ωw. . . . . . . . . . . . . . . . 35

11 utmUív . . . . 37 CA tmsD≈ iSeries Ωw°Asu (Linux Windows) . . . . . . . . . . 37

12 CLP . . . . . . . . . 39 CLP tmsD≈ iSeries Ωw°Asu . . . . . . . . . . . . . . . . . 39

5 g DB2 Connect . . . . 41

13 ⌡µzví . . . . 43

14 b DB2 Connect WsΩ

wí . . . . . . . . . . . . . 45

15 i@B\¬ . . . . . . . . . 47

6 g . . . . . . . . . . . 49

16 úw DB2 Connect . . . 51úw DB2 ú (Windows) . . . . . . . . 51úw DB2 ú (Linux UNIX) . . . . . 52

7 g ²PßO . . . . . . . . 53

² A. utmUívtm

Ωwsu . . . . . . . . . . . . . 55utmUívjM⌠⌠tmΩwsu . . 55utmUívΓtmΩwsu . . . . 56utmUívΩwsu . . . . . 57

² B. yÑΣ . . . . . . . . . . 59≤ DB2 yÑ (Windows) . . . . . . . . 59≤ DB2 yÑ (Linux UNIX) . . . . . 59Σ DB2 yÑ . . . . . . . . . . . 60

© Copyright IBM Corp. 1993, 2006 iii

HΣLyÑ⌡µuDB2 wvδFyÑOr 61rΩα½ . . . . . . . . . . . . . 62

² C. DB2 ΩwNΩT . . . . . 63DB2 NΩTº[ . . . . . . . . . . . . 63σ≤Núd . . . . . . . . . . . . . 63

PDF µí DB2 NO . . . . . . . . . 64q DB2 LΩy. . . . . . . . . . . . 66qⁿOµBzπ SQL ¼Aí . . . . . . 67súP DB2 ΩTñ . . . . . . . . 67YnbuDB2 ΩTñvñAHznyÑπDD . . . . . . . . . . . . . . . . . 67

≤sqú°í⌠⌠°AWwuDB2 ΩTñv . . . . . . . . . . . . . . . . 68DB2 . . . . . . . . . . . . . 70DB2 °ΩT . . . . . . . . . . . . 70° . . . . . . . . . . . . . . . . . 71

² D. N . . . . . . . . . . 73 . . . . . . . . . . . . . . . . . 74

. . . . . . . . . . . . . . . . 77

ó IBM . . . . . . . . . . . . . . 81

iv DB2 Connect Personal Edition tJ

1 g DB2 Connect

© Copyright IBM Corp. 1993, 2006 1

2 DB2 Connect Personal Edition tJ

1 ÷≤ DB2 Connect

DB2 Connect™ úq Linux®BUNIX® Windows® ¼¡xsj¼qúPñ¼Ω

wαOCziHs OS/390® z/OS®BiSeries™BVSE VM W DB2® Ω

wCziHsP Distributed Relational Database Architecture™ (DRDA®) e

D 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 DB2 Connect °AtJñyw DB2 Connect °Aú (AIX)z

v DB2 Connect °AtJñyw DB2 Connect °Aú (HP-UX)z

v DB2 Connect °AtJñyw DB2 Connect °Aú (Linux)z

v DB2 Connect °AtJñyw DB2 Connect °Aú (Solaris)z

v DB2 Connect °AtJñyw DB2 Connect °Aú (Windows)z

v 21 yw DB2 Connect Personal Edition (Linux)z

v 19 yw DB2 Connect Personal Edition (Windows)z


http://www.ibm.com/support/docview.wss?rs=73&uid=swg21219983

2 DB2 Connect Ω

DB2 Connect Personal Edition sD≈ iSeries DB2 Ω

úgñí°AiµsuAOϕΦKBntmC∩≤Σ TCP/IP s

uD≈ iSeries Ωw°AíAΣpCboípñAC@ DB2 Connect

u@úsD≈ iSeries Ωw°AsuC

Yniµ TCP/IP suAD≈ iSeries ΩwΣ TCP/IPCUCΣ

TCP/IP suG

v DB2 UDB for OS/390 and z/OS 7.1 ≤s

v DB2 UDB for iSeries 5.1 ≤sAH

v DB2 Server for VSE & VM 7 ≤s

Yns IBM® D≈ iSeries Ωw°AAzn@wv DB2 Connect ú

Czúα DB2 ßs IBM D≈ iSeries Data ServerC

6 1 πww DB2 Connect Personal Edition u@sD≈

iSeries Ωw°AC


÷º:

v DB2 Connect ΓUñysD≈Ωwz

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

z (CLP) zsuC

F CA ºßAziHG

1. DB2 Connect D≈ iSeries Ωw°Aºísu


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 56 yutmUívΓtmΩwsuz

v DB2 ßtJñyß]wfttmUítmΩwsuz

v 45 14 , yb DB2 Connect WsΩw íz

v 37 y CA tmsD≈ iSeries Ωw°Asu (Linux

Windows)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ííXdA oí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¡xA h

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 í

2 DB2 Connect Ω 7

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πA N DB2 Universal Database™

(DB2 UDB) for Linux, UNIX, and Windows 8 uoñvC Developer

Workbench OεXo⌠AiBsΦBúBíp DB2 xs

MwqτC z]iH Developer Workbench o SQLJ

íAHBsΦ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


3 wtm DB2 Connect Personal Edition @δBJ

w DB2 Connect Personal Edition ]thBJCDDNQwtm DB2

Connect Personal Edition @δBJC

1. Mwznp≤bz⌠⌠ñ DB2 ConnectC

2. τzu@D≈ iSeries Ωw°AOwπTwΘnΘ≥

DC

3. τzD≈ iSeries Ωw°AOwtmⁿ DB2 Connect suC

4. w DB2 Connect nΘCzNu@tmτzD≈ iSeries s

uC

: pGzqúww DB2 ßAziHbqúWn² DB2 Connect Personal

Edition vA DB2 Connect Personal EditionC

5. wºßA DB2 Connect PzD≈ iSeries ΩwtºísuC

DB2 Connect zMΣtm TCP/IP suCziHutmUí

(CA)vMΣD≈ iSeries ΩwC

6. N DB2 Connect úí íszD≈ iSeries ΩwC

7. D≈ iSeries suC

8. zbwn DB2 Connect PíC≤íou@

w DB2 ßC

9. pGznu@z DB2 UDB for OS/390 z/OS DB2 Database for

Linux, UNIX, and Windows °AAw DB2 ßC

÷@:


v 39 y CLP tmsD≈ iSeries Ωw°Asuz


Windows)z



v 27 y DB2 Connect su DB2 Universal Database for OS/390

and z/OSz

v 57 yutmUívΩwsuz

v wPtmRΩñyuvñvn² DB2 ú\αvXz

÷:

v 15 yDB2 Connect Personal Edition (Linux) wDz

v 13 yDB2 Connect Personal Edition (Windows) wDz


2 g w DB2 Connect


4 wD

OΘD

≥D:

úí°z∩w¼zt¼wC uDB2 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 Ωwtn 256 MB RAMC∩≤⌡µ DB2 DB2 GUI uπ

tAn 512 MB RAMCMAFπWiαA 1 GB

RAMCoDú]AtW⌡µºΣLnΘ⌠≤B OΘ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

DB2 Connect Personal Edition (Windows) wD

psΩTA\

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

Ynw DB2 Connect Personal EditionAhXUC@tBnΘqTDG

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


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

– 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 ßqe SQL nDC

÷@:


÷:

v DB2 °AtJñyDB2 ú IBM Software Development Kit for Java h

z

w DB2 Connect Personal Edition bß (Windows)

pGOb Windows Ww DB2 Connect Personal Edition úAhnw

bßC

wbßO⌡µwºbßCb⌡µuDB2 wvδFºeA²w

qwbßCziHbwºewq]wbßA]iH²uDB2 wvδ

FzbßC

bßWϕutRWWh DB2 RWWhC

n⌠bß⌡µwC@δÑAbn⌡µwqú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τ IDAhw ID ≤nbßº⌠

W Domain Administrators sC

z]iHutvbßú⌡µwC

DB2 wíPvQ:

DB2 wíPuúívvQCDB2 wíPUCvQG

v @@t@í≈

v O½≤

v ΩwOΘ

v HAΦínJ


v W[tB

v ≤½hO

Windows Ww:

DB2 úú Windows wCziH ID w DB2 Connect

Personal EditionA²OúD ID ≤ DB2ADMNS DB2USERS sAh

ID Lk⌡µ⌠≤ DB2 ⁿOC

DB2 wíioΓssCziHbqwíⁿwsWⁿw]W

C

Ynw\αAbw DB2 íA∩ DB2 ½≤@twe

W@tw∩CⁿuDB2 zsvµuDB2 sv

µw]Cw]sW DB2ADMNS DB2USERSCpGPssW

≡AtNúz≤sWCpnAz]iHµⁿwC

÷º:

v 9 3 , ywtm DB2 Connect Personal Edition @δBJz

v Administration Guide: Implementation ñyUser, user ID and group naming rulesz

÷@:

v DB2 °AtJñybw DB2 úºe]w Windows ¬Mv

(Windows)z

DB2 Connect Personal Edition (Linux) wD

psΩTA\

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

Ynw DB2 Connect Personal EditionAhXUC@tBnΘqTDG

wΘD

BzOUCΣñº@G

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

v x86-64 (Intel EM64T AMD64)

v POWER™ (⌠≤Σ Linux iSeries pSeries®)

v eServer™zSeries

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 ns²duWíC

4 wD 15

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

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

v pGnuDB2 wvδFw DB2 ConnectAQn⌠≤ DB2

uπAhnα≈eí X Window System nΘC

qTD

pn TCP/IP sAhúnΣLnΘC

÷@:


v DB2 °AtJñyⁿ CD-ROM (Linux)z

÷:

v DB2 °AtJñyDB2 ú IBM Software Development Kit for Java h

z


5 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 ≈NC

ϕ 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


6 w@

w DB2 Connect Personal Edition (Windows)

w DB2 Connect Personal Edition (Windows)

@íp≤b Windows @tWw DB2 Connect Personal EditionC

²Mn≤:

uDB2 wvδFºeG

v TwztXUCDG

– nwΘD

– OΘD

v pGnb Windows WwBQn Lightweight Directory Access Protocol (LDAP)A

hXR²⌡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

v pGnDuzvbßw DB2 ConnectA\DD DB2 Connect D

zw (Windows)C

:

Ynw DB2 Connect Personal EditionAG

1. Hπzv¡¡nJtC

2. ÷¼íA²wíαbn≤sC

3. pGzqúww DB2 ßAziHbqúWn² DB2 Connect Personal

Edition vA DB2 Connect Personal EditionCYn⌡µwíw DB2

Connect Personal EditionAϕΣlBJC

4. N CD íJ≈ñC⌡µ\αuDB2 wvδFC uDB2 wv

δFNMwtyÑAMßyÑwíCpGnHúPyÑ⌡µw

íAwíLkAhiHΓ⌡µuDB2 wvδFC

5. eWuDB2 ívCziHb°íñ°w²Mn≤N

A≥w@C

6. @lw@AϕwíúiµwCuWíⁿz⌡µΣ

lBJC÷@UíIsuWíCziHH÷@U°÷sA⌠w@

C


Θxxs@δΩTAHwúwíy¿TºCΘxWϕ

DB2-<úYg>-<Θí>.log µíAp DB2-CPE-10-06-2006_17_23_42.logC

w]AΘx≤ My Documents\DB2LOG ²ñC

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 Ωwt DB2

÷úσ≤C

÷º:

v 20 yDB2 Connect Dzw (Windows)z


v DB2 °AtJñyDB2 wΦkz

v DB2 °AtJñyuDB2 ΩTñvw∩z

÷@:

v DB2 °AtJñyuDB2 wvδFwuDB2 ΩTñv

(Windows)z

÷:

v Command Reference ñysetup - Install DB2 commandz

v 13 yDB2 Connect Personal Edition (Windows) wDz

v 13 yOΘDz

DB2 Connect Dzw (Windows)

YDuzvwAhnJbß≤ Power Users sC

Ybn²ñX DB2 Connect ÷ΩTAbn²

HKEY_CURRENT_USER Ω¿ñΘJC÷M\h DB2 Connect Dzw

xsbn² HKEY_LOCAL_MACHINE Ω¿ñA²O⌠]wb

HKEY_CURRENT_USER ñ≤C

t≤iiµDzwC A]bw⌠≤ DB2

Connect úúnAA²OSzv¡ANLkAAHbiµD

zwAAHΦíaC

UCObzwDzwúsb⌠ñziαJw¼pG


v YDuzvwF DB2 ConnectAMßuzvbPtWw

DB2 ConnectCuzvNoúwwTºCuzvv¡úw

½swúAMoDC

v YDuzvwF DB2 ConnectAMßGDuzvbPt

Ww DB2 ConnectCbΩdñAwNóATºAⁿX

OuzvAαwúC

v uzvwwF DB2 ConnectAMßDuzvbPtWw DB2

ConnectCbΩdñAwNóATºAⁿXO

uzvAαwúCuzvúwP½swv¡C

÷@:

v DB2 Connect °AtJñyw DB2 Connect °Aú (Windows)z


w DB2 Connect Personal Edition (Linux)

zuDB2 wvδFAb Linux Ww DB2 Connect Personal EditionCuDB2

wvδFO@ Java ¼wuπAiHN DB2 úwPtmCpGz

úQδFAhi db2_install Script Γw DB2 úC

²Mn≤:

lwºeG

v TwztXUCDG

– wΘBenΘD

– OΘD

v zn root v¡⌡µwC

v btWⁿ DB2 ú CDC

:

Ynb Linux Ww DB2 Connect Personal EditionG

1. Hπ root v¡¡nJtC

2. pGzqúww DB2 ßAziHbqúWn² DB2 Connect Personal

Edition vA DB2 Connect Personal EditionCYn⌡µwíw DB2

Connect Personal EditionAϕΣlBJC

3. ΘJUCⁿOA½ⁿ CD ²G

cd /mnt/cdrom

Σñ /mnt/cdrom Nϕ CD ⁿIC

4. ΘJ ./db2setup ⁿOAHuDB2 wvδFCz⌡µ X Windows

íwíCΦíß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

6 w@ 21

w¿ DB2 Connect Personal Edition wCw]w⌠O /opt/ibm/db2/V9.1C

pGn²z DB2 úiHsqúzL⌠⌠st@xqúW DB2 σ≤A

hwuDB2 ΩTñvCuDB2 ΩTñvtA≤ DB2 Ωwt DB2

÷úσ≤C

÷º:


v DB2 °AtJñyDB2 wΦkz


÷@:

v DB2 °AtJñyuDB2 wvδFwuDB2 ΩTñv(Linux)z

v DB2 °AtJñyⁿ CD-ROM (Linux)z

÷:

v Administration Guide: Planning ñyAvailability of Asian fonts (Linux)z

v 15 yDB2 Connect Personal Edition (Linux) wDz

v 13 yOΘDz


7 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 DB2 °AtJñyw DB2 °Aúbß (Windows)z

v Command Reference ñydb2extsec - Set permissions for DB2 objects commandz


3 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





8 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 27 ytm DB2 Universal Database for OS/390 and z/OS TCP/IPz

v 30 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≡AXú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

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

ϕ 2. 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

ϕ 3. 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


ϕ 4. 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

8 DB2 Connect qT DB2 for OS/390 and z/OS Ωw 29

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

v 27 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°AsuCpdA

\ 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

÷@:





http://www.ibm.com/servers/eserver/zseries/zos/servicetst/

9 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')C DB2 UDB for iSeries

@ww]CpGΘJQirúΦKAhOWO QCNTEDDMC

5. ÷píΩwWCziHΘJ DSPRDBDIREAYiooΩTCπ@

MµCbumvµñAt *LOCAL rµOOwqß

RDBNAMEC pGS *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

ϕ 5. 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 33 y DB2 Connect su DB2 for VSE & VMz


10 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


4 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


11 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 x86B Windows x64 (AMD64/EM64T)B x86 LinuxAH

AMD64/EM64T Linux ΣuDB2 zuπvCb¡xWAzúiH

DB2 ⁿOµBz (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 57 yutmUívΩwsuz


12 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


5 g DB2 Connect


13 ⌡µ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 7 yΩwío DB2 Client Σz


14 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


15 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


6 g


16 ú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≤ΩwAhΩúNúú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°íAú 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 CjεRúúFΩp DB2 Ωw

H íeC

÷@:

v 52 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 51 yúw DB2 ú (Windows)z

÷:

v Command Reference ñyDROP DATABASE commandz


7 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 57 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 Ωwsu¼C

v nzL DB2 Connect hDsuA∩ghDs°AΩsC

v YnsuA∩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≤tmz ICziH∩aΘJC÷U@BC

12. bⁿww∩°íñAⁿwnOw∩C

13. ÷@U¿CzbαΩwC∩⌠\αϕ@H÷¼ CAC

÷º:


÷@:

v 57 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 55 yutmUívjM⌠⌠tmΩwsuz


² A. utmUívtmΩwsu 57

² 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 67 yYnbuDB2 ΩTñvñAHznyÑπDDz

÷:

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

:

YndtWi yÑ⌠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 67 yYnbuDB2 ΩTñvñAHznyÑπDDz

÷:

v 60 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ΦσσBJσ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 59 y≤ DB2 yÑ (Linux UNIX)z

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

ϕ 6. 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ÑΣ 61

÷:

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≤RAzDCpGn∩S

wDDíúNúA[WDDD URLC

oqll≤puDB2 ßΣñvCpGσ≤M DB2

NDAsϕ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 68 y≤sqú°í⌠⌠°AWwuDB2 ΩTñvz

÷:

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

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



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

ϕ 8. 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

ϕ 9. WebSphere Information Integration NΩT

W LΩ

WebSphere Information Integration:

Administration Guide for Federated

Systems

SC19-1020 O

² C. DB2 ΩwNΩT 65

ϕ 9. 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 63 yDB2 NΩTº[z

v Nñy÷≤Nz

÷@:

v 66 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ϕzQnqyDC

÷º:

v 63 yDB2 NΩTº[z

÷:

v 64 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 68 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 63 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(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°MDPΩTi≤Uz DB2 úC

DB2 σ≤

p°ΩTA\ DB2 Troubleshooting Guide uDB2 ΩTñv

uΣ°vqCiHbBΣp≤ DB2 Euπ

íj≈OD÷ΩTB@úDMΦAHM

DB2 úiαoºDΣL÷C


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

DB2 Technical Support ⌠

pGzDJDBn≤UMΣiα]MMΦA\ DB2 Technical

Support ⌠C Technical Support ⌠is DB2 yB TechNotesB

uvíR°i (APAR í)vBM≤ΣLΩCzi

HbwñiµjMAzDMΣ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 63 yDB2 NΩTº[z

°

Uz°ANPz∩oXv¡C

HG zisÑuXvHDA O IBM @

vΣLvk IBM º÷σrCg IBM PNAzúoGBi

∩@ÑuXvΣ⌠≤í≈C

G ziHsBGiÑuXv°íA O IBM

@vΣLvk IBM º÷σrCg IBM PNAzúo∩@

ÑuXvA]úo≤° sBGiÑuXvΣ⌠≤í≈C

únñTº\i ANuXv⌠≤]t≤ΣñºΩTB

ΩBnΘΣLz]ú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


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

² 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ΣL D

oCIBM LoúA]LkToD IBM ú⌡µαBeB

⌠≤∩úΣLDiOLCpGz∩D IBM úα⌠≤A

wVúdC

÷ IBM V⌠≤»zANϕ IBM wAiα≤²ní

pUMC

ñtΘíΩ°idCFúπíAod]

AHB qBtPMú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ºσ≤ñO qBúAWiαO International

Business Machines Corporation ΣL qAxCIBM Corporation bⁿΩ

() ΣLΩaΩT≤ http://www.ibm.com/legal/copytrade.shtmlC

UCNyOΣL qUABwQ≤ 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

ΣL qBúAWiαOΣL qAxC

² D. N 75

HñσrAσrAS

ϕºCC

efyÑ 60

≤

UNIX 59

Windows 59

Oí SQL

DB2 AD Client Σ 7

í

s 45

eD

Linux

32 15

64 15

ΓsWΩw

tmUí (CA) 56

σ≤ 63, 64

° 71

e¡fD≈Ωw°A

tm TCP/IP 39

X

q 66

≤su VSE VM

q DB2 Connect DB2 33

²⌡

XR

b Windows 2000 H Windows

.NET W 17

efrX

Σ 60

α½

º¼p 62

w

s 23

w

bß (Windows) 14

DB2 Connect Personal Edition 9

eCf≤s

ΩTñ 68

DB2 ΩTñ 68

eKfbß

w (Windows) 14

s

w 23

DB2ADMNS 23

DB2USERS 23

Ish (CLI)

DB2 AD Client Σ 7

N 73

½≤sMO

DB2 AD Client Σ 7

ems

DB2 AD Client Σ 7

eEfⁿO

db2secv82 23

ⁿOµBz (CLP)

DB2 AD Client Σ 7

q DB2 y 66

eQfOΘD

UNIX 13

Windows 13

tm

s

utmUív 37


TCP/IP 39

tmUí

\α 55

tmUí (CA)

tm

s iSeries Ωw°A 37

suD≈Ωw°A 37

Ωwsu, @δ 56

Ωwsu 57

eQ@fDP

ⁿ 70

uWΩT 70

ΩayÑΣ (NLS)

α½rΩ 62

MrX

Σ 62

\α

tmΩwsu 55

ⁿ

°DP 70

Visual Explain 70

°

X 71

ú] 3

ú

DB2

UNIX 52

DB2 Ωw

Windows 51

]w

LANG ⌠ 59

qT≤w

DRDA D≈stm 27

s

í 45

su

suD≈ iSeries Ωw 5

tmUí 6

zLqT°A DRDA D≈ 27

º[ 6

eQGf

Ωwsu 57

oñ

DB2 AD Client Σ 7

eQTfsW

Ωw

Γ 56

úw

DB2 Ωw

Windows 51


Ω

α½

r 62

Ωw

tm 57

Ωwsu

tm

utmUí (CA)v 56

uv 55

57

ΩTñ

HúPyÑ° 67

≤s 68

67

w]yÑ]w

Windows 59

eQf°

ⁿ 70

uWΩT 70

D

UNIX 13

Windows 13

yÑ

VΣ 62

yÑ⌠

Σ 60

yÑOr

uDB2 wvδF 61

í

≤ SQL »zí 67

π 67

eQCfí

ODBC 45

ío

ODBC 43

zL Net.Data JDBC 43

p IBM 79

eQKfV CCSID Σ

yÑΣ 62

eGQTf≤

Windows w]yÑ]w 59

AActiveX Ω½≤

DB2 AD Client Σ 7

CCCSID (sXrOr)

VyÑ 62

DDB2

yÑ 60

rX 60

ú

UNIX 52

yÑ⌠ 60

DB2 Connect

bß (Windows) 14

D Administrator w 20

su DB2 for VSE & VM 33

DB2 Connect Personal Edition

w

º[ 9

Linus 21

Windows 19

wD

Windows 13

tm 9

úí 3

DB2 Connect °Aú

úí 3

DB2 Universal Database for OS/390 and

z/OS

≤stϕµ 30

DB2 ß

º[ 6

uDB2 wvδF

yÑOr 61

DB2 Ωw

ú 51

úw 51

DB2 ΩTñ

HúPyÑ° 67

≤s 68

67

DB2ADMNS

s 23

DB2USERS

s 23

IiSeries

tm DB2 Connect 31

tm≤ DB2 Connect DB2 31

DSPNETA 31

DSPRDBDIRE 31

WRKLIND 31

iSeries Ωw°A

tm TCP/IP 39

JJava

DB2 AD Client Σ 7

JDBC (Java Ωwsq)

DB2 AD Client Σ 7

LLANG ⌠

]w 59

Linux

w


NNLS (ΩayÑΣ)

α½rΩ 62

OODBC (±íΩwsq)

wí 45

OS/390

tm DB2 Ωwt 30

SSQL »zí

πí 67

SQLJ (Oí SQL for Java)

DB2 AD Client Σ 7

TTCP/IP

Γtm

D≈Ωw°A 39

iSeries Ωw°A 39

tm

D≈su 5, 27


TCP/IP (≥)

DB2 UDB for OS/390 and z/OS tm

27

UUNIX

ú

DB2 52

≤ DB2 yÑ 59

VVisual Explain

ⁿ 70

VTAM

≤ DB2 Connect OS/390

z/OS 27

WWindows

w


DB2 Connect, D Administrator 20

wD


ú DB2 Ωw 51

XR²⌡

Windows 2000 Windows Server

2003 17

Windows Server 2003 17

≤w]yÑ]w 59

DB2 bß 14

Zz/OS

tm DB2 Ωwt 30

79

ó 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-2246-00

DB2 Connect Personal Edition t.J..public.dhe.ibm.com/ps/products/db2/info/vr9/pdf/... · ² 1 g DB2...

Documents

Transcript of DB2 Connect Personal Edition t.J..public.dhe.ibm.com/ps/products/db2/info/vr9/pdf/... · ² 1 g DB2...