性能調(diào)優(yōu)-課件第1周

DB2設(shè)計與性能優(yōu) 講師

DATAGURU專業(yè)數(shù)據(jù)分析社【】和幻燈片為煉數(shù)成金網(wǎng)絡(luò)課程的教程以外范圍散播，違者將可能被法律和經(jīng)濟課程詳情煉數(shù)成金培訓(xùn) DB2設(shè)計與性能優(yōu) 講

DATAGURU專業(yè)數(shù)據(jù)分析社DB2設(shè)計與性能優(yōu) 講師

DATAGURU專業(yè)數(shù)據(jù)分析社 本周內(nèi) DB2產(chǎn)Editions&DB2BufferAutomaticDB2設(shè)計與性能優(yōu) 講

BreakfreewithDATAGURU專業(yè)數(shù)據(jù)分析社 DB2版本介

Express&

DatabaseEnterpriseDeveloperAllowsdeveloperstodevelopandperformqualityassurance.TheeditionisaproductbundlethatincludesmanyDB2features.DB2設(shè)計與性能優(yōu) 講 DB2和Oracle版本對 DB2Express-nocostdownloadanddeploy-optionallicenseWindows,Linux,Solaris(Beta:MacOS2GBmemory,2NoDatabasesizeDB2ExpressWindows,4GBmemory,4IncludesDB2WorkgroupServerWindows,Linux,16GBmemory,4DB2EnterpriseServerWindows,Linux,Solaris,IBMAIX?,HP-LinuxonsystemNolimitonmemoryand

OracleExpressNocostandWindows,Linux,1GBmemory,1Upto4GBuserOracleStandardOneWindows,Linux,2DoesnotincludeOracleStandardWindows,Linux,4OracleEnterpriseWindows,Linux,NolimitonmemoryandDB2設(shè)計與性能優(yōu) 講師

DATAGURU專業(yè)數(shù)據(jù)分析社DB2引擎包含主引擎處理器的引擎分派單元(EDU)以線程的形式存在并執(zhí)行各種任 EDU作為應(yīng)用程序 ，負責(zé)執(zhí)行各種任務(wù)，包括處理數(shù)據(jù)庫應(yīng)用程序請DB2保持多 存在來保證當有服務(wù)請求時能夠及時響兩種主要 :協(xié) ,DB2設(shè)計與性能優(yōu) 講

DATAGURU專業(yè)數(shù)據(jù)分析社獨立的DB2環(huán)DB2設(shè)計與性能優(yōu) 講師

DATAGURU專業(yè)數(shù)據(jù)分析社DB2一些有關(guān)實例的指以下多數(shù)指令可以在控制中心中進指令指令描例啟動默認停止當前db2stop-創(chuàng)建實db2icrt–udb2fenc1刪除實db2idrop–f列出所有升級DB2后遷移一個實db2imigr–udb2fenc1安裝補丁后升級實db2iupdt–udb2fenc1DB2設(shè)計與性能優(yōu) 講

DATAGURU專業(yè)數(shù)據(jù)分析社查看數(shù)據(jù)庫管理器配db2getdbmcfgshow更改數(shù)據(jù)庫管理器配db2updatedbmcfgusinghealth_mon查看數(shù)據(jù)db2getdbcfgfortestdbdb2connecttotestdbdb2getdbcfgshow更改一個數(shù)據(jù)庫設(shè)db2updatedbcfgusinglogprimaryDB2設(shè)計與性能優(yōu) 講

DATAGURU專業(yè)數(shù)據(jù)分析社DB2通過DIAGLEVEL參數(shù)來控制日志的數(shù)存放于 該日志包含DB2所有錯誤和警告日志信日志存放于多個文件中(最多5該日志包含性能統(tǒng)計數(shù)據(jù)和DB2的優(yōu)化結(jié)DB2設(shè)計與性能優(yōu) 講

DATAGURU專業(yè)數(shù)據(jù)分析社作為實例用戶來 中添 節(jié)db2db2catalogtcpipnodedb2noderemoteSERVER1server hostname/IP port你也可以db2db2catalogadmintcpipnodedb2dasremote完成以上操作后，可以開始正常使 數(shù)據(jù)庫db2db2catalogdbSAMPLEatnodedb2nodeauthenticationdb2db2connecttoSAMPLEuserdb2inst1usingDB2設(shè)計與性能優(yōu) 講

DATAGURU專業(yè)數(shù)據(jù)分析社 使用以下命令來顯示本 中的結(jié)點，DAS和數(shù)據(jù)庫信息databaseadminnodenodeDB2設(shè)計與性能優(yōu) 講

DATAGURU專業(yè)數(shù)據(jù)分析社

DB2設(shè)計與性能優(yōu) 講

DATAGURU專業(yè)數(shù)據(jù)分析社 系統(tǒng)管理空數(shù)據(jù)存放在文件系統(tǒng) 除非需要適用于小型，個人數(shù)據(jù)庫以 空間變化頻繁的數(shù)據(jù) 要求較CREATECREATETABLESPACEtbsp1MANAGEDBYUSING('d:\acc_tbsp','e:\acc_tbsp',DB2設(shè)計與性能優(yōu) 講

DATAGURU專業(yè)數(shù)據(jù)分析社 數(shù)據(jù)庫管理空 CREATETABLESPACEtbsp2PAGESIZE8KCREATETABLESPACEtbsp2PAGESIZE8KMANAGEDBYUSING(FILE'/storage/dms1'10M)AUTORESIZECREATETABLESPACEtbsp1PAGESIZE8KCREATETABLESPACEtbsp1PAGESIZE8KMANAGEDBYUSING(FILEFILEDB2設(shè)計與性能優(yōu) 講

DATAGURU專業(yè)數(shù)據(jù)分析社 自 表空數(shù)據(jù)庫允許使用自 數(shù)據(jù)庫管理器能夠自動分配容器(物 地址自動調(diào)整表空間的大對普通/大型表空間來使用數(shù)據(jù)庫對用戶或系統(tǒng)臨時表空間使用系統(tǒng)db2db2createdatabaseMYDBon/ASPATHdbpathonCONNECTTOCREATETABLESPACEtbsp1MANAGEDBYAUTOMATICDB2設(shè)計與性能優(yōu) 講

DATAGURU專業(yè)數(shù)據(jù)分析社 DB2設(shè)計與性能優(yōu) 講

DATAGURU專業(yè)數(shù)據(jù)分析社 每個表空間 有一個同樣頁面大小的緩沖 OLTP應(yīng)用程序設(shè)置的表空間需要一個較大的緩沖如果創(chuàng)建表空間時，沒有特別指定緩沖池，那么數(shù)據(jù)庫會使用默認的IBMDEFAULTBP緩沖bp4kPAGESIZEtbsp1PAGESIZE4KDB2設(shè)計與性能優(yōu) 講

DATAGURU專業(yè)數(shù)據(jù)分析社 工具和產(chǎn)品對 IBMDataIBMOptimDatabaseDB2ControlDB2PerformanceSQLIBMDataSQLandProcedureOracleNETNodecataloging/connecting, Queryperformance QueryvisualexplanationHealthMonitorDB2EventMonitor DB2WorkloadWorkloadOracleDataHighAvailabilityandDisasterDB2設(shè)計與性能優(yōu) 講

DATAGURU專業(yè)數(shù)據(jù)分析社

OracleSGA(shared

AnOracleSIDcanaccessonlyonedatabaseataCommon“Instance”Memorystructureandthebackgroundprocessesusedtoaccessdatafroma“Database”physicalfilesusedtostoreDATAGURU專業(yè)數(shù)據(jù)分析社DB2設(shè)計與性能優(yōu) 講 DB2和Oracle術(shù)語對

AlertDataDatadictionaryCatalogDDataLargeUtilityPfile/spfileDB/DBMAutomaticclientDynamicviews(V_$AdministrationviewsDB2設(shè)計與性能優(yōu) 講

DATAGURU專業(yè)數(shù)據(jù)分析社 DB2安裝與需 Installationdb2setupResponseMinimum1Ghz1GhzTempDB2設(shè)計與性能優(yōu) 講

DATAGURU專業(yè)數(shù)據(jù)分析社 結(jié)

OracleProductdirectoryDatabase

sqlnet.ora,etc.DB2設(shè)計與性能優(yōu) 講

DATAGURU專業(yè)數(shù)據(jù)分析社 結(jié) Linux/UNIX(Automatic/

DB2InstancedirectoryInstancesoftwaredirectorieslinkedtomainDB2

StoredProcedureDirectory–ExternalandInternalDB2diagnosticlogsandotherlogsInitializationprofileforUnixsInstanceconfigurationparametersbinarySystemDatabasedirectory–CatalogsarekepthereDatabasesarecreatedunderthisnodeLocalDatabaseDatabaseID(directoryforSAMPLEdatabase)AutomaticStoragedirectory(forSAMPLEdatabase)T0000000,T0000001,T0000002–System,Temporary,Usertablespaces B2installlocationMainDB2softwareDATAGURU專業(yè)數(shù)據(jù)分析社DB2設(shè)計與性能優(yōu)

參數(shù)配置比 DB29.7hasnearly210PFILEsareneededfordatabaseduringinstance/databasecreationOracleneedseitherPFILESortemplatestocreateaDB2AUTOCONFIGUREfeaturesuggestsdatabaseparametervaluesatdatabasecreationPFILEtoSPFILEconversionis Noconversionisnecessary.TheDBDBMhavethatfunctionalityby DB2設(shè)計與性能優(yōu) 講

DATAGURU專業(yè)數(shù)據(jù)分析社變量和環(huán)境變量比 DB2registry Managedbyusingdb2setortheConfiguration

CommunicationsmanagerSQLsearchespath

db2set-

db2set

CurrentinstanceDefaultinstanceDB2directory

db2set-all

AssignavaluetoavariableResetsavariabletoit'sdefaultDisplaysallvariablesOracleenvironment

[i][i]

CurrentworkingPathtoinitializationparameterfile(init.ora)HomedirectoryinwhichOracleisinstalledOracleDBinstanceonthehostcomputerTop-levelOracledirectory

[g][g]DB2設(shè)計與性能優(yōu) 講

DATAGURU專業(yè)數(shù)

[e]EnvironmentVariables–OS[g]GlobalRegistryVariables– tire[i]InstanceRegistryVariables–effectscurrent 數(shù)據(jù)庫創(chuàng) SetenvironmentCreatepasswordSTARTUPCREATE

SetregistryDB2INST,CREATECreatedataCreateAddtheSID

DB2usesexternalfilenecessaryDB2automaticallyenableSelfTunningManagerenabledbydefault

U

DB2uses“autoconfigure”Nofiles(likeOraclepfile's)areneededDuringthedatabasecreation,whenthecompatibilityvectorisenabled,DB2automaticallybuildsthedictionaryviewsand DB2設(shè)計與性能優(yōu) 講 實例和數(shù)據(jù)庫管 STARTUP

Startingan

Startinganinstanceand

DB2ACTIVATEALTERDATABASEALTERDATABASE

Startinga

DB2ACTIVATESHUTDOWN

an

SHUTDOWN

aninstance

DB2STOPALTERSYSTEM SESSION DB2設(shè)計與性能優(yōu) 講

KillingaDATAGURU專業(yè)數(shù)據(jù)分析社

FORCEAPPLICATION[ALL| 管理命 OtherStartthedefaultdb2stop-Createandb2icrt–udb2fenc1Dropandb2idrop–fListallMigrateaninstanceafterupgradingdb2imigr–udb2fenc1db2iupdt–udb2fenc1ViewDatabaseManagerdb2getdbmcfgshowChangeaDatabaseManagerdb2updatedbmcfgusinghealth_mon ViewDatabase

db2getdbcfgfordb2connecttodb2getdbcfgshowChangeaDB DATAGUudDB2設(shè)計與性能優(yōu) 講 DB2Sample數(shù)據(jù) TocreatethesampledatabasepopulatedwithbothrelationaldataandXMLVerifythedatabasecreationbysimplyconnectingandqueryingthedb2sampldb2sampl–sqldb2connecttoForremotedb2db2catalogdatabasesampleasatnodedb2connecttoDB2設(shè)計與性能優(yōu) 講

DATAGURU專業(yè)數(shù)據(jù)分析社日志: TroubleshootinganddiagnosticLocatedin$DB2INSTANCE_HOME/sqllib/db2dump/byGenerallogwhichcontainsallDB2errorsandUse“db2diag”tooltofilterandformadb2diaglog2

Singlediagnosticlogfile(db2diag.log)

logfilessingleactivelogfilethatgrows y.DEFAULTbehaviorConfiguration

setoffilesthattheactivelogfileclosesandopensdb2diag.N+1.logwhenitreachesthelimitsizeDiagsize:sizeofthelogfilesforrotatinglogfilesform;0forsinglelogfileDiagpath:LocationofthelogDiaglevel:TypesoferrorstobewrittentoDATAGURU專業(yè)數(shù)據(jù)分析社DB2設(shè)計與性能優(yōu) 講 Oracle字典vsDB2系統(tǒng)編 Oracledictionaryviewswillbecreatedbysettingthe registryvariableOracleDataSYS.xx$-BaseSYS.GV_$-AdminviewsSYS.V_$-AdminviewsUSER_$-UsersALL_$-ExpandedusersviewsDBA_$-DatabaseAdminviewsSELECT<column>FROM

DB2SystemSYSIBM-BasetablesSYSIBMADM–AdminviewsSYSCAT–CatalogbasetablesSYSSTAT–UpdateableviewsSELECT<column>FROMWHEREOWNER=userANDSELECT<column>FROMsyscat.tablesWHEREOWNER=userANDDB2設(shè)計與性能優(yōu) 講

DATAGURU專模型比

Table

Logical

Table

DB2設(shè)計與性能優(yōu) 講

DATAGURU專業(yè)數(shù)

模型比較–表空 Table–

PermanentTableSmallfile(severalsmallTemporaryTableLocallyManagedUndoTable

SystemManagedDB2設(shè)計與性能優(yōu) 講

DATAGURU專業(yè)數(shù)據(jù)分析社 DB2表空間類 Catalogtablespaces(1CatalogtableswithMustDB2設(shè)計與性能優(yōu) 講

Systemtemporarytablespace(1forexample:join,sortsUserTableSpaces(1ormoreDefaultusertableCanbetabl

Usertemporarytable(1ormoreStoretempdatafromtablescreatedwithDECLARETEMPORARYTABLE DB2表空間管 SystemManagedOraclehasNODatastoredinfilesrepresentingdataSpaceisallocatedonAccessto ontrolledusingstandardI/OfunctionsoftheIdealfor aldatabasesanddatabasesthatgrow/shrinkLowerperformance,astheOShandlestheCREATECREATETABLESPACEbyeoracleMANAGEDBYUSING('d:\acc_tbsp','e:\acc_tbsp',AllOracletablespacesworkslikeDB2'sDatastoredinfilesoronraw–Storagespacepre-allocatedinfilesystem,typicallycontiguousphysicallyIdealforperformance-sensitiveapplicationsCREATETABLESPACEbyeoracleMANAGEDCREATETABLESPACEbyeoracleMANAGEDBYUSING(FILE'/db2/file1'1M,FILE'/db2/file2'1AUTORESIZEYESINCREASESIZE2MMAXSIZE100DB2設(shè)計與性能優(yōu) 講

DATAGURU專業(yè)數(shù)據(jù)分析社 DB2自 表空 AutomaticStorageTableDBMcreatesandextendscontainersasneededupthelimitsimposedbythestoragepathsassociatedwiththedatabaseAutomaticallyhandlesresizingtableCreatesaDMStablespaceforregular/largetableCreatesaSMStablespaceforuserorsystemtemporarytableNewDB&arehandledbyautomaticstoragebyDEFAULTdb2createdatabaseMYDBon/ASPATHdbpathon/DBPATHDB2設(shè)計與性能優(yōu) 講

DATAGURU專業(yè)數(shù)據(jù)分析社AnIllustrativeLet’swalkthroughthefollowingsetdb2createdatabaseMYDBon/ASPATHdbpathondb2createtablespaceTS1managedbysystemusing('/MYDIR1','/MYDIR2')extentsize4DB2設(shè)計與性能優(yōu) 講

DATAGURU專業(yè)數(shù)據(jù)分析社AnIllustrativeLet’swalkthroughthefollowingset ;db2createdatabaseMYDBon/ASPATHdbpathondb2createtablespaceTS1managedbysystemusing('/MYDIR1','/MYDIR2')extentsize4DB2設(shè)計與性能優(yōu) 講

DATAGURU專業(yè)數(shù)據(jù)分析社WhatGetsCreatedOnDisksetDB2INSTANCE=MYINST;db2createdatabaseMYDBon/ASPATHdbpathon/DBPATH/MYINST/NODE0000/SQL00001SQLOGDIR/event

//bufferpoolinfo//tablespaceinfo//automaticstoragepathinformation//databaseconfiguration//recoveryhistoryfile//logcontrolfile//usedwithlog//tablespaceloghistory//logdirectory//logfilesgo//defaultpathforeventmonitor/ASPATH/MYINST/NODE0000/MYDBT0000000/C0000000.CATT0000001/C0000000.TMP/T0000002/C0000000.USR

//initialcatalogtablespace//initialsystemtemptablespace//initialusertablespaceDB2設(shè)計與性能優(yōu) 講

DATAGURU專業(yè)數(shù)據(jù)分析社AnIllustrativeLet’swalkthroughthefollowingsetDB2INSTANCE=MYINST;db2createdatabaseMYDBon/ASPATHdbpathon/DBPATHdb2createtablespaceTS1managedbysystemusing('/MYDIR1','/MYDIR2')extentsizeDB2設(shè)計與性能優(yōu) 講

DATAGURU專業(yè)數(shù)據(jù)分析社WhatGetsCreatedOnDiskdb2createtablespaceTS1managedbyusing('/MYDIR1','/MYDIR2')extentsizeFirstFirstExtentofDataPagesforT1SecondExtentofDataPagesforT1DB2設(shè)計與性能優(yōu) 講

DATAGURU專業(yè)數(shù)據(jù)分析社 AreaofmainmemoryusedtocachetableandindexEachdatabasemusthaveatleastonebufferBufferpoolscanbecreated,droppedorSYSCAT.BUFFERPOOLScatalogviewaccessesinformationforthebufferpoolsdefinedintheEverytablespaceassociatesaspecificbufferpoolofthesamepagesizeMatchbufferpoolsizewithpurposeoftabletoincreasehitratioCREATECREATEBUFFERPOOLbp4kPAGESIZECREATETABLESPACEtbsp1PAGESIZE4KBUFFERPOOLDB2設(shè)計與性能優(yōu) 講

DATAGURU專業(yè)數(shù)據(jù)分析社 DB2ConfigurationAdvisorusesexpertheuristicstoperformanceandtobalancememoryAutomaticenvironmentcharacteristicUserdescriptionofbasicoperationalCombinedwithmathematicalmodelofeachconfigurationparameter,basedonexpertheuristicsTousetheConfigurationAdvisor,specifytheAUTOCONFIGUREcommandforanexistingdatabase,TheAUTOCONFIGUREisrunbydefaultwhenyouissuetheCREATEDATABASEcommand.Inside

ofthe

n

hasonlyafewdatabasetemplatesandwonthelpyoutosettheperformanceparametersanonce,inonetoolDBCA

chesettingsall1–createaparameterandpasswordfiles.2-Usetheparameterfiletobuildaninstance. 3-IssuetheCREATEDB2設(shè)計與性能優(yōu) 講

4RunSQLscriptstogeneratethedatadictionary.5RunSQLscriptstogeneratetheEnterpriseManagerDatabase Toolthatsuggestsmodificationstothedatabase'sphysicaldesigntoimproveAllowstodisplay,edit,orsavethenewdatabaseobjectcreation Invokedwiththedb2advisImplementationof mendationsbyIndexesonthebaseIndexesontheMaterializedQueryConvertingregulartablesintoMulti-DimensionalClustering(MDC) Re-partitioning(DPF)existingtableswithanewsetofpartitioningkeyand/orinanewtablespace.DB2設(shè)計與性能優(yōu) 講

DATAGURU專業(yè)數(shù)據(jù)分析社 CreateadatabasewithautomaticstorageCREATEDATABASE<dbname>AUTOMATICYESON/data/storagePath1,

DB2willcreatethecontainersinsidethesepathsCreateatablespacewithautomaticstorageCREATETABLESPACETS2MANAGEDBYAUTOMATICSTORAGEINITIALSIZE500KINCREASESIZE100K MAXSIZE100M

resizeofDMStablespacesDB2設(shè)計與性能優(yōu) 講

DATAGURU專業(yè)數(shù)據(jù)分析社 DatabasemaintenanceisessentialforensuringoptimizedperformanceandTherefore,settingupautomaticmaintenanceremovesburdenfromDBAtohavetomanuallydothesetasksAUTOMAINTparameteristhemasteron/offIndividualChildparameterscanbesettoON/OFFandthesettingsarepersistedinthedatabaseconfigurationfile.Enabled/disabledthroughdatabaseconfigurationparameterAutomaticAutomaticdatabasebackupAutomaticAutomaticstatisticsprofilingAutomaticreorganizationDATAGURU專業(yè)數(shù)據(jù)分析社DB2設(shè)計與性能優(yōu) 講 SelfTuningMemoryManager(STMM)simplifiesthetaskofmemoryOptimizestheperformanceofyourdatabasebyautomaticallyadjustingthevaluesMemoryconfigurationparametersininstanceMemoryconfigurationparametersindatabaseSizeofbufferHands-offonlinememoryRequiresnoDBASensestheunderlyingworkloadandtunesthememorybasedonCanadaptquicklytoworkloadshiftsthatrequirememoryDB2設(shè)計與性能優(yōu) 講

DATAGURU專業(yè)數(shù)據(jù)分析社 IfupgradingfromolderversionofDB2orpreviouslyturnedoffTurnonthemasterupdatedbcfgfor<db_name>usingSELF_TUNING_MEMSeteachparameterthatyouwishtotunetoupdatedbcfgfor<db_name>using<param>ForbufferpoolstobetunedbyAllnewlycreatedbufferpoolsdefaulttoFormigrateddatabase'salterbufferpool<bp_name>sizeToquerywhetherornotSTMMistuningyourConnecttotheGetDatabaseConfigurationwithgetdbcfgfor<db_name>showCheckthevalueforIfsettoON(ACTIVE)thensystemisbeingIfsettoOFF,orON(INACTIVE)thensystemisnotbeingDB2設(shè)計與性能優(yōu) 講

DATAGURU專業(yè)數(shù)據(jù)分析社STMMworksintwomodesdependingontheconfigurationoftheDATABASE_MEMORYparameter–TotalamountofmemoryusedbyaparticularDB2databasecangroworshrinkovertimememoryto,theOSas

COMPUTEDor–Memorytuningstilloccursbuttotalmemoryusedbydatabaseisconstant–ForoneheaptogrowanotherheapmustshrinkDB2設(shè)計與性能優(yōu) 講

DATAGURU專業(yè)數(shù)據(jù)分析社 DATABASE_MEMORY=1)Scenarioinvolvesachangeinworkloadthatnowrequiresmorememoryfor

MemoryusedotherTotalSystemTotalSystemDB2databasememoryDB2databasememoryOtherDBmemoryDB2設(shè)計與性能優(yōu) 講

DATAGURU專業(yè)數(shù)據(jù)分析社 DATABASE_MEMORY=ScenarioinvolvesachangeinworkloadthatnowrequiresmorememoryforDB2requestsandgetsmorememoryfromtheOS,thereforeshrinkingthefreememoryinthesystem

MemoryusedotherinsystemTotalSystemDB2TotalSystemDB2databasememoryOtherDBmemoryDB2設(shè)計與性能優(yōu) 講

DATAGURU專業(yè)數(shù)據(jù)分析社 DATABASE_MEMORY=ScenarioinvolvesachangeinworkloadthatnowrequiresmorememoryforTotalTotalSystemDB2usesnewlyacquiredmemoryinsortheap

MemoryusedotherinsystemDatabasesortDB2databasememoryOtherDB2databasememoryDB2設(shè)計與性能優(yōu) 講

DATAGURU專業(yè)數(shù)據(jù)分析社 DATABASE_MEMORY=COMPUTEDor1)Scenarioinvolvesachangeinworkloadthatnowrequiresmorememoryfor

MemoryusedotherTotalSystemTotalSystemDB2databasememoryDB2databasememoryDB2設(shè)計與性能優(yōu) 講

DATAGURU專業(yè)數(shù)據(jù)分析社

OtherDBmemory DATABASE_MEMORY=COMPUTEDorScenarioinvolvesachangeinworkloadthatnowrequiresmorememoryforDB2databaseissetatfixedmemoryusage,andthuscannottakememoryfromOS.Thereforeidentifiesanothermemoryconsumerinthedatabasethatdoesnotneeditsmemoryanymore(e.g.locklist)

MemoryusedotherinsystemTotalSystemDB2TotalSystemDB2databasememoryDatabaselockDB2設(shè)計與性能優(yōu) 講

DATAGURU專業(yè)數(shù)據(jù)分析社

OtherDBmemo