AIX小机上建立DB2数据库

1总体规划1.1主机环境两台主机，型号均为IBMP570，主机名分别为**p570a和**p570b（**为地市名简称），安装操作系统AIX5L（64位内核），版本V5.3，维护级别升级到5300-04。1.2数据库产品数据库采用DB2ENTERPRISESERVEREDITIONv8.2,补丁打到fixpak12,补丁下载地址：/software/data/db2/udb/support/downloadv8_aix5.html#r12主机内置磁盘2*146.8G，用于安装操作系统及各类软件。磁盘阵列为IBMDS4800一台，14*146.8G，其中6块硬盘做RAID10，7块硬盘做RAID5，1块硬盘做全局热备盘，每组RAID划成一个LUN。正常运行状态下，RAID10的LUN挂在主机**p570a上，在对应的物理卷上创建卷组TDdatavg；RAID5的LUN挂在主机**p570b上，在对应的物理卷上创建卷组CRMdatavg。1.4实例、用户及数据库每台主机上各创建一个64位实例db2inst1，实例用户为db2inst1，所属组db2grp1，用户目录/home/db2inst1，隔离用户为db2fenc1，所属组db2ifenc1，用户目录/home/db2fadm1。在挂有卷组TDdatavg的主机实例db2inst1下创建数据库**data，用来存放分销系统数据；在挂有卷组CRMdatavg的主机实例db2inst1下创建数据库**crm，用来存放CRM系统数据。2主机相关环境设置2.1安装64位JDK把DB2软件光盘包中的DeveloperKit,JavaTechnologyEdition(64-bit)forAIX5L放入光驱中，按如下步骤安装：mount/cdromsmittyinstall回车进入操作菜单(蓝色为选择或输入内容，回车进入下一层)InstallandUpdateSoftwareListSoftwareandRelatedInformationSoftwareMaintenanceandUtilitiesSoftwareServiceManagementInstallSoftwareUpdateInstalledSoftwaretoLatestLevel(UpdateAll)InstallSoftwareBundleUpdateSoftwarebyFix(APAR)InstallandUpdatefromALLAvailableSoftwareINPUTdevice/directoryforsoftware[/cdrom/aix]INPUTdevice/directoryforsoftware /cdrom/aixSOFTWAREtoinstall [_all_latest]PREVIEWonly?(installoperationwillNOToccur)noCOMMITsoftwareupdates? yesSAVEreplacedfiles? noAUTOMATICALLYinstallrequisitesoftware? yesyesEXTENDfilesystemsifspaceneeded?yesTOC\o"1-5"\h\zOVERWRITEsameornewerversions? noVERIFYinstallandcheckfilesizes? noIncludecorrespondingLANGUAGEfilesets? yesDETAILEDoutput? noProcessmultiplevolumes? yesACCEPTnewlicenseagreements? yesPreviewnewLICENSEagreements? no回车即开始安装，显示OK表明安装成功2.2创建相关用户和组2.2.1实例用户和组使用命令：mkgroupid=301db2grp1mkuserid=301pgrp=db2grp1db2inst12.2.2隔离用户和组使用命令：mkgroupid=302db2fadm1mkuserid=302pgrp=db2fadm1db2fenc1注：以后做ha时注意各主机用户和组的id保持一致。2.3创建磁盘阵列卷组2.3.1创建TDdatavg#smittyvg回车进入操作菜单（蓝色为选择或输入内容，回车进入下一层）ListAllVolumeGroupsAddaVolumeGroupSetCharacteristicsofaVolumeGroupListContentsofaVolumeGroupAddanOriginalVolumeGroupAddaBigVolumeGroupAddaScalableVolumeGroupVOLUMEGROUPname [TDdatavg]TOC\o"1-5"\h\zPhysicalpartitionSIZEinmegabytes 256*PHYSICALVOLUMEnames [hdisk2]Forcethecreationofavolumegroup? noActivatevolumegroupAUTOMATICALLY yesatsystemrestart?VolumeGroupMAJORNUMBER []CreateVGConcurrentCapable? no回车执行操作，显示OK表明创建完成。2.3.2仓U建CRMdatavg步骤同创建TDdatavg,其中VOLUMEGROUPname为CRMdatavg。3DB2安装3.1DB2安装3.1.1解压缩把DB2V8.2光盘放入光驱，可看到目录下有一个ese.dbcs.tar.gz文件，解压此文件，进入存放解压文件的目录，执行命令：gzip-c-dese.dbcs.tar.gz|tar-xvf-解压完成即生成DB2安装目录ese.dbcs。3.1.2安装安装DB2有两种方式：1）db2install进入目录ese.dbcs，执行命令./db2install,出现提示后，输入DB2.ESE（区分大小写），执行安装。此种方式不创建das（DB2管理服务器）和实例，需要在安装完成后手工创建das和实例。2）db2setup进入目录ese.dbcs，执行命令：#./db2setup，进入图形安装界面安装完成，点击Finish，结束安装3.2DB2升级下载fixpak12补丁，解压生成升级目录，进入目录执行命令installFixPak-y，即可完成所有包的升级工作。升级完成后需手工升级das，root用户执行/usr/opt/db2_08_01/instance/dasupdt。3.3创建64位实例root用户执行/usr/opt/db2_08_01/instance/db2isetup，启动创建实例程序，首先欢迎界面安装完成，点击Finish，结束安装实例创建完成，切换到db2inst1用户，可执行DB2命令。执行命令db2level，显示如下信息：DB21085IInstancendb2inst1"uses"64"bitsandDB2coderelease"SQL08024"withlevelidentifier"03050106".Informationaltokensare"DB2v12","s060120","U805924",andFixPak"12".Productisinstalledat"/usr/opt/db2_08_01".可显示实例名称、位数、版本等基本信息。3.4更新实例环境参数用db2inst1用户登陆系统，执行以下命令：db2setdb2comm=tcpipdb2setdb2codepage=1386db2setdb2territory=CN3.5安装数据库许可证使用db2inst1用户登陆系统运行如下步骤：1、 使用命令(db2licm-l)可以查看当前数据库的许可情况；2、 使用命令(db2licm-a<filename>)可以为数据库添加数据库许可，许可证文件一般位于数据库产品介质的/ese.dbcs/db2/license/目录中，如：/ese.dbcs/db2/license/db2ese.lic；3、 使用命令(db2licm-a<filename>)添加数据库许可后一般为只添加了一个CPU的许可，可以使用命令(db2licm-nDB2ESE<n>)添加更多的CPU许可，如在本系统中使用(db2licm-nDB2ESE4)添加4个CPU的许可。3.6创建数据库数据库要创建在磁盘阵列上，在主机**p570a的TDdatavg上创建文件系统/tdhome，作为分销数据库的存放目录，在主机**p570b的CRMdatavg上创建文件系统/crmhome，作为CRM数据库的存放目录。创建分销数据库，db2inst1用户登录**p570a，执行命令：db2createdatabase**dataon/tdhomeusingcodesetGBKterritotyCN创建CRM数据库，db2inst1用户登录**p570b，执行命令：db2createdatabase**crmon/crmhomeusingcodesetGBKterritotyCN为了WebSphere数据源连接使用，还需要把本地数据库编目成远程数据库。编目分销数据库，db2inst1用户登录**p570a，执行命令：db2catalogtcpipnode**dataremoteipserver50000db2catalogdb**dataas**dataatnode**data编目CRM数据库，db2inst1用户登录**p570b，执行命令：db2catalogtcpipnode**crmremoteipserver50000db2catalogdb**crmas**crmaatnode**crm4表空间设计4.1表空间规划基本原则1、 系统表按系统默认存放于各系统表空间，采用系统管理方式。2、 应用新建表全部存放于新建的表空间。3、 新建表空间容器采用裸设备，以提高数据读写能力。4、 索引和数据存放于不同的表空间。5、 大型对象数据存放于单独的表空间。6、 静态表和动态表存放于不同的表空间。7、 大数据量、访问频繁的表可存放于单独表空间。8、 根据表行的长度和数据量确定表空间的页宽。9、 数据交换量比较大的表空间配置单独的缓冲池。10、 为保证表的重建及数据迁移的准确性，各地市保留原表空间名称、类型和管理方式等，空间适当增大。4.2表空间规划4.2.1导出原数据库信息用db2look导出原数据库完整信息，根据导出的表空间信息，规划新建表空间，注意保留原表空间名称。db2look命令可参考如下格式：db2look-ddbname-e-oFname-l-f-IuserID-wpassword-wrapperWrapperName

