IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2...

75
IBM DB2 Connect 9.7 wtm DB2 Connect Personal Edition 2012 7 δs 9 7 SC40-2456-03

Transcript of IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2...

Page 1: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

IBM DB2 Connect 9.7

w��tm DB2 Connect Personal Edition2012 � 7 δ≤s

�� 9 �� 7

SC40-2456-03

���

Page 2: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and
Page 3: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

IBM DB2 Connect 9.7

w��tm DB2 Connect Personal Edition2012 � 7 δ≤s

�� 9 �� 7

SC40-2456-03

���

Page 4: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

��

���ΩT�ΣΣ��ú�ºeA�\¬ � 59���² B, y�N��z U�@δΩTC

���N��

�σ≤]t IBM ���vΩTCªO���vX��ú�A�Bⁿ�@vkO@C�X��]t�ΩTú]A⌠≤ú

�OTA�B�ΓUú��⌠≤n�ú���pO���C

ziHbuW�zLϕa� IBM ��NϕAq� IBM X��C

v YnuWq�X��A�⌡�uIBM X��ñ�vA⌠}� www.ibm.com/shop/publications/order

v YnMΣzϕa� IBM ��NϕA�⌡� IBM Directory of Worldwide ContactsA⌠}� www.ibm.com/planetwide

