DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux,...

125
IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

Transcript of DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux,...

Page 1: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

IBM DB2 10.5for Linux, UNIX, and Windows

DB2 10.5 ��sW\α

SC27-3197-00

���

Page 2: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00
Page 3: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

IBM DB2 10.5for Linux, UNIX, and Windows

DB2 10.5 ��sW\α

SC27-3197-00

���

Page 4: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

��

b���ΩTH�ªΣ��ú�ºeA�²\¬� 103���² D, 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⌠}� http://www.ibm.com/shop/publications/order

v YnMΣzϕa� IBM ��NϕA�⌡� IBM Directory of Worldwide ContactsA⌠}� http://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 2013.

Page 5: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

�²

÷≤�� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . vii����∩H . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . vii����c . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . vii¬G�����D . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ix

� 1 g sW\α . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1

� 1 � DB2 10.5 ��½I . . . . . . . . . . . . . . . . . . . . . . . . . . . 3

� 2 � ú�M�[j\α . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7

� 3 � i�z�[j\α . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9DB2 Ω�w�s �μ��� ϕμ∩�. . . . . . . . . . . . . . . . . . . . . . . . . . . 9sW NOT ENFORCED Dn�Σ��@¡εΣ� . . . . . . . . . . . . . . . . . . . . . . 9

� 4 � �°[j\α . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11�μ��� ϕμ�s�°�q . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11sμ�iWi HADR �°�α . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18

� 5 � ¬i��B�≈BOⁿB�����[j\α . . . . . . . . . . . . . . . . . 19DB2 pureScale ⌠�ñ{bΣ� HADR . . . . . . . . . . . . . . . . . . . . . . . . . . 19DB2 Advanced Copy Services (ACS) Script ��i²�ß Script ≤e÷�� . . . . . . . . . . . . . 19

� 6 � �α[j\α . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21�μ��� ϕμ�s��ΩT . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21ϕ�í¼�iWid��α . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21���TÑhíΩw� DB2 pureScale S� �α[j\α . . . . . . . . . . . . . . . . . . . . 21IBM DB2 pureScale S� �μ�πO�Θ[j\α . . . . . . . . . . . . . . . . . . . . . . 22

� 7 � SQL �e�[j\α . . . . . . . . . . . . . . . . . . . . . . . . . . 23j¼εCΣ� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23q�ñ�ú NULL �Σ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23

� 8 � u@q�z[j\α . . . . . . . . . . . . . . . . . . . . . . . . . . . 25zL¿�l��qu@q¡� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25

� 9 � IBM Data Server Client �X�{í[j\α . . . . . . . . . . . . . . . . 27@δ�ß��X�{í[j\α . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27Ish��� (CLI) X�{í[j\α . . . . . . . . . . . . . . . . . . . . . . . . . . 27IBM Data Server Provider for .NET[j\α . . . . . . . . . . . . . . . . . . . . . . . . 29w[j JDBC � SQLJ Σ� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30

� 10 � DB2 σrjM[j\α . . . . . . . . . . . . . . . . . . . . . . . . . 33DB2 σrjMtm\α . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33DB2 σrjM�Twσ�Bz . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33� DB2 σrjM]wΓ�ⁿOΩw . . . . . . . . . . . . . . . . . . . . . . . . . . . 33DB2 σrjM�tm∩� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34

� 11 � w����[j\α . . . . . . . . . . . . . . . . . . . . . . . . . . 35�� DB2 ��{íw� IBM Data Studio Web D�x �≤ . . . . . . . . . . . . . . . . . . . 35

© Copyright IBM Corp. 2013 iii

Page 6: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

Guardium Installation Manager Client w�{íw�J DB2 °A�ú�ñ . . . . . . . . . . . . . . . 35DB2 pureScale ⌠� ñ��M≤w�w� . . . . . . . . . . . . . . . . . . . . . . . . 35w� DB2 pureScale S� w�� Root nJ]w . . . . . . . . . . . . . . . . . . . . . . 36

� 12 � �°����DP�[j\α. . . . . . . . . . . . . . . . . . . . . . . 37s�ⁿO��i[j�°���α . . . . . . . . . . . . . . . . . . . . . . . . . . . . 37

� 13 � DB2 pureScale S�[j\α . . . . . . . . . . . . . . . . . . . . . . 39≤¬�i�� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 39DB2 pureScale S� P DB2 Enterprise Server Edition ºí��� . . . . . . . . . . . . . . . . . 40½�[j\αi�ϕμ�@ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 40��μ�H≈��iw����vº . . . . . . . . . . . . . . . . . . . . . . . . . . 40DB2 pureScale ⌠�ñ�uW�M≤≤s�iWii�� . . . . . . . . . . . . . . . . . . . 41

� 2 g �≤\α . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 43

� 14 � �z�≤Kn . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 45w�≤ HADR ��l]w . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 45HADR Θx�s@�{bw]��� . . . . . . . . . . . . . . . . . . . . . . . . . . . 45w�≤í�Ω�w�z{ítm�� . . . . . . . . . . . . . . . . . . . . . . . . . . . 46w�≤í�n²�⌠��� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 46

� 15 � Ω�w]w�ú�w��≤Kn . . . . . . . . . . . . . . . . . . . . . . 49Ω�wtm����≤ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 49

� 16 � ��{í}o�≤Kn . . . . . . . . . . . . . . . . . . . . . . . . . 51wsW��≤í�t�¼²°�B��τ��s��B���z�í�°� . . . . . . . . . . . . . . 51

� 17 � DB2 ⁿO� SQL »zí�≤Kn . . . . . . . . . . . . . . . . . . . . 55

� 18 � 10.5 � ñw≤��\α . . . . . . . . . . . . . . . . . . . . . . . . 57w≤� db2DatabaseUpgrade API � COBOL � FORTRAN yÑΣ� . . . . . . . . . . . . . . . . 57w≤�í�n²�⌠��� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 57w≤��wεú�í�Ω�wtm�� . . . . . . . . . . . . . . . . . . . . . . . . . . 58

� 19 � 10.5 � ñw�εú��\α . . . . . . . . . . . . . . . . . . . . . . . 61wεú�A��O�Nz{íu²�� . . . . . . . . . . . . . . . . . . . . . . . . . . 61wεú�í��z�í . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 62úAΣ�í�@�t� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 63wεú����pΩ�]w� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 64wεú�í�n²�⌠��� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 64w≤��wεú�í�Ω�wtm�� . . . . . . . . . . . . . . . . . . . . . . . . . . 65

� 20 � 10.5 � �≤¡��ñw≤�Mw�εú�� DB2 \αKn . . . . . . . . . . 67

� 3 g DB2 Connect [j\α��≤Kn . . . . . . . . . . . . . . . . . . 85

� 21 � vT DB2 Connect Server � DB2 10.5 � [j\α��≤ . . . . . . . . . 87

� 4 g �²PßO . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 89

iv DB2 10.5 ��sW\α

Page 7: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

�² A. DB2 S�� DB2 ú���ñ�\α . . . . . . . . . . . . . . . . . . . . 91

�² B. DB2 Connect ú���ñ DB2 S��\α . . . . . . . . . . . . . . . . . 95

�² C. DB2 �NΩTº[ . . . . . . . . . . . . . . . . . . . . . . . . . . . 97LΩ�y� PDF μí� DB2 �N�w . . . . . . . . . . . . . . . . . . . . . . . . . . 97qⁿOμBz�π� SQL ¼Aí� . . . . . . . . . . . . . . . . . . . . . . . . . . . 99s�úP��� DB2 ΩTñ� . . . . . . . . . . . . . . . . . . . . . . . . . . . . 100ΩTñ��°� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 100

�² D. �N�� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 103

�� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 107

² v

Page 8: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

vi DB2 10.5 ��sW\α

Page 9: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

÷≤��

��ú� DB2® Database for Linux, UNIX, and Windows 10.5 �� DB2 Connect™ ú

��t�sW�w�≤\α�ΩTC

����∩H

��A�≤Ω�w�z�B��{í]pv�ΣL DB2 Ω�w���A�L�A�

DB2 10.5 � for Linux, UNIX, and Windows H� DB2 Connect 10.5 �ú��[j

\αAH� 10.5 �Po�ú��²eΣ���ºí�tºC

���ú�º[ΩTAú]t���í�º\α���ⁿ�CYn�oΣLΩTA�

���ú����C

p� 10.5 �i�S�P[j\αΩTA�\¬� 1��� 1 g, ysW\αzC

p� 10.5 ���≤BYN≤��w��\αΩTA�\¬� 43��� 2 g, y�≤

\αzC�ΩTⁿXb�� 10.5 �ºeAz�nD�½n�≤C

p� DB2 Connect ��÷ΩTA�\¬� 85��� 3 g, yDB2 Connect [j\α

��≤KnzC

����c

[\UCDDG

� 1 gGsW\α

� 3 ��� 1 �, yDB2 10.5 ��½Iz

��í�½nsWS��[j\α�ú�½IC

� 7 ��� 2 �, yú�M�[j\αz

��í� 10.5 �i�ú�]��≤C

� 9 ��� 3 �, yi�z�[j\αz

��í�iH≤UzH≤���í��zΩ�w�sWS��[j\αC

� 11 ��� 4 �, y�°[j\αz

��í�i���°Ω�wt��sWS��[j\αC

� 19 ��� 5 �, y¬i��B�≈BOⁿB�����[j\αz

��í�iTOOd���Ω��sWS��[j\αC

� 21 ��� 6 �, y�α[j\αz

��í�i≤UTObzs��≤sΩ��A≥��¬�α�sWS��[j

\αC

� 23 ��� 7 �, ySQL �e�[j\αz

��í�i≤UzNΣL����{sΩ�w��{í�α� DB210.5 � ⌠

��sWS��[j\αC

© Copyright IBM Corp. 2013 vii

Page 10: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

� 25 ��� 8 �, yu@q�z[j\αz

��í�s�u@q�z\αA�\αiXR���ñú��{�u@q�z

\αC

� 33 ��� 10 �, yDB2 σrjM[j\αz

��í� Net Search Extender �sWS��[j\αC

� 35 ��� 11 �, yw����[j\αz

��í�i≤�típ DB2 Ω�wú��≤�Pa�@ú��sWS��[j

\αC

� 39 ��� 13 �, yDB2 pureScale S�[j\αz

��í�iΣ� DB2 pureScale® �sWS��[j\αC

� 2 gG�≤���

� 45 ��� 14 �, y�z�≤Knz

��í�PΩ�w�z�÷�{s DB2 \α��≤C

� 49 ��� 15 �, yΩ�w]w�ú�w��≤Knz

��í�PΩ�w]w�ú�w��÷�{s DB2 \α��≤C

� 51 ��� 16 �, y��{í}o�≤Knz

��í�P��{í}o�÷�{s DB2 \α��≤C

� 55 ��� 17 �, yDB2 ⁿO� SQL »zí�≤Knz

��í�Σ�s\α� DB2 CLP ⁿOBDB2 t�ⁿO� SQL »zí�≤C

� 57 ��� 18 �, y10.5 � ñw≤��\αz

��CXYN≤��\αA�\αⁿ�O�Σ�²OúA�����Swτ

��\αA�Biα�b����ñ�H�úC

� 61 ��� 19 �, y10.5 � ñw�εú��\αz

��CX 10.5 �ñúΣ��S��\αC

� 67 ��� 20 �, y10.5 � �≤¡��ñw≤�Mw�εú�� DB2 \αKnz

��CX DB2 10.5 �ñw≤��úΣ��S��\αC

� 3 gGDB2 Connect [j\α��≤Kn

� 87 ��� 21 �, yvT DB2 Connect Server � DB2 10.5 � [j\�

≤z ��í� 10.5 � ñiα�vT{s DB2 Connect \α�[j\αBw�≤

\αBw≤��\α�wεú��\αC

� 4 gG�²

� 91 ���² A, yDB2 S�� DB2 ú���ñ�\αz

��²]t DB2 Ω�wú���� DB2 S�ñi�\α��÷ΩTC

� 95 ���² B, yDB2 Connect ú���ñ DB2 S��\αz

��²]t DB2 Connect ú���� DB2 S�ñi�\α��÷ΩTC

� 97 ���² C, yDB2 �NΩTº[z

��²]ts�H��� DB2 Ω�wt�º�sσ≤��÷ΩTC

� 103 ���² D, y�N��z

��²]tP�� DB2 Ω�wú��Σσ≤�÷�k��D�¡εC

viii DB2 10.5 ��sW\α

Page 11: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

¬G�����D�

PSw�M≤�÷p�DDA�bDD�D�}Y]A ″FPx″ r�AΣñ x Nϕ�

M≤h�C

����UC¬G�����DC

�Θ ⁿXⁿOB÷Σr�ΣL�t�w²wq�W���CHjg�g�ⁿO�

CLP ⁿOA�Hpg�g�ⁿOh�t�ⁿOC

�Θ ⁿXUCΣñ@�G

v ������ú��W�� (��)

v @δj�

v sNy���

v t@��ΩT���

Monospace r¼ ⁿXUCΣñ@�G

v ���²

v ⁿ�nbROú�r��°íñΣJ�ΩT

v Sw��d

v Pt�π��ⁿ�σrd

v t�Tºd

v {í]p{íXd

÷≤�� ix

Page 12: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

x DB2 10.5 ��sW\α

Page 13: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

� 1 g sW\α

usW\αv]A 10.5 �ñ�t�s\α��÷ΩTC

DB2 10.5 � for Linux, UNIX, and Windows ú�s�\αAi≤Uz�z¿�H�

���{í}oC

� 3 ��� 1 �, yDB2 10.5 ��½Iz

��í�½nsWS��[j\α�ú�½IC

� 7 ��� 2 �, yú�M�[j\αz

��í� 10.5 �i�ú�]��≤C

� 9 ��� 3 �, yi�z�[j\αz

��í�iH≤UzH≤���í��zΩ�w�sWS��[j\αC

� 11 ��� 4 �, y�°[j\αz

��í�i���°Ω�wt��sWS��[j\αC

� 19 ��� 5 �, y¬i��B�≈BOⁿB�����[j\αz

��í�iTOOd���Ω��sWS��[j\αC

� 21 ��� 6 �, y�α[j\αz

��í�i≤UTObzs��≤sΩ��A≥��¬�α�sWS��[j

\αC

� 23 ��� 7 �, ySQL �e�[j\αz

��í�i≤UzNΣL����{sΩ�w��{í�α� DB210.5 � ⌠

��sWS��[j\αC

� 25 ��� 8 �, yu@q�z[j\αz

��í�s�u@q�z\αA�\αiXR���ñú��{�u@q�z

\αC

� 33 ��� 10 �, yDB2 σrjM[j\αz

��í� Net Search Extender �sWS��[j\αC

� 35 ��� 11 �, yw����[j\αz

��í�i≤�típ DB2 Ω�wú��≤�Pa�@ú��sWS��[j

\αC

� 39 ��� 13 �, yDB2 pureScale S�[j\αz

��í�iΣ� DB2 pureScale �sWS��[j\αC

© Copyright IBM Corp. 2013 1

Page 14: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

2 DB2 10.5 ��sW\α

Page 15: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

� 1 � DB2 10.5 ��½I

IBM® DB2 10.5 � for Linux, UNIX, and Windows b DB2 Ω�wú�ñis�B

z��d�Ω�μíAH[tiμ�RBzCΣuI]AijTYu�Ω{�{

�ú���ΘτAu�n�C� DBA ]p�DH���d��πMú�u@AYi

F¿C�¿ípo��N�nBA]Aα��Γ²���úY\αBjTú��Rd

��αAH�α≈jT�C�α�ºC

DB2 �μ��� ϕμ

DB2 10.5 � ��iFA�≤ DB2 Ω�w�úY �μ��� ϕμA�w∩���

°d�]q�izLhϕμ�XB��ME�B∩P¼⌡�ϕμy��δ��Ω

�� ]�R�u@qA�JFsx��C

� DB2 10.5 � ���AziH� H�μ��xs� �μ��� ϕμCo�s\

αwgLO�Θ���BCPU ��� I/O ��C

DB2 10.5 � ��zLNo�WS�QkPLh 10 ��bΩ�wπsΦ��X���

�N}o��XAoH�≥ú�Γ²���hu@q�αCBLU AccelerationA�� IBM

Research and Development Labs ��s�XAªα≈��[tú�°i��RAwg

}loμ�Bb DB2 10.5 � ñπ���πX\αC�÷]w��μ��� BLU

Acceleration L��{�BE�A����Ω�wA�M�F¿Ñ¬�αPxsΘ�

vC]�Σ²��P DB2 10.5 � πXb@�A�HQ�o≡}���N�L��

≤ SQL �⌡C

DB2 10.5 � ��ú�UCU�G

v @�]w (DB2_WORKLOAD=ANALYTICS)A�H���μ��B��Sϕ�lO�Θt

mB���d≥jptmBí¼ P��u@q�z]��\t�⌠����

v s�ykA�Hb CREATE TABLE »zíWⁿwϕμxsΘ��]��\ CRE-

ATE TABLE »zí�

v s�Ω�wtm�� (dft_table_org)A�H�≤w]ϕμ��]��\ dft_table_org

- w]ϕμ���

v s� db2convert ��{íA�HN C��� ϕμα½� �μ��� ϕμ]��\ db2convert - NHεC���ϕμα½�H�μ���ϕμ�

v REORG TABLE ⁿOA�H¼ �μ��� ϕμ�xsΘ]��\∩H�μ���ϕμiμí¼ �

v ��u@q�zAizL�P�⌡μ�d�jTWiu@q��α�t���q

]��\w]d��μ�z�

v �AMμw²ú�Ao�s�w²ú��¼i�≤s� �μ��� ϕμ�d�⌡μ

p�ñ]��\qH�μ���ϕμw²ú�Ω��

v Σ� NOT ENFORCED Dn�Σ��@¡εAoi²zbwΩ��X¡ε�A

�Kú�n��α¿��í�D]��\��¡ε�AP�]Σ� �μ���

ϕμW� ENFORCED Dn�Σ��@¡ε

UCOP �μ��� ϕμSO�÷�ΣL[j\αG

© Copyright IBM Corp. 2013 3

Page 16: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

v d��b�XΣ�Aiε�j¼�íϕμ����O�Θ�qFbY�ípUAo

�d��⌡μt��Cb�XO@����NAibd�ñ��íϕμ�ΣL

�íϕμWR�B�@HWzⁿC��XμzⁿX�ß�Lo�GA��e�@

HWj¼�íϕμAHε�O�Θ�qC�� DB2 ��ΘXAHⁿXSw°Ω�

XBΓl��íϕμAO�N�M�b�X���N�j¼�íϕμ]��\

EXPLAIN_ARGUMENT ϕμ�C

v ∩úYΩ���≡�úY@�

v ��� CPU q�Ai�\h@�� SIMD ⁿO��

v VqBz�AiBz�μΩ��VqA�DO

v ∩�t�bU�í��α�π

v w���[j��ªñAijTε� I/O

v Ω�wxs ��\ p≤ DB2 10.1 �

v O�Θ���AHF��j�α

v @úⁿDnO�Θjp¡ε�t�FbBA�Bz�Ω�i�j≤ RAM

IBM DB2 pureScale S�[j\α

DB2 pureScale S�Ob 9.8 ��@�iC10.5 � OH DB2 pureScale S� �

��m≥ªC

DB2 pureScale S� ú�Ñj�eq���{ízq�A�¬≤�Yμ�����C

�≥∩}�≥i���¬i��ADB2 pureScale S� i�Maⁿp���@��≤

ó�CDB2 10.5 � ��ú�UCU�G

v ¬i��a° � (HADR) Σ�

v ≤¬�i��

v g∩}�u@q¡�

v DB2 pureScale S� P DB2 Enterprise Server Edition ºí���μ��

�A10.5 �]i DB2 pureScale S� �¬i��B�αBu@q�z�w�[j

\αC

p��÷ΩTA��\� 39��� 13 �, yDB2 pureScale S�[j\αzC

�αWi

�≥He���α∩}��m≥ªA10.5 � ��α∩}Dn�½bUC����Ω

TGH�μ���ϕμAH� CREATE INDEX »zí���]�H� ]tϕ�í¼

����

p��÷ΩTA��\� 21��� 6 �, y�α[j\αzC

SQL �e�

pGz��D DB2 ú��÷píΩ�wú�Ah 10.5 ����{s�\αB���

�e�S�iμ�mAHú�ΣLi²z≤[⌠x DB2 ú��[j\αCo�[j\

αε�Fiμu@����í�Σ�°�Ai²zw∩ΣL÷píΩ�wú���g

���{íα≈b DB2 ⌠�ñ�t⌡μC

p��÷ΩTA��\� 23��� 7 �, ySQL �e�[j\αzC

4 DB2 10.5 ��sW\α

Page 17: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

���ú�M�

ú�M�w�≤Aε����M≤A�zL≥� DB2 ��ñ�t�≤h\α�S��

ú�≤j��Ap x\αC

p��÷ΩTA��\� 7��� 2 �, yú�M�[j\αzC

� 1 � DB2 10.5 ��½I 5

Page 18: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

6 DB2 10.5 ��sW\α

Page 19: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

� 2 � ú�M�[j\α

H� IBM Data Server ��≥oiADB2 �≤�W��]�]�≥��≤AH �½

⌡�DC

IBM w≤sú�M�Aα≈zL��M≤ú��μ�A�zL≥� DB2 ��ñ�t

�≤h\α�S��ú�≤j��Ap x\αCs� DB2 Advanced Work-

group Server Edition D�AXípbí�Bu@�ñ�ñ¼W����⌠�ñCªiΣ

����Ω�w⌠�P DB2 pureScale ⌠�C

s� IBM DB2 Advanced Recovery S� ú�FΣLuπAiO@z��τB���

÷ΣΩ�Ap DB2 Recovery ExpertBDB2 Merge Backup P IBM InfoSphere® Optim™

High Performance UnloadCIBM DB2 Advanced Recovery S� O 10.5 � ñ�@i

Op��S�C���ú�� DB2 S�\α]ib DB2 Ω�wú���ñ��C

í� DB2 ��u�≤s�v�AYi≤s�ΣL��Czú�n½sw� DB2 Ω�

wú�Cz]iHsW DB2 Connect �v�AH≤sí� DB2 ����� DB2 Con-

nect \αC

YnA�o�ú���°�÷��v�μPΩTA��\ DB2 ú�⌠� (http://

www.ibm.com/software/data/db2/linux-unix-windows)C

© Copyright IBM Corp. 2013 7

Page 20: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

8 DB2 10.5 ��sW\α

Page 21: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

� 3 � i�z�[j\α

10.5 � ú�[j\αAi≤�Pa�z DB2 ⌠�B�p���¿�B�C⌡μt

��zu@�vTAH�����ñi��D\α�αOC

DB2 Ω�w�s �μ��� ϕμ∩�

� DB2 10.5 � ���AziH� H�μ��xs� �μ��� ϕμCDB2 10.5

� ú��s\αi��Bz�μΩ��VqA�DOCo�s\αwgLO�Θ�

��BCPU ��� I/O ��C

DB2 10.5 � ��iFA�≤ DB2 Ω�w�wsX �μ��� ϕμA�]A∩�

Ru@q�sxΣ�Co��¼�u@q����°d�Aoq�izLhϕμ�

XB��ME�B∩P¼⌡�ϕμy��δC

DB2 10.5 � ��b DB2 Ω�wú�ñis�Bz��d�Ω�μíAH[ti

μ�RBzCΣuI]AijTYu�Ω{�{�ú���ΘτAu�n�C� DBA

]p�DH���d��πMú�u@AYiF¿C�¿ípo��N�nBA]

Aα��Γ²���úY\αBjTú��Rd��αAH�α≈jT�C�α�

ºC

H�μ���ϕμ� C��� ϕμiP�sb≤�P�Ω�wB⌡Bϕμí�d

�ñCpG��Rd��� �μ��� ϕμA@δ�ÑAb��ΣL���ϕμ]Y

����]O �μ��� �ANiF����αC

sW NOT ENFORCED Dn��Σ��@¡εΣ�

DB2 10.5 � ��sWF NOT ENFORCED Dn�Σ��@¡ε�Σ�C

\αi²zboΩ�w�X�@¡ε�A�Kú�n��α¿�]Dnb≤ϕ

μW�íJB≤s�Rú@���í�D]PIμ�@¡ε�÷p�Cϕ�Ω�

s�Lkú�ΣLU�Ao���¡εi≤Ud���uπ∩��zQ�Ω�s

�p�C

© Copyright IBM Corp. 2013 9

Page 22: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

10 DB2 10.5 ��sW\α

Page 23: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

� 4 � �°[j\α

10.5 � ]A\h[j\αAi² DB2 Ω�w⌠���°≤���A�F�≤¬��

εδ�C

�μ��� ϕμ�s�°�q

DDú�s�°����º[Ai≤UzA���π∩ �μ��� ϕμ⌡μd��

�Ω�w°A�u@qC

DB2 �°���π�jí���n�ΩTA�H�°∩ �μ��� ϕμ⌡μd��

�u@qC DB2 10.5 � ��iFs��°���Aß≥X�N[Hí�C

�G�� TEMP � GBP ��Od�����C

��s��°����qw���v

s��°����i²zO�° �μ��� ϕμ� C��� ϕμ�Ω�� I/OC

ϕu@q∩ C��� � �μ��� ϕμy¿vT�AziH��o��°����

A��í�� I/O O� �μ��� ϕμ�s����Co���]�U≤z�πt

�ApAª�i≤UzMwOnN �μ��� ϕμ±mbO�ϕμíA�O

n��O�w��C��NA�μ��� Ω��]t �μ��� ϕμ��μΩ

�C

v �ΦMΩΘ �μ��� Ω��¬���H�Σ�������p��G

– POOL_COL_L_READS

– POOL_TEMP_COL_L_READS

– POOL_COL_P_READS

– POOL_TEMP_COL_P_READS

– POOL_COL_LBP_PAGES_FOUND

v ��� ��gJ��p��G

– POOL_COL_WRITES

v DPB �μ��� Ω��¬��MgJ�H�Σ������p��G

– POOL_ASYNC_COL_READS

– POOL_ASYNC_COL_READ_REQS

– POOL_ASYNC_COL_WRITES

– POOL_ASYNC_COL_LBP_PAGES_FOUND

v Cϕμ]H�Cϕμ�C»zíAzL�°���ípMμ°i�� �μ��

� Ω��¬���p��G

– OBJECT_COL_L_READS

– OBJECT_COL_P_READS

– OBJECT_COL_GBP_L_READS

– OBJECT_COL_GBP_P_READS

– OBJECT_COL_GBP_INVALID_PAGES

© Copyright IBM Corp. 2013 11

Page 24: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

– OBJECT_COL_LBP_PAGES_FOUND

– OBJECT_COL_GBP_INDEP_PAGES_FOUND_IN_LBP

��s��°���A�°∩ �μ��� ϕμñ�Ω�úX�w²ú�

nD

Ns� �μ��� ϕμ�d��ÑAΣw²ú��Φ����∩C@⌡μⁿN�U

bd�⌡μ�ís���μ�¬����AiμDPB�ú�CpGSw�μ��

�bw��ñ�≥i���Ah��μ�w²ú�\αN��A��nPB¬�o

����A��μ�w²ú�\α��A���C

÷M⌡μⁿiPBw²ú�����ⁿ¡≤�s�ºϕμí�w²ú�jpA²�

⌡μⁿ]iPBw²ú���C

���qw²ú���v�s�°���i≤Uzl�w∩ �μ��� ϕμñ�Ω�

úXnDB�Qúμ�w²ú���nDqAH�w²ú��]���wbO�Θñ

��¬�����C��w²ú� �μ��� ϕμñ�Ω�AOiμΩ�y�H�

C I/O ¿��½n]�C

v UC�°���i²z�°∩ �μ��� ϕμñ�Ω�úX�w²ú�nDG

– POOL_QUEUED_ASYNC_COL_REQS

– POOL_QUEUED_ASYNC_TEMP_COL_REQS

– POOL_QUEUED_ASYNC_COL_PAGES

– POOL_QUEUED_ASYNC_TEMP_COL_PAGES

– POOL_FAILED_ASYNC_COL_REQS

– POOL_FAILED_ASYNC_TEMP_COL_REQS

– SKIPPED_PREFETCH_COL_P_READS

– SKIPPED_PREFETCH_TEMP_COL_P_READS

– SKIPPED_PREFETCH_UOW_COL_P_READS

– SKIPPED_PREFETCH_UOW_TEMP_COL_P_READS

��s��°����q�μΩ�jp

�μ��� ϕμ�P�μΩ�xs�b�sϕμ½≤�÷pC

v UC�°���i≤Uz⌠p�μΩ��jpG

– COL_OBJECT_L_SIZE

– COL_OBJECT_P_SIZE

– COL_OBJECT_L_PAGES

eΓ��iδT�M �μ��� Ω�½≤��Φ�ΩΘjpA²Σ�⌠¿�¬]�

�pΓ����í�Co���� ADMIN_GET_TAB_INFO ϕμτ�°iC

COL_OBJECT_L_PAGES ��P{s� DATA_OBJECT_L_PAGES ���ⁿAú�¿

�C�jp⌠pNΦ�]�� * ��jp�A²bY�ípUΣ⌠piαú

TC

12 DB2 10.5 ��sW\α

Page 25: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

��ϕμ�s�°���

s��°���iw∩ϕμñ�Ω���°i�÷ΩTC

v UCO MON_GET_TABLE �� �s�qG

– TAB_ORGANIZATION

��s��°����q�í�Oq

�í�Oq�°��� iw∩ DB2 Ω�w�z{íBz �μ��� ϕμ��O��

íú��÷ΩTC�í�Oq��jPi���Ñ�í�Bz�íC

v UCOwsW��í�OqÑh�c��°���G

– TOTAL_COL_TIME

– TOTAL_COL_PROC_TIME

– TOTAL_COL_EXECUTIONS

oT TOTAL_* �q�pΓ�� �μ��� BzlNz{íí� �μ��� Ω�

Bz��O��í�pCTOTAL_COL_TIME Nϕ�� �μ��� BzlNz{í�

g�í�pCTOTAL_COL_PROC_TIME Nϕ �μ��� BzlNz{í�]�q

�Ñ�í]pGΩwÑB I O��óm� T O T A L _ C O L _ T I M E l�C

TOTAL_COL_EXECUTIONS Nϕ �μ��� ϕμñ�Ω�b»zí⌡μ�íQs�

����pC

TOTAL_COL_TIME ����q� TOTAL_SECTION_TIMECTOTAL_COL_PROC_TIME

����q� TOTAL_SECTION_PROC_TIMECnD�����qO�P

�C

���°��A�oE�≤úP���nD�q

v UC�°����°inD�qG

– MON_GET_DATABASE

– MON_GET_DATABASE_DETAILS

– MON_GET_WORKLOAD

– MON_GET_WORKLOAD_DETAILS

– MON_GET_UNIT_OF_WORK

– MON_GET_UNIT_OF_WORK_DETAILS

– MON_GET_SERVICE_SUBCLASS

– MON_GET_SERVICE_SUBCLASS_DETAILS

– MON_GET_CONNECTION

– MON_GET_CONNECTION_DETAILS

– EVMON_FORMAT_UE_TO_XML

– MON_FORMAT_XML_METRICS_BY_ROW

– u@μ��≤�°�

– �pΩ��≤�°�

v UCO��nD�q���� �s�qG

– POOL_COL_L_READS

– POOL_TEMP_COL_L_READS

� 4 � �°[j\α 13

Page 26: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

– POOL_COL_P_READS

– POOL_TEMP_COL_P_READS

– POOL_COL_LBP_PAGES_FOUND

– POOL_COL_WRITES

– POOL_COL_GBP_L_READS

– POOL_COL_GBP_P_READS

– POOL_COL_GBP_INVALID_PAGES

– POOL_COL_GBP_INDEP_PAGES_FOUND_IN_LBP

– POOL_QUEUED_ASYNC_COL_REQS

– POOL_QUEUED_ASYNC_TEMP_COL_REQS

– POOL_QUEUED_ASYNC_COL_PAGES

– POOL_QUEUED_ASYNC_TEMP_COL_PAGES

– POOL_FAILED_ASYNC_COL_REQS

– POOL_FAILED_ASYNC_TEMP_COL_REQS

– TOTAL_COL_TIME

– TOTAL_COL_PROC_TIME

– TOTAL_COL_EXECUTIONS

ezC@���Ω��¼� BIGINTFϕ REQUEST METRICS �ε�]� BASE

�AY�°io���C

�GY� MON_GET_DATABASE � MON_GET_DATABASE_DETAILS ��A

REQUEST METRICS u��ε TOTAL_COL_TIMEBTOTAL_COL_PROC_TIME �

TOTAL_COL_EXECUTIONS ���¼��eCϕ OBJECT METRICS �ε�]�

BASE �A�°iΣL��C

���°���oí��q

í��qOb SQL »zí⌡μ�í�q�nD�ql�C

v UC�°����°ií��qG

– MON_GET_ACTIVITY

– MON_GET_ACTIVITY_DETAILS

– MON_GET_PKG_CACHE_STMT

– MON_GET_PKG_CACHE_STMT_DETAILS

– EVMON_FORMAT_UE_TO_XML

– MON_FORMAT_XML_METRICS_BY_ROW

– í��≤�°�

– M≤���≤�°�

v UCO���q���� �s�qG

– POOL_COL_L_READS

– POOL_TEMP_COL_L_READS

– POOL_COL_P_READS

– POOL_TEMP_COL_P_READS

14 DB2 10.5 ��sW\α

Page 27: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

– POOL_COL_LBP_PAGES_FOUND

– POOL_COL_WRITES

– POOL_COL_GBP_L_READS

– POOL_COL_GBP_P_READS

– POOL_COL_GBP_INVALID_PAGES

– POOL_COL_GBP_INDEP_PAGES_FOUND_IN_LBP

– POOL_QUEUED_ASYNC_COL_REQS

– POOL_QUEUED_ASYNC_TEMP_COL_REQS

– POOL_QUEUED_ASYNC_COL_PAGES

– POOL_QUEUED_ASYNC_TEMP_COL_PAGES

– POOL_FAILED_ASYNC_COL_REQS

– POOL_FAILED_ASYNC_TEMP_COL_REQS

– TOTAL_COL_TIME

– TOTAL_COL_PROC_TIME

– TOTAL_COL_EXECUTIONS

ezC@���Ω��¼� BIGINTFϕ ACTIVITY METRICS �ε�]� BASE

�AY�°io���C

���°���oΩ�w½≤�q

½≤�q���°iSwΩ�w½≤�πΩ�w��°���C

v UCO

MON_GET_DATABASEBMON_GET_DATABASE_DETAILSBMON_GET_BUFFERPOOL

� MON_GET_TABLESPACE �� �s�qG

– POOL_COL_L_READS

– POOL_TEMP_COL_L_READS

– POOL_COL_P_READS

– POOL_TEMP_COL_P_READS

– POOL_COL_LBP_PAGES_FOUND

– POOL_COL_WRITES

– POOL_ASYNC_COL_READS

– POOL_ASYNC_COL_READ_REQS

– POOL_ASYNC_COL_WRITES

– POOL_ASYNC_COL_LBP_PAGES_FOUND

– POOL_COL_GBP_L_READS

– POOL_COL_GBP_P_READS

– POOL_COL_GBP_INVALID_PAGES

– POOL_COL_GBP_INDEP_PAGES_FOUND_IN_LBP

– POOL_ASYNC_COL_GBP_L_READS

– POOL_ASYNC_COL_GBP_P_READS

– POOL_ASYNC_COL_GBP_INVALID_PAGES

� 4 � �°[j\α 15

Page 28: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

– POOL_ASYNC_COL_GBP_INDEP_PAGES_FOUND_IN_LBP

– POOL_QUEUED_ASYNC_COL_REQS

– POOL_QUEUED_ASYNC_TEMP_COL_REQS

– POOL_QUEUED_ASYNC_COL_PAGES

– POOL_QUEUED_ASYNC_TEMP_COL_PAGES

– POOL_FAILED_ASYNC_COL_REQS

– POOL_FAILED_ASYNC_TEMP_COL_REQS

– SKIPPED_PREFETCH_COL_P_READS

– SKIPPED_PREFETCH_TEMP_COL_P_READS

– SKIPPED_PREFETCH_UOW_COL_P_READS

– SKIPPED_PREFETCH_UOW_TEMP_COL_P_READS

ezC@���Ω��¼� BIGINTFϕ OBJECT METRICS �ε�]� BASE

�AY�°io���C

v UCO MON_GET_TABLE �� �s�qG

– COL_OBJECT_L_PAGES

– NUM_COLUMNS_REFERENCED

– OBJECT_COL_L_READS

– OBJECT_COL_P_READS

– OBJECT_COL_GBP_L_READS

– OBJECT_COL_GBP_P_READS

– OBJECT_COL_GBP_INVALID_PAGES

– OBJECT_COL_LBP_PAGES_FOUND

– OBJECT_COL_GBP_INDEP_PAGES_FOUND_IN_LBP

– SECTION_EXEC_WITH_COL_REFERENCES

– TAB_ORGANIZATION

���°i�Hí�ϕμ��íp]pAíJ�εC�¬��εC���°�

��Cu�°i�Ω�w��ßQs��ϕμC

ezC@���Ω��¼� B I G I N TCT A B _ O R G A N I Z A T I O N �

COL_OBJECT_L_PAGES ��@��°iCϕ OBJECT METRICS �ε�]�

EXTENDED �A�°iΣL��C

v UCO MON_GET_TABLE_USAGE_LIST �� �s�qG

– OBJECT_COL_L_READS

– OBJECT_COL_P_READS

– OBJECT_COL_GBP_L_READS

– OBJECT_COL_GBP_P_READS

– OBJECT_COL_GBP_INVALID_PAGES

– OBJECT_COL_LBP_PAGES_FOUND

– OBJECT_COL_GBP_INDEP_PAGES_FOUND_IN_LBP

16 DB2 10.5 ��sW\α

Page 29: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

����C@b⌡μ�í��ϕμ�úP SQL »zí� @εCCu�b

w�ϕμ� ��ípMμßA��°iΩTC

ezC@���Ω��¼� BIGINTFϕ OBJECT METRICS �ε�]�

EXTENDED �AY�°io���C

v UCO ADMIN_GET_TAB_INFO �� �s�qG

– COL_OBJECT_L_SIZE

– COL_OBJECT_P_SIZE

����C@ϕμ� @εCA�°i�Hí�ϕμ�e��°���FΣ

ñ�°i��ϕμAú�ϕμOQs�C

v UC{s��q�úA�≤ �μ��� ϕμA]�� NULLG

– LARGE_RIDS

– LARGE_SLOTS

���z°���oRñv�q

�z°�O��≤�°���W�w²wq°�Ai∩�°Ω�⌡μ@δpΓC

v UCO MON_BP_UTILIZATION �� �s�qG

– COL_PHYSICAL_READS

– COL_HIT_RATIO_PERCENT

– GBP_COL_HIT_RATIO_PERCENT

°�iú����sw��ñúPΩ��¼�RñvC

v UCO MON_TBSP_UTILIZATION �� �s�qG

– COL_PHYSICAL_READS

– COL_HIT_RATIO_PERCENT

– GBP_COL_HIT_RATIO_PERCENT

°�iú�ϕμíh�WúPΩ��¼�RñvC

v UCO MON_WORKLOAD_SUMMARYBMON_SERVICE_SUBCLASS_SUMMARYB

MON_CONNECTION_SUMMARY � MON_DB_SUMMARY �� ��q]wgL

�∩ANs� COL xs �q�J�q�G

– TOTAL_BP_HIT_RATIO_PERCENT

– TOTAL_GBP_HIT_RATIO_PERCENT

o�°�iw∩�Nz{í�¿�E��úP�nI]u@qBA�l�OBsu

�Ω�w��u@Aú��qo�u@��°���KnC

���z{�ú�]t�°Ω��°i

UC�z{�wgL≤sA�J COL xs �°���C

v MONREPORT.DBSUMMARY

v MONREPORT.CONNECTION

� 4 � �°[j\α 17

Page 30: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

���°��A�obSwA��O⌡μ�Nz{í�÷ΩT

MON_GET_AGENT ���π�bSwA��O�⌡μ�Nz{í�÷ΩTCbgLU

C�≤ßA{bwN∩ �μ��� ϕμ⌡μ¡μd�Bz�Nz{í�J�qG

v AGENT_TYPEG∩≤Bz �μ��� ϕμ�Nz{íA�� SMPSUBAGENT �

¼C

v AGENT_SUBTYPEG�� s� COLUMNAR ��¼AH�OBz �μ��� ϕ

μ� SMP Nz{íC

v REQUEST_TYPEGπ� COLUMNAR ��¼�Nz{íAΣμ�Pπ� DSS �

SMP ��¼�Nz{í�PCπΘ�ÑApGl q XúOsAh� �NO

SUBSECTION:subsection_numberFh�� C

sμ�iWi HADR �°�α

MON_GET_HADR ϕμτ�AH�t -hadr ∩�� db2pd ⁿOñwsW�sμ�C

ziH��\hsμ���° HADR Ω�w��αG

v STANDBY_SPOOL_PERCENT i²zA���Fh� HADR Θx�s@�íC

v HADR_FLAGS ]t�μ�l�iⁿX�U����≤s≤≤�o�A�ⁿX��

Ω�wO�Θx ¼��Φ���DC

18 DB2 10.5 ��sW\α

Page 31: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

� 5 � ¬i��B�≈BOⁿB�����[j\α

10.5 � ]Ai≤UTOΩ��i��[j\αC

DB2 pureScale ⌠�ñ{bΣ� HADRDB2 pureScale ⌠�{bΣ� DB2 ¬i��a° � (HADR)Co�[j\α�XF

DB2 pureScale S���≥i��AH� HADR @��a° �\αC

YQnHμ@ú�P��X¬i���DPa° ��DAq�n��δ�CDB2

pureScale S�ú����i��B��O�i�π�CΣS�]t���ó���B�

� ��Ω�@�[cAbbú�U≤w�jí�Dw��B@ñ�y¿��

CúLAb@δípUAz�ú�N DB2 ¿��t�úP�az�mA]a°

�O@αO�¡C�∩aAHADR α≈ú�⌠V���¬i�����a° �\

αC

b��ñADB2 pureScale ⌠��úΣ� HADRA]pGzQnú�a° ��MΦ

�Ah��ípΣLú�Ap InfoSphere Q Replication � Change Data CaptureCú

LAHADR P DB2 pureScale S��πXAα≈ú�\huIG

v ≤zQ�PBCSUPERASYNC � ASYNC PB�íb DB2 pureScale ⌠�ñ

ⁿΣ�C

v DDL Σ�CHADR i�g DDL @�C

v e÷��CHADR �tm��@úe÷C

v �� �Σ�CziH�� TAKEOVER HADR ⁿOA⌡μX� �]ñΓ�½��jε �]ó� Γ�C

DB2 Advanced Copy Services (ACS) Script ���i²�ß Script ≤e÷��

� 10.5 � �AΩ@ Snapshot ��q Script iHzL DB2 ≤Aϕa�≈�����A

i�ε�������∩� Snapshot @���°��zC

Lhzb⌡μ Snapshot @��A����π����{íw�xswΘ�Σ� DB2

ACS APIA��g�ú�i⌡μ Snapshot �≈�����q ScriptC�g�q Script �

nBOi²z����xs�m≤πu�FúLA�� DB2 ñsbYz�IG

v �g�q Script Jx°]e÷X�ASOOb�� �Ω�w@�ÑΦ�C

v �q Script ú�ú�{���A]zLk�° Snapshot @��i��O¿

\C

b 10.5 � ñAzL�A��o�\αCDB2 ACS API {b]�≤ DB2 ACS {í

wñC{íwiIs��⌡μ Snapshot @���ß ScriptCDB2 Ω�w�z{í�

bAϕ�≈ �e÷X���@ApoX SET WRITE SUSPENDBSET WRITE RESUME �db2inidb ⁿOCP�A]��� DB2 ACS APIAC Snapshot @�b �{��

ñúN�@�A²ziH�°¿\�ó���≈C

© Copyright IBM Corp. 2013 19

Page 32: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

20 DB2 10.5 ��sW\α

Page 33: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

� 6 � �α[j\α

DB2 10.5 � ]t\h SQL �α[j\αAi�≥² DB2 Ω�°A�¿�π�ú�

u��Ω�°A��MΦ�AA�≤⌠≤W����C

�μ��� ϕμ�s��ΩT

s���ΩTi��AHΣ� �μ��� ϕμ\αCziH��o�ΩTAPwz

���{íb��o�s\α��⌡μΦíC

DB2 10.5 � ú�Fs� CTQ p�BΓlANϕ �μ��� Ω�BzP C���

Ω�Bzºí�α�C

� �μ��� ϕμº��ΩT�BJAPz∩ C��� ϕμ⌡μd������

BJ�PC

v ]wu{μ���ívSO�s������≈αApU��G

db2 SET CURRENT EXPLAIN MODE YES

v ∩ �μ��� ϕμoXz�d�C

v oX db2exfmt ⁿOAHμí��ϕμ��e��os�p�CpG

db2exfmt -d sample -1 -o output.exfmt

ϕ�í¼��iWid��α

� DB2 10.5 � �AziH�� CREATE INDEX »zí���A� ]tϕ�í¼

���C

��ϕ�í¼�Σ\αAi²z∩�xsbϕμñ�Ω�� �Cϕz��ϕ

�í¼�Σ� ��Aϕ�í��G�xsb�ñC

pG��wq]Aϕ�í¼�ΣAh�tzⁿ]Aϕ�í� SQL »zíiqñ≥

onBC��o�S�AΩ�w�z{íNiq\h¬�v��¼Φkñ∩A�

Hs�Ω���⌠zⁿC]A]tϕ�í�d�NoHú��αC

pGd�HΣLΦí��ϕ�íA�ñ�ϕ�í]���UCpAd�ibΣ

�Gñ� �ϕ�íA�O��ϕ�í���G�C

Yn���⌠b⌡μ��ⁿw�ϕ�í�≥onBA���ϕ�í¼�ΣA�ún

��Σ�Σ�]t@HWϕμ�μ�ΣL��¼C

���TÑhíΩw� DB2 pureScale S� �α[j\α

���TÑhíΩw (EHL)AϕμΩwNi�NεCΩw���ΩwCEHL iε� DB2

pureScale ⌠� ñ∩��≈α (CF) �⌠⌠Ω�yqC

EHL ib�íΩ�Ωw�z{íw�Ω�ºí� ΣWUN÷YCo �¼�ΩwA

ib DB2 Ω�w°A��úP�≤ºí���⌠≤Ω���K��sΩwC EHL i

© Copyright IBM Corp. 2013 21

Page 34: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

�Kjí�w∩Ω�ϕμB���ϕμ��������qTPΩ�@�O�Θ

�qCEHL iKú CF qTA�Wi�αC

EHL ∩UC�¼�u@qD�½nA]�ª�α≈R�B�o ��G

v ⌠μípFbo�ípñAC@��{íúu�μ@¿��t�ABΣΩ�s

�jhu�¡≤o�Sw���{íCbΩ�w⌠μ⌠�ñA@ DB2 pureScale O

���hΩ�wA²⌠≤μ@Ω�wú��μ@¿�s�C

v ���i���u@qFb�u@qñAu@�ⁿ��A��Swϕμ��μ

@¿�s�Cb�ís�u@qñA��Y¿����{íú�s�PΣL¿�

½��ϕμC

v @¿�tmA����μ@¿��σ��{u@qCt�g]w�iμ]íσ�

BzA�XGS� OLTP í�Cbo�t�ñAϕμ���σ�u@����í�μ

@su⌡μC

DB2 pureScale ⌠� �w]��� EHLCDB2 �����i≥q≤ EHL �u@qA

HWi�αCEHL ]izL�� opt_direct_wrkld Ω�wtm���}��÷¼C

IBM DB2 pureScale S� �μ�πO�Θ[j\α

DB2 pureScale ⌠� ñ��μ�πO�ΘS�{wgL[jA�C@¿�ú�Σ�¡

�W �π�C

²C@¿�ú�W ��π�Aπ�UCnBG

v �π≤α�Mu@q��ΦC

v C@ STMM �π�úαAϕ]�C@¿��i�O�Θ�≤C

�AW ��π�]iTOC@¿��O�ΘtmAϕ�πAH]�¿�Sw

�u@q�Ω�]iαH¿��úP�C

UPDATE STMM TUNING MEMBER xs{�{bi ⁿ -2CbsΩ�wñA�w]�bt

�ϕμñ]wCN]� -2 iTw��¿�w�� STMM �π�A�U�

W B@H�πC@¿��O�ΘtmC

22 DB2 10.5 ��sW\α

Page 35: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

� 7 � SQL �e�[j\α

pGz�� DB2 Ω�wú�H��÷píΩ�wú�Ah DB2 10.5 � ]t�[j

\αi²z≤[⌠x DB2 Ω�wú�Co�[j\αε�Fiμu@����í�Σ

�°�Ai²zw∩ΣL÷píΩ�wú���g�í���{íα≈b DB2 ⌠�ñ

⌡μC

j¼εCΣ�

� DB2 10.5 � �wXRεCjpΣ�A²z�� �ϕμbεC°�Wα≈WXϕ

μíº��jp�O²°�W¡C

ϕμΩ��εC���¿W���� ⌠Ai��� jpG4B8B16 � 32 KBC�

�bSwjpϕμí�� �ϕμAú��@�����jpCb��ñAϕμ

εCñe\�����W¡�M≤ϕμí���jpC��� �ϕμ@�bεC

°�WX��jp�O²°�W¡�AN�ú��� (SQLSTATE 54010)CpAb�

�ñLkb 4K ��jp�ϕμíñ� UCϕμA]�ΣεCjpLjC

CREATE TABLE T1 (C1 INTEGER, C2 VARCHAR(5000))

zLXRεCjpΣ�A²� ϕμ�]t�j¼εCWXϕμí��jp�O²

°�W¡�Aib 4K ��jp�ϕμíñ� T1 ϕμC

XR�εCjpΣ�i��⌡μUC�@G

v NεCjpWX 32K �ϕμ�α� DB2 10.5 �C

v ∩iNjí��Ω�εCe�≤p���WB²ϕμwq�nj��jp��

�{íWi�αC

v � π�h VARCHAR � VARGRAPHIC �μ�ϕμC�μ�W¡���≤A²

]�α≈WX��jp�O²°�W¡A�Hα�h�μC

i�≤{sϕμAHR�B�XR�εCjpΣ�C

q��ñ�ú NULL ��Σ

� DB2 10.5 � �Aib CREATE INDEX »zíW��s� EXCLUDE NULL KEYS

lyAHYε}¿��jpC

b�Σñ����μ� NULL �AH EXCLUDE NULL KEYS ly� ��

ú�Γ�ΣíJ�½≤ñCpGzúQ²d�s�P NULL �Σ�÷p�Ω�A

�ú NULL �ΣYi≥ozQ�xsΘ��α��CY��@�Abjε⌡μ

ϕμΩ���@��AN�ñ�Σ� NULL �εCC

© Copyright IBM Corp. 2013 23

Page 36: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

24 DB2 10.5 ��sW\α

Page 37: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

� 8 � u@q�z[j\α

10.5 � S��XR��ñú��u@q�z\αC

zL¿�l��qu@q¡�

b DB2 pureScale ⌠� ñAz{biHzLwq¿�l���qu@q¡��@�C

��¿�l�AziHN��{íu@qj≈�Sw�¿��Coiú¬u�A��

U≤¿�h��u@q�zC

��{íYs �P¿�l��÷p�Ω�wOWANib�l��U¿�ºí¡�

Σu@qCl�ñ]A�¿�iiμ�A�∩A�Y�vTQⁿú�l����{í

u@q⌡μ�b��mC

Ynb��{íh�W�zz�u@qAziHbΩ�wñwqh¿�l�C�

�A∩≤ DB2 pureScale O�ñC@Ω�w�M�¿�AziH�CΩ�wwq@

¿�l�C

��s�¿�l��z�íAi²z� B�≤��≤¿�l�½≤C�zo�¿�

l�wqAi²zsW��≤¿�l�ñ�¿�A���/�¿�l�CziH�∩

b°A�Mμñú����{í�¿�tⁿΩT≥�Cz]iHⁿw��{í��s

��Ω�wOWA�αQⁿú�¿�l�C

���Ω�w⌠�� DB2 pureScale ⌠� úΣ�¿�l�\αC

© Copyright IBM Corp. 2013 25

Page 38: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

26 DB2 10.5 ��sW\α

Page 39: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

� 9 � IBM Data Server Client �X�{í[j\α

í� IBM Data Server Client �X�{íAw��iWi��{í�α�ia���s

�Wi�\α�H[jC

Yn�� 10.5 � \αAz���� 10.5 � IBM Data Server Client �X�{íC

@δ�ÑAziH�� DB2 10.1 �B9.7 �� 9.5 ��ß��X�{íAb DB2 10.5

� W⌡μ��{íB}o��{íAH�⌡μΩ�w�z@�CPaAziH��

10.5 � �ß��X�{íAb DB2 10.1 �B9.8 �B9.7 �� 9.5 �°A�W⌡μ

��{íB}o��{íAH�⌡μ�z@�CM�Ai��\α���°A���

ß� (�X�{í) W������h��X���úPC

@δ�ß��X�{í[j\α

��]t 10.5 � �[j\αC

v z{biH�� DB2DSDRIVER_CFG_PATH n²��A� db2dsdriver.cfg ��ⁿwh

W�C⌠���W���z�n²��ⁿw�u²��iμBzCp���Ω

�A��\ db2dsdriver.cfg tm��m� ����C

Ish��� (CLI) X�{í[j\α

CLI X�{í]t\hA�≤ 10.5 � �Dn[j\αC

��\UC 10.5 � �Σ�M≤ñ�t��N�≤�sWS�CU���C@�

M≤úO�[���C

v 10.5 � [j\α

10.5 �GCLI X�{íb DB2 ¬i��S�Φ��[j\α

z{biH�� SQL_ATTR_OVERRIDE_PRIMARY_AFFINITY su��A���

t�S�ⁿws���Dn¿�AL��∩ db2dsdriver.cfg ��C��\Call Level

Interface Guide and Reference Volume 2C

10.5 �GCLI X�{íbIsxs{�Φ��[j\α

10.5 � CLI X�{íbIsxs{�Φ�π�UC[j\αG

v z{biHbsu�»zíh�Wⁿw

SQL_ATTR_STREAM_OUTPUTLOB_ON_CALL ��AHΩyBz�≤ LOB � XML

Ω��¼�xs{� OUT ��Ω�C��\Call Level Interface Guide and Refer-

ence Volume 2�Call Level Interface Guide and Reference Volume 2C

v z{biHbIsxs{��oXσ� CALL »zíAH��⌠⌠yqCYn��

σ� CALL »zíΣ�ACLI ��{í���� SQL_ATTR_PARAMSET_SIZE »

zí��ⁿw}CjpA�ú�}Cμí��Ω�C��\Developing User-

defined Routines (SQL and External)C

© Copyright IBM Corp. 2013 27

Page 40: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

10.5 �GCLI X�{íb DB2 for i °A�suΦ��[j\α

10.5 � ú�� CLI X�{í�JFUC DB2 for i °A�suM��[j\αG

v CLI X�{í{biH��UC]wA�½sπz *USRLIBL ���G

– ]w SQL_ATTR_CACHE_USRLIBL su��C

– ]w CacheUsrLibL db2cli.ini ÷ΣrC

– ]w CacheUsrLibL db2dsdriver.cfg ÷ΣrC

��\Call Level Interface Guide and Reference Volume 2 C

v z{biHbs � DB2 for i °A��Ab⌠��suh�WⁿwUCΘ�B�

íBp�μí��jr���G

– SQL_ATTR_DATE_FMT

– SQL_ATTR_DATE_SEP

– SQL_ATTR_TIME_FMT

– SQL_ATTR_TIME_SEP

– SQL_ATTR_DECIMAL_SEP

��\Call Level Interface Guide and Reference Volume 2�Call Level Interface Guide

and Reference Volume 1C

10.5 �GCLI X�{í�@δ[j\α

10.5 � ú�� CLI X�{í�JFUC[j\αC

v z{biHb db2dsdriver.cfg ��ñⁿwÑq@�s��C���XUC°≤A

�α��Ñq@�s��G

– CLI X�{í��Σ�s Ω�w°A�C CLI X�{íΣ� DB2 for Linux,

UNIX, and Windows °A�C

– Ñq@�s����ⁿwb db2dsdriver.cfg ��� <sessionglobalvariables> l

qñC

– b db2dsdriver.cfg ��� <sessionglobalvariables> l qñⁿ����s�

���²bΩ�w°A�� A�α≈��C

��\ Preparation Guide for DB2 10.1 DBA for Linux, UNIX, and Windows Exam

611 ñ�uIBM Data Server X�{ítm��cvDDC

v z{b�hi�UC db2dsdriver.cfg �ß�ΩT÷Σrⁿw 255 r�G

– ClientAccountingString

– ClientApplicationName

– ClientUserID

– ClientWorkstationName

��\ uIBM Data Server X�{ítm��ß�ΩT÷ΣrvC

v z{b�hi�UC db2cli.ini �ß�ΩT÷Σrⁿw 255 r�G

– ClientAcctStr

– ClientApplName

– ClientUserID

– ClientWrkStnName

28 DB2 10.5 ��sW\α

Page 41: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

��\ uIBM Data Server X�{ítm��ß�ΩT÷ΣrvC

v z{b�hi�UC⌠��su��ⁿw 255 r�G

– SQL_ATTR_INFO_ACCTSTR

– SQL_ATTR_INFO_APPLNAME

– SQL_ATTR_INFO_USERID

– SQL_ATTR_INFO_WRKSTNNAME

��\Call Level Interface Guide and Reference Volume 2�Call Level Interface Guide

and Reference Volume 1C

v z{biH�� db2cli ⁿOτ� db2dsdriver.cfg ��ñ���Ω�w� DSN �

C��\ Command ReferenceC

IBM Data Server Provider for .NET[j\α

DB2 10.5 � ñ�t� IBM Data Server Provider for .NET sWS�MμC

v 10.5 � [j\α

10.5 �GMicrosoft Entity Framework 5.0 S���

IBM Data Server Provider for .NET Σ�UC Microsoft Entity Framework 5.0 S�P

IBM Database Add-Ins for Visual Studio ú�ft��G

v C�Σ�

v @�¼�h��

v xs{��σ�J

p��÷ΩTA��\ Developing ADO.NET and OLE DB ApplicationsC

10.5 �GÑq@�s����Σ�

z{biHb IBM Data Server X�{ítm�ñⁿwÑq@�s��CUCO��

�Ñq@�s���ípG

v Ω�w°A���O DB2 for Linux, UNIX, and Windows °A�C

v z��b IBM Data Server X�{ítm�� <sessionglobalvariables> l qñⁿ

wÑq@�s��C

v bs �Ω�w°A�eAz��²� Ñq@�s��C

p��÷ΩTA��\ Preparation Guide for DB2 10.1 DBA for Linux, UNIX, and Win-

dows Exam 611C

10.5 �GΣ�°�� 255 �r���ß�ΩT÷Σr�e

IBM Data Server Provider for .NET �hiΣ� 255 r���ß�ΩT÷Σr��

eG

v z{biHb IBM Data Server X�{ítm�ñA�UC�ß�ΩT÷Σrⁿw�

h 255 r�G

– ClientAccountingString

– ClientApplicationName

– ClientUserID

� 9 � IBM Data Server Client �X�{í[j\α 29

Page 42: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

– ClientWorkstationName

p��÷ΩTA��\ uIBM Data Server X�{ítm��ß�ΩT÷ΣrvC

v z{b�hi�UC DB2ConnectionStringBuilder �ß�ΩT�eⁿw 255 r�G

– DB2ConnectionStringBuilder.ClientAccountingString

– DB2ConnectionStringBuilder.ClientApplicationName

– DB2ConnectionStringBuilder.ClientUserID

– DB2ConnectionStringBuilder.ClientWorkstationName

p��÷ΩTA��\ uDB2ConnectionStringBuilder �evC

v z{b�hi�UC DB2Connection �ß�ΩT�eⁿw 255 r�G

– DB2Connection.ClientAccountingInformation

– DB2Connection.ClientApplicationInformation

– DB2Connection.ClientUser

– DB2Connection.ClientWorkStation

p��÷ΩTA��\ uDB2Connection �evC

w[j JDBC � SQLJ Σ�

IBM Data Server Driver for JDBC and SQLJ ]t\hA�≤ 10.5 � �Dn[j\

αC

DB2 for Linux, UNIX, and Windows H�� IBM Data Server Driver for JDBC and

SQLJ ��π�UC[j\αC

DB2 10.5 � [j\α

3.66 �B4.16 ��≤s��π�UC IBM Data Server Driver for JDBC and SQLJ [

j\αC

�qHr��D����

DB2 for Linux, UNIX, and Windows {bΣ�brΩ�μ����wqñ���Tr

Ωμ���Cb U n i c o d e Ω�wñAπ�

CHARBVARCHARBCLOBBGRAPHICBVARGRAPHIC � DBCLOB Ω��¼��

μi��rΩμ��wqC

IBM Data Server Driver for JDBC and SQLJ ]ú�∩��Σ�Ai²zs�b��{

íñ��rΩμ�wq��μG

v sΦk D B 2 P a r a m e t e r M e t a D a t a . g e t M a x S t r i n g U n i t B i t s �

DB2ResultSetMetaData.getMaxStringUnitBits i∩μ@���P����r�Ω��¼

�rΩμ�ñ�j�q���C∩≤�� OCTETS wq�r��μAo�Φk�

� 8C∩≤�� CODEUNITS16 wq�r��μAo�Φk�� 16C∩≤

�� CODEUNITS32 wq�r��μAo�Φk�� 32C

v java.sql.DatabaseMetaData � java.sql.ParameterMetaData Φk�� ResultSet �μA

Σñ]trΩμ�����÷ΩTC{b�w∩�μ���Abo� ResultSet �μ

ñ�JrΩμ���C

30 DB2 10.5 ��sW\α

Page 43: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

s��Θxs��°�[j\α

itμ¼�UC÷≤ DB2 for Linux, UNIX, and Windows DB2 pureScale Ω �Σ

¿�A�÷≤ DB2 for z/OS® Ω�@�s��Σ¿��ΩTG

v πΩ�@�s��ΩTG

– �qs�Θxs � ßA�� �xs ½≤�W¡C

– �qs�Θxs � ßAF� maxTransportWaitTime ���C

– �qs�Θxs � ßA��s� IP �}���C

– � s�sußAΩ�@�s��¿�o�suO����C

v Ω�@�s�U¿��ΩTG

– �qs�Θxs � ßA�≤¿���Θ�W¡C

– �qs�Θxs � ßAtm�¿���Θ�W¡C

– �qs�Θxs � ßA¿�F� memberConnectTimeout ���C

– �qs�Θxs � ßA¿�o�¬�O����C

se�w�≤�e

HUO 10.5 � ñ���≤� Connection � DataSource �eG

maxRetriesForClientRerouteN DB2 for z/OS �su�ÑAϕ enableSysplexWLB ]� true �A

maxRetriesForClientReroute �w]{b� 1C�A��s��@�s��

Nq]���≤A]uA�v]w�úP�N[C¡�A��s N²��

�s �@Ω�@�¿�A�Os �s� IP �}C�� 10.5 �Aμ��

�s�Ω�@�s�Ahϕ���s ���¿�]ó�¿�ú��AH�s

� IP �}C

HUO 10.5 � ñsW�stm�eG

db2.jcc.sslConnectionⁿw IBM Data Server Driver for JDBC and SQLJ O�� SSL Socket s

�Ω���C�e�ú� Connection � DataSource �e�w]

sslConnectionC

db2.jcc.override.sslConnectionⁿw IBM Data Server Driver for JDBC and SQLJ O�� SSL Socket s

�Ω���C�e�m½ Connection � DataSource �e sslConnectionC

db2.jcc.sslTrustStoreLocationⁿw�ß�W]tiμ SSL su�°A���� Java H⌠xswW�C�

e�ú� Connection � DataSource �e�w] sslTrustStoreConnectionC

db2.jcc.override.sslTrustStoreLocationⁿw�ß�W]tiμ SSL su�°A���� Java H⌠xswW�C�

e�m½ Connection � DataSource �e sslTrustStoreConnectionC

db2.jcc.sslTrustStorePasswordⁿw�ß�W]tiμ SSL su�°A���� Java H⌠xswKXC�

e�ú� Connection � DataSource �e�w] sslTrustStorePasswordC

� 9 � IBM Data Server Client �X�{í[j\α 31

Page 44: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

db2.jcc.override.sslTrustStorePasswordⁿw�ß�W]tiμ SSL su�°A���� Java H⌠xswKXC�

e�m½ Connection � DataSource �e sslTrustStorePasswordC

DB2 for z/OS Ω�°A�su�[j\α

IBM Data Server Driver for JDBC and SQLJ 3.66 �� 4.16 �ú�UC÷≤ DB2 for

z/OS Ω�°A�su�[j\αCYn²o����X�{íP DB2 for z/OS � 10

��ftB@Ah��w� DB2 for z/OS PTFCpG�w� PTFAsu�ó�A�

X{ SQL �� -1224C�P DB2 for z/OS t��z�pAHTw PTF ww�C

���ß�½s�e[j\α

DB2 for z/OS su����ß�½seDK�BzwgL�∩Ai≤��a

B@CbDK����ß�½se�í½s� su�A�Θtm��ß�

�n��⌡μC

32 DB2 10.5 ��sW\α

Page 45: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

� 10 � DB2 σrjM[j\α

10.5 � ]AiXRuσrjMv\α�[j\αC

DB2 σrjMtm\α

uDB2 σrjMv{bπ�[j�tm\αH��M��[j\αCo�[j�t

m\αA�≤��¼�C

o�∩}]AUCU�G

v �C�∩jM�vTC

v ≤�πaΣ�hyѼ�A�U yÑú�≤���\αC

v zL∩�Oíσ≤BOs��úY���eiμ�XBs���ssA�o��

ú�Σ�C

v [j�tm\αA]A≤Yμ�τ�H�wqt�h�w]�αOC

DB2 σrjM�Twσ�Bz

uDB2 σrjMv{b�≤h∩�ii@B�ε≤sBzC

úFⁿw COMMIT @��σ�jpH�Az]iHMwb@≤sÑq@��í��

¿h�Tw�⌠Cz]iHⁿwTwjpOHεC��OgL��í]Hp��μ

����C

UCuDB2 σrjMvⁿOwgLjAiΣ�\αG

v CREATE INDEX FOR TEXT ⁿO

v ALTER INDEX FOR TEXT ⁿO

v UPDATE INDEX FOR TEXT ⁿO

UCuDB2 σrjMvxs{�]wgL∩}AiBz COMMIT σ�@�G

v SYSTS_CREATE {�

v SYSTS_ALTER {�

v SYSTS_UPDATE {�

� DB2 σrjM]wΓ�ⁿOΩw

ziHN�z@�v@M��Sw�σr�C��ε�≡Ab@����N���

�eⁿOΩwA�b@��⌠��H�úCúLA�zLuDB2 σrjMv�z�@�

]�iα�vTσr�CJ�o�íp�Az{biHΓ�]wⁿOΩwC

YnΓ�]wΩwA��� d b 2 t s S E T C O M M A N D L O C K S ⁿO�

SYSPROC.SYSTS_ADMIN_CMD() xs{�C

v ziHpU���� i1 oXⁿOG

db2ts set command locks for index i1 for text

v ��Az]iHpU��oXxs{�G

© Copyright IBM Corp. 2013 33

Page 46: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

db2 "call sysproc.systs_admin_cmd(’set command locks for index i1 for text’, ’en_US’, ?)"

DB2 σrjM��tm∩�

�ε≤sBzñsWFΓs��tm∩�GINITIALMODE � LOGTYPEC

�� INITIALMODE ∩�Aib�� � Y⌡μ�l≤sCziHNΣ�≡��@�≤s@��⌡μA����H⌡LCpApG�l�ObO�αBJñ� A

ziH�� INITIALMODE ∩�Cp�i@BⁿA��\σrjMW� qC

LOGTYPE ]w�MwΘxϕμ��zΦíC≥�∩�isW��δ��≤�o{íC�q∩�ú�sWo{íA�O�n≤h�q���OÑií≤s��≤Cp�

∩��¡εi@B�÷ⁿA��\σrjMW� qC

� ��Az��]wΣñ@∩�C

34 DB2 10.5 ��sW\α

Page 47: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

� 11 � w���[j\α

10.5 � ]Ai²ípú��t�≤�A�B≤÷≤∩ú�iμ�@�[j\αC

pGzww� 9.7 �B9.8 �� 10.1 ���A�BQn∩� DB2 10.5 �Ah�n�

� 10.5 �C10.5 � Os��CzLkM��M≤AHq����� 10.5 �C

YnA��¡εBiα�D�ΣL��Ω�A��\ m�� DB2 10.5 �nñ�

yDB2 °A���n�z�m�� DB2 10.5 �nñ�y�ß���n�zC

N DB2 °A�� DB2 �ß��� 10.5 � �Aiα�nDz@��Ω�w��

{í��íCYn≤UPO���A��\m�� DB2 10.5 �nñ�yΩ�

w��{í��n�z�m�� DB2 10.5 �nñ�y�í��n�zDDC

�� DB2 ��{íw� IBM Data Studio Web D�x ≤

IBM Data Studio Web D�x w��P DB2 Enterprise Server Edition w���{í

πXC

b��ñAz���OUⁿ�w� IBM Data Studio Web D�xCb DB2 10.5 � �

�ñAInstallation Manager �Uⁿ�w� IBM Data Studio Web D�x �≤C IBM

Data Studio �w�{�]��C

Guardium Installation Manager Client w�{íw�J DB2 °A�ú�ñ

Guardium® Installation Manager (GIM) Client iH∩�aw��tmb DB2 °A�

WCGIM Client �⌡μ≤ Guardium ¼��W��� GIM Server ���CGIM Cli-

ent iw�Btm�≤s Guardium S-TAP®]nΘ TAP��ΣL Guardium Nz{íC

Guardium S-TAP �ΣL Guardium Nz{íi�����°Ω�wí�C

b DB2 10.5 � ��ñADB2 w�{í�H²�íN GIM Client w�{í±mb

DB2 w�⌠�UC

DB2 w�{íú�b�t�Ww��tm GIM ClientCGIM Client ��zL GIM

Client w�{íHΓ�Φíb�t�Ww��tmC

DB2 pureScale ⌠� ñ���M≤w�w��

b DB2 10.5 � ñAziH�� DB2 installFixPack ⁿOP�≤s DB2 pureScale

Ω � DB2 Enterprise Server Edition Ω�¼C

installFixPack ⁿOiN DB2 pureScale Ω ≤s��s�M≤C� DB2 9.8 �

�Anb Linux � UNIX @�t�W���s�M≤≤s DB2 nΘA��⌡μh

BJ{�CΣ�]�AúF DB2 �M≤≤s��A�{���≤s Tivoli® Sys-

tem Automation � GPFS™ nΘh�≤s�C

b DB2 10.5 � ��ñAw[j DB2 installFixPack ��Aibμ@BJ{�ñP�

≤s DB2 pureScale Ω � DB2 Enterprise Server Edition Ω�¼C

© Copyright IBM Corp. 2013 35

Page 48: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

w�� DB2 pureScale S� w�� Root nJ]w

z{biHw��tm DB2 pureScale S�A�L����� root nJ�LKX SSHC

b��ñAw��tm DB2 pureScale S� �A������ root nJ� root �L

KX SSHC

b DB2 10.5 � ñAúA�n�� root nJ]wC

36 DB2 10.5 ��sW\α

Page 49: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

� 12 � �°����DP�[j\α

DB2 10.5 � ú��[j\αAi� DB2 ⌠�ñ��D�°��@�C

s�ⁿO��i[j�°���α

db2pd � db2support ⁿOñ[JFs�ⁿO��C

UϕCXs�ⁿO��C

ϕ 1. s�°��ⁿO���Kn. ϕμπ�s��°��ⁿO��C

�°��ⁿO s�

db2pd ��

��O db2pd -wlocks ⁿOs�l∩

�C����Aiw∩t�eÑ�

��{íΩwAπ� TableNmBSchemaNm

� AppNode �μC

-extentmovement

����Aiπ�zΩ�w�d≥��

¼AC

-membersubsetstatus

����Ai�X¿�l��¼AC

-subsetid

����i�Ol�C

db2support -alldbs | -alldatabases

����Aiⁿwn¼���bΩ�w

²ñΣ�ºΩ�w��÷ΩTC

-sg group_name | -system_group group_name

����Ai¼��÷≤ⁿwt�s�

�t��÷ΩTC

-su user_name | -system_user user_name

����Ai¼��÷≤ⁿwt���

��t��÷ΩTC

-wlm

����Ai¼���uπ�íñ¼

�h�� 0 �≤¬º WLM �D��÷Ω

TC

© Copyright IBM Corp. 2013 37

Page 50: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

38 DB2 10.5 ��sW\α

Page 51: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

� 13 � DB2 pureScale S�[j\α

IBM DB2 pureScale S� Oq 9.8 �}liCDB2 10.5 � �≥H DB2 pureScale

S� Σ���m≥ªC

DB2 10.5 � ú�F�� DB2 pureScale S� [j\αA]AzLuW���≤AH

� DB2 pureScale S� P DB2 Enterprise Server Edition ºí���@��ú¬i�

�C�A10.5 �]i DB2 pureScale S� �¬i��B�αBu@q�z�w�

[j\αC

�÷º�:

� 25��yzL¿�l��qu@q¡�z

� 19��yDB2 pureScale ⌠�ñ{bΣ� HADRz

� 35��yDB2 pureScale ⌠� ñ��M≤w�w�z

� 36��yw� DB2 pureScale S� w�� Root nJ]wz

� 21��y���TÑhíΩw� DB2 pureScale S� �α[j\αz

≤¬�i��

�� IBM DB2 pureScale S�ADB2 10.5 � ú¬FuW���≤�i��C

�� DB2 10.5 �A��[j\αiWii��G

v z{biHbuWsW DB2 ¿�AL�εB@C

v {bAb≈u¼AUsW DB2 ¿��AL� Y⌡μΩ�w�≈As�Ω�wY

i���C

v bsW@�ßAi� ���≈M�� Roll Forward �úP���A�ú�ni

μh�πΩ�w�≈

v �� IBM DB2 10.5 Enterprise Server Edition P DB2 pureScale Ω ºí��≈

M�C

bsW¿�� DB2 pureScale Ω �ADB2 10.5 � i²zK≤W�εB@�@�

íCP²e�PAs¿�izLμ@ⁿO db2iupdt sW� DB2 pureScale O�AL�

εΩCb�Q�¿ db2iupdt ⁿOßAs�Ω�wi Y�s¿���CzL�⌡μΩ�w��π≈u�≈AYiA���Ω�wC

��Ω�w�ϕμí�≈�@�±H�≤e÷CziH⌡μUC�@G

v NΩ�w�≈���π�úP��� DB2 pureScale ΩC

v Nb DB2 pureScale Ω Wiμ�uWΩ�w�≈M����π�W���� DB2

pureScale ΩC��Σ�]AzL¿�sW�≤�⌡μ� RollForward @�C

v Nb DB2 pureScale Ω Wiμ�ϕμí�≈M����π�W���� DB2

pureScale ΩC��Σ�]AzL¿�sW�≤�⌡μ�ϕμí RollForward @

�C

© Copyright IBM Corp. 2013 39

Page 52: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

DB2 pureScale S� P DB2 Enterprise Server Edition ºí���

DB2 10.5 � iF�≈M�ib DB2 Enterprise Server Edition ΩP DB2 pureScale

Ω ºí� �≡�μ��C

DB2 10.1 � iFN DB2 Enterprise Server Edition Ωα½� DB2 pureScale Ω

�\αCúLAo��⌡μ�w²α½@�CDB2 10.5 � �Fo�{�A²

Γ�{��ⁿΣ�C�� DB2 10.5 �Azu�⌡μ≈uΩ�w�≈AMßb DB2

Enterprise Server Edition W���≈YiC

�A10.5 � ]iFq DB2 pureScale ٠��� DB2 Enterprise Server Edition

�\αAi�zb DB2 ��⌠�ñ��Czu�⌡μ≈uΩ�w�≈AMßb ESE Ω

W���≈AA≤ ESE ΩW⌡μ≈uΩ�w�≈AHΣ�q���I ��αOC

�≤α≈b DB2 Enterprise Server Edition ΩP DB2 pureScale Ω ºíiμ�≈

���A�HziH⌡μUC�@G

v Nb DB2 Enterprise Server Edition Wiμ�≈uΩ�w�≈M���� DB2

pureScale ΩAú�nzLα�� RollForward Σ�C

v Nb DB2 pureScale Ω Wiμ�≈uΩ�w�≈M���� DB2 Enterprise

Server Edition ΩAú�nzLα�� RollForward Σ�C

½�[j\αi��ϕμ�@

DB2 10.5 � [JFi�ϕμ�@�[j\αC

DB2 10.5 � zLUCΦí[j½�\αG

v DB2 pureScale ⌠�ñ{bΣ�Na]uW�ϕμ½�C

v ���A�úY�ϕμ{bΣ�Na]uW�ϕμ½�C

v ∩íJ�íO� (ITC) ϕμ�¼ d≥A{b�N}¿tm� ⌠X���q��

⌠Co X��b�i��d≥ºe⌡μC

���μ�H≈��iw�����vº

DB2 10.5 � ��Σ�μsWF@H≈���¼C��μ�H≈���U≤w�

bSwíJípUg�s�����X{���vº¼pC

o�s\αSO�½≤b DB2 pureScale ⌠�ñg�s����C

pGεC����sW�ϕμñAh���ß@��N��Qs�C�ß@

��º�Hg�Qs�AO]�CsW����Σú�íJ��Cb�

�íWO���¡��μ��ΣU�Uh�A��iαX{¼pC

�Db DB2 pureScale ⌠�ñ�≤�cA]���²h¿�@�Cb DB2

pureScale ⌠�ñAú�����W�¼ΩvºA���¡]��bO���≈αí�

≡CO���≈α ��N����b≤s�íJ�úP¿�C¼p��Púα

μ�U�C

ϕzⁿw RANDOM ∩��A�xsb�≡¼�cñ�H≈�mWC]A��W

�s≥íJ���ε�C��vº��D]�oHw�CziH��H≈����

40 DB2 10.5 ��sW\α

Page 53: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

A∩ⁿw��μ⌡μ�Ñd\C�A]iHbú���yñ��H≈���

�Σ�μA�O²H≈�Σ�μ�¡≤�s�CY��HH≈��xsAz

�i�H≈�Σ�μ��lC

DB2 pureScale ⌠�ñ�uW��M≤≤s��iWii��

z{biHNuW�M≤≤s�M�� DB2 pureScale ⌠�AP�O� DB2 Ω

�i��CziH��uW�M≤≤s��M��M≤���Sϕ�mC

q DB2 10.5 �}lAϕzM�uW�M≤≤s��A@�uα≤s@íΩ�w°

A�A�ΣlΩ�w°A���≥Bzμ÷CΩ�w°A�b≤sºßAYi�≥i

μBzCo�M��M≤�s{�Ai²zbO��≥i���ípU≤s DB2

pureScale ΩC

b 10.5 � ºeAYnM��M≤A��²² DB2 Ω≈uC{��ⁿΣ�C

� 13 � DB2 pureScale S�[j\α 41

Page 54: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

42 DB2 10.5 ��sW\α

Page 55: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

� 2 g �≤\α

u�≤\αv]A 10.1 � ñ{s\α�≤��÷ΩTC

DB2 10.5 � for Linux, UNIX, and Windows ]tb�gs��{í��∩{s��

�{í�A��cO�w�≤\αBw≤��\α�wεú��\αC

A�o��≤�U≤}o�W�z�{μ��{íAH�� 10.5 �C

w�≤�\αq�]tw]��≤A�OP����úP��GCpAzb��

ñ��� SQL »zíAb 10.5 � ñiα�ú�úP��GC

O���{íbU��ºí��e�O½n��C²OAí�μ���iμ�≤A

�αQ�{μ��ñs��w�≤�\αC

UCU�í� 10.5 � ñiαvT{s��{í�w�≤\αBw≤��\α�wε

ú��\αC

� 45 ��� 14 �, y�z�≤Knz

��í�PΩ�w�z�÷�{s DB2 \α��≤C

� 49 ��� 15 �, yΩ�w]w�ú�w��≤Knz

��í�PΩ�w]w�ú�w��÷�{s DB2 \α��≤C

� 51 ��� 16 �, y��{í}o�≤Knz

��í�P��{í}o�÷�{s DB2 \α��≤C

� 55 ��� 17 �, yDB2 ⁿO� SQL »zí�≤Knz

��í�Σ�s\α� DB2 CLP ⁿOBDB2 t�ⁿO� SQL »zí�≤C

� 57 ��� 18 �, y10.5 � ñw≤��\αz

��CXYN≤��\αA�\αⁿ�O�Σ�²OúA�����Swτ

��\αA�Biα�b����ñ�H�úC

� 61 ��� 19 �, y10.5 � ñw�εú��\αz

��CX 10.5 �ñúΣ��S��\αC

� 67 ��� 20 �, y10.5 � �≤¡��ñw≤�Mw�εú�� DB2 \αKnz

��CX DB2 10.5 �ñw≤��úΣ��S��\αC

p� DB2 Ω�wú��S��≤��÷ΩTA��\uDB2 S�P DB2 ú����

\αvCDB2 for Linux, UNIX, and Windows ��]⌠}� http://www.ibm.com/software/

data/db2/linux-unix-windows/��ú��÷�v�μPΩTC

© Copyright IBM Corp. 2013 43

Page 56: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

44 DB2 10.5 ��sW\α

Page 57: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

� 14 � �z�≤Kn

10.5 � �]A�w�≤\α�vTz�z��� DB2 Ω�w�ΦíC

w�≤ HADR ��l]w

� 10.5 � �AHADR Ω�w��l]wBJw�≤C{bAY�zuOntmY�

��wA]���� hadr_target_list tm��C

���

10.1 � iF hadr_target_list �wtm��A�Htmh HADR ���

wC�����hiⁿwT��Ω�wCpG HADR ]wñu�@��Ω�wA

hú�n��C

� 10.5 � �Ab��� DB2 pureScale S�� DB2 ⌠�ñAz@���b�l]

w HADR Ω�wL{ñ]w hadr_target_list Ω�wtm��A]Au�@��Ω�w�⌠�b�C{bw≤��]w hadr_target_list Ω�wtm��� HADR �

l]wABb����ñiα�εú�Cb DB2 pureScale ⌠�ñAz��]w

hadr_target_list Ω�wtm���α�l]w HADRC

�MΦk

⌡μ�l]w HADR @�ñ���BJA]A]w hadr_target_list Ω�wtm��C

pGzO� s� HADR ]wA�⌡μ�l]w HADR @�ñ���BJA]A]

w hadr_target_list Ω�wtm��CpGw���Φk]w HADR]τYA

hadr_target_list ����A��\bºesb� HADR ]wW��h½���íC

HADR Θx�s@�{bw]���

HADR Θx�s@�{bw]���CtdⁿwΘx�s@�μ�� hadr_spool_limitΩ�wtm��{b�w]� AUTOMATICC

���

∩≤zb 10.5 � ñ� �⌠≤Ω�wAú���Θx�s@�CY�{s�Ω�wA

b�� 10.5 � �íNo��μ�A�M≤zO�� DB2 pureScale S�G

v Y� DB2 pureScale �wAhadr_spool_limit ���]� AUTOMATICC]�Lh

�úΣ� HADR P DB2 pureScale S��ft��A�Hoú�y¿⌠≤vTC

v ΣL�� DB2 Ω�w� hadr_spool_limit �����≤C

HADR Θx�s@�Ob 10.1 � ñiAªi²DnΩ�wW�μ÷�≥iμA�L

�Ñ��Ω�wW�Θx½C��π��s@�ijT�C HADR ∩DnΩ�w

�u@qiαy¿�vTA²∩��Ω�w�½�αh��t�vTC

© Copyright IBM Corp. 2013 45

Page 58: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

�MΦk

pGzúQ⌡μ HADR Θx�s@�A�N hadr_spool_limit Ω�wtm��]�0C��u@�≤��Ω�wWCz�n�°���½s����Ω�wA�α�M

s�CY�DnΩ�wA�ε HADRAMß�� HADR ��Ms]NΩ�wO

��uW�A]AΩ�w�¿���AN���sC

�TO HADR Θx�s@�α≈�B@A�TΩ���Ω�w�@�ñΘx⌠�ú

�¼≈���íC

w�≤í�Ω�w�z{ítm��

10.5 � ]t@�s��w�≤�Ω�w�z{ítm��C

���

s�Ω�w�z{ítm�

�≤s�S��\αA10.5 �]t@�s�tm��C

ϕ 2. s� 10.5 �Ω�w�z{ítm���Kn

�W� í� ��Ω�

cf_transport_method ⌠⌠�ΘΦktm�� b DB2 pureScale ⌠�ñAcf_transport_method

tm��i�ε��≤ Φkb DB2 ¿�PO�

��≈α (CF) ºíiμqTC

curr_eff_arch_level {μ��[ch�tm�� ���π�Ω⌡μ�b�{μ��[ch�

(CEAL)C

curr_eff_code_level Current®��{íXh�tm

��

���π�Ω⌡μ�b�{μ��{íXh

� (CECL)C

�MΦk

zL��s�\α���s�Ω�w�z{ítm���{sΩ�w�z{ítm�

��sA�Q�[j�\α�sS�C

w∩��P DB2 °A�μ��≤�sΩ�w�z{ítm���∩{sΩ�w�z{

ítm����≤A�πz�{s��{í� ScriptC

w�≤í�n²�⌠���

�Σ� DB2 10.5 � ñsW�w�≤�\αAn²�⌠���ú�FYz�≤C

���

n²���s�

Uϕπ�π� 10.5 � Ωºs�n²��G

46 DB2 10.5 ��sW\α

Page 59: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

ϕ 3. t�s�n²��

n²�� s�

DB2_WORKLOAD ∩≤ �μ��� ϕμAs� ANALYTICS i���μ

��B��Sϕ�lO�ΘtmB��Md≥jpt

mBí¼ H���u@q�zCbNΩ�w�≤�

Ru@q�A���]w]b� Ω�wºe��

��w]tmC

�≤�μ�

Uϕí�zb� ��� 10.5 � Ω�∩n²������≤C

ϕ 4. μ�w�≤�n²��

n²�� �≤�μ�

DB2DSDRIVER_CFG_PATH z{biH����Ab�P�úP��mWⁿwπ�úP

W��htm�CpG�b⌠��W�t∩ñⁿw�WA�

WN�w]� db2dsdriver.cfg CpG�ⁿw⌠�W�A

W�N�w]�@�t��²�cC

�MΦk

��s�n²��A��n²����sA HR�B�[j�\α�sS�C

w∩��P DB2 °A�μ��≤�sn²���∩n²����≤A�πz���{

í� ScriptC

�\w≤��wεú��n²��MμAHA�iαvTz���{í� Script �Σ

L�≤A�PzO��∩ª�iμ�πC

� 14 � �z�≤Kn 47

Page 60: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

48 DB2 10.5 ��sW\α

Page 61: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

� 15 � Ω�w]w�ú�w��≤Kn

10.5 � ]Aw�≤�\αAo\α�vTzw� DB2 Ω�wú��]w DB2 Ω

�w�ΦíC

�FQ�{μ��ñ�]t�sS�Aw≤sí��CnΘ�DCYnTOwT]

wz�t�A��\uDB2 Ω�wú��w��Dv�uΣ�Ω�w��{í}o⌠�

���vC

ziHN DB2 °A���ß���Aq 10.1 �B9.8 �� 9.7 ��� 10.5 �C

10.5 � O@s��A]zLkM��M≤AHq��iμ�C

YnA���Ω�B�{��¡εAH�z�n�N�iα�DA��\m��

DB2 10.5 �nñ�uDB2 °A���n�v�u�ß���n�vC

N DB2 °A���ß��� 10.5 � �Aiα�nDz@��Ω�w��{í�

�íC��\m�� DB2 10.5 �nñ�uΩ�w��{í��n�v�u�í�

�n�vAH≤UzMwO�⌠≤�vTC

Ω�wtm����≤

DB2 10.5 � ]t@�sW�w�≤�Ω�wtm��C

���

s�Ω�wtm�

�≤s�S��\αA10.5 � ]t@�s�Ω�wtm��C

ϕ 5. s� 10.5 � Ω�wtm��

�W� í� ��Ω�

extended_row_sz ��εCjp ���ⁿwϕμwqOiWX���

εC°�W¡C

dft_table_org w]ϕμ�� ���ⁿwb�≤ CREATE TABLE »

zíWⁿw ORGANIZE BY COLUMN �

ORGANIZE BY ROW ly�ípUA�

��ϕμ�� � �μ��� ϕμ]

C O L U M N��O C��� ϕμ]

ROW�C

nchar_mapping Ωar�∩M ���Mw Unicode Ω�wñ�Ωar

�rΩΩ��¼�Ω��¼∩MC

opt_direct_wrkld ���íu@q Ω�wtm��i�����TÑh

íΩw (EHL)C��M�π DB2

pureScale Ω�Ω�wC

page_age_trgt_gcr ��g�í�s�l�

tm��ⁿww�≤��bOs���

���≈αºenOdbs�w��ñ�

��í]Hϕ�μ��C���A�

≤ DB2 pureScale ΩC

© Copyright IBM Corp. 2013 49

Page 62: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

ϕ 5. s� 10.5 � Ω�wtm�� (�≥)

�W� í� ��Ω�

page_age_trgt_mcr ��g���l�

tm���ⁿww�≤��bOs�ϕ

μíxsΘ]YO DB2 pureScale Ω

Ah�ϕμíxsΘ�s�w���

ºenOdb��w��ñ���í

]Hϕ�μ��C

string_units w]rΩμ� ��ⁿwzbwqr�Ω��¼���

Ω��¼�����w]rΩμ�C

w�≤�Ω�wtm�

UCΩ�wtm��b 10.5 �ñπ�w�≤�μ�Bsd≥�sC

ϕ 6. π�w�≤�μ�Bsd≥�s�Ω�wtm��

�W� í� ��Ω�

db_mem_thresh Ω�wO�Θ{�tm

��

b 10.5 � ñAsΩ�w]�D

���w�� db_mem_thresh

w]wq 10 �≤� 100C

hadr_spool_limit HADR Θx�s¡εtm

��

b 10.5 � ñAhadr_spool_limit

�w]wq 0]w���≤�

AUTOMATICCp��÷ΩTA��

\ � 45��yHADR Θx�s

@�{bw]���zC

hadr_syncmode Ph¼Atm��ñΘ

xgJ� HADR PB

�í

b 10.5 � ñADB2 pureScale Ω

�w� hadr_syncmode w]w

q NEARSYNC �≤� ASYNCC��

ΣLΩ�w�¼� hadr_syncmode

w]h�� NEARSYNCC

hadr_target_list HADR �Mμtm�� 10.5 � ñw≤��l]w HADR

�ú]w���\αCú��

�Ω�w�q�≤Azú��b

�l]w{�ñ]w��Cp

��÷ΩTA��\� 45 ��

yw�≤ HADR ��l]wzC

sortheap ��Ω�∩jptm�� b 10.5 � ñA64 ��¡x�

sortheap w]wq 4 194 303

�≤� 4 294 967 295C

�MΦk

zL���s\��s��wtm���{s�wtm���sA�Q�

[j�\α�sS�C

w∩��P DB2 °A�μ��≤�sΩ�wtm���∩{sΩ�wtm����≤A

�πz�{s��{í� ScriptC

�\w≤��wεú��Ω�wtm��MμAHA�iαvTz���{í� Script

�ΣL�≤C

50 DB2 10.5 ��sW\α

Page 63: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

� 16 � ��{í}o�≤Kn

10.5 � ]Aw�≤�\αAo\α�vTz}o��{í�ΦíC

�A�\w≤��wεú��\αAHMwo\αO�vTz�{s��{

íC

wsW��≤í�t�¼²°�B �τ��s���B ��z�í�°�

�Σ� DB2 10.5 � ñ�sS�AwsW��∩Ω�w¼²½≤Apt�¼²°�B

��τ��s��B���z�í�°�C

���

t�¼²°��≤

10.5 � ñw�≤UCt�¼²°�Cjí��¼²°��∩�e]As��

μB�≤�í�B�≤��μΩ��¼�W[��μ°�C

v SYSCAT.ATTRIBUTES ¼²°�

v SYSCAT.CHECKS ¼²°�

v SYSCAT.COLUMNS ¼²°�

v SYSCAT.CONTROLS ¼²°�

v SYSCAT.DATATYPES ¼²°�

v SYSCAT.INDEXCOLUSE ¼²°�

v SYSCAT.INDEXES ¼²°�

v SYSCAT.PACKAGES ¼²°�

v SYSCAT.ROUTINEPARMS ¼²°�

v SYSCAT.ROUTINES ¼²°�

v SYSCAT.ROWFIELDS ¼²°�

v SYSCAT.SERVICECLASSES ¼²°�

v SYSCAT.STOGROUPS ¼²°�

v SYSCAT.TABDEP ¼²°�

v SYSCAT.TABLES π�W� TABLEORG �s�μA�HⁿXϕμ��C

v SYSCAT.TABLESPACES ¼²°�

v SYSCAT.TRIGGERS ¼²°�

v SYSCAT.VARIABLES ¼²°�

v SYSCAT.VIEWS ¼²°�

v SYSSTAT.COLUMNS ¼²°�

v SYSSTAT.INDEXES ¼²°�

v SYSSTAT.TABLES ¼²°�

10.5 � ñwsWUCt�¼²°�G

© Copyright IBM Corp. 2013 51

Page 64: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

v SQL Reference Volume 1 ñ�uSYSCAT.MEMBERSUBSETATTRS ¼²°

�v

v SQL Reference Volume 1 ñ�uSYSCAT.MEMBERSUBSETMEMBERS ¼

²°�v

v SQL Reference Volume 1 ñ�uSYSCAT.MEMBERSUBSETS ¼²°�v

�s����≤

wsWUC��s��G

v NLS_STRING_UNITS s��

��z°���í�≤

10.5 � ñw�≤UC�z°���íCjí��∩�e]As�μBsB�

≤��μΩ��¼�W[��μ°�G

v ADMINTABINFO �z°�� ADMIN_GET_TAB_INFO ϕμτ�

v ENV_SYS_INFO �z°�

v MON_BP_UTILIZATION �z°�

v MON_CONNECTION_SUMMARY �z°�

v MON_CURRENT_SQL �z°�

v MON_DB_SUMMARY �z°�

v MON_FORMAT_XML_COMPONENT_TIMES_BY_ROW ϕμτ�

v MON_FORMAT_XML_METRICS_BY_ROW ϕμτ�

v MON_FORMAT_XML_TIMES_BY_ROW ϕμτ�

v MON_GET_APPL_LOCKWAIT ϕμτ�

v MON_GET_BUFFERPOOL ϕμτ�

v MON_GET_CONNECTION ϕμτ�

v MON_GET_CONNECTION_DETAILS ϕμτ�

v MON_GET_TABLESPACE ϕμτ�

v MON_GET_SERVICE_SUBCLASS ϕμτ�

v MON_GET_SERVERLIST ϕμτ�

v MON_GET_TABLE ϕμτ�

v MON_GET_TABLESPACE ϕμτ�

v MON_GET_TABLE_USAGE_LIST ϕμτ�

v MON_TBSP_UTILIZATION �z°�

v MON_GET_UNIT_OF_WORK ϕμτ�

v MON_GET_UNIT_OF_WORK_DETAILS ϕμτ�

v MON_GET_WORKLOAD ϕμτ�

v MON_GET_WORKLOAD_DETAILS ϕμτ�

v MON_WORKLOAD_SUMMARY �z°�

wsWUC�°��í�°�G

v A d m i n i s t r a t i v e R o u t i n e s a n d V i e w s ñ�

uMON_CAPTURE_ACTIVITY_IN_PROGRESS {�v

v Administrative Routines and Views ñ�uMON_COLLECT_STATS {�v

52 DB2 10.5 ��sW\α

Page 65: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

v Administrative Routines and Views ñ�uMON_GET_ACTIVITY ϕμτ�v

v Administrative Routines and Views ñ�uMON_GET_AGENT ϕμτ�v

v Administrative Routines and Views ñ�uMON_GET_DATABASE ϕμτ�v

v Administrative Routines and Views ñ�uMON_GET_DATABASE_DETAILS

ϕμτ�v

v Administrative Routines and Views ñ�uMON_GET_INSTANCE ϕμτ�v

v Administrative Routines and Views ñ�uMON_GET_QUEUE_STATS ϕμ

τ�v

v A d m i n i s t r a t i v e R o u t i n e s a n d V i e w s ñ�

uMON_GET_SERVICE_SUBCLASS_STATS ϕμτ�v

v A d m i n i s t r a t i v e R o u t i n e s a n d V i e w s ñ�

uMON_GET_SERVICE_SUPERCLASS_STATS ϕμτ�v

v Administrative Routines and Views ñ�uMON_GET_UTILITY ϕμτ�v

v Administrative Routines and Views ñ�uMON_GET_WORKLOAD_STATS

ϕμτ�v

v A d m i n i s t r a t i v e R o u t i n e s a n d V i e w s ñ�

uMON_GET_WORK_ACTION_SET_STATS ϕμτ�v

v A d m i n i s t r a t i v e R o u t i n e s a n d V i e w s ñ�

uMON_TRANSACTION_LOG_UTILIZATION �z°�v

wsWUC⌠��íG

v A d m i n i s t r a t i v e R o u t i n e s a n d V i e w s ñ�

uENV_GET_DB2_EDU_SYSTEM_RESOURCES ϕμτ�v

v A d m i n i s t r a t i v e R o u t i n e s a n d V i e w s ñ�

uENV_GET_INSTANCE_CODE_LEVELS ϕμτ�v

wsWUCu@q�z�íG

v Administrative Routines and Views ñ�uWLM_ALTER_MEMBER_SUBSET

{�v

v Administrative Routines and Views ñ�uWLM_CREATE_MEMBER_SUBSET

{�v

v Administrative Routines and Views ñ�uWLM_DROP_MEMBER_SUBSET

{�v

�MΦk

��{st�¼²½≤]pAs�μ��μñw�∩�Ω��¼�ñ��≤A�π

z���{íC�A}l��iú�≤���°���í�st�¼²½≤A�s

�s\α��÷ΩTC

��\mAdministrative Routines and Viewsnñ�yw≤�� SQL �z�í�Σ�N

�í�°�z�MμAHPiαvT��{í� Script �ΣL�≤CYnN���í

�°���≤vT���CA��\mAdministrative Routines and Viewsnñ�yb�

�{íñIs���í�°����@kzC

p�Ω�wq��e°��MμA��\uΩ�wq��e°�vDDC

� 16 � ��{í}o�≤Kn 53

Page 66: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

54 DB2 10.5 ��sW\α

Page 67: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

� 17 � DB2 ⁿO� SQL »zí�≤Kn

DB2 10.5 � �≤F DB2 CLP ⁿOBDB2 t�ⁿO� SQL »zíAHΣ�s\αC

�Aí� DB2 CLP ⁿOBDB2 t�ⁿO� SQL »zíhw≤��wεú�Co

��≤iα�vT{s�Ω�w��{í�Ω�w�z ScriptC

DB2 ⁿO��≤

w�≤UC DB2 ⁿOG

ϕ 7. w�≤� DB2 ⁿO

DB2 ⁿOW� �≤���Ω�

db2cat db2cat ΘX{b�π�H≈���Σ�ΩTC�≤H≈����O��

�A]∩≤ⁿO�� �⌠≤ΘXAú�π� Extend Index InfoC

db2exfmt db2exfmt ΘX{b�π�H≈���Σ�ΩTCR �ⁿXπ� RAN-

DOM ����μCA �ⁿXπ� ASCENDING ����μCD �ⁿXπ

� DESCENDING ����μCdb2exfmt ⁿO]�w∩s� �μ��� ϕ

μ�d�ú�ΘXC

db2expln db2expln ΘX{b�π�H≈���Σ�ΩTCRandom �ⁿXπ� RAN-

DOM ����μCdb2expln ⁿO]�w∩s� �μ��� ϕμ�d�ú

�ΘXC

db2level ⁿO{b�π� IBM DB2 pureScale Ω�{μ���A�⌠�CYn

π�Y¿���PΩTA��� db2level ⁿOP -localMember ��Cb

��ñAdb2level ⁿO�w∩oXⁿO�¿�π�Σ{μ���A�⌠�C

db2look ⁿO{b�ú� DDL »zíAú��� C��� ϕμA]�� �

μ��� ϕμC

db2pd -apinfo ��{b�π�≤hPu@μ� (UOW) {μ�Lhí��÷�Ω

TC

-edus ��]�π�tdBz �μ��� Ω��Nz{íC

showlocks ��{b�π� TableNm � SchemaNm �μAHⁿX��{

í�O�ºΩw�ϕμW��⌡W�CYnπ�ΩTAz����

showlocks ��P -locks ��C

-tablespace ��{b�π� RSE �μAHⁿXOw��i¼ íS

�C

-transactions ��{b�π���{íTw�����{í Rollback �

�C

db2support -d ��{biΣ�qhΩ�w¼�ΩTCYnⁿwhΩ�wA�HrI

�j�wW�C

LOAD ∩≤ �μ��� ϕμA�w]�b LOAD REPLACE ⁿO⌡μ�íiμ��

�pΩ�¼�CYn�T����pΩ�¼�A�ⁿw STATISTICS NO �

�C�Ab∩ �μ��� ϕμ⌡μ LOAD REPLACE @��íA�w]N

��N�μúYwq�C

© Copyright IBM Corp. 2013 55

Page 68: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

SQL »zí��≤

w�≤UC SQL »zíG

ϕ 8. w�≤� SQL »zí

SQL »zí �≤���Ω�

CREATE TABLE

»zí

s� ORGANIZE BY COLUMN � ORGANIZE BY ROW lyAiⁿw

ϕμΩ�nH�μ�OεC���xsCpGoΓly�ⁿwAh�

�� dft_table_org Ω�wtm���ⁿw�w]ϕμ���xsΩ�Cú

Db� Ω�wºeN DB2_WORKLOAD n²��]� ANALYTICSAhw]

ϕμ���O ROWCp���Ω�A��\mDatabase Administration Con-

cepts and Configuration Referencenñ�y� �μ��� ϕμzC

CREATE INDEX

»zí

s� RANDOM lyi�� ��ⁿwH≈��C

w�εú� DB2 ⁿO� SQL »zí

wεú�UC DB2 ⁿO� SQL »zíG

ϕ 9. wεú� DB2 ⁿO� SQL »zí

DB2 ⁿO� SQL»zí �≤���Ω�

db2IdentifyType1 Lhú� db2IdentifyType1 ⁿOAH≤Uz²N�¼ 1 �α½��¼

2AMßA�� 9.7 �A]��¼ 1 �b 9.7 �ñwεú�Cb 10.5

� ñL�A��ⁿOA]�zuαq 9.7 ��≤s��iμ�Co�

��ñ�Ω�wúAπ��¼ 1 �C

LOAD ⁿO� STA-

TISTICS YES ��

wεú� LOAD ⁿO� STATISTICS YES ��CP���÷p�\αA

w�P STATISTICS USE PROFILE ���÷p�\α��NC

dynexpln wεú� dynexpln ⁿOC�∩� db2expln ⁿO��N dynexpln ⁿOC

db2expln ⁿOú�ÑP�\αA]�ªiH� Bz�A»zíC

56 DB2 10.5 ��sW\α

Page 69: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

� 18 � 10.5 � ñw≤��\α

ϕ����iα�ú{μ��Σ��Sw\α�S��A\αY��O�w≤�Cb

Y�ípUA��zW�ε��w≤��\αC

pAb���ñ��w]��n²���o�μ�A�Bb�����ñ�úw

@o�n²��A�H�b���ñ≤��n²��C

DB2 \α

b 10.5 � ñw≤�UC DB2 \αG

v �l]w HADR �L�]w hadr_target_list]��\� 45��yw�≤

HADR ��l]wz�

v db2DatabaseUpgrade � COBOL P FORTRAN Σ�]��\yw≤�

db2DatabaseUpgrade API � COBOL � FORTRAN yÑΣ�z�

v í� SQL �z�íw≤�]��\mAdministrative Routines and Viewsnñ

�y≤�� SQL �z�íP°�z�

n²���tm�

10.5 � ñw≤�UCn²���tm��G

v í�n²�⌠���]��\yw≤�í�n²�⌠���z�

v í�Ω�wtm��]��\� 58��yw≤��wεú�í�Ω�w

tm��z�

��\C@DDAHA�≤h���Ω�A�W����≤C]��\iα�vT

Ω�w�{s��{í�� 61��� 19 �, y10.5 � ñwεú��\αzC

w≤� db2DatabaseUpgrade API � COBOL � FORTRAN yÑΣ�

w≤� db2DatabaseUpgrade API � COBOL � FORTRAN yÑΣ�A�Biα�b

����ñ�H�úC

���

C � Java™ {í]pyÑ�Σ� db2DatabaseUpgrade APIC

�MΦk

bεú� API ºeA}l��Σ��{í]pyÑ�≥Is APIC��A��

�ioX UPGRADE DATABASE ⁿO� DB2 ⁿO ScriptC

w≤�í�n²�⌠���

b DB2 10.5 � ñAw≤�@�n²��C≤�����Mi�A²]�����ñ

iα��H�úA�Hú���C

UϕCXw≤��n²�⌠���Cª�w�ΣL\α�NA�ª�Σ��τ�w@

oC

© Copyright IBM Corp. 2013 57

Page 70: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

ϕ 10. 10.5 � ñw≤��n²�⌠���

n²�⌠��� ��Ω�

DB2_EVMON_EVENT_LIST_SIZE ]� 9.7 �∩≥ª�≤�°�≥ª[c�F�

≤A�H]wn²��ú��⌠≤@�C

DB2_NCHAR_SUPPORT n²��i�����wq��¼G

NCHARBNVARCHAR � NCLOBCúA�n

o�Ω��¼A]�{b��r�°�P�τ

��� �úOr��Cbn²��εú

�ºeA}l�� nchar_codeset Ω�wtm

��Abz� Unicode Ω�wñⁿwΩar�

rΩΩ��¼�Ω��¼∩MCp���Ω

�A��\ unchar_mapping - Ωar�∩Mt

m��vC

�MΦk

}l��P≤��n²���÷��NS��τ�C

úA��w≤��n²��A]�P�tm���÷p�\αw@o�w�s\α�

NC

w≤��w�εú�í�Ω�wtm��

]�\α��≤BsΩ�wtm���i�Σ���úA�Hw≤��wεú�

UC�wtm��C

���

w≤�UCΩ�wtm��G

ϕ 11. w≤��Ω�wtm��

�W� í� ��Ω�

buffpage w��jp ����ⁿXjp� - 1 � A L T E R

BUFFERPOOL � CREATE BUFFERPOOL »

zíAⁿXw]w��jpC

boΓ»zíñ�� SIZE ���ⁿX�T

A���� AUTOMATIC ���w���

�μ�πC

58 DB2 10.5 ��sW\α

Page 71: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

ϕ 11. w≤��Ω�wtm�� (�≥)

�W� í� ��Ω�

softmax �d≥�ní�dIí

j

���Mwní�dIP �d≥�WvA

�U≤⌡μl� �{�C

��� p a g e _ a g e _ t r g t _ m c r �

page_age_trgt_gcr Ω�wtm��A�ún�

� softmax ��C

v page_age_trgt_mcr ���ⁿww�≤��b

Os�ϕμíxsΘ]YO DB2 pureScale

ΩAh�s�w���ºenOdb��

w��ñ���íC

v page_age_trgt_gcr �ⁿww�≤��bOs

���ºenOdbs�w��ñ���

íC

wεú�UCΩ�wtm��G

ϕ 12. wεú��Ω�wtm��

�W� ���

auto_stats_prof wεú�tm��A]����pΩ�]w�]wεú�C

p��÷ΩTA��\� 64��ywεú����pΩ�]w

�zC

auto_prof_upd wεú�tm��A]����pΩ�]w�]wεú�C

p��÷ΩTA��\� 64��ywεú����pΩ�]w

�zC

�MΦk

úA��w≤��Ω�wtm��A]�P�tm���÷p�\αw@o�w�s

\α��NC�AúA��wεú��Ω�wtm��A]�ª�S�w���

GC

pGú�F�NΩ�wtm��A�]w���H�@w��Ω�wμ�C

� 18 � w≤��\α 59

Page 72: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

60 DB2 10.5 ��sW\α

Page 73: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

� 19 � 10.5 � ñw�εú��\α

wεú��\αb 10.5 � ñwD�úA�BúAi�CpGzbe��ñ���\

αAh�niμ�≤C

DB2 \α

10.5 � ñwεú�UC DB2 \αG

v A��O�Nz{íu²��]��\ywεú�A��O�Nz{íu

²��z�

v í��z�í]��\� 62��ywεú�í��z�íz�

v í�@�t��Σ�]��\� 63��yúAΣ�í�@�t�z�

v ���pΩ�]w�]��\� 64 ��ywεú����pΩ�]w

�z�

ⁿOBⁿO�Bn²���tm�

10.5 � ñwεú�UCⁿOBⁿO��Bn²���tm��G

v db2IdentifyType1 ⁿO]��\� 56��ywεú� DB2 ⁿO� SQL

»zíz�

v dynexpln ⁿO]��\� 56��ywεú� DB2 ⁿO� SQL »z

íz�

v LOAD ⁿO� STATISTICS YES ��]��\� 56��ywεú� DB2 ⁿ

O� SQL »zíz�

v í�n²�⌠���]��\� 64 ��ywεú�í�n²�⌠��

�z�

v í�Ω�wtm��]��\� 58��yw≤��wεú�í�Ω�w

tm��z�

w�εú�A�O�Nz{íu²��

wεú�NC@ DB2 A��OPNz{íu²��� ÷p�@�]i�εA�

�OñNz{í��÷@�t�u²���C

���

� 10.1 � �AziH��u@q�z{í (WLM) �ú�≤��a�ε CPU ��qA

�e\u²��¬�u@±u²��C�u@��≤h� CPU Ω�CWLM �ú

�iú�úFNz{íu²��H��ΣLS�C

b 9.5 �ñAiFNz{íu²��AH��u@⌡μ�bA��O�Nz{íu²

��A�u²��C�u@ⁿú��t� CPU Ω�A��u²��¬�u@ⁿ

úh�t� CPU Ω�C²OAΦkg���∩Sw�¼�u@q��C

Y� AIX® � Linux @�t�Az]iH�� DB2 A��OP AIX WLM � Linux

WLM �Oºí�πXA��εtm�CA��O�t�Ω�qC

© Copyright IBM Corp. 2013 61

Page 74: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

�MΦk

�� WLM �ú��NNz{íu²��AH�ε CPU ��qC

w�εú�í��z�í

b 10.5 � ñAwεú�@� SQL �z�íCz�����N�íC

���

Uϕπ�wεú�� SQL �z�íB≤��í����BΣ�N�í�°�AH�

�N°���í��i�����G

ϕ 13. 10.5 � ñwεú�� SQL �z�í�°��Σ�N�í�°�

w�εú���í�°�

≤�}lΘ

� s����

�N}lΘ

SNAPSHOT_AGENT ϕμτ� 9.1 � M O N _ G E T _ A G E N T ϕμτ��

MON_GET_CONNECTION ϕμτ�

10.5 � �

9.7 �

SNAPSHOT_APPL ϕμτ� 9.1 � MON_GET_CONNECTION ϕμτ��

MON_GET_UNIT_OF_WORK ϕμτ

9.7 �

SNAPSHOT_APPL_INFO ϕμτ� 9.1 � MON_GET_CONNECTION ϕμτ��

MON_GET_UNIT_OF_WORK ϕμτ

9.7 �

SNAPSHOT_BP ϕμτ� 9.1 � MON_GET_BUFFERPOOL ϕμτ� 9.7 �

SNAPSHOT_CONTAINER ϕμτ� 9.1 � MON_GET_CONTAINER ϕμτ� 9.7 �

SNAPSHOT_DATABASE ϕμτ� 9.1 � MON_GET_DATABASE ϕμτ��

MON_GET_TRANSACTION_LOG ϕμ

τ�

10.5 �

SNAPSHOT_DBM ϕμτ� 9.1 � MON_GET_INSTANCE ϕμτ� 10.5 �

SNAPSHOT_DYN_SQL ϕμτ� 9.1 � MON_GET_PKG_CACHE_STMT ϕμ

τ�

9.7 �

SNAPSHOT_FCM ϕμτ� 9.1 � MON_GET_FCM ϕμτ� 9.7 � Fix

Pack 2

SNAPSHOT_FCMNODE ϕμτ� 9.1 � MON_GET_FCM_CONNECTION_ LIST

ϕμτ�

9.7 � Fix

Pack 2

SNAPSHOT_FILEW {� 9.1 � SNAP_WRITE_FILE {� 9.1 �

SNAPSHOT_LOCK ϕμτ� 9.1 � MON_GET_APPL_LOCKWAIT ϕμτ

�BMON_GET_LOCKS ϕμτ�B

MON_FORMAT_LOCK_NAME ϕμτ

9.7 � Fix

Pack 1

SNAPSHOT_LOCKWAIT ϕμτ� 9.1 � MON_GET_APPL_LOCKWAIT ϕμτ

�BMON_GET_LOCKS ϕμτ��

MON_FORMAT_LOCK_NAME ϕμτ

9.7 � Fix

Pack 1

SNAPSHOT_QUIESCERS ϕμτ� 9.1 � SNAP_GET_TBSP_QUIESCER ϕμτ

9.1 �

SNAPSHOT_RANGES ϕμτ� 9.1 � SNAP_GET_TBSP_RANGE ϕμτ� 9.1 �

SNAPSHOT_STATEMENT ϕμτ� 9.1 � MON_GET_ACTIVITY ϕμτ��

MON_CURRENT_SQL �z°�

10.5 � �

9.7 � Fix

Pack 1

SNAPSHOT_SUBSECT ϕμτ� 9.1 � SNAP_GET_SUBSECTION ϕμτ� 9.1 �

62 DB2 10.5 ��sW\α

Page 75: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

ϕ 13. 10.5 � ñwεú�� SQL �z�í�°��Σ�N�í�°� (�≥)

w�εú���í�°�

≤�}lΘ

� s����

�N}lΘ

SNAPSHOT_SWITCHES ϕμτ� 9.1 � SNAP_GET_SWITCHES ϕμτ� 9.1 �

SNAPSHOT_TABLE ϕμτ� 9.1 � MON_GET_TABLE ϕμτ� 9.7 �

SNAPSHOT_TBREORG ϕμτ� 9.1 � MON_GET_UTILITY ϕμτ��

SNAP_GET_TAB_REORG ϕμτ�

10.5 � �

9.1 �

SNAPSHOT_TBS ϕμτ� 9.1 � MON_GET_TABLESPACE ϕμτ� 9.7 �

SNAPSHOT_TBS_CFG ϕμτ� 9.1 � MON_GET_TABLESPACE ϕμτ��

MON_GET_REBALANCE_STATUS ϕ

μτ�

9 . 7 ��

10.1 �

SNAPSHOT_UTIL ϕμτ� � 8 � MON_GET_UTILITY ϕμτ� 10.5 �

SNAPSHOT_UTIL_PROG ϕμτ� � 8 � SNAPUTIL_PROGRESS �z°��

SNAP_GET_UTIL_PROGRESS ϕμτ

9.1 �

SQLCACHE_SNAPSHOT ϕμτ� 9.1 � MON_GET_PKG_CACHE_STMT ϕμ

τ�

9.7 �

�MΦk

�∩��Pwεú��í������wq�½≤C�� � 62��ϕ 13 ñⁿX�

�N�í�°�A½�o�½≤CpGz�t���½≤�Ω�wAUPGRADE DATA-BASE ⁿO��≤wεú���z�íA�N��½≤�O�L�C

�∩�����{í� ScriptA��úo��í�����A���� � 62��ϕ 13

ñⁿX��N�í�°�C

úAΣ�í�@�t�

� DB2 10.5 � �Awεú�í�@�t��Σ�C

���

úAΣ�UC@�t�� Linux oμM≤G

v Red Hat Enterprise Linux 5.6

v Ubuntu 10.4 LTS

v Windows 2003

v Windows 2003 R2

v Windows 2008

v Windows XP

v Windows Vista

úAΣ�UC[cG

v POWER4 Bz�¼t�]DB2 °A��Ω��ß��

�����

b� DB2 Ω�wú�ºeA�²�\�Σ��@�t�MμA�W��z� DB2

°A�@�t�C

� 19 � εú��\α 63

Page 76: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

w�εú����pΩ�]w�

wεú����pΩ�]w�C

���

]����pΩ�]w���π��αB�tß�¡εA�Hwεú����pΩ

�]w�Cb���Ω�w⌠�BpXt������ �¡μ�Ω�wñAúΣ

��\αA�O�� qΩ�¼�C

P�]�εú�@� SYSINSTALLOBJECTS {�ºuπW���� ASP C

UCϕμP���pΩ��g{í\α�÷A]]Nεú�C

v SYSTOOLS.OPT_FEEDBACK_QUERY

v SYSTOOLS.OPT_FEEDBACK_PREDICATE

v SYSTOOLS.OPT_FEEDBACK_PREDICATE_COLUMN

v SYSTOOLS.OPT_FEEDBACK_RANKING

v SYSTOOLS.OPT_FEEDBACK_RANKING_COLUMN

b���ñAziH�����pΩ�]w�A�Mw RUNSTATS ⁿO�����C�BA���pΩ�]w����ϕμ�pΩ�OwL�C

RUNSTATS ⁿO��pΩ�]w�úⁿεú��vTA�M��ⁿ�Σ�C

�MΦk

ε�����pΩ�]w�\αC

ziH�� IBM Data Studio uπA≤UzMw RUNSTATS ⁿO�����AH���pΩ�]w��⌡μ RUNSTATS ⁿO��≥¼��pΩ�CUC\αi≤Uz�o�pΩ�¼����G

v �pΩ�U�Cp���Ω�A��\uú��BzUC@����G¼� SQL »

zí�s�⌠�ñΩ�w½≤��pΩ�vA⌠}� http://publib.boulder.ibm.com/

infocenter/dstudio/v3r2/topic/com.ibm.datatools.qrytune.sngqry.doc/topics/

genrecsstats.htmlC

v u@qU�CU��n IBM InfoSphere Optim Query Workload Tuner uπ�@�

ñ�vCp���Ω�A��\u� MQTB��h��O�H�≤Ω�w��

½steΩ�vA⌠}� http://publib.boulder.ibm.com/infocenter/dstudio/v3r2/topic/

com.ibm.datatools.qrytune.workloadtunedb2luw.doc/topics/genrecsdsgn.htmlC

v RUNSTATS ⁿO�@��UuπCp���Ω�A��\uiHq@��Uuπ⌡μ

�Ω�w�zⁿOvA⌠}� http://publib.boulder.ibm.com/infocenter/dstudio/v3r2/topic/

com.ibm.datatools.adm.doc/topics/c_taskassitantcommandsupport.htmlC

w�εú�í�n²�⌠���

b 10.5 � ñAwεú�@�n²��Cz��Nª�����í�úC

64 DB2 10.5 ��sW\α

Page 77: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

���

10.5 �ñwεú�UCn²�⌠���G

ϕ 14. 10.5 � ñwεú��n²��

n²�⌠��� ��Ω�

DB2_INDEX_FREE n²���ú��\αP CREATE INDEX »zíñ�

PCTFREE ly�PCΣtºb≤ADB2_INDEX_FREE A�≤z�

� ����A� PCTFREE lyhA�≤μ@�Cp��

�Ω�A��\ CREATE INDEX »zíCREATE INDEX »

zíC]wn²��N��P��A]�÷p�\αwLk

��C

DB2_TRUSTED_BINDIN {bwεú���A]�∩≤b�OíDj≈xs{��

]tD���d�»zí�ÑA��wúAú�Wi�α�

Σ�C

�MΦk

]�wεú��n²��S�w���GA�HúA��o���CpGϕ 14 ñw

ⁿX�Nn²��A�NΣ]�Aϕ�AH�@���Ω�w�z{íμ�C

w≤��w�εú�í�Ω�wtm��

]�\α��≤BsΩ�wtm���i�Σ���úA�Hw≤��wεú�

UC�wtm��C

���

w≤�UCΩ�wtm��G

ϕ 15. w≤��Ω�wtm��

�W� í� ��Ω�

buffpage w��jp ����ⁿXjp� - 1 � A L T E R

BUFFERPOOL � CREATE BUFFERPOOL »

zíAⁿXw]w��jpC

boΓ»zíñ�� SIZE ���ⁿX�T

A���� AUTOMATIC ���w���

�μ�πC

softmax �d≥�ní�dIí

j

���Mwní�dIP �d≥�WvA

�U≤⌡μl� �{�C

��� p a g e _ a g e _ t r g t _ m c r �

page_age_trgt_gcr Ω�wtm��A�ún�

� softmax ��C

v page_age_trgt_mcr ���ⁿww�≤��b

Os�ϕμíxsΘ]YO DB2 pureScale

ΩAh�s�w���ºenOdb��

w��ñ���íC

v page_age_trgt_gcr �ⁿww�≤��bOs

���ºenOdbs�w��ñ���

íC

� 19 � εú��\α 65

Page 78: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

wεú�UCΩ�wtm��G

ϕ 16. wεú��Ω�wtm��

�W� ���

auto_stats_prof wεú�tm��A]����pΩ�]w�]wεú�C

p��÷ΩTA��\� 64��ywεú����pΩ�]w

�zC

auto_prof_upd wεú�tm��A]����pΩ�]w�]wεú�C

p��÷ΩTA��\� 64��ywεú����pΩ�]w

�zC

�MΦk

úA��w≤��Ω�wtm��A]�P�tm���÷p�\αw@o�w�s

\α��NC�AúA��wεú��Ω�wtm��A]�ª�S�w���

GC

pGú�F�NΩ�wtm��A�]w���H�@w��Ω�wμ�C

66 DB2 10.5 ��sW\α

Page 79: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

� 20 � 10.5 � �≤¡��ñw≤�Mw�εú�� DB2 \αKn

]��÷\α��≤Bs\α�i�Σ���úA�Hw≤��wεú����

ñi��í� DB2for Linux, UNIX and Windows \αC

��\KnAHA�o��≤∩z⌠��πΘvTC

\αO�}l≤������Cú��ΩTO�n�GYn�oSw��w≤��\

α��πMμA]��\w∩��ú��ΩTG

v y9.5 ��≤¡��ñw≤��\αz

v � 73��y9.7 �ñw≤��\αz

v � 79��y10.1 �ñw≤��\αz

v � 82��y10.5 �ñw≤��\αz

�G

1. pG�i���RΩTANú�Σⁿ�C

2. ú]A�[{í\α (p Spatial Extender) �w≤�\α��÷ΩTC

3. pGw≤��n²��P�bΣLϕμñí��\α�÷A�OCXΣ�÷Ω

TC

Yn� DB2 Ω�wú����°wεú�\α��sMμA���UCΩTG

ϕ 17. � DB2 Ω�wú����wεú�\α

�� ���ΣLΩT

9.7 � v ��\uwεú��\αKnvA⌠}� http://publib.boulder.ibm.com/

infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.wn.doc/doc/c0023234.html

10.1 �

v ��\uwεú��\αKnvA⌠}� http://publib.boulder.ibm.com/

infocenter/db2luw/v10r1/topic/com.ibm.db2.luw.wn.doc/doc/c0023234.html

v ��\uwεú�í�n²�⌠���vA⌠}� h t t p : / /

publib.boulder.ibm.com/infocenter/db2luw/v10r1/topic/com.ibm.db2.luw.wn.doc/

doc/i0052379.html

10.5 �

v ��\uwεú��\αKnvA⌠}� http://publib.boulder.ibm.com/

infocenter/db2luw/v10r5/topic/com.ibm.db2.luw.wn.doc/doc/c0023234.html

v ��\uwεú�í�n²�⌠���vA⌠}� h t t p : / /

publib.boulder.ibm.com/infocenter/db2luw/v10r5/topic/com.ibm.db2.luw.wn.doc/

doc/i0052379.html

9.5 ��≤¡��ñw≤��\α

Uϕπ� 9.5 �ñw≤�B�iαb 10.1 � �≤s��ñwεú��\αCwb 9.7

�ñεú�� 9.5 �\α��π�A]� 9.7 ��≤s���Ω�wñwL\αC

© Copyright IBM Corp. 2013 67

Page 80: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

ϕ 18. b 9.5 ��≤¡��ñw≤�B�Bb 10.1 � �≤s��ñwεú��\α

wb����

ñ�εú� ���ΣLΩT

ALTER TABLE »zí� ADD

PARTITIONING KEY � DROP

PARTITIONING KEY ly

Mw ��\uw≤� ALTER TABLE »zí�

ADD PARTITIONING KEY lyvA⌠}�

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

v9 / top i c / com. ibm.db2 .udb . rn .doc /doc /

c0023217.htm

�uw≤� ALTER TABLE »zí� DROP

PARTITIONING KEY lyvA⌠}� http://

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

t o p i c / c o m . i b m . d b 2 . u d b . r n . d o c / d o c /

c0023216.htm

S Y S C A T . I N D E X E S ñ�

COLNAMES �μ

Mw ��\uw≤� SYSCAT.INDEXES ñ�

C O L N A M E S �μvA⌠}� h t t p : / /

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

t o p i c / c o m . i b m . d b 2 . u d b . r n . d o c / d o c /

c0023225.htm

���l�m�Ω�wOⁿ Mw ��\uw≤����l�m�Ω�wO

ⁿvA⌠}� http://publib.boulder.ibm.com/

i n f o c e n t e r / d b 2 l u w / v 9 / t o p i c /

com.ibm.db2.udb.rn.doc/doc/c0023086.htm

�í�í��wñ�w]τ�i

JI�

Mw ��\u�í�í{b�n�T�iJIW

μvA⌠}� http://publib.boulder.ibm.com/

i n f o c e n t e r / d b 2 l u w / v 9 / t o p i c /

com.ibm.db2.udb.rn.doc/doc/c0023021.htm

iCheckPending �� Mw ��\uw�N∩�mϕμ¼A�w≤�

iCheckPending ��vA⌠}� ht tp : / /

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

t o p i c / c o m . i b m . d b 2 . u d b . r n . d o c / d o c /

c0024079.htm

IMPORT ⁿO∩� CREATE �

REPLACE_CREATE

Mw ��\uw≤� IMPORT ⁿO∩� CRE-

ATE � REPLACE_CREATEvA⌠}� http://

publib.boulder.ibm.com/infocenter/db2luw/v9r5/

t o p i c / c o m . i b m . d b 2 . l u w . w n . d o c / d o c /

i0052280.html

logretain � userexit tm�

10.1 � ��\uw≤��wεú�í�tm�

�vA⌠}� http://publib.boulder.ibm.com/

i n f o c e n t e r / d b 2 l u w / v 1 0 r 1 / t o p i c /

com.ibm.db2.luw.wn.doc/doc/i0058741.html

db2flsn ⁿO� -file ∩� Mw ��\uw½sRW��sΘx�ε�

S Q L O G C T L . L F HvA⌠}� h t t p : / /

publib.boulder.ibm.com/infocenter/db2luw/v9r5/

t o p i c / c o m . i b m . d b 2 . l u w . w n . d o c / d o c /

i0051995.html

68 DB2 10.5 ��sW\α

Page 81: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

ϕ 18. b 9.5 ��≤¡��ñw≤�B�Bb 10.1 � �≤s��ñwεú��\α (�≥)

wb����

ñ�εú� ���ΣLΩT

LONG VARCHAR � LONG

VARGRAPHIC Ω��¼

Mw ��\uFP1Gw≤� LONG VARCHAR �

LONG VARGRAPHIC Ω��¼vA⌠}�

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

v9r5/topic/com.ibm.db2.luw.wn.doc/doc/

i0053661.html

⌠⌠ΩTA� (NIS � NIS+) Σ

���÷�n²�� (Linux �

UNIX @�t�)

Mw ��\uw≤�⌠⌠ΩTA�]N I S �

NIS+�Σ�]Linux � UNIX�vA⌠}�

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

v9 / top i c / com. ibm.db2 .udb . rn .doc /doc /

c0024980.htm

agentpri tm�� Mw ��\uw�≤í�Ω�w�z{ítm�

�vA⌠}� http://publib.boulder.ibm.com/

i n f o c e n t e r / d b 2 l u w / v 9 r 5 / t o p i c /

com.ibm.db2.luw.wn.doc/doc/i0052553.html

a p p _ c t l _ h e a p _ s zB

a p p g r o u p _ m e m _ s z �

groupheap_ratio tm��

Mw ��\uw�≤í�Ω�wtm��vA⌠

}� http://publib.boulder.ibm.com/infocenter/

db2luw/v9r5/topic/com.ibm.db2.luw.wn.doc/doc/

i0052508.html

buffpage Ω�wtm�� Mw ��\u� 8 �P���ú�e�vA⌠}

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

db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/

admin/r0008109.htm

indexsort Ω�wtm�� � 8 � ��\u� 8 �P���ú�e�vA⌠}

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

db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/

admin/r0008109.htm

maxagents � maxcagents tm

��

Mw ��\uw�≤í�Ω�w�z{ítm�

�vA⌠}� http://publib.boulder.ibm.com/

i n f o c e n t e r / d b 2 l u w / v 9 r 5 / t o p i c /

com.ibm.db2.luw.wn.doc/doc/i0052553.html

numsegs Ω�wtm�� Mw ��\uw�≤í�Ω�wtm��vA⌠

}� http://publib.boulder.ibm.com/infocenter/

db2luw/v9r5/topic/com.ibm.db2.luw.wn.doc/doc/

i0052508.html

query_heap_sz Ω�w�z{í

tm��

Mw ��\uw�≤í�Ω�w�z{ítm�

�vA⌠}� http://publib.boulder.ibm.com/

i n f o c e n t e r / d b 2 l u w / v 9 r 5 / t o p i c /

com.ibm.db2.luw.wn.doc/doc/i0052553.html

RAΩ�Ωy Snapshot ΘX Mw ��\uw≤�RAΩ�Ωy Snapshot Θ

XvA⌠}� http://publib.boulder.ibm.com/

i n f o c e n t e r / d b 2 l u w / v 9 r 5 / t o p i c /

com.ibm.db2.luw.wn.doc/doc/i0052585.html

� 20 � w≤��wεú��Kn 69

Page 82: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

ϕ 18. b 9.5 ��≤¡��ñw≤�B�Bb 10.1 � �≤s��ñwεú��\α (�≥)

wb����

ñ�εú� ���ΣLΩT

SNAP_GET_DB_V91B

SNAP_GET_DB_V95B

� SNAP_GET_DYN_SQL_V91

ϕμτ�

10.1 � ��\uwεú�í�H���r��

S Q L �z�ívA⌠}� h t t p : / /

publib.boulder.ibm.com/infocenter/db2luw/v10r1/

t o p i c / c o m . i b m . d b 2 . l u w . w n . d o c / d o c /

i0058675.html

ADMINTABCOMPRESSINFO �

SNAPTBSP_PART �z°�B

A D M I N _ G E T _ T A B _

C O M P R E S S _ I N F O �

WLM_GET_ACTIVITY_DETAILS

ϕμτ�

Mw w≤�� 9.5 � SQL �z�í�Σ�N�í

�°���\uw≤�� 9.5 � SQL �z�

í�Σ�N�í�°�vA⌠}� http://

publib.boulder.ibm.com/infocenter/db2luw/v9r5/

topic /com.ibm.db2. luw.sql . r tn .doc/doc/

r0023171.html

IBM DB2 Geodetic Data Man-

agement S�

10.1 � ��\uwεú� IBM DB2 Geodetic Data

M a n a g e m e n t S�vA⌠}� h t t p : / /

publib.boulder.ibm.com/infocenter/db2luw/v10r1/

t o p i c / c o m . i b m . d b 2 . l u w . w n . d o c / d o c /

i0059833.html

HP-UX 32 ���ß�Σ� Mw ��\uFP7Gw≤� HP-UX 32 ���ß�

Σ�vA⌠}� http://publib.boulder.ibm.com/

i n f o c e n t e r / d b 2 l u w / v 9 r 5 / t o p i c /

com.ibm.db2.luw.wn.doc/doc/i0058505.html

DB2 �αU� Mw ��\uFP8Gw≤� DB2 �αU�vA⌠

}� http://publib.boulder.ibm.com/infocenter/

db2luw/v9r5/topic/com.ibm.db2.luw.wn.doc/doc/

i0059075.html

Uϕπ� 9.5 �ñw≤�B�iαb 10.1 � �≤s��ñwεú��n²��Cw

b 9.7 �ñεú�� 9.5 �n²����π�A]� 9.7 ��≤s���Ω�wñ

wLo�n²��C

ϕ 19. wb 9.5 �ñ≤�B�Biαb 10.1 � �≤s��ñwεú��n²��

n²��

wb����

ñ�εú� ���ΣLΩT

DB2_ALLOCATION_SIZE Mw ��\uw≤�í�n²�⌠���vA⌠

}� http://publib.boulder.ibm.com/infocenter/

db2luw/v9r5/topic/com.ibm.db2.luw.wn.doc/doc/

i0052033.html

DB2ATLD_PORTS Mw ��\uw≤�í�n²�⌠���vA⌠

}� http://publib.boulder.ibm.com/infocenter/

db2luw/v9r5/topic/com.ibm.db2.luw.wn.doc/doc/

i0052033.html

DB2_ASYNC_IO_MAXFILOP 10.1 � ��\uwεú�í�n²�⌠��

�vA⌠}� http://publib.boulder.ibm.com/

i n f o c e n t e r / d b 2 l u w / v 1 0 r 1 / t o p i c /

com.ibm.db2.luw.wn.doc/doc/i0052379.html

70 DB2 10.5 ��sW\α

Page 83: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

ϕ 19. wb 9.5 �ñ≤�B�Biαb 10.1 � �≤s��ñwεú��n²�� (�≥)

n²��

wb����

ñ�εú� ���ΣLΩT

DB2_BAR_AUTONOMIC_DISABLE 10.1 � ��\uwεú�í�n²�⌠��

�vA⌠}� http://publib.boulder.ibm.com/

i n f o c e n t e r / d b 2 l u w / v 1 0 r 1 / t o p i c /

com.ibm.db2.luw.wn.doc/doc/i0052379.html

DB2BPVARS Mw ��\uw≤�í�n²�⌠���vA⌠

}� http://publib.boulder.ibm.com/infocenter/

db2luw/v9r5/topic/com.ibm.db2.luw.wn.doc/doc/

i0052033.html

DB2_COMMIT_ON_EXIT Mw ��\u9.1 �ñ�w≤�n²��ϕμvA

⌠}� http://publib.boulder.ibm.com/infocenter/

d b 2 l u w / v 9 / i n d e x . j s p ? t o p i c = /

com.ibm.db2.udb.admin.doc/doc/r0004670.htm

%23r0004670__depr-rv

DB2COUNTRY 10.1 � ��\uwεú�í�n²�⌠��

�vA⌠}� http://publib.boulder.ibm.com/

i n f o c e n t e r / d b 2 l u w / v 1 0 r 1 / t o p i c /

com.ibm.db2.luw.wn.doc/doc/i0052379.html

DB2_CORRELATED_PREDICATES Mw ��\u9.1 �ñ�w≤�n²��ϕμvA

⌠}� http://publib.boulder.ibm.com/infocenter/

d b 2 l u w / v 9 / i n d e x . j s p ? t o p i c = /

com.ibm.db2.udb.admin.doc/doc/r0004670.htm

%23r0004670__depr-rv

DB2DEFPREP 10.1 � ��\uwεú�í�n²�⌠��

�vA⌠}� http://publib.boulder.ibm.com/

i n f o c e n t e r / d b 2 l u w / v 1 0 r 1 / t o p i c /

com.ibm.db2.luw.wn.doc/doc/i0052379.html

DB2_DJ_COMM 10.1 � ��\uwεú�í�n²�⌠��

�vA⌠}� http://publib.boulder.ibm.com/

i n f o c e n t e r / d b 2 l u w / v 1 0 r 1 / t o p i c /

com.ibm.db2.luw.wn.doc/doc/i0052379.html

DB2DMNBCKCTLR 10.1 � ��\uwεú�í�n²�⌠��

�vA⌠}� http://publib.boulder.ibm.com/

i n f o c e n t e r / d b 2 l u w / v 1 0 r 1 / t o p i c /

com.ibm.db2.luw.wn.doc/doc/i0052379.html

DB2_ENABLE_BUFPD Mw ��\u9.1 �ñ�w≤�n²��ϕμvA

⌠}� http://publib.boulder.ibm.com/infocenter/

d b 2 l u w / v 9 / i n d e x . j s p ? t o p i c = /

com.ibm.db2.udb.admin.doc/doc/r0004670.htm

%23r0004670__depr-rv

DB2_ENABLE_SINGLE_NIS_GROUP Mw ��\u9.1 �ñ�w≤�n²��ϕμvA

⌠}� http://publib.boulder.ibm.com/infocenter/

d b 2 l u w / v 9 / i n d e x . j s p ? t o p i c = /

com.ibm.db2.udb.admin.doc/doc/r0004670.htm

%23r0004670__depr-rv

� 20 � w≤��wεú��Kn 71

Page 84: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

ϕ 19. wb 9.5 �ñ≤�B�Biαb 10.1 � �≤s��ñwεú��n²�� (�≥)

n²��

wb����

ñ�εú� ���ΣLΩT

DB2FFDC 10.1 � ��\uwεú�í�n²�⌠��

�vA⌠}� http://publib.boulder.ibm.com/

i n f o c e n t e r / d b 2 l u w / v 1 0 r 1 / t o p i c /

com.ibm.db2.luw.wn.doc/doc/i0052379.html

DB2_HASH_JOIN 10.1 � ��\uwεú�í�n²�⌠��

�vA⌠}� http://publib.boulder.ibm.com/

i n f o c e n t e r / d b 2 l u w / v 1 0 r 1 / t o p i c /

com.ibm.db2.luw.wn.doc/doc/i0052379.html

DB2_INDEX_FREE 10.5 � ��\uwεú�í�n²�⌠��

�vA⌠}� http://publib.boulder.ibm.com/

i n f o c e n t e r / d b 2 l u w / v 1 0 r 5 / t o p i c /

com.ibm.db2.luw.wn.doc/doc/i0052379.html

DB2_MAP_XML_AS_CLOB_FOR_DLC 10.1 � ��\uwεú�í�n²�⌠��

�vA⌠}� http://publib.boulder.ibm.com/

i n f o c e n t e r / d b 2 l u w / v 1 0 r 1 / t o p i c /

com.ibm.db2.luw.wn.doc/doc/i0052379.html

DB2_MAPPED_BASE Mw ��\u9.1 �ñ�w≤�n²��ϕμvA

⌠}� http://publib.boulder.ibm.com/infocenter/

d b 2 l u w / v 9 / i n d e x . j s p ? t o p i c = /

com.ibm.db2.udb.admin.doc/doc/r0004670.htm

%23r0004670__depr-rv

DB2MEMMAXFREE 10.1 � ��\uwεú�í�n²�⌠��

�vA⌠}� http://publib.boulder.ibm.com/

i n f o c e n t e r / d b 2 l u w / v 1 0 r 1 / t o p i c /

com.ibm.db2.luw.wn.doc/doc/i0052379.html

DB2_NO_MPFA_FOR_NEW_DB Mw ��\u9.1 �ñ�w≤�n²��ϕμvA

⌠}� http://publib.boulder.ibm.com/infocenter/

d b 2 l u w / v 9 / i n d e x . j s p ? t o p i c = /

com.ibm.db2.udb.admin.doc/doc/r0004670.htm

%23r0004670__depr-rv

DB2_PARTITIONEDLOAD_DEFAULT Mw ��\uw≤�í�n²�⌠���vA⌠

}� http://publib.boulder.ibm.com/infocenter/

db2luw/v9r5/topic/com.ibm.db2.luw.wn.doc/doc/

i0052033.html

DB2_PRED_FACTORIZE Mw ��\u9.1 �ñ�w≤�n²��ϕμvA

⌠}� http://publib.boulder.ibm.com/infocenter/

d b 2 l u w / v 9 / i n d e x . j s p ? t o p i c = /

com.ibm.db2.udb.admin.doc/doc/r0004670.htm

%23r0004670__depr-rv

D B 2 P R I O R I T I E S �

DB2NTPRICLASS

Mw ��\uw≤�í�n²�⌠���vA⌠

}� http://publib.boulder.ibm.com/infocenter/

db2luw/v9r5/topic/com.ibm.db2.luw.wn.doc/doc/

i0052033.html

72 DB2 10.5 ��sW\α

Page 85: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

ϕ 19. wb 9.5 �ñ≤�B�Biαb 10.1 � �≤s��ñwεú��n²�� (�≥)

n²��

wb����

ñ�εú� ���ΣLΩT

DB2ROUTINE_DEBUG 10.1 � ��\uwεú�í�n²�⌠��

�vA⌠}� http://publib.boulder.ibm.com/

i n f o c e n t e r / d b 2 l u w / v 1 0 r 1 / t o p i c /

com.ibm.db2.luw.wn.doc/doc/i0052379.html

DB2_RR_TO_RS 10.1 � ��\uwεú�í�n²�⌠��

�vA⌠}� http://publib.boulder.ibm.com/

i n f o c e n t e r / d b 2 l u w / v 1 0 r 1 / t o p i c /

com.ibm.db2.luw.wn.doc/doc/i0052379.html

DB2_SNAPSHOT_NOAUTH 10.1 � ��\uwεú�í�n²�⌠��

�vA⌠}� http://publib.boulder.ibm.com/

i n f o c e n t e r / d b 2 l u w / v 1 0 r 1 / t o p i c /

com.ibm.db2.luw.wn.doc/doc/i0052379.html

DB2_TRUSTED_BINDIN 10.5 � ��\uwεú�í�n²�⌠��

�vA⌠}� http://publib.boulder.ibm.com/

i n f o c e n t e r / d b 2 l u w / v 1 0 r 5 / t o p i c /

com.ibm.db2.luw.wn.doc/doc/i0052379.html

DB2_UPDATE_PART_KEY 10.1 � ��\uwεú�í�n²�⌠��

�vA⌠}� http://publib.boulder.ibm.com/

i n f o c e n t e r / d b 2 l u w / v 1 0 r 1 / t o p i c /

com.ibm.db2.luw.wn.doc/doc/i0052379.html

DB2_VENDOR_INI Mw ��\uwεú�í�n²�⌠��

�vA⌠}� http://publib.boulder.ibm.com/

i n f o c e n t e r / d b 2 l u w / v 1 0 r 1 / t o p i c /

com.ibm.db2.luw.wn.doc/doc/i0052379.html

DB2YIELD 10.1 � ��\uwεú�í�n²�⌠��

�vA⌠}� http://publib.boulder.ibm.com/

i n f o c e n t e r / d b 2 l u w / v 1 0 r 1 / t o p i c /

com.ibm.db2.luw.wn.doc/doc/i0052379.html

9.7 �ñw≤��\α

Uϕπ� 9.7 �ñw≤��\αCpG\αwεú�Aϕμñ]�π�εú��\

��C

ϕ 20. 9.7 �ñw≤��\α

wb����

ñ�εú� ���ΣLΩT

CREATE EVENT MONITOR

FOR DEADLOCKS »zí�

DB2DETAILDEADLOCK �≤�

°�

Mw ��\uw≤� CREATE EVENT MONI-

T O R F O R D E A D L O C K S »zí�

DB2DETAILDEADLOCK �≤�°�vA⌠

}� http://publib.boulder.ibm.com/infocenter/

db2luw/v9r7/topic/com.ibm.db2.luw.wn.doc/doc/

i0054715.html

� 20 � w≤��wεú��Kn 73

Page 86: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

ϕ 20. 9.7 �ñw≤��\α (�≥)

wb����

ñ�εú� ���ΣLΩT

CREATE EVENT MONITOR

FOR TRANSACTIONS »zí

Mw ��\uw≤� CREATE EVENT MONI-

TOR FOR TRANSACTIONS »zívA⌠}

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

db2luw/v9r7/topic/com.ibm.db2.luw.wn.doc/doc/

i0054716.html

DB2 Governor Mw ��\uw≤� DB2 Governor � Query

P a t r o l l e rvA⌠}� h t t p : / /

publib.boulder.ibm.com/infocenter/db2luw/v9r7/

t o p i c / c o m . i b m . d b 2 . l u w . w n . d o c / d o c /

i0054901.html

Query Patroller 10.1 � ��\uwεú� Query PatrollervA⌠}

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

db2luw/v10r1/topic/com.ibm.db2.luw.wn.doc/doc/

i0058730.html

IBM DB2 Geodetic Data Man-

agement S�

10.1 � ��\uwεú� IBM DB2 Geodetic Data

M a n a g e m e n t S�vA⌠}� h t t p : / /

publib.boulder.ibm.com/infocenter/db2luw/v10r1/

t o p i c / c o m . i b m . d b 2 . l u w . w n . d o c / d o c /

i0059833.html

db2imigr � db2ckmig ⁿO 10.1 � ��\uwεú� db2imigr � db2ckmig

ⁿOvA⌠}� http://publib.boulder.ibm.com/

i n f o c e n t e r / d b 2 l u w / v 1 0 r 1 / t o p i c /

com.ibm.db2.luw.wn.doc/doc/i0058593.html

MIGRATE DATABASE ⁿOF

sqlemgdb � sqlgmgdb API

Mw ��\uw≤�Ω�Ω�w�αⁿOM

APIvA⌠}� http://publib.boulder.ibm.com/

i n f o c e n t e r / d b 2 l u w / v 9 r 7 / t o p i c /

com.ibm.db2.luw.wn.doc/doc/i0053793.html

db2iupdt ⁿO� -s �� 10.1 � ��\uwεú� db2iupdt ⁿO� -s �

�vA⌠}� http://publib.boulder.ibm.com/

i n f o c e n t e r / d b 2 l u w / v 1 0 r 1 / t o p i c /

com.ibm.db2.luw.wn.doc/doc/i0058592.html

db2rfpen ⁿO� -file �� 10.1 � ��\uwεú� db2flsn � db2rfpen ⁿ

O� - f i l e ��vA⌠}� h t t p : / /

publib.boulder.ibm.com/infocenter/db2luw/v10r1/

t o p i c / c o m . i b m . d b 2 . l u w . w n . d o c / d o c /

i0058592.html

db2trcBdb2pdBdb2fodcB

db2pdcfg � db2support ⁿO�

-global ��

Mw ��\uFP4Gw≤��°��uπ� -global

��vA⌠}� http://publib.boulder.ibm.com/

i n f o c e n t e r / d b 2 l u w / v 9 r 7 / t o p i c /

com.ibm.db2.luw.wn.doc/doc/i0058858.html

REORG INDEXES ⁿO� CONVERT

��

9.7 � ��\uwεú��¼ 1 �vA⌠}�

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

v9r7/topic/com.ibm.db2.luw.wn.doc/doc/

i0054145.html

74 DB2 10.5 ��sW\α

Page 87: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

ϕ 20. 9.7 �ñw≤��\α (�≥)

wb����

ñ�εú� ���ΣLΩT

J�X��{í�u@ϕμ

í (WSF)

10.1 � ��\uwεú�J�X��{í�

u@ϕμí ( W S F )vA⌠}� h t t p : / /

publib.boulder.ibm.com/infocenter/db2luw/v10r1/

t o p i c / c o m . i b m . d b 2 . l u w . w n . d o c / d o c /

i0057410.html

LIST TABLESPACES � LIST

TABLESPACE CONTAINERS ⁿOM

�÷� APIG

v sqlbctsq

v sqlbftsq

v sqlbftpq

v sqlbgtss

v sqlbmtsq

v sqlbotsq

v sqlbstpq

v sqlbstsq

v sqlbtcq

Mw ��\uw≤� LIST TABLESPACES �

LIST TABLESPACE CONTAINERS ⁿOvA

⌠}� http://publib.boulder.ibm.com/infocenter/

db2luw/v9r7/topic/com.ibm.db2.luw.wn.doc/doc/

i0055001.html

MIGRATE_PRIOR_VERSIONS �

CONFIG_ONLY ��÷Σr

Mw ��\uw≤�í� ��÷ΣrvA⌠}

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

db2luw/v9r7/topic/com.ibm.db2.luw.wn.doc/doc/

i0054093.html

Sw DB2 API Ω��cñ�

D B 2 L O A D Q U E R Y _ T Y P E 1

_ I N D E X E S �

DB2REORG_CONVERT

9.7 � ��\uwεú��¼ 1 �vA⌠}�

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

v9r7/topic/com.ibm.db2.luw.wn.doc/doc/

i0054145.html

sqlugrpn API Mw ��\uw≤� sqlugrpn APIvA⌠}�

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

v9r7/topic/com.ibm.db2.luw.wn.doc/doc/

i0054733.html

sqlugtpi API Mw ��\uw≤� sqlugtpi APIvA⌠}�

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

v9r7/topic/com.ibm.db2.luw.wn.doc/doc/

i0053643.html

db2HistoryCloseScanB

db2HistoryGetEntryB

db2HistoryOpenScanA

� db2HistoryUpdate API

10.1 � ��\uwεú��zΩ�w{O²º

DB2 API � COBOLBFORTRAN � REXX

ñ�Σ�vA⌠}� h t t p : / /

publib.boulder.ibm.com/infocenter/db2luw/v10r1/

t o p i c / c o m . i b m . d b 2 . l u w . w n . d o c / d o c /

i0059298.html

�ΦΩ�s�ñ°i�

details_xml

Mw ��\uFP6Gw≤���pΩ��≤�°�

b details_xml ñ°i�qvA⌠}� http://

publib.boulder.ibm.com/infocenter/db2luw/v9r7/

t o p i c / c o m . i b m . d b 2 . l u w . w n . d o c / d o c /

i0060390.html

� 20 � w≤��wεú��Kn 75

Page 88: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

ϕ 20. 9.7 �ñw≤��\α (�≥)

wb����

ñ�εú� ���ΣLΩT

dyn_query_mgmt Ω�wtm�� 10.1 � ��\uw≤��wεú�í�tm�

�vA⌠}� http://publib.boulder.ibm.com/

i n f o c e n t e r / d b 2 l u w / v 1 0 r 1 / t o p i c /

com.ibm.db2.luw.wn.doc/doc/i0058741.html

DB2SE_USA_GEOCODER 10.1 � ��\uwεú�

DB2SE_USA_GEOCODERvA⌠}� http://

publib.boulder.ibm.com/infocenter/db2luw/v10r1/

t o p i c / c o m . i b m . d b 2 . l u w . w n . d o c / d o c /

i0059643.html

Net Search Extender \α�ⁿO

�l�

Mw ��\uw≤� Net Search Extender S��

ⁿO�l�vA⌠}� h t t p : / /

