IBM DB2 9.7 for Linux, UNIX, and...

88
IBM DB2 9.7 for Linux, UNIX, and Windows Linux Windows W DB2 wzJ GI13-0694-00

Transcript of IBM DB2 9.7 for Linux, UNIX, and...

Page 1: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

IBM DB2 9.7for Linux, UNIX, and Windows

Linux � Windows W DB2 w���zJ�

GI13-0694-00

���

Page 2: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla
Page 3: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

IBM DB2 9.7for Linux, UNIX, and Windows

Linux � Windows W DB2 w���zJ�

GI13-0694-00

���

Page 4: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

��

b���ΩTH�ªΣ��ú�ºeA�²\¬� 73���² F, y�N��zU�@δΩ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 International Business Machines Corporation 1993, 2009.

Page 5: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

�²

� 1 g w����� . . . . . . . . 1

� 1 � ���O��D . . . . . . . 3

� 2 � Windows w�����. . . . . 5DB2 °A�� IBM Data Server Client �w��D(Windows) . . . . . . . . . . . . . . . 5w� DB2 ú�ºe]w Windows �¬M�v(Windows) . . . . . . . . . . . . . . . 6�P���v¡ (Windows). . . . . . . . . . 8DB2 t��z�s��N�� (Windows) . . . . . 8

� 3 � Linux w����� . . . . . . 11DB2 °A�� IBM Data Server Client �w��D(Linux) . . . . . . . . . . . . . . . . 13�ñí����z�q (Linux) . . . . . . . . 14

� 2 g w�z� DB2 ú� . . . . 15

� 4 � w� DB2 °A� (Windows) 17

� 5 � �� DB2 w�δFw� DB2 °

A� (Linux) . . . . . . . . . . . . 21

� 3 g τ�z�w� . . . . . . . 25

� 6 � ���nBJτ� DB2 °A��

w� (Linux � Windows). . . . . . . 27

� 7 � ��ⁿOμBz� (CLP) τ�w

� . . . . . . . . . . . . . . . . . 29

� 8 � ��u�����@�Ω�wvδ

F����v��w. . . . . . . . . 31

� 9 � DB2 uπ�D\αϕ��

(Linux) . . . . . . . . . . . . . . . 33

� 4 g DB2 ú��v . . . . . . . 35

� 10 � DB2 �v� . . . . . . . . 37

� 11 � �� db2licm ⁿOn² DB2ú��\α�vX . . . . . . . . . . 41

� 12 � ���vñ�n² DB2 ú��

\α�vX . . . . . . . . . . . . . 43

� 13 � �d DB2 �v{� . . . . . 45

� 14 � ≤s���v . . . . . . . . 47

� 5 g �²PßO . . . . . . . . 49

�² A. �����w� DB2 ú� . . . 51���w�≥�º� . . . . . . . . . . . 51����N�� . . . . . . . . . . . . . 51��uDB2 w�vδF����� . . . . . . . 52

�² B. �d DB2 ú�≤s�� . . . . 53�d DB2 ≤s�. . . . . . . . . . . . 53

�² C. M� DB2 ��M≤ . . . . . . 55M��M≤ . . . . . . . . . . . . . . 55

�² D. �úw�z� DB2 ú� . . . . 59�úw� DB2 ú� (Windows) . . . . . . . . 59�úw� DB2 ú� (Linux) . . . . . . . . . 59�ε DB2 �z°A� (Linux) . . . . . . . 60�ú DB2 �z°A� (Linux) . . . . . . . 60�ε root Ω (Linux). . . . . . . . . . 61�ú DB2 Ω (Linux) . . . . . . . . . 61�� db2_deinstall � doce_deinstall ⁿO�úDB2 ú� (Linux) . . . . . . . . . . . 62

�² E. DB2 �NΩTº[ . . . . . . 63LΩ�y� PDF μí� DB2 �NO� . . . . . 63q� DB2 LΩ�y. . . . . . . . . . . . 66qⁿOμBz�π� SQL ¼Aí� . . . . . . 67s�úP���uDB2 ΩTñ�v . . . . . . . 67buDB2 ΩTñ�vñHz�n�yÑπ�DD . . 67≤sqú�°�í⌠⌠°A�W� DB2 ΩTñ� 68Γ�≤sqú�°�í⌠⌠°A�Ww��uDB2ΩTñ�v . . . . . . . . . . . . . . 69DB2 ⁿ��� . . . . . . . . . . . . . 70DB2 �°��ΩT . . . . . . . . . . . . 71°� . . . . . . . . . . . . . . . . . 71

�² F. �N�� . . . . . . . . . . 73

�� . . . . . . . . . . . . . . . . 77

© Copyright IBM Corp. 1993, 2009 iii

Page 6: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

iv Linux � Windows W DB2 w���zJ�

Page 7: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

� 1 g w�����

© Copyright IBM Corp. 1993, 2009 1

Page 8: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

2 Linux � Windows W DB2 w���zJ�

Page 9: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

� 1 � ���O��D

��≥��D

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

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

Ajp⌠p�C

�Oon J��ºΩ�wBnΘ�qTú����íC

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

O�Θ�D

DB2 Ω�wt����n 256 MB � RAMC∩≤�⌡μ DB2 ú�� DB2 GUI u

π�t�A���n 512 MB � RAMCM�A�Fπ�Wi��αA���� 1 GB

� RAMCo��Dú]At�W⌡μºΣLnΘ���⌠≤B�O�Θ�DC

PwO��D�A��NUC��G

v ∩≤ IBM® Ω�°A��ß�Σ�Ao�O�Θ�DOH 5 ��μ�ß�su�≥

ªCCh 5 ��ß�suN�nB� 16 MB � RAMC

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

�º�ß���vTC

∩≤ DB2 °A�ú�A���πO�Θ\α���]w��O�Θtm���A

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

Atei�O�ΘΩ�A]A��BΩ�]��BΩwMμ�w�C

v b Linux @�t�WA�� SWAP í��� RAM �Γ�C

© Copyright IBM Corp. 1993, 2009 3

Page 10: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

4 Linux � Windows W DB2 w���zJ�

Page 11: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

� 2 � Windows w�����

DB2 °A�� IBM Data Server Client �w��D (Windows)b Windows® @�t�Ww� DB2 Ω�wú�ºeA�TOz∩��t��X�n�

@�t�Bw�n�DC

ϕ 1. Windows u@�¡x

@�t� ���� wΘ

Windows XP Professional (32 ��

� 64 ��)

Windows Vista Business (32 ���

64 ��)

Windows Vista Enterprise (32 ��

� 64 ��)

Windows Vista Ultimate (32 ���

64 ��)

Windows XP Service

Pack 2 �≤s��

IBM Data Server Pro-

vider for .NET ��

��{í� CLR °A

��{��n .NET 2.0

Framework ⌡μ��C

� 6 4 �� I B M

Data Server Provider for

.NET ��{íC

��� W i n d o w s

Vista A�M≤C

iH⌡μΣ�º Windows @�t

� (32 ��� 64 ��¼t�) �

�� Intel® � AMD Bz�

ϕ 2. Windows °A�¡x

@�t� ���� wΘ

Windows 2003 Datacenter Edition

(32 ��� 64 ��)

Windows 2003 Enterprise Edition

(32 ��� 64 ��)

Windows 2003 Standard Edition (32

��� 64 ��)

Service Pack 2 �≤s��C

]Σ� R2

IBM Data Server Provider for .NET

�ß���{í� CLR °A��

{��n .NET 2.0 Framework ⌡

�C

� 64 �� IBM Data Server

Provider for .NET ��{íC

iH⌡μΣ�º Win-

dows @�t� (32 �

�� 64 ��¼t�)

��� Intel � AMD

Bz�C

Windows Server 2008 Datacenter

Edition (32 ��� 64 ��)

Windows Server 2008 Enterprise

Edition (32 ��� 64 ��)

Windows Server 2008 Standard Edi-

tion (32 ��� 64 ��)

IBM Data Server Provider for .NET

�ß���{í� CLR °A��

{��n .NET 2.0 Framework ⌡

�C

� 64 �� IBM Data Server

Provider for .NET ��{íC

��� Windows Server 2008 A

�M≤C

© Copyright IBM Corp. 1993, 2009 5

Page 12: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

�: DB2 Ω�wú�Σ��m≤Y� Windows @�t�ñwΘjε�uΩ�⌡μw�

(DEP)v\αC

ΣLnΘ�N��

v �n Windows Installer 3.0CpG ���Ahw�{í�w�ªC

v IBM Data Server Provider for .NET �ß���{í� CLR °A��{�

�n .NET 2.0 Framework ⌡μ��Cb x64 ⌠�ñA32 �� IBM Data

Server Provider for .NET ��{í�H WOW64 ���í⌡μC

v �n MDAC 2.8CuDB2 w�vδFN�w� MDAC 2.8 (pG� w�)C

�: pGww��� MDAC (pA2.7)Ah DB2 w��N MDAC ��¿

2.8CY�@δw�Ah�w� MDAC 2.8CY��qw�Ahu�bz �

°∩��w� MDAC 2.8 �w]����w�ªCpG�qw���°∩�

MDACAhú�w�ªC

v pGzp��� LDAP (Lightweight Directory Access Protocol)Ah���

Microsoft® LDAP �ß�� IBM Tivoli® Directory Server � 6 ��ß� (]

� IBM LDAP �ß�AΣH�≤ DB2 Ω�wú�)Cw� Microsoft

Active Directory ºeA�����≤w�CΘW db2\Windows\utilities

²U� db2schex ��{í�XR²⌡C

Microsoft LDAP �ß�H�≤ Windows @�t�C

v �n�UCΣñ@�s²�A�α�°uWí�B⌡μ DB2 w���{í

(setup.exe)AH�⌡μu�nBJv(db2fs)G

– Firefox 2.0 �≤s��

– Internet Explorer 6.0 �≤s��

– Mozilla ¼s²� 1.7 �≤s��

– Safari 3.0 �≤s��

w� DB2 ú�ºe]w Windows �¬M�v (Windows)

q�b Windows Ww� DB2 ú��ΦkO�� Administrator ���bßCM�A]

iH��D Administrator bß�w� DB2 ú�CYno��A Windows Administra-

tor ��b Windows Wtm�¬M�v\αC

�@��� Windows Administrator p≤]wqú�Σπ��¬M�vAH��D

Administrator ���bßiμw�C]�[\N DB2 �zv¡�PD Administrator �

����÷@�C

@δ�ÑAWindows Administrator �⌡μ�@�A²S� Administrator bß�t@�

H�iHw� DB2 ú�C�H��ñΓiαuiHw� DB2 ú�A��]iHbw

�ß�z DB2 ú�C

�l�{�ºeA��N���¬M�vºD Administrator w��UC¡εG

v pG²e�w����]O��P�D Administrator ����⌡μAD Administra-

tor ����iHw��M≤B�[{íú���� DB2 ú�C

v D Administrator ���Lk�úw� DB2 ú�CWindows Vista (PHW���) @

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

6 Linux � Windows W DB2 w���zJ�

Page 13: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

�{���uWindowsus�hs�vC

1. ÷@U}l -> ⌡μAMßΣJ gpedit.mscCY�}�s��h°íC

2. ÷@Uuqútm –> �zd� –> Windows �≤ –> Windows InstallervC

3. ��UCus�hv]wG

v @�H�¬M�v�w� (�n)

v �\����εw�@� (�n)

v �� Windows InstallerCMßNª]��úC

v ²���iH�w���ú� (∩�)

v CΘΩ�ú¬�A²���iH��CΘΩ� (∩�)

v ��ú¬�A²���iHs²�� (Y�s�w�A�∩��AY��M≤

��Ah��n�)

4. ��n⌡μw�º���bß��¬M�vC

a. ÷@U���tm –> �zd� –> Windows �≤ –> Windows InstallerC

b. ��@�H�¬M�v�w� (�n)us�hv]wC

5. ⌡μPnw� DB2 ú�º���bß�÷�]wC

v �Onw� DB2 ú�����bßC�n�A����bßC

v NW�nbΣWiμw�º��≈�gJvú���bßC

6. ∩��G��¿A��w��M≤��[BJG

v ú� sqllib\cfg ²�¬� vC

v ]��M≤w�O°�ú���n��A�H�Tww�� allowlockdownpatch

(p Windows Installer SDK σ≤ñ�z)C

7. ��UC⌠@�Φk�½sπzqú�w�hG

v ½s�� PCC

v bⁿOμñΘJ gpupdate.exeC

b�{�ºßAzN]wqú�Σπ��¬M�vAH�]wiHw� DB2 °A�ú

�B�ß���M≤����bßC

b DB2 w��¿ºßG

v bΩ�Ω�w�z{ítmñ�wq�t��z (SYSADM) �t��ε

(SYSCTRL) v¡s�ñ�⌠≤���AúiHb DB2 Ωñ����� DB2 Ω�

wC

v u�π��� Administrator v¡����iH⌡μ DB2 Ω��{íAp

db2icrtBdb2idropBdb2iupdt � db2iupgradeC

v ⌡μ db2start � db2stop ⁿO��v�Dwqb START DATABASE MANAGER

ⁿO� STOP DATABASE MANAGER ⁿO�DDñC

�� regedit �D Windows s��hs�

uWindows s�hsΦ�v��NΦíO�� regeditC

1. bn²�Σ HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\

Windows ñAsW≈X installer

2. ��UC��sΦ≈X installerG

v Y� AlwaysInstallElevatedA�ΘJ REG_DWORD=1

� 2 � Windows w���� 7

Page 14: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

v Y� AllowLockdownBrowseA�ΘJ REG_DWORD=1

v Y� AllowLockdownMediaA�ΘJ REG_DWORD=1

v Y� AllowLockdownPatchA�ΘJ REG_DWORD=1

v Y� DisableMSIA�ΘJ REG_DWORD=0

v Y� EnableUserControlA�ΘJ REG_DWORD=1

3. bn²�Σ HKEY_CURRENT_USER\SOFTWARE\Policies\Microsoft\

Windows ñAsW≈X installer

4. ��UC��sΦ≈X installerG

v Y� AlwaysInstallElevatedA�ΘJ REG_DWORD=1

�ú�¬M�v

ú��¬M�vºßANiH�α��@CYno��A��ú

HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows U�n²≈

X InstallerC

N DB2 �zv¡�PD Administrator ���

��Au� Windows Administrators s��¿�π� DB2 �zv¡CWin-

d o w s A d m i n i s t r a t o r iH∩�N@�HW� D B 2 v¡ (p

SYSADMBSYSMAINT � SYSCTRL) �Pww� DB2 ú��D Adminis-

trator ���C

�P���v¡ (Windows)�DDí�b Windows @�t�W�P���v¡��nBJC��Gw��]w

DB2 ������bß��π�Sw����v¡C

Ynb Windows W�PiÑ���v¡Az��H��u�z�v¡�nJC

1. ÷@U}l -> ⌡μA�ΣJ secpol.mscCb Windows 2008 � Windows Vista (�

≤s�) WA÷@U}lA�bjMCñΣJ secpol.mscC÷@UTwC

2. ∩��≈w��hC

3. b¬íμñAi}�≈�h½≤AMß∩����v¡ⁿúC

4. bkíμñA∩�zQnⁿw����v¡C

5. q\αϕñA∩��@ —> w�...

6. ÷@UsWA∩�n∩Σⁿwv¡�����s�AMß÷@UsWC

7. ÷@UTwC

pGz�qú�≤ Windows ⌠�Ah⌠����v¡�m½z���]wCb�íp

UAz�u⌠⌠�z�v���≤���v¡C

DB2 t��z�s��N�� (Windows)��w]�A�w∩wwqbߺqúW�≤ Administrators s��⌠≤�� DB2��

�bßA�Put��z (SYSADM)vv¡CpGbßO �bßAhª���≤��

Administrators s�CpGbßO⌠�bßAhª���≤⌠��ε�W� Administra-

tors s���� Administrators s�CziH]wn²�� DB2_GRP_LOOKUP=local

�sW⌠�bß (�s�s�) ���s�ñAHjε DB2 Ω�w°A�@wnb��

qúW⌡μs�d\C

8 Linux � Windows W DB2 w���zJ�

Page 15: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

pApG���nJ⌠�bßB��s� DB2 Ω�wAh DB2 Ω�w°A��y

X⌠��ε�HC�s� (]A Administrators s�)C

Yn²⌠������ SYSADM v¡AhL���≤�� Administrators s��⌠

��ε�W� Administrators s�C]� DB2 Ω�w°A��Obwwqbß�≈�

W⌡μ�vA�HbN⌠����sW�°A�W��� Administrators s��Aú�

N⌠���� SYSADM v¡�P�s� (úDw]w DB2_GRP_LOOKUP=local)C

Yn�KN⌠����sW�⌠��ε�W� Administrators s�A���s�s�A

�NQn�P SYSADM v¡�⌠����sW��s�s�ñCMß��s�s�W

�≤s DB2 tm� SYSADM_GROUPC

Yn≤s DB2 tm�A�ΘJUCⁿOG

db2 update dbm cfg using sysadm_group global_groupdb2stopdb2start

� 2 � Windows w���� 9

Page 16: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

10 Linux � Windows W DB2 w���zJ�

Page 17: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

� 3 � Linux w�����

DB2 °A�� IBM Data Server Client �w��D (Linux)b Linux @�t�Ww� DB2 Ω�wú�ºeA�TOz∩��t��X�n�@�

t�BwΘBnΘ�qT�DC

UCwΘWΣ� DB2 Ω�wú�G

v x86 (Intel Pentium®BIntel Xeon® � AMD) 32 �� Intel � AMD Bz�

v x64 (64 �� AMD64 � Intel EM64T Bz�)

v POWER® (IBM eServer™ OpenPower®BiSeries®BpSeries®BSystem i®BSystem p®A

H�Σ� Linux � POWER Systems)

v eServer System z® � System z9®

Linux ��@�t��C�D]AG

v Red Hat Enterprise Linux (RHEL) 5 Update 2

v SUSE Linux Enterprise Server (SLES) 10 Service Pack 2

v SUSE Linux Enterprise Server (SLES) 11

v Ubuntu 8.0.4.1

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

data/db2/linux/validate/C

h⌡μⁿ[c¡ε

pGb Linux @�t�Ww� DB2 32 ��Ω�wú�A��q��� 64 ��@

�t��w� DB2 64 ��Ω�wú�Ch⌡μⁿ[cq��� O�ΘtmCM�A

oiα�vT 32 �� DB2 Ω�w°A��O�ΘtmCpG

v Nz{í⌡μⁿ�M�O�Θbμ@{�ñtmCΩ�wNz{í��M�O�Θ

tm�E�AiαLk±Jμ@{�O�ΘíC

v h�Ω�w�Σ�ⁿ�¡εA]�∩≤��Ω�w�ÑA��Ω�w@�O�Θ

qúbμ@{�ñtmCziα�nε�í�Ω�w�O�Θ�qAHP��Q�

���Ω�wCM�AΩ�w�z{í�αiα�ⁿ�vTCt@�∩�Φ�O�

�h�Ω�bΩñsΩ�wCM�A�n¼≈�t�Ω��Σ��tmC

o�D

bw� DB2 Ω�wú�ºeAz��≤s�{ítm�C⌡μ DB2 Ω�wt�

�ASw�{í��w]�iα�ú¼C

z]iα�ΣLú����{í�n Linux t�Ω�Cz���� Linux t�B@⌠

���D��∩�{ítm�C

�{ítm�]≤ /etc/sysctl.confC

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

© Copyright IBM Corp. 1993, 2009 11

Page 18: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

M≤�D

UϕCX SLES � RHEL oμM≤�M≤�DG

v ��DPB I/O � DB2 Ω�w°A��n libaio.so.1C

v DB2 Ω�w°A���ß��n libstdc++so.6CM�ApG�� IBM Tivoli Sys-

tem Automation for Multiplatforms � IBM Tivoli Monitoring for Databases: DB2

AgentAh�n libstdc++so.5C

SLES � RHEL �M≤�D

Ω�]W� í�

libaio ]t DB2 Ω�w°A��n�DPB��wC

compat-libstdc++ ]t libstdc++so.6 (Linux on POWER ú�n)

Uϕw∩ DB2 ���Ω�w°A�CX SUSE Linux � Red Hat oμ��M≤�DC

v SUSE10 � RHEL5 t��n ksh93 Korn ShellC��ΣL DB2 Ω�wt�ú�n

pdksh Korn Shell M≤C

v ���Ω�wt��n�� Shell ��{íCDB2 Ω�wt�Σ�UC�� Shell �

�{íG

– rsh

– ssh

��w]�ADB2 Ω�wt�b�� DB2 �IW⌡μⁿO���� rshApA�

��� DB2 �w�� �CYn�� DB2 �wt�w]�A��w� rsh-

server M≤ (�\U��ϕμ)Crsh � ssh � �ΩT�≤uDB2 ΩTñ�vC

pG∩��� rsh �� Shell ��{íAh]��w��⌡μ inetd (� xinetd)Cp

G∩��� ssh �� Shell ��{íAh�nb DB2 w��¿ßA�Y]w

DB2RSHCMD qT��CpGú]w�n²��Ah��� rshC

v ���Ω�wt��n nfs-utilsu⌠⌠��t�vΣ�M≤C

�≥ DB2 Ω�wt�]wºeA��w��tm���n�M≤Cp�@δ� Linux

ΩTA�\ Linux oμ�σ≤C

SUSE Linux �Ω�]�D

Ω�]W� í�

pdksh � ksh93 Korn ShellC��Ω�w⌠��n�Ω�]C

openssh �M≤]t@�°A�{íAi²���zLw�� Shell b (�q)

��qúW⌡μⁿOCpGN DB2 Ω�wt��w]tmP rsh f

t��Ahú�n�M≤C

rsh-server �Ω�]]t@�°A�{íAi²���b��qúW⌡μⁿ

OBnJΣLqúAH�bqúºí�s�� (rshBrexecBrlogin �

rcp)CpGN DB2 Ω�wt�tm¿�� sshAhú�n�M≤C

nfs-utils u⌠⌠��t�vΣ�Ω�]Cªe\q��qús�����C

12 Linux � Windows W DB2 w���zJ�

Page 19: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

Red Hat �Ω�]�D

�² Ω�]W� í�

/System Environment/Shell pdksh � ksh93 Korn ShellC��Ω�w⌠��n�Ω�

]C

/Applications/Internet openssh �Ω�]]t@��ß�{íAi²��

�zLw�� Shell b��qúW⌡μⁿ

OCpGN DB2 �wt��w]tmP

rsh ft��Ahú�n�M≤C

/System Environment/Daemons openssh-server �Ω�]]t@�°A�{íAi²��

�zLw�� Shell q��qú⌡μⁿOC

pGN DB2 �wt��w]tmP rsh

ft��Ahú�n�M≤C

/System Environment/Daemons rsh-server �Ω�]]t@�{íAi²���b�

�qúW⌡μⁿOC��Ω�w⌠��n

ªCpGN DB2 Ω�wt�tm¿��

sshAhú�n�M≤C

/System Environment/Daemons nfs-utils u⌠⌠��t�vΣ�Ω�]Cªe\q

��qús�����C

n�N��

v (�¡�ß�) pGW���uKerberos �OvAh�n IBM Network Authentica-

tion Service Client 1.4 ��≤s��CziHqUC⌠�Uⁿ NAS �ß�G https://

www6.software.ibm.com/dl/dm/dm-nas-pC

v �n�UCΣñ@�s²�A�α�°uWí��⌡μu�nBJv(db2fs)G

– Firefox 2.0 �≤s��

– Mozilla ¼s²� 1.7 �≤s��

v pG�XUC¼pAh�niHe{�í������uX °ít�vnΘG

– zn��uDB2 ]wvδFb Linux @�t�Ww� DB2 Ω�wú�A��

– znb Linux for x86 � AMD 64/EM64 W� Linux W��⌠≤ DB2 �u

πC

v Micro Focus úú� SLES 11 W⌠≤ COBOL s��ú��Σ�C