bⁿΩ�[�jAYnq DB2 Marketing and Sales q� DB2 X��A��� 1-800-IBM-4YOU (426-4968)C

ϕz�eΩT� IBM �AzY�v� IBM HΣ{�Aϕ�Φí����teΩTA�ú�∩zt�⌠≤d⌠C

© Copyright IBM Corporation 1993, 2012.

Page 5: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

�²

� 1 � ÷≤�� . . . . . . . . . . . 1

� 2 � DB2 Connect �� . . . . . . 3÷≤ DB2 Connect . . . . . . . . . . . . 3

DB2 Connect ú����� . . . . . . . . 3@δ DB2 Connect Ω�d . . . . . . . . . 3�� DB2 Connect Personal Edition s� System zD≈� IBM i DB2 Ω� . . . . . . . . . 3��tm�U{í�zΩ�wsu (Linux �Windows) . . . . . . . . . . . . . . 5Ω�w��{í}o� IBM Data Server Client Σ� . . . . . . . . . . . . . . . . . 5

� 3 � w� DB2 Connect PersonalEdition . . . . . . . . . . . . . . . 7w��tm DB2 Connect Personal Edition ���@δBJ . . . . . . . . . . . . . . . . . 7���O�Θ�D . . . . . . . . . . . . 7w� DB2 Connect Personal Edition (Linux) . . . 8w� DB2 Connect Personal Edition (Solaris). . . 11w� DB2 Connect Personal Edition (Windows) . . 15DB2 Connect ú�∩≤D≈�ñ¼t��w��D 19

����O�z . . . . . . . . . . . . . 20N��� ID sW� DB2ADMNS � DB2USERS���s� (Windows) . . . . . . . . . . 20

D root ¡w�º[ (Linux � UNIX) . . . . . 20root w�PD root w�ºí�tº . . . . . 21D root w��¡ε . . . . . . . . . . . 21HD root ���w� DB2 ú� . . . . . . 24�� db2rfe bD root w�ñ�� root ¼\α . . 25N�M≤M��D root ¡w� . . . . . 26�� db2_deinstall �úD root DB2 Ω�wú�]Linux � UNIX�. . . . . . . . . . . 27

� 4 � DB2 Connect qT��� . . . 29��� DB2 Connect �su�� IBM DB2 for IBMi . . . . . . . . . . . . . . . . . . 29��� DB2 Connect �su�� DB2 for z/OS . . 30D≈Ω�w . . . . . . . . . . . . . 31tm DB2 for z/OS � TCP/IP . . . . . . . 31tm DB2 for z/OS . . . . . . . . . . . 34

��� DB2 Connect �su�� DB2 for VSE &VM . . . . . . . . . . . . . . . . . 34

tmj¼D≈�ñ¼°A��su . . . . . . . 34�� CA tmP IBM j¼D≈Ω�w°A��s

u]Linux � Windows� . . . . . . . . . 34�� CLP tmP IBM j¼D≈Ω�w°A��

su . . . . . . . . . . . . . . . . 35

� 5 � �� . . . . . . . . . . . . 37tm IBM j¼D≈Ω�w�s�v . . . . . . 37��utm�U{ívjM⌠⌠�tmΩ�wsu 37��utm�U{ívΓ�tmΩ�wsu . . . 38��utm�U{ív��Ω�wsu . . . . 39�ú DCS (D≈Ω�w) . . . . . . . . . 39

Σ�� DB2 �yÑ . . . . . . . . . . . 39HzΩa�yÑπuDB2 w�vδF (Linux �UNIX) . . . . . . . . . . . . . . . 40HΣLyÑ⌡μuDB2 w�vδF��yÑ ID . 40�≤ DB2 ú��yÑ (Windows) . . . . . 41�≤ DB2 �yÑ (Linux � UNIX) . . . . 42r�Ω��α½ . . . . . . . . . . . . 43

}oΩ�w��{í . . . . . . . . . . . 43DB2 Connect W�s�Ω�w��{í . . . . 43⌡μz�v���{í . . . . . . . . . . 45

�úw� DB2 Connect. . . . . . . . . . . 45�úw� DB2 ú� (Windows) . . . . . . . 45�úw� DB2 Ω�wú�]Linux � UNIX� . . 46

�² A. DB2 �NΩTº[ . . . . . . 49LΩ�y� PDF μí� DB2 �NO� . . . . . 49q� DB2 LΩ�y. . . . . . . . . . . . 52qⁿOμBz�π SQL ¼Aí� . . . . . . 53s�úP���uDB2 ΩTñ�v . . . . . . . 53buDB2 ΩTñ�vñHz�n�yÑπDD . . 53≤sqú�°� í⌠⌠°A�W� DB2 ΩTñ� 54Γ�≤sqú�°� í⌠⌠°A�Ww��uDB2ΩTñ�v . . . . . . . . . . . . . . 55DB2 ⁿ��� . . . . . . . . . . . . . 57DB2 �°��ΩT . . . . . . . . . . . . 57°� . . . . . . . . . . . . . . . . . 58

�² B. �N�� . . . . . . . . . . 59

�� . . . . . . . . . . . . . . . . 63

© Copyright IBM Corp. 1993, 2012 iii

Page 6: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

iv w��tm DB2 Connect Personal Edition

Page 7: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

� 1 � ÷≤��

w��tm DB2 Connect Personal Edition ú�z����AMß��w� DB2 Con-

nect™ Personal Edition ��íΩTC]AC@�Σ��@�t��SwΩTCe{ DB2

Connect Personal Edition PΣ��Ω�w°A�ú�ºí�÷YA]Ap≤tmsuC

��A�∩H

t��z�BΩ�w�z�BqTMa�nΘú�w��ú���\¬���Y�í

��íC

© Copyright IBM Corp. 1993, 2012 1

Page 8: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

2 w��tm DB2 Connect Personal Edition

Page 9: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

� 2 � DB2 Connect ��

÷≤ DB2 ConnectDB2 Connect ú�q LinuxBUNIX � Windows @�t�s�j¼D≈�ñ¼Ω�w

�\αC

ziHs�� z/OS®BIBM® i � IBM Power Systems™B VSE H� VM W� DB2®

Ω�wCz]iHs��ϕu Distributed Relational Database Architecture™ (DRDA®) �

D IBM Ω�wC

DB2 Connect ú�����

DB2 Connect �su�M� (]A DB2 Connect Personal Edition)AH���

�h� DB2 Connect °A�ú�C

v DB2 Connect Enterprise Edition

v DB2 Connect Application Server Edition

v DB2 Connect Unlimited Edition for System z®

v DB2 Connect Unlimited Edition for System i®

p� DB2 Connect ú�PA���ΩTA��\ www.ibm.com/software/data/db2/

db2connect/

@δ DB2 Connect Ω�d�

e{�� DB2 Connect ���u@ñΩ�w⌠��@δΦkAH��¿Dn@� (]A

DB2 Connect) �@δΦkCΩ�d]ApU�⌠��@�GDB2 Connect � IBM j

¼D≈Ω�w°A�ºí���suF��utm�U{ív��zΩ�w�suF

H� IBM Data Server Client Σ�Ω�w��{í}oC

�� DB2 Connect Personal Edition s� System z D≈� IBM i DB2Ω�

úg ñí°A����iμsuAO�ϕΦK�Bn��tmC∩≤ IBM j¼D≈

Ω�w°A�Σ� TCP/IP su\α�¼p�íA�Σp�Cbo�¼pñAC@�

DB2 Connect u@�ú���P IBM j¼D≈Ω�w°A����suC

TCP/IP su\α�n IBM j¼D≈Ω�wΣ� TCP/IPCUC��Σ���� TCP/IP

suG

v DB2 for z/OS 7.1 ��≤s��

v IBM DB2 for IBM i 5.1 ��≤s��AH�

v DB2 Server for VM and VSE � 7 ��≤s��

Yns�� IBM j¼D≈Ω�w°A�Az�niHsW� IBM Data Server Cli-

ent� DB2 Connect �vC

© Copyright IBM Corp. 1993, 2012 3

Page 10: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

� 1 πww� DB2 Connect Personal Edition �u@���s� IBM j¼D≈Ω

�w°A�C

� 1. DB2 Connect P IBM j¼D≈Ω�w°A�ºí���su

4 w��tm DB2 Connect Personal Edition

Page 11: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

��tm�U{í�zΩ�wsu (Linux � Windows)utm�U{í (CA)vi≤Uz�z��°A��Ω�wsuC CA iHϕ¿ DB2

�ß��≤���C���� CA �]w⌠≤�ßP°A��qTC

�Gbºe���ñA��¡xúΣ�uDB2 �zuπv(p CA�C�b� 9 �Au

� Windows x86BWindows x64 (AMD64/EM64T)Bx86 W� LinuxAH� AMD64/

EM64T W� Linux Σ�uDB2 �zuπvCb��¡xñAzúiH�� DB2 ⁿO

μBz� (CLP) ��zsuC

�F CA ºßAziHG

v NΩ�ws����{íi��ª�C�T�Φki�G

– ��Ω�w�z��ú��]w���wqs�C�ßs������Ω�w

]wC

– b⌠⌠ñjMi�Ω�w�∩�@�C����]w�ñ�wq���Ω�w]

w�ßs�CúDzLwwq IBM j¼D≈Ω�w� DB2 Connect °A�A

�h DB2 Connect Personal Edition LkjM IBM j¼D≈Ω�wC

– ΘJ�n�su��AHHu@�Φí�tmPΩ�wºí�suC

v �úws�Ω�wA��≤ws�Ω�w eC

v �X��Jt��ß�Ω�w�tmΩT��ß]w�C

v ��gLt��O�����w�s�C

v g ∩���{íA�Os�Mμñ���A���{íPΩ�ws�C

v sWB�≤��ú CLI/ODBC Ω���AH�tm CLI/ODBC tm]wC

v �πz�t�W��ßtm��CH�ΦΦí����B∩���ºß��

ú���]wC

v ≤sΩ�w°A�KXC

Ω�w��{í}o� IBM Data Server Client Σ�

Data Server Client ]tUC��G

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)

]A��}o��{í����{íXdA�o����{íXdiH�÷�

α� ODBCA��� ODBC SDK iμs�CiHq Microsoft �o Windows @

�t�� ODBC SDKA]iHqΣLU����o\hΣLΣ�¡x� ODBC

SDKCb Windows @�t�WADB2 Client (��� Microsoft ODBC SDK �}

o���{í) �w]�w� ODBC � CLI X�{íCY�ΣL��¡xAh

ODBC � CLI X�{íi∩�aP DB2 Client @�w�A�ß�Σ�iH��

�¡xº ODBC SDK �}o���{í (pG���C

v IBM Data Server Driver for JDBC and SQLJAΣñ]AG

– JDBC 3 � JDBC 4 �e��{íΣ�

– SQLJ Σ�A�≤��RA SQL �}o Java™ ��{í

v Java 5 ⌠� O≤ DB2 °A�ñAHΣ�°A� Java ��{íc≤A]Ax

s{�����wq�τ�

� 2 � DB2 Connect � 5

Page 12: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

v Windows @�t�W� ActiveX Data Object (ADO) �u½≤s�M�O (OLE)v����í]UDF �uxs{�v� ]]A�� Microsoft Visual Basic � Microsoft

Visual C++ Ω@�{íXd�C

v Windows @�t�W�u½≤s�M�OΩ�w (OLE DB)vϕμτ�C

v Windows @�t�W� C# � Visual Basic .NET ��{íM CLR .NET �íC

v Ruby and Ruby on Rails ��{íΣ�A]A�÷w��{íXd� IBM_DB

gemC Ruby O@���πX�½≤�V{í]pyÑA��}o Web ��{íC

Ruby on Rails (RoR) ]� RailsAO��u�¼-°�-�εv[c�}o Web �

�{íHs�Ω�w�@�[cC

v PHP Hypertext Preprocessor ��{íΣ�A]A{í]p��w�{íXdC

PHP O@� Script yÑA��}o Web ��{íC]Σ�½≤�V{í]p

v IBM Data Studio OπX Eclipse uπ�εX�M�AA�≤Ω�w}o��}o

DBAC IBM Data Studio iε� DB2 � Informix® Ω�°A�⌡μUC@���

íG⌡μCΘ�z@�B��Bíp�ú� SQL � Java xs{�BípΩ�ñ�

Web A�AH��� SQL � XQuery ��÷pí� XML Ω�d�C

v zLuⁿOsΦ�v�uⁿOμBz� (CLP)v�¼�í SQLA�� SQL »zí�

�¼�w∩Ω�w⌡μSO�d�C

v @�Oⁿ� APIAiH��ΣL��{í}ouπA��bª��ú� Ω@ DB2 �

ems��Σ�CpAAIX® W� IBM COBOL �����C

6 w��tm DB2 Connect Personal Edition

Page 13: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

� 3 � w� DB2 Connect Personal Edition

w��tm DB2 Connect Personal Edition ���@δBJ

�GpGz�qúww� IBM Data Server ClientAhiHb�qúWn² DB2 Con-

nect Personal Edition �vAH�� DB2 Connect Personal EditionC

]w DB2 Connect Personal Edition �{�]th�BJC�DDQ�w��tm DB2

Connect Personal Edition ���@δBJC

1. Mwnp≤b⌠⌠ñ�� DB2 ConnectC

2. τ�z�u@�� IBM j¼D≈Ω�w°A�Wúwπ�T�nwΘ����C

3. τ�zwtm IBM j¼D≈Ω�w°A�Ai�ⁿ�� DB2 Connect �suC

4. w� DB2 Connect nΘCzN����u@��tm�τ� IBM j¼D≈suC

5. w�ºßA�b DB2 Connect P IBM j¼D≈Ω�wt�ºí��suC

DB2 Connect ��zMΣ�tm�� TCP/IP suCp��Ω�A��\τ� IBM

Data Server Driver Package (Windows) w���÷DDC

6. N DB2 Connect �ú��{í���{ís� IBM j¼D≈Ω�wC

�GIBM Data Server Driver Package (DS Driver) ú�n�BJC∩≤�j��ß

M≤AC@�u�M≤v��ú�niμ½ss�C

7. �� IBM j¼D≈suC

z{bw��AiN DB2 Connect Pz�����{íft��C

���O��D

TO�Aϕ���í�qi� DB2 ⌠���A���atmO�ΘC

��≥��D

ú������í�°z∩�w��¼�z����t��¼�wCuDB2 w

�vδF���biμ@δw�BúYw���qw��í�∩���≤A�ú��

Ajp⌠p�C

�Oo�J���Ω�wBnΘ�qTú����íC

b Linux � UNIX @�t�WA�� /tmp �²ñ� 2 GB �i�íC

O�Θ�D

O�Θ�DⁿΩ�wt��jp��°{�BΩ�wí��d≥AH�s�t��

�ß��vTCDB2 Ω�wt����n 256 MB � RAM1C∩≤�⌡μ DB2 ú

�� DB2 GUI uπ�t�A���n 512 MB � RAMCM�A�Fπ�Wi��

αA���� 1 GB � RAMCo��Dú]At�W⌡μºΣLnΘ���⌠≤B�

1.b HP-UX Version 11i for Itanium ¼t�W⌡μ� DB2 ú����n 512 MB � RAMC

© Copyright IBM Corp. 1993, 2012 7

Page 14: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

O�Θ�DC∩≤ IBM Data Server ClientΣ�Ao�O�Θ�DOH 5 ��μ�ß

su�≥ªCCW[¡��ßsuAY�W[ 16 MB � RAMC

∩≤ DB2 °A�ú�A�μ�πO�Θ�z{í (STMM) ���]w��O�Θtm

����AH��O�Θtm@�CY��AhO�Θ�π{í�b��O�Θ°�

�ºí�Atei�O�ΘΩ�A]A��BM≤�BΩwMμ�w�C

���í�D

DB2 �n���]]�μ½�C�n�tmA�αΣ� DB2 ñ�U�\αA�o

�\α��°�°μ½/�í��v���wC��μ½/�í�Ω��qH

t����úPA�Bú��O����nΘ�O�Θ��vCu�b Solaris � HP ¡

xWADB2 ����nªA]�btm¡��í����ª�C

jít��Xzμ½/�íU¡tm� 25-50% � RAMCπ� STMM �π�

\hp¼Ω�w�h�Ω�w� Solaris � HP t�Aiα�n 1 x RAM �≤¬�

�ítmCo�≤¬��DO ≤C�Ω�w/Ωw²tm�Ω�O�ΘAH�

STMM �πh�Ω�w�Od�Ω�O�Θ�PCiαQn∩t�W�Dw�O�ΘL

�μU��ΣLμ½/�íC

w� DB2 Connect Personal Edition (Linux)Ynwqw��n]wA�b Linux Ww� DB2 Connect Personal Edition ú�A�

��uDB2 w�vδFCw� IBM Data Server Driver Package (DS Driver)AMßM

� DB2 Connect Personal Edition �vAOUC{���n∩Φ�Cp��Ω�A

��\ IBM Data Server Client �¼C

}lºe

}lw�ºeG

v ziH�� root �D root v¡�w� DB2 ConnectCp�D root w���÷Ω

TA��\uD root w�º[]Linux � UNIX�vC

v �Twz�t��XG

– ���O�Θ�D

– � 10��yDB2 Connect Personal Edition �w��D (Linux)z.

v ��bt�W�ⁿ DB2 Ω�wú� DVDC

v ���i�� DB2 Connect ú�M��CpGzw��ODσ��� DB2 Con-

nect ú�Ah��π�Aϕ�uΩayÑM≤vC

v YnMΣt�Www�� DB2 Ω�wú�A��\mw� DB2 °A� nñ�yC

Xt�Www�� DB2 ú�]Linux � UNIX�zDDC uDB2 w�vδFO�

w�{íCz���α≈e{������ X Windows nΘA�αb≈�

W⌡μuDB2 w�vδFC�Tw X Windows °A�b⌡μñABzwAϕa�

Xπe�CpAexport DISPLAY=9.26.163.144:0C

v pGbz�⌠�ñ���O�ⁿu�q¼�²s�qT≤w (LDAP)v�w�nΘA

hb��uDB2 w�vδFºeA��Γ����n� DB2 ���Cb}lºeA

��\u�ñí����z�qvDDC

8 w��tm DB2 Connect Personal Edition

Page 15: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

�Gq DB2 9.1 � Fix Pack 2 }lAw≤�u⌠⌠ΩTA� (NIS)v�u⌠⌠ΩT

�[A� (NIS+)v\αC����ñiα��úo�\α�Σ�Cu�q¼�²s�

qT≤w (LDAP)vO�ñí����zA�����MΦ�C

÷≤o�@�

uDB2 w�vδFO@� Java ¼w�uπAiHN⌠≤ DB2 Ω�wú��w�Pt

m���CpGúQ�����{íAz�Γ�∩Φ�CziHzLUCΦí�w

� DB2 Connect Personal Edition ú�G

v �� ��Φk

v Γ��� db2_install ⁿOCzúα ��@�t����w���{í rpmA�Γ�w� DB2 Ω�wú�C�n�≤⌠≤t�o���w���{í�{� ScriptA

o� Script O��P DB2 w�¼��⌡μd�C

{�

Yn��uDB2 w�vδFb Linux Ww� DB2 Connect Personal EditionG

1. N�²�½��ⁿ DVD ��²G

cd /db2dvd

Σñ db2dvd Nϕ DVD ��ⁿIC

2. pGwUⁿ DB2 Connect ú�M��Ah���úY� untar �ú���C

a. �úYú��G

gzip -d product.tar.gz

Σñ product OzwUⁿ�Ω�wú�WC

b. Untar ú��G

tar xvf product.tar

c. �½�²G

cd ./product/disk1

�GpGzwUⁿuΩayÑM≤vA�Nª untar ��P�²Cp��b�P�²

ñ��l�²]p ./nlpack/disk2�A�i²w�{í��MΣw�M���ú

�úC

3. qú�M���b��²ΘJ ./db2setup ⁿOAH��uDB2 w�vδFC�Φ

�íßAY�}�uIBM DB2 w���{ívCY�h CD w�A�b�ⁿ CD

�mº�A���∩��∩⌠W�oX db2setup ⁿOAHTOi��n�ú�ⁿ DB2 Connect ú� CDC �°íñAziH�°w������P���N

��A���iJw�{�C

4. �lw�ßA��≥�¿uDB2 w�vδFw�e�A�iμ∩Cw�í���

�z�¿uDB2 w�vδFC÷@Uí��IsuWí�CziHH�÷@U�°

H�⌠w�Cϕz÷U�ß@�uDB2 w�vδFw�e�W��¿ßADB2 ��

���st�C �¿ßAN��� /opt/IBM/db2/V9.7 w]w�⌠�w� DB2

Connect Personal Edition ú�C

pGnw��t�w����²Ah DB2 Connect ú�w�⌠�[W _xxAΣñ

xx Oq 01 }l��rA���ww�� DB2 ���q�W[C

� 3 � w� DB2 Connect Personal Edition 9

Page 16: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

z�iHⁿw�v� DB2 Ω�wú�w�⌠C

�G

w� DB2 Connect ú�ºßA]iHzLquΩayÑM≤v�b�²⌡μ ./db2setupⁿOA�w�uΩayÑM≤vC

�w]A�Nw�Θx db2setup.log � db2setup.err m≤ /tmp �²ñCziHⁿ

wΘx���mC

pGn²z� DB2 Ω�wú�s��qú�⌠⌠Wt@íqú� DB2 σ≤Ah�

�w�uDB2 ΩTñ�vCDB2 ΩTñ� ]t DB2 Ω�w� DB2 �÷ú��σ≤C

��\mw� DB2 °A�nñ�y�� DB2 w�δFw� DB2 ΩTñ� (UNIX)z

DDC

DB2 Connect Personal Edition �w��D (Linux)b Linux @�t�Ww� DB2 Connect Personal Edition ºeA�TOz∩�t�

�X�n�@�t�BwΘBnΘ�qT�DC

Ynw� DB2 Connect Personal EditionA���XUC�DG

w�D

Bz���OUCΣñº@G

v x86 (Intel PentiumBIntel Xeon � AMD Athlon)

v x64 (Intel EM64T � AMD64)

o�D

p�Σ�º Linux oμ���sΩTA�Ns²�ⁿV http://www.ibm.com/

db2/linux/validateC

iα�nDz≤s�{ítm��C�{ítm��]≤ /etc/

sysctl.confC p��� sysctl ⁿO�]w���o�����÷ΩTA��\@�t�ΓUC

n�D

v �ns²��d�uWí�C

v pGn��uDB2 w�vδF�w� DB2 ConnectA�Qn��⌠≤ DB2

�uπAh�nα≈e{�í����� X Window System nΘC

qT�D

pn�� TCP/IP su\αAhú�nΣL�nΘC

�ⁿ CD � DVD (Linux)Ynb Linux @�t�W�ⁿ CD-ROMA�oX mount ⁿOC

}lºe

��z�t�tmAziα�n root ���v¡�α�ⁿ��C

{�

Ynb Linux @�t�W�ⁿ CD � DVDA�G

1. N CD � DVD íJ��≈ñA�ΘJUCⁿOG

10 w��tm DB2 Connect Personal Edition

Page 17: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

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

Σñ /cdrom Nϕ CD � DVD ��ⁿIC

2. nXC

�G

z� CD � DVD ��t�{bw�¿�ⁿCN��m≤��≈A�ΘJ cd /cdromⁿOiH�° CD � DVD � eAΣñ cdrom O�ⁿI�²C

w� DB2 Connect Personal Edition (Solaris)Ynwqw��n]wAH�w� DB2 Connect Personal EditionA���uDB2 w�v

δFCw� IBM Data Server Driver Package (DS Driver)AMßM� DB2 Connect Per-

sonal Edition �vAOUC{���n∩Φ�Cp��Ω�A��\ IBM Data

Server Client �¼C

}lºe

}lw�ºeG

v ziH�� root �D root v¡�w� DB2 ConnectCp�D root w���÷Ω

TA��\mw� DB2 °A�nñ�yD root w�º[]Linux � UNIX�zC

v �Twz�t��Xw�BO�����DC

v ��bt�W�ⁿ DB2 Ω�wú� DVDC

v ���i�� DB2 Connect ú�M��CpGzw��ODσ��� DB2 Con-

nect ú�Ah��π�Aϕ�uΩayÑM≤vC

v YnMΣt�Www�� DB2 Ω�wú�A��\mw� DB2 °A�nñ�yC

Xt�Www�� DB2 ú�]Linux � UNIX�zDDC

v uDB2 w�vδFO�w�{íCz���α≈e{������ X Win-

dows nΘA�αb≈�W⌡μuDB2 w�vδFC�Tw X Windows °A�b

⌡μñABzwAϕa�Xπe�CpAexport DISPLAY=9.26.163.144:0C

v pGbz�⌠�ñ���O�ⁿu�q¼�²s�qT≤w (LDAP)v�w�nΘA

hb��uDB2 w�vδFºeA��Γ����n� DB2 ���Cb}lºeA

��\w� DB2 °A�ñ�u�ñí����z�qvC

�Gq DB2 9.1 � Fix Pack 2 }lAw≤�u⌠⌠ΩTA� (NIS)v�u⌠⌠ΩT

�[A� (NIS+)v\αC����ñiα��úo�\α�Σ�Cu�q¼�²s�

qT≤w (LDAP)vO�ñí����zA�����MΦ�C

÷≤o�@�

uDB2 w�vδFO@� Java ¼w�uπAiHN⌠≤ DB2 Ω�wú��w�Pt

m���CpGúQ���δFAz�Γ�∩Φ�CziHzLUCΦí�w� DB2

Connect Personal Edition ú�G

v �� ��ΦkC

v Γ��� db2_install ⁿOCzúα ��@�t����w���{í pkgaddA�Γ�w� DB2 Ω�wú�C �n�≤⌠≤t�o���w���{í�{�

ScriptAo� Script O��P DB2 w�¼��⌡μd�C

� 3 � w� DB2 Connect Personal Edition 11

Page 18: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

{�

Ynb Solaris x64 W��uDB2 w�vδF�w� DB2 Connect Personal EditionA

�⌡μUC�@G

1. N�²�½��ⁿ DVD ��²G

cd /db2dvd

Σñ db2dvd Nϕ DVD ��ⁿIC

2. pGwUⁿ DB2 Connect ú�M��Ah���úY� untar �ú���C

a. �úYú��G

gzip -d product.tar.gz

Σñ product O�Uⁿ� DB2 Connect ú�WC

b. Untar ú��G

tar xvf product.tar

c. �½�²G

cd ./product/disk1

�GpGzwUⁿuΩayÑM≤vA�Nª untar ��P�²Cp��b�P�²

ñ��l�²]p ./nlpack/disk2�A�i²w�{í��MΣw�M���ú

�úC

3. qú�M���b��²ΘJ ./db2setup ⁿOAH��uDB2 w�vδFC Y�

h CD w�A�b�ⁿ CD �mº�A���∩��∩⌠W�oX db2setupⁿOAHTOi��n�ú�ⁿ DB2 Connect ú� CDC �Φ�íßAY�}�

uIBM DB2 w���{ívC �°íñAziH�°w������P���N

��A���iJw�{�C

4. �lw�ßA��≥�¿uDB2 w�vδFw�e�A�iμ∩C w�í���

�z�¿uDB2 w�vδFC÷@Uí��IsuWí�CziHH�÷@U�°

÷sA�⌠w�@�Cϕz÷U�ß@�uDB2 w�vδFw�e�W��¿ßA

DB2 �����st�C

�¿ßAN�Q� /opt/IBM/db2/V9.7 w]w�⌠�w� DB2 Connect Per-

sonal EditionC

pGnw��t�w����²Ah DB2 Connect ú�w�⌠�[W _xxAΣñ

xx Oq 01 }l��rA���ww�� DB2 ���q�W[C

z]iHⁿw�v� DB2 Connect ú�w�⌠C

�G

w� DB2 Connect ú�ºßA]iHzLquΩayÑM≤v�b�²⌡μ ./db2setupⁿOA�w�uΩayÑM≤vC

�w]A�Nw�Θx db2setup.log � db2setup.err m≤ /tmp �²ñCziHⁿ

wΘx���mC

pGn²z� DB2 Ω�wú�s��qú�⌠⌠Wt@íqú� DB2 σ≤Ah�

�w�uDB2 ΩTñ�vCuDB2 ΩTñ�v]t DB2 Ω�w� DB2 �÷ú��σ

12 w��tm DB2 Connect Personal Edition

Page 19: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

≤C��\mw� DB2 °A�nñ�y�� DB2 w�δFw� DB2 ΩTñ�

(UNIX)zDDC

DB2 Connect ú��w��D (Solaris)buSolaris @�t�vWw� DB2 Connect ú�ºeA�TOz∩�t��X�n

�@�t�BwΘBnΘ�qT�DC

Ynb Solaris Ww� DB2 Connect ú�A���XUC�DG

ϕ 1. Solaris w��D

@�t� wΘ

Solaris 10 Update 5

v 64 ���

v ��{í 127128-11

Solaris x64]Intel 64 � AMD64�

Solaris 9

v 64 ���

v ��{í 111711-12 � 111712-12

v pG���l�mA��{í 122300-11

Solaris 10 Update 5

v 64 ���

v pG���l�mA��{í 125100-07

UltraSPARC � SPARC64 Bz�

1. uΣ�N DB2 w�b���WCDB2 �eúΣ�����w�C

@�t��D

ziHq http://java.sun.com ⌠��o ″Recommended & Security Patches″CqSunSolve Online ⌠�÷@U¬Σe�ñ� ″Patches″ \αϕ��C

P�]�n J2SE Sola r i s @�t���{íO�CziHq ht tp : / /

java.sun.com ⌠��oª�C

∩≤ 64 �� Fujitsu PRIMEPOWER t�W� DB2 ConnectAz��nUC

��G

v Solaris 9 �≤s��{í 112233-01 �≤s��AH�o��{í

912041-01 ��{íC

ziHq FTSI ⌠�Uⁿ Solaris @�t�� Fujitsu PRIMEPOWER ��{íA

⌠}�Ghttp://download.ftsi.fujitsu.com/C

Y�ΣLb Solaris WivT DB2 Ω�wt���DMμA��\G

www.ibm.com/support/docview.wss?&uid=swg21257606

DB2 Ω�wú�Σ� Solaris ZFS ��t��u�Φ⌠� (LDom)vC

p� DB2 ú��Σ�Ω���N��Ω�A��\ http://www.ibm.com/

developerworks/wikis/display/im/DB2+Virtualization+SupportC

n�D

v �n� SUNWlibC nΘA�αb Solaris Ww� DB2 ConnectCziHq

http://java.sun.com ⌠��oªC

v �ns²��d�uWí�C

� 3 � w� DB2 Connect Personal Edition 13

Page 20: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

qT�D

ziH�� TCP/IP

v pn�� TCP/IP su\αAhú�nΣL�nΘC

v bUCípUASun Cluster 2.2 iΣ� DB2 ConnectG

– D≈�qT≤wO TCP/IP

– úO��ΓÑqTwCpG���N SPM Θxtm�b@���W]o

iHzL spm_log_path Ω�w�z{ítm����¿�ABó��Γt���P� TCP/IP tm]�P�D≈WBIP �}ÑÑ�A�≥�¡

εi±eC

�ⁿ CD � DVD]Solaris @�⌠��

buSolaris @�⌠�vWApG CD-ROM bzNªíJ��≈�����ⁿA�oX

mount ⁿOC

}lºe

pGz�� NFS q�t��ⁿ CD � DVD ��≈Ah���� root s�v��

X�qúW� CD � DVD ��t�C���t�tmAz]iα�n�qú�

root s�vC

{�

Ynb Solaris W�ⁿ CD � DVDA�⌡μUC�@G

1. N CD � DVD íJ��≈ñC

2. pGt�b⌡μu���z{ív(vold)Ah��N���ⁿ¿ /cdrom/

cd_label]pG CD � DVD ����� /cdrom/unnamed_cdrom]pG CD � DVD

S����C

pGz�t���⌡μu���z{ívA��¿UCBJ��ⁿ CD � DVDG

a. ΘJUCⁿOHP��m�WG

ls -al /dev/sr* |awk ’{print "/" $11}’

�ⁿO�� CD � DVD �m�WCb�dñAⁿO�� rΩ /dev/

dsk/c0t6d0s2C

b. ΘJUCⁿOH�ⁿ CD � DVDG

mkdir -p /cdrom/unnamed_cdrommount -F hsfs -o ro /dev/dsk/c0t6d0s2 /cdrom/unnamed_cdrom

Σñ /dev/dsk/c0t6d0s2 NϕW@�BJ�� ��mWA� /cdrom/

unnamed_cdrom Nϕ CD � DVD �ⁿ�²C

3. nXC

�G

z� CD � DVD ��t�{bw�¿�ⁿCzLN CD � DVD ±mb��≈ñA

�ΘJ cd /cdrom ⁿOiH�°Σ eAΣñ cdrom O�ⁿI�²C

14 w��tm DB2 Connect Personal Edition

Page 21: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

w� DB2 Connect Personal Edition (Windows)�@�í�p≤b Windows @�t�WA��uDB2 w�vδF�w� DB2 Con-

nect Personal EditionCt�Az]iH�� ��Φk�w� DB2 Connect Personal Edi-

tionCw� IBM Data Server Driver Package (DS Driver)AMßM� DB2 Connect Per-

sonal Edition �vAOUC{���n∩Φ�Cp��Ω�A��\ IBM Data

Server Client �¼C

}lºe

��uDB2 w�vδFºeG

v �Twz�t��XUC�DG

– nwΘ�D

– ���O�Θ�D

v pGnb Windows Ww�BQn�� Lightweight Directory Access Protocol (LDAP)A

h��XR�²⌡�C

v ��z��u�z�vbß�⌡μw�@�Cu�z�vbß��Oznw� DB2 Ω

�wú�� Windows qúW��z�s����bßAB�π�UCiÑ��

�v¡G

– @�@�t��@í

– ��O�½≤

– W[tB

– ≤½{�hO�

pGS�iÑ���vQA�OiH⌡μw�A²w�{íiαLkτ�bßC

v pGn��D�z�b�w� DB2 ConnectA��\uDB2 Connect �D�z�w

� (Windows)vDDC

{�

v Yn��uDB2 w�vδF�w� DB2 Connect Personal EditionA�⌡μUC�@G

1. Hπ��z�v¡����¡nJt�C

2. ÷¼��{íA²w�{íαb�n�≤s��C

3. pGz�qúww� IBM Data Server ClientAhiHb�qúWn² DB2 Con-

nect Personal Edition �vAH�� DB2 Connect Personal EditionCYn⌡μw

�{í�w� DB2 Connect Personal EditionA�ϕ�ΣlBJC

4. N DVD íJ��≈C ��⌡μ\α�����uDB2 w�vδFCuDB2 w

�vδFNMwt�yÑAMß���yÑ�w�{íCpGnHúP�yÑ�

⌡μw�{íA�w�{íLk����AhiHΓ�⌡μuDB2 w�vδFC

5. e�W�}�uDB2 ��{ívCziHb�°íñ�°w���������

N��A����≥w�@�C

6. @��lw�@�A�ϕ�w�{í�ú�iμw�CuWí��ⁿ�z⌡μ

Σl�BJC÷@Uí��IsuWí�CziHH�÷@U�°÷sA�⌠w

�@�C

Θx�xs@δΩTAH� w���úw�í��y¿���TºCΘx��W

ϕ� D B 2 -ú�Yg -Θ��í . l o g μíAp D B 2 - C L I E N T - 1 0 - 0 6 -

2006_17_23_42.logC��w]�AΘx��≤ My Documents\DB2LOG �²ñC

� 3 � w� DB2 Connect Personal Edition 15

Page 22: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

v YnΓ�IsuDB2 w�vδFA�⌡μUC�@G

1. ÷@U}lAMß∩�⌡μ∩�C

2. b}�μ�ñAΘJUCⁿOG

x:\setup /i language

ΣñG

– x: Nϕz� DVD ��≈

– language NϕzyÑ�a�X]pAEN Nϕσ�C

3. ÷@UTwC

pGn²z� DB2 Ω�wú�s��qú�⌠⌠Wt@íqú� DB2 σ≤Ah

��w�uDB2 ΩTñ�vCuDB2 ΩTñ�vt�A�≤ DB2 Ω�wt���

÷ú��σ≤C

DB2 Connect Personal Edition �w��D (Windows)zb Windows @�t�Ww� DB2 Connect Personal Edition ºeA�Twz�∩

�t��X�n�@�t�BwΘBnΘ�qT�DC

Ynw� DB2 Connect Personal EditionA���XUC�DG

@�t��D

UCΣñ@�G

v Windows XP Professional Edition]32 ��� 64 ���H� Service Pack

2 �≤s��

v Windows 2003 H� Service Pack 2 �≤s��G

– Standard Edition]32 ��� 64 ���

– Enterprise Edition]32 ��� 64 ���

– Datacenter Edition]32 ��� 64 ���

v Windows Vista

– Professional Edition]32 ��� x64�

– Enterprise Edition]32 ��� x64�

Σ��� Windows Vista A�M≤C

v Windows 7

– Professional Edition]32 ��� x64�

– Enterprise Edition]32 ��� x64�

v Windows Server 2008

– Standard Edition]32 ��� 64 ���

– Enterprise Edition]32 ��� 64 ���

– Datacenter Edition]32 ��� 64 ���

Σ��� Windows Server 2008 A�M≤C

v Windows Server 2008 R2

– Standard Edition]64 ���

– Enterprise Edition]64 ���

16 w��tm DB2 Connect Personal Edition

Page 23: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

– Datacenter Edition]64 ���

Σ��� Windows Server 2008 R2 A�M≤C

w�D

v �� Intel � AMD Bz�úα≈⌡μΣ�� Windows @�t�]32 ��

� x64 ¼t��C

n�D

v �ns²��d�uWí�C

qT�D

v @�t�Σ��ú� TCP/IPC

Windows]64 ���q

v Σ�� 32 ���ßq���e� SQL nDC

\α o� DB2 Connect DnOw∩�Hu@������{ísuC°A��hD

\αLk��Cp�o��ú�\α��π��A�yX http://www.ibm.com/

software/data/db2/db2connect/edition-pe.htmlC

o� DB2 Connect ���úO����{í°A�A]�ú��w�bo�°

A�WC

w� DB2 Connect Personal Edition ������bß

(Windows)

pGOb Windows Ww� DB2 Connect Personal Edition ú�Ah�n�w����

bßC

w����bßO⌡μw�º����bßCb⌡μuDB2 w�vδFºeA��²w

qw����bßCziHbw�ºewq]w���bßA]iH²uDB2 w�vδ

F�z��bßC

�����bßW��ϕut�RWWh� DB2 RWWhC

pGz���w����bß]t DB2 RWWhñ�ⁿw�Dσr�Ah DB2 w