publib.boulder.ibm.com/infocenter/db2luw/v9r7/

t o p i c / c o m . i b m . d b 2 . l u w . w n . d o c / d o c /

i0054683.html

SQL �z�íl� Mw ��\uw≤�� 9.7 � SQL �z�í�Σ

�N�í�°�vA⌠}� h t t p : / /

publib.boulder.ibm.com/infocenter/db2luw/v9r7/

topic /com.ibm.db2. luw.sql . r tn .doc/doc/

r0023171.html

SNAP_GET_TBSP_PART_V91 ϕ

μτ�

10.1 � ��\uwεú�í�H���r��

S Q L �z�ívA⌠}� h t t p : / /

publib.boulder.ibm.com/infocenter/db2luw/v10r1/

t o p i c / c o m . i b m . d b 2 . l u w . w n . d o c / d o c /

i0058675.html

SNAP_GET_DBM_MEMORY_

P O O L ϕμτ��

SNAPDBM_MEMORY_POOL �

z°�

Mw ��\uFP5Gw≤�í��°�í�°

�vA⌠}� http://publib.boulder.ibm.com/

i n f o c e n t e r / d b 2 l u w / v 9 r 7 / t o p i c /

com.ibm.db2.luw.wn.doc/doc/i0059455.html

SNAP_GET_DB_MEMORY_