首理方式群容量五宽描述心一_，二1常规数据库首理/dev/rtdc1M（符容器4⑶4R存放订单、配送单等数据交换较频警的表/dev/rtdc2/de^'rtdcS/■dcv/rtdc4常规数据库管理/dev/rtddl20G（每容器5G〕4K存放基础数据号只他茹布豹表/deu/rtdd2/dcv/rtdd3/dev/rtdd4」空一出数据库管理,'cev/rtd?l2G（每容器1G）4R存放大型对象数据表/dev/rtdb2JjCMDDLEW数据库管理/de班rtdml2G（每容器1①4K存放中间数据/dev/rtdmS:XnTC'EX常规数据库管理/dcv/rtdilJUG（符容器5⑶4K存赦宗引表/dev/rtdi2/dev/rtdiS/dev/rtdi4□C_TMP用户临时系统管理文件系统自动分配4K存放临时表WE妇PEEl用户临时寿登言正自动分配4K存放临时表系统临时系鸵育玮文科卜系藐自动分配和：存KW表CRM数据库名称类型管理方式容器容量页宽描述CKb4DSPACE常规数据库管理/dev/rcrmdl32G（每客器8G）4K存放销售数据表/dev/rcrmd2/dev/rcrmd3/dev/rcrmd4CWBSPACE常规数据库管理/dev/rcrmbl4G〔每容器NG）4K存放基础数据表/dev/rcrmb2CBMSPACE常规数据库管理/dev/rcrtml24G（每客器6G）4K存放索引/dev/rcrmi2/dev/rcrtni3/dev/rcrmi4CWTSPACE用户临时系统管理文件系统自动分配4K存放临时TEMPSPACE2系统临时系统管理文件系统自动分配32K存放临时4.3创建表空间4.3.1创建裸设备