��óC

�n��⌠����bß�⌡μw�C@δ�ÑAbn⌡μw��qúWA���

bß���≤ Administrators s�C

]i��D�z����bßC�∩Φ��n Windows Administrators s�¿²t

m Windows �¬M�v]wAHe\D�z����bß⌡μw�CpAb 64 �

�@�t�WAz��²b HKLM\Software\Wow6432Node WΓ��P�í\ivADB2

Connect Personal Edition �α¿\aw�Cb Windows Vista WAD Administrator i

⌡μw�A²uDB2 w�vδF�úLú��z{�C

w����bß�n���vQuq⌠⌠s��qúvC

∩≤⌠�b��íAYnτ���� IDAhw���� ID ���≤n��bߺ⌠�

W� Domain Administrators s�C

z]iH�� ��u�t�vbß���ú�⌡μw�C

� 3 � w� DB2 Connect Personal Edition 17

Page 24: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

DB2 w�{í�P����v¡

DB2 w�{í���Puú�{ív���vQCDB2 w�{í�PUC���vQG

v @�@�t��@í

v ��O�½≤

v ΩwO�Θ�

v HA�ΦínJ

v W[tB

v ≤½{�hO�

Windows W���w�

DB2 ú�ú���� Windows w�CziH����� ID �w� DB2 Connect Per-

sonal EditionA²OúD���� ID �≤ DB2ADMNS � DB2USERS s�A�h�

��� ID Lk⌡μ⌠≤ DB2 ⁿOC

DB2 w�{íi��oΓ�ss�CziHb�qw��íⁿwsW��ⁿw]W

C

Yn���w�\αA�bw� DB2 �íA∩��� DB2 ½≤�@�t�w�e�

W���@�t�w��∩�C�ⁿuDB2 �z�s�vμ��uDB2 ���s�v

�w]�Cw]s�W� DB2ADMNS � DB2USERSCpGP{s�s�W

�≡At�N�úz�≤s�WCp��nAz]iH�μⁿw�C

XR LDAP �²A�� Active Directory ⌡� (Windows)pGzp���u�q¼�²s�qT≤w (LDAP)v�²°A�S�P Windows Server

2003 ft��Ah���� db2schex ⁿO�XR Active Directory ⌡�AH]t DB2

½≤�O���wqC

}lºe

bw� DB2 ú����Ω�wºeXR�²⌡��nBpUG

v ]w���� ID π�¼≈�M�viHgJ Active DirectoryAbw��í��

�w] DB2 Ω�s�� Active Directory ñ� DB2 �IC

v bw�ºß���⌠≤Ω�wú���s� Active DirectoryC

÷≤o�@�

YnXR�²⌡�A�G

{�

1. ��π�u⌡��zvv¡� Windows ���bßAnJ�≤ Windows ⌠��⌠

≤≈�C

2. qw� DVD ⌡μ db2schex ⁿOCziH��UCΦí⌡μ�ⁿOA�ú�nnXßAnJG

runas /user:MyDomain\Administrator x:\db2\Windows\utilities\db2schex.exe

Σñ x: Nϕ DVD ��≈N�C

18 w��tm DB2 Connect Personal Edition

Page 25: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

U@B

ϕ db2schex �¿�AziH�≥w� DB2 ú�F�pGzwgw� DB2 ú��w

��Ω�wAh��Γ�n²�I�s�Ω�wCp��÷ΩTA��\uDB2 w��

¿ß�� LDAP Σ�vDDC

DB2 Connect �D�z�w� (Windows)Y�Du�z�v�w�AhnJ���bß���≤ Power Users s�C

Y���bn²ñX{� D B 2 C o n n e c t �÷ΩTA��bn²�

HKEY_CURRENT_USER Ω�¿ñΘJC÷M�\h DB2 Connect �D�z�w��

��xsbn²� HKEY_LOCAL_MACHINE Ω�¿ñA²O⌠�]w��b

HKEY_CURRENT_USER ñ�≤C

Windows Administrators s�¿��tm Windows �¬M�v]wAHe\D�z

����bß⌡μw�CpAb 64 ��@�t�WAz��²b HKLM\Software\

Wow6432Node WΓ��P�π\ivA32 �� DB2 Connect Personal Edition ú��

α�Qa�¿w�C

�GpGn D Administrator ���bßw�ú�Ahzb��w� DB2 ú�e��

²w� VS2005 ⌡μ����wCw�DB2 ú�eA@�t�W��n� VS2005 ⌡

μ����wCVS2005 ⌡μ����wiHqMicrosoft ⌡μ����w⌠��oC�

Γ�∩�GYO 32 ��t��∩ vcredist_x86.exeAYO 64 ��t�h�∩

vcredist_x64.exeC

t����≤�����iiμD�z�w�C��A]�bw�⌠≤ DB2

Connect ú��ún�A�A²OS��zv¡ANLk��A�A�HbiμD�

z�w��AA��H{�Φí��a��C

UCOb�z�w��D�z�w�úsb�⌠�ñziαJ�w�¼pG

v Y�Du�z�vw�F DB2 ConnectAMßu�z�v��b�P�t�Ww�

DB2 ConnectCu�z�vN�oú�ww��TºCu�z�v�v¡�úw�

�½sw�ú�A��Mo��DC

v Y�Du�z�vw�F DB2 ConnectAM�G�Du�z�v��b�P�t�

Ww� DB2 ConnectCb�Ω�dñAw�N�óA�� ��TºAⁿX��

���Ou�z�vA�αw�ú�C

v u�z�vww�F DB2 ConnectAMßDu�z�v��b�P�t�Ww� DB2

ConnectCb�Ω�dñAw�N�óA�� ��TºAⁿX�����O

u�z�vA�αw�ú�Cu�z�v����úw�P½sw��v¡C

v D�z����Lk�úw� DB2 ú�C�≤ Windows Vista]PHW����@

�t�W���D�z����iH�úw� DB2 ú�C

DB2 Connect ú�∩≤D≈�ñ¼t��w��D

DB2 Connect ú�i²u@�s���Σ�D≈�ñ¼¡xW�Ω�w (pAz/OS W

� DB2�CbíípUADB2 Connect �ßiα�nN��{íM��D≈�ñ¼Ω

�wú�A�α��o�\αC

��\ Installing IBM Data Server Clients ñ�uw� IBM Data Server Client (Linux

� UNIX)v�uw� IBM Data Server Client (Windows)vC

� 3 � w� DB2 Connect Personal Edition 19

Page 26: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

����O�z

bw� DB2 Connect Personal Edition ß�÷Σ@�ON���sW�π�w]W

DB2ADMNS � DB2USERS �Γ����s�ñ�Σñ@�CN⌡μo�@�A]�

ªOzN∩Ω�w⌠�Ω@�Ω�ww��h�@íC

N��� ID sW� DB2ADMNS � DB2USERS ���s� (Windows)�Q�¿ DB2 w�ºßA{bz��N�nb≈�W⌡μ� DB2 ��{í�uπ

����sW� DB2ADMNS � DB2USERS s�CDB2 w�{í���Γ�ss�C

ziH��sW��ⁿw]WCw]s�W� DB2ADMNS � DB2USERSC

}lºe

v z��ww�F DB2 Ω�wú�C

v z��bw� DB2 Ω�wú��íA∩�F�� DB2 ½≤�@�t�w�e�W

���@�t�w��∩�C

{�

YnN���sWAϕ�s�ñA�G

1. ÷@U}lAMß∩�⌡μC

2. ΣJ lusrmgr.mscAMß÷@UTwC

3. ∩������Ms�C

4. ∩����C

5. ∩�znsW����C

6. ÷@U�eC

7. ÷@U⌡�≤��C

8. ÷@UsWC

9. ∩�Aϕ�s�C

10. ÷@UTwC

U@B

pGziμFw�Bw∩ú��sw�\αA�i� ⌡μ db2extsec.exe ⁿOAbw�ºß⌡μ��@CN���sW�s���@A�bsW���ºß����@

�nJ���CpApGzN��� ID sW� DB2ADMNS s�Ah�nnXA½

snJA��≤����C

D root ¡�w�º[ (Linux � UNIX)b 9.5 �ºeAu�� root M�v����A�αw�ú�BM�� ��M≤B

tmΩBsW\α��úw�ú�C{bAY�zúO root ���A]iHb Linux

� UNIX @�t�W⌡μo�@�C

DB2 w�{í�bD root ¡w��íA�����tmD root ΩCD root ��

�iHbw��í�qD root Ω�tmCY�S� root M�vAz�OiH���

�@ww�� DB2 Ω�wú�C

DB2 Ω�wú��D root ¡w��@� DB2 Ω�w]���jí\αC

20 w��tm DB2 Connect Personal Edition

Page 27: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

∩≤\hs��ÑAD root ¡w�D�AXApU�G

v ��d�u@�H��dW���]o����Qnbú��t��z��í�

ípUAw� DB2 Ω�wú���°�

v q�úOt��z�²�� DB2 Ω�wú�}o��{í���{í}oH

v }o�nΘú�n root ���v¡²i O DB2 Ω�wú��uW�nΘ��

(ISV)v

÷MD root ¡w�π� root ¡w��jí\αA²��@�tº�¡εCH root

���¡⌡μ db2rfe ⁿOAKi�úí¡εC

root w�PD root w�ºí�tº

úF��¡εº�AD root ¡w���²�c]P root ¡w���²�cy�ú

PC

b root ¡w��íADB2 Ω�wú��l�²����b root ���∩��²

ñ��C

P root ���úPAD root ���Lk∩w� DB2 Ω�wú���mCD root ¡

w�@��≤ $HOME/sqllib �²AΣñ $HOME NϕD root �����l�²C

D root ¡w�º sqllib �²ñ�l�²GmP root ¡w��ⁿC

∩≤ root ¡w�AiH��h�ΩCΩ��v�P��Ω���� ID �÷

pC

D root ¡w�uα�@� DB2 ΩCD root ¡w��²]t�� DB2 Ω�w

ú����Ω��A²OS�n��C

UϕJ�F root ¡w�PD root ¡w�ºí�tºC

ϕ 2. root ¡w�PD root ¡w�ºí�tº

�h root ¡�w� D root ¡�w�

���iH∩�w��² O �CDB2 Ω�wú�w�b�

����l�²UC

e\� DB2 Ω� h� @�

w��ííp��� �{í��C��bw�ºß

��ΩC

{í���Ω��Cibw

�ºß�Y�� DB2 Ω�wú

�C

�����Ω � w�s��ºeAú�n�ú

w����CP�w�s��

P��ΩC

D root w��¡ε

úF root ¡w�PD root ¡w�ºí�tº�A���÷≤D root ¡w��

¡εC�DDNQ�o�¡εAH≤UzP�O�n��D root ¡w�C

ú�¡ε

D root ¡w�úΣ�w�í DB2 Ω�wú�G

v DB2 Query Patroller

� 3 � w� DB2 Connect Personal Edition 21

Page 28: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

v DB2 Net Search Extender

v �w��uDB2 ΩTñ�v

�GD root ¡w�úΣ��w��uDB2 ΩTñ�vAoO]��n

root ���v¡�α���n{íCúLAiHND root ¡w� DB2 Ω

tm���P@íqúW�w��uDB2 ΩTñ�vC

\α�uπ¡ε

D root ¡w�Lk��UC\α�uπG

v uDB2 �z°A� (DAS)v�Σ�÷ⁿOGdascrtBdasdropBdaslistBdasmigr � dasupdt

v tm�U{í

v �εñ�

v úΣ� db2governor W[u²���αO

v buu@q�z{í (WLM)vñAe\bD root DB2 Ω� DB2 A��

Oñ]wNz{íu²��CM�A�ú�ϕ��Nz{íu²��A]ú

�� SQLCODE ��C

v úΣ�t�½s���D root DB2 Ω�����

�α�°�¡ε

D root ¡w�úΣ�UC�α�°�\αG

v bX{��⌡μ Script �@��@

v �e�q

���Ω�w¡ε

D root ¡w�uΣ�μ@��Ω�wCzLksWΣL�Ω�w��C

CX DB2 Ω�wú�

ϕHD root ���¡⌡μ�Adb2ls ⁿOú��ΘXúP≤H root ���

¡⌡μ�ú��ΘXCp��ΩTA��\ db2ls ⁿODDC

DB2 ��

C@�D root ���uαw�@� DB2 Ω�wú���C

DB2 Ω¡ε

bD root ¡w�ñAw��í���@� DB2 ΩCLk��ΣLΩC

DB2 Ω�@�i�Ω���⌡μ

root ¡w��D root ¡w�ibP@qú�úPw�⌠ñP�sbCM

�Au��D r o o t Ω�D r o o t ����α≤s��≤ (��

db2_deinstall ⁿO) D root ΩC

π� root ���v¡�������� DB2 ΩAuα π� root ���

v¡����≤s��≤C

DB2 ΩⁿO

UC DB2 ΩⁿOLkbD root ¡w�ñ��G

db2icrtHD root ���¡w� DB2 Ω�wú��A������tmμ

@ΩCLkbD root ¡w�ñ��≤hΩCM�ApG�nt

m�����ΩAziH��D root ¡w�tmⁿO db2nrcfgC

22 w��tm DB2 Connect Personal Edition

Page 29: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

db2iupdtdb2iupdt ⁿOLk�≤D root ΩC²OAiH��D root ¡w

�tmⁿO (db2nrupdt) �≤sD root DB2 ΩCúLAq�ú�n

≤sD root ΩA]�ª�b≤s DB2 Ω�wú����≤sC

db2idropLk�≤D root ¡w��í�����ΩC���úw� DB2 Ω

�wú�A�α�≤ DB2 ΩC

db2iupgradeD root ¡w�úΣ���CYn��D root ΩA���

db2nrupgrade ⁿOC

�¡ε

LkN root Ω���D root ΩC

ßmw��@�i� DB2 Ω���⌡μ

root ¡w��D root ¡w�ibP@qúWP�sbCúLAu�w�

DB2 Ω�wú���lD root ���A�α⌡μß≥�@ApG

v M��M≤

v sW\α

v w��[ú�

�π ulimit �

UNIX � Linux @�t�W� ulimit ⁿO�]w�°i���Ω�¡ε]pΩ��∩�¡ε�C∩≤ root ΩAΩ�w°A���A≤s��� ulimit

]wA�L��≤�[]wCM�A∩≤D root ΩAuiHbw��í�d

ulimit ]wCpG]wú¼Ah�π�iTºCYn�≤ ulimit ]wAh�

n root ���v¡C

izL⌡μ db2rfe JA�¡ε

D root ¡w��≤h¡εizL⌡μ db2rfe ⁿO�JACUC\α�αObD root

¡w�ñ��Lk��G

v @�t�¼O

v ¬i�� (HA) \α

v b /etc/services ��ñOdA�W�αO

v W[���Ω�¡ε (ulimit) �αOC�αO�A�≤ AIXCbΣL@�t�WA�

�Γ�W[���Ω�¡εC

⌡μu��D root ¡w�� root \αvⁿO (db2rfe)AH��o�\α�αOC⌡

μ db2rfe ⁿOO∩���A�B⌡μ���Oπ� root ���v¡����C

D root ¡�w�ñ��O�¼

@�t�¼OO DB2 Ω�wú��w]O�¼C]�D root ¡w�úΣ�@�

t�¼OA�HpGz∩únbHD root ���¡w� DB2 Ω�wú�ºß⌡

μ db2rfe ⁿOAh��Γ�]wO�¼Cz]iH� ≤sΩ�w�z{ítm(dbm cfg) ��ñ�UC��A�F���G

v clnt_pw_plugin]�ß��� ID/KX� {ítm���

v group_plugin]s�� {ítm���

� 3 � w� DB2 Connect Personal Edition 23

Page 30: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

v srvcon_pw_plugin]°A�tm��ñeJsu���� ID/KX� {í�

HD root ���w� DB2 ú�

HD root ���¡iHw�jí DB2 Ω�wú�C

}lºe

bzHD root ���¡w�⌠≤ DB2 Ω�wú�ºeAnA� root ¡w�PD

root ¡w�ºí�tºAH�D root ¡w��¡εCp�D root w���÷Ω

TA��\yD root ¡w�º[ (Linux � UNIX)zC

HD root ���¡w� DB2 Ω�wú������pUG

v z��α≈�μ�ⁿ�zLΣLΦí�ⁿw� DVDC

v z���i�@ DB2 �������� IDC

��� ID π�UC¡ε��DG

– ��π� guestsBadminsBusers � local H��Dns�

– iH]Apgr� (a–z)B�r (0–9) ��ur� ( _ )

– °�úαWX 8 �r�

– úαH IBMBSYSBSQL ��r}Y

– úαO DB2 Odr (USERSBADMINSBGUESTSBPUBLIC � LOCAL) � SQL

Odr

– Lk��π� DB2 Ω IDBDAS ID �j≈ ID º root M�v�⌠≤u��

� IDvC

– úα]A½�r�

– pGⁿw{s���� IDA�úO��s���� IDA�Tw��� IDG

- �Ωw

- KXS�L�

v znw�ºú��nwΘ�Dú�A�≤ root ���A�A�≤D root ���C

v b AIX 5.3 �WA����uDPB I/O (AIO)vCjP��t���uI/O �¿≡

(IOCP)vC

v z��l�²��O��� DB2 ⌠C

DB2 w�⌠π�UCWhG

– iH]Apgr� (a–z)Bjgr� (A–Z) ��ur� ( _ )

– úαWX 128 �r�

– úα]tμ

– úα]tDσr�

– úαO����

÷≤o�@�

HD root ���¡w� DB2 Ω�wú�A∩≤D root ����Ñ@�AMC½y

íAD root ���bw� DB2 Ω�wú��L�⌡μ⌠≤Sϕ�@Au�nHD

root ���¡nJYiC

24 w��tm DB2 Connect Personal Edition

Page 31: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

{�

Yn⌡μD root ¡w�A�G

1. HD root ���¡nJ

2. ��⌠≤i��Φk�w� DB2 Ω�wú�C ∩�]AG

v uDB2 w�vδF (GUI w�)

v db2_install ⁿO

v ft ��� db2setup ⁿO (Ln��w�)

�G]�D root ���Lk∩w� DB2 Ω�wú���²A�H�ñ �

�ñ�⌠≤ FILE ÷ΣrC

3. w� DB2 Ω�wú�ºßAz��}�s�nJÑq@�AH��D root DB2 Ω

C ��AziH���P�nJÑq@�AeúO�� $HOME/sqllib/

db2profile (A�≤ Bourne Shell � Korn Shell ���) � $HOME/sqllib/

db2chsrc (A�≤ C Shell ���) ]w DB2 Ω⌠�AΣñA$HOME OD root

�����l�²C

U@B

w� DB2 Ω�wú�ºßA�τ�@�t����{�Ω�¡ε (ulimit)CpGú�X

ulimit �p�Ah DB2 ���o�Dw��@�Ω�ú¼��Co���iα��P

DB2 Ω�wt�ñ�C

�� db2rfe bD root w�ñ�� root ¼\α

D root ¡w�ñ���S��\α@}lLk��A²OizL⌡μ db2rfe ⁿO���ª�C

}lºe

�@��n root ���v¡C

{�

Yn��D root ¡w�ñ��Lk���S��\αA�G

1. MΣtmd�C wú�Γ�dtm�G

v $HOME/sqllib/instance/db2rfe.cfgAw��D root DB2 Ω�w]�∩Σw²

tmC

v $HOME/sqllib/cfg/db2rfe.cfg.sampleA�iμtm

Σñ $HOME OD root �����l�²C

2. NΣñ@�dtm��sΣL�mA²�l��O�ú�C

3. °�n≤s�s�tm�C �tm�O db2rfe ⁿO�ΘJC

tm��dpUG

INSTANCENAME=db2inst2SET_ULIMIT=NOENABLE_HA=NOENABLE_OS_AUTHENTICATION=NORESERVE_REMOTE_CONNECTION=NO

**SVCENAME=db2c_db2inst2

� 3 � w� DB2 Connect Personal Edition 25

Page 32: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

**SVCEPORT=48000RESERVE_TEXT_SEARCH_CONNECTION=NO

**SVCENAME_TEXT_SEARCH=db2j_db2inst2**SVCEPORT_TEXT_SEARCH=55000

�G

v DB2 w�{í���±g INSTANCENAME ����

v uαb AIX W�� SET_ULIMIT ��CbΣL@�t�WAπ� root v¡��

���n�]w ulimit �C

v ΣL÷Σr�w]�� NO

v �w]��Pl�� (p SVCENAME�C��H ** ϕ

v pGN��]� YES �BΣπ�⌠≤l��A��z�°��l��A�ú�A

ϕ��Cú��⌠≤≡�úOdC�TOzⁿú�≡�Oi��C

U�ú�@hdAHπN��UCS��\α�wsΦtm�G

v ¬i��

v @�t�¼O

v DB2 σrjM]A�W� db2j_db2inst2 B≡�� 55000�

Yn��o�S��\αA�sΦtm�ApU�G

INSTANCENAME=db2inst2SET_ULIMIT=NOENABLE_HA=YESENABLE_OS_AUTHENTICATION=YESRESERVE_REMOTE_CONNECTION=NO

**SVCENAME=db2c_db2inst2**SVCEPORT=48000

RESERVE_TEXT_SEARCH_CONNECTION=YESSVCENAME_TEXT_SEARCH=db2j_db2inst2SVCEPORT_TEXT_SEARCH=55000

4. H root ���v¡nJC

5. �²� $HOME/sqllib/instance �²AΣñ $HOME NϕD root �����l�²C

6. ��UCyk⌡μ db2rfe ⁿOG

db2rfe -f config_file

Σñ config_file ObBJ � 25�� 3 ñ���tm�C

U@B

YnbD root ¡w�WOd�� root ¼\αA�bM��M≤����s��º

ßA½s⌡μ db2rfe ⁿOC

N��M≤M��D root ¡�w�

N�M≤M��D root ¡w��@�APN�M≤M�� root ¡w��@�

≥��PAu�X��¼pC

}lºe

bN�M≤M��D root ¡w�ºeAz��H��w�D root ¡w����

� ID nJC

26 w��tm DB2 Connect Personal Edition

Page 33: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

pGzwbD root ¡w�ñ�� db2rfe ⁿO�� root \αAh��Σ⌡μ

db2rfe ⁿO����tm�Cz�n�tm�AHbM��M≤ºß½s�� root \

αC

{�

YnN�M≤M��D root ¡w�A�G

1. ��yM��M≤zDDM�z��M≤C

�GinstallFixPack ⁿO� -b ∩�∩D root ¡w��ÑL�C

2. ∩���G⌡μ db2rfe ⁿOC pGzbD root ¡w�ñ�� root ¼\αA�

Bn½s��o�\αAh��½s⌡μ db2rfe ⁿOC⌡μ�ⁿO�n root ��

�v¡C

�GpGzb���� root \α�wsΦ $HOME/sqllib/instance/db2rfe.cfgAh

bM��M≤�ú�∩g�tm�A]�ziHb⌡μ db2rfe ⁿO�½������C²OA]���d $HOME/sqllib/cfg/db2rfe.cfg.sampleCpG�M≤�

JFD r o o t ¡w�i��⌠≤s r o o t \αA$HOME/sqllib/cfg/

db2rfe.cfg.sample �πo�s\αC

�� db2_deinstall �úD root DB2 Ω�wú�]Linux � UNIX��@�ú��� db2_deinstall ⁿO�úD root DB2 Ω�wú���≤�BJC

}lºe

z��b⌡μ db2_deinstall ⁿOºe�εD root ΩC

÷≤o�@�

v �@�A�≤��� root ���v¡w�� DB2 Ω�wú�Ct�@�@��≤�

úw��� root ���v¡w�� DB2 Ω�wú�C

v P root ���@�AD root ���]iH�� db2_deinstall ⁿO��úw� DB2

Ω�wú�CD root ¡w�� db2_deinstall ⁿOπ�P root ¡w��P�

∩�A²ªB���@�∩�G-f sqllibC

v ��NAHD root ���¡⌡μ db2_deinstall ��úw� DB2 Ω�wú��

�≤D root ΩCoP root ¡w�úPAbΣñ⌡μ db2_deinstall ���úw� DB2 Ω�w{í��C

v zúα�����@�t���{í]p rpm � SMIT���ú DB2 Ω�wú

�C

{�

Yn�úw� D root ���w�� DB2 Ω�wú�A�⌡μUC�@G

1. H��w� DB2 Ω�wú����� ID nJC

2. �²� $HOME/sqllib/install �²AΣñ $HOME O�l�²C

3. ⌡μ db2_deinstall ⁿOC

�G

v pG⌡μπ� -a ∩�� db2_deinstall ⁿOAh��ú DB2 Ω�w{í��A

²O⌠≤tm��Odb� sqllib_bk ��≈�²ñC

� 3 � w� DB2 Connect Personal Edition 27

Page 34: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

v pG⌡μπ� -a -f sqllib ∩�� db2_deinstall ⁿOAh��ú�l�²ñ�π� sqllib l�²CpG sqllib ñ�znOd�⌠≤��A���b⌡μ

db2_deinstall -a -f sqllib ºeNΣ�sΣL�mC

v P root ¡w�@�Aw∩D root ¡w�⌡μπ� -F ∩�� db2_deinstallⁿOAYi²D root ����úSw DB2 \αC

28 w��tm DB2 Connect Personal Edition

Page 35: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

� 4 � DB2 Connect qT���

��� DB2 Connect �su�� IBM DB2 for IBM i}lºe

DB2 Connect ú��t���{í∩z IBM DB2 for IBM i t�WΩ��s�vC

÷≤o�@�

Yn]wsuAz�nF�UCΩTG

{�

1. �⌠⌠WCΘJ DSPNETAAYi�o�ΩTC

2. �t�d�}CziHQ�UCΣñ@�ΦíΘJ WRKLIND ⁿOAYi�o�Ω

TG

WRKLIND (*elan)CXA�⌠⌠t�d

WRKLIND (*trlan)CXO�⌠t�d

WRKLIND (*all)CX��t�d

3. D≈WCΘJ DSPNETAAYi�o�ΩTC

4. TCP/IP ≡�A�WCw]�� X’07’6DB (X’07F6C4C2’)CDB2 for i @���

w]�CpGΘJQ�i��rúΦK�AhOWO QCNTEDDMC

5. ÷píΩ�wWCziHΘJ DSPRDBDIREAYi�oo�ΩTC���π@�

MμCbu��mv�μñAt� *LOCAL �rμO���O��wq�ß�

RDBNAMEC pGS� *LOCAL n²AziHsW@�n²A���q°A�W

� DSPNETA ⁿO�o�t�WC

© Copyright IBM Corp. 1993, 2012 29

Page 36: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

�G

dpUG

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 IBM Power Systems °A��oo����A�bUCu@ϕñΘJ�G

ϕ 3. IBM Power Systems �tm��

�� �� d z��

A-1 �⌠⌠W SPIFNET

A-2 �t�d�} 400009451902

A-4 Hostname SYD2101A

A-5 TCP/IP ≡�A�W X’07F6C4C2’ (w]�)

A-6 ÷píΩ�wW NEW_YORK3

p��÷ΩTA��\ DB2 Server for VSE & VM SQL Reference (SC09-2989) ñ�

uDRDA �qv@�C

��� DB2 Connect �su�� DB2 for z/OS}lºe

�DDú�buDB2 Connect °A�v� DB2 Connect �ß P DB2 for z/OS º

í�� TCP/IP ⌠⌠su��÷ⁿC

pGzw� DB2 for z/OS N�Ph�m≤sμ÷ (ΓÑqTw)A��\ DB2 Con-

nect ��ΓU ñ�u���εñ���h�m≤svC

30 w��tm DB2 Connect Personal Edition

Page 37: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

{�

Yn��² DB2 for z/OS �¼�� DB2 Connect �sunDAz��zLUCΦí

�tmqT≤wG

v ytm DB2 for z/OS � TCP/IPz

v

v � 34��ytm DB2 for z/OSz

D≈Ω�w

b�σ≤ñAΩ�w@ⁿO��í�÷píΩ�w�zt� (RDBMS)CP DB2 Con-

nect qT�ΣLt�iα��Ω�w@ⁿ�í�yLúP�ºC DB2 Connect Ny

uΩ�wv]iHⁿG

System zDB2 for z/OS. DB2 for z/OS lt�A ª� LOCATION NAME [H�OC

�� z/OS -display ddf ⁿO�o DB2 °A��mWB⌠�WBIP �}

�≡C

DB2 for z/OS �mOΩ�w°A���@WC��{í����mW�s

� DB2 for z/OS lt�� DB2 for z/OS Ω�@�s�CΩ�@�s�i²

úP DB2 lt�W���{íP�¬��gJ�PΩ�C��{í�� DB2

Ω�@�s�⌠⌠�}�s� DB2 Ω�@��mC�s�� DB2 lt�∩�

�{í�ÑOzq�C

DB2 for z/OS Σ��P DB2 �mW�h�Ω�wA]��mW�ⁿ≤

LinuxB UNIX � Windows �wOWCbs��m�A�wOWi��m

½�m��mOWC�mOWO�m�t@�WCª���εΩ�@�s�

ñ��{í�s��lt�C

u�mWv]wqb Boot Strap Data Set (BSDS) � DSNL004I Tºñ

(LOCATION=location)A��uíΩ�≈α (DDF)v��gJªCu�mW

v�hΣ� 8 �OW�mWA²��{íiH��úP� dbalias W�

s�� 8 �� z/OS °A�C

VSE bΩ�w�� ( Σ DBNAME ��O) ñ⌡μ� DB2 for VSE

VM b CMS Ω�≈� ( Σ DBNAME ��O) ñ⌡μ� DB2 for VM

IBM Power Systems °A�

IBM DB2 for IBM iAIBM i @�t�úi���@íCúDt�Otm�

��W���Uxs�A�h IBM Power Systems °A�Wuαsb@�Ω�

wC

tm DB2 for z/OS � TCP/IP}lºe

�DDí�p≤tm DB2 Connect u@�P DB2 for z/OS � 8 ��≤s��ºí�

TCP/IP qTCo�ⁿON]UC¼pG

v zzL TCP/IP Pμ@D≈Ω�w°A���ms�Ch�D≈su���H�P

�ΦíBzA÷MC@�íp���≡� �A��X ú��PC���s� IP �

}�s��s��mC