P O O L ϕμτ��

SNAPDB_MEMORY_POOL �z

°�

Mw ��\uFP5Gw≤�í��°�í�°

�vA⌠}� http://publib.boulder.ibm.com/

i n f o c e n t e r / d b 2 l u w / v 9 r 7 / t o p i c /

com.ibm.db2.luw.wn.doc/doc/i0059455.html

S N A P _ G E T _ A G E N T _

MEMORY_POOL ϕμτ��

SNAPAGENT_MEMORY_POOL

�z°�

Mw ��\uFP5Gw≤�í��°�í�°

�vA⌠}� http://publib.boulder.ibm.com/

i n f o c e n t e r / d b 2 l u w / v 9 r 7 / t o p i c /

com.ibm.db2.luw.wn.doc/doc/i0059455.html

76 DB2 10.5 ��sW\α

Page 89: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

ϕ 20. 9.7 �ñw≤��\α (�≥)

wb����

ñ�εú� ���ΣLΩT

UC DB2 �zuπG

v í��°�

v ⁿOsΦ�

v tm�U{í

v u�εñ�v��÷�δF

�U�

v u�εñ�v��{íXR

v �≤�R{í

v �α��ñ�

v ��μ÷�°�

v μ÷Θx

v �vñ�

v O�Θd {í

v Query Patroller ñ�

v �P�zñ�

v @�ñ�

10.1 � ��\uwεú� DB2 �zuπvA⌠}

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

db2luw/v10r1/topic/com.ibm.db2.luw.wn.doc/doc/

i0058731.html

DB2 �z°A� (DAS) Mw ��\uw≤��εñ�uπ� DB2 �z°

A� ( D A S )vA⌠}� h t t p : / /

publib.boulder.ibm.com/infocenter/db2luw/v9r7/

t o p i c / c o m . i b m . d b 2 . l u w . w n . d o c / d o c /

i0054250.html

DB2 �αU� Mw ��\uFP4Gw≤� DB2 �αU�vA⌠

}� http://publib.boulder.ibm.com/infocenter/

db2luw/v9r7/topic/com.ibm.db2.luw.wn.doc/doc/

i0059075.html

�α�°� Mw ��\uw≤��α�°�vA⌠}� http://