创建表空间之前需要先创建表空间使用的容器，为了提高性能，表空间容器统一使用裸设备，上表中列出的容器即为系统中的各裸设备。AIX中裸设备通过创建逻辑卷获得，裸设备名称即对应逻辑卷名称前加字母”r”。以rtddl为例，创建裸设备步骤如下：#smittylvListAllLogicalVolumesbyVolumeGroupAddaLogicalVolumeSetCharacteristicofaLogicalVolumeShowCharacteristicsofaLogicalVolumeRemoveaLogicalVolumeCopyaLogicalVolumeVOLUMEGROUPname [TDdatavg]LogicalvolumeNAME [tdd1]*VOLUMEGROUPname TDdatavg*NumberofLOGICALPARTITIONS [10]PHYSICALVOLUMEnames [hdisk2]LogicalvolumeTYPE [jfs2]. （其余选项按默认即可回车执行，显示OK创建成功其余裸设备根据此步骤建立，各裸设备的参数如下表所示

卷组物理卷PPSIZE逻辑卷类型裸设备容量LVsTDdatavghdtslc2512Mtdcljfs2rtdcl4G8tdc2jfs2rtd-c24G8tdc3jfs2rtdcS4GStdc4jfs2rtdc44G8tddljfs2rtddl5G10tdd2jfs2rtdd25G10tdd3jfs2rtdd35G10tdd4jfs2rtdd45G10tdbljfs2rtdbl1G2tdb2jfs2rtdb21G2tdiljfs2rtdil5G10tdi2jfs2rtdi25G10tdi3jfs2rtdi35G10tdi4jfs2rtdi45G10tdmljfs2rtdml1G2tdm2jfs2rtdin21G2CEMdatav^hdisk31024Mcimdljfs2rcrmd-18G3crmd2jfs2rcrmd28G8cimdSj£s2rcrmd-S8GScimd4jfs2rcnnd-48G8crmbljfs2rcrmbl2G2cimb2jfs2rcrmb22G2crmiljfs2rcrtnil6G6crmi2jfs2rcrmi26G6crmi3jfs2rcrmi36G6crmi4jfs2rcmn46G6注：表中的LVs是根据PPSIZE计算的，如果PPSIZE不是如表中设置，需要根据实际情况计算。4.3.2修改逻辑卷和裸设备属性为了可进行数据库操作，逻辑卷和裸设备所属用户和组均应为db2inst1、db2grp1。进入目录/dev，执行如下命令修改裸设备属性（以rtddl为例）：chowndb2inst1:db2grp1tddlchowndb2inst1:db2grp1rtdd1其余逻辑卷和裸设备属性均按此命令修改。4.3.3创建表空间