� 4 � DB2 Connect qT��� 31

Page 38: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

v ��Ω�w�≤ DB2 for z/OS � 8 ��≤s��WC

v �����nΘúww�C

v DB2 �ßú]w��n�C

{�

1. z��²¼��÷D≈Ω�w°A�� DB2 Connect °A��ΩTA�αzL

TCP/IP su��� DB2 ConnectCw∩zzL TCP/IP �s��C@íD≈°A�A

z���²F�UCΩTG

v TCP/IP services � hosts ��b DB2 Connect u@�W��mG

UNIX � Linux W

/etc/

Windows XP � Windows Server 2003 W

q�O %SystemRoot%\system32\drivers\etc\AΣñ %SystemRoot% Nϕ

Windows w�⌠�²C

ziαQsWD≈ΩT�⌠�W°A�AH�Kbh�t�W�@o���C

v �� DB2 for z/OS D≈Wº�Ñ����mC

v wq� DB2 for z/OS � TCP/IP ≡�C

�G�÷�A�WΩTú�b DB2 Connect u@�P DB2 for z/OS ºíμ½C

≡� 446 wn²��� DB2 Connect u@��qT����w]�C

v D≈� DB2 Connect u@�� TCP/IP �}�D≈WC

v DB2 for z/OS Ω�w°A�� LOCATION NAMEC

v b IBM j¼D≈°A�WVΩ�woX CONNECT nD�A������� ID

PKXC

2. �ó�z��⌠⌠�z�� DB2 for z/OS �z�AnD≤U�o�ΩTC��u

@ϕº��ϕμAHW� DB2 Connect PD≈Ω�w°A�ºí�C@� TCP/IP

suC

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

ϕ 5. D≈W�⌠⌠��

�� í� d� z��

TCP-8 D≈W MVSHOST

TCP-9 D≈ IP �} 9.21.152.100

TCP-10 A�W db2inst1c

TCP-11 ≡� 446 446

32 w��tm DB2 Connect Personal Edition

Page 39: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

ϕ 5. D≈W�⌠⌠�� (�≥)

�� í� d� z��

TCP-12 �mW NEW_YORK3

TCP-13 ��� ID

TCP-14 KX

�G

a. n�oD≈� IP �} TCP-9A�bD≈WΘJG

TSO NETSTAT HOME

b. Yn�o≡� TCP-11A�b DB2Dn�}í�t�ΘxñMΣ DSNL004IC

ϕ 6. DB2 Connect �ß�°A�W�⌠⌠��

�� í� d� z��

TCP-18 D≈W mcook02

TCP-19 IP �} 9.21.27.179

TCP-20 A�W db2inst1c

TCP-21 ≡� 446 446

ϕ 7. DB2 Connect °A�W� DB2 �²��

�� í� d� z��

TCP-30 �IW MVSIPNOD

TCP-31 Ω�wW nyc3

TCP-32 Ω�wOW mvsipdb1

TCP-33 DCS Ω�wW nyc3

3. �¿C@� TCP/IP D≈�u@ϕd��G

a. ±J�≤ DB2 for z/OS D≈ºD≈W� IP �}��]TCP-8 � TCP-

9�C

b. ±J�≤ DB2 Connect u@�ºD≈W� IP �}��]TCP-18 � TCP-

19�C

c. Mwn�≤su�A�W�≡�]TCP-10 � TCP-20A�O TCP-11 � TCP-

21�C

d. Mwzns�� DB2 for z/OS Ω�w°A�� LOCATION NAMEC

e. Mws�D≈Ω�w��n������ ID �KXC

4. bz� System z °A�WG

a. τ�D≈�}�D≈WC

b. τ�≡��A�WC

c. �n�AHT�≡��A�W≤s Services ��C

d. �n�A�H DB2 Connect u@��D≈W� IP �}A≤s hosts �]�

DB2 for z/OS t����u⌠�W°A�v�C

e. �T{b����s�ºeAs�wqw@�C�ó�D≈⌠⌠�z�A��

≤�εH]pG�n��C

� 4 � DB2 Connect qT��� 33

Page 40: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

f. �ó� DB2 for z/OS �z�AH�dzO�π������� IDBKX�Ω�

w LOCATION NAMEC

g. pGD≈t�W� TCP/IP Σ��∩��A���T�≡�∩ DB2 Con-

nect °A�iμ PING �@CpG

ping remote_host_name -p port_number

System z °A��Σ�iHqUC�m�oGhttp://www.ibm.com/servers/eserver/

support/zseries/

tm DB2 for z/OS}lºe

bziH�� DB2 Connect ºeAz� DB2 for z/OS �z���tm DB2 for z/OSA

H�\q DB2 Connect u@��s�C�qNⁿz���≤s�U¡AH�\ DB2

Connect �ßP DB2 for z/OS Ω�w°A���suCp��dA��\ DB2

for z/OS w�σ≤Ghttp://publib.boulder.ibm.com/infocenter/imzic ��\ DB2 for z/OS

w�ΓUñ� DDF w�BJC

��� DB2 Connect �su�� DB2 for VSE & VM}lºe

p�p≤N DB2 Server for VM and VSE ]w���{í°A���÷ΩTA��\

DB2 Server for VSE & VM SQL Reference (SC09-2989) �uDRDA �qv@�C

tmj¼D≈�ñ¼°A��su

bw� DB2 ConnectA�tmΩ�w°A���ⁿqTºßAz�n����í�πΓ

�t�ºí�suC�t��suO��utm�U{í (CA)v�ⁿOμBz�

(CLP) ��¿C

�� CA tmP IBM j¼D≈Ω�w°A��su]Linux � Windows��@�í�p≤��utm�U{í (CA)vAq DB2 Connect u@�s�� IBM j

¼D≈Ω�w°A�CCA O@� DB2 GUI uπAi��tmΩ�wsu�ΣLΩ�

w]wC

}lºe

�Gbºe���ñA��¡xúΣ�uDB2 �zuπv]p CA�C�b� 9 �A

u� Windows x86BWindows x64 (AMD64/EM64T)Bx86 W� LinuxAH� AMD64/

EM64T W� Linux Σ�uDB2 �zuπvCb��¡xWAzúiH�� DB2 ⁿO

μBz� (CLP) �tmP IBM j¼D≈Ω�w°A��suC

v utm�U{ív��w�b DB2 Connect u@�WCutm�U{íviHO IBM

Data Server Client �@íC

v ��tm�°A��ⁿJ≡�ßnDC��w]A°A�w�{í����t

m°A�Wjí�qT≤wAH�ⁿJ≡�ß�suC

34 w��tm DB2 Connect Personal Edition

Page 41: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

÷≤o�@�

z� DB2 Connect u@�iHOUCΣñº@G

IBM Data Server ClientIBM Data Server Client iH��s�� IBM j¼D≈Ω�wC

DB2 Connect °A�

ziHzL DB2 Connect °A�ú��s�� IBM j¼D≈Ω�wC

{�

ziH��UCΦkAQ� CA �tmPΩ�w�suG

v ���ß]w�s��Ω�wC

��\ Installing IBM Data Server Clients ñ�u��tutm�U{ív��ß

]w�tm�wsuvC

v �� CA �s���wC

��\ Installing IBM Data Server Clients ñ�u��tutm�U{ív��ß

]w�tm�wsuvC

�� CLP tmP IBM j¼D≈Ω�w°A��su

ziH�� DB2 ⁿOμBz� (CLP)AΓ�tm DB2 Connect °A�P IBM j¼

D≈Ω�wºí� TCP/IP suCp��� db2dsdriver.cfg tmsu��Ω�A�

�\ db2dsdriver tm���÷DDC

}lºe

b DB2 Connect P IBM j¼D≈Ω�w°A�ºíΓ�tm TCP/IP suºeA�

TOG

v TCP/IP b DB2 Connect °A�P IBM j¼D≈t�WB@C

v zw�OUC���G

– D≈W (hostname) � IP �} (ip_address)

– suA�W (svcename) �≡�/qT≤w ( port_number/tcp)

– ��Ω�wW (target_dbname)

– �Ω�wW (local_dcsname)

– �IW (node_name)

{�

Ynb DB2 Connect °A�P IBM j¼D≈Ω�wºíΓ�tm TCP/IP qTG

1. b DB2 Connect °A�Wtm TCP/IPC��\� 31��ytm DB2 for z/OS �

TCP/IPzC

2. s� TCP/IP �IC��\ Command Reference ñ�uCATALOG TCPIP/TCPIP4/

TCPIP6 NODE ⁿOvC

3. N IBM j¼D≈Ω�ws��uΩ�wsuA� (DCS)vΩ�wC��\ Com-

mand Reference ñ�uCATALOG DCS DATABASE ⁿOvC

� 4 � DB2 Connect qT��� 35

Page 42: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

4. s� IBM j¼D≈Ω�wC��\ Command Reference ñ�uCATALOG DATA-

BASE ⁿOvC

5. N��{í���{ís�� IBM j¼D≈Ω�w°A�C��\� 43��yDB2

Connect W�s�Ω�w��{ízC

6. ��\ SQL ReferenceAVolume 2 ñ�uCONNECT]�¼ 1�»zívDDA�

�� IBM j¼D≈suC

�G

�G ≤ TCP/IP qT≤w��ΦAϕt@� IBM j¼D≈W��≈ó�AiαL

k�Yq TCP/IPC]�A�� TCP/IP �s�� DB2 °A���ß��{íA

��°A�W��∩�Nz{íA��iα�X{ϕ≈�ípCTCP/IP SO_KEEPALIVE

Socket ∩�O����≤�o�ó� TCP/IP suw �C

36 w��tm DB2 Connect Personal Edition

Page 43: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

� 5 � ��

tm IBM j¼D≈Ω�w�s�v

bw� DB2 ConnectA�tmΩ�w°A���ⁿqTºßAz�n����í�πΓ

�t�ºí�suC

��í�p≤��utm�U{í (CA)v� DB2 ⁿOμBz� (CLP) �MΣBs�

�s��Ω�w°A�C

��utm�U{ívjM⌠⌠tmΩ�wsu

ziH��utm�U{í (CA)vjM⌠⌠ñ�Ω�wC

}lºe

bz� jM⌠⌠�tmΩ�wsuºeG

v Twzπ�@���� DB2 ��� IDC

v pGzqw�F DB2 Server � DB2 Connect °A�ú��t��tmsuA�T

Oz���� ID π�Ω� SYSADM � SYSCTRL v¡C

Yo�UCípAjMΦk\αiαLk���t�G

v �≤O�⌠�ñC

v DB2 Administration Server (DAS) S�b�t�W⌡μC

v jMO�C��w]�AjM��y⌠⌠ 1 ϕFo��íiαú≈°����

t�CziH]w DB2DISCOVERYTIME n²��Hⁿw�°��íC

v wtm⌡μjM�⌠⌠A�jMLkΣ�n��t�C

nQbΣ� IPv6 �⌠⌠W�Ttm IPv6 �}�A��NHUXIG

v �t���Cbwt�ñC

v �utm�U{íiÑ°�v�Σ��Tatm IPv6 suC

{�

� jM⌠⌠�tmΩ�wsuG

1. H��� DB2 ��� ID nJt�C

2. �� CACziHq Windows W�u}lv\αϕA�Ob Windows � Linux t

�W�� db2ca ⁿOA��� CAC

3. b CA \αϕC�∩�UA∩��δFsWΩ�wCY�}�sWΩ�wδFC

4. ∩�jM⌠⌠ΩsA�÷@UU@BC

5. ÷ΓUwt� Σ�Ω�¿ACX�ßw���t�A��÷ΓUΣLt�

Σ�Ω�¿ACX⌠⌠W���t�C pG�CX⌠≤t�AziH÷@UsW

t��ⁿw@�t�CsWt�ºßAª�πbwt�MμñC

6. i}z����t���A�z�QsW�Ω�w�εC∩�Ω�wC÷U@

BC

© Copyright IBM Corp. 1993, 2012 37

Page 44: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

7. bΩ�wOWμ�ñΣJ�Ω�wOWA�b��μ�ñ∩�aΣJií��

�w���C

8. pGzp��� ODBCA�No�Ω�wn²¿ ODBC Ω���C��w�

ODBCAΦi⌡μo�@�C

9. ÷@U�¿C{bziH��wsW�Ω�wC÷@U÷¼H�⌠ CAC

��utm�U{ívΓ�tmΩ�wsu

pGz�Qns��Ω�wAH��Ω�w�n�t��ΩTAhziH�μΘJ�

�tmΩTC�Φk�ⁿ��ⁿOμBz��ΘJⁿOA²OªO���Φk�e

{C

}lºe

bz��utm�U{í (CA)vΓ�tmΩ�w�suºeG

v �TOzπ�nsuΩ�w��� DB2 ��� IDC

v pGzqw�F DB2 °A�� DB2 Connect °A�ú��t��tmsuA�T

Oz���� ID π�Ω�w�z{íΩ� SYSADM � SYSCTRL v¡C

{�

Yn�� CA �tm�w�suG

1. H��� DB2 ��� ID nJt�C

2. �� CACiHq Windows �u}lv\αϕ��� db2ca ⁿO�� CAC

3. b CA \αϕC�∩�UA∩��δFsWΩ�wC

4. ∩��μtmPΩ�w�suΩsAMß÷@UU@BC

5. pGzn�� Lightweight Directory Access Protocol (LDAP)A�∩�Pn�@�

DB2 �²�m�∩��ΩsC÷U@BC

6. qqT≤wMμ∩�∩�≤zQn���qT≤w�ΩsC (��G�\��π

APPCBAPPN � NetBIOS ∩�A²OwgúAΣ�o�∩�C) pGz�t�w

w� DB2 ConnectA�Bz∩� TCP/IPAhiH∩�Ω�wΩ�W�≤D≈�

OS/400 t�o�∩�CpGz∩�o��∩�A��@�∩�²z∩�zn∩D

≈� OS/400® Ω�w���su�¼C

v nzL DB2 Connect hD��suA�∩�g�hDs� °A�ΩsC

v Yn����suA�∩��su °A�ΩsC

÷U@BC

7. ΘJ�nqT≤w��AMß÷@UU@BC

8. bΩ�wWμ�ñΘJznsW��Ω�w�Ω�wOWAMßbΩ�wO

Wμ�ñΘJ�Ω�wOWC pGznsWD≈� OS/400 Ω�wA�bΩ�w

Wμ�ñAΣJ OS/390® � z/OS Ω�w��mWBOS/400 Ω�w� RDB

WA� VSE � VM Ω�w� DBNAMECziH∩b��ñsWí��Ω�

w���C

÷U@BC

9. pGzp��� ODBCA�No�Ω�wn²¿ ODBC Ω���Cb⌡μ�@�

ºeA�Twww� ODBCC÷U@BC

38 w��tm DB2 Connect Personal Edition

Page 45: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

10. bⁿw�I∩�°íñA∩�@�t�AMßΘJzQns�ºΩ�wt���

ΩWC

11. bⁿwt�∩�°íñATwt�WBD≈W�@�t�O�TCbo�

e�ñ�ΩTO�≤tm�z�ICziH∩�aΘJ��C÷U@BC

12. bⁿww�∩�°íñAⁿwn��O�w�∩�C

13. ÷@U�¿Cz{bα���Ω�wC�∩��⌠\αϕ�@H÷¼ CAC

��utm�U{ív��Ω�wsu

btmºßA≤utm�U{ívñ��z�Ω�wsuC

{�

Yn���wsuA�G

1. ��tm�U{íC

2. ���°�ñ�Ω�wA�qw∩�\αϕ∩���suC���}���su

°íC

3. ∩�@�HWzn���su�¼ (w]� CLI�CziHP���h��¼CΘJ�Ω�w������ ID MKXAMß÷@U��suC pGsu¿\Ab�

G���X{@hT{�su�TºCpGsu��óAzN¼@hí�T

ºCYn�≤⌠≤ziαúTⁿw�]w�A�b��°�ñ∩�Ω�wAMß

q∩��\αϕ��∩��≤Ω�wC

U@B

]w°A�H��}o⌠� (p IBM Data Studio) �Aziα�b�l� DB2 su

WJ��Tº SQL30081NCiα��]O�Ω�w°A���⌡≡ú�\��s

uCb�ípUA�τ��⌡≡wAϕatmH�ⁿ���ß�sunDC

�ú DCS (D≈Ω�w)��uiÑtm�U{ívºO�� DCS ����ú DCS (D≈Ω�w) ��C

÷≤o�@�

1. pGzúbuiÑ�°vñA�q�°\αϕ∩�iÑ�°C

2. ∩�n�ú� DCS ��C

3. bw∩�\αϕñ÷@U�ú DCSCY�}�T{°íAzibΣñτ�z�∩C

Σ�� DB2 ��yÑ

DB2 �� DB2 yÑΣ�iH��°A�s�yÑ��ßs�yÑC°A�s�

yÑNα½jí�TºBí�� DB2 ����C�ßs�yÑNα½ IBM

Data Server Runtime Client �≤AΣñ]AjíTº�Y�í�σ≤C

°A�s�yÑ]AG�Φ�σ σBJσBª�σBΓ⌡σBkσBwσBqj

QσBΘσB�σB�σBi⌡σBXσB�ΘñσBΦZ σBτσσAH�c

ΘñσC

� 5 � �� 39

Page 46: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

�ßs�yÑ]AGⁿ�BσBO[Q�σBJ�JΦ�σBⁿ⌡σB��σB�

B�σBI QσB�σ σB�¿º�σBÑ∩JσBÑ�º�σAH�g�

ΣσC

�únN DB2 ú�Σ��yÑP DB2 �Σ��yÑVcCDB2 ú�Σ��yÑA

]NOΩ�iH���yÑCo�yÑO DB2 �Σ�ºyÑ�W�C

HzΩa�yÑπuDB2 w�vδF (Linux � UNIX)

db2setup ⁿO�d�@�t�AHPw{s�yÑ]wCpG db2setup Σ�z@�t��yÑ]wAhbπuDB2 w�vδF�AN���yÑC

pGz�t����P�rX�A²yÑ⌠�WP DB2 �Σ��yÑ⌠�Wú

PAz�iΘJUCⁿOANz� LANG ⌠���]�Aϕ��AHd�α½ß�

db2setupG

bourne (sh)Bkorn (ksh) � bash ShellG

LANG=<locale>export LANG

C ShellG

setenv LANG <locale>

Σñ locale O DB2 �Σ��yÑ⌠�C

HΣLyÑ⌡μuDB2 w�vδF��yÑ ID

Yn��Pqúw]yÑúP�yÑ�⌡μuDB2 w�vδFAiHΓ���uDB2 w

�vδFA�ⁿwyÑ IDC�yÑ��i�≤n⌡μw��¡xWC

b Windows @�t�WAziH⌡μ setup.exe �ft�� -i ��AHⁿww�@�N���yÑ�Γ�r�yÑXC

b Linux � UNIX @�t�WA��z]w LANG ⌠���AHz�ΩayÑπuDB2 w�vδFC

ϕ 8. yÑ ID

yÑ yÑ ID

ⁿ�Bσ]�A�≤ Windows ¡x� ar

�Φ�σ σ br

O[Q�σ bg

�Θñσ cn

cΘñσ tw

J�JΦ�σ hr

Jσ cz

ª�σ dk

ⁿ⌡σ nl

σ en

Γ⌡σ fi

40 w��tm DB2 Connect Personal Edition

Page 47: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

ϕ 8. yÑ ID (�≥)

yÑ yÑ ID

kσ fr

wσ de

��σ el

I Qσ hu

qjQσ it

Θσ jp

�σ kr

�σ no

i⌡σ pl

�σ σ pt

�¿º�σ ro

Xσ ru

Ñ∩Jσ sk

Ñ�º�σ sl

ΦZ σ es

τσσ se

g�Σσ tr

�≤ DB2 ú���yÑ (Windows)DB2 �yÑOX{bTºBí���uπ�W�yÑCw� DB2 ú��A�w

�@�HW�yÑΣ��∩�Cw�ºßAziHN DB2 �yÑ�≤�t@�ww

���yÑC

}lºe

�únN DB2 ú�Σ��yÑP DB2 �Σ��yÑVcCDB2 ú�Σ��yÑA

OⁿΩ�iH���yÑCo�yÑO DB2 �Σ�ºyÑ�W�C

z��Nn��� DB2 �yÑw�bt�WC��uDB2 w�vδFw� DB2 ú

��A�∩��w� DB2 ú��yÑCpGN DB2 ú���yÑ�≤���w

��ⁿΣ��yÑAh DB2 ú��yÑ�²w]�@�t�yÑAYúΣ��y

ÑAh]�yC

÷≤o�@�

b Windows W�≤ DB2 ú��yÑA�n�≤ Windows @�t��w]yÑ]

