IBM Cloud 1 %CBOE+VQZUFS/PUFCPPLT Š (FPSHF#BLMBS[ %C%JHJUBM5FDIOJDBM&OHBHFNFOU ೔ຊޠ༁ ੢ށ ژࢠ ,ZPLP/JTIJUP ೔ຊΞΠɾϏʔɾΤϜגࣜձࣾ ςΫϊϩδʔࣄۀ෦ %BUB"*5FDIOJDBM4BMFT

IBM Cloud 2 Legal Disclaimer 2 Copyright © IBM Corporation 2019 All rights reserved. U.S. Government Users Restricted Rights - Use, duplication, or disclosure restricted by GSA ADP Schedule Contract with IBM Corporation THE INFORMATION CONTAINED IN THIS PRESENTATION IS PROVIDED FOR INFORMATIONAL PURPOSES ONLY. WHILE EFFORTS WERE MADE TO VERIFY THE COMPLETENESS AND ACCURACY OF THE INFORMATION CONTAINED IN THIS PRESENTATION, IT IS PROVIDED “AS IS” WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED. IN ADDITION, THIS INFORMATION IS BASED ON CURRENT THINKING REGARDING TRENDS AND DIRECTIONS, WHICH ARE SUBJECT TO CHANGE BY IBM WITHOUT NOTICE. FUNCTION DESCRIBED HEREIN MY NEVER BE DELIVERED BY IBM. IBM SHALL NOT BE RESPONSIBLE FOR ANY DAMAGES ARISING OUT OF THE USE OF, OR OTHERWISE RELATED TO, THIS PRESENTATION OR ANY OTHER DOCUMENTATION. NOTHING CONTAINED IN THIS PRESENTATION IS INTENDED TO, NOR SHALL HAVE THE EFFECT OF, CREATING ANY WARRANTIES OR REPRESENTATIONS FROM IBM (OR ITS SUPPLIERS OR LICENSORS), OR ALTERING THE TERMS AND CONDITIONS OF ANY AGREEMENT OR LICENSE GOVERNING THE USE OF IBM PRODUCTS AND/OR SOFTWARE. IBM, the IBM logo, ibm.com and Db2 are trademarks or registered trademarks of International Business Machines Corporation in the United States, other countries, or both. If these and other IBM trademarked terms are marked on their first occurrence in this information with a trademark symbol (® or !), these symbols indicate U.S. registered or common law trademarks owned by IBM at the time this information was published. Such trademarks may also be registered or common law trademarks in other countries. A current list of IBM trademarks is available on the Web at “Copyright and trademark information” at www.ibm.com/legal/copytrade.shtml

IBM Cloud 3 Agenda § +VQZUFS /PUFCPPLͱ͸ʁ § ͳͥ +VQZUFS /PUFCPPL § %CΛ /PUFCPPLʹ౷߹ͯ͠ΈΑ͏ - ಈ͔ͯ͠ΈΑ͏ - 42-αϙʔτ - ߴ౓ͳػೳ § ελʔτʹ໾ཱͭϦιʔε

IBM Cloud 4 Jupyter Notebook § +VQZUFSͷϊʔτϒοΫ͸ɺ೥݄ʹ։ൃ͕࢝·ͬͨ*1ZUIPOΛϕʔεʹ͍ͯ͠·͢ɻ § طଘͷ1ZUIPOΠϯλʔϓϦλ͸ػೳ͕ݶΒΕ͓ͯΓɺΑΓॆ࣮ͨ͠։ൃ؀ڥΛ࡞ΔͨΊʹ ࡞ۀ͕࢝·Γ·ͨ͠ɻ § ೥ʹ͸*1ZUIPO͕ϦϦʔε͞Ε·ͨ͠ IUUQCMPHGQFSF[PSHJQZUIPOOPUFCPPLIJTUPSJDBMIUNM § ϊʔτϒοΫͷʮςΩετʯΛ࡞੒͢ΔͨΊʹ.BSLEPXOΛ࢖༻͍ͯ͠·͢ɻ § ίʔυͷηϧʹ͸ҎԼͷ΋ͷ͕࢖͑·͢ - 1ZUIPO - .BHJDίϚϯυ ޙड़ - +BWB $ (P-BOH ͳͲ͍Ζ͍Ζͳݴޠ § ΠϯλϥΫςΟϒͳ։ൃͱϓϩτλΠϐϯά͕Մೳ

IBM Cloud 5 +VQZUFS /PUFCPPL͸ͲΜͳ΋ͷ § .JDSPTPGU8PSEʹࣅ͍ͯ·͕͢ɺϥΠϒίʔυ͕͋Γ·͢ɻ ςΩετ ίʔυ

IBM Cloud 6 Jupyter Notebook の動作要件 § ҰൠతͳσεΫτοϓϓϥοτϑΥʔϜͰಈ࡞ - -JOVY - .BD049 - 8JOEPXT § ίϯςϯπ͸8FCϒϥ΢βʔͰࢀর - $ISPNF *& 4BGBSJ 'JSFGPY FUDʜ § +VQZUFS͸ɺϫʔΫεςʔγϣϯ্ͰϩʔΧϧʹ࣮ߦ͢Δ͜ͱ΋ɺαʔϏεͷҰ෦ͱͯ͠ ࣮ߦ͢Δ͜ͱ΋Ͱ͖·͢ɻ - MPDBMIPTUͰ/PUFCPPLʹΞΫηε § ΠϯετʔϧΠϝʔδ͸ҎԼͷαΠτͰऔಘͰ͖·͢ - IUUQTKVQZUFSPSH - IUUQTXXXBOBDPOEBDPNEJTUSJCVUJPO - 1ZUIPOͱඞཁͳଟ͘ͷϥΠϒϥϦΛؚΉ"OBDPOEBͷϑϧελοΫΛೖख͢Δ͜ͱΛ͓קΊ͠ ·͢ɻ ༁஫"OBDPOEB͸৚݅ʹΑΓ༗ྉԽͨ͠ͷͰ஫ҙ

IBM Cloud 7 ෳࡶͳ+VQZUFS /PUFCPPLͷαϯϓϧ

IBM Cloud 8 ͳͥ+VQZUFS /PUFCPPL § Α͍ͱ͜Ζ - ݚڀऀ΍σʔλαΠΤϯςΟετʹ޿͘ར༻͞Ε͍ͯΔ - ςΩετ΍ίʔυͷڞ༗͕Մೳ - ࢼߦࡨޡΛଅ͠ɺίʔυͰԿ͕ى͍ͬͯ͜Δ͔Λه࿥͢Δ͜ͱ͕Ͱ͖Δ § ͍·͍ͪͳͱ͜Ζ - Կ͔Λ΍Δʹ͸1ZUIPOΛཧղ͢Δඞཁ͕͋Δʢͱ͖Ͳ͖ʣɻ - /PSFCPPLʹ͸%CͷωΠςΟϒ઀ଓ͕ͳ͍ʢ؆୯ʹͰ͖Δύοέʔδ͸͋Δ͕ɺ%Cͷ֦ு Λαϙʔτ͍ͯ͠ͳ͍

IBM Cloud 9 ͸͡ΊΑ͏ §"OBDPOEB·ͨ͸+VQZUFS/PUFCPPLΛΠϯετʔϧ͠·͢ - ωΠςΟϒʹΠϯετʔϧͨ͘͠ͳ͍৔߹͸ɺ%PDLFSͷ࢖༻Λݕ౼͍ͯͩ͘͠͞ ʢ༁஫ɿ"OBDPOEB΋%PDLFS %FTLUPQ΋৚݅ʹΑΓ༗ঈʹͳͬͨͷͰ஫ҙʣ §*OTUBMMUIF%C1ZUIPOESJWFS - FBTZ@JOTUBMM JCN@EC ·ͨ͸ - QJQJOTUBMMJCN@EC ༁஫ࠓ͸ͪ͜Β §%PXOMPBEUIF%C.BHJD$PNNBOE - IUUQTHJUIVCDPN%#4BNQMFTECKVQZUFS - ͨͬͨͭͷϑΝΠϧ͕ඞཁECJQZOC - JQZOC͸ +VQZUFS OPUFCPPL༻ͷ֦ுࢠͰ͢ - ͜ͷ +VQZUFS OPUFCPPLFOWJSPONFOUʹΠϯϙʔτ͠·͢ 9

IBM Cloud 10 ͕Μ͹Γ·͠ΐ͏ʂʜ § %PDLFSͷಋೖ - IUUQTEPDTEPDLFSDPN ࢀর §%PDLFSίϯςφͷ࡞੒ - IUUQTHJUIVCDPN%#4BNQMFTECKVQZUFS - ECKVQZUFSEPDLFSΛۭͷσΟϨΫτϦʹμ΢ϯϩʔυ͠·͢ - ,JUFNBUJD $-*ίϚϯυϥΠϯ͔ 8JOEPXTPS.BD PS-JOVYͷλʔϛφϧ΢Οϯυ΢Λ࢖͍·͢ w ECKVQZUFSEPDLFSϑΝΠϧ͕ஔ͔Ε͍ͯΔσΟϨτϦʹҠಈ͠·͢ w ҎԼͷίϚϯυΛ࣮ߦͯ͠ɺ%PDLFSΠϝʔδΛ࡞੒͠·͢ɻ EPDLFSCVJMEUECKVQZUFSGECKVQZUFSEPDLFS ß,FFQUIFQFSJPE EPDLFSSVOOBNFECKVQZUFSEQECKVQZUFS - ͓޷Έͷϒϥ΢βΛ࢖ͬͯMPDBMIPTU ʹΞΫηε ʢ༁஫ɿ%PDLFS %FTLUPQ͸༗ঈʹͳͬͨͷͰ஫ҙ -PDBMʹ+VQZUFS OPUFCPPLΛಋೖɺΫϥ΢υ؀ڥΛ࢖͏ ͔͋ͨΓ͕ଥ౰ʣ 10

IBM Cloud 11 ࣍͸Կ͢Δ §+VQZUFS /PUFCPPLTͷىಈ §%CυϥΠόʔ͕Ͳ͔͜ʹ͋Δ͜ͱΛ֬ೝ͍ͯͩ͘͠͞ʢ·ͨ͸%PDLFSΠϯετ ʔϧΛ࢖༻͍ͯͩ͘͠͞ʂʣɻ §ϊʔτϒοΫʹΞΫηε͠·͢ʢMPDBMIPTUʣɻ §ECJQZOCϊʔτϒοΫΛΠϯϙʔτ͢Δ͔ɺϊʔτϒοΫΛอଘ͢Δύεʹ഑ஔ ͠·͢ɻ 11

IBM Cloud 12 %C.BHJDίϚϯυͷϩʔυ §ۭͷϊʔτϒοΫΛ։͖ɺ࣍ͷίϚϯυΛೖྗ͠·͢ɻ §+VQZUFSͷ 3VOϘλϯ·ͨ͸4IJGU3FUVSOͰίʔυΛ࣮ߦ͠·͢ɻ §ຐ๏͕͔͔ͬͨʂʁ 12

IBM Cloud 13 .BHJDίϚϯυ §+VQZUFSʹ͸ɺ1ZUIPOίʔυ΍ಛผͳΞΫγϣϯΛ୅ߦ͢Δ.BHJDίϚϯυ͕༻ҙ ͞Ε͍ͯ·͢ - ྫ͑͹ TZTUFNγεςϜίϚϯυΛ࣮ߦ͠·͢ §SVOECJQZOCίϚϯυ͸ɺECJQZOCϑΝΠϧͷ಺༰ΛಡΈࠐΜͰɺ৽͍͠ TRM ͱ TRM ίϚϯυΛ࡞੒͠·͢ § TRMίϚϯυ͸ҰߦίϚϯυʹ࢖༻͞Εɺ TRM ͸ 42-ͷϒϩοΫΛ࣮ߦ͢Δ ͨΊͷ΋ͷͰ͢ɻ - ม਺ʹ୅ೖͰ͖Δͷ͸ TRM ίϚϯυͷ݁ՌͷΈͰ͢ɻ - \ม਺໊^Λ࢖༻ͨ͠1ZUIPOͷม਺ஔ׵͸ɺTRMίϚϯυͰͷΈಈ࡞͠·͢ɻ - ୯Ұͷ TRM ίϚϯυ͸ɺߦ຤ͷόοΫεϥογϡ = Λ࢖༻ͯ͠ෳ਺ߦʹ֦ுͰ͖·͢ɻ - TRM ϒϩοΫ಺ͷෳ਺ͷεςʔτϝϯτͰ͸ɺηϛίϩϯ ΛσϦϛλʔͱͯ͠࢖༻ ͠·͢ɻ 13

IBM Cloud 14 %C΁ͷ઀ଓ §%C.BHJDίϚϯυΛಡΈࠐΜͩΒɺ͍Α͍Α઀ଓͰ͢ɻ §઀ଓߏจ͸%C$-1ʹࣅ͍ͯ·͕͢ɺ͍͔ͭ͘ͷ޻෉͕͋Γ·͢ɻ TRM $0//&$550EBUBCBTF 64&3%#*/4564*/(ECJOTU )045103544- TRM $0//&$5$3&%&/5*"-4OBNF TRM $0//&$5130.15 TRM $0//&$53&4&5 TRM $0//&$5$-04& 14

IBM Cloud 15 %C΁ͷ઀ଓ §%C.BHJDίϚϯυΛಡΈࠐΜͩΒɺ͍Α͍Α઀ଓͰ͢ɻ §઀ଓߏจ͸%C$-1ʹࣅ͍ͯ·͕͢ɺ͍͔ͭ͘ͷ޻෉͕͋Γ·͢ɻ TRM $0//&$550EBUBCBTF 64&3%#*/45 64*/(ECJOTU )045 1035 44- TRM $0//&$5$3&%&/5*"-4OBNF TRM $0//&$5130.15 TRM $0//&$5 15

IBM Cloud 16 ϓϩϯϓτΛ࢖ͬͨ઀ଓ §130.15ʹ઀ଓ͢Δͱɺ͢΂ͯͷඞཁͳύϥϝʔλΛ࣭໰Λ͞Ε·͢ɻ §೚ҙͷλΠϛϯάͰఀࢭ͢Δʹ͸ɺ/6--஋Λೖྗ͠·͢ɻ 16

IBM Cloud 17 ೝূ৘ใΛ࢖ͬͨ઀ଓ §%CͷΫϥ΢υɾΠϯελϯε͔Βఏڙ͞ΕΔೝূ৘ใ §ೝূ৘ใΛ1ZUIPOͷม਺ʹׂΓ౰ͯͰ͖·͢ NZJE \EC#-6%# QBTTXPSEJGPSHPUJU ʜ^ TRM $0//&$5$3&%&/5*"-4NZJE 17

IBM Cloud 18 ઀ଓ৘ใΛ࢖ͬͨ઀ଓ §σʔλϕʔε΁ͷ઀ଓʹඞཁͳ͢΂ͯͷ஋Λهड़ TRM $0//&$550EBUBCBTF 64&3%#*/45 64*/(ECJOTU )045 1035 <44-> §Ҏલʹ઀ଓ͍ͯͨ͠৔߹͸ɺTRM $0//&$5ͰσΟεΫʹอଘ͞Ε͍ͯΔҎલͷ ઀ଓ৘ใΛ࢖༻͠·͢ɻ §஋͕଍Γͳ͍৔߹͸ɺҎલͷ઀ଓͷ৘ใ͕ར༻͞Ε·͢ɻ - TRM DPOOFDUUPTBNQMF - ҎલͷϢʔβʔ࢖༻ऀͷ஋͸ɺҎલͷ৘ใ͕࢖ΘΕ·͢ɻ §҉໧తͳ઀ଓ͸ɺ࠷ॳͷ TRM จΛ࣮ߦ͢Δͱ͖ʹߦΘΕ·͢ɻ 18

IBM Cloud 19 ઀ଓͷࣦഊ §઀ଓઌ͔Βͷ׬શͳ਍அ৘ใ͕໭͖ͬͯ·͢ɻ - ͦͷ৘ใ͕໾ʹཱ͔ͭͲ͏͔͸ɺ͋ͳ͕ͨ൑அ͍ͯͩ͘͠͞ 19

IBM Cloud 20 ਍அ৘ใ §ͭͷ૊ΈࠐΈม਺͔Βৗʹ਍அ৘ใΛಘΔ͜ͱ͕Ͱ͖·͢ɻ - TRMDPEF r࠷ޙʹੜ੒͞ΕͨTRMDPEF - TRMTUBUF r࠷ޙʹੜ੒͞ΕͨTRM TUBUF - TRMFSSPS r࠷ޙʹੜ੒͞Εͨϝοηʔδ §ϓϩάϥϛϯάɾϩδοΫΛ࢖༻͍ͯ͠Δ৔߹ʹศར 20

IBM Cloud 21 ઀ଓ੒ޭ 21 §઀ଓ͕੒ޭͨ͠৔߹΋ϝοηʔδΛ໭͠·͢ §TRMίϚϯυ͸ߦʹ͔͠ॻ͚ͳ͍͜ͱʹ஫ҙ͍ͯͩ͘͠͞ɻ - ߦҎ্ଓ͚Δ৔߹͸ɺόοΫεϥογϡ=Λ࢖༻͍ͯͩ͘͠͞ɻ - Ϣʔβʔ*%ͱύεϫʔυͷେจࣈɾখจࣈ͸۠ผ͞Ε·͢ɻ §ͲͷOPUFCPPLͰ΋DPOOFDUͰ઀ଓͰ͖ΔΑ͏ʹͳΓ·ͨ͠ɻ

IBM Cloud 22 ࣍͸Կ͕Ͱ͖Δ 22 §઀ଓ͕׬ྃͨ͠Βɺ42-Λ࣮ߦ͢Δ͜ͱ͕Ͱ͖·͢

IBM Cloud 23 ϑΥʔϚοτ͕͓͔͍͠ 23 §σϑΥϧτͰ͸1BOEBT%BUBGSBNFܗࣜͰग़ྗ͞Ε·͢ɻ §ग़ྗͷ࠷ॳͷߦͱ࠷ޙͷߦΛදࣔ͠·͢ɻ §΋ͬͱݟ͍ͨ৔߹͸ɺಛผͳϑϥά BMM Λ࢖༻͢Δ͔ɺ͍͔ͭ͘ͷઃఆΛมߋ͢Δ ͔ɺHSJEϑΥʔϚοτΛ࢖༻͢Δඞཁ͕͋Γ·͢ɻ

IBM Cloud 24 άϦουܗ͕ࣜΑΓඒ͘͠ 24 §TRMίϚϯυͷޙʹHSJEΦϓγϣϯΛ࢖༻͠·͢ɻ §͜ΕͰɺճ౴ηοτΛεΫϩʔϧͨ͠ΓɺྻͷαΠζΛมߋͨ͠Γɺ೚ҙͷྻͰιʔ τͨ͠Γ͢Δ͜ͱ͕Ͱ͖·͢ɻ §015*0/Λมߋ͢Δ͜ͱͰɺ͜ͷදࣔܗࣜΛσϑΥϧτʹ͢Δ͜ͱ͕Ͱ͖·͢ɻ ༁஫HJUIVC ্ͷެࣜ%PDLFS *NBHFͰ͸ಈ͖·͕ͨ͠ɺ 8BUTPO4UVEJP্ͷOPUFCPPL΍Colaboratory Ͱ͸ಈ͖·ͤΜͰͨ͠ɻ಺෦Ͱ࢖༻͍ͯ͠ΔRHSJE͸͏·͘ಈ͔ͳ͍؀ڥ͕Α͋͘ΔΑ͏Ͱ͢ɻΤϥʔʹͳΔ ৔߹͸͖͋ΒΊͯBΦϓγϣϯΛ࢖͍·͠ΐ͏

IBM Cloud 25 Φϓγϣϯ §ίϚϯυͷಈ࡞Λมߋ͢ΔΦϓγϣϯ͕͍͔ͭ͋͘Γ·͢ - ."93084 rճ౴ηοτͷҰ෦ΛӅ͢લʹ1BOEBTͷσΟεϓϨΠʹදࣔ͢Δߦ਺ - ."9(3*% rεΫϩʔϧՄೳͳσΟεϓϨΠͷ࠷େදࣔߦ਺ - 36/5*.& rεςʔτϝϯτ࣮ߦͷλΠϛϯάͰɺԿඵޙʹ࣮ߦ͢Δ͔ - %*41-": rग़ྗʹ1BOEBT·ͨ͸(SJEϑΥʔϚοτΛ࢖༻ - -*45 rݱࡏͷઃఆΛදࣔ §ίϚϯυ͸ɺҰ౓ʹෳ਺ͷΦϓγϣϯΛઃఆ͢Δ͜ͱ͕Ͱ͖·͢ɻ TRM PQUJPONBYHSJE EJTQMBZHSJE 25

IBM Cloud 26 42-จͱ42-ϒϩοΫ §͜Ε·Ͱ͸୯Ұͷ42-จͷΈΛ͖ࣔͯ͠·ͨ͠ §େن໛ͳ42-ͷϒϩοΫΛ࣮ߦ͍ͨ͠৔߹͸ʁ §TRMϑΥʔϚοτΛ࢖༻ͯ͠ɺ$FMM಺ͷ͢΂͕ͯ%C42-Ͱ͋Δ͜ͱΛϓϩά ϥϜʹ఻͑·͢ɻ 26

IBM Cloud 27 σϦϛλʔ §σϑΥϧτͰ͸42-จͷ۠੾Γʹηϛίϩϯ ͕࢖ΘΕ͍ͯ·͢ɻ §͜ΕΛΞοτʢ!ʣه߸ʹมߋ͢Δʹ͸EϑϥάΛ࢖༻͠·͢ɻ §ϒϩοΫͷ࣮ߦதʹΤϥʔ͕ൃੜͯ͠΋ແࢹ͢Δʹ͸ - ΤϥʔΛ཈੍͍ͨ͠৔߹͸ɺRVJFU·ͨ͸ RϑϥάΛ࢖༻͍ͯͩ͘͠͞ɻ - ग़ྗ͸ͦͷ··දࣔ͞Ε·͢ 27

IBM Cloud 28 4&-&$5ͷ݁ՌΛม਺ʹ୅ೖ §݁ՌηοτΛ1ZUIPOͷม਺ʹׂΓ౰ͯΔ͜ͱ͕Ͱ͖·͢ɻ §ม਺ʹ֨ೲ͞Εͨޙ͸ɺ1BOEBTͷߏจΛ࢖ͬͯදࣔͨ͠ΓɺεϥΠεͨ͠Γ͢Δ ͜ͱ͕Ͱ͖·͢ɻ - ΧϥϜͷ໊લ͸Θ͔͍ͬͯΔ͕ɺҐஔ͕Θ͔Βͳ͍৔߹ʹศརͰ͢ɻ 28

IBM Cloud 29 4&-&$5ͷ݁ՌΛม਺ʹ୅ೖ §·ͨɺl७ਮͳ ͷ഑ྻܗࣜͷσʔλΛಘΔ͜ͱ΋Ͱ͖·͢ɻ §഑ྻͷ࠷ॳͷߦʢߦ໨ʣ͕ΧϥϜ໊ɺ࢒Γͷߦ͕σʔλߦͰ͢ɻ 29

IBM Cloud 30 ύϥϝʔλͷ࢖༻ §εςʔτϝϯτʹ1ZUIPOม਺Λ༩͑Δʹ͸ɺҎԼͷϑΥʔϚοτΛ࢖༻͠·͢ɻ WBS@OBNF §*/ͷϦετʹ΋ରԠ͍ͯ͠·͢ 30

IBM Cloud 31 จࣈྻஔ׵ §42-ߏจͷ߲໨ʢྻͳͲʣͷ஋Λࢦఆ͢Δʹ͸ɺ\WBSOBNF^ܗࣜΛ࢖༻͠·͢ɻ §୯Ұߦͷ TRM ίϚϯυͰͷΈ࢖༻Ͱ͖·͢ɻ 31

IBM Cloud 32 */4&35 §*/4&35ͰจࣈྻΛѻ͏৔߹͸஫ҙ͕ඞཁ §యܕతͳ*/4&35XJUI7"-6&۟Λ࢖͏͜ͱ͕Ͱ͖·͢ɻ §จࣈྻ಺ͷҾ༻ූ b ͸ɺͭͷҾ༻ූͭͷҾ༻ූͱͳΓ·͢ɻ §·ͨ͸ɺม਺Λ࢖͍·͠ΐ͏ Ҿ༻ූ͸ඞཁ͋Γ·ͤΜ 32

IBM Cloud 33 +40/*/4&35 §+40/ΦϒδΣΫτʢࣙॻܕʣΛ࡞੒͠ɺ௚઀*/4&35 33

IBM Cloud 34 ؆୯ͳϓϩοςΟϯάػೳ §TRMίϚϯυͰ͸ɺ؆୯ͳνϟʔτ͕࡞੒Ͱ͖·͢ - QJFrԁάϥϑ - CBSr๮άϥϑ - MJOFrંΕઢάϥϑ TRM rCBS4&-&$5803,%&15 "7( 4"-"3: '30.&.1-0:&&= (3061#:803,%&15 34

IBM Cloud 35 ίϛοτɾείʔϓ §42-࣮ߦͷσϑΥϧτϞʔυ͸"650$0..*50/ - ͢΂ͯͷεςʔτϝϯτ͸ίϛοτ͞Ε·͢ §"650$0..*5ͷ0/0''͕ՄೳͰ͢ TRM "650$0..*50'' - "650$0..*5ͷঢ়ଶ͸ɺ઀ଓͷ༗ޮظؒதɺ͜ͷঢ়ଶΛҡ࣋͠·͢ §τϥϯβΫγϣϯͷ࠷ޙʹ$0..*5จΛ࢖͍·͢ - $0..*5803, rεςʔτϝϯτΛด͡ɺ͢΂ͯͷ࡞ۀΛίϛοτ͢Δ - $0..*5)0-% r͞ΒͳΔ࡞ۀͷͨΊʹεςʔτϝϯτΛΦʔϓϯʹ͓ͯ͘͠ - 30--#"$, r͜͜·Ͱͷ࡞ۀΛશͯϩʔϧόοΫ͢Δ 35

IBM Cloud 36 ετΞʔυɾϓϩγʔδϟ §ετΞυϓϩγʔδϟΛݺͼग़͢ʹ͸ɺҎԼͷߏจΛ࢖༻͠·͢ɻ SFTVMU Q@B Q@C Q@D ʜTRM rS$"--QSPD B C D ʜ §͜ͷߏจʢSϑϥά෇͖ʣͰ͸ɺ݁Ռͱύϥϝʔλ͕ฦ͞Ε·͢ - Q@B Q@C Q@D͸ɺϓϩγʔδϟʹΑͬͯఏڙ·ͨ͸ฦ͞ΕΔ஋Ͱ͢ɻ §݁ՌηοτͷΈ͕ඞཁͳ৔߹͸ɺεςʔτϝϯτΛ୯ಠͰ࢖༻͢Δ͔ɺม਺ʹ୅ೖ ͍ͯͩ͘͠͞ɻ YTRM $"--"%.*/@$.% %&4$3*#&5"#-&&.1-0:&& 36

IBM Cloud 37 1SFQBSFE4UBUFNFOUT §13&1"3&ίϚϯυͱ&9&$65&ίϚϯυ͸ɺ42-จΛԿ౓΋܁Γฦ࣮͠ߦ͢Δ৔߹ ʹศརͰ͢ɻ §ͨ·ʹ͔࣮͠ߦ͞Εͳ͍Α͏ͳ؆୯ͳλεΫʹ͸ɺ͜ΕΒͷεςʔτϝϯτΛ࢖༻͠ ͯ΋ϝϦοτ͸͋Γ·ͤΜɻ §13&1"3&&9&$65&ͷϝϦοτ͸ɺಉ͡಺༰ͷτϥϯβΫγϣϯΛେྔʹॲཧ͢Δ ৔߹ʹݦஶʹݱΕ·͢ɻ 37

IBM Cloud 38 1SFQBSFE4UBUFNFOUT §13&1"3&จ͸ɺҎԼͷ42-จʹͷΈ࢖༻Ͱ͖·͢ɻ - 4&-&$5 - */4&35 - 61%"5& - %&-&5& - .&3(& §εςʔτϝϯτΛ࡞੒͢Δʹ͸ɺҎԼͷߏจΛ࢖༻͠·͢ TUNU TRM 13&1"3&TRM §ม਺TUNU͸ɺεςʔτϝϯτΛ࣮ߦ͢Δࡍʹ࢖༻͞Ε·͢ɻ 38

IBM Cloud 39 Prepared Statements §ステートメントを準備したら、以下の構文で実行できます。: %sql EXECUTE :stmt USING v1,v2,v3,.... §EXECUTE ステートメントにステートメント変数 :stmt を与える必要があります。 §USING節の後に続く値は、定数またはPythonの変数名をカンマで区切ったものです。 - 変数名の前にコロン : を置くと、その変数は直ちにステートメントに代入されます。 %sql EXECUTE :stmt USING 3,'asdsa',24.5,:x,y - :xは直接パラメータリストに実体化され、変数yはステートメントに紐付けされ、その内容が動的 に転送されます。 39

IBM Cloud 40 §1ZUIPOͷม਺Ͱ͸ɺҎԼͷछྨͷσʔλΛࢦఆͰ͖·͢ - DIBS จࣈσʔλܕʢσϑΥϧτʣ - CJO CJOBSZ όΠφϦσʔλ - EFD EFDJNBM ਐ਺σʔλܕ - JOU JOUFHFS ਺஋σʔλܕ §͜ΕΒͷम০ࢠ͸ɺม਺໊ͷޙʹ!ه߸Λ࢖ͬͯ௥Ճ͞Ε·͢ɻ TRM &9&$65&TUNU 64*/(W!JOU W!CJOBSZ W!EFDJNBM §σϑΥϧτͰ͸ɺม਺Λจࣈྻͱͯ͠ѻ͍·͢ɻ 40 Prepared Statements

IBM Cloud 41 1SFQBSFE4UBUFNFOUTͷྫ 41

IBM Cloud 42 ͦͷଞͷεςʔτϝϯτɾΦϓγϣϯ §42-ͷ࣮ߦ࣌ʹ௥ՃΦϓγϣϯ͕ར༻Մೳ - E ୅ସεςʔτϝϯτσϦϛλ!ͷ࢖༻ - U UJNFεςʔτϝϯτͷ࣮ߦ࣌ؒ - R RVJFU ϝοηʔδΛදࣔ͠ͳ͍ - K ྻ໨ͷ+40/ϑΥʔϚοτԽ - KTPO݁ՌηοτΛ+40/Ϩίʔυͱͯ͠औಘ͢Δ - B BMM ͢΂ͯͷग़ྗΛදࣔ - QC CBS ݁Ռͷ๮άϥϑදࣔ - QQ QJF ݁Ռͷԁάϥϑදࣔ - QM MJOF ݁Ռͷઢάϥϑදࣔ - TBNQMFEBUB αϯϓϧͷ&.1-0:&&ςʔϒϧͱ%&1"35.&/5ςʔϒϧΛσʔλϕʔεʹϩʔυ - S BSSBZ ݁ՌΛม਺ʢߦͷϦετʣʹ໭͢ - F FDIP ϚΫϩͷஔ׵ͷΤίʔ - I IFMQ ϔϧϓ৘ใͷදࣔ - HSJE εΫϩʔϧՄೳͳάϦουͰ݁ՌΛදࣔ 42

IBM Cloud 43 ྫσʔλΛ+40/Ϩίʔυͱͯ͠औಘ 43

IBM Cloud 44 ϚΫϩ §TRMίϚϯυͰ͸ɺϚΫϩΛ࢖༻͢Δ͜ͱ΋Ͱ͖·͢ɻ - ϚΫϩ͸ɺ࣮ߦ͢Δ42-ίϚϯυʹςΩετΛ୅ೖ͢ΔͨΊʹ࢖༻͞Ε·͢ɻ - ϚΫϩͷஔ׵͸ɺ42-͕࣮ߦ͞ΕΔલʹߦΘΕ·͢ɻ - ͜ΕʹΑΓɺҰൠతʹ࢖༻͞ΕΔ42-ίϚϯυΛೖྗ͢Δ͜ͱͳ͘ɺͦΕΒΛؚΉϚΫϩΛ࡞੒͢Δ͜ͱ ͕Ͱ͖·͢ɻ - ϚΫϩ͸ύϥϝʔλʹΞΫηεͨ͠ΓɺݶΒΕͨϩδοΫػೳΛ͍࣋ͬͯ·͢ɻ TRM EFGJOFEFTDSJCF 5IF%&4$3*#&DPNNBOEDBOFJUIFSVTFUIFTZOUBY%&4$3*#&5"#-&OBNFPS%&4$3*#&5"#-&4&-&$5 WBSTZOUBY4ZOUBY%&4$3*#&<5"#-&OBNFc4&-&$5TUBUFNFOU> $IFDLUPTFFXIBUDPVOUPGWBSJBCMFTJT.VTUCFBUMFBTUJUFNT JG\BSHD^ FYJU\TZOUBY^ FOEJG $"--"%.*/@$.% \^ 44

IBM Cloud 45 ఆٛࡁΈϚΫϩ §%&4$3*#&<4&-&$5PS5"#-&> - ςʔϒϧ΍4&-&$5จͷ಺༰Λදࣔ͢Δ §-*455"#-&4<'03"--c'034$)&."OBNF> - ݱࡏͷεΩʔϚ·ͨ͸σʔλϕʔεͷςʔϒϧΛҰཡදࣔ 45

IBM Cloud 46 1BOEBT%BUBGSBNF UP%C §1BOEBT%BUBGSBNF͸%CͷςʔϒϧΛ࡞੒͠σʔλΛอଘ͢Δ͜ͱ͕Ͱ͖·͢ɻ §1BOEBT͸$47ϑΝΠϧΛΠϯϙʔτͰ͖·͢ɻ §64*/(۟Λ࢖ͬͯɺ1BOEBTͷ%BUBGSBNF͔Β%CͷςʔϒϧΛ࡞੒͠·͢ɻ §NZGMJHIUTͱ͍͏%CςʔϒϧΛ࡞੒͠ɺશͯͷσʔλΛςʔϒϧʹίϐʔ͠·͢ɻ 46

IBM Cloud 47 1BOEBT%BUBGSBNF UP%Cͷྫ §サンプル出力 47

IBM Cloud 48 Pandas Dataframe to Db2 シンタックス §TRM 64*/(EBUBGSBNF <$3&"5&c"11&/%c3&1-"$&>5"#-&UBCMF <8*5)%"5"c$0-6./4"4*4c,&&1<*/5c'-0"5>c-*.*5Y> §EBUBGSBNF ஋Λ֨ೲ͢ΔEBUBGSBNFͷ໊લɻ §$3&"5& ςʔϒϧͷ࡞੒ ςʔϒϧ͕ଘࡏ͢Δ৔߹͸ࣦഊɻ §3&1-"$& ςʔϒϧ͕ଘࡏ͠ͳ͍৔߹͸࡞੒͠ɺଘࡏ͢Δ৔߹͸ஔ׵ɻ §"11&/% طଘͷςʔϒϧʹσʔλΛ௥Ճɻςʔϒϧ͸࡞੒͠ͳ͍ɻ §UBCMF ςʔϒϧ໊ §8*5)%"5" EBUBGSBNFͷσʔλΛ%Cςʔϒϧʹίϐʔ͢Δ §$0-6./4"4*4 %CϑϨϯυϦʔͳ໊લͰ͸ͳ͘ɺ EBUBGSBNFͷΧϥϜ໊Λ࢖ ༻͢Δ ༁஫%CϑϨϯυϦʔͳ໊લ͸࣍ϖʔδࢀর §,&&1*/5 ,&&1'-0"5 %CͷϑϨϯυϦʔͳܕͷ୅ΘΓʹɺσʔλϑϨ ʔϜ͔Β */5͓Αͼ '-0"5ϑΥʔϚοτΛ࢖༻͢Δɻ §-*.*5Y ςʔϒϧʹίϐʔ͢Δߦ਺Λ Yʹ੍ݶ͢Δ 48

IBM Cloud 49 %CϑϨϯυϦʔ WT 1BOEBTͷྻ໊ §$0-6./4"4*4۟͸ɺݩͷEBUBGSBNF໊Λ࢖༻͠·͢ɻ 49

IBM Cloud 50 %C42-ฒྻॲཧ §%C.BHJDͷίϚϯυʹ͸ɺ42-Λෳ਺ϓϩηεͰ࣮ߦ͢Δػೳ͕͋Γ·͢ - σʔλൣғΛҰҙʹऔಘͰ͖ΔΩʔ͕͋Ε͹ɺ%CΤϯδϯͰ42-Λฒྻ࣮ߦ͢Δ͜ͱ͕ ՄೳͰ͢ɻ - େྔͷσʔλΛऔಘ͢Δඞཁ͕͋Δ৔߹ʹɺॲཧ଎౓Λ޲্ͤ͞Δ͜ͱ͕Ͱ͖Δ·͢ɻ - %CΫΤϦͷ࣮ߦΛߴ଎Խ͢ΔͷͰ͸ͳ͘ɺϫʔΫϩʔυΛෳ਺ͷεϨουʹ෼ࢄͤ͞ɺ %CͷύΠϓϥΠϯԽʹΑΓݕࡧ࣌ؒΛվળ͠·͢ɻ - %C%1'#-6ͷ୅ସʹ͸ͳΒͳ͍͕ɺ͜ΕΒͷγεςϜͱซ༻͢Δ͜ͱ͕Ͱ͖·͢ɻ §4ZOUBY TRM 64*/(SBOHF<4&-&$5c8*5)4&-&$5> XIFSFDPMVNOSBOHFBOE - SBOHFͷ஋͸ɺ42-ΫΤϦΛ࣮ߦ͢Δࡍʹ࢖༻͢Δ஋ΛؚΉ 1ZUIPOͷϦετ·ͨ͸഑ྻ Ͱ͢ɻ 50

IBM Cloud 51 %C42-ฒྻॲཧ §ฒྻεϨουΛ࢖༻͢ΔͨΊʹ͸ɺ࢖༻Ͱ͖ΔεϨουͷ࠷େ਺Λઃఆ͠·͢ɻ TRM 4&55)3&"%4<>·ͨ͸ TRM 015*0/45)3&"%4<> §·ͨ͸ Λࢦఆ͢Δͱɺ୯ҰεϨουͰΫΤϦΛ࣮ߦ͠·͢ɻ TRM 4&55)3&"%4 §ΑΓେ͖͍஋Λࢦఆ͢ΔͱɺYݸͷεϨου͕ੜ੒͞ΕɺͦΕͧΕͷεϨου͕ SBOHFύϥϝʔλͰࢦఆ͞Εͨൣғͷ͏ͪͷͭͷ42-จΛ࣮ߦ͠·͢ɻ §ྫ͑͹ɺ࣍ͷΑ͏ͳม਺͕ઃఆ͞Ε͍ͯΔͱ͠·͢ EFQBSUNFOUT<" " # #> §࣍ͷ42-͸ɺΫΤϦΛճʢ֤஋ʹճʣ࣮ߦ͠·͢ TRM 64*/(EFQBSUNFOUT4&-&$5%&15/0 $06/5 '30.%&154 8)&3&%&15/0EFQBSUNFOUT 51

IBM Cloud 52 -JWF-BCT §JCNDPNEFNPTʹΞΫηεͯ͠%CΛݕࡧ §৽͍͠-JWF -BC͸ؒ΋ͳ͘ར༻Մೳ - %C.BHJD$PNNBOETBOE1SPHSBNNJOHJO1ZUIPO - %C42-'FBUVSFTBOE'VODUJPOT - %C42-'FBUVSFTBOE'VODUJPOT - "O*OUSPEVDUJPOUP&YUFSOBM5BCMFT - 6TJOHUIF/FX+40/*40'VODUJPOTJO%C - 5IF%C%BUB.BOBHFNFOU$POTPMFBOE3&45GVM"1*T - %CPO$MPVE5VUPSJBM - 6TJOH7JTVBM4UVEJP$PEFBOEUIF(0-BOHVBHF §खॱ - *#.ͷϢʔβʔ*%ͰαΠϯΞοϓ͢Δ - ϥϘͷબ୒ - ϥϘͷ४උ͕Ͱ͖ͨͱ͍͏ϝʔϧΛ଴ͭʢʙ෼ʣɻ - ୳ݕ͠Α͏ 52

IBM Cloud 53 ௥ՃϦιʔε § %JHJUBM5FDIOJDBM&OHBHFNFOU4JUFʹΞΫηε - %JHJUBM5FDIOJDBM&OHBHFNFOUHSPVQ %5& ͸ɺϏσΦɺ੡඼πΞʔɺ੡඼ϥϘΛఏڙ͠ɺ͓ ٬༷͕ࣗ༝ʹٕज़Λࢼ͢͜ͱ͕Ͱ͖ΔΑ͏ʹ͍ͯ͠·͢ɻ - ੡඼ϥϘ͸ɺ͓٬༷ͷͨΊʹ༻ҙ͞Εͨ׬શʹػೳ͢ΔαʔόʔͰ͢ɻ - ͜ΕΒͷαʔόʔʹ͸ɺجຊ੡඼ʢ%Cʣͱࣗश༻ͷαϯϓϧؚ͕·Ε͍ͯ·͢ɻ - IUUQTXXXJCNDPNEFNPT § ৽͍͠%C+40/#PPL - JCNCJ[ECKTPO § (JU)VC%C4BNQMFT - %CͷαϯϓϧϓϩάϥϜ͸(JU)VCʹଟ਺ެ։͞Ε͍ͯ·͢ɻ - IUUQTHJUIVCDPN*#.ECTBNQMFT

IBM Cloud 54 Db2 and Jupyter Notebooks — George Baklarz Db2 Digital Technical Engagement ೔ຊޠ༁ ੢ށ ژࢠ ,ZPLP/JTIJUP ೔ຊΞΠɾϏʔɾΤϜגࣜձࣾ ςΫϊϩδʔࣄۀ෦ %BUB"*5FDIOJDBM4BMFT