创建表空间需要指定对应的缓冲池，因此创建表空间前需要创建相应的缓冲池（创建缓冲池见第5章节）。创建表空间使用db2inst1用户，根据表空间类型和管理方式不同，建表语句如下：常规类型、数据库管理（以JX_CO为例）CREATEREGULARTABLESPACEJX_COPAGESIZE4KMANAGEDBYDATABASEUSING（DEVICE'/dev/rtdc1'1048576,DEVICE'/dev/rtdc2'1048576,DEVICE'/dev/rtdc3'1048576,DEVICE'/dev/rtdc4'1048576）EXTENTSIZE16OVERHEAD10.67PREFETCHSIZE16TRANSFERRATE0.04BUFFERPOOLCODROPPEDTABLERECOVERYON;大对象类型、数据库管理（以JX_BLOB为例）CREATELARGETABLESPACEJX_BLOBPAGESIZE4KMANAGEDBYDATABASEUSING（DEVICE'/dev/rtdb1'262144,DEVICE'/dev/rtdb2'262144）EXTENTSIZE16OVERHEAD10.67PREFETCHSIZE16TRANSFERRATE0.04BUFFERPOOLBLOB;用户临时类型、系统管理（以JX_TMP为例）CREATEUSERTEMPORARYTABLESPACEJX_TMPPAGESIZE4KMANAGEDBYSYSTEMUSING（7tdhome/db2inst1/NODE0000/SQL00001/SQLT0003.0'）EXTENTSIZE16OVERHEAD12.67PREFETCHSIZE16TRANSFERRATE0.18BUFFERPOOLIBMDEFAULTBP;系统临时类型、系统管理（以STPAGE32为例）CREATESYSTEMTEMPORARYTABLESPACESTPAGE32PAGESIZE32KMANAGEDBYSYSTEMUSING（7tdhome/db2inst1/NODE0000/SQL00001/SQLT0004.0'）EXTENTSIZE16OVERHEAD12.67PREFETCHSIZE16TRANSFERRATE0.18BUFFERPOOLIBMDEFAULTBP;其余表空间按类型区分，使用以上语句创建，注意表空间的名称、页宽、容器名称、容器大小、对应缓冲池名称等。表空间也可通过DB2的控制中心创建。4.4创建表执行导出的原数据库的建表语句，由于表空间名称没有改变，不需要更改表和表空间的对应。5缓冲池规划5.1缓冲池规划基本原则1、 每个缓冲池对应单独的表空间。2、 根据表空间所需页宽确定缓冲池的页宽。3、 根据数据量和访问量确定缓冲池大小。5.2缓冲池规划（以吉安为例）数据库缓肿池页宽页数对应表空间jadataco4KwuouuBATA4K10300JX_D直TAMIDDLE4K25300JX_MDDLINI-EX4K100000jy_INDEXBLOB4K1000n：_BLOBIDBP3232K1000SIPAGE32jacrrnCBMD4K50300CRMDSPACECKM14K10U000CR3.TT4K50300CKE.JTSPACECBJWIBP3232K1250TEMP母ACE2注：缓冲池的容量的设置要充分参考原数据库的设置，还要在实际使用过程中对缓冲池不断的监控调整，以达到最好性能。5.3创建缓冲池缓冲池要在表空间之前创建，以创建CO为例，使用db2inst1用户登陆系统，执行命令：CREATEBUFFERPOOLCOIMMEDIATESIZE75000PAGESIZE4K;其余缓冲池均使用此命令创建，注意修改缓冲池的名称、大小、页宽等。缓冲池也可通过DB2的控制中心创建。6DB2配置参数6.1数据库管理器配置参数数据库管理器配置参数在实例级影响系统资源，不受该实例下某一数据库的影响。查看参数列表：db2getdbmcfg修改某一参数：db2updatedbmcfgusing<parameter-name><value>dbm配置参数列表DatabaseManagerConfigurationNodetype=EnterpriseServerEditionwithlocalandremoteclientsDatabasemanagerconfigurationreleaselevel =0x0a00CPUspeed(millisec/instruction) (CPUSPEED)=4.959615e-07Communicationsbandwidth(MB/sec)(COMM_BANDWIDTH)=1.000000e+02Maxnumberofconcurrentlyactivedatabases(NUMDB)=8DataLinkssupport (DATALINKS)=NOFederatedDatabaseSystemSupport (FEDERATED)=YESTransactionprocessormonitorname (TP_MON_NAME)=Defaultcharge-backaccount(DFT_ACCOUNT_STR)=JavaDevelopmentKitinstallationpathDiagnosticerrorcapturelevelNotifyLevelDiagnosticdatadirectorypath/home/db2inst1/sqllib/db2dumpDefaultdatabasemonitorswitchesBufferpoolLockSortStatementTableTimestampUnitofworkMonitorhealthofinstanceanddatabasesSYSADMgroupnameDB2IADM1SYSCTRLgroupnameSYSMAINTgroupnameSYSMONgroupnameClientUserid-PasswordPluginClientKerberosPluginGroupPluginGSSPluginforLocalAuthorization(JDK_PATH)=/usr/java14_64(DIAGLEVEL)=3(NOTIFYLEVEL)=3(DIAGPATH)=(DFT_MON_BUFPOOL)=OFF(DFT_MON_LOCK)=OFF(DFT_MON_SORT)=OFF(DFT_MON_STMT)=OFF(DFT_MON_TABLE)=OFF(DFT_MON_TIMESTAMP)=ON(DFT_MON_UOW)=OFF(HEALTH_MON)=ON(SYSADM_GROUP)=(SYSCTRL_GROUP)=(SYSMAINT_GROUP)=(SYSMON_GROUP)=(CLNT_PW_PLUGIN)=(CLNT_KRB_PLUGIN)=(GROUP_PLUGIN)=(LOCAL_GSSPLUGIN)=ServerPluginModeUNFENCED(SRV_PLUGIN_MODE)=ServerListofGSSPlugins(SRVCON_GSSPLUGIN_LIST)=ServerUserid-PasswordPluginServerConnectionAuthenticationNOT_SPECIFIEDDatabasemanagerauthenticationCatalogingallowedwithoutauthorityTrustallclientsTrustedclientauthenticationBypassfederatedauthenticationDefaultdatabasepathDatabasemonitorheapsize(4KB)JavaVirtualMachineheapsize(4KB)Auditbuffersize(4KB)Sizeofinstancesharedmemory(4KB)AUTOMATICBackupbufferdefaultsize(4KB)Restorebufferdefaultsize(4KB)Sortheapthreshold(4KB)Directorycachesupport(SRVCON_PW_PLUGIN)=(SRVCON_AUTH)=(AUTHENTICATION)=SERVER(CATALOG_NOAUTH)=NO(TRUST_ALLCLNTS)=YES(TRUST_CLNTAUTH)=CLIENT(FED_NOAUTH)=NO(DFTDBPATH)=/home/db2inst1(MON_HEAP_SZ)=90(JAVA_HEAP_SZ)=2048(AUDIT_BUF_SZ)=0(INSTANCE_MEMORY)=(BACKBUFSZ)=1024(RESTBUFSZ)=1024(SHEAPTHRES)=32768(DIR_CACHE)=YESApplicationsupportlayerheapsize(4KB)(ASLHEAPSZ)=60MaxrequesterI/Oblocksize(bytes) (RQRIOBLK)=32767Queryheapsize(4KB) (QUERY_HEAP_SZ)=4000