publib.boulder.ibm.com/infocenter/db2luw/v9r7/

t o p i c / c o m . i b m . d b 2 . l u w . w n . d o c / d o c /

i0055045.html

HP-UX 32 ���ß�Σ� Mw ��\uFP3Gw≤� HP-UX 32 ���ß�

Σ�vA⌠}� http://publib.boulder.ibm.com/

i n f o c e n t e r / d b 2 l u w / v 9 r 7 / t o p i c /

com.ibm.db2.luw.wn.doc/doc/i0058505.html

Java �í� IBM SDK 1.4.2 �

Σ�

Mw ��\uw≤� Java �í� IBM Software

Developer’s Kit (SDK) 1.4.2 Σ�vA⌠}�

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

v9r7/topic/com.ibm.db2.luw.wn.doc/doc/

i0055421.html

Visual Studio 2005 Σ� 10.1 � ��\uwεú� Visual Studio 2005 Σ

�vA⌠}� http://publib.boulder.ibm.com/

i n f o c e n t e r / d b 2 l u w / v 1 0 r 1 / t o p i c /

com.ibm.db2.luw.wn.doc/doc/i0060222.html

� 20 � w≤��wεú��Kn 77

Page 90: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

Uϕπ� 9.7 �ñw≤��n²��CpGn²��wεú�Aϕμñ]�π�ε

