近期客戶上線了一套DB2 數(shù)據(jù)庫,讓我們提供下數(shù)據(jù)庫的壓測(cè)方案,接到要求后開始找合適的壓測(cè)工具,因?yàn)镈B2數(shù)據(jù)庫的特殊性,關(guān)于DB2數(shù)據(jù)庫的壓測(cè)工具并不多,上網(wǎng)看了下,對(duì)于數(shù)據(jù)庫的壓測(cè)工具有以下幾種工具:
通過對(duì)比后,決定使用HammerDB,為最終工具
下面就介紹下使用HammerDB對(duì)DB2進(jìn)行壓測(cè)的使用方法
下載完成后進(jìn)行安裝,一直下一步就可以了
安裝完成后打開界面如下
選擇安裝新產(chǎn)品
然后一直下一步,到完成安裝。
▼▼▼
[db2inst1@ ~]$ db2 create database tpcc pagesize 8 k
DB20000I The CREATE DATABASE command completed successfully.
[db2inst1@ ~]$ db2 update db cfg for tpcc using PCKCACHESZ 1631072
DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.
[db2inst1@ ~]$ db2 update db cfg for tpcc using LOGFILSIZ 1048572
DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.
[db2inst1@ ~]$ db2 update db cfg for tpcc using LOGPRIMARY 25
DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.
[db2inst1@ ~]$ db2 update db cfg for tpcc using LOGSECOND 5
DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.
[db2inst1@ ~]$ db2 update db cfg for tpcc using LOGBUFSZ 17264
DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.
[db2inst1@ ~]$ db2 update db cfg for tpcc using MINCOMMIT 1
DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.
[db2inst1@ ~]$ db2 update db cfg for tpcc using NUM_IOSERVERS AUTOMATIC
DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.
[db2inst1@ ~]$ db2 update db cfg for tpcc using DFT_PREFETCH_SZ AUTOMATIC
DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.
[db2inst1@ ~]$ db2 update db cfg for tpcc using LOCKTIMEOUT 15
DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.
[db2inst1@ ~]$ db2 update db cfg for tpcc using SOFTMAX 2500
DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.
[db2inst1@ ~]$
[db2inst1@ ~]$ db2 connect to tpcc
Database Connection Information
Database server = DB2/LINUXX8664 10.5.5
SQL authorization ID = DB2INST1
Local database alias = TPCC
[db2inst1@ ~]$ db2 create bufferpool C_BP immediate size 2500000 pagesize 8k
DB20000I The SQL command completed successfully.
[db2inst1@ ~]$ db2 create large tablespace C_TS pagesize 8k managed by automatic storage bufferpool C_BP
DB20000I The SQL command completed successfully.
[db2inst1@ ~]$ db2 create bufferpool D_BP immediate size 500000 pagesize 4k
DB20000I The SQL command completed successfully.
[db2inst1@ ~]$ db2 create large tablespace D_TS pagesize 4k managed by automatic storage bufferpool D_BP
DB20000I The SQL command completed successfully.
[db2inst1@ ~]$ db2 create bufferpool W_BP immediate size 500000 pagesize 4k
DB20000I The SQL command completed successfully.
[db2inst1@ ~]$ db2 create large tablespace W_TS pagesize 4k managed by automatic storage bufferpool W_BP
DB20000I The SQL command completed successfully.
[db2inst1@ ~]$ db2 create bufferpool I_BP immediate size 500000 pagesize 4k
DB20000I The SQL command completed successfully.
[db2inst1@ ~]$ db2 create large tablespace I_TS pagesize 4k managed by automatic storage bufferpool I_BP
DB20000I The SQL command completed successfully.
[db2inst1@ ~]$ db2 create bufferpool H_BP immediate size 2000000 pagesize 8k
DB20000I The SQL command completed successfully.
[db2inst1@ ~]$ db2 create large tablespace H_TS pagesize 8k managed by automatic storage bufferpool H_BP
DB20000I The SQL command completed successfully.
[db2inst1@ ~]$ db2 create bufferpool S_BP immediate size 2000000 pagesize 8k
DB20000I The SQL command completed successfully.
[db2inst1@ ~]$ db2 create large tablespace S_TS pagesize 8k managed by automatic storage bufferpool S_BP
DB20000I The SQL command completed successfully.
[db2inst1@ ~]$ db2 create bufferpool NO_BP immediate size 3000000 pagesize 8k
DB20000I The SQL command completed successfully.
[db2inst1@ ~]$ db2 create large tablespace NO_TS pagesize 8k managed by automatic storage bufferpool NO_BP
DB20000I The SQL command completed successfully.
[db2inst1@ ~]$ db2 create bufferpool OR_BP immediate size 3000000 pagesize 8k
DB20000I The SQL command completed successfully.
[db2inst1@ ~]$ db2 create large tablespace OR_TS pagesize 8k managed by automatic storage bufferpool OR_BP
DB20000I The SQL command completed successfully.
[db2inst1@ ~]$ db2 create bufferpool OL_BP immediate size 5000000 pagesize 8k
DB20000I The SQL command completed successfully.
[db2inst1@ ~]$ db2 create large tablespace OL_TS pagesize 8k managed by automatic storage bufferpool OL_BP
DB20000I The SQL command completed successfully.
▼▼▼
D:Program FilesIBMSQLLIBBIN>db2 catalog tcpip node tpcc remote 192.168.100.101 server 50000
DB20000I CATALOG TCPIP NODE 命令成功完成。
DB21056W 直到刷新目錄高速緩存之后,目錄更改才生效。
D:Program FilesIBMSQLLIBBIN> db2 catalog db tpcc as tpcc at node tpcc
DB20000I CATALOG DATABASE 命令成功完成。
DB21056W 直到刷新目錄高速緩存之后,目錄更改才生效。
D:Program FilesIBMSQLLIBBIN>db2 terminate
DB20000I TERMINATE 命令成功完成。
D:Program FilesIBMSQLLIBBIN>db2 connect to tpcc user db2inst1 using db2inst1
數(shù)據(jù)庫連接信息
數(shù)據(jù)庫服務(wù)器 = DB2/LINUXX8664 10.5.11
SQL 授權(quán)標(biāo)識(shí) = DB2INST1
本地?cái)?shù)據(jù)庫別名 = TPCC
然后點(diǎn)擊Build 創(chuàng)建測(cè)試用的用戶
點(diǎn)擊Load 進(jìn)行腳本創(chuàng)建
點(diǎn)擊RUN進(jìn)行測(cè)試
在測(cè)試的時(shí)候點(diǎn)擊start transaction couter
可以查看到HammerDB提供的監(jiān)控指標(biāo):吞吐量,單位為TPM(每分鐘事務(wù)數(shù))。
以上就是使用HammerDB工具DB2數(shù)據(jù)庫進(jìn)行測(cè)試的使用方法,如有對(duì)測(cè)試工具有其他的問題的歡迎溝通。
更多精彩干貨分享
點(diǎn)擊下方名片關(guān)注
IT那活兒
文章版權(quán)歸作者所有,未經(jīng)允許請(qǐng)勿轉(zhuǎn)載,若此文章存在違規(guī)行為,您可以聯(lián)系管理員刪除。
轉(zhuǎn)載請(qǐng)注明本文地址:http://specialneedsforspecialkids.com/yun/129929.html
摘要:下面基于,帶著大家看一下中如何配置多數(shù)據(jù)源。注意版本不一致導(dǎo)致的一些小問題。配置配置兩個(gè)數(shù)據(jù)源數(shù)據(jù)庫和數(shù)據(jù)庫注意事項(xiàng)在配置數(shù)據(jù)源的過程中主要是寫成和。五啟動(dòng)類此注解表示啟動(dòng)類這樣基于的多數(shù)據(jù)源配置就已經(jīng)完成了,兩個(gè)數(shù)據(jù)庫都可以被訪問了。 在上一篇文章《優(yōu)雅整合 SpringBoot+Mybatis ,可能是你見過最詳細(xì)的一篇》中,帶著大家整合了 SpringBoot 和 Mybatis...
摘要:性能壓測(cè)工具及其調(diào)優(yōu)工具使用使用使用簡(jiǎn)介在日常的開發(fā)中,的性能顯得尤為重要,一個(gè)程序的好壞主要就是性能來決定的。工具主要就是用于對(duì)程序進(jìn)行壓力測(cè)試的一種有有力工具。 ...
摘要:主要介紹了美團(tuán)智能支付業(yè)務(wù)在穩(wěn)定性方向遇到的挑戰(zhàn),并重點(diǎn)介紹在穩(wěn)定性測(cè)試中的一些方法與實(shí)踐。其中,智能支付作為新擴(kuò)展的業(yè)務(wù)場(chǎng)景,去年也成為了美團(tuán)增速最快的業(yè)務(wù)之一。 本文根據(jù)美團(tuán)高級(jí)測(cè)試開發(fā)工程師勛偉在美團(tuán)第43期技術(shù)沙龍美團(tuán)金融千萬級(jí)交易系統(tǒng)質(zhì)量保障之路的演講整理而成。主要介紹了美團(tuán)智能支付業(yè)務(wù)在穩(wěn)定性方向遇到的挑戰(zhàn),并重點(diǎn)介紹QA在穩(wěn)定性測(cè)試中的一些方法與實(shí)踐。 背景 美團(tuán)支付承載...
閱讀 1346·2023-01-11 13:20
閱讀 1684·2023-01-11 13:20
閱讀 1132·2023-01-11 13:20
閱讀 1858·2023-01-11 13:20
閱讀 4100·2023-01-11 13:20
閱讀 2704·2023-01-11 13:20
閱讀 1385·2023-01-11 13:20
閱讀 3597·2023-01-11 13:20