Workloadimpactbythrottledutilities(UTIL_IMPACT_LIM)=10Priorityofagents(AGENTPRI)=SYSTEMPriorityofagentsMaxnumberofexistingagents(MAXAGENTS)=400AgentpoolsizeAgentpoolsize(NUM_POOLAGENTS)=200(calculated)Initialnumberofagentsinpool(NUM_INITAGENTS)=0Maxnumberofcoordinatingagents (MAX_COORDAGENTS)=(MAXAGENTS-NUM_INITAGENTS)Maxno.ofconcurrentcoordinatingagents(MAXCAGENTS)=MAX_COORDAGENTSMaxnumberofclientconnections(MAX_CONNECTIONS)=MAXCOORDAGENTSKeepfencedprocess(KEEPFENCED)=YESNumberofpooledfencedprocesses(FENCED_POOL)=MAX_COORDAGENTSInitialnumberoffencedprocesses(NUM_INITFENCED)=0Indexre-creationtimeandredoindexbuild(INDEXREC)=RESTARTTransactionmanagerdatabasename(TM_DATABASE)=1ST_CONNTransactionmanagerdatabasename(TM_DATABASE)=1ST_CONNSPMnameSPMlogsizeSPMnameSPMlogsizeTransactionresyncinterval(sec)(RESYNC_INTERVAL)=180(SPM_NAME)=czycp550(SPM_LOG_FILE_SZ)=256SPMresyncagentlimit(SPM_MAX_RESYNC)=20SPMlogpathSPMlogpath(SPM_LOG_PATH)=(SVCENAME)=TCP/IPServicenamedb2cdb2inst1(SVCENAME)=DiscoverymodeDiscoverymode(DISCOVER)=SEARCHDiscoverserverinstance(DISCOVER_INST)=ENABLEMaximumquerydegreeofparallelism(MAX_QUERYDEGREE)=ANYEnableintra-partitionparallelism(INTRA_PARALLEL)=NONmunicationbuffers(4KB)(FCM_NUM_BUFFERS)=4096(FCM_NUM_RQB)=NumberofFCMrequestblocks(FCM_NUM_RQB)=AUTOMATICNumberofFCMconnectionentries(FCM_NUM_CONNECT)=AUTOMATIC(FCM_NUM_ANCHORS)=NumberofFCMmessageanchors(FCM_NUM_ANCHORS)=AUTOMATIC(CONN_ELAPSE)=10Nodeconnectionelapsetime(sec)(CONN_ELAPSE)=10Maxnumberofnodeconnectionretries(MAX_CONNRETRIES)=5Maxtimedifferencebetweennodes(min)(MAX_TIME_DIFF)=60db2start/db2stoptimeout(min)(START_STOP_TIME)=106.2数据库管理参数数据库配置参数针对单个数据库，其参数指定分配给该数据库的资源量以及其他事项。查看参数列表：db2getdbcfgfordbname修改某一参数：