ú�o�n²�����C

ϕ 21. 9.7 �ñw≤��n²��

n²��

wb����

ñ�εú� ���ΣLΩT

DB2_CAPTURE_LOCKTIMEOUT Mw ��\uw≤�í�n²�⌠���vA⌠

}� http://publib.boulder.ibm.com/infocenter/

db2luw/v9r7/topic/com.ibm.db2.luw.wn.doc/doc/

i0052033.html

DB2_QP_BYPASS_APPLICATIONS 10.1 � ��\uwεú�í�n²�⌠��

�vA⌠}� http://publib.boulder.ibm.com/

i n f o c e n t e r / d b 2 l u w / v 1 0 r 1 / t o p i c /

com.ibm.db2.luw.wn.doc/doc/i0052379.html

DB2_QP_BYPASS_COST 10.1 � ��\uwεú�í�n²�⌠��

�vA⌠}� http://publib.boulder.ibm.com/

i n f o c e n t e r / d b 2 l u w / v 1 0 r 1 / t o p i c /

com.ibm.db2.luw.wn.doc/doc/i0052379.html

DB2_QP_BYPASS_USERS 10.1 � ��\uwεú�í�n²�⌠��

�vA⌠}� http://publib.boulder.ibm.com/

i n f o c e n t e r / d b 2 l u w / v 1 0 r 1 / t o p i c /