[j Linux w��q

b RHEL 5 t�WApGw��[j Linux w� (SELinux) BΣB≤jε�íAhw

�{íiα��≤ SELinux ¡ε�ó�C

YnP�O�ww� SELinux BΣB≤jε�íAziH⌡μUCΣñ@�G

v �d /etc/sysconfig/selinux ��

v ⌡μ sestatus ⁿO

v �d /var/log/messages ��AH�o SELinux �N��C

Yn�� SELinuxAziH⌡μUCΣñ@�G

v b\i�íñ]wªA�HW����¡�⌡μ setenforce 0 ⁿO

v �∩ /etc/sysconfig/selinux �½s}≈C

� 3 � Linux w���� 13

Page 20: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

pG DB2 Ω�wú�w�Qaw�b RHEL 5 t�WAh DB2 {�Nbúⁿ¡ε�

⌠�ñ⌡μCYnⁿú DB2 {��ª�v�⌠�A��∩hCb sqllib/

samples ²ñú��d SELinux hC

�ñí����z�q (Linux)b]Aw�nΘ�⌠�ñA�@�w��N��C

�: DB2 w�Lk≤s���b@�t�º��ε�����s�CpALDAP i�

≤b@�t�º��ε����s�C

�: q DB2 9.1 � Fix Pack 2 }lA≤�u⌠⌠ΩTA� (NIS)v�u⌠⌠ΩTA�

[j� (NIS+)v\αCb ���ñiα��úo�\α�Σ�CLightweight Direc-

tory Access Protocol (LDAP) O�ñí����zA�����MΦ�C

��Ω�AbS�w��≤�ípUA��∩Ω����s�MμAH JΩ�

w�z°A� (DAS) ���ºDns��s�Mμ (pG�� DAS �)CpGΩ

��{íLk�∩o�eAªN°iLk⌡μC�iTºiú�Γ�iμ�≤��

nΩTC

o��N��b�íw�{íúe\ DB2 w��Ω��{í��∩����Φ�⌠

≤⌠�Uú��C

14 Linux � Windows W DB2 w���zJ�

Page 21: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

� 2 g w�z� DB2 ú�

© Copyright IBM Corp. 1993, 2009 15

Page 22: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

16 Linux � Windows W DB2 w���zJ�

Page 23: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

� 4 � w� DB2 °A� (Windows)

�@�í�p≤b Windows W��uDB2 w�vδFCziH��uDB2 w�vδ

F�wqw�A�N DB2 Ω�wú�w�bt�WC

}lºe

b��uDB2 w�vδFºeG

v �Twt��Xw�BO������DC

v pGzW�b Windows W�� LDAPAH≤ Active Directory ñn² DB2 °A�A

h��bw�eXR²⌡C

v pGzW��� IBM Tivoli Monitoring for Databases: DB2 AgentA�bw� DB2

ú�ºe\u�� DB2 w�{íw� IBM Tivoli Monitoring for Databases: DB2

AgentvAH�o �ΩT�¡εC

v z����� Administrator ���bß (π��������v¡) �α⌡μw�C

bi�� LocalSystem @� DAS P DB2 Ω���B ��Ω�w��\α�

DB2 Ω�w°A�ñAπ��¬M�v�D�z����iH⌡μw�C

�: pGD Administrator ���bßn⌡μú�w�A�\��b��w� DB2 Ω

�wú�ºeA²w� VS2005 ⌡μ����wC@�t�ñ�nsb VS2005 ⌡

μ����wAMß�αw� DB2 Ω�wú�CVS2005 ⌡μ����wiHq

Microsoft ⌡μ����wUⁿ⌠��oC�Γ�∩�G∩� vcredist_x86.exe �≤

32 ��t�A� vcredist_x64.exe �≤ 64 ��t�C

v ÷M�D�nA²O�O��z÷¼��{íA²w�{íiH≤sqúW���

��A�ú�n½s}≈C

v úΣ�qΩ���≈� ∩M�⌠⌠��≈ (pAuWindows ����vñ�

\\hostname\sharename) w� DB2 ú�Cb��w� DB2 ú�ºeAz��N⌠⌠

��≈∩M� Windows ��≈r� (pAZ:)C

¡ε

v ⌠≤���bßAúLk⌡μh�uDB2 w�vδFΩC

v DB2 ��W�ΩW�}YúiHO��C DB2 ��W¡ε� 64 ��σr

�A� A-ZBa-z � 0-9 �¿C

v b�� DB2 ��ñADB2 ��W�ΩW��O�@�C

v u�@�Ω�w�� �Ω�w�iH�� XML \αC

v pGww�UCΣñ@�Ahb�P⌠ULkw�⌠≤ΣL DB2 Ω�wú�G

– IBM Data Server Runtime Client

– IBM Data Server Driver Package

– DB2 ΩTñ�

v uDB2 w�vδFμ�úⁿD�σr�C

v pGzb Windows VistaBWindows 2008 �≤s�W���w�Ah�����

�≤ DB2ADMNS � DB2USERS s�A�α⌡μ�� DB2 ⁿO���{íAoO

© Copyright IBM Corp. 1993, 2009 17

Page 24: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

]��B��w�\α (���s��ε) �¡ε���z��w]M�vCpG�

��ú�≤Σñ@�s�AhL∩�� DB2 tm���{íΩ�Núπ�¬�vC

{�

Yn��uDB2 w�vδFG

1. ��wq� DB2 w����u�z�vbßnJt�C

2. pGz�� DB2 Ω�wú� DVDA�NªíJ��≈CpGw����⌡μ\αA

h�����uDB2 w���{ívCpG��⌡μ B@A���uWindows �

���v�s² DB2 Ω�wú� DVDA�÷ΓUuw�v��AH��uDB2 w

���{ívC

3. pGwq Passport Advantage Uⁿ DB2 Ω�wú�A�⌡μi⌡μ�AH�X DB2

Ω�wú�w���C���uWindows ����v�s² DB2 w���A�÷

ΓUw���AH��uDB2 w���{ívC

4. ziHzLuDB2 w�v��{í��°w��������N��A�O

iμw�Cziα�Qn�\w��������N��AH�o�s�ΩTC

5. ÷@Uw�ú�Aw�ú�°í�π�i�w����ú�C

pGqúW� w�{s DB2 Ω�wú�A�÷@Uw�sú����w�Cϕ�

uDB2 w�vδF�ú��≥iμw�C

pGqúW��ww�@�{s DB2 Ω�wú�AhiHG

v ÷@Uw�sú�AH��s� DB2 ��C

v ÷@U��{s�ú�AH≤s{s� DB2 ��AN\αsW�{s� DB2 �

�A��{s� DB2 � 8 �B9.1 � � 9.5 ���A��w��[ú�C

6. uDB2 w�vδF�P�t�yÑA����yÑ�w�{íCuWí��ⁿ�z

⌡μΣl�BJCYnIsuWí�A�÷@Uí��÷ F1CziHH�÷@U�

°÷sA�⌠w�@�C

�G

�w]ADB2 Ω�wú��w�b Program_Files\IBM\sqllib ²UAΣñ

Program_Files Nϕ Program Files ²��mC

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

xx O�rAq 01 }lA���ww�� DB2 ����W[C

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

U@B

v τ�z�w�C

v ⌡μ�n�ßmw�@�C

p�w��í�J�º����÷ΩTA��\�≤ My Documents\DB2LOG\ ²ñ�

w�Θx�CΘx����UCμíGDB2-ProductAbrrev-DateTime.logApADB2-

ESE-Tue Apr 04 17_04_45 2008.logC

pGoO Vista 64 ��Ws� DB2 ú�w�ABz�� 32 �� OLE DB Pro-

viderAh��Γ�n² IBMDADB2 DLLCYnn²� DLLA�⌡μUCⁿOG

18 Linux � Windows W DB2 w���zJ�

Page 25: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

c:\windows\SysWOW64\regsvr32 /s c:\Program_Files\IBM\SQLLIB\bin\ibmdadb2.dll

ΣñAProgram_Files Nϕ Program Files ²��mC

pGn²z� DB2 Ω�wú�iHs���qú�zL⌠⌠s�t@xqúW� DB2

σ≤Ah��w�uDB2 ΩTñ�vCuDB2 ΩTñ�v]t DB2 Ω�wt�� DB2

�÷ú��σ≤C�w]ApG NuDB2 ΩTñ�vw�b��AhiHq Web s

� DB2 ΩTC

DB2 Express Edition � DB2 Workgroup Server Edition O�Θ¡ε

pGzbw� DB2 Express EditionAh�\�ΩO�ΘW¡O 4 GBC

pGzbw� DB2 Workgroup Server EditionAh�\�ΩO�ΘW¡O 16

GBC

tm�Ω�O�Θ�qO� INSTANCE_MEMORY Ω�w�z{ítm�Mw�C

q 9.1 � 9.5 �����½n�N��G

v pG 9.1 � DB2 Ω�wú��O�ΘtmWXe\�¡εAh DB2

Ω�wú�b���{μ��ºßAiαLk��C

v �μ�πO�Θ�z{íAú�WL�v¡ε�W[z�πΘΩ

O�Θ¡εC

� 4 � w� DB2 °A� (Windows) 19

Page 26: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

20 Linux � Windows W DB2 w���zJ�

Page 27: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

� 5 � �� DB2 w�δFw� DB2 °A� (Linux)

�@�í�p≤b Linux @�t�W��uDB2 w�vδFCziH��uDB2 w�v

δF�wqw��n]wAHbz�t�Ww� DB2 Ω�wú�C

}lºe

b��uDB2 w�vδFºeG

v �Twt��Xw�BO������DC

v TOzww�Σ��s²� (Firefox 2.0+BMozilla 1.7+ � SeaMonkey 1.1.4)C

v ziH�� root �D root v¡Aw� DB2 °A�Cp�D root ¡�w���÷

ΩTA�\�÷��C

v DB2 Ω�wú�M����i�CziH�RΩΘ DB2 Ω�wú� DVDA�q

Passport Advantage® Uⁿw�M��A��o DB2 w�M��C

v pGzOw�D�σ��� DB2 Ω�wú�Ah��π�Aϕ�uΩayÑM≤vC

v uDB2 w�vδFO�w�{íCz���ie{�í������ X Win-

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

b⌡μCTwzwAϕa�Xπ�e�CpAexport DISPLAY=9.26.163.144:0C

v pGb⌠�ñ��w�nΘAh��Γ����n� DB2 ���A�α��uDB2

w�vδFC

v pGzW��� IBM Tivoli Monitoring for Databases: DB2 AgentAhbw� DB2

ú�ºeA�\DDu�� DB2 w�{íw� IBM Tivoli Monitoring for Data-

bases: DB2 AgentvAH�o �Ω��¡εC

¡ε

v ⌠≤���bßAúLk⌡μh�uDB2 w�vδFΩC

v u���rX� UTF-8 wqBu�@��w�� ��w�iH�� XML \

αC

v uDB2 w�vδFμ�úⁿD�σr�C

{�

Yn��uDB2 w�vδFG

1. pGz�ΩΘ DB2 Ω�wú� DVDA�ΘJUCⁿOA�½��ⁿ DB2 Ω�w

ú� DVD �²G

cd /dvdrom

ΣñA/dvdrom Nϕ DB2 Ω�wú� DVD ��ⁿIC

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

a. �úYú���G

gzip -d product.tar.gz

Σñ product O�Uⁿºú��WC

b. Untar ú���G

© Copyright IBM Corp. 1993, 2009 21

Page 28: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

b Linux @�t�W

tar -xvf product.tar

Σñ product O�Uⁿºú��WC

c. �½²G

cd ./product

Σñ product O�Uⁿºú��WC

�: pGwUⁿuΩayÑM≤vAhNª untar ��P�²ñCo�b�P�

²ñ��l² (pA./nlpack)A�i²w�{í��Σ�w�M���L�ú

�C

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

4. Y�}�uIBM DB2 w���{ívCziHqo�°íñ�°w������

��N��A�Oiμw�Cz]iH�\w��������N��AH

�o�sΩTC

5. ÷@Uw�ú�Aw�ú�°í�π�i�w����ú�C

÷@Uw�sú�AH��w�Cϕ�uDB2 w�vδF�ú��≥iμw�C

�lw�ßA��≥�¿��uDB2 w�vδFw�e��∩�∩�Cw�í��

ⁿ�z⌡μΣl�BJCYnIsw�í�A�÷@Uí��÷@U F1CziHH

�÷@U�°÷sA�⌠w�@�C

�G

Y�D root ¡�w�ADB2 Ω�wú��@�w�b $HOME/sqllib ²ñAΣñ

$HOME NϕD root �����l²C

Y� root ¡�w�Ah�w]ADB2 Ω�wú��w�bG

Linux /opt/ibm/db2/V9.7

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

_xx O�rAq 01 }lA���ww�� DB2 ����W[C

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

DB2 w�⌠π�UCWhG

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

v úαWX 128 �r�

v úα]tμ

v úα]tD�σr�

w�Θx��G

v DB2 w�Θx�C�������� DB2 w�ΩTA]A��C

– Y� root ¡�w�Ah DB2 w�Θx�WO db2setup.logC

– Y�D root ¡�w�Ah DB2 w�Θx�WO db2setup_username.logAΣ

ñ username O⌡μw��D root ��� IDC

22 Linux � Windows W DB2 w���zJ�

Page 29: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

v DB2 ��Θx�C������� Java™ ����⌠≤��ΘX (pAº�¼p

�]�ΩT)C

– Y� root ¡�w�Ah DB2 ��Θx�WO db2setup.errC

– Y�D root ¡�w�Ah DB2 ��Θx�WO db2setup_username.errAΣ

ñ username O⌡μw��D root ��� IDC

�w]Ao�Θx��≤ /tmp ²ñCziHⁿwΘx���mC

ú�A� db2setup.his ��C���ADB2 w�{í�N DB2 w�Θx����x

sb DB2_DIR/install/logs/ ²ñA�½sRW� db2install.historyCpG�W

wsbAh DB2 w�{í�NΣ½sRW� db2install.history.xxxxAΣñ xxxx

� 0000-9999A°�≈�W�w���wC

C�w���ú��O��{��MμCpG�úw���Ah]��ú�w�⌠

U��{��C��s�@�bw�YN�⌠�⌡μA�BpG{íb�¿ºe�ε

�ñ�Ahú����{��C

U@B

v τ�z�w�C

v ⌡μ�n�ßmw�@�C

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

OA�w�uΩayÑM≤vC

b Linux x86 WApGn²z� DB2 Ω�wú�iHs���qú�zL⌠⌠s�t

@xqúW� DB2 σ≤Ah��w�uDB2 ΩTñ�vCuDB2 ΩTñ�v]t DB2

Ω�wt�� DB2 �÷ú��σ≤C

DB2 Express Edition � DB2 Workgroup Server Edition O�Θ¡ε

pGzbw� DB2 Express EditionAh�\�ΩO�ΘW¡O 4 GBC

pGzbw� DB2 Workgroup Server EditionAh�\�ΩO�ΘW¡O 16

GBC

tm�Ω�O�Θ�qO� INSTANCE_MEMORY Ω�w�z{ítm�Mw�C

q 9.1 � 9.5 �����½n�N��G

v pG 9.1 � 9.5 � DB2 Ω�wú��O�ΘtmWXe\�¡εA

h DB2 Ω�wú�b���{μ��ºßAiαLk��C

v �μ�πO�Θ�z{íAú�WL�v¡ε�W[z�πΘΩ

O�Θ¡εC

� 5 � ��uDB2 w�vδFw� DB2 °A� 23

Page 30: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

24 Linux � Windows W DB2 w���zJ�

Page 31: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

� 3 g τ�z�w�

© Copyright IBM Corp. 1993, 2009 25

Page 32: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

26 Linux � Windows W DB2 w���zJ�

Page 33: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

� 6 � ���nBJτ� DB2 °A��w� (Linux � Windows)

ziHq SAMPLE Ω�wñs�Ω�A�τ� DB2 °A�w�O�w�Q�¿C

z��w�u�εñ�v�u�nBJv�≤AH⌡μ�@�C

u�nBJvbuDB2 w�vδF�\α∩�°íñOC�J��≤CªObu@δv

w�{�ñiμw�A�iHb⌡μu�qvw��∩�C

u�εñ�v�≤u�b Linux (�¡ x86 � AMD64/EM64T) � Windows (�¡ x86

� AMD64/EM64T) W�i�C

1. b Linux WAHΩ���¡�nJt�C

2. ���nBJG

v b Windows @�t�WA÷@U}lA�∩�{í� -> IBM DB2 -> [DB2 �

�W�] -> ]wuπ > �nBJ

v b Linux � Windows @�t�WAiHΣJ db2fs ⁿO���u�nBJvC

3. ziH∩�n���Ω�w½≤�¼�Ω�w�mCb Windows WAziH∩�n

�� SAMPLE Ω�w���≈Ab Linux WAhiH∩�n�� SAMPLE Ω�w�

²C

4. o�ⁿO�ßO����í�BzCb�� SAMPLE Ω�wßAz�¼�@��¿

TºC÷@UTwC

5. ��u�εñ�vCb Windows WA÷@U}lA�∩�{í� -> IBM DB2 ->[DB2 ��W�] -> @δ�zuπ -> �εñ�Cb Linux t�WAΣJ db2cc ⁿ

OC

6. bu�εñ�ve��¬íμñAi}½≤≡H�° SAMPLE Ω�w� SAMPLE Ω�

w½≤Cbu�εñ�ve��kíμñ∩�uϕμv½≤H�° SAMPLE Ω�wϕ

μC���½kΣ÷@UϕμW staffA�∩�ud�vCbⁿOsΦ�°íñA

÷@U⌡μ÷sH⌡μd�A�d��G�C

bτ�w�ºßAYi�ú SAMPLE Ω�wH�X��íCM�ApGzW�Q�d

���{íAh�Od SAMPLE Ω�wC

�ΘJ db2 drop database sample ⁿOH�≤ SAMPLE Ω�wC

z]iH��u�nBJv��dú�≤s�AHTwz�D DB2 ú��i�ú�

≤s��[j\αC

© Copyright IBM Corp. 1993, 2009 27

Page 34: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

28 Linux � Windows W DB2 w���zJ�

Page 35: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

� 7 � ��ⁿOμBz� (CLP) τ�w�

ziH�� SAMPLE Ω�w�⌡μ SQL ⁿO���dΩ�AHτ�w�C

����

v ib\α∩�ñΣ�� SAMPLE Ω�w�≤��w�bt�WAB]A≤@

δw�ñC

v z��Oπ� SYSADM v¡����C

Ynτ�w�A�G

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

2. ΘJ db2start ⁿOH��Ω�w�z{íC

3. ΘJ db2sampl ⁿOAH�� SAMPLE Ω�wC

o�ⁿO�ßO����í�BzCS��¿TºFϕⁿOú�r����AY

ϕ�Bzw�¿C

b�� SAMPLE Ω�w�A���HΩ�wOW SAMPLE iμsC

4. s� SAMPLE Ω�wB����bí� 20 ñu@º�u�MμA�½]Ω�ws

uC�qⁿOμBz� (CLP) ñΘJUCⁿOG

connect to sample"select * from staff where dept = 20"

connect reset

ΘX��PUC��ⁿG

ID NAME DEPT JOB YEARS SALARY COMM---- --------- ------ ----- ------ -------- ---------

10 Sanders 20 Mgr 7 98357.50 -20 Pernal 20 Sales 8 78171.25 612.4580 James 20 Clerk - 43504.60 128.20190 Sneider 20 Clerk 8 34252.75 126.50

∩�� 4 ºO²C

bτ�w�ºßAYi�ú SAMPLE Ω�wH�X��íC�ΘJ db2 drop data-

base sample ⁿOH�≤ SAMPLE Ω�wC

© Copyright IBM Corp. 1993, 2009 29

Page 36: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

30 Linux � Windows W DB2 w���zJ�

Page 37: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

� 8 � ��u�����@�Ω�wvδF����v�Ω�w

u���� @�Ω�wvδFO]wΩ�w���ΦíCδF���zú��≥�

ΩTG

v bz∩�����²W��sΩ�w

v �z�Ω�ⁿw��í

v w∩���α�tmsΩ�w

v }��� @

v tmHqll≤�Is{í�ΦíAbΩ�w�nHO�J�q�

u���� @�Ω�wvδFiHqu�nBJv��A�Oqu�εñ�v

��C

²Mn≤

v pGzQqu�nBJv��δFAh]��w�u�nBJv�≤Cu�nB

JvOuDB2 w�vδFñJ��≤���@í≈CªObu@δvw�{�ñiμ

w�A�iHb⌡μu�qvw��∩�C

v z���� SYSADM � SYSCTRL v¡AH⌡μ�@�C

v Y� LinuxAh���iHe{�í������ Xwindow nΘAu�nBJv

�u�εñ�v�αb≈�W⌡μCTwzwAϕa�Xπ�e�CpAexport

DISPLAY=9.26.163.144:0C

v b Linux WATww]HΩ��� (db2inst1) ¡≈nJCΩOsΩ�w�]

wtm���ΦΩ�w�z{í⌠�C

1. Hzn����Ω�w����bßnJt�C

2. HUCΦíº@A��u���� @�Ω�wvG

v qu�nBJvG÷@U��z�v�Ω�wC

v qu�εñ�vG÷@U��Ω�wΩ�¿C÷@U��Ω�wíμñ���s

Ω�wC

3. ϕ�δF�BJCú�÷≤sΩ�w�í≈����n]wA]AΣWAH�b

U�¼pUiHq��p�HÑ�C

pGzOqu�nBJv���v�Ω�wAhz{biH��u�εñ�vA}l

�����z�Ω�wCYniμ��@A�÷@Uu�nBJvñ���Ω�wC

© Copyright IBM Corp. 1993, 2009 31

Page 38: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

32 Linux � Windows W DB2 w���zJ�

Page 39: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

� 9 � DB2 uπ�D\αϕ�� (Linux)

w�ºßAziHsW�� DB2 uπ�D\αϕC

b Linux @�t�WAiNUC DB2 uπsW�D\αϕG

v �d DB2 ≤s�

v ⁿOμBz� (CLP)

v Command Line Processor Plus (CLPPlus)

v tm�U{í

v �εñ�

v �nBJ

v Query PatrollerC

iHQ����Γ��ΦíANo� DB2 uπsW�D\αϕC⌡μUC⌠≤@�

DB2 ⁿO�A�����D\αϕ�G

v db2icrt

v db2iupdt

v db2nrcfg

v db2nrupdtC

��H root ¡�⌡μ db2icrt � db2iupdt ⁿOC db2nrcfg � db2nrupdt A�≤D root

¡�w�AB�Ω���⌡μC

Ynd�\αϕ�Aziα�n½s��α�C

⌡μUC@�ⁿO�A����úD\αϕ�G

v db2_deinstall (�úD root ¡�w��A���ú DB2 D root Ω�\αϕ�)

v db2idropC

��Az�iHzL⌡μUCⁿOAΓ�����úD\αϕ�G

v db2addicons sW\αϕ�

v db2rmicons �ú\αϕ�

⌡μ db2addicons ⁿOºeA��²]w{μ���� DB2 Ω⌠�CYn]wΩ

⌠�AiH��GInstance_HOME/sqllib/db2profile (A�≤ Bourne Shell � Korn Shell

���) � Instance_HOME/sqllib/db2chsrc (A�≤ C Shell ���)AΣñ

Instance_HOME OΩ�����l²C

© Copyright IBM Corp. 1993, 2009 33

Page 40: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

34 Linux � Windows W DB2 w���zJ�

Page 41: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

� 4 g DB2 ú��v

© Copyright IBM Corp. 1993, 2009 35

Page 42: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

36 Linux � Windows W DB2 w���zJ�

Page 43: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

� 10 � DB2 �v�

�Γ��¼��v�P DB2 Ω�wú��÷pG≥��vX��π�vXCo��v

Xxsb�σr��ñAo���q���v���v �C

y≥�z�vú��⌠≤��vCª]Ab DB2 Ω�wú�w�CΘñABbw�{

��í��M�CpAdb2ese.lic O DB2 Enterprise Server Edition �≥��v�C

�� DB2 Ω�wú� (]A DB2® Connect™) �C@�∩��Ω�w\αú�n�v

XCbu�� CDv� /db2/license ²ñiΣ��vXA� CD @�ú�w�CΘ

�@í�ú�CpAdb2ese_u.lic O�vXABiHbu DB2 Enterprise Server Edi-

tion for Linux, UNIX, and Windows - �v���∩��� CDvWΣ�C�w]Ab

DB2 Ω�wú�w��íú�M��vXCM�AUCú�ú�nu�� CDvA]�

�bw�L{��M��vG DB2 Express-C � DB2 Connect Personal EditionC�

�A DB2 Personal Edition ]OSC¿� DB2 Personal Edition π�u�� CDvA

²]�bw��í��M�Σ�vC

p��v��MμA�\� 38��ϕ 3C

@δ�ÑADB2 Ω�wú���v�RΦíAiH��C�Bz� (�Bz���μ�

(PVU) IO)A����v���CiH��Cí°A��R DB2 Express EditionC IBM

Database Enterprise Developer Edition Ow∩C�oi{í�vCuDB2 Storage Opti-

mization S�vOSC]�ª�i� PVU �R (B�ϕ≥ªΩ�wt�]� PVU

�v�i�R)C

pGz�RF DB2 Ω�wú��μWIO�\αAh�nM�h��vXCC@�

DB2 Ω�wú�� DB2 \αúπ��v��vXC��bP≥ª DB2 Ω�wú��

P�¼O�εU≥o��\αCpAYz�Rt��C�Bz��v� DB2 Enter-

prise Server EditionAh]N�n�Bz��R DB2 Performance Optimization S�C

pGzqUCΣñ@�⌠�Uⁿ DB2 Ω�wú��\αA²S�u�� CDvAhi

H÷UCΦk�o�vXG

v Passport AdvantageGziHq Passport Advantage ⌠��ou�� CDvM��Ghttp://

www.ibm.com/software/lotus/passportadvantage/C�� Passport Advantage �Az��

�OUⁿC@�ú��\α�u�� CDvM��C

v PartnerWorld®G�p� PartnerWorld H�oAϕ��vXC�\ PartnerWorld ⌠

�Ghttp://www.ibm.com/partnerworld/pwhome.nsf/weblook/index_pub.html

v DB2 Σ�ñ���{íñ�⌠�GpGz� �R�vXA�p� IBM PΓN

ϕC

ϕz�oAϕ��vXºßA��b�� DB2 Ω�wú�ºeM�ªCo]�n

²�vX�sW�vC��z� DB2 Ω�wú�n²�vXA@�l�� �t�W

ww� DB2 Ω�wú��\α�@�≈εCziHbUC⌠}Σ� DB2 Ω�wú�

�v°�Ghttp://www.ibm.com/software/slaC

DB2 Ω�wú��\α��vzLUCuπiμ�zG

v db2licm �v�zuπⁿOA�OA

© Copyright IBM Corp. 1993, 2009 37

Page 44: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

v u�εñ�vñ�u�vñ�vC

ϕ 3. DB2 �v�

�v�W� DB2 Ω�wú��\α

db2aac.lic DB2 Advanced Access Control S�

db2conpe.lic DB2 Connect Personal Edition

db2consv.lic DB2 Connect Server ( �v≥�{í)

db2consv_as.lic DB2 Connect Application Server Edition

db2consv_ee.lic DB2 Connect Enterprise Edition

db2consv_is.lic DB2 Connect Unlimited Edition for System i

db2consv_zs.lic DB2 Connect Unlimited Edition for System z

db2dede.lic IBM Database Enterprise Developer Edition

db2dpf.lic DB2 Database Partitioning S�

db2ese.lic DB2 Enterprise Server Edition ( �v≥�{í)

db2ese_c.lic DB2 Enterprise Server Edition (CPU ∩�)

db2ese_u.lic DB2 Enterprise Server Edition (u�v���v

∩�)

db2exp.lic DB2 Express Edition ( �v≥�{í)

db2exp_c.lic DB2 Express Edition (CPU ∩�)

db2exp_s.lic DB2 Express Edition (°A�∩�)

db2exp_sftl.lic DB2 Express Edition (°A�∩��°�nΘ

��v)

db2exp_u.lic DB2 Express Edition (u�v���v∩�)

db2exp_uftl.lic DB2 Express Edition (�v���∩��°�

n��v)

db2expc_uw.lic DB2 Express-C ( OT)

db2geo.lic DB2 Geodetic Data Management \α

db2hrese.lic DB2 Enterprise Server Edition �PΦ g\α

db2haexp.lic DB2 High Availability S� for DB2 Express

Edition

db2pe.lic DB2 Personal Edition

db2poese.lic DB2 Performance Optimization S� for DB2

Enterprise Server Edition

db2so.lic DB2 Storage Optimization S�

db2wse.lic DB2 Workgroup Server Edition ( �v≥�{

í)

db2wse_c.lic DB2 Workgroup Server Edition (CPU ∩�)

db2wse_u.lic DB2 Workgroup Server Edition (u�v���v

∩�)

bwdb2.lic DB2 �≥�{í x\α

ewdb2.lic DB2 �°� x\α

iwebe.lic InfoSphere™ Warehouse Enterprise Base Edition

iwde.lic InfoSphere Warehouse Developer Edition

38 Linux � Windows W DB2 w���zJ�

Page 45: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

ϕ 3. DB2 �v� (�≥)

�v�W� DB2 Ω�wú��\α

iwdpb_c.lic InfoSphere Warehouse Departmental Base Edi-

tion CPU ∩�

iwdpb_u.lic InfoSphere Warehouse Departmental Base Edi-

tion �v���∩�

iwdp_c.lic InfoSphere Warehouse Departmental Edition CPU

∩�

iwdp_u.lic InfoSphere Warehouse Departmental Edition �

v���∩�

iwee.lic InfoSphere Warehouse Enterprise Edition

sam31.lic IBM Tivoli System Automation for Multiplatforms

(SA MP)

pGz��H _t.lic ����v�AhªO��nΘ�vC

� 10 � DB2 �v 39

Page 46: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

40 Linux � Windows W DB2 w���zJ�

Page 47: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

� 11 � �� db2licm ⁿOn² DB2 ú��\α�vX

�� db2licm ⁿOAHM��v � (]�n²�vX)C

Yn�¿�@�Az��π�Aϕ��v� (*.lic)C�\� 37��� 10 �, yDB2

�v�zC

b Windows @�t�WAz���≤�� Administrators � Power Users s�AHf

t�� db2licm ⁿOP -a ⁿO�C

v b Windows @�t�WAzLΘJUCⁿOAn² DB2 �vXG

db2instance_path\bin\db2licm -a filename

ΣñAdb2instance_path O�� DB2 Ω��mA� filename O∩�≤zw�R�

ú��\αº�v���π⌠W���WC

v b Linux @�t�WAzLΘJUCⁿOAn² DB2 �vXG

INSTHOME/sqllib/adm/db2licm -a filename

ΣñAINSTHOME NϕΩ�����l²A� filename O∩�≤��Rú��

\αº�v���π⌠W���WC �iHbw� DB2 Ω�wú��⌠ñ

Σ� db2licm ⁿOCpApGz��w]w�²Ahb AIX®BHP-UX � Solaris

@�t�W� /opt/ibm/db2/V9.7/admC

© Copyright IBM Corp. 1993, 2009 41

Page 48: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

42 Linux � Windows W DB2 w���zJ�

Page 49: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

� 12 � ���vñ�n² DB2 ú��\α�vX

qu�vñ�vA��usW�vv°íAb Linux � Windows @�t�WsW�vC

��@]�M��v ��sW�vC

½n: b 9.7 �ñw≤�u�vñ�vA�iα≤ ���ñ�úC p��÷ΩTA�

\ 9.7 ��sW\α�ñ�uw≤��εñ�uπ� DB2 �z°A� (DAS)vD

DC

Yn�¿�@�Az��π�Aϕ��v� (*.lic)C�\� 37��� 10 �, yDB2

�v�zCb Linux @�t�WAΩ�����π��v��b²�¬��⌡μM

�vC

Ynn² DB2 �vXG

1. ÷@Uu�εñ�v� AH}�u�vñ�vC∩�znsW�v�t�C

2. ∩�@�ΩC

3. w��ú�μ�Nπ�ww��ú�WC∩�@�ú�C

4. q�v\αϕ∩�sWC Y�}�usW�vv∩�C

5. ∩�znsW��vX (*.lic)C

6. ÷@UTwAHsW�vXC

N�Y½sπzu�vñ�v��vΩTC

© Copyright IBM Corp. 1993, 2009 43

Page 50: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

44 Linux � Windows W DB2 w���zJ�

Page 51: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

� 13 � �d DB2 �v{�

C@� DB2 Ω�wú��\αúπ�PΣ�÷p��vXC�� DB2 Ω�wú��

\αºeA��²n²�vXCYnτ��v{�A�⌡μ db2licm ⁿO�ú���°

iC

�: pGzww� DB2 Ω�wú���M��Ah�M��]A���º��ñ�í

i�\α�s�vC

1. �τ�zwn² DB2 Ω�wú���vXC

a. }�u�vñ�v�oXⁿO db2licm -lC

b. �du�v�¼vΩTC

v pGz���v�¼Gu}oH�vAhϕ�z� DB2 Ω�wú�O@�

Database Enterprise Developer Edition for Linux, UNIX®, and Windows �@

í���o�Cb�ípUA IBM Database Enterprise Developer Edition �

v°��u²���¬≤@δ DB2 ú��v°�C

v pGz���v�¼Gu��ⁿ¡vAhϕ�z� DB2 Ω�wú�O@�t

@� IBM ú��@í���o�Cb�ípUAú�H���v°�AΣu

²��¬≤@δ DB2 ú��v°�C

v pGz���v�¼Gu�n²�vvAhϕ��n²F≥��vXCz�

�w∩ DB2 Ω�wú�n²Aϕ��π�vXC

2. �τ�zwn² DB2 \α��vXC

a. �� db2licm ⁿO�u�vñ�v�d� ENV_FEATURE_INFO �z°�Aú

���°iC

v YnzL�� db2licm ⁿOú���°iA�oXⁿOG

db2licm -g filename

ΣñAfilename OnxsΘX�⌠��WC

v CYnqu�vñ�vú���°iA�∩��v → ú�°iC

v Ynb ENV_FEATURE_INFO �z°�ñd���ΩTA�s�Ω�w�

oXUCd�G

SELECT * FROM SYSIBMADM.ENV_FEATURE_INFO

b. �R��°iC pGz n²w��L� DB2 \α�vXAh��°i�N\

αCX�uHWvC

3. zLn²Aϕ��vX��úHW��A�M���DC

© Copyright IBM Corp. 1993, 2009 45

Page 52: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

46 Linux � Windows W DB2 w���zJ�

Page 53: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

� 14 � ≤s���v

pGzw��Oπ����v� DB2 ú�AB{bQn≤s��π�vAhz��≤

sú��vXC

zLk��o�ΦkAq@� DB2 ú�≤s¿t@� DB2 ú�C

pG²e�v� DB2 °A�ú���úsbAhμ@°A��M≤M��iH��

w�⌠≤ DB2 Ω�w°A�ú�Cb�ípUAww��nΘ��vO��nΘ�vC

Yn≤sz� DB2 �vG

1. �o�vXC�vXiHqUC�m�oG

v q Passport Advantage Uⁿ���ΣA�

v q IBM ¼��ΩΘCΘ]ñ�u�� CDvC

2. ��u�vñ�v� db2licm ⁿO�n²�vXC

�: LkN 32 �� Linux W� DB2 Enterprise Server Edition ��nΘ�vA≤

s�í@��vC

© Copyright IBM Corp. 1993, 2009 47

Page 54: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

48 Linux � Windows W DB2 w���zJ�

Page 55: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

� 5 g �²PßO

© Copyright IBM Corp. 1993, 2009 49

Page 56: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

50 Linux � Windows W DB2 w���zJ�

Page 57: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

�² A. �����w� DB2 ú�

���w�≥�º�

PuDB2 w�vδFúP�OADB2 ���w�ú�nM⌠≤���¼�AYi²z

w� DB2 ú�C

���O@���σσr�AΣñ]t]w�tmΩTC����ⁿwtm�w�

�AH�nw��ú���≤C

�Φkú��U≤jW�íp DB2 ú�AP�]�U≤bz��qw�Ptm{�ñA

HzqΦíO DB2 w�{�C

ziH��UC⌠≤Φk������G

v �∩�ú��Σñ@�d���Cd����≤ DB2 ú� DVD �UC²G

db2/platform/samples

Σñ platform OⁿAϕ�wΘ¡xC

v ��uDB2 w�δFvA��z�ú��ΘJAxsw��tmΩ�CpGz∩��

∩�AbuDB2 w�vδFñ�����Ah�w]A��� (pGzw�h½��

⌠�Ah°A���@����A�� ]��@����) N�xsbo��mC

�w]A����xs� Windows @�t�W� My Documents ñAH� Linux @

�t�W� /tmp ñC

v �����ú��Aq{sww��tm� DB2 ú�������C

���w�]iH�Ln��w����w�C

����N��

b}liμ���w�ºeAz��A�UC�N��G

v ÷M� 8 ��� 9 �ñ������μí�ⁿA²∩≤≤BiH�����h��

�¡εCpADB2 � 9 �ñú��⌠≤���úuα��w� DB2 � 9 �ú�

(pA9.5 ��≤s�)F���Lk�≤w� DB2 � 8 �C�ºτMADB2 � 8

�ñú�����Lk�≤w� DB2 � 9 �CoDnO�≤� 9 �ñ]ts��

n÷ΣrC

v b Linux ¡xWAw∩ root ¡�w�������iαLk�D root ¡�w��

�Cí����÷Σr�∩ root ¡�w���Cp� �ΩTA�\���÷Σ

rC

v pGz��uDB2 w�vδFAhG

– bw��íAziHbuDB2 w�vδF�∩�w��@e�ñANz�]wxs

b���ñC

– u���b⌡μ�w�@�������CpGz�tm�ϕ�μA�OzQ

��peyß�q����Ah��z���ΦkC

– u�z�w�{��¿BΣ�Q�¿�A��ú����CpG�°w�A�O

w�ó�Ahú������C

© Copyright IBM Corp. 1993, 2009 51

Page 58: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

– ���Φk������Y �∩AhLkb db2isetup ⁿO -r �ñ��C��w�δF���b db2isetup ⁿOñ������A��[H�∩A�α�XU

C°≤G

- ��]t÷Σr FILE

- úα]t÷ΣrGPRODBLIC_AGREEMENT � INSTALL_TYPEC

v zi�����b⌠⌠W�C@�u@�w��PtmA�w�Y� DB2 ú��h

½tmCMßziHN���te�znw��ú��u@�C

v pGz�����ú��Ah���{s�w�������CpGz�tm��

�° (HΓ�Φítm)Ah��z���ΦkCpGO�����ú��ú����

�Ahiα�nΘJ���W�KXC

��uDB2 w�vδF�����

ziH��uDB2 w�vδFA��b⌡μ�w�@�������C������

�z�uDB2 w�vδF∩��ú�CMßAziH�����AQ��P]w�⌡μ

LHíw�C

Yn��uDB2 w�vδF������A�G

1. quDB2 w�v��{íñAw∩znw��ú�∩�w�sú�A�∩���{

s�ú�AH∩�n��� DB2 ��C

2. ∩�nw��ú�� DB2 ��AA÷U@BAH��uDB2 w�vδFC

3. buw∩��v��W÷U@BA�ⁿ�vX�°�C

4. b∩�w��¼°íñA∩�u@δvBuúYv�u�qvw�C

5. b∩�w�B������Γ�°íñA∩�N��w�]wxsb���ñ∩

�A�boíqúWw�ú�A�N��]wxsb���ñ∩�CMßAb��

�W�μ�ñAΣJzn²uDB2 w�vδF±m�ú�º����⌠C�w]A

����W� Prod_<abbrev>.rspA�Bxs≤ directory1C

�:

a. pG∩�N��w�]wxsb���ñ∩�Ahú�bqúWw�⌠≤n

ΘAu���π����W�μ�ñ�ⁿwW����C

b. pG∩����Ω�ww�Ah�ú�Γ����A@��≤��Ω�q

úA@��≤P�qúCPqú����W�����Ωºqú�W

�ú�C�w]A�� ����W� Prod_<abbrev>.rspA�Bxs≤

directory2C

6. ∩�zQn�∩�AH�≥BzΣl�w�e�C

7. b}l�s��������°íñA�\�∩��]wC