wC

{�

Yn�≤ Windows @�t�W� DB2 ú��yÑG

1. zLu�εxv∩�a�yÑ∩�C

2. ba∩�������μíUA∩�Aϕ�yÑCb Windows 2008 � Win-

dows Vista]�≤s��WA�w∩o�BJ��μí��C

� 5 � �� 41

Page 48: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

3. ba∩�����mUA∩�∩�≤AϕyÑ��mC

4. biÑ���D Unicode {í�yÑUA∩�Aϕ�yÑCb Windows 2008 �

Windows Vista]�≤s��WA≤t��z���D Unicode {í�yÑUA÷

@U�≤t�yÑa�∩�Aϕ�yÑCMßAt��nDz½s}≈A�÷@

U�°C

5. biÑ���w]���bß]wUA�∩M���]w �e����bßH�

w]���]w�Φ�Cb Windows 2008 � Windows Vista]�≤s��WA

≤t��z���Od�bßUA÷@U�s Od�bßA��∩zn�syÑ

]w�Σñ�bßC

6. t��nDz½s}≈Aºßo��≤����C

U@B

���@�t�í�AH�o�≤w]t�yÑ��[ΩTC

�≤ DB2 ��yÑ (Linux � UNIX)DB2 ú���yÑOX{bTºBí���íuπ�W�yÑCw� DB2 ú�

�A�w�@�HW�yÑΣ��∩�CpGzbw�ºßAQN�yÑ�≤�t

@�ww���yÑA����@�ñºz�BJC

}lºe

�únN DB2 ú�Σ��yÑP DB2 �Σ��yÑVcCDB2 ú�Σ��yÑA

]NOΩ� iH���yÑAO DB2 �Σ�ºyÑ�W�C

z��Nn��� DB2 �yÑ�Σ�w�bt�WC��uDB2 w�vδFw�

DB2 �A�∩��w� DB2 �yÑΣ�CpGN DB2 ú���yÑ�≤���

w��ⁿΣ��yÑADB2 �yÑNw]�@�t�yÑCpGúΣ�@�t�y

ÑA�Nσ�@� DB2 �yÑC

��uDB2 w�vδF���uΩayÑM≤v�w� DB2 ú��A�∩��w�

DB2 �yÑΣ�C

÷≤o�@�

Yn�dt�Wi����yÑ⌠�A�⌡μ $ locale -a ⁿOC

Yn�≤ DB2 �yÑA�N LANG ⌠���]�zQn�yÑ⌠�C

{�

Y� bourne (sh)Bkorn (ksh) � bash ShellG

LANG=<locale>export LANG

Y� C ShellG

setenv LANG <locale>

pAYnHky@� DB2 ú���Ah��w�kyyÑΣ�A�B��N

LANG ⌠���]�kyyÑ⌠�Ap fr_FRC

42 w��tm DB2 Connect Personal Edition

Page 49: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

�G

rΩ��α½

b≈�ºí�er�Ω��A��²Nªα½¿�¼≈�i���íC

pAb DB2 Connect °A��D≈� System i Ω�w°A�ºí�eΩ��Aq�

�q°A�rX�૨D≈ CCSIDA!ºτMCpGΓx≈���úP�rX��

CCSIDAh�NrXIq@�rX�� CCSID ∩Mt@�C�α½q�Ob�¼�

B⌡μC

�e� Ω�w�r�Ω�O SQL »zí�ΘJΩ���¿C�q Ω�w�e�r

�Ω�hO ΘXΩ���¿C�����Ω��ΘXΩ�ú�Qα½CpA� FOR

BIT DATA lyi��μñ�Ω�C�hApGΓx≈��úP�rX�� CCSIDA

���ΘJ�ΘXr�Ω�ú�Qα½C

±ΦíApG�� DB2 Connect �s�Ω�Ah�o�UCíG

1. DB2 Connect ��e SQL »zí�NΩ�ΘJ System zC

2. DB2 for z/OS N SQL »zí�Ω�૨D≈°A��rX�AMßBz�Ω�C

3. DB2 for z/OS N�G� � DB2 Connect °A�C

4. DB2 Connect N�G૨���⌠��rX�C

∩≤VyÑAIBM wwqF@�Sϕ� BiDi CCSIDSAB DB2 Connect ]Σ�o

���C

pGΩ�w°A��V��úP≤�ß�V��Azi��o�Sϕ� CCSIDS

�BztºC

p� DB2 Connect rX�PD≈� System i °A� CCSID ºí�Σ�α½�÷ΩTA