com.ibm.db2.luw.wn.doc/doc/i0052379.html

DB2_SERVER_ENCALG Mw ��\uw≤�í�n²�⌠���vA⌠

}� http://publib.boulder.ibm.com/infocenter/

db2luw/v9r7/topic/com.ibm.db2.luw.wn.doc/doc/

i0052033.html

DB2_USE_DB2JCCT2_JROUTINE 10.1 � ��\uw≤�í�n²�⌠���vA⌠

}� http://publib.boulder.ibm.com/infocenter/

db2luw/v9r7/topic/com.ibm.db2.luw.wn.doc/doc/

i0052033.html

78 DB2 10.5 ��sW\α

Page 91: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

ϕ 21. 9.7 �ñw≤��n²�� (�≥)

n²��

wb����

ñ�εú� ���ΣLΩT

Query Patroller n²��G

v DQP_ABORTRESULT

v DQP_CHILD_WAIT

v DQP_DISKMON

v DQP_EXIT_AN

v DQP_INTERVAL

v DQP_LAST_RESULT_DEST

v DQP_LOCAL_SERVANTS

v DQP_LOG

v DQP_LOGMON

v DQP_MAIL

v DQP_MAIL_ACCOUNT

v DQP_MAPI_PASSWORD

v DQP_MAPI_PROFILE