8. Ynw�ú�A�÷@U�¿C

9. �¿w��AuDB2 w�vδFN�N�ú�����±mbzⁿw�⌠ñC�

�uDB2 w�vδF������A�NSϕ÷Σr ENCRYPTED sW����C

pG

DAS_PASSWORD = 07774020164457377565346654170244883126985535505156353ENCRYPTED = DAS_PASSWORD

ENCRYPTED ÷ΣrⁿXΩ��KX�úOπ���r��C

52 Linux � Windows W DB2 w���zJ�

Page 59: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

�² B. �d DB2 ú�≤s��

�d DB2 ≤s��

�dú�≤s�AHTwz�D DB2 ú��i�ú�≤s��[j\αC

÷≤o�@�

b DB2 ú�w��íAw]���≤sA�C≤sA�i²z�≥o�ú�≤s�A

pG

v DB2 ú����≤s���÷TºC

v �NΩ� (p��ⁿ�B⌠⌠�e����) �i��C

v PzP��í��÷� IBM μPí�C

ziH��UC⌠@Φí�s�ú�≤s�G

v ��ⁿOμ

v ��u�nBJv

v b Linux @�t�WA��D\αϕC

v b Windows @�t�WApGw� DB2 ú��S��¬M�vAh���≤sA

�C

