DB2压测工具的使用

IT那活儿 2021-05-02

2835

近期客户上线了一套DB2 数据库，让我们提供下数据库的压测方案，接到要求后开始找合适的压测工具，因为DB2数据库的特殊性，关于DB2数据库的压测工具并不多，上网看了下，对于数据库的压测工具有以下几种工具：

通过对比后，决定使用HammerDB，为最终工具

下面就介绍下使用HammerDB对DB2进行压测的使用方法

一. HammerDB的安装

在HammerDB官网下载安装包，支持Linux 和Windows系统，这里使用Windows版本的，网址为https://www.hammerdb.com/download.html

下载完成后进行安装，一直下一步就可以了

安装完成后打开界面如下

二. DB2客户端安装

在官网下载DB2客户端进行安装，安装如下：

选择安装新产品

然后一直下一步，到完成安装。

三. 进行数据库压测准备

3.1 在目标db2数据库进行数据准备

▼▼▼
[db2inst1@ ~]$ db2 create database tpcc pagesize 8 kDB20000I The CREATE DATABASE command completed successfully.[db2inst1@ ~]$ db2 update db cfg for tpcc using PCKCACHESZ 1631072DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.[db2inst1@ ~]$ db2 update db cfg for tpcc using LOGFILSIZ 1048572DB20000I 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 5DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.[db2inst1@ ~]$ db2 update db cfg for tpcc using LOGBUFSZ 17264DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.[db2inst1@ ~]$ db2 update db cfg for tpcc using MINCOMMIT 1DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.[db2inst1@ ~]$ db2 update db cfg for tpcc using NUM_IOSERVERS AUTOMATICDB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.[db2inst1@ ~]$ db2 update db cfg for tpcc using DFT_PREFETCH_SZ AUTOMATICDB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.[db2inst1@ ~]$ db2 update db cfg for tpcc using LOCKTIMEOUT 15DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.[db2inst1@ ~]$ db2 update db cfg for tpcc using SOFTMAX 2500DB20000I 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 8kDB20000I The SQL command completed successfully.[db2inst1@ ~]$ db2 create large tablespace C_TS pagesize 8k managed by automatic storage bufferpool C_BPDB20000I The SQL command completed successfully.[db2inst1@ ~]$ db2 create bufferpool D_BP immediate size 500000 pagesize 4kDB20000I The SQL command completed successfully.[db2inst1@ ~]$ db2 create large tablespace D_TS pagesize 4k managed by automatic storage bufferpool D_BPDB20000I The SQL command completed successfully.[db2inst1@ ~]$ db2 create bufferpool W_BP immediate size 500000 pagesize 4kDB20000I The SQL command completed successfully.[db2inst1@ ~]$ db2 create large tablespace W_TS pagesize 4k managed by automatic storage bufferpool W_BPDB20000I The SQL command completed successfully.[db2inst1@ ~]$ db2 create bufferpool I_BP immediate size 500000 pagesize 4kDB20000I The SQL command completed successfully.[db2inst1@ ~]$ db2 create large tablespace I_TS pagesize 4k managed by automatic storage bufferpool I_BPDB20000I The SQL command completed successfully.[db2inst1@ ~]$ db2 create bufferpool H_BP immediate size 2000000 pagesize 8kDB20000I The SQL command completed successfully.[db2inst1@ ~]$ db2 create large tablespace H_TS pagesize 8k managed by automatic storage bufferpool H_BPDB20000I The SQL command completed successfully.[db2inst1@ ~]$ db2 create bufferpool S_BP immediate size 2000000 pagesize 8kDB20000I The SQL command completed successfully.[db2inst1@ ~]$ db2 create large tablespace S_TS pagesize 8k managed by automatic storage bufferpool S_BPDB20000I The SQL command completed successfully.[db2inst1@ ~]$ db2 create bufferpool NO_BP immediate size 3000000 pagesize 8kDB20000I The SQL command completed successfully.[db2inst1@ ~]$ db2 create large tablespace NO_TS pagesize 8k managed by automatic storage bufferpool NO_BPDB20000I The SQL command completed successfully.[db2inst1@ ~]$ db2 create bufferpool OR_BP immediate size 3000000 pagesize 8kDB20000I The SQL command completed successfully.[db2inst1@ ~]$ db2 create large tablespace OR_TS pagesize 8k managed by automatic storage bufferpool OR_BPDB20000I The SQL command completed successfully.[db2inst1@ ~]$ db2 create bufferpool OL_BP immediate size 5000000 pagesize 8kDB20000I The SQL command completed successfully.[db2inst1@ ~]$ db2 create large tablespace OL_TS pagesize 8k managed by automatic storage bufferpool OL_BPDB20000I The SQL command completed successfully.

3.2 在DB2客户端进行连接配置

在客户端进行编目测试，进行数据库连接测试

▼▼▼
D:\Program Files\IBM\SQLLIB\BIN>db2 catalog tcpip node tpcc remote 192.168.100.101 server 50000DB20000I CATALOG TCPIP NODE 命令成功完成。DB21056W 直到刷新目录高速缓存之后，目录更改才生效。D:\Program Files\IBM\SQLLIB\BIN> db2 catalog db tpcc as tpcc at node tpccDB20000I CATALOG DATABASE 命令成功完成。DB21056W 直到刷新目录高速缓存之后，目录更改才生效。D:\Program Files\IBM\SQLLIB\BIN>db2 terminateDB20000I TERMINATE 命令成功完成。D:\Program Files\IBM\SQLLIB\BIN>db2 connect to tpcc user db2inst1 using db2inst1   数据库连接信息 数据库服务器 = DB2/LINUXX8664 10.5.11 SQL 授权标识 = DB2INST1 本地数据库别名 = TPCC