��\��M��X�rX�DDC

}oΩ�w��{í

b�� DB2 Connect �⌠�ñs��⌡μ��{í�A��o�e{�Sw�qC

DB2 Connect W�s�Ω�w��{í

}lºe

z��NΩ�w��{í]�JB�XB½�BuⁿOμBz�v�M CLI s���A

s�C@�Ω�wºßA�αP�Ω�w@���o���{íCb⌠⌠⌠�ñA

pGz���h��ßObúP�@�t�W⌡μA��≤úP� DB2 ���A�

h�Ah��bC�@�t�� DB2 ���Xñs���{í@�C

s���{í���Ω�]AªO@�½≤A�½≤]Aqμ@���BzSw SQL »

zí�n�ΩTC

s�����búP� .lst ��ñAo����≤w��²]Y� WindowsAq�

O sqllib�U� bnd �²CC���∩°A�íO�@�C

� 5 � �� 43

Page 50: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

{�

v YnN��{í���{ís� IBM j¼D≈Ω�w°A�A�s�� IBM j

¼D≈°A�A���UCd@�d�G

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

v °z�u@�@�t��wA��UCΣñ@�ΦkANΩ�w��{ís� DB2

Ω�wG

– tm�U{í (CA)G

1. �� CAC

2. ∩�zQn���{íPΣs��Ω�wC

3. �½kΣ÷@UA�∩�s�C

4. ∩�ns����{í���C

5. sW⌠≤Qn�s�∩�C

6. ΘJNPΩ�ws����� ID �KXC��� ID ���vNs�Ω�]

s�Ω�wWC÷@Us�C

– ⁿOμBz�G

1. �≤ bnd �²AoO x:\sqllib\bndAΣñ x: Nϕww� DB2 ���≈C

2. YnsuΩ�wA�buⁿOñ�v�uⁿOμBz�vñΘJUCⁿ

OG

connect to database_alias

Σñ database_alias NϕzQnsu�Ω�wOWC

3. buⁿOñ�v�uⁿOμBz�vñΘJUCⁿOG

"bind @db2ubind.lst messages bind.msg grant public""bind @db2cli.lst messages clibind.msg grant public"

bo�lñAbind.msg � clibind.msg OΘXTº�A� EXECUTE �

BINDADD M�vN��� publicC

4. oXUCⁿOAi½]PΩ�w�s�G

connect reset

�G

1. db2ubind.lst �t�b��Ω�w��{í�M≤����s��� (.bnd) �M

μCdb2cli.lst ��t�b�� CLI M DB2 ODBC X�{í�M≤����

s��� (.bnd) MμC

2. s�iαnßWX�α�¿C

3. pGz� BINDADD v¡Ah�@��� CLI � ODBC X�{í�A��

�s� CLI M≤CpGz�����{í�s�Ω�wAhi��utm�U

{ív�us�v≈α (�ⁿOμBz�) �⌡μs��@C

44 w��tm DB2 Connect Personal Edition

Page 51: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

⌡μz�v���{í

ziHQ�ww�� IBM Data Server Client ��m�⌡μ DB2 ��{íC

UCX���{íúiHs� DB2 Ω�wG

v �� IBM Data Server Client }o���{íA]A Oí SQLBAPIBxs{�B

���wq�τ�� CLI �Is

v ODBC ��{í

v �� JDBC � SQLJ �� Java ��{í

v PHP ��{í

v Ruby � Ruby on Rails ��{í

v Perl ��{í

v Python ��{í

b Windows @�t�WAUC��]iHs� DB2 �wG

v H Microsoft Visual Basic � Microsoft Visual C++ Ω@� ActiveX Data Objects (ADO)

v ½≤s�M O (OLE) ����í]UDF �xs{��

v ½≤s�M OΩ�w (OLE DB) ϕμτ�

Yn⌡μ��{íA�⌡μUC�@G

1. �Tw°A�wtm�¿A�b⌡μñC

2. b DB2 °A�WA�TwΩ�w�z{íwb��{íPΣs��Ω�w°A�W

��CYΣ����A�b����{íºeAb°A�oX db2start ⁿOC

3. TwziP��{í���ºΩ�w�s�C

4. (∩�a) s��n���AHΣ���ñ�Ω�w��{íX�{íC

5. ⌡μ���{íC

�úw� DB2 Connectb��Y�� Aziα�nN DB2 Connect ú�qt�ñ�úC�ú��úw� DB2

Connect ú���DO��z���@�t��e{C

�úw� DB2 ú� (Windows)�@�ú�q Windows @�t����ú DB2 ú��BJC�ϕúA�n{s� DB2

Ω�Ω�w�A�⌡μ�@�C

÷≤o�@�

pGz�úw�w] DB2 ��ABbt�W��ΣL DB2 ��Ahb�≥iμ�ú

w�ºeA��� db2swtch ⁿO�∩s�w]��C�BApGuDB2 �z°A�

(DAS)vOb��ú���U⌡μA�N DAS ����ú���ñC�hAb�úw�

ºßA��� db2admin create ⁿO½� DASA�B�½stm DASAY�\α�α

B@C

Ynq Windows �ú DB2 ú�G

� 5 � �� 45

Page 52: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

{�

1. (∩���) ��u�εñ�v� drop database ⁿOA��≤��Ω�wC�TwzúA�no�Ω�wCpG�≤Ω�wAzNóh��Ω�C

2. �ε�� DB2 {��A�CoiHzLuWindows A�ve��oX db2stop ⁿO��¿Cb���ú DB2 ú�ºeApG DB2 A��{����εAzN¼

@��iAΣñt�bO�ΘñOd DB2 DLL �{��A�MμCpGzN�

�usW/�ú{ív��ú DB2 ú�AhoO∩�BJC

3. �ú DB2 ú��Γ�∩�G

sW/�ú{í

��izLuWindows �εxvs��usW/�ú{ív°í��ú DB2

ú�Cp�q Windows @�t��únΘú���÷ΩTA��\@�t

��í�C

db2unins ⁿO

ziHq DB2DIR\bin �²⌡μ db2unins ⁿOA��ú DB2 ú�B\α

�yÑC���ⁿOAiHQ� /p ��P��úw�h� DB2 ú�Cz

iH�� ����úw� DB2 ú�B\α�yÑ (�� /u ���Cp��÷ΩTA��\ db2unins ⁿODDC

�G

U@B

≥��OA��u�εx - sW/�ú{ív≈αA���� db2unins /p ⁿO�db2unins /u ⁿOA�ú@wα≈�ú DB2 ú�C�ϕºe�Φkó�A����

�UC�úw�∩�C

Ynq Windows t�Wjε�ú�í DB2 ��A�⌡μ db2unins /f ⁿOC�ⁿO�jε�úw�t�W��í DB2 ��CúF���Ω�]p DB2 Ω�w�º�A

�jεRú�í eCbQ� /f ��⌡μ�ⁿOºeA��\ db2unins ⁿOH�o�Ω�C

�úw� DB2 Ω�wú�]Linux � UNIX��@�ú�q Linux � UNIX @�t��ú DB2 Ω�wú��BJC

÷≤o�@�

ú�n�@�AYiw�s��� DB2 Ω�wú�CLinux � UNIX W�C@� DB2

Ω�wú���úπ�úP�w�⌠A]�iH�sbP@íqúWC

�G�@�A�≤�� root ���v¡w�� DB2 Ω�wú�C�ODDi��p≤

�úw�HD root ���¡w�� DB2 Ω�wú�C

{�

Yn�ú DB2 Ω�wú�A�⌡μUC�@G

1. ∩���G�≤��Ω�wC ziH��u�εñ�v� DROP DATABASE ⁿO��≤Ω�wC�≤Ω²�²�≤Ω�w�A��t�W�Ω�w����Od�

πC

2. �εuDB2 �z°A�vC ��\mw� DB2 °A�nΓUC

46 w��tm DB2 Connect Personal Edition

Page 53: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

3. �úuDB2 �z°A�v�⌡μ dasupdt ⁿOANuDB2 �z°A�v≤s�Σ

Lw�⌠C Yn�úuDB2 �z°A�vA��\ w� DB2 °A�ΓUC

4. �ε�� DB2 ΩC ��\mw� DB2 °A�nΓUC

5. �ú DB2 Ω�⌡μ db2iupdt ⁿOANΩ≤s�ΣLw�⌠C Yn�ú DB2

ΩA��\ w� DB2 °A�ΓUC

6. �ú DB2 Ω�wú�C ��\mw� DB2 °A�nΓUC

� 5 � �� 47

Page 54: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

48 w��tm DB2 Connect Personal Edition

Page 55: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

�² A. DB2 �NΩTº[

ziHzLUCuπ�Φk��o DB2 �NΩTG

v DB2 ΩTñ�

– DD (@�Bº���DD)

– uDB2 uπv�í�

– d{í

– ⁿ���

v DB2 �y

– PDF � (iUⁿ)

– PDF � (q DB2 PDF DVD)

– X��

v ⁿOμí�

– ⁿOí�

– Tºí�

�GuDB2 ΩTñ�vDD�≤sWv¬≤ PDF �LΩ�yCYn�o�sΩTA�

bσ≤@≤s�Nw�ª�A�yXuDB2 ΩTñ�v(ibm.com)C

ziHb ibm.com WuWs�ΣL DB2 �NΩTAp TechNotesB���� IBM

Redbooks®X��C�s� DB2 Information Management software ��w⌠� (http://

www.ibm.com/software/data/sw-library/)C

σ≤Nú�d

��D�½°z∩ DB2 σ≤�NúCpGz�p≤∩i DB2 σ≤���A��eq

ll≤� [email protected] DB2 σ≤ñ�\¬z���NúA²ú��� �C

�ú�Swd�iα�mA²��iH≤R�A�z��DCpGn∩Sw�D

D�í��ú�NúA�[WDD�D� URLC

�"��o�qll≤�}�puDB2 �ßΣ�ñ�vCpG�σ≤��M� DB2

�N�DA�sϕa IBM A�ñ�H�o≤UC

LΩ�y� PDF μí� DB2 �NO�

U�Uϕí�iquIBM X��ñ�v] �≤ www.ibm.com/e-business/linkweb/

publications/servlet/pbi.wss��o DB2 ��wC PDF μí� 9.7 � σ�ΓUiH

q www.ibm.com/support/docview.wss?uid=swg27015148 UⁿA� PDF μí� DB2

���ΓUiHq www.ibm.com/support/docview.wss?uid=swg27015149 UⁿC

���y÷MϕμⁿX�LΩ�A²iαbz�Ωa�a�Lkú�C

C�≤sΓU�A��Y�W[C�Twz\¬�O�s���ΓUACpUC

�GuDB2 ΩTñ�v�≤sWv¬≤ PDF �LΩ�yC

© Copyright IBM Corp. 1993, 2012 49

Page 56: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

ϕ 9. DB2 �NΩT

W � �LΩ� e�≤s

Administrative API Refer-

ence

SC27-2435-03 O 2010 � 9 δ

Administrative Routines

and Views

SC27-2436-03 � 2010 � 9 δ

Call Level Interface Guide

and ReferenceAVolume 1

SC27-2437-03 O 2010 � 9 δ

Call Level Interface Guide

and ReferenceAVolume 2

SC27-2438-03 O 2010 � 9 δ

Command Reference SC27-2439-03 O 2010 � 9 δ

Data Movement Utilities

Guide and Reference

SC27-2440-01 O 2009 � 8 δ

Data Recovery and High

Availability Guide and

Reference

SC27-2441-03 O 2010 � 9 δ

Database Administration

Concepts and Configura-

tion Reference

SC27-2442-03 O 2010 � 9 δ

Database Monitoring

Guide and Reference

SC27-2458-03 O 2010 � 9 δ

Database Security Guide SC27-2443-02 O 2009 � 11 δ

DB2 Text Search Guide SC27-2459-03 O 2010 � 9 δ

Developing ADO.NET and

OLE DB Applications

SC27-2444-02 O 2009 � 11 δ

Developing Embedded

SQL Applications

SC27-2445-02 O 2009 � 11 δ

Developing Java Applica-

tions

SC27-2446-03 O 2010 � 9 δ

Developing Perl, PHP,

Python, and Ruby on

Rails Applications

SC27-2447-02 � 2010 � 9 δ

Developing User-defined

Routines (SQL and Exter-

nal)

SC27-2448-02 O 2009 � 11 δ

Gett ing Started with

Database Application

Development

GI11-9410-02 O 2009 � 11 δ

Linux � Windows W

DB2 w���zJ�

GI13-0694-00 O 2009 � 8 δ

Globalization Guide SC27-2449-00 O 2009 � 8 δ

w� DB2 °A� GC40-2454-03 O 2010 � 9 δ

Ins ta l l ing IBM Data

Server Clients

GC27-2454-02 � 2010 � 9 δ

Message Reference Vol-

ume 1

SC27-2450-01 � 2009 � 8 δ

50 w��tm DB2 Connect Personal Edition

Page 57: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

ϕ 9. DB2 �NΩT (�≥)

W � �LΩ� e�≤s

Message Reference Vol-

ume 2

SC27-2451-01 � 2009 � 8 δ

Net Search Extender

Administration and User’s

Guide

SC27-2469-02 � 2010 � 9 δ

Partitioning and Cluster-

ing Guide

SC27-2453-02 O 2009 � 11 δ

pureXML Guide SC27-2465-02 O 2009 � 11 δ

Query Patroller Adminis-

tration and User’s Guide

SC27-2467-00 � 2009 � 8 δ

Spatial Extender and

Geodetic Data Manage-

ment Feature User’s

Guide and Reference

SC27-2468-02 � 2010 � 9 δ

SQL Procedural Lan-

guages : App l i ca t i on

Enablement and Support

SC27-2470-03 O 2010 � 9 δ

SQL ReferenceAVolume

1

SC27-2456-03 O 2010 � 9 δ

SQL ReferenceAVolume

2

SC27-2457-03 O 2010 � 9 δ

Troubleshooting and Tun-

ing Database Perfor-

mance

SC27-2461-03 O 2010 � 9 δ

��� DB2 9.7 � SC40-2453-03 O 2010 � 9 δ

Visual Explain ⁿ��� SC40-2462-00 � 2009 � 8 δ

DB2 9.7 ���s°º SC40-2459-03 O 2010 � 9 δ

Workload Manager Guide

and Reference

SC27-2464-03 O 2010 � 9 δ

XQuery Reference SC27-2466-01 � 2009 � 11 δ

ϕ 10. DB2 Connect - Sw��NΩT

W � �LΩ� e�≤s

w��tm DB2 Con-

nect Personal Edition

SC40-2456-03 O 2010 � 9 δ

w��tm DB2 Con-

nect °A�

SC40-2458-03 O 2010 � 9 δ

DB2 Connect ��ΓU SC40-2457-02 O 2010 � 9 δ

�² A. DB2 �NΩTº[ 51

Page 58: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

ϕ 11. Information Integration �NΩT

W � �LΩ� e�≤s

Information Integration:

Administration Guide for

Federated Systems

SC19-1020-02 O 2009 � 8 δ

Information Integration:

ASNCLP Program Refer-

ence for Replication and

Event Publishing

SC19-1018-04 O 2009 � 8 δ

Information Integration:

Configuration Guide for

Federated Data Sources

SC19-1034-02 � 2009 � 8 δ

Information Integration:

SQL Replication Guide

and Reference

SC19-1030-02 O 2009 � 8 δ

Information Integration:

Introduction to Replica-

tion and Event Publish-

ing

GC19-1028-02 O 2009 � 8 δ

q� DB2 L�y

÷≤o�@�

pGz�nq� DB2 LΩ�yA\hΩa�a��⌠�í�ú�uWq�A�A²�

D��Ωa�a��⌠�Op�Cz@�iHVϕa� IBM ��Nϕq� DB2 L

Ω�yC�OϕADB2 PDF σ≤ DVD W�Y�ql��S�LΩ�CpADB2 Mes-

sage Reference �⌠@US�LΩ�C

ziHV IBM IOq�uDB2 PDF σ≤vDVD W\h DB2 �y�LΩ�C��z

qμ��μaIAz]\iHq IBM Publications Center buWq��yCpGz�Ω

a�a�úú�uWq�Ah@wiHVϕa� IBM ��Nϕq�LΩ�� DB2 �

yC��NA�DuDB2 PDF σ≤vDVD W����yúú�LΩ�C

�Gp��sM��π� DB2 σ≤A�yXuDB2 ΩTñ�vA⌠}� http://

publib.boulder.ibm.com/infocenter/db2luw/v9r7C

Ynq� DB2 L�yG

{�

v YnA�z�Ωa�a�O�iHbuWq�LΩ�� DB2 �yA�d\ IBM Pub-

lications CenterA⌠}� http://www.ibm.com/shop/publications/orderCz��∩�ΩaB

a��yÑ�αs�X��q�ΩTA�ϕ�A�≤z�ba�q�ⁿC

v YnVϕa� IBM ��Nϕq� DB2 LΩ�yG

1. qUCΣñ@�⌠�AΣXϕa��Nϕ�pΩTG

– IBM directory of world wide contactsA⌠}� www.ibm.com/planetwide

52 w��tm DB2 Connect Personal Edition

Page 59: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

– IBM Publications ⌠�A⌠}� http://www.ibm.com/shop/publications/orderCz

��∩�ΩaBa��yÑAHs�z�ba��AϕX����Cb�⌠

�WAϕ� ″About this site″ ��C

2. ��q�q�A�ⁿwznq� DB2 X��C

3. �ú���NϕzQnq���yW���Cp��W���A��\� 49

��yLΩ�y� PDF μí� DB2 �NO�zC

qⁿOμBz�π� SQL ¼Aí�

DB2 ú��w∩°≤� iαO SQL »zí�G� SQLSTATE �C SQLSTATE í

�i�� SQL ¼A� SQL ¼A�OrX�NqC

{�

Yn�� SQL ¼Aí�A�}�ⁿOμBz��ΘJG

? sqlstate � ? class code

Σñ sqlstate Nϕ���¡�� SQL ¼AA� class code Nϕ SQL ¼A�eΓ��C

pA? 08003 iπ 08003 SQL ¼A�í�A� ? 08 hNπ 08 �OX�í�

s�úP���uDB2 ΩTñ�v

÷≤o�@�

÷≤ DB2 9.8 ��DDAuDB2 ΩTñ�v� URL � http://publib.boulder.ibm.com/

infocenter/db2luw/v9r8/C

÷≤ DB2 9.7 ��DDAuDB2 ΩTñ�v� URL � http://publib.boulder.ibm.com/

infocenter/db2luw/v9r7/C

÷≤ DB2 9.5 ��DDAuDB2 ΩTñ�v� URL � http://publib.boulder.ibm.com/

infocenter/db2luw/v9r5C

÷≤ DB2 9.1 ��DDAuDB2 ΩTñ�v� URL � http://publib.boulder.ibm.com/

infocenter/db2luw/v9/C

÷≤ DB2 � 8 ��DDA��uDB2 ΩTñ�v� URLGhttp://publib.boulder.ibm.com/

infocenter/db2luw/v8/C

buDB2 ΩTñ�vñHz�n�yÑπ�DD

÷≤o�@�

DB2 ΩTñ����Hs²��n]w�ⁿw�yÑ�πDDCpGDD���¿

z�n�yÑAh DB2 ΩTñ��Hσπ�DDC

{�

v Ynb Internet Explorer s²�ñAHz�n�yÑ�πDDG

1. b Internet Explorer ñA÷@Uuπ —> ⌠�⌠⌠∩� —> yÑ... ÷sC���}�uyÑ�n]wv°íC

�² A. DB2 �NΩTº[ 53

Page 60: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

2. TwwNz�n�yÑⁿw�yÑMμñ��@���C

– YnNsyÑsWMμñA�÷@UsW... ÷sC

�GsWyÑ�úO�qúπ�H��nyÑπDD����r¼C

– YnNyÑ�MμA�∩�yÑA÷@UW�÷sA�yÑ¿�y

ÑMμ��@�yÑ�εC

3. ½sπz��AHz�n�yÑ�πuDB2 ΩTñ�vC

v Ynb Firefox � Mozilla s²�ñHz�n�yÑ�πDDG

1. ∩�uπ —> ∩� —> iÑ∩��yÑ�qñ�÷sCu�n]wv°íñ

�πuyÑve�C

2. TwwNz�n�yÑⁿw�yÑMμñ��@���C

– YnNsyÑsWMμñA�÷@UsW... ÷sAqusWyÑv°íñ∩�yÑC

– YnNyÑ�MμA�∩�yÑA÷@UW�÷sA�yÑ¿�y

ÑMμ��@�yÑ�εC

3. ½sπz��AHz�n�yÑ�πuDB2 ΩTñ�vC

�G

bí≈s²��@�t��XñAz���N@�t��a�]w�≤�z∩�y

Ñ⌠��yÑC

≤sqú�°��í⌠⌠°A�W� DB2 ΩTñ�

��w�≤s�w��uDB2 ΩTñ�vC

}lºe

��wgw�uDB2 9.7 � ΩTñ�vCp��Ω�A��\w� DB2 °A�ñ�

u�� DB2 w�δFw� DB2 ΩTñ�vDDC��bw�uΩTñ�v�M��

�����¡ε]�b≤suΩTñ�v�M�C

÷≤o�@�

iH���Γ�≤s{s�uDB2 ΩTñ�vG

v ��≤s - ≤s{s�uΩTñ�v\α�yÑC��≤s��[nBNO≤s�í

Lk��uΩTñ�v��í�uC��A�iH]w��≤sAϕ@ΣLw�⌡

μ�σ�u@�@í≈�⌡μC

v Γ�≤s - ϕzQnb≤sL{ñsW\α�yÑ�AN�����≤sCpA�

²wb�w�σ�kσ�uΩTñ�vA{bz]Qnw�wσFΓ�≤sN

w�wσAP�≤s{s�uΩTñ�v\α�yÑCúLAΓ�≤s�nzΓ�

�εB≤s�½s��uΩTñ�vCbπ�≤sL{ñLk��uΩTñ�vC

�DDz��≤s�L{Cp�Γ�≤sⁿA��\uΓ�≤sqú�°� í

⌠⌠°A�Ww�� DB2 ΩTñ�vDDC

54 w��tm DB2 Connect Personal Edition

Page 61: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

{�

Yn��≤sqúW�°� í⌠⌠°A�Ww��uDB2 ΩTñ�vA�G

1. b Linux @�t�WA

a. s²�ww�uΩTñ�v�⌠CuDB2 ΩTñ�vw]�w�b /opt/ibm/

db2ic/V9.7 �²ñC

b. qw��²s² doc/bin �²C

c. ⌡μ update-ic ScriptG

update-ic

2. b Windows @�t�WA

a. }�ⁿO°íC

b. s²�ww�uΩTñ�v�⌠CuDB2 ΩTñ�vw]�w�b <Program

Files>\IBM\DB2 Information Center\Version 9.7 �²ñAΣñ <Program

Files> Nϕ Program Files �²��b�²C

c. qw��²s² doc\bin �²C

d. ⌡μ update-ic.bat ��G

update-ic.bat

�G

uDB2 ΩTñ�v���½s��CpG�i��≤s��AhuΩTñ�v�πs

��≤s�DDCpGS�i��uΩTñ�v≤s��Ah�@hTº�sW�Θ

xCΘx��≤ doc\eclipse\configuration �²CΘx�WOH≈ú���XC

pA1239053440785.logC

Γ�≤sqú�°��í⌠⌠°A�Ww��uDB2 ΩTñ�v

pGzwb�w�uDB2 ΩTñ�vAhiHq IBM �o�w�σ≤≤sC

÷≤o�@�

Γ�≤s�w�� DB2 ΩTñ� �Az�nG

1. �εqúW� DB2 ΩTñ�AMßHW�í�í½s��uΩTñ�vCHW�í

�í⌡μuΩTñ�vi�ε⌠⌠W�ΣL���s�uΩTñ�vA�i²zM

�≤sCDB2 ΩTñ��u@���@��HW�í�í⌡μCC

2. ��≤s\α�d�i��≤s��CpG�z��w��≤sAhiH��u≤

sv\α��o�w�ª�C

�GpGz�⌠��nb�s��⌠�⌠⌠�≈�Ww� DB2 ΩTñ� ≤sAh

���ws��⌠�⌠⌠�ww� DB2 ΩTñ� �≈�AN≤s⌠�ΦM��

��t�CpGz�⌠⌠N�\h���w�σ≤≤sAhP�iHb�ΦM≤

s⌠���≤s⌠��� ProxyAHε�C����⌡μ≤s����íC

pG�≤sM≤A���u≤sv\α��oM≤CM�Au≤sv\αuA�≤

W�í�íC

3. �εW�íuΩTñ�vA�½s��qúW� DB2 ΩTñ�C

�² A. DB2 �NΩTº[ 55

Page 62: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

�Gb Windows 2008 M Windows Vista (�≤s��) WA��H�z�¡�⌡μ

��ß��C�ⁿOCYn}�π��π�z�M�v�ⁿOú��uπA��

½kΣ÷@U�∩�H�z�¡�⌡μC

{�

Yn≤sqú�°� í⌠⌠°A�Ww�� DB2 ΩTñ�A�G

1. �ε DB2 ΩTñ�C

v b Windows WA÷@U}l > �εx > t��zuπ > A�CMß�½k

Σ÷@U DB2 ΩTñ�A�A�∩�εC

v b Linux WAΘJUCⁿOG

/etc/init.d/db2icdv97 stop

2. HW�í�í��uΩTñ�vC

v b Windows WG

a. }�ⁿO°íC

b . s²�ww�uΩTñ�v�⌠CD B 2 ΩTñ� w]�w�b

Program_Files\IBM\DB2 Information Center\Version 9.7 �²ñAΣñ

Program_Files Nϕ Program Files �²��mC

c. qw��²s² doc\bin �²C

d. ⌡μ help_start.bat �G

help_start.bat

v b Linux WG

a. s²�ww�uΩTñ�v�⌠CDB2 ΩTñ� w]�w�b /opt/ibm/

db2ic/V9.7 �²ñC

b. qw��²s² doc/bin �²C

c. ⌡μ help_start ScriptG

help_start

�}�t�w] Web s²�AHπW�íuΩTñ�vC

3. ÷@U≤s÷s ( )C(s²����� JavaScript)CbuΩTñ�v�ke�WA

÷@UMΣ≤sC Y�π{sσ≤�≤sMμC

4. Yn�lw�{�A��∩Qnw��∩AMß÷@Uw�≤sC

5. w�{��¿ºßA�÷@U�¿C

6. �εW�íuΩTñ�vC

v b Windows WAs²�w��²� doc\bin �²A�⌡μ help_end.bat ��G

help_end.bat

�Ghelp_end σ��]t�n�ⁿOAiHw�a�εw�� help_start σ�

����{�C�ún�� Ctrl-C �ΣL⌠≤Φk��ε help_start.batC

v b Linux WAs²�w��²� doc/bin �²A�⌡μ help_end ScriptG

help_end

�Ghelp_end Script ]t�n�ⁿOAiHw�a�εw�� help_start Script

���{�C�ún��ΣL⌠≤Φk��ε help_start ScriptC

56 w��tm DB2 Connect Personal Edition

Page 63: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

7. ½s�� DB2 ΩTñ�C

v b Windows WA÷@U}l > �εx > t��zuπ > A�CMß�½k

Σ÷@U DB2 ΩTñ�A�A�∩���C

v b Linux WAΘJUCⁿOG

/etc/init.d/db2icdv97 start

�G

≤s� DB2 ΩTñ� �π�s�≤sL�DDC

DB2 ⁿ���

DB2 ⁿ�í��≤UzA� DB2 ú��UíC{�ú�vBⁿC

}lºe

ziHquΩTñ�v�°ⁿ���� X H T M L ��A⌠}� h t t p : / /

publib.boulder.ibm.com/infocenter/db2help/C

��{���dΩ��{íXC��\ⁿ���AH�oSw@�������

�í�C

DB2 ⁿ���

Yn�°ⁿ���A�÷@U�DC

ypureXML®z �≤ pureXML Guide

]w DB2 Ω�wHxs XML Ω�AH����� XML Ω�xsw�⌡μ

≥�@�C

yVisual Explainz �≤ Visual Explain ⁿ���

�� Visual ExplainAHRB���M�π SQL »zíi��o����αC

DB2 �°��ΩT

�UíU���°����DP�ΩTi≤Uz�� DB2 Ω�wú�C

DB2 σ≤

p��°��ΩTA��\ Troubleshooting and Tuning Database Perfor-

mance �uDB2 ΩTñ�v�uΩ�w≥�ºvp�C�°��ΩT]t@

�DDAi≤Uzj≈��O DB2 E�uπ���{í�DC]t�@���

ú�D��MΦ�AH�p≤�Mz�� DB2 Ω�wú��iαo�º�D�

�÷��C

IBM Σ�ñ�Jf⌠�

pGzo��DBn≤UMΣiα��]��MΦ�A��\uIBM Σ�ñ�

Jf⌠�vCu�NΣ�ñ�v⌠�i����s� DB2 X��BTechNotesB

u�v{íR°i]APAR ����{í�vB�M≤�ΣLΩ�Cz

iHb��wñiμjMA�z��DMΣiα��MΦ�C

p�s�uIBM Σ�ñ�Jf⌠�vA��Ghttp://www.ibm.com/support/entry/

p o r t a l / O v e r v i e w / S o f t w a r e / I n f o r m a t i o n _ M a n a g e m e n t /

DB2_for_Linux,_UNIX_and_WindowsC

�² A. DB2 �NΩTº[ 57

Page 64: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

°�

��Uz°�AN�Pz∩o�X�����v¡C

�H��G zi�s�ÑuX��v��H�D�����A���O IBM �@

v��ΣL��vk� IBM º�÷σrC�g IBM �PNAzúoGBi

�∩@�ÑuX��v�Σ⌠≤í≈C

����G ziH�sBG�i�ÑuX��v��°� í��A���O IBM

�@v��ΣL��vk� IBM º�÷σrC�g IBM �PNAzúo∩@�

ÑuX��vA]úo≤°���sBG�i�ÑuX��v�Σ⌠≤í≈C

ú���n�ñ�T��º\i�A���NuX��v�⌠≤]t≤ΣñºΩTB

Ω�BnΘ�ΣL�z]úvA���oΣL⌠≤��q\º\iBnΘ�v�v

QC

���∩≤uX��vº��pM� IBM �vqA� IBM {wΣ�ϕ�Wzⁿ�

�uX��v�A IBM oH�MP�B���º\iC

úDz��ϕu��A�º@�kWA]A��ⁿΩXfkWA�hzúoUⁿBX

f�AΘX�ÑΩTC

IBM ∩≤�ÑX��º eú�⌠≤O�CX���Σu{¼vú�Aú�a⌠≤�

�qºßOAΣñ]A (²ú¡≤) AΓ�BDIv�AXSw�ºqßOd⌠C

58 w��tm DB2 Connect Personal Edition

Page 65: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

�² B. �N��

�ΩTYw∩ IBM bⁿΩ�ú�ºú�PA��}oCD IBM ú���÷ΩTOH

�σ≤�@�X��i��ΩT�≥ªA�B�úw��≤C

bΣLΩaAIBM úúo�ú��σ≤�ú�ºU�ú�BA��\αCnDz�b

��O�i�o�ú�PA��A�Vϕa� IBM A�Nϕd�C�σ≤bú�

IBM �ú�B{í�A��Aúϕ�tuα�� IBM �ú�B{í�A�Cun

�I� IBM º�z]úvA⌠≤\α�ϕºú�B{í�A�i�N IBM ºú�B

{í�A�CúLAΣLD IBM ú�B{í�A�bB@W��Pτ�AΣd⌠�

≤���C

bo���σ≤ñiα]t� IBM ��ºMQ�MQ���C������ú��

ezMQº⌠≤�vCziH���Φí�d��vA�τ�HG

IBM Director of Licensing

IBM Corporation

North Castle Drive

Armonk, NY 10504-1785

U.S.A.

Ynd��÷���r� (DBCS) ΩT��v�yA�pzΩa� IBM �z]ú

í�A�����ΦíHG

Intellectual Property Licensing

Legal and Intellectual Property Law

IBM Japan, Ltd.

1623-14, Shimotsuruma, Yamato-shi

Kanagawa 242-8502 Japan

UCq¿YPΩa (�a) ºk�°�Φ��AY°�úA�G International Busi-

ness Machines Corporation u�u{pvú��X��Aúú�⌠≤��qºO�A

Σñ]ABú¡≤úH!WwBi���Sw��ºA���⌠tO�CY��a

�bY�μ÷W�ú�\�úWzO�Ah��úL�C

��ñiα���NW���LΩW���C]�AIBM �w��qF�N�qß�

eJs�ñCP�AIBM oH�∩i�]������ñ�ú��ú��]��{

íC

��∩≤D IBM ⌠����uO�FΦK�ú�A�ú∩o�⌠�@⌠≤{iC��

⌠�W� e�D� IBM ú� e�@í≈A�ß���⌠����μ ß�IC

ϕzú�ΩT� IBM �AzY�v� IBM HΣ{�Aϕ�Φí����teΩTA

�ú�∩zt�⌠≤d⌠C

�{íº≥�v�Y�μ�o�÷Ω�AHK��UCΩT�ió� IBMCΣUCΩT

ⁿ�OG (1) W����{íPΣL{í (]A�{í) ºíμ½ΩT�Φí (2) �¼

��wμ½ºΩTΦkCY�⌠≤�D�pG

© Copyright IBM Corp. 1993, 2012 59

Page 66: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

IBM Canada Limited

U59/3600

3600 Steeles Avenue East

Markham, Ontario L3R 9Z7

CANADA

WzΩ���o�ΣSϕn≤AbY�ípU��IOΦo��C

���yz�⌠≤{í�Σ��i���v�@O IBM �ú�A�ⁿuIBM �ß

X�vBuIBM Ω�{í�vX�v�Φºí⌠≤PÑX�°�ºWdC

�í�tº⌠≤�αΩ�AOo��ε�⌠�ºUF]�úP@�⌠�ºU�o�

�GAiα���j�tºCí≈�qiαOb}oñ�t�W⌡μA]�úO�i

Hq@δ�t�≥P�P��GC��í≈��qAOQ�í�k�o�⌠p�A

ΣΩ��Giα���úPC���������ΣS��⌠�Aτ�XA��Ω

�C

���ú�ºD IBM ú�ΩTAY ú����A�ΣX��n��ΣL�}�D

�oCIBM ����Lo�ú�A]LkT{o�D IBM ú��⌡μ�αB�e�B

�⌠≤∩ú��ΣLDiO���L�CpGz∩D IBM ú���α�⌠≤���A

�wV�ú����d�C

�÷ IBM ���V�⌠≤»zA�Nϕ IBM ����wA�iα≤��²n��í

pU�����M C

��ñt�Θ��í����Ω��°idC�Fú��π�í�Ao�d]

A�HB�qBtPMú��WCo�W��ΩcAYP⌠≤�q�WMϕ}

pPA��XC

�@v�vG

��]t�lyÑ�d��{íA�Hí�U�@�¡xW�{í]p�NCzi

H≥≤πoB��BPΓ�G�X@�¡x (�≤⌡μ��g�d{í) º��{í

]p����{íÑ��AH⌠≤í�sB�∩�Go�d{íA�L�I

O� IBMC²o�d�gL�π���C]�AIBM ú�O��to�{í�

¡w�BA�αO�\αC�{ídHu{¼vú�ABL⌠≤O�C IBM útß

⌠≤]�{ídº���ú��⌠≤l�C

o�d{í�O⌠≤l��@�C@≈���⌠≤í≈Aú��π�UC��@v

n�G

© (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.

��

IBMBIBM �x� ibm.com® OΩ��≈��≈�¡�q (IBM) bⁿΩ� (�) Σ

LΩa����U�A�b�@�\h���ñ�¿�UCΣLú��A�W

iαO IBM �ΣL�q��Cb “Copyright and trademark information” ⌠�]⌠

}� www.ibm.com/legal/copytrade.shtml�ñA�{μ� IBM �MμC

UCNyOΣL�q����U�

60 w��tm DB2 Connect Personal Edition

Page 67: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

v Linux O Linus Torvalds bⁿΩ� (�) ΣLΩa�a�º�C

v Java ��� Java ¼���xO Oracle �]��Σl�q����U�C

v UNIX O The Open Group bⁿΩ�ΣLΩa��U�C

v IntelBIntel �xBIntel InsideBIntel Inside �xBIntel CentrinoBIntel Centrino �

xBCeleronBIntel XeonBIntel SpeedStepBItanium � Pentium O Intel Corporation

�Σl�qbⁿΩ�ΣLΩa����U�C

v MicrosoftBWindowsBWindows NT � Windows �xO Microsoft Corporation b

ⁿΩ� (�) ΣLΩa��C

ΣL�qBú��A�WiαOΣL�q���A��xC

�² B. �N�� 61

Page 68: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

62 w��tm DB2 Connect Personal Edition

Page 69: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

����HñσrAσrA�Sϕ��º���

CC

eT�fj¼D≈s�

tm 34, 37

e�fñ¼°A�

tmsu 34

�yÑ

º[ 39

�≤

UNIX 42

Windows 41

Oí SQL ��{í

IBM Data Server Client Σ� 5

��{í

s� 43

σ≤

LΩ 49

°���� 58

º[ 49

PDF �� 49

e¡�fD≈Ω�w

�ßsu 19

tm TCP/IP 35

�ß

º[ 5

�²�c

root ¡w�∩�D root ¡w� 21

�²⌡�

XR

Windows 18

e��frX�

Σ� 39

α½

º� 43

w�

���s� 20

w�

DB2 Connect Personal Edition 7, 17

w� (�≥)

DB2 ú�

HD root ���¡ 24

eC�f≤s

DB2 ΩTñ� 54, 55

eK�f���bß

w��� (Windows) 17

���s�

w� 20

sW� 20

DB2ADMNS 20

DB2USERS 20

Ish�� (CLI)

IBM Data Server Client Σ� 5

�N�� 59

D root ¡w�

�²�c 21

w� 24

¡ε 21

�M≤ 26

tº 21

�� root ¼\α 25

º[ 20

�úw� 27

D root Ω

�≤ 27

�ú 27

ems��

IBM Data Server Client Σ� 5

eE�fⁿO

db2rfe

JAD root ¡w��¡ε 21

�� root ¼\α 25

db2secv82 20

db2setup

HzΩa�yÑπuDB2 w�vδF 40

ⁿOμBz� (CLP)

IBM Data Server Client 5

ⁿ���

�DP� 57

Mμ 57

© Copyright IBM Corp. 1993, 2012 63

Page 70: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

ⁿ��� (�≥)

�°�� 57

Visual Explain 57

q� DB2 �y 52

eQ�f�M≤

D root ¡w� 26

�y

q� 52

O�Θ

�D

º[ 7

tm

su\α

tm�U{í 34

Pj¼D≈�su 34

DB2 Connect Personal Edition 7

TCP/IP

�� CLP 35

tm�U{í (CA)

tm

Ω�wsu 38

P System i Ω�w°A��su 34

PD≈Ω�w°A��su 34

��\α 37

���wsu 39

eQ@�f�DP�

i�ΩT 57

ⁿ��� 57

ΩayÑΣ� (NLS)

α½r�Ω� 43

πuDB2 w�vδF 40

M��X

��� 43

��\α

tm�wsu 37

�≤

D root Ω 27

°�

X�� 58

�ú

DB2 (root)

Linux 46

UNIX 46

qT≤w

DRDA D≈s�tm 31

s�

��{í

DB2 Connect 43

su

��s� IBM i 3

��s� System z D≈ 3

tm�U{í 5

zLqT°A�� DRDA D≈ 31

º[ 5

eQG�f��

Ω�wsu 39

eQT�f�ⁿ CD � DVD

Linux 10

Solaris @�⌠� 14

�úw�

D root ¡w� 27

DB2 Connect 45

DB2 Ω�wú�

Windows 45

root ¡w� 46

Ω�w

Γ�sW 38

D≈ 31

su

tm 37, 38

�� 39

Ω�wsuA� (DCS) �²

�ú�� 39

Ω�w��{í

}o 43

w]yÑ]w

Windows 41

eQ�fΩ

�ú 27

Ω�d

DB2 Connect 3

�°��

ⁿ��� 57

suΩT 57

��í

�D 7

yÑ ID � DB2 w�δF 40

V� 43

DB2 � 39, 41

yÑ⌠�

DB2 �yÑ 39

í�

tmyÑ 53

64 w��tm DB2 Connect Personal Edition

Page 71: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

í� (�≥)

SQL »zí 53

eQ¡�fd

DB2 Connect 3

sXr� ID (CCSID)

VyÑ 43

eQC�f��{í

ODBC 43

��{í}o

IBM Data Server Client

�� 5

eQK�fα½

r� 43

V CCSID Σ�

yÑΣ� 43

eQE�f÷≤�� 1

AActiveX Ω�½≤

DB2 Data Server Client Σ� 5

CCD

�ⁿ

Linux 10

Solaris @�⌠� 14

DDB2 Connect

w�

���� 19

D�z� 19

°A�ú�

w�]Solaris @�t�� 13

ú� 3

º[ 3

DB2 for VSE & VM 34

IBM i su 29

DB2 Connect (�≥)

Personal Edition

w� (Linux) 8, 10

w� (Solaris) 11

w� (Windows) 15, 16

w�]º[� 7

tm 7

Windows ���bß 17

DB2 for VM & VSE

��� DB2 Connect �su�� 34

DB2 for z/OS

≤st�ϕμ 34

uDB2 w�vδF

yÑ ID 40

DB2 ΩTñ�

≤s 54, 55

�� 53

yÑ 53

DB2ADMNS s�

sW��� 20

DB2 Connect Personal Edition 20

db2rfe ⁿO

�� root \α 21, 25

db2setup ⁿO

yÑ]w 40

DB2USERS ���s�

sW��� 20

DB2 Connect 20

DVD

�ⁿ

Linux 10

Solaris @�⌠� 14

IIBM Data Server Client

s�� 19

JJava

IBM Data Server Client Σ� 5

JDBC

IBM Data Server Client Σ� 5

LLANG ⌠���

]w 40, 42

Linux

w�

DB2 Connect Personal Edition 8

�ú

DB2 (root) 46

�� 65

Page 72: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

Linux (�≥)

�ⁿ

CD 10

DVD 10

�úw� DB2

D root Ω 27

root 46

OODBC

w�����{í 43

OLE

IBM Data Server Client Σ� 5

Rroot ¡w�

�²�c 21

PD root ¡w�±� 21

root ¼\α

D root ¡w� 25

SSolaris @�t�

w� DB2 Connect Personal Edition 11

Solaris @�⌠�

w��D

DB2 Connect °A�ú� 13

�ⁿ CD � DVD 14

SQL »zí

í�

π 53

SQLJ

IBM Data Server Client Σ� 5

System i

Ω�w°A�

tm TCP/IP 35

TTCP/IP

tm

D≈su 3, 31

D≈Ω�w°A� 35

System i Ω�w°A� 35

DB2 for z/OS tm 30

UUNIX

�ú

DB2 (root) 46

UNIX (�≥)

�ú (�≥)

DB2 D root Ω 27

�úw� DB2

root 46

�≤ DB2 �yÑ 42

VVTAM

��� DB2 Connect �su�� z/OS 30

WWindows

w�

DB2 Connect Personal Edition ({�) 15

DB2 Connect]tD�z�¡s�� 19

���bß

DB2 Connect Personal Edition w� 17

�úw� DB2 45

w]yÑ]w 41

Windows @�t�

w�

DB2 Connect Personal Edition]�D� 16

Zz/OS

tm DB2 Ω�wt� 34

66 w��tm DB2 Connect Personal Edition

Page 73: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and
Page 74: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

����

Printed in Taiwan

SC40-2456-03

Page 75: IBM DB2 Connect 9public.dhe.ibm.com/ps/products/db2/info/vr97/pdf/...IBM DB2 Connect 9.7 w tm DB2 Connect Personal Edition 2012 7 δ≤s 9 7 SC40-2456-03. ... v DB2 Server for VM and

Spineinformation:

IBM

DB

2C

on

nec

t9.

7��

9��

7w��tm

DB

2C

onne

ctPe

rson

alE

ditio

n��