¡ε

v �≤sA��n⌠�⌠⌠suC

v b Windows @�t�WA��u}lv\αϕñ� C

{�

��UCΣñ@�Φí�s� DB2 ú�≤s��[j\αG

v ��ⁿOμAΘJG

db2updserv

v ��u�nBJvG

– ziHΣJ db2fs ⁿO���u�nBJvC

– b Windows @�t�WA÷@U}lA�∩�{í� -> IBM DB2 -> [DB2 �

�W�] -> ]wuπ -> �nBJ

÷@U}l�dú�≤s��÷sC

v b Windows @�t�WA��u}lv\αϕñ� A÷@U}lA�∩�{í

� -> IBM DB2 -> [DB2 ��W�] -> ΩT -> �d DB2 ≤s��C

v b Linux @�t�WA÷@UD\αϕAMß∩� IBM DB2 -> �d DB2 ≤s�

�G

��o�≤sA�AziH�°i� DB2 ú�≤s��MμA�A� DB2 ú�≤

s�� ��C

© Copyright IBM Corp. 1993, 2009 53

Page 60: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

54 Linux � Windows W DB2 w���zJ�

Page 61: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

�² C. M� DB2 ��M≤

M���M≤

��zb�s��M≤h�W⌡μ DB2 Ω�w⌠�AHTO@�S��DCYn�

Qw��M≤A�⌡μ���n�w²w��ßmw�@�C

÷≤o�@�

DB2 �M≤]tb IBM ���í�o{º�D�≤s��{í (u�v{í�R

°ivA� APAR)AH��ß�°iº�D��{íCAPARLIST.TXT ��í�C@

��M≤ñ]t��{íABi≤UC⌠}UⁿGftp://ftp.software.ibm.com/ps/

products/db2/fixes/english-us/aparlist/C

�M≤O�[�Coϕ�b⌠≤ DB2 �w����s�M≤ñAút� DB2 P

@��ºe�M≤ñ���≤sC

i���M≤M���G

v μ@°A�M��C

μ@°A�M��]t�� DB2 Ω�w°A�ú�� IBM Data Server Client ��

�s��w≤s�{íXCpGh� DB2 Ω�w°A�ú�w�bμ@�mWAh

DB2 Ω�w°A��M≤�N @{íX≤sM����ww�� DB2 Ω�w°

A�ú�CData Server Client �M≤]tbY� DB2 Ω�w°A��M≤ñ (τ

YAiH�UC⌠@�Ω�w°A�ú�ú�A���M≤G DB2 Enterprise Server

EditionB DB2 Workgroup Server EditionB DB2 Express EditionB DB2 Personal Edi-

tionB DB2 Connect Enterprise EditionB DB2 Connect Application Server EditionB

DB2 Connect Unlimited Edition for zSeries®A� DB2 Connect Unlimited Edition for

i5/OS®)CziH�� DB2 Ω�w°A��M≤AH�� Data Server ClientC

�w]A]iHQ� DB2 ����vA��μ@°A�M��Aw�Sw�M≤

h��⌠≤ DB2 Ω�w°A�ú�C

v C@�ΣL DB2 Ω�wú���M≤C

ubww�D°A�Ω�wú���[{íú��A������M≤CpA

IBM Data Server Runtime Client � DB2 Query PatrollerC

pGww�� DB2 Ω�wú�uO DB2 Ω�w°A�ú�� Data Server Cli-

entA�ún����¼��M≤C�∩�μ@°A�M���M≤C

∩≤ Windows ¡xApG�h� DB2 Ω�wú� (��]A@�úO Data Server

Client � DB2 Ω�w°A��ú�) w�bμ@ DB2 ��ñAhz��Uⁿ��

úY��∩��ú�Sw�M≤AMß�α���M≤w�{�C

v q��M≤C

ww�h� DB2 Ω�wú��q��M≤A�w�⌠�C

© Copyright IBM Corp. 1993, 2009 55

Page 62: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

pGww�� DB2 Ω�wú�uO DB2 Ω�w°A�ú�� Data Server Cli-

entAhú�nq��M≤Cb�ípUA����μ@°A�M���M≤C

b Linux @�t�WApGww�ΩayÑAhz��n�O�ΩayÑ�M≤CΩ

ayÑ�M≤LkμWw�Cq��M≤�ú�ⁿw��M≤��P�M�A

BΓ������Ph���M≤CpApGzb Linux WM�q��{í�D

�σ� DB2 Ω�wú�Ah��P�M�q��M≤�ΩayÑ�M≤AH≤s

DB2 Ω�wú�C

¡ε

v DB29.7 � �M≤�iM�≤ DB29.7 � q�� (GA) � DB29.7 � �M≤

��C

v bw��M≤ºeA���εPb≤s� DB2 ���÷��� DB2 ΩBDAS

���{íC

v b���Ω�w⌠�ñAbw��M≤ºeAz���ε��Ω�w�� °A

�W�Ω�w�z{íCz��b��Ω�Ω�w�� °A����ΣLΩ�

w�� °A�Ww��M≤C��NPΩ���qú≤s��P��M

≤h�C

v b Linux@�t�WG

– pGzbu⌠⌠��t� (NFS)vñπ� DB2 Ω�wú�Ah��Twbw��

M≤ºew���εUC�G��ΩBDB2 �z°A� (DAS)B{�íq

T (IPC)AH����P NFS �ⁿw��ΣL≈�W���{íC

– pGt�ⁿO fuser � lsof Lk��Ah installFixPack ⁿONLk��ⁿJ�

DB2 ��Cz��Tw ⁿJ DB2 ��A�ú�m½∩��w��M≤Cb

Linux WA�n fuser ⁿO� lsof ⁿOC

p�m½∩�� �Ω�A�\ installFixPack ⁿOC

v b�ß���{íWAbwM��M≤ºßAYn⌡μ��{í���s�A�

����π�s�v¡C

v w� DB2 �M≤ú��u IBM Data Studio �zD�xv� IBM Data Studio ú

�A�C

{�

Ynw��M≤G

1. �d�M≤���C

2. w��M≤ºe⌡μ�n�@�C

3. ∩��M≤w�Φk�w��M≤C

4. w��M≤ºß⌡μ�n�@�C

5. M�Aϕ� DB2 Ω�wú��vC

pG²e�v� DB2 °A�ú��� sb≤≈�Ahμ@°A��M≤M��

iH��w�⌠≤ DB2 Ω�w°A�ú�Cb�ípUAw�� DB2 Ω�wú�

�°�����vABNb 90 ����í�⌠ß�εB@AúDz������

vC

U@B

56 Linux � Windows W DB2 w���zJ�

Page 63: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

�dΘx�Ad�O��⌠≤ßmw�BJA�O����Tº����@C

Y� Linux W�D root ¡�w�AiH�� db2rfe ⁿO�� root ¼\α (pu¬

i��v�@�t�¼�O)CpGbw� DB2 Ω�wú�ºß�� root ¼\αAh

z��bC�M��M≤�½s⌡μ db2rfe ⁿOAH½s��o�\αCp� �Ω

�A�\U��D root �÷��C

pGzb�P�t�W�h� DB2 ��Ah����iH�≤úP�����M≤

h�CpGnN�M≤M��@�HW� DB2 ��Az��v@b�� DB2 ��

Ww��M≤C

�² C. M� DB2 �M≤ 57

Page 64: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

58 Linux � Windows W DB2 w���zJ�

Page 65: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

�² D. �úw�z� DB2 ú�

�úw� DB2 ú� (Windows)�@�ú�q Windows @�t����ú DB2 ú��BJC�ϕúA�n{s� DB2

Ω�Ω�w�A�⌡μ�@�C

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

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

≥��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 ú� (Linux)�@�ú�q Linux @�t��ú DB2 ú��BJC

ú�n�@�AYiw�s��� DB2 ú�CLinux W�C@� DB2 ú���úπ

�úP�w�⌠A]�iH�sbP@íqúWC

© Copyright IBM Corp. 1993, 2009 59

Page 66: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

�: �@�M���� root v¡w�� DB2 ú�C�ODDi��p≤�úw�HD

root ���¡�w�� DB2 ú�C

Yn�ú DB2 ú�A�⌡μUCBJG

1. ∩��G�≤��Ω�wCziH��u�εñ�v� drop database ⁿO��≤Ω

�wC�≤Ω² ²�≤Ω�w�A��t�W�Ω�w����Od�πC

2. �εuDB2 �z°A�vC�\ w� DB2 °A�ΓUC

3. �úuDB2 �z°A�vA�⌡μ dasupdt ⁿOANuDB2 �z°A�v≤s�Σ

Lw�⌠CYn�úuDB2 �z°A�vA�\ w� DB2 °A�ΓUC

4. �ε�� DB2 ΩC�\ w� DB2 °A�ΓUC

5. �ú DB2 ΩA�⌡μ db2iupdt ⁿOANΩ≤s�t@�w�⌠CYn�ú

DB2 ΩA�\ w� DB2 °A�ΓUC

6. �ú DB2 ú�C�\ w� DB2 °A�ΓUC

�ε DB2 �z°A� (Linux)b�ú DB2 ú�ºeA��²�ε DB2 �z°A� (DAS)C

�úw� DB2 ú��ApGzb�ú�ß@� DB2 ��Ah���≤ DASCpG

zπ�ΣL DB2 ��Ah��z⌡μ dasupdt ⁿOAH�� DAS PΣL DB2 ��

�÷pCpGzMw�≤ DASAh��²�ε DASC

�: �@�úiM�� DB2 ú��D root ¡�w�C

Yn�ε DB2 �z°A�A�⌡μUCBJG

1. H DB2 �z°A����¡�nJC

2. ΘJ db2admin stop ⁿOH�ε DB2 �z°A�C

�ú DB2 �z°A� (Linux)pG�ú�ß@� DB2 ��Ah���²�ú DB2 �z°A� (DAS)AMß�ú DB2

ú�C

pG�ú@� DB2 ��A²�π�ΣL DB2 ��AhqnN DB2 DAS PΣ�÷p

� DB2 ��⌡μ dasupdt ⁿOC

�: �@�uαM���� root v¡w�� DB2 ú�C

Yn�ú DASA�G

1. Hπ� root v¡����¡�nJC

2. �ε DASG

db2admin stop

3. ΘJUCⁿOH�ú DASG

DB2DIR/instance/dasdrop

Σñ DB2DIR Ozb DB2 w��íⁿw��mCLinux �w]w�⌠O /opt/

ibm/db2/V9.7C

60 Linux � Windows W DB2 w���zJ�

Page 67: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

�ε root Ω� (Linux)z���εPb�úw�º DB2 ���÷p��� DB2 ΩC�úw�{μ��

iαú�vTPΣL DB2 ���÷p�ΩC

Yn�ε DB2 ΩA�⌡μUCBJG

1. Hπ� root v¡����¡�nJC

2. ΘJUCⁿOAH�oP{μ DB2 ���÷p��� DB2 ΩWMμG

DB2DIR/bin/db2ilist

Σñ DB2DIR Ozb DB2 � 9 �w��íⁿw��mCLinux �w]w�⌠O

/opt/ibm/db2/V9.7C

3. pG Script J .profile ñA�⌡μªC

. INSTHOME/sqllib/db2profile (bash, Bourne, or Korn shells)source INSTHOME/sqllib/db2cshrc (C shell)

Σñ INSTHOME OΩ��l²C

4. ��zxsUC��G

v Ω�w�z{ítm� $HOME/sqllib/db2systm

v �Itm� $HOME/sqllib/db2nodes.cfg

v $HOME/sqllib/function ñ����wqτ��j≈xs{���{í

5. ΘJ db2stop force ⁿOAH�ε DB2 Ω�w�z{íC

6. T{wΘJ db2 terminate ⁿOA�εFΩC

7. ∩≤C@�Ω½�o�BJC

�ú DB2 Ω� (Linux)�@���p≤�út�W�í���� root ΩC

�: �@�úiM��D root ¡�w�CYn�úD root ΩAz���úw� DB2

ú�C

pG�ú�ß@� DB2 � 9 ���AziH�²�ú DB2 ΩAMß�ú DB2 ú

�CpG�ú@� DB2 � 9 ���A²�π�ΣL DB2 � 9 ���AziHqn

N DB2 ΩPΣ�÷p� DB2 ��⌡μ db2iupdt ⁿOC

�úΩßApGbt@��P���ΩUs�Ω���� DB2 Ω�wAhi

H���Ω�wCúD�TRúΩ�w��A�hY��úΩAΩ�w��O��

πABiH½��C

�ϕzúW��� DB2 ú�A��úQN{sΩ����s��� DB2 ú��A

�i�ú DB2 ΩC���ns������� DB2 ú�ww�CpGw�úPΩ

�÷p� DB2 ��AhLk���ΩC

Yn�úΩA�G

1. Hπ� root v¡����¡�nJC

2. ∩��GpGzTwúA�n÷pΩ�w�Ω�AhiHqt�ñ�úΩ�w�

�A�b�≤Ωºe�≤Ω�wC

3. ΘJUCⁿOH�úΩG

�² D. �úw�z� DB2 ú� 61

Page 68: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

DB2DIR/instance/db2idrop InstName

Σñ DB2DIR Ozb DB2 w��íⁿw��mCLinux �w]w�⌠O /opt/

ibm/db2/V9.7C

db2idrop ⁿO�qΩMμ�úΩn²A��ú INSTHOME/sqllib ²AΣñ

INSTHOME OΩ��l²A� InstName OΩ�nJWCpGznb

/sqllib ²ñxs⌠≤��Aho��@N�úo���CpGz��no��

�Az��b�≤ΩºeAs@ª���C

4. ∩��GHπ� root v¡����¡�A�úΩ������� ID Ms� (Y

�∩�Ω���)CpGzp�½�ΩA�ún�ú��� ID Ms�C

�: oO∩�BJA]�iα≥≤ΣL�A��Ω����Ω���s�C

�� db2_deinstall � doce_deinstall ⁿO�ú DB2 ú� (Linux)�@�ú��� db2_deinstall ⁿO�ú DB2 ú�� DB2 �≤�BJCdb2_deinstall

ⁿO�qz�t��ú�� DB2 ú�Cdoce_deinstall ⁿO��úP doce_deinstall u

π�b�Pw�⌠ñ�uDB2 ΩTñ�vC�ⁿOuA�≤ Linux @�t�C

qt�ñ�ú DB2 ú�ºeA�TOzw⌡μ� 59 ��y�úw� DB2 ú�

(Linux)z ñí����BJ

�:

v �@�M���� root v¡w�� DB2 ú�C

v zúα����@�t���{í (p rpm � SMIT) ��ú DB2 ú�C

v doce_deinstall ⁿOuA�≤ Linux x32 � x64C

YnqSw⌠�úí DB2 ú�G

1. H root ���¡�nJC

2. s� DB2 ú��b�⌠C

3. �⌡μUCΣñ@�ⁿOG

v Yn�ú{μ�mñww�� DB2 ú��\αA�q DB2DIR/install ²⌡μ

db2_deinstall -F ⁿOC

v Yn�ú{μ�mñww���� DB2 ú�A�q DB2DIR/install ²⌡μ

db2_deinstall -a ⁿOC

v Yn������ú DB2 ú�A�q DB2DIR/install ²⌡μ db2_deinstall -r

<response_file> ⁿOCziH��d�����úw�ú�CpAdoce_deinstall

-r db2un.rsp

v Yn�ú{μ�m�uDB2 ΩTñ�vA�q DB2DIR/install ²⌡μ

doce_deinstall -aC

v Yn������úuDB2 ΩTñ�vA�q DB2DIR/install ²⌡μ

doce_deinstall -r <response_file> ⁿOCziH��d�����úw�uΩT

ñ�vCpAdoce_deinstall -r doceun.rsp

ΣñADB2DIR Ozbw� DB2 ú��ⁿw��mC

62 Linux � Windows W DB2 w���zJ�

Page 69: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

�² E. 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ºí�

�: uDB2 Ω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úCpG�⌠≤p≤∩i DB2 σ≤���A�Hq

ll≤�e� [email protected] DB2 σ≤ñ�\¬z���NúA²ú�

��C�ú�Swd�iα�mA²�iH≤R��A�z��DCpGn∩S

w�DD�í��ú�NúA�[WDD�D� URLC

����o�qll≤�}�p�uDB2 �ßΣ�ñ�vCpG�σ≤ �M� DB2

�N�DA�s�ϕa IBM A�ñ�H�o≤UC

LΩ�y� PDF μí� DB2 �NO�

U�Uϕí�iq IBM Publications Center www.ibm.com/shop/publications/order �o

DB2 ��wCPDF μí� DB2 9.7 � �σ�M����ΓUiHq www.ibm.com/

support/docview.wss?rs=71&uid=swg2700947 UⁿC

���y÷MϕμⁿX�LΩ�A²iαbz�Ωa�a Lkú�C

C�≤sΓU�A��Y�W[C�Twz\¬�O�s���ΓUAC�pUC

© Copyright IBM Corp. 1993, 2009 63

Page 70: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

�: uDB2 ΩTñ�v�≤sWv¬≤ PDF �LΩ�yC

ϕ 4. DB2 �NΩT

W� �� �LΩ� e�≤s

Administrative API Refer-

ence

SC27-2435-00 O 2009 � 8 δ

Administrative Routines

and Views

SC27-2436-00 � 2009 � 8 δ

Call Level Interface Guide

and ReferenceAVolume 1

SC27-2437-00 O 2009 � 8 δ

Call Level Interface Guide

and ReferenceAVolume 2

SC27-2438-00 O 2009 � 8 δ

Command Reference SC27-2439-00 O 2009 � 8 δ

Data Movement Utilities

Guide and Reference

SC27-2440-00 O 2009 � 8 δ

Data Recovery and High

Availability Guide and

Reference

SC27-2441-00 O 2009 � 8 δ

Database Administration

Concepts and Configura-

tion Reference

SC27-2442-00 O 2009 � 8 δ

Database Monitoring

Guide and Reference

SC27-2458-00 O 2009 � 8 δ

Database Security Guide SC27-2443-00 O 2009 � 8 δ

DB2 Text Search Guide SC27-2459-00 O 2009 � 8 δ

Developing ADO.NET and

OLE DB Applications

SC27-2444-00 O 2009 � 8 δ

Developing Embedded

SQL Applications

SC27-2445-00 O 2009 � 8 δ

Developing Java Applica-

tions

SC27-2446-00 O 2009 � 8 δ

Developing Perl, PHP,

Python, and Ruby on

Rails Applications

SC27-2447-00 � 2009 � 8 δ

Developing User-defined

Routines (SQL and Exter-

nal)

SC27-2448-00 O 2009 � 8 δ

Gett ing Started with

Database Application

Development

GI11-9410-00 O 2009 � 8 δ

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-00 O 2009 � 8 δ

w� IBM Data Server

Clients

GC40-2455-00 � 2009 � 8 δ

64 Linux � Windows W DB2 w���zJ�

Page 71: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

ϕ 4. DB2 �NΩT (�≥)

W� �� �LΩ� e�≤s

Tº�ΓU�@U SC40-2460-00 � 2009 � 8 δ

Tº�ΓU�GU SC40-2461-00 � 2009 � 8 δ

Net Search Extender

Administration and User’s

Guide

SC27-2469-00 � 2009 � 8 δ

Partitioning and Cluster-

ing Guide

SC27-2453-00 O 2009 � 8 δ

pureXML Guide SC27-2465-00 O 2009 � 8 δ

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-00 � 2009 � 8 δ

SQL Procedural Lan-

guages : App l i ca t i on

Enablement and Support

SC27-2470-00 O 2009 � 8 δ

SQL ReferenceAVolume

1

SC27-2456-00 O 2009 � 8 δ

SQL ReferenceAVolume

2

SC27-2457-00 O 2009 � 8 δ

Troubleshooting and Tun-

ing Database Perfor-

mance

SC27-2461-00 O 2009 � 8 δ

��� DB2 9.7 � SC40-2453-00 O 2009 � 8 δ

Visual Explain ⁿ��� SC40-2462-00 � 2009 � 8 δ

DB2 9.7 ��sW\α SC40-2459-00 O 2009 � 8 δ

Workload Manager Guide

and Reference

SC27-2464-00 O 2009 � 8 δ

XQuery Reference SC27-2466-00 � 2009 � 8 δ

ϕ 5. DB2 Connect - Sw��NΩT

W� �� �LΩ� e�≤s

w��tm DB2 Con-

nect Personal Edition

SC40-2456-00 O 2009 � 8 δ

w��tm DB2 Con-

nect °A�

SC40-2458-00 O 2009 � 8 δ

DB2 Connect ��ΓU SC40-2457-00 O 2009 � 8 δ

�² E. DB2 �NΩTº[ 65

Page 72: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

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

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 �⌠@U�S�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

�: p��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

– 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

66 Linux � Windows W DB2 w���zJ�

Page 73: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

3. �ú���NϕzQnq���yW���Cp��W���A�\� 63

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

÷≤ DB2 9.7 ��DDAuDB2 ΩTñ�v� URL � http://publib.boulder.ibm.com/

infocenter/db2luw/v9r7/

÷≤ DB2 9.5 ��DDAuDB2 ΩTñ�v� URL � http://publib.boulder.ibm.com/

infocenter/db2luw/v9r5/

÷≤ DB2 � 9 ��DDAuDB2 ΩTñ�v� URL � http://publib.boulder.ibm.com/

infocenter/db2luw/v9/

÷≤ D B 2 � 8 ��DDA��� 8 �uΩTñ�v� U R LG h t t p : / /

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

buDB2 ΩTñ�vñHz�n�yÑπDD

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

2. TwwNz�n�yÑⁿw�yÑMμñ��@��C

– YnNsyÑsW�MμñA�÷@UsW... ÷sC

�: sWyÑ�úO�qúπ�H��nyÑπ�DD����r¼C

– YnNyÑ��Mμ�A�∩�yÑA÷@UW�÷sA�yÑ¿�y

ÑMμ��@�yÑ�εC

3. Mús²���AMß½sπz��AY�Hz�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

�² E. DB2 �NΩTº[ 67

Page 74: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

– YnNsyÑsW�MμñA�÷@UsW... ÷sAqusWyÑv°íñ∩�yÑC

– YnNyÑ��Mμ�A�∩�yÑA÷@UW�÷sA�yÑ¿�y

ÑMμ��@�yÑ�εC

3. Mús²���AMß½sπz��AY�Hz�n�yÑ�π�uDB2 ΩTñ

�vC

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

{�

�DD z��≤s�L{Cp�Γ�≤sⁿ�A�\uΓ�≤sqú�°�í

⌠⌠°A�Ww�� DB2 ΩTñ�vDDC

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. ⌡μ ic-update ScriptG

ic-update

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

68 Linux � Windows W DB2 w���zJ�

Page 75: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

c. qw�²s²� doc\bin ²C

d. ⌡μ ic-update.bat ��G

ic-update.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

Γ�≤s��w��uDB2 ΩTñ�v�Az�nG

1. �εqúW�uDB2 ΩTñ�vAMß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

�: pGz�⌠��nb s�⌠�⌠⌠�≈�Ww�uDB2 ΩTñ�v≤sA

h���ws�⌠�⌠⌠�ww�uDB2 ΩTñ�v�≈�AN≤s⌠�ΦM�

����t�CpGz�⌠⌠N�\h���w�σ≤≤sAhP�iHb��Φ

M≤s⌠���≤s⌠��� ProxyAHε�C����⌡μ≤s����íC

pG�≤sΩ�]A���u≤sv\α��oΩ�]CM�Au≤sv\αuA

�≤W�í�íC

3. �εW�íuΩTñ�vA�½s��qúW�uDB2 ΩTñ�vC

�: b Windows 2008 M Windows Vista (�≤¬��) WA��H�z�¡��⌡μ

��ß��C�ⁿOCYn}�π��π�z�M�v�ⁿOú���uπA��

�½kΣ÷@U �∩�H�z�¡⌡μC

Yn≤sqúW�°�í⌠⌠°A�Www��uDB2 ΩTñ�vA�G

1. �εuDB2 ΩTñ�vC

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�⌠CuDB2 ΩTñ�vw]�w�b <Pro-

gram Files>\IBM\DB2 Information Center\Version 9.7 ²ñAΣñ <Pro-

gram Files> Nϕ Program Files ²��b²C

c. qw�²s²� doc\bin ²C

�² E. DB2 �NΩTº[ 69

Page 76: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

d. ⌡μ help_start.bat �G

help_start.bat

v b Linux WG

a. s²�ww�uΩTñ�v�⌠CuDB2 ΩTñ�vw]�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

�: help_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

�: help_end Script ]t�n�ⁿOAiHw�a�εw�� help_start Script

���{�C�ún��ΣL⌠≤Φk��ε help_start ScriptC

7. ½s��uDB2 ΩTñ�vC

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

≤s�uDB2 ΩTñ�v�π�s�H�≤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

70 Linux � Windows W DB2 w���zJ�

Page 77: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

DB2 ⁿ���

Yn�°ⁿ���A�÷@U�DC

ypureXML®z �≤ pureXML Guide

]w DB2 Ω�wHxs XML Ω�AH���� XML Ω�xsw�⌡μ

≥�@�C

yVisual Explainz �≤ Visual Explain ⁿ���

�� Visual ExplainAH�RB�� M�π SQL »zíi��o����αC

DB2 �°��ΩT

�UíU���°��M�DP�ΩTi≤Uz�� DB2 Ω�wú�C

DB2 σ≤

p��°��ΩTA�\ DB2 Troubleshooting Guide �u DB2 ΩTñ�v

�uΩ�w≥�º�v qCziHb�BΣ�p≤�� DB2 E�uπ���

{í�j≈��O�D��÷ΩTB@��ú�D��MΦ�AH�p≤�M

�� DB2 Ω�wú��iαo�º�D�ΣL�÷��C

DB2 Technical Support ⌠�

pGzDJ�DB�n≤UMΣiα�]M�MΦ�A�\ DB2 Techni-

cal Support ⌠�C Technical Support ⌠�i����s� DB2 �yB

TechNotesBu�v{í�R°i (APAR ����{í)vB�M≤�ΣL

Ω�CziHb���wñiμjMA�z��DMΣiα��MΦ�C

Yns� DB2 Technical Support ⌠�A�yX http://www.ibm.com/software/

data/db2/support/db2_9/

°�

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

�² E. DB2 �NΩTº[ 71

Page 78: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

72 Linux � Windows W DB2 w���zJ�

Page 79: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

�² F. �N��

�ΩTYw∩ IBM bⁿΩ�ú�ºú�PA��}oCD IBM ú���÷ΩTOH

�σ≤�@�X��i��ΩT�≥ªA�B�úw��≤C

bΣLΩañAIBM iαú�ú���ñ�ú�U�ú�BA��\αCn�Dz�b

�O�i��o�ú�PA��A�Vϕa� IBM A�Nϕd�C��bú� IBM

ú�B{í�A��Aúϕ��t�uα�� IBM �ú�B{í�A�Cun I�

IBM �z]úvA⌠≤\α�ϕ�ú�B{í�A�úiH�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�τ�H�G

IBM Director of Licensing

IBM Corporation

North Castle Drive

Armonk, NY 10504-1785

U.S.A.

Ynd��÷����r� (DBCS) ΩT��v�yA�p�zΩa� IBM z]ú

í�A�����ΦíH�G

Intellectual Property Licensing

Legal and Intellectual Property Law

IBM Japan, Ltd.

3-2-12, Roppongi, Minato-ku, Tokyo 106-8711 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�p�G

IBM Canada Limited

Office of the Lab Director

© Copyright IBM Corp. 1993, 2009 73

Page 80: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

8200 Warden Avenue

Markham, Ontario

L6G 1C7

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º⌠≤�αΩ�A�Oo��ε�⌠�º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

��]tlyÑ�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��t�o�{í�

¡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 I B M �ΣL�q���Cbu�@v���ΩTv⌠� (⌠}�

www.ibm.com/legal/copytrade.shtml) ñA�{μ� IBM ��MμC

UCNyOΣL�q�����U��

v Linux O Linus Torvalds bⁿΩ� (�) ΣLΩa�a º��C

74 Linux � Windows W DB2 w���zJ�

Page 81: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

v Java ��� Java ¼����xO Sun Microsystems, Inc. bⁿΩ� (�) ΣLΩa

���C

v UNIX O The Open Group bⁿΩ�ΣLΩa��U��C

v IntelBIntel �xBIntel Inside®BIntel Inside �xBIntel® Centrino®BIntel Centrino �

xBCeleron®BIntel® Xeon®BIntel SpeedStep®BItanium® � Pentium O Intel Cor-

poration �Σ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

�² F. �N�� 75

Page 82: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

76 Linux � Windows W DB2 w���zJ�

Page 83: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

��

����HñσrA�σrA�Sϕ��º���

CC

e��fσ≤

LΩ 63

°���� 71

º[ 63

PDF 63

e�f���

w�

�¼ 51

�m 51, 52

��

uDB2 w�vδF 52

º[ 51

w�

���

�¼ 51

w��q 14

�� CLP τ� 29

����� 51

��u�nBJvτ� 27

�D

Linux 11

Windows 5

Windows �¬M�v 6

�� @δF

���w 31

eC�f@�t��D

Linux 11

Windows 5

≤s

DB2 ΩTñ� 68, 69

≤s�

�d 53

t��z�s�

DB2 Ω�w

Windows 8

eK�f���M�v

Windows 8

�N�� 73

eE�f��

�� DB2 w�δF���� 52

Ω�w

�� @δF 31

d�w 27

ßmw�@�

D\αϕ� 33

ⁿO

jεε��{í 61

db2idrop 61

db2ilist 61

db2sampl 29

db2start 8

db2stop 61

db2_deinstall 62

doce_deinstall 62

ⁿOμBz� (CLP)

τ�w� 29

ⁿ���

�DP� 71

�°�� 71

Visual Explain 70

q� DB2 �y 66

�nBJ

ú�≤s� 53

τ�

DB2 w� 27

eQ�f�M≤

M� 55

�y

q� 66

O�Θ�D 3

eQ@�f�ε

�z°A� 60

root Ω 61

© Copyright IBM Corp. 1993, 2009 77

Page 84: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

�DP�

i�ΩT 71

ⁿ��� 71

�v

≤s���v 47

�vñ� 43

db2licm ⁿO 41

º[ 37

�d�� 45

�vñ�

≤s���v 47

n²�v 43

�z�v 37

�d�� 45

�≤

root Ω 61

°�

��X�� 71

�ú

DAS 60

DB2 Ω�w

Windows 59

root Ω 61

n�D

Linux 11

Windows 5

eQG�fLn��w�

����� 51

�D

Linux 11

Windows 5

eQT�f�úw�

DB2 Ω�w

Windows 59

db2_deinstall ⁿO 62

doce_deinstall ⁿO 62

Ω�w

Q�u�� @vδF��Ω�w 31

��

Q�u�� @vδF��Ω�w 31

eQ��fΩ

�ε root 61

�≤ 61

�ú 61

Ω (�≥)

root

�ú 61

�°��

ⁿ��� 71

suΩT 71

��í�D 3

�z°A�

�ε 60

⌠⌠��t� (NFS) w�

b Linux W 11

í�

tmyÑ 67

SQL »zí 67

�D

O�Θ 3

�� 3

eGQT�fτ�

DB2 w�

��u�nBJv 27

DuDB2 w�vδF

����� 52

DB2 °A�

w�

Windows 17

DB2 ΩTñ�

HúP�yÑ��° 67

≤s 68, 69

�� 67

yÑ 67

DB2 �z°A� (DAS)

�ε 60

�ú 60

db2licm ⁿO

n²�v 41

�z�v 37

�d�� 45

db2_deinstall ⁿO

�ú DB2 ú� 62

doce_deinstall ⁿO

{� 62

LLinux

w��D 11

�ú

DB2 root Ω 61

78 Linux � Windows W DB2 w���zJ�

Page 85: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

Linux ��w

libaio.so.1 11

libstdc++so.5 11

Rroot Ω

�≤ 61

�ú 61

SSAMPLE Ω�w

x 27

τ�w� 27

SQL »zí

π�í� 67

SYSADM

Windows 8

sysadm_group tm� 8

UUNIX

�ú

DB2 ú� 62

�ú DB2 root Ω 61

VVisual Explain

ⁿ��� 70

WWindows @�t�

w�

DB2 °A� (�� DB2 w�δF) 17

DB2 °A� (�D) 5

IBM Data Server Client (�D) 5

t��z�v¡ 8

��D Administrator ���b�w�

]w�¬M�v 6

�P���v¡ 8

�úw� DB2 59

�� 79

Page 86: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

80 Linux � Windows W DB2 w���zJ�

Page 87: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla
Page 88: IBM DB2 9.7 for Linux, UNIX, and Windowspublic.dhe.ibm.com/ps/products/db2/info/vr97/pdf/zh_TW/... · 2009-07-16 · – Firefox 2.0 ≤s – Internet Explorer 6.0 ≤s – Mozilla

����

Printed in Taiwan

GI13-0694-00