db2updatedbcfgfordbnameusing<parameter-name><value>TD数据库配置参数列表DatabaseConfigurationforDatabaseczv3td=0x0a00=0x0a00Databaseconfigurationreleaselevel=0x0a00=0x0a00DatabasereleaselevelDatabaseterritoryDatabasecodepageDatabasecodesetDatabasecountry/regioncodeDatabasecollatingsequenceAlternatecollatingsequenceDatabasepagesizeDynamicSQLQuerymanagementDISABLEDiscoverysupportforthisdatabaseDefaultqueryoptimizationclassDegreeofparallelismContinueuponarithmeticexceptionsDefaultrefreshage=CN=1386=GBK=86=UNIQUE(ALT_COLLATE)==4096(DYN_QUERY_MGMT)=(DISCOVER_DB)=ENABLE(DFT_QUERYOPT)=5(DFT_DEGREE)=1(DFT_SQLMATHWARN)=NO(DFT_REFRESH_AGE)=0Defaultmaintainedtabletypesforopt(DFT_MTTB_TYPES)=SYSTEMNumberoffrequentvaluesretained(NUM_FREQVALUES)=10Numberofquantilesretained (NUM_QUANTILES)=20=NOBackuppending=NOTOC\o"1-5"\h\zDatabaseisconsistent =NORollforwardpending =NORestorepending =NOMultifileallocationenabled =YESLogretainforrecoverystatus =NOUserexitforloggingstatus =NODataLinksTokenExpiryInterval(sec)(DL_EXPINT)=60DataLinksWriteTokenInitExpiryIntvl(DL_WT_IEXPINT)=60DataLinksNumberofCopiesDataLinksTimeafterDrop(days)DataLinksTokeninUppercaseDataLinksTokenAlgorithmDatabaseheap(4KB)Sizeofdatabasesharedmemory(4KB)AUTOMATICCatalogcachesize(4KB)(MAXAPPLS*4)Logbuffersize(4KB)Utilitiesheapsize(4KB)Bufferpoolsize(pages)Extendedstoragesegmentssize(4KB)NumberofextendedstoragesegmentsMaxstorageforlocklist(4KB)(DL_NUM_COPIES)=1(DL_TIME_DROP)=1(DL_UPPER)=NO(DL_TOKEN)=MAC0(DBHEAP)=2400(DATABASE_MEMORY)=(CATALOGCACHE_SZ)=(LOGBUFSZ)=512(UTIL_HEAP_SZ)=5000(BUFFPAGE)=1000(ESTORE_SEG_SZ)=16000(NUM_ESTORE_SEGS)=0(LOCKLIST)=20000Maxsizeofappl.groupmemset(4KB)(APPGROUP_MEM_SZ)=30000Percentofmemforappl.groupheap(GROUPHEAP_RATIO)=70Maxappl.controlheapsize(4KB)(APP_CTL_HEAP_SZ)=128Sortheapthresforsharedsorts(4KB)(SHEAPTHRES_SHR)=(SHEAPTHRES)Sortlistheap(4KB)SQLstatementheap(4KB)Defaultapplicationheap(4KB)Packagecachesize(4KB)(MAXAPPLS*8)Statisticsheapsize(4KB)Intervalforcheckingdeadlock(ms)Percent.oflocklistsperapplicationLocktimeout(sec)ChangedpagesthresholdNumberofasynchronouspagecleanersNumberofI/OserversIndexsortflagSequentialdetectflagDefaultprefetchsize(pages)TrackmodifiedpagesDefaultnumberofcontainersDefaulttablespaceextentsize(pages)MaxnumberofactiveapplicationsAveragenumberofactiveapplications(SORTHEAP)=2048(STMTHEAP)=8192(APPLHEAPSZ)=2048(PCKCACHESZ)=(STAT_HEAP_SZ)=4384(DLCHKTIME)=10000(MAXLOCKS)=40(LOCKTIMEOUT)=30(CHNGPGS_THRESH)=40(NUM_IOCLEANERS)=8(NUM_IOSERVERS)=12(INDEXSORT)=YES(SEQDETECT)=YES(DFT_PREFETCH_SZ)=AUTOMATIC(TRACKMOD)=OFF=1(DFT_EXTENT_SZ)=32(MAXAPPLS)=AUTOMATIC(AVG_APPLS)=1MaxDBfilesopenperapplication(MAXFILOP)=64Logfilesize(4KB)(LOGFILSIZ)=10000Numberofprimarylogfiles(LOGPRIMARY)=12Numberofsecondarylogfiles(LOGSECOND)=8Changedpathtologfiles(NEWLOGPATH)=Pathtologfiles=/home/db2inst1/db2inst1/NODE0000/SQL00002/SQLOGDIR/Overflowlogpath(OVERFLOWLOGPATH)=Mirrorlogpath(MIRRORLOGPATH)=Firstactivelogfile=Blocklogondiskfull(BLK_LOG_DSK_FUL)=NOPercentofmaxactivelogspacebytransaction(MAX_LOG)=0Num.ofactivelogfilesfor1activeUOW(NUM_LOG_SPAN)=0Groupcommitcount(MINCOMMIT)=1Percentlogfilereclaimedbeforesoftchckpt(SOFTMAX)=100Logretainforrecoveryenabled(LOGRETAIN)=OFFUserexitforloggingenabled(USEREXIT)=OFFHADRdatabaserole=STANDARDHADRlocalhostname(HADR_LOCAL_HOST)=HADRlocalservicename(HADR_LOCAL_SVC)=HADRremotehostname(HADR_REMOTE_HOST)=HADRremoteservicename(HADR_REMOTE_SVC)=HADRinstancenameofremoteserver(HADR_REMOTE_INST)=HADRtimeoutvalue(HADR_TIMEOUT)=120HADRlogwritesynchronizationmode(HADR_SYNCMODE)=NEARSYNCAutorestartenabledAutorestartenabledIndexre-creationtimeandredoindexbuildFirstlogarchivemethodOptionsforlogarchmethlSecondlogarchivemethodOptionsforlogarchmeth2FailoverlogarchivepathNumberoflogarchiveretriesonerrorLogarchiveretryDelay(secs)Vendoroptions(RESTART)LogpagesduringindexbuildDefaultnumberofloadrecsessionsNumberofdatabasebackupstoretainRecoveryhistoryretention(days)TSMmanagementclassTSMnodenameTSMownerTSMpasswordAutomaticmaintenanceAutomaticdatabasebackupAutomatictablemaintenanceAutomaticrunstatsAutomaticstatisticsprofilingAutomaticprofileupdatesAutomaticreorganization(LOGARCHMETH1)=OFF(LOGARCHOPT1)=(LOGARCHMETH2)=OFF(LOGARCHOPT2)=(FAILARCHPATH)=(NUMARCHRETRY)=5(ARCHRETRYDELAY)=20(VENDOROPT)=(AUTORESTART)=ON(INDEXREC)=SYSTEM(LOGINDEXBUILD)=OFF(DFT_LOADREC_SES)=1(NUM_DB_BACKUPS)=12(REC_HIS_RETENTN)=366(TSM_MGMTCLASS)=(TSM_NODENAME)=(TSM_OWNER)=(TSM_PASSWORD)=(AUTO_MAINT)=OFF(AUTO_DB_BACKUP)=OFF(AUTO_TBL_MAINT)=OFF(AUTO_RUNSTATS)=OFF(AUTO_STATS_PROF)=OFF(AUTO_PROF_UPD)=OFF(AUTO_REORG)=OFFHD数据库参数列表DatabaseConfigurationforDatabaseczv3hd=0x0a00=0x0a00Databaseconfigurationreleaselevel=0x0a00=0x0a00DatabasereleaselevelDatabaseterritoryDatabasecodepageDatabasecodesetDatabasecountry/regioncodeDatabasecollatingsequenceAlternatecollatingsequenceDatabasepagesizeDynamicSQLQuerymanagementDISABLEDiscoverysupportforthisdatabaseDefaultqueryoptimizationclassDegreeofparallelismContinueuponarithmeticexceptionsDefaultrefreshage=CN=1386=GBK=86=UNIQUE(ALT_COLLATE)==4096(DYN_QUERY_MGMT)=(DISCOVER_DB)=ENABLE(DFT_QUERYOPT)=5(DFT_DEGREE)=1(DFT_SQLMATHWARN)=NO(DFT_REFRESH_AGE)=0Defaultmaintainedtabletypesforopt(DFT_MTTB_TYPES)=SYSTEMNumberoffrequentvaluesretained(NUM_FREQVALUES)=10Numberofquantilesretained (NUM_QUANTILES)=20Backuppending=NODatabaseisconsistent=NOTOC\o"1-5"\h\zRollforwardpending =NORestorepending =NOMultifileallocationenabled =YESLogretainforrecoverystatus =NOUserexitforloggingstatus =NODataLinksTokenExpiryInterval(sec)(DL_EXPINT)=60DataLinksWriteTokenInitExpiryIntvl(DL_WT_IEXPINT)=60DataLinksNumberofCopiesDataLinksTimeafterDrop(days)DataLinksTokeninUppercaseDataLinksTokenAlgorithmDatabaseheap(4KB)Sizeofdatabasesharedmemory(4KB)AUTOMATICCatalogcachesize(4KB)(MAXAPPLS*4)Logbuffersize(4KB)Utilitiesheapsize(4KB)Bufferpoolsize(pages)Extendedstoragesegmentssize(4KB)NumberofextendedstoragesegmentsMaxstorageforlocklist(4KB)(DL_NUM_COPIES)=1(DL_TIME_DROP)=1(DL_UPPER)=NO(DL_TOKEN)=MAC0(DBHEAP)=2400(DATABASE_MEMORY)=(CATALOGCACHE_SZ)=(LOGBUFSZ)=512(UTIL_HEAP_SZ)=5000(BUFFPAGE)=1000(ESTORE_SEG_SZ)=16000(NUM_ESTORE_SEGS)=0(LOCKLIST)=20000Maxsizeofappl.groupmemset(4KB)(APPGROUP_MEM_SZ)=30000Percentofmemforappl.groupheap(GROUPHEAP_RATIO)=70Maxappl.controlheapsize(4KB)(APP_CTL_HEAP_SZ)=128Sortheapthresforsharedsorts(4KB)(SHEAPTHRES_SHR)=(SHEAPTHRES)Sortlistheap(4KB)SQLstatementheap(4KB)Sortlistheap(4KB)SQLstatementheap(4KB)Defaultapplicationheap(4KB)Packagecachesize(4KB)(MAXAPPLS*8)Statisticsheapsize(4KB)Intervalforcheckingdeadlock(ms)Percent.oflocklistsperapplicationLocktimeout(sec)ChangedpagesthresholdNumberofasynchronouspagecleanersNumberofI/OserversIndexsortflagSequentialdetectflagDefaultprefetchsize(pages)TrackmodifiedpagesDefaultnumberofcontainersDefaulttablespaceextentsize(pages)MaxnumberofactiveapplicationsAveragenumberofactiveapplications(SORTHEAP)=2048(STMTHEAP)=8192(APPLHEAPSZ)=2048(PCKCACHESZ)=(STAT_HEAP_SZ)=4384(DLCHKTIME)=10000(MAXLOCKS)=40(LOCKTIMEOUT)=60(CHNGPGS_THRESH)=40(NUM_IOCLEANERS)=8(NUM_IOSERVERS)=12(INDEXSORT)=YES(SEQDETECT)=YES(DFT_P