v DQP_NET

v DQP_NOCPU

v DQP_NOEXPLAIN

v DQP_NTIER

v DQP_PURGEHOURS

v DQP_RECOVERY_INTERVAL

v DQP_RES_TBLSPC

v DQP_RUNTIME

v DQP_SERVER

v DQP_SHARE

v DQP_SIBLING_WAIT

v DQP_STARTUP

v DQP_TRACEFILE

10.1 � ��\uwεú� Query PatrollervA⌠}

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

db2luw/v10r1/topic/com.ibm.db2.luw.wn.doc/doc/

i0058730.html

10.1 �ñw≤��\α

Uϕπ� 10.1 � ñw≤��\αCpG\αwεú�Aϕμñ]�π�εú��

\��C

ϕ 22. 10.1 �ñw≤��\α

wb����

ñ�εú� ���ΣLΩT

í��°��í Mw ��\uw≤�í��°��ívA⌠}�

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

v10r1/topic/com.ibm.db2.luw.wn.doc/doc/

i0059660.html

� 20 � w≤��wεú��Kn 79

Page 92: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

ϕ 22. 10.1 �ñw≤��\α (�≥)

wb����

ñ�εú� ���ΣLΩT

A��O�Nz{íu²�� 10.5 � ��\uw≤�A��O�Nz{íu²�

�vA⌠}� http://publib.boulder.ibm.com/

i n f o c e n t e r / d b 2 l u w / v 1 0 r 1 / t o p i c /

com.ibm.db2.luw.wn.doc/doc/i0059645.html

���pΩ�]w� 10.5 � ��\uw≤����pΩ�]w�vA⌠

}� http://publib.boulder.ibm.com/infocenter/

db2luw/v10r1/topic/com.ibm.db2.luw.wn.doc/doc/

i0060240.html

�� Unicode Standard 4.0.0 �

�∩�

Mw ��\uw≤��� Unicode Standard 4.0.0

��∩�vA⌠}� h t t p : / /

publib.boulder.ibm.com/infocenter/db2luw/v10r1/

t o p i c / c o m . i b m . d b 2 . l u w . w n . d o c / d o c /

i0058749.html

INSTALL_TSAMP ��÷Σr Mw ��\u{b���w� IBM Tivoli System

Automation for Multiplatforms (SA MP)vA⌠

}� http://publib.boulder.ibm.com/infocenter/

db2luw/v10r1/topic/com.ibm.db2.luw.wn.doc/doc/

i0059123.html

Net Search Extender Mw ��\uw≤� Net Search ExtendervA⌠}

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

db2luw/v10r1/topic/com.ibm.db2.luw.wn.doc/doc/

i0058722.html

DMS �[ϕμí Mw ��\uFP1Gw≤� DMS �[ϕμ

ívA⌠}� http://publib.boulder.ibm.com/

i n f o c e n t e r / d b 2 l u w / v 1 0 r 1 / t o p i c /

com.ibm.db2.luw.wn.doc/doc/i0060577.html

SMS �[ϕμí Mw ��\uw≤� SMS �[ϕμívA⌠}

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

db2luw/v10r1/topic/com.ibm.db2.luw.wn.doc/doc/

i0058748.html

H���r�� SQL �z�í

l�

Mw ��\uw≤�í�H���r�� SQL �

z�ívA⌠}� http://publib.boulder.ibm.com/

i n f o c e n t e r / d b 2 l u w / v 1 0 r 1 / t o p i c /

com.ibm.db2.luw.wn.doc/doc/i0058674.html

db2IdentifyType1 ⁿO 10.5 � ��\uw≤� db2IdentifyType1 ⁿOvA⌠

}� http://publib.boulder.ibm.com/infocenter/

db2luw/v10r1/topic/com.ibm.db2.luw.wn.doc/doc/

i0059642.html

db2_install ⁿO Mw ��\uw≤� db2_install ⁿO]Linux �

U N I X�vA⌠}� h t t p : / /

publib.boulder.ibm.com/infocenter/db2luw/v10r1/

t o p i c / c o m . i b m . d b 2 . l u w . w n . d o c / d o c /

i0058736.html

80 DB2 10.5 ��sW\α

Page 93: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

ϕ 22. 10.1 �ñw≤��\α (�≥)

wb����

ñ�εú� ���ΣLΩT

db2pdcfg ⁿO� -flushbp �� Mw ��\uw≤� db2pdcfg ⁿO� -flushbp

��vA⌠}� http://publib.boulder.ibm.com/

i n f o c e n t e r / d b 2 l u w / v 1 0 r 1 / t o p i c /

com.ibm.db2.luw.wn.doc/doc/i0058772.html

db2pd ⁿO� -tcbstat ���

Y�μΘX

Mw ��\uw≤� db2pd ⁿO� -tcbstat �

��Y�μΘXvA⌠}� h t t p : / /

publib.boulder.ibm.com/infocenter/db2luw/v10r1/

t o p i c / c o m . i b m . d b 2 . l u w . w n . d o c / d o c /

i0058932.html

CREATE DATABASE ⁿO�í

���

Mw ��\uw≤� CREATE DATABASE ⁿO

�í���vA⌠}� h t t p : / /

publib.boulder.ibm.com/infocenter/db2luw/v10r1/

t o p i c / c o m . i b m . d b 2 . l u w . w n . d o c / d o c /

i0058750.html

dynexpln ⁿO 10.5 � ��\uw≤� dynexpln ⁿOvA⌠}�

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

v10r1/topic/com.ibm.db2.luw.wn.doc/doc/

i0058770.html

PRUNE LOGFILE ⁿO Mw ��\uw≤� PRUNE LOGFILE ⁿOvA⌠}

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

db2luw/v10r1/topic/com.ibm.db2.luw.wn.doc/doc/

i0060625.html

LOAD ⁿO� ALLOW READ

ACCESS ��

Mw ��\uFP1Gw≤� LOAD ⁿO� ALLOW

READ ACCESS ��vA⌠}� http://

publib.boulder.ibm.com/infocenter/db2luw/v10r1/

t o p i c / c o m . i b m . d b 2 . l u w . w n . d o c / d o c /

i0058771.html

REORG INDEXES/TABLE ⁿO

�í�∩���÷ DB2 API Ω

��c���

Mw ��\uw≤��wεú� R E O R G

INDEXES/TABLE ⁿO����÷ DB2 API

Ω��c���vA⌠}� h t t p : / /

publib.boulder.ibm.com/infocenter/db2luw/v10r1/

t o p i c / c o m . i b m . d b 2 . l u w . w n . d o c / d o c /

i0059689.html

�zΩ�í�ⁿOñ� -m �

-cf ��μí

Mw ��\uw�≤�zΩ�í�ⁿOvA⌠

}� http://publib.boulder.ibm.com/infocenter/

db2luw/v10r1/topic/com.ibm.db2.luw.wn.doc/doc/

i0059122.html

ALTER DATABASE »zí Mw ��\uw≤� ALTER DATABASE »z

ívA⌠}� http://publib.boulder.ibm.com/

i n f o c e n t e r / d b 2 l u w / v 1 0 r 1 / t o p i c /

com.ibm.db2.luw.wn.doc/doc/i0058773.html

�ΦΩ�s�ñ°i�

details_xml

Mw ��\uFP1Gw≤���pΩ��≤�°�

b details_xml ñ°i�qvA⌠}� http://

publib.boulder.ibm.com/infocenter/db2luw/v10r1/

t o p i c / c o m . i b m . d b 2 . l u w . w n . d o c / d o c /

i0060390.html

� 20 � w≤��wεú��Kn 81

Page 94: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

ϕ 22. 10.1 �ñw≤��\α (�≥)

wb����

ñ�εú� ���ΣLΩT

health_mon Ω�wtm�� Mw ��\uw≤��wεú�í�tm�

�vA⌠}� http://publib.boulder.ibm.com/

i n f o c e n t e r / d b 2 l u w / v 1 0 r 1 / t o p i c /

com.ibm.db2.luw.wn.doc/doc/i0058741.html

mincommit Ω�wtm�� Mw ��\uw≤��wεú�í�tm�

�vA⌠}� http://publib.boulder.ibm.com/

i n f o c e n t e r / d b 2 l u w / v 1 0 r 1 / t o p i c /

com.ibm.db2.luw.wn.doc/doc/i0058741.html

DB2_EXTENDED_OPTIMIZATION �

ENHANCED_MULTIPLE_DISTINCT ]

w

Mw ��\uw�≤í�n²�⌠���vA⌠

}� http://publib.boulder.ibm.com/infocenter/

db2luw/v10r1/topic/com.ibm.db2.luw.wn.doc/doc/

i0052034.html

S N A P H A D R �z°��

SNAP_GET_HADR ϕμτ�

Mw ��\uw≤� HADR �í��°��vA

⌠}� http://publib.boulder.ibm.com/infocenter/

db2luw/v10r1/topic/com.ibm.db2.luw.wn.doc/doc/

i0059582.html

Uϕπ� 10.1 � ñw≤��n²��CpGn²��wεú�Aϕμñ]�π�

εú�o�n²�����C

ϕ 23. 10.1 �ñw≤��n²���]w

n²��

wb����

ñ�εú� ���ΣLΩT

DB2_LIKE_VARCHAR Mw ��\uw≤�í�n²�⌠���vA⌠

}� http://publib.boulder.ibm.com/infocenter/

db2luw/v10r1/topic/com.ibm.db2.luw.wn.doc/doc/

i0052033.html

10.5 �ñw≤��\α

Uϕπ� 10.5 � ñw≤��\αCpG\αwεú�Aϕμñ]�π�εú��

\��C

ϕ 24. 10.5 �ñw≤��\α

wb����

ñ�εú� ���ΣLΩT

db2DatabaseUpgrade � COBOL

� FORTRAN Σ�

Mw ��\uw≤� db2DatabaseUpgrade API �

COBOL � FORTRAN yÑΣ�vA⌠}�

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

v10r5/topic/com.ibm.db2.luw.wn.doc/doc/

i0060820.html

w≤�í� SQL �z�í Mw ��\uw≤�� SQL �z�í�°�vA

⌠}� http://publib.boulder.ibm.com/infocenter/

db2luw/v10r5/topic/com.ibm.db2.luw.sql.rtn.doc/

doc/r0023171.html

82 DB2 10.5 ��sW\α

Page 95: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

ϕ 24. 10.5 �ñw≤��\α (�≥)

wb����

ñ�εú� ���ΣLΩT

softmax Ω�wtm�� Mw ��\uw≤��wεú�í�Ω�wt

m��vA⌠}� http://publib.boulder.ibm.com/

i n f o c e n t e r / d b 2 l u w / v 1 0 r 5 / t o p i c /

com.ibm.db2.luw.wn.doc/doc/i0058741.html

Uϕπ� 10.5 � ñw≤��n²��CpGn²��wεú�Aϕμñ]�π�

εú�o�n²�����C

ϕ 25. 10.5 �ñw≤��n²���]w

n²��

wb����

ñ�εú� ���ΣLΩT

Mw ��\uw≤�í�n²�⌠���vA⌠

}� http://publib.boulder.ibm.com/infocenter/

db2luw/v10r5/topic/com.ibm.db2.luw.wn.doc/doc/

i0052033.html

� 20 � w≤��wεú��Kn 83

Page 96: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

84 DB2 10.5 ��sW\α

Page 97: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

� 3 g DB2 Connect [j\α��≤Kn

b 10.5 � ñAw[j��≤ DB2 Connect ú�\αC

� 87 ��� 21 �, yvT DB2 Connect Server � DB2 10.5 � [j\�

≤z ��í� 10.5 � ñiα�vT{s DB2 Connect \α�[j\αBw�≤

\αBw≤��\α�wεú��\αC

�÷º�:

� 43��� 2 g, y�≤\αz

© Copyright IBM Corp. 2013 85

Page 98: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

86 DB2 10.5 ��sW\α

Page 99: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

� 21 � vT DB2 Connect Server � DB2 10.5 � [j\α��≤

]� DB2 Ω�wú�P DB2 Connect Server ºí@�@δ\αA�H�í� DB2 10.5

� [j\α��≤�vT DB2 Connect Server �\αC

UCO�vT DB2 Connect Server \α� 10.5 � [j\α��≤C

ú�M�[j\α

v ��M�� 7��� 2 �, yú�M�[j\αz

w����[j\α

v Data Studio Web D�xπX� 35��y�� DB2 ��{íw� IBM Data Stu-

dio Web D�x �≤z

�°����DP�[j\α

v s�ⁿO��i[j�°���α� 37��ys�ⁿO��i[j�°���αz

w≤��\α

v db2DatabaseUpgrade API � COBOL � FORTRAN yÑΣ�� 57��yw≤�

db2DatabaseUpgrade API � COBOL � FORTRAN yÑΣ�z

�εú��\α

v A��O�Nz{íu²��� 61 ��ywεú�A��O�Nz{íu²�

�z

v ���pΩ�]w�� 64��ywεú����pΩ�]w�z

v úAΣ�í�@�t�� 63��yúAΣ�í�@�t�z

© Copyright IBM Corp. 2013 87

Page 100: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

88 DB2 10.5 ��sW\α

Page 101: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

� 4 g �²PßO

© Copyright IBM Corp. 2013 89

Page 102: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

90 DB2 10.5 ��sW\α

Page 103: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

�² A. DB2 S�� DB2 ú���ñ�\α

í�\αusb≤Sw DB2 Ω�wú���C

ϕμⁿX DB2 ú���ñ�t�\αC

�Gϕμ����Cp��vBv¡�q����Ω�A��\ DB2 ú���vX

�C

ϕ 26. DB2 S�� DB2 Ω�wú���ñ�\α

D B 2Express-C

D B 2Express ®

Edition1

DB2 Work-group ServerEdition

DB2 Enter-prise ServerEdition

D B 2AdvancedWorkgroupServer Edi-tion

D B 2AdvancedEnterpriseServer Edi-tion

DB2 Devel-oper Ed i -tion

�A�úY��

�εCúY

No No No No Yes Yes Yes

PΓíΣL DB2

LUW °A���

≤Ω���g

No No No No Yes Yes Yes

úYG�≈ Yes Yes Yes Yes Yes Yes Yes

su�ñ� No No No Yes Yes Yes Yes

s≥Ω�l¼ No No No No Yes Yes Yes

DB2 Advanced

Copy Services]�

� Tivoli Storage

FlashCopy® Man-

ager�

No Yes Yes Yes Yes Yes Yes

DB2 ���

ϕμ

No No No No Yes Yes Yes

\α No No No No Yes2 Yes2 Yes

DB2 Governor No No No Yes Yes Yes Yes

DB2 pureScale \

α

No No No No Yes Yes Yes

D B 2 R e c o v e r y

Expert

I B M D B 2

A d v a n c e d

Recovery S

I B M D B 2

A d v a n c e d

Recovery S�

I B M D B 2

A d v a n c e d

Recovery S

I B M D B 2

A d v a n c e d

Recovery S

I B M D B 2

A d v a n c e d

Recovery S

I B M D B 2

A d v a n c e d

Recovery S

D B 2 M e r g e

Backup

I B M D B 2

A d v a n c e d

Recovery S

I B M D B 2

A d v a n c e d

Recovery S�

I B M D B 2

A d v a n c e d

Recovery S

I B M D B 2

A d v a n c e d

Recovery S

I B M D B 2

A d v a n c e d

Recovery S

I B M D B 2

A d v a n c e d

Recovery S

P DB2 LUW �

Informix® Data

Server ����

pX

Yes Yes Yes Yes Yes Yes Yes

P DB2 LUW �

Oracle ����

pX

No No No Yes2 Yes2 Yes Yes

¬i��a°

No Yes Yes Yes Yes Yes Yes

IBM Data Studio Yes Yes Yes Yes Yes Yes Yes

IBM InfoSphere

Data Architect

No No No No Yes3 Yes3 Yes3

© Copyright IBM Corp. 2013 91

Page 104: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

ϕ 26. DB2 S�� DB2 Ω�wú���ñ�\α (�≥)

D B 2Express-C

D B 2Express ®

Edition1

DB2 Work-group ServerEdition

DB2 Enter-prise ServerEdition

D B 2AdvancedWorkgroupServer Edi-tion

D B 2AdvancedEnterpriseServer Edi-tion

DB2 Devel-oper Ed i -tion

IBM InfoSphere

Optim Configura-

tion Manager

No No No No Yes Yes Yes

IBM InfoSphere

O p t i m P e r f o r -

mance Manager

Extended Edition

No No No No Yes Yes Yes

IBM InfoSphere

Optim pureQuery®

Runtime

No No No No Yes Yes Yes

IBM InfoSphere

O p t i m Q u e r y

Workload Tuner

No No No No Yes Yes Yes

IBM InfoSphere

Optim High Per-

formance Unload

I B M D B 2

A d v a n c e d

Recovery S

I B M D B 2

A d v a n c e d

Recovery S�

I B M D B 2

A d v a n c e d

Recovery S

I B M D B 2

A d v a n c e d

Recovery S

I B M D B 2

A d v a n c e d

Recovery S

I B M D B 2

A d v a n c e d

Recovery S

IBM Mobile Data-

base

Yes Yes Yes Yes Yes Yes Yes

IBM Mobile Data-

base Sync

Yes Yes Yes Yes Yes Yes Yes

��¼s��ε

(LBAC)

No Yes Yes Yes Yes Yes Yes

πΘd�ϕμ

(MQT)

No No No Yes Yes Yes Yes

h��O�

(MDC) ϕμ

No No No Yes Yes Yes Yes

h½�xsΘ No No No Yes Yes Yes Yes

N e t S e a r c h

Extender

Yes Yes Yes Yes Yes Yes Yes

uW½� No Yes Yes Yes Yes Yes Yes

Oracle �e� Yes Yes Yes Yes Yes Yes Yes

�� - ���Ω

�w⌠�

No No No No Yes Yes Yes

�� - ϕμ�� No No Yes Yes Yes Yes Yes

pureXML® xsΘ Yes Yes Yes Yes Yes Yes Yes

PΓíΣL DB2

LUW °A�� Q

�g

No No No No Yes Yes Yes

d�¡μ No No No Yes Yes Yes Yes

�guπ Yes4 Yes4 Yes4 Yes4 Yes Yes4 Yes

εC��μs�

�ε (RCAC)

No Yes Yes Yes Yes Yes Yes

Spatial Extender Yes Yes Yes Yes Yes Yes Yes

D B 2 L U W P

I n f o r m i x D a t a

S e r v e r ºí�

SQL �g

No Yes Yes Yes Yes Yes Yes

�íl�d� Yes Yes Yes Yes Yes Yes Yes

IBM Tivoli Sys-

tem Automation

for Multiplatforms

No Yes Yes Yes Yes Yes Yes

u@q�z No No No No Yes Yes Yes

92 DB2 10.5 ��sW\α

Page 105: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

�G

1. DB2 Express Edition]]A DB2 Express Edition Fixed Term License�

2. u��� SQL Warehouse uπ (SQW) �α��\αC

3. DB2 Advanced Enterprise Server Edition ]A 10 InfoSphere Data Architect �

���vC

4. b��Σ��@�t�WiH��u�gñ�vH���guπCu�gñ�v�

A�≤ Linux � Windows @�t�C

�² A. DB2 S�� DB2 ú���ñ�\α 93

Page 106: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

94 DB2 10.5 ��sW\α

Page 107: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

�² B. DB2 Connect ú���ñ DB2 S��\α

í�\αusb≤Sw DB2 Connect ú���Cbí�ípUA\αOPSw DB2 S

��÷pC

ϕμⁿX DB2 Connect ú���ñ�t�\αCpG\αúA�≤ DB2 Connect ú

�Ah�ⁿwuúA�vC

ϕ 27. DB2 Connect ú���ñ�\α

DB2 Connect Personal Edi-tion DB2 Connect °A���

�A�úY No No

i��A� No Yes

úYG�≈ No No

úYGΩ� No No

úYG� No No

úYG��ϕμ No No

úYGXML No No

su�ñ� No Yes

s≥Ω�l¼ No No

�w�� No No

DB2 Governor No Yes

ºΦpX No No

¬i��a° � No Yes

PΦpX No Yes

PΦ Q �g No No

IBM Data Studio Yes Yes

IBM InfoSphere Optim Perfor-

mance Manager Extended Edi-

tion1

No No

I B M I n f o S p h e r e O p t i m

pureQuery Runtime

No Yes2

��¼s��ε (LBAC) No No

πΘd�ϕμ (MQT) No Yes

h��O� (MDC) ϕμ No Yes

h½�xsΘ No No

uW½� No No

DB2 pureScale No No

pureXML xsΘ No No

d�¡μ No Yes

�guπ No Yes3

y@� No No

© Copyright IBM Corp. 2013 95

Page 108: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

ϕ 27. DB2 Connect ú���ñ�\α (�≥)

DB2 Connect Personal Edi-tion DB2 Connect °A���

Spatial Extender No Yes

�íl�d� Yes Yes

ϕμ�� No No

Tivoli System Automation No Yes

u@q�z No Yes

�G

1. IBM InfoSphere Optim Performance Manager Extended Edition O Performance Expert �U

@Nú�CIBM InfoSphere Optim Performance Manager Extended Edition i≤U��½

n⌠�Ω�w���{í��αMi��C

2. u� DB2 Connect Unlimited Edition for System z® � DB2 Connect Application Server

Advanced Edition �]A IBM InfoSphere Optim pureQuery RuntimeC

3. b��Σ��@�t�WiH��u�gñ�vH���guπCu�gñ�v�A�≤

Linux � Windows @�t�C

96 DB2 10.5 ��sW\α

Page 109: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

�² C. DB2 �NΩTº[

ú�h μí� DB2 �NΩTAziHQ�h Φí�s�ª�C

ziHzLUCuπ�Φk��o DB2 �NΩTG

v DB2 ΩTñ�

– DD (@�Bº ���DD)

– d{í

– ⁿ���

v DB2 �y

– PDF � (iUⁿ)

– PDF �]�� DB2 PDF DVD�

– X��

v ⁿOμí�

– ⁿOí�

– Tºí�

�GuDB2 ΩTñ�vDD�≤sWv¬≤ PDF �LΩ�yCYn�o�sΩTA�

bσ≤@≤s�Nw�ª�A�yXuDB2 ΩTñ�vA⌠}� ibm.comC

ziHb ibm.com WuWs�ΣL DB2 �NΩTAp TechNotesB���� IBM

Redbooks®X��C�s� DB2 Information Management nΘw⌠A⌠}� 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] σ≤�ñ�\¬z���NúA²ú��

�C�ú�Swd�iα�mA²��iH≤R��A�z��DCpGn∩S

w�DD�í��ú�NúA�[WDD�D� URLC

����oqll≤�}�puDB2 �ßΣ�ñ�vCpG�σ≤��M� DB2

�N�DA�pϕa IBM A�ñ�HMD≤UC

LΩ�y� PDF μí� DB2 �N�w

Uϕí�uIBM X��ñ�vú�� DB2 �wA⌠}�Gwww.ibm.com/e-business/

linkweb/publications/servlet/pbi.wssCziHq www.ibm.com/support/docview.wss?rs=71

&uid=swg27009474 Uⁿ PDF μí��σ��w��� DB2 10.1 � ΓUC

Y�ϕμⁿX�ú�LΩ���yAz�Ωa�a iα�OS�ú�o��yC

� �H�C�≤sΓU�W[C�Twz¬��ΓUO�s��ApU��C

�GuDB2 ΩTñ�v�≤sWv¬≤ PDF �LΩ�yC

© Copyright IBM Corp. 2013 97

Page 110: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

ϕ 28. DB2 �NΩT

W� �� ú�LΩ�� ��Θ�

Administrative API Refer-

ence

SC27-5506-00 O 2013 � 7 δ 28 Θ

Administrative Routines

and Views

SC27-5507-00 2013 � 7 δ 28 Θ

Call Level Interface Guide

and Reference Volume 1

SC27-5511-00 O 2013 � 7 δ 28 Θ

Call Level Interface Guide

and Reference Volume 2

SC27-5512-00 O 2013 � 7 δ 28 Θ

Command Reference SC27-5508-00 O 2013 � 7 δ 28 Θ

Database Administration

Concepts and Configura-

tion Reference

SC27-4546-00 O 2013 � 7 δ 28 Θ

Data Movement Utilities

Guide and Reference

SC27-5528-00 O 2013 � 7 δ 28 Θ

Database Monitoring

Guide and Reference

SC27-4547-00 O 2013 � 7 δ 28 Θ

Data Recovery and High

Availability Guide and

Reference

SC27-5529-00 O 2013 � 7 δ 28 Θ

Database Security Guide SC27-5530-00 O 2013 � 7 δ 28 Θ

DB2 Workload Manage-

ment Guide and Refer-

ence

SC27-5520-00 O 2013 � 7 δ 28 Θ

Developing ADO.NET and

OLE DB Applications

SC27-4549-00 O 2013 � 7 δ 28 Θ

Developing Embedded

SQL Applications

SC27-4550-00 O 2013 � 7 δ 28 Θ

Developing Java Applica-

tions

SC27-5503-00 O 2013 � 7 δ 28 Θ

Developing Perl, PHP,

Python, and Ruby on

Rails Applications

SC27-5504-00 2013 � 7 δ 28 Θ

Developing RDF Applica-

tions for IBM Data Serv-

ers

SC27-5505-00 O 2013 � 7 δ 28 Θ

Developing User-defined

Routines (SQL and Exter-

nal)

SC27-5501-00 O 2013 � 7 δ 28 Θ

Gett ing Started with

Database Application

Development

GI13-2084-00 O 2013 � 7 δ 28 Θ

Linux � Windows W

DB2 w���zJ�

GI13-1162-00 O 2013 � 7 δ 28 Θ

Globalization Guide SC27-5531-00 O 2013 � 7 δ 28 Θ

98 DB2 10.5 ��sW\α

Page 111: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

ϕ 28. DB2 �NΩT (�≥)

W� �� ú�LΩ�� ��Θ�

w� DB2 °A� GC27-3192-00 O 2013 � 7 δ 28 Θ

w� IBM Data Server

Client

GC27-3193-00 2013 � 7 δ 28 Θ

Tº��ΓU�@U SC27-3198-00 2013 � 7 δ 28 Θ

Tº��ΓU�GU SC27-3199-00 2013 � 7 δ 28 Θ

Net Search Extender

Administration and User’s

Guide

SC27-5526-00 2013 � 7 δ 28 Θ

Partitioning and Cluster-

ing Guide

SC27-5532-00 O 2013 � 7 δ 28 Θ

pureXML Guide SC27-5521-00 O 2013 � 7 δ 28 Θ

Spatial Extender User’s

Guide and Reference

SC27-5525-00 2013 � 7 δ 28 Θ

SQL Procedural Lan-

guages : App l i ca t i on

Enablement and Support

SC27-5502-00 O 2013 � 7 δ 28 Θ

SQL Reference Volume 1 SC27-5509-00 O 2013 � 7 δ 28 Θ

SQL Reference Volume 2 SC27-5510-00 O 2013 � 7 δ 28 Θ

Text Search Guide SC27-5527-00 O 2013 � 7 δ 28 Θ

Troubleshooting and Tun-

ing Database Perfor-

mance

SC27-4548-00 O 2013 � 7 δ 28 Θ

�� DB2 10.5 � SC27-3191-00 O 2013 � 7 δ 28 Θ

DB2 10.5 ��sW\α SC27-3197-00 O 2013 � 7 δ 28 Θ

XQuery Reference SC27-5522-00 2013 � 7 δ 28 Θ

ϕ 29. DB2 Connect Sw�NΩT

W� �� ú�LΩ�� ��Θ�

DB2 Connect w��t

m DB2 Connect Per-

sonal Edition

SC27-3194-00 O 2013 � 7 δ 28 Θ

DB2 Connect w��t

m DB2 Connect °A�

SC27-3195-00 O 2013 � 7 δ 28 Θ

DB2 Connect ��ΓU SC27-3196-00 O 2013 � 7 δ 28 Θ

qⁿOμBz�π� SQL ¼Aí�

DB2 ú��w∩°≤� iαO SQL »zí�G� SQLSTATE C SQLSTATE í

�i�� SQL ¼A� SQL ¼A�OrX�NqC

�² C. DB2 �NΩTº[ 99

Page 112: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

{�

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��� DB2 ΩTñ�

ΣL DB2 ú����σ≤ib ibm.com® W�OΩTñ�Σ�C

÷≤o�@�

p� DB2 10.1 � DDAuDB2 ΩTñ�vURL � http://pic.dhe.ibm.com/infocenter/

db2luw/v10r1C

p� DB2 9.8 �DDAuDB2 ΩTñ�vURL � http://pic.dhe.ibm.com/infocenter/

db2luw/v9r8/C

p� DB2 9.7 �DDAuDB2 ΩTñ�vURL � http://pic.dhe.ibm.com/infocenter/

db2luw/v9r7/C

p� DB2 9.5 �DDAuDB2 ΩTñ�vURL � http://publib.boulder.ibm.com/infocenter/

db2luw/v9r5C

ΩTñ��°�

��Uz°�AN�Pz∩o�X�����v¡C

A��GUC°�Y IBM ⌠���°�C

�H��Gzi�s�ÑuX��v�H�D������A��O IBM �@

v���ΣL��vk� IBM º�÷σrC�g IBM ��PNAzúo�GBi�

�∩@�ÑuX��v�Σ⌠≤í�C

���GziH�sB�G�i��ÑuX��v��°��í��A��O IBM

�@v���ΣL��vk� IBM º�÷σrC�g IBM ��PNAzúo∩@�

ÑuX��vA]úo≤°���sB�G�i��ÑuX��v�Σ⌠≤í�C

v¡Gú���n�ñ�T��º\i�A���NuX��v�⌠≤]t≤Σñº

ΩTBΩ�BnΘ�ΣL z]úvA���oΣL⌠≤���q\º\iBnΘ�

v�vQC

���∩≤uX��vº��pM� IBM �vqA� IBM {wΣ�ϕ�Wzⁿ��

�uX��v�AIBM oH�MPB���º\iC

úDz��ϕu��A�º@�kWA]A��ⁿΩXfkWAhzúoUⁿBX

f�AΘXÑΩTC

IBM ∩≤�ÑX��º�eú�⌠≤O�CX���Σu{¼vú�Aú�a⌠≤��

�q�ºßOAΣñ]A (²ú¡≤) AΓ�BDIv�AXSw�ºq�ßOd⌠C

100 DB2 10.5 ��sW\α

Page 113: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

IBM �GIBMBIBM �xB� ibm.com OΩ��≈� ≈�¡�q (IBM) bⁿ

Ω� (�) ΣLΩa����U��A�b�@�\h� ñ�¿UCΣLú�

�A�W�iαO IBM �ΣL�q���CA current list of trademarks is available b

⌠}� www.ibm.com/legal/copytrade.shtml �⌠�WA�{μ� IBM ��MμC

�² C. DB2 �NΩTº[ 101

Page 114: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

102 DB2 10.5 ��sW\α

Page 115: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

�² D. �N�

�ΩTYw∩ IBM bⁿΩ�ú�ºú�PA��}oCD IBM ú���÷ΩTOH

�σ≤�@�X��i��ΩT�≥ªA�B�úw��≤C

bΣLΩañAIBM iαú�ú���ñ�ú�U�ú�BA��\αCnDz�b

Oi��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�pzΩa� IBM z]ú

í�A�����ΦíH�G

Intellectual Property Licensing

Legal and Intellectual Property Law

IBM Japan, Ltd.

19-21, Nihonbashi-Hakozakicho, Chuo-ku

Tokyo 103-8510, 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ß��

e�Js�ñ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. 2013 103

Page 116: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

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�⌠pA

ΣΩ�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]

AHB�qBtPMú��W�Co�W���ΩcAYP⌠≤�q�W�Mϕ}

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��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 IBM �ΣL�q���Cb Copyright and trademark information ⌠�ñ]⌠

}� www.ibm.com/legal/copytrade.shtml�A��s� IBM ��MμC

UCNyOΣL�q����U��

104 DB2 10.5 ��sW\α

Page 117: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

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 �xBCeleronBIntel SpeedStepBItanium

� Pentium O Intel Corporation �Σl�qbⁿΩ�ΣLΩa�a ����U

��C

v MicrosoftBWindowsBWindows NT � Windows �xO Microsoft Corporation bⁿ

Ω� (�) ΣLΩa���C

ΣL�qBú��A�W�iαOΣL�q����A��xC

�² D. �N�� 105

Page 118: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

106 DB2 10.5 ��sW\α

Page 119: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

��

���HñσrA�σrA�Sϕ� º���

CC

eT�fu@q¡�

[j\α 25

w≤��\α

Nz{íu²�� 61

�wtm�� 58, 65

Ω�w�z{ítm�� 58, 65

Kn 43, 57, 67

db2DatabaseUpgrade API

COBOL � FORTRAN �Σ� 57

w�≤�\α

Kn 43

��{í}o 51

e��f��τ�

sW 51

�≤ 51

���í

sW 51

�≤ 51

��°�

sW 51

�≤ 51

[j\αKn 35

σ≤

L� 97

°���� 100

º[ 97

PDF �� 97

Θx

[j\αKn 19

Θx�s@�

s�w]μ� 45

e¡�fDn�Σ¡ε

NOT ENFORCED 9

H�μ���ϕμ

Ω�w 9

Nz{íu²��

w≤� 61

i¼ �xsΘ

[j\α 40

i�z�

[j\αKn 9

��

[j\α

Kn 27

e��f �

[j\αKn 19

w�

[j\αKn 35

�≤Kn 49

���p�]w�

wεú� 64

eC�ft�¼²

°�

sW 51

�≤ 51

eK�fτ�

sW 51

�≤ 51

A��O

Nz{íu²��

wεú� 61

�N�� 103

�μ��� ϕμ

��ΩT 21

�°�q 11

ϕ�í¼�Σ

º[ 21

ϕμ��

[j\α 9

¼²°�

sW 51

�≤ 51

eE�f�q

�°

�μ��� ϕμ 11

© Copyright IBM Corp. 2013 107

Page 120: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

ⁿO

�∩Kn 55

db2pd

[j\α 37

db2support

[j\α 37

ⁿOμBz� (CLP)

ⁿO�≤ 55

¡ε

NOT ENFORCED

Dn�Σ 9

�@� 9

eQ�f�M≤

[j\αKn 35

uW≤s� 41

�α

[j\α

Kn 21

EHL 21

DB2 pureScale ⌠�

[j\α 21

EHL 21

ϕ�í¼�Σ

º[ 21

�Σ

NULL �μ 23

�Σ

ϕ�í¼ 21

°�

WX 23

tm��

sW 46, 49

�≤ 46, 49

¬i��

[j\αKn 19

¬G�����D ix

eQ@�fεú��\α

���p�]w� 64

�wtm�� 58, 65

Ω�w�z{ítm�� 58, 65

Kn 43, 61, 67

SQL �z�í 62

�DP

[j\αKn 37

�@¡ε

NOT ENFORCED 9

�í

sW 51

�≤ 51

°�

X�� 100

eQG�f�≈

[j\αKn 19

��

[j\αKn 19

�s°º

STMM [j\α 22

Naϕμ½�

[j\α 40

n²��

w≤� 57

εú��Σ� 65

s� 46

�≤ 46

°�

sW 51

�≤ 51

eQT�fsW

DB2 σrjM

SET COMMAND LOCKS ⁿO 33

sW\α

Kn 1

sWS�

½I 3

Kn 1

��

�μ��� ϕμ 21

Ω�w

]w�≤Kn 49

�wtm��

wεú� 58, 65

w≤� 58, 65

sW 49

�≤ 49

Ω�w�z{ítm��

wεú� 58, 65

w≤� 58, 65

s� 46

�≤ 46

eQ��f�°��

[j\αKn 37

108 DB2 10.5 ��sW\α

Page 121: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

�°

[j\α

Kn 11

�q

�μ��� ϕμ 11

�z

�∩Kn 45

í�

SQL »zí 100

eQ¡�fs��

sW 51

�≤ 51

��

\α 91

uW≤s�

�M≤ 41

eQ��fεCjp

j¼ 23

H≈����μ

º[ 40

eQC�f��{í}o

�≤Kn 51

⌠���

�≤ 46

eGQ@�fX�{í

[j\α

Kn 27

CCLI

[j\α 27

CLP]ⁿOμBz��

ⁿO

�≤ 55

DDB2 Advanced Copy Services (ACS)

Script �� 19

DB2 Connect

[j\αKn 85

DB2 Connect (�≥)

º[ 95

�≤Kn 85

DB2 [j\αKn 87

DB2 �≤Kn 87

DB2 for Linux, UNIX, and Windows

����\α 91

DB2 pureScale S�

[j\α 25, 39, 40

DB2 pureScale Ω

[j\α 39, 40

DB2 pureScale ⌠�

[j\α 21

EHL

º[ 21

HADR

º[ 19

DB2 u@q�z

[j\α

Kn 25

DB2 σrjM

[j\α

tm\α 33

Twσ�Bz 33

[j\αKn 33

sW

�tm∩� 34

DB2 t�ⁿO

�∩Kn 55

DB2 ú�

]� 7

DB2 ΩTñ�

�� 100

db2DatabaseUpgrade API

w≤� COBOL � FORTRAN �Σ� 57

db2pd ⁿO

[j\α 37

-hadr �≤ 18

db2support ⁿO

[j\α 37

DB2_EVMON_EVENT_LIST_SIZE n²��

w≤� 57

DB2_NCHAR_SUPPORT n²��

w≤� 57

DB2_WORKLOAD E�n²��

�≤ 46

dft_table_org �wtm��

sW 49

EEHL

º[ 21

� 109

Page 122: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

GGuardium GIM Client

w�{í

w�J DB2 w�ñ 35

HHADR

�l]w

�≤ 45

]w

�≤ 45

���w

Θx�s@� 45

DB2 pureScale ⌠�

º[ 19

hadr_spool_limit �wtm��

�≤ 45, 49

hadr_syncmode �wtm��

�≤ 49

IIBM Data Server Client

[j\α 27

IBM Data Server Provider for .NET

[j\α 29

IBM Data Server X�{í

[j\α 27

IBM Data Studio

Web D�xw�[j\α 35

installFixPack ⁿO

[j\α 35

JJDBC

[j\αKn 30

MMON_GET_HADR

�≤ 18

Rroot nJ 36

SSnapshot �≈

Script �� 19

Snapshot ��

Script �� 19

SQL

�e�[j\α 23

SQL »zí

í�

π� 100

�≤ 55

SQL �z�í

wεú� 62

SYSCAT °�

sW 51

�≤ 51

eSϕr�f.NET

[j\α 29

110 DB2 10.5 ��sW\α

Page 123: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00
Page 124: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

����

Printed in Taiwan

SC27-3197-00

Page 125: DB2 10.5 W - IBMpublic.dhe.ibm.com/ps/products/db2/info/vr105/pdf/... · IBM DB2 10.5 for Linux, UNIX, and Windows DB2 10.5 sW\α SC27-3197-00

Spineinformation:

IBM

DB

210

.5fo

rL

inu

x,U

NIX

,an

dW

ind

ow

sD

B2

10.5��sW\α

��