巡 检 人：小麦苗([QQ：646634621] [微信公众号：DB宝] [提供OCP、OCM、高可用、MySQL和PostgreSQL最实用的培训])
版 本 号：v7.0.0
修改日期：2021-10-29
巡检日期：2021-10-29

[转到页底]

● 操作系统配置信息

OS_NAME	OS_VERSION	OS_RELEASE	HOST_NAME	TOTAL_CPUS	CONFIGURED_CPUS	TOTAL_MEMORY_GB	OS_FULL_VERSION	OS_KERNEL_VERSION	OS_ARCH_TYPE
Linux	3	10	lhrdb2	16	16	44	Red Hat Enterprise Linux Server 7.9	3.10.0-1127.10.1.el7.x86_64 #1 SMP Wed Jun 3 14:28:03 UTC 2020	x86_64

● 操作系统资源信息

NAME	VALUE	DATATYPE	UNIT	DBPARTITIONNUM
OS_NAME	Linux	VARCHAR(256)		0
HOST_NAME	lhrdb2	VARCHAR(256)		0
OS_VERSION	3	VARCHAR(256)		0
OS_RELEASE	10	VARCHAR(256)		0
MACHINE_IDENTIFICATION	x86_64	VARCHAR(256)		0
OS_LEVEL	0	VARCHAR(256)		0
CPU_TOTAL	16	BIGINT		0
CPU_ONLINE	16	BIGINT		0
CPU_CONFIGURED	16	BIGINT		0
CPU_SPEED	1698	BIGINT	MHz	0
CPU_HMT_DEGREE	1	BIGINT		0
CPU_CORES_PER_SOCKET	8	BIGINT		0
MEMORY_TOTAL	45932	BIGINT	MB	0
MEMORY_FREE	304	BIGINT	MB	0
MEMORY_SWAP_TOTAL	10547	BIGINT	MB	0
MEMORY_SWAP_FREE	10536	BIGINT	MB	0
VIRTUAL_MEM_TOTAL	56479	BIGINT	MB	0
VIRTUAL_MEM_FREE	10840	BIGINT	MB	0
CPU_LOAD_SHORT	1.560000	DECIMAL		0
CPU_LOAD_MEDIUM	1.550000	DECIMAL		0
CPU_LOAD_LONG	1.600000	DECIMAL		0
CPU_USAGE_TOTAL	13	SMALLINT	PERCENT	0

● 实例信息

INST_NAME	IS_INST_PARTITIONABLE	NUM_DBPARTITIONS	INST_PTR_SIZE	RELEASE_NUM	SERVICE_LEVEL	BLD_LEVEL	PTF	FIXPACK_NUM	NUM_MEMBERS
db2inst1	0	1	64	0607010F	DB2 v11.5.6.0	s2106111000	DYN2106111000AMD64	0	1

● LICENSE

INSTALLED_PROD	INSTALLED_PROD_FULLNAME	LICENSE_INSTALLED	PROD_RELEASE	LICENSE_TYPE
ESE	DB2_ENTERPRISE_SERVER_EDITION	N	11.5
AESE	DB2_ADVANCED_ENTERPRISE_SERVER_EDITION	N	11.5
AWSE	DB2_ADVANCED_WORKGROUP_SERVER_EDITION	N	11.5
WSE	DB2_WORKGROUP_SERVER_EDITION	N	11.5
DAE	DB2_DIRECT_ADVANCED_EDITION	N	11.5
DSE	DB2_DIRECT_STANDARD_EDITION	N	11.5
DEC	DB2_DEVELOPER_C_EDITION	Y	11.5	COMMUNITY
ADV	DB2_ADVANCED_EDITION	N	11.5
STD	DB2_STANDARD_EDITION	N	11.5
LITE	DB2_LITE_EDITION	N	11.5
BASE	DB2_BASE_EDITION	N	11.5

● PRODUCT FEATURE

FEATURE_NAME	FEATURE_FULLNAME	LICENSE_INSTALLED	PRODUCT_NAME	FEATURE_USE_STATUS

● 数据库大小

SNAPSHOT_TIMESTAMP	DB_SIZE_M	DB_CAPACITY_M
2021-10-29-12.33.09.863404	219	766096

Value of output parameters -------------------------- Parameter Name : SNAPSHOTTIMESTAMP Parameter Value : 2021-10-29-12.33.09.863404 Parameter Name : DATABASESIZE Parameter Value : 229969920 Parameter Name : DATABASECAPACITY Parameter Value : 803310006272 Return Status = 0

● 表空间信息 SQL0420N Invalid character found in a character string argument of the function "DECFLOAT". SQLSTATE=22018 [回到目录]

● TABLESPACE CONTAINER

SNAPSHOT_TIMESTAMP	TBSP_ID	TBSP_NAME	TBSP_TYPE	TBSP_CONTENT_TYPE	TBSP_CREATE_TIME	TBSP_STATE	TBSP_TOTAL_SIZE_MB	TBSP_USABLE_SIZE_MB	TBSP_USED_SIZE_MB	TBSP_FREE_SIZE_MB	TBSP_UTILIZATION_PERCENT(%)	TBSP_TOTAL_PAGES	TBSP_USABLE_PAGES	TBSP_USED_PAGES	TBSP_FREE_PAGES	TBSP_PAGE_TOP	TBSP_PAGE_SIZE	TBSP_EXTENT_SIZE	TBSP_PREFETCH_SIZE	TBSP_MAX_SIZE	TBSP_INCREASE_SIZE	TBSP_INCREASE_SIZE_PERCENT	TBSP_LAST_RESIZE_TIME	TBSP_LAST_RESIZE_FAILED	TBSP_USING_AUTO_STORAGE	TBSP_AUTO_RESIZE_ENABLED	DBPGNAME	TBSP_NUM_CONTAINERS	REMARKS	DBPARTITIONNUM

DBPARTITIONNUM	TBSP_NAME	TBSP_ID	CONTAINER_TYPE	TOTAL_SIZE	USABLE_SIZE	FS_TOTAL_SIZE_MB	FS_USED_SIZE_MB	CONTAINER_NAME
0	SYSCATSPACE	0	FILE_EXTENT_TAG	128	127	0	0	/database/data/db2inst1/NODE0000/LHRDB/T0000000/C0000000.CAT
0	TEMPSPACE1	1	PATH	0	0	0	0	/database/data/db2inst1/NODE0000/LHRDB/T0000001/C0000000.TMP
0	USERSPACE1	2	FILE_EXTENT_TAG	128	127	0	0	/database/data/db2inst1/NODE0000/LHRDB/T0000002/C0000000.LRG
0	SYSTOOLSPACE	3	FILE_EXTENT_TAG	32	31	0	0	/database/data/db2inst1/NODE0000/LHRDB/T0000003/C0000000.LRG

● 内存信息

CURRENT_PARTITION_MEM	DBPARTITIONNUM	MAX_PARTITION_MEM	PEAK_PARTITION_MEM
6130630656	0	17179869184	6230507520

● INSTANCE MEMORY

DBPARTITIONNUM	MEMBER	POOL_CONFIG_SIZE	POOL_CUR_SIZE	POOL_ID	POOL_WATERMARK	SNAPSHOT_TIMESTAMP
0	0	273743872	79101952	OTHER	79364096	2021-10-29-04.44.48.917270
0	0	4456448	4456448	FCMBP	4456448	2021-10-29-04.44.48.917270
0	0	393216	786432	MONITOR	786432	2021-10-29-04.44.48.917270

● IDATABASE MEMORY

SNAPSHOT_TIMESTAMP	DBPARTITIONNUM	POOL_ID	POOL_CUR_SIZE	POOL_WATERMARK	POOL_CONFIG_SIZE	PERCENT
2021-10-29-04.44.48.932020	0	UTILITY	196608	917504	349503488	.00
2021-10-29-04.44.48.932020	0	PACKAGE_CACHE	35586048	35586048	39190528	.90
2021-10-29-04.44.48.932020	0	OTHER	196608	196608	20971520	.00
2021-10-29-04.44.48.932020	0	CAT_CACHE	1835008	1835008	1245184	1.47
2021-10-29-04.44.48.932020	0	BP	3733782528	3733782528	3733782528	1.00
2021-10-29-04.44.48.932020	0	BP	1835008	1835008	1835008	1.00
2021-10-29-04.44.48.932020	0	BP	1572864	1572864	1572864	1.00
2021-10-29-04.44.48.932020	0	BP	1441792	1441792	1441792	1.00
2021-10-29-04.44.48.932020	0	BP	1310720	1310720	1310720	1.00
2021-10-29-04.44.48.932020	0	SHARED_SORT	2359296	4718592	285802496	.00
2021-10-29-04.44.48.932020	0	LOCK_MGR	64290816	64290816	66060288	.97
2021-10-29-04.44.48.932020	0	DATABASE	189857792	189857792	228589568	.83
2021-10-29-04.44.48.932020	0	APPLICATION	131072	131072	1048576	.12
2021-10-29-04.44.48.932020	0	APPLICATION	131072	262144	1048576	.12
2021-10-29-04.44.48.932020	0	APPLICATION	131072	131072	1048576	.12
2021-10-29-04.44.48.932020	0	APPLICATION	262144	262144	1048576	.25
2021-10-29-04.44.48.932020	0	APPLICATION	262144	262144	1048576	.25
2021-10-29-04.44.48.932020	0	APPLICATION	131072	131072	1048576	.12
2021-10-29-04.44.48.932020	0	APPLICATION	196608	458752	1048576	.18
2021-10-29-04.44.48.932020	0	APPLICATION	196608	458752	1048576	.18
2021-10-29-04.44.48.932020	0	APPLICATION	196608	458752	1048576	.18
2021-10-29-04.44.48.932020	0	APPLICATION	65536	65536	1048576	.06
2021-10-29-04.44.48.932020	0	APPLICATION	65536	65536	1048576	.06
2021-10-29-04.44.48.932020	0	APPLICATION	65536	65536	1048576	.06
2021-10-29-04.44.48.932020	0	APPLICATION	65536	65536	1048576	.06
2021-10-29-04.44.48.932020	0	APPLICATION	65536	65536	1048576	.06
2021-10-29-04.44.48.932020	0	APPLICATION	65536	65536	1048576	.06
2021-10-29-04.44.48.932020	0	APPLICATION	65536	65536	1048576	.06
2021-10-29-04.44.48.932020	0	APPLICATION	65536	65536	1048576	.06
2021-10-29-04.44.48.932020	0	APPLICATION	65536	65536	1048576	.06
2021-10-29-04.44.48.932020	0	APPLICATION	196608	196608	1048576	.18
2021-10-29-04.44.48.932020	0	APPLICATION	65536	65536	1048576	.06
2021-10-29-04.44.48.932020	0	APPLICATION	65536	65536	1048576	.06
2021-10-29-04.44.48.932020	0	APPLICATION	65536	65536	1048576	.06
2021-10-29-04.44.48.932020	0	APPLICATION	262144	262144	1048576	.25
2021-10-29-04.44.48.932020	0	APPL_SHARED	4259840	4259840	81920000	.05

● SORT HEAP MEMORY

SORT_HEAP_ALLOCATED	SORT_SHRHEAP_ALLOCATED	SORT_SHRHEAP_TOP
0	5	352

● DB2 REGISTER

DBPARTITIONNUM	REG_VAR_NAME	REG_VAR_VALUE	IS_AGGREGATE	AGGREGATE_NAME	LEVEL
0	DB2COMM	TCPIP	0		I
0	DB2SYSTEM	lhrdb2	0		G
0	DB2_FED_LIBPATH	/database/config/db2inst1/sqllib/federation/odbc/lib:/database/config/db2inst1/sqllib/federation/netezza/lib64:	0		E

● DBM CFG

NAME	VALUE	VALUE_FLAGS	DEFERRED_VALUE	DEFERRED_VALUE_FLAGS	DATATYPE
agent_stack_sz	1024	NONE	1024	NONE	INTEGER
agentpri	-1	NONE	-1	NONE	INTEGER
aslheapsz	15	NONE	15	NONE	BIGINT
audit_buf_sz	0	NONE	0	NONE	BIGINT
authentication	SERVER	NONE	SERVER	NONE	VARCHAR(32)
catalog_noauth	NO	NONE	NO	NONE	VARCHAR(3)
clnt_krb_plugin		NONE		NONE	VARCHAR(32)
clnt_pw_plugin		NONE		NONE	VARCHAR(32)
cluster_mgr		NONE		NONE	VARCHAR(262)
comm_bandwidth	1.000000e+02	NONE	1.000000e+02	NONE	REAL
conn_elapse	10	NONE	10	NONE	INTEGER
cpuspeed	2.991513e-07	NONE	2.991513e-07	NONE	REAL
dft_account_str		NONE		NONE	VARCHAR(25)
dft_mon_bufpool	OFF	NONE	OFF	NONE	VARCHAR(3)
dft_mon_lock	OFF	NONE	OFF	NONE	VARCHAR(3)
dft_mon_sort	OFF	NONE	OFF	NONE	VARCHAR(3)
dft_mon_stmt	OFF	NONE	OFF	NONE	VARCHAR(3)
dft_mon_table	OFF	NONE	OFF	NONE	VARCHAR(3)
dft_mon_timestamp	ON	NONE	ON	NONE	VARCHAR(3)
dft_mon_uow	OFF	NONE	OFF	NONE	VARCHAR(3)
dftdbpath	/database/data	NONE	/database/data	NONE	VARCHAR(215)
diaglevel	3	NONE	3	NONE	INTEGER
diagpath	/database/config/db2inst1/sqllib/db2dump/ $m	NONE	/database/config/db2inst1/sqllib/db2dump/ $m	NONE	VARCHAR(215)
diagpath_resolved	/database/config/db2inst1/sqllib/db2dump/DIAG0000/	NONE	/database/config/db2inst1/sqllib/db2dump/DIAG0000/	NONE	VARCHAR(215)
dir_cache	YES	NONE	YES	NONE	VARCHAR(3)
discover	SEARCH	NONE	SEARCH	NONE	VARCHAR(8)
discover_inst	ENABLE	NONE	ENABLE	NONE	VARCHAR(8)
fcm_num_buffers	4096	AUTOMATIC	4096	AUTOMATIC	BIGINT
fed_noauth	NO	NONE	NO	NONE	VARCHAR(3)
federated	YES	NONE	YES	NONE	VARCHAR(3)
fenced_pool	-1	AUTOMATIC	-1	AUTOMATIC	BIGINT
group_plugin		NONE		NONE	VARCHAR(32)
health_mon	OFF	NONE	OFF	NONE	VARCHAR(3)
indexrec	RESTART	NONE	RESTART	NONE	VARCHAR(32)
instance_memory	4194304	AUTOMATIC	4194304	AUTOMATIC	BIGINT
rstrt_light_mem	10	AUTOMATIC	10	AUTOMATIC	SMALLINT
intra_parallel	NO	NONE	NO	NONE	VARCHAR(3)
java_heap_sz	65536	NONE	65536	NONE	BIGINT
jdk_path	/database/config/db2inst1/sqllib/java/jdk64	NONE	/database/config/db2inst1/sqllib/java/jdk64	NONE	VARCHAR(255)
keepfenced	YES	NONE	YES	NONE	VARCHAR(3)
local_gssplugin		NONE		NONE	VARCHAR(32)
max_connections	-1	AUTOMATIC	-1	AUTOMATIC	BIGINT
max_connretries	5	NONE	5	NONE	INTEGER
max_coordagents	200	AUTOMATIC	200	AUTOMATIC	BIGINT
max_querydegree	-1	NONE	-1	NONE	BIGINT
max_time_diff	60	NONE	60	NONE	INTEGER
mon_heap_sz	90	AUTOMATIC	90	AUTOMATIC	INTEGER
notifylevel	3	NONE	3	NONE	INTEGER
num_initagents	0	NONE	0	NONE	BIGINT
num_initfenced	0	NONE	0	NONE	BIGINT
num_poolagents	100	AUTOMATIC	100	AUTOMATIC	BIGINT
numdb	32	NONE	32	NONE	INTEGER
resync_interval	180	NONE	180	NONE	INTEGER
rqrioblk	65535	NONE	65535	NONE	INTEGER
sheapthres	0	NONE	0	NONE	BIGINT
spm_log_file_sz	256	NONE	256	NONE	BIGINT
spm_log_path		NONE		NONE	VARCHAR(226)
spm_max_resync	20	NONE	20	NONE	BIGINT
spm_name	lhrdb2	NONE	lhrdb2	NONE	VARCHAR(8)
srvcon_auth	NOT_SPECIFIED	NONE	NOT_SPECIFIED	NONE	VARCHAR(32)
srvcon_gssplugin_list		NONE		NONE	VARCHAR(255)
srv_plugin_mode	UNFENCED	NONE	UNFENCED	NONE	VARCHAR(16)
srvcon_pw_plugin		NONE		NONE	VARCHAR(32)
start_stop_time	10	NONE	10	NONE	INTEGER
svcename	db2c_db2inst1	NONE	db2c_db2inst1	NONE	VARCHAR(14)
tm_database	1ST_CONN	NONE	1ST_CONN	NONE	VARCHAR(8)
tp_mon_name		NONE		NONE	VARCHAR(19)
trust_allclnts	YES	NONE	YES	NONE	VARCHAR(16)
trust_clntauth	CLIENT	NONE	CLIENT	NONE	VARCHAR(16)
util_impact_lim	10	NONE	10	NONE	BIGINT
nodetype	DPF_SERVER	NONE	DPF_SERVER	NONE	VARCHAR(32)
release	0x1500	NONE	0x1500	NONE	INTEGER
federated_async	0	NONE	0	NONE	INTEGER
alternate_auth_enc	NOT_SPECIFIED	NONE	NOT_SPECIFIED	NONE	VARCHAR(32)
ssl_cipherspecs		NONE		NONE	VARCHAR(255)
ssl_clnt_keydb		NONE		NONE	VARCHAR(1023)
ssl_clnt_stash		NONE		NONE	VARCHAR(1023)
ssl_svcename		NONE		NONE	VARCHAR(14)
ssl_svr_keydb		NONE		NONE	VARCHAR(1023)
ssl_svr_label		NONE		NONE	VARCHAR(1023)
ssl_svr_stash		NONE		NONE	VARCHAR(1023)
ssl_versions		NONE		NONE	VARCHAR(255)
sysadm_group	DB2IADM1	NONE	DB2IADM1	NONE	VARCHAR(128)
sysctrl_group		NONE		NONE	VARCHAR(128)
sysmaint_group		NONE		NONE	VARCHAR(128)
sysmon_group		NONE		NONE	VARCHAR(128)
cf_num_workers	1	AUTOMATIC	1	AUTOMATIC	INTEGER
cf_mem_sz	131072	AUTOMATIC	131072	AUTOMATIC	INTEGER
fcm_num_channels	2048	AUTOMATIC	2048	AUTOMATIC	INTEGER
diagsize	0	NONE	0	NONE	BIGINT
alt_diagpath		NONE		NONE	VARCHAR(215)
alt_diagpath_resolved		NONE		NONE	VARCHAR(215)
cf_diaglevel	2	NONE	2	NONE	INTEGER
cf_diagpath	/database/config/db2inst1/sqllib/db2dump/DIAG0000/	NONE	/database/config/db2inst1/sqllib/db2dump/DIAG0000/	NONE	VARCHAR(215)
cf_diagpath_resolved	/database/config/db2inst1/sqllib/db2dump/DIAG0000/	NONE	/database/config/db2inst1/sqllib/db2dump/DIAG0000/	NONE	VARCHAR(215)
cf_num_conns	16	AUTOMATIC	16	AUTOMATIC	INTEGER
comm_exit_list		NONE		NONE	VARCHAR(128)
wlm_dispatcher	NO	NONE	NO	NONE	INTEGER
wlm_disp_concur	16	COMPUTED	-1	COMPUTED	INTEGER
wlm_disp_cpu_shares	NO	NONE	NO	NONE	INTEGER
wlm_disp_min_util	5	NONE	5	NONE	INTEGER
fcm_parallelism	16	AUTOMATIC	16	AUTOMATIC	INTEGER
cur_eff_arch_lvl	V:11 R:5 M:6 F:0 I:0 SB:0	NONE	V:11 R:5 M:6 F:0 I:0 SB:0	NONE	VARCHAR(50)
cur_eff_code_lvl	V:11 R:5 M:6 F:0 I:0 SB:0	NONE	V:11 R:5 M:6 F:0 I:0 SB:0	NONE	VARCHAR(50)
member_inst_mem	0	NONE	0	NONE	BIGINT
cf_transport_method	0	NONE	0	NONE	INTEGER
keystore_location		NONE		NONE	VARCHAR(255)
keystore_type	NONE	NONE	NONE	NONE	VARCHAR(32)
fcm_buffer_size	32768	NONE	32768	NONE	INTEGER
python_path		NONE		NONE	VARCHAR(255)
r_path		NONE		NONE	VARCHAR(255)

● DB CFG[下一项]

NAME	VALUE	VALUE_FLAGS	DEFERRED_VALUE	DEFERRED_VALUE_FLAGS	DATATYPE	DBPARTITIONNUM	MEMBER
app_ctl_heap_sz	256	NONE	256	NONE	INTEGER	0	0
appgroup_mem_sz	20000	NONE	20000	NONE	BIGINT	0	0
applheapsz	256	AUTOMATIC	256	AUTOMATIC	BIGINT	0	0
archretrydelay	20	NONE	20	NONE	INTEGER	0	0
auto_del_rec_obj	OFF	NONE	OFF	NONE	VARCHAR(3)	0	0
auto_maint	ON	NONE	ON	NONE	VARCHAR(3)	0	0
auto_db_backup	OFF	NONE	OFF	NONE	VARCHAR(3)	0	0
auto_tbl_maint	ON	NONE	ON	NONE	VARCHAR(3)	0	0
auto_runstats	ON	NONE	ON	NONE	VARCHAR(3)	0	0
auto_stmt_stats	ON	NONE	ON	NONE	VARCHAR(3)	0	0
auto_stats_views	OFF	NONE	OFF	NONE	VARCHAR(3)	0	0
auto_sampling	ON	NONE	ON	NONE	VARCHAR(3)	0	0
auto_reorg	OFF	NONE	OFF	NONE	VARCHAR(3)	0	0
autorestart	ON	NONE	ON	NONE	VARCHAR(3)	0	0
auto_reval	DEFERRED	NONE	DEFERRED	NONE	INTEGER	0	0
avg_appls	1	AUTOMATIC	1	AUTOMATIC	INTEGER	0	0
blk_log_dsk_ful	NO	NONE	NO	NONE	VARCHAR(3)	0	0
blocknonlogged	NO	NONE	NO	NONE	VARCHAR(3)	0	0
catalogcache_sz	300	NONE	300	NONE	BIGINT	0	0
chngpgs_thresh	80	NONE	80	NONE	INTEGER	0	0
database_memory	1277440	AUTOMATIC	1268711	AUTOMATIC	BIGINT	0	0
dbheap	5219	AUTOMATIC	5219	AUTOMATIC	BIGINT	0	0
dft_degree	1	NONE	1	NONE	BIGINT	0	0
dft_extent_sz	32	NONE	32	NONE	BIGINT	0	0
dft_loadrec_ses	1	NONE	1	NONE	INTEGER	0	0
dft_mttb_types	SYSTEM	NONE	SYSTEM	NONE	VARCHAR(64)	0	0
dft_prefetch_sz	32	AUTOMATIC	32	AUTOMATIC	INTEGER	0	0
dft_queryopt	5	NONE	5	NONE	BIGINT	0	0
dft_refresh_age	0	NONE	0	NONE	VARCHAR(20)	0	0
dft_sqlmathwarn	NO	NONE	NO	NONE	VARCHAR(3)	0	0
discover_db	ENABLE	NONE	ENABLE	NONE	VARCHAR(8)	0	0
dlchktime	10000	NONE	10000	NONE	BIGINT	0	0
failarchpath		NONE		NONE	VARCHAR(242)	0	0
groupheap_ratio	70	NONE	70	NONE	INTEGER	0	0
hadr_local_host		NONE		NONE	VARCHAR(255)	0	0
hadr_local_svc		NONE		NONE	VARCHAR(40)	0	0
hadr_remote_host		NONE		NONE	VARCHAR(255)	0	0
hadr_remote_inst		NONE		NONE	VARCHAR(8)	0	0
hadr_remote_svc		NONE		NONE	VARCHAR(40)	0	0
hadr_syncmode	NEARSYNC	NONE	NEARSYNC	NONE	VARCHAR(16)	0	0
hadr_timeout	120	NONE	120	NONE	BIGINT	0	0
hadr_peer_window	0	NONE	0	NONE	BIGINT	0	0
indexrec	SYSTEM	NONE	SYSTEM	NONE	VARCHAR(32)	0	0
locklist	15360	AUTOMATIC	15360	AUTOMATIC	BIGINT	0	0
locktimeout	-1	NONE	-1	NONE	INTEGER	0	0
logarchmeth1	DISK:/database/logs/	NONE	DISK:/database/logs/	NONE	VARCHAR(251)	0	0
logarchmeth2	OFF	NONE	OFF	NONE	VARCHAR(251)	0	0
logarchopt1		NONE		NONE	VARCHAR(242)	0	0
logarchopt2		NONE		NONE	VARCHAR(242)	0	0
logbufsz	2152	NONE	2152	NONE	INTEGER	0	0
logfilsiz	1024	NONE	1024	NONE	BIGINT	0	0
alt_collate		NONE		NONE	INTEGER	0	0
logindexbuild	OFF	NONE	OFF	NONE	VARCHAR(3)	0	0
logprimary	16	NONE	16	NONE	INTEGER	0	0
logsecond	22	NONE	22	NONE	INTEGER	0	0
max_log	0	NONE	0	NONE	INTEGER	0	0
maxappls	40	AUTOMATIC	40	AUTOMATIC	INTEGER	0	0
maxfilop	61440	NONE	61440	NONE	INTEGER	0	0
maxlocks	98	AUTOMATIC	98	AUTOMATIC	INTEGER	0	0
min_dec_div_3	NO	NONE	NO	NONE	VARCHAR(3)	0	0
mirrorlogpath		NONE		NONE	VARCHAR(242)	0	0
newlogpath		NONE		NONE	VARCHAR(1023)	0	0
num_db_backups	12	NONE	12	NONE	INTEGER	0	0
num_freqvalues	10	NONE	10	NONE	INTEGER	0	0
num_iocleaners	4	AUTOMATIC	4	AUTOMATIC	INTEGER	0	0
num_ioservers	4	AUTOMATIC	4	AUTOMATIC	INTEGER	0	0
num_log_span	0	NONE	0	NONE	INTEGER	0	0
num_quantiles	20	NONE	20	NONE	INTEGER	0	0
numarchretry	5	NONE	5	NONE	INTEGER	0	0
overflowlogpath		NONE		NONE	VARCHAR(242)	0	0
pckcachesz	9556	AUTOMATIC	9556	AUTOMATIC	BIGINT	0	0
rec_his_retentn	90	NONE	90	NONE	INTEGER	0	0
self_tuning_mem	ON (Active)	NONE	ON	NONE	VARCHAR(3)	0	0
seqdetect	YES	NONE	YES	NONE	VARCHAR(3)	0	0
sheapthres_shr	69776	AUTOMATIC	69776	AUTOMATIC	BIGINT	0	0
softmax	0	NONE	0	NONE	INTEGER	0	0
sortheap	3488	AUTOMATIC	3488	AUTOMATIC	BIGINT	0	0
stat_heap_sz	4384	AUTOMATIC	4384	AUTOMATIC	BIGINT	0	0
stmtheap	8192	AUTOMATIC	8192	AUTOMATIC	BIGINT	0	0
trackmod	OFF	NONE	OFF	NONE	VARCHAR(3)	0	0
tsm_mgmtclass		NONE		NONE	VARCHAR(30)	0	0
tsm_nodename		NONE		NONE	VARCHAR(64)	0	0
tsm_owner		NONE		NONE	VARCHAR(64)	0	0
tsm_password		NONE		NONE	VARCHAR(64)	0	0
util_heap_sz	85319	AUTOMATIC	85319	AUTOMATIC	BIGINT	0	0
vendoropt		NONE		NONE	VARCHAR(242)	0	0
backup_pending	NO	NONE	NO	NONE	VARCHAR(3)	0	0
codepage	1208	NONE	1208	NONE	INTEGER	0	0
codeset	utf-8	NONE	utf-8	NONE	VARCHAR(17)	0	0
collate_info		NONE		NONE	VARCHAR(260)	0	0
country	1	NONE	1	NONE	INTEGER	0	0
database_consistent	NO	NONE	NO	NONE	VARCHAR(3)	0	0
database_level	0x1500	NONE	0x1500	NONE	INTEGER	0	0
hadr_db_role	STANDARD	NONE	STANDARD	NONE	VARCHAR(16)	0	0
log_retain_status	NO	NONE	NO	NONE	VARCHAR(3)	0	0
loghead	S0000036.LOG	NONE	S0000036.LOG	NONE	VARCHAR(1023)	0	0
logpath	/database/data/db2inst1/NODE0000/SQL00001/LOGSTREAM0000/	NONE	/database/data/db2inst1/NODE0000/SQL00001/LOGSTREAM0000/	NONE	VARCHAR(1023)	0	0
multipage_alloc	YES	NONE	YES	NONE	VARCHAR(3)	0	0
numsegs	1	NONE	1	NONE	INTEGER	0	0
pagesize	4096	NONE	4096	NONE	BIGINT	0	0
release	0x1500	NONE	0x1500	NONE	INTEGER	0	0
restore_pending	NO	NONE	NO	NONE	VARCHAR(3)	0	0
rollfwd_pending	NO	NONE	NO	NONE	VARCHAR(16)	0	0
territory	us	NONE	us	NONE	VARCHAR(33)	0	0
user_exit_status	YES	NONE	YES	NONE	VARCHAR(3)	0	0
db_mem_thresh	100	NONE	100	NONE	INTEGER	0	0
db_collname	IDENTITY	NONE	IDENTITY	NONE	VARCHAR(128)	0	0
enable_xmlchar	YES	NONE	YES	NONE	VARCHAR(3)	0	0
restrict_access	NO	NONE	NO	NONE	VARCHAR(3)	0	0
appl_memory	40000	AUTOMATIC	40000	AUTOMATIC	BIGINT	0	0
wlm_collect_int	0	NONE	0	NONE	INTEGER	0	0
decflt_rounding	ROUND_HALF_EVEN	NONE	ROUND_HALF_EVEN	NONE	VARCHAR(16)	0	0
number_compat	OFF	NONE	OFF	NONE	VARCHAR(3)	0	0
varchar2_compat	OFF	NONE	OFF	NONE	VARCHAR(3)	0	0
date_compat	OFF	NONE	OFF	NONE	VARCHAR(3)	0	0
cur_commit	ON	NONE	ON	NONE	VARCHAR(16)	0	0
smtp_server		NONE		NONE	VARCHAR(255)	0	0
mon_req_metrics	BASE	NONE	BASE	NONE	VARCHAR(8)	0	0
mon_act_metrics	BASE	NONE	BASE	NONE	VARCHAR(8)	0	0
mon_obj_metrics	EXTENDED	NONE	EXTENDED	NONE	VARCHAR(8)	0	0
mon_uow_data	NONE	NONE	NONE	NONE	VARCHAR(8)	0	0
mon_locktimeout	NONE	NONE	NONE	NONE	VARCHAR(16)	0	0
mon_deadlock	WITHOUT_HIST	NONE	WITHOUT_HIST	NONE	VARCHAR(16)	0	0
mon_lockwait	NONE	NONE	NONE	NONE	VARCHAR(16)	0	0
mon_lw_thresh	5000000	NONE	5000000	NONE	INTEGER	0	0
mon_pkglist_sz	32	NONE	32	NONE	INTEGER	0	0
mon_lck_msg_lvl	1	NONE	1	NONE	INTEGER	0	0
sql_ccflags		NONE		NONE	VARCHAR(1023)	0	0
stmt_conc	OFF	NONE	OFF	NONE	VARCHAR(8)	0	0
section_actuals	NONE	NONE	NONE	NONE	VARCHAR(8)	0	0
cf_catchup_trgt	15	AUTOMATIC	15	AUTOMATIC	INTEGER	0	0
cf_db_mem_sz	32768	AUTOMATIC	32768	AUTOMATIC	INTEGER	0	0
cf_gbp_sz	4096	AUTOMATIC	4096	AUTOMATIC	INTEGER	0	0
cf_lock_sz	16384	AUTOMATIC	16384	AUTOMATIC	INTEGER	0	0
cf_sca_sz	4096	AUTOMATIC	4096	AUTOMATIC	INTEGER	0	0
dec_to_char_fmt	NEW	NONE	NEW	NONE	VARCHAR(8)	0	0
systime_period_adj	NO	NONE	NO	NONE	VARCHAR(3)	0	0
suspend_io	NO	NONE	NO	NONE	INTEGER	0	0
mon_uow_pkglist	OFF	NONE	OFF	NONE	VARCHAR(3)	0	0
mon_uow_execlist	OFF	NONE	OFF	NONE	VARCHAR(3)	0	0
connect_proc		NONE		NONE	VARCHAR(257)	0	0
log_ddl_stmts	NO	NONE	NO	NONE	VARCHAR(3)	0	0
db_seed	3286132524	NONE	3286132524	NONE	INTEGER	0	0
log_appl_info	NO	NONE	NO	NONE	VARCHAR(3)	0	0
dft_schemas_dcc	NO	NONE	NO	NONE	VARCHAR(3)	0	0
hadr_target_list		NONE		NONE	VARCHAR(2048)	0	0
hadr_spool_limit	0	AUTOMATIC	0	AUTOMATIC	INTEGER	0	0
hadr_replay_delay	0	NONE	0	NONE	INTEGER	0	0
logarchcompr1	OFF	NONE	OFF	NONE	VARCHAR(5)	0	0
logarchcompr2	OFF	NONE	OFF	NONE	VARCHAR(5)	0	0
dft_table_org	ROW	NONE	ROW	NONE	VARCHAR(8)	0	0
mon_rtn_execlist	OFF	NONE	OFF	NONE	VARCHAR(3)	0	0
mon_rtn_data	NONE	NONE	NONE	NONE	VARCHAR(4)	0	0
extbl_strict_io	NO	NONE	NO	NONE	INTEGER	0	0
extbl_location	/database/config/db2inst1	NONE	/database/config/db2inst1	NONE	VARCHAR(1023)	0	0
string_units	SYSTEM	NONE	SYSTEM	NONE	VARCHAR(8)	0	0
nchar_mapping	CHAR_CU32	NONE	CHAR_CU32	NONE	VARCHAR(8)	0	0
extended_row_sz	ENABLE	NONE	ENABLE	NONE	INTEGER	0	0
opt_direct_wrkld	NO	NONE	NO	NONE	INTEGER	0	0
page_age_trgt_mcr	240	NONE	240	NONE	INTEGER	0	0
page_age_trgt_gcr	240	NONE	240	NONE	INTEGER	0	0
cf_deda_ratio	4	AUTOMATIC	4	AUTOMATIC	SMALLINT	0	0
cf_self_tuning_mem	OFF	NONE	OFF	NONE	VARCHAR(3)	0	0
encrlib		NONE		NONE	VARCHAR(254)	0	0
encropts		NONE		NONE	VARCHAR(1023)	0	0
encrypted_database	NO	NONE	NO	NONE	VARCHAR(3)	0	0
pl_stack_trace	NONE	NONE	NONE	NONE	SMALLINT	0	0
hadr_ssl_label		NONE		NONE	VARCHAR(127)	0	0
opt_buffpage	0	NONE	0	NONE	BIGINT	0	0
opt_locklist	0	NONE	0	NONE	BIGINT	0	0
opt_sortheap	0	NONE	0	NONE	BIGINT	0	0
opt_maxlocks	0	NONE	0	NONE	INTEGER	0	0
wlm_agent_load_trgt	14	AUTOMATIC	14	AUTOMATIC	INTEGER	0	0
wlm_admission_ctrl	NO	NONE	NO	NONE	INTEGER	0	0
wlm_cpu_shares	1000	NONE	1000	NONE	INTEGER	0	0
wlm_cpu_share_mode	HARD	NONE	HARD	NONE	INTEGER	0	0
wlm_cpu_limit	0	NONE	0	NONE	INTEGER	0	0
ddl_compression_def	NO	NONE	NO	NONE	VARCHAR(3)	0	0
ddl_constraint_def	YES	NONE	YES	NONE	VARCHAR(3)	0	0
dec_arithmetic		NONE		NONE	VARCHAR(6)	0	0
auto_cg_stats	OFF	NONE	OFF	NONE	VARCHAR(3)	0	0
log_disk_cap	0	NONE	0	NONE	BIGINT	0	0
authn_cache_duration	3	NONE	3	NONE	SMALLINT	0	0
authn_cache_users	0	NONE	0	NONE	SMALLINT	0	0
repl_site_id	0	NONE	0	NONE	SMALLINT	0	0
db_update_lvl_state	0	NONE	0	NONE	SMALLINT	0	0
act_sortmem_limit	100	NONE	100	NONE	SMALLINT	0	0
hadr_ssl_host_val	NO	NONE	NO	NONE	VARCHAR(32)	0	0
large_aggregation	NO	NONE	NO	NONE	SMALLINT	0	0

● DATABASE PATH

SNAPSHOT_TIMESTAMP	DB_NAME	DB_STORAGE_PATH	DB_STORAGE_PATH_WITH_DPE	DBPARTITIONNUM	DB_STORAGE_PATH_STATE	FS_ID	FS_TOTAL_SIZE	FS_USED_SIZE	STO_PATH_FREE_SIZE
2021-10-29-04.44.49.042788	LHRDB	/database/data		0	IN_USE		0	0	0

● STORAGE GROUP

STORAGE_GROUP_NAME	STORAGE_GROUP_ID	DBPARTITIONNUM	DB_STORAGE_PATH	DB_STORAGE_PATH_WITH_DPE	DB_STORAGE_PATH_STATE	DB_STORAGE_PATH_ID	FS_ID	FS_TOTAL_SIZE	FS_USED_SIZE	STO_PATH_FREE_SIZE
IBMSTOGROUP	0	0	/database/data		IN_USE	0	64768	1082120392704	279151992832	802901291008

锁情况

● database locks

DBPARTITIONNUM	LOCK_LIST_IN_USE	LOCK_WAIT_TIME	LOCK_WAITS	LOCKS_WAITING	LOCKS_HELD
0	83200	0	0	0	2

● dead_locks

DBPARTITIONNUM	LOCK_LIST_IN_USE	DEADLOCKS
0	83200	0

● LOCK ESCALS

DBPARTITIONNUM	LOCK_LIST_IN_USE	LOCK_ESCALS
0	83200	0

历史统计

● LAST 20:数据库备份历史

DBPARTITIONNUM	EID	START_TIME	SEQNUM	END_TIME	NUM_LOG_ELEMS	FIRSTLOG	LASTLOG	BACKUP_ID	TABSCHEMA	TABNAME	COMMENT	CMD_TEXT	NUM_TBSPS	TBSPNAMES	OPERATION	OPERATIONTYPE	OBJECTTYPE	LOCATION	DEVICETYPE	ENTRY_STATUS	SQLCAID	SQLCABC	SQLCODE	SQLERRML	SQLERRMC	SQLERRP	SQLERRD1	SQLERRD2	SQLERRD3	SQLERRD4	SQLERRD5	SQLERRD6	SQLWARN	SQLSTATE
0	1	20211027091125	1	20211027091136	1	S0000000.LOG	S0000000.LOG				DB2 BACKUP LHRDB OFFLINE		2	'SYSCATSPACE', 'USERSPACE1'	B	F	D	/database/backup	D	A		0	0	0			0	0	0	0	0	0

● LAST 20:还原历史

DBPARTITIONNUM	EID	START_TIME	SEQNUM	END_TIME	NUM_LOG_ELEMS	FIRSTLOG	LASTLOG	BACKUP_ID	TABSCHEMA	TABNAME	COMMENT	CMD_TEXT	NUM_TBSPS	TBSPNAMES	OPERATION	OPERATIONTYPE	OBJECTTYPE	LOCATION	DEVICETYPE	ENTRY_STATUS	SQLCAID	SQLCABC	SQLCODE	SQLERRML	SQLERRMC	SQLERRP	SQLERRD1	SQLERRD2	SQLERRD3	SQLERRD4	SQLERRD5	SQLERRD6	SQLWARN	SQLSTATE

● 升级历史

VERSIONNUMBER	VERSION_TIMESTAMP	AUTHID	VERSIONBUILDLEVEL
11050600	2021-10-27-09.03.44.709278	DB2INST1	s2106111000

● LAST 20:ADD TABLESPACE(HISTORY)

DBPARTITIONNUM	EID	START_TIME	SEQNUM	END_TIME	NUM_LOG_ELEMS	FIRSTLOG	LASTLOG	BACKUP_ID	TABSCHEMA	TABNAME	COMMENT	CMD_TEXT	NUM_TBSPS	TBSPNAMES	OPERATION	OPERATIONTYPE	OBJECTTYPE	LOCATION	DEVICETYPE	ENTRY_STATUS	SQLCAID	SQLCABC	SQLCODE	SQLERRML	SQLERRMC	SQLERRP	SQLERRD1	SQLERRD2	SQLERRD3	SQLERRD4	SQLERRD5	SQLERRD6	SQLWARN	SQLSTATE
0	3	20211027091748	0	20211027091749	0						CREATE TABLESPACE, ID = 3	CREATE TABLESPACE SYSTOOLSPACE IN IBMCATGROUP MANAGED BY AUTOMATIC STORAGE EXTENTSIZE 4	1	'SYSTOOLSPACE'	A		P			A		0	0	0			0	0	0	0	0	0

● LAST 20:DROP TABLE(HISTORY)

DBPARTITIONNUM	EID	START_TIME	SEQNUM	END_TIME	NUM_LOG_ELEMS	FIRSTLOG	LASTLOG	BACKUP_ID	TABSCHEMA	TABNAME	COMMENT	CMD_TEXT	NUM_TBSPS	TBSPNAMES	OPERATION	OPERATIONTYPE	OBJECTTYPE	LOCATION	DEVICETYPE	ENTRY_STATUS	SQLCAID	SQLCABC	SQLCODE	SQLERRML	SQLERRMC	SQLERRP	SQLERRD1	SQLERRD2	SQLERRD3	SQLERRD4	SQLERRD5	SQLERRD6	SQLWARN	SQLSTATE

● LAST 20:RUNSTAT TABLE(HISTORY)

TABSCHEMA	TABNAME	STATS_TIME
DB2INST1	ABC	9999-10-01-00.00.00.000000
DB2INST1	TEST1	2021-10-28-09.51.49.273111
DB2INST1	TEST	2021-10-28-08.46.50.623659

● LAST 20:LOAD COPY(HISTORY)

DBPARTITIONNUM	EID	START_TIME	SEQNUM	END_TIME	NUM_LOG_ELEMS	FIRSTLOG	LASTLOG	BACKUP_ID	TABSCHEMA	TABNAME	COMMENT	CMD_TEXT	NUM_TBSPS	TBSPNAMES	OPERATION	OPERATIONTYPE	OBJECTTYPE	LOCATION	DEVICETYPE	ENTRY_STATUS	SQLCAID	SQLCABC	SQLCODE	SQLERRML	SQLERRMC	SQLERRP	SQLERRD1	SQLERRD2	SQLERRD3	SQLERRD4	SQLERRD5	SQLERRD6	SQLWARN	SQLSTATE

● LAST 20:LOAD(HISTORY)

DBPARTITIONNUM	EID	START_TIME	SEQNUM	END_TIME	NUM_LOG_ELEMS	FIRSTLOG	LASTLOG	BACKUP_ID	TABSCHEMA	TABNAME	COMMENT	CMD_TEXT	NUM_TBSPS	TBSPNAMES	OPERATION	OPERATIONTYPE	OBJECTTYPE	LOCATION	DEVICETYPE	ENTRY_STATUS	SQLCAID	SQLCABC	SQLCODE	SQLERRML	SQLERRMC	SQLERRP	SQLERRD1	SQLERRD2	SQLERRD3	SQLERRD4	SQLERRD5	SQLERRD6	SQLWARN	SQLSTATE

● LAST 20:Unload(HISTORY)

DBPARTITIONNUM	EID	START_TIME	SEQNUM	END_TIME	NUM_LOG_ELEMS	FIRSTLOG	LASTLOG	BACKUP_ID	TABSCHEMA	TABNAME	COMMENT	CMD_TEXT	NUM_TBSPS	TBSPNAMES	OPERATION	OPERATIONTYPE	OBJECTTYPE	LOCATION	DEVICETYPE	ENTRY_STATUS	SQLCAID	SQLCABC	SQLCODE	SQLERRML	SQLERRMC	SQLERRP	SQLERRD1	SQLERRD2	SQLERRD3	SQLERRD4	SQLERRD5	SQLERRD6	SQLWARN	SQLSTATE

● LAST 20:Quiesce(HISTORY)

DBPARTITIONNUM	EID	START_TIME	SEQNUM	END_TIME	NUM_LOG_ELEMS	FIRSTLOG	LASTLOG	BACKUP_ID	TABSCHEMA	TABNAME	COMMENT	CMD_TEXT	NUM_TBSPS	TBSPNAMES	OPERATION	OPERATIONTYPE	OBJECTTYPE	LOCATION	DEVICETYPE	ENTRY_STATUS	SQLCAID	SQLCABC	SQLCODE	SQLERRML	SQLERRMC	SQLERRP	SQLERRD1	SQLERRD2	SQLERRD3	SQLERRD4	SQLERRD5	SQLERRD6	SQLWARN	SQLSTATE

● LAST 20:Rollforward(HISTORY)

DBPARTITIONNUM	EID	START_TIME	SEQNUM	END_TIME	NUM_LOG_ELEMS	FIRSTLOG	LASTLOG	BACKUP_ID	TABSCHEMA	TABNAME	COMMENT	CMD_TEXT	NUM_TBSPS	TBSPNAMES	OPERATION	OPERATIONTYPE	OBJECTTYPE	LOCATION	DEVICETYPE	ENTRY_STATUS	SQLCAID	SQLCABC	SQLCODE	SQLERRML	SQLERRMC	SQLERRP	SQLERRD1	SQLERRD2	SQLERRD3	SQLERRD4	SQLERRD5	SQLERRD6	SQLWARN	SQLSTATE

● LAST 20:归档历史

DBPARTITIONNUM	EID	START_TIME	SEQNUM	END_TIME	NUM_LOG_ELEMS	FIRSTLOG	LASTLOG	BACKUP_ID	TABSCHEMA	TABNAME	COMMENT	CMD_TEXT	NUM_TBSPS	TBSPNAMES	OPERATION	OPERATIONTYPE	OBJECTTYPE	LOCATION	DEVICETYPE	ENTRY_STATUS	SQLCAID	SQLCABC	SQLCODE	SQLERRML	SQLERRMC	SQLERRP	SQLERRD1	SQLERRD2	SQLERRD3	SQLERRD4	SQLERRD5	SQLERRD6	SQLWARN	SQLSTATE
0	39	20211029105149	0		1	S0000036.LOG	C0000000	1635381944					0		X	P	D	/database/data/db2inst1/NODE0000/SQL00001/LOGSTREAM0000/S0000036.LOG	D	A		0	0	0			0	0	0	0	0	0
0	38	20211028095149	0	20211029105151	1	S0000035.LOG	C0000000	1635381943					0		X	1	D	/database/logs/db2inst1/LHRDB/NODE0000/LOGSTREAM0000/C0000000/S0000035.LOG	D	A		0	0	0			0	0	0	0	0	0
0	37	20211028084544	0	20211028095150	1	S0000034.LOG	C0000000	1635381942					0		X	1	D	/database/logs/db2inst1/LHRDB/NODE0000/LOGSTREAM0000/C0000000/S0000034.LOG	D	A		0	0	0			0	0	0	0	0	0
0	36	20211028084537	0	20211028084545	1	S0000033.LOG	C0000000	1635381941					0		X	1	D	/database/logs/db2inst1/LHRDB/NODE0000/LOGSTREAM0000/C0000000/S0000033.LOG	D	A		0	0	0			0	0	0	0	0	0
0	34	20211028084536	0	20211028084537	1	S0000031.LOG	C0000000	1635381939					0		X	1	D	/database/logs/db2inst1/LHRDB/NODE0000/LOGSTREAM0000/C0000000/S0000031.LOG	D	A		0	0	0			0	0	0	0	0	0
0	35	20211028084536	0	20211028084538	1	S0000032.LOG	C0000000	1635381940					0		X	1	D	/database/logs/db2inst1/LHRDB/NODE0000/LOGSTREAM0000/C0000000/S0000032.LOG	D	A		0	0	0			0	0	0	0	0	0
0	32	20211028084535	0	20211028084536	1	S0000029.LOG	C0000000	1635381937					0		X	1	D	/database/logs/db2inst1/LHRDB/NODE0000/LOGSTREAM0000/C0000000/S0000029.LOG	D	A		0	0	0			0	0	0	0	0	0
0	33	20211028084535	0	20211028084537	1	S0000030.LOG	C0000000	1635381938					0		X	1	D	/database/logs/db2inst1/LHRDB/NODE0000/LOGSTREAM0000/C0000000/S0000030.LOG	D	A		0	0	0			0	0	0	0	0	0
0	30	20211028084534	0	20211028084535	1	S0000027.LOG	C0000000	1635381935					0		X	1	D	/database/logs/db2inst1/LHRDB/NODE0000/LOGSTREAM0000/C0000000/S0000027.LOG	D	A		0	0	0			0	0	0	0	0	0
0	31	20211028084534	0	20211028084536	1	S0000028.LOG	C0000000	1635381936					0		X	1	D	/database/logs/db2inst1/LHRDB/NODE0000/LOGSTREAM0000/C0000000/S0000028.LOG	D	A		0	0	0			0	0	0	0	0	0
0	28	20211028084533	0	20211028084534	1	S0000025.LOG	C0000000	1635381933					0		X	1	D	/database/logs/db2inst1/LHRDB/NODE0000/LOGSTREAM0000/C0000000/S0000025.LOG	D	A		0	0	0			0	0	0	0	0	0
0	29	20211028084533	0	20211028084535	1	S0000026.LOG	C0000000	1635381934					0		X	1	D	/database/logs/db2inst1/LHRDB/NODE0000/LOGSTREAM0000/C0000000/S0000026.LOG	D	A		0	0	0			0	0	0	0	0	0
0	27	20211028084532	0	20211028084534	1	S0000024.LOG	C0000000	1635381932					0		X	1	D	/database/logs/db2inst1/LHRDB/NODE0000/LOGSTREAM0000/C0000000/S0000024.LOG	D	A		0	0	0			0	0	0	0	0	0
0	25	20211028084531	0	20211028084533	1	S0000022.LOG	C0000000	1635381834					0		X	1	D	/database/logs/db2inst1/LHRDB/NODE0000/LOGSTREAM0000/C0000000/S0000022.LOG	D	A		0	0	0			0	0	0	0	0	0
0	26	20211028084531	0	20211028084533	1	S0000023.LOG	C0000000	1635381931					0		X	1	D	/database/logs/db2inst1/LHRDB/NODE0000/LOGSTREAM0000/C0000000/S0000023.LOG	D	A		0	0	0			0	0	0	0	0	0
0	24	20211028084530	0	20211028084532	1	S0000021.LOG	C0000000	1635338765					0		X	1	D	/database/logs/db2inst1/LHRDB/NODE0000/LOGSTREAM0000/C0000000/S0000021.LOG	D	A		0	0	0			0	0	0	0	0	0
0	23	20211028084355	0	20211028084532	1	S0000020.LOG	C0000000	1635338764					0		X	1	D	/database/logs/db2inst1/LHRDB/NODE0000/LOGSTREAM0000/C0000000/S0000020.LOG	D	A		0	0	0			0	0	0	0	0	0
0	20	20211028084353	0	20211028084356	1	S0000017.LOG	C0000000	1635333410					0		X	1	D	/database/logs/db2inst1/LHRDB/NODE0000/LOGSTREAM0000/C0000000/S0000017.LOG	D	A		0	0	0			0	0	0	0	0	0
0	22	20211028084353	0	20211028084357	1	S0000019.LOG	C0000000	1635338763					0		X	1	D	/database/logs/db2inst1/LHRDB/NODE0000/LOGSTREAM0000/C0000000/S0000019.LOG	D	A		0	0	0			0	0	0	0	0	0
0	21	20211028084353	0	20211028084357	1	S0000018.LOG	C0000000	1635338762					0		X	1	D	/database/logs/db2inst1/LHRDB/NODE0000/LOGSTREAM0000/C0000000/S0000018.LOG	D	A		0	0	0			0	0	0	0	0	0

对象统计

● 用户对象数统计

TABSCHEMA	COUNTS
DB2INST1	3
SYSCAT	159
SYSIBM	184
SYSIBMADM	81
SYSPUBLIC	1
SYSSTAT	9
SYSTOOLS	4

● 最新创建的表

TABSCHEMA	TABNAME	CREATE_TIME	ALTER_TIME
DB2INST1	ABC	2021-10-29-12.12.58.655205	2021-10-29-12.12.58.655205
DB2INST1	TEST1	2021-10-28-08.45.21.088122	2021-10-28-08.45.21.088122
DB2INST1	TEST	2021-10-28-08.42.46.022400	2021-10-28-08.42.46.022400

● TOP 10:空间占用最大的表

TABSCHEMA	TABNAME	TAB_SIZE_KB	NPAGES	FPAGES	NPAGES_FPAGES	TBSPACE	INDEX_TBSPACE	LONG_TBSPACE
DB2INST1	TEST	95980	23995	23995	0	USERSPACE1
DB2INST1	TEST1	2020	505	505	0	USERSPACE1
DB2INST1	ABC	-4	-1	-1	0

● TOP 10:空间占用最大的表(ADMINTABINFO)

TABSCHEMA	TABNAME	DATA_OBJECT_P_SIZE	INDEX_OBJECT_P_SIZE	LONG_OBJECT_P_SIZE	LOB_OBJECT_P_SIZE	XML_OBJECT_P_SIZE
DB2INST1	TEST	96128	0	0	512	0
DB2INST1	TEST1	2176	0	0	512	0

● TOP 10:TABLE RELATION SIZE

TABSCHEMA	TABNAME	TOTAL_P_SIZE
DB2INST1	TEST	96640
DB2INST1	TEST1	2688

● TABLE PARTITION

TABSCHEMA	TABNAME	DATAPARTITIONID	DATAPARTITIONNAME	LOWINCLUSIVE	LOWVALUE	HIGHINCLUSIVE	HIGHVALUE

● LOAD PENDING(TABLE)

TABSCHEMA	TABNAME	LOAD_STATUS

● INVALID TABLE

TABSCHEMA	TABNAME	STATUS	INVALIDATE_TIME

● ROWS READ TABLE(MOST)

TABSCHEMA	TABNAME	ROWS_READ	ROWS_WRITTEN	OVERFLOW_ACCESSES	PAGE_REORGS
<6114>	TEMP (00001,00002)	0	1	0	0
DB2INST1	TEST1	0	6538	0	0
DB2INST1	TEST	0	311136	0	0

● ROWS WRITEEN TABLE(MOST)

TABSCHEMA	TABNAME	ROWS_READ	ROWS_WRITTEN	OVERFLOW_ACCESSES	PAGE_REORGS
DB2INST1	TEST	0	311136	0	0
DB2INST1	TEST1	0	6538	0	0
<6114>	TEMP (00001,00002)	0	1	0	0

● ROWS OVERFLOW TABLES(MOST)

TABSCHEMA	TABNAME	ROWS_READ	ROWS_WRITTEN	OVERFLOW_ACCESSES	PAGE_REORGS
<6114>	TEMP (00001,00002)	0	1	0	0
DB2INST1	TEST1	0	6538	0	0
DB2INST1	TEST	0	311136	0	0

● TOP 10:REORG TABLES(PAGE_REORGS)

TABSCHEMA	TABNAME	ROWS_READ	ROWS_WRITTEN	OVERFLOW_ACCESSES	PAGE_REORGS
<6114>	TEMP (00001,00002)	0	1	0	0
DB2INST1	TEST1	0	6538	0	0
DB2INST1	TEST	0	311136	0	0

● TOP 10:REORG TABLES(NPAGES-FPAGES)

TABSCHEMA	TABNAME	TAB_SIZE_KB	NPAGES	FPAGES	NPAGES_FPAGES	TBSPACE	INDEX_TBSPACE	LONG_TBSPACE
DB2INST1	ABC	-4	-1	-1	0
DB2INST1	TEST1	2020	505	505	0	USERSPACE1
DB2INST1	TEST	95980	23995	23995	0	USERSPACE1

● TOP 10:STATIS TIME NULL(TABLES)

TABSCHEMA	TABNAME	STATS_TIME
DB2INST1	ABC	9999-10-01-00.00.00.000000

● TOP 10:USER INDEXES

INDSCHEMA	INDNAME	INDEXTYPE	LASTUSED	CREATE_TIME	TABSCHEMA	TABNAME

● 无效的索引

INDSCHEMA	INDNAME	TABSCHEMA	TABNAME	COMPRESS_ATTR	INDEX_COMPRESSED	INDEX_PARTITIONING	INDEX_REQUIRES_REBUILD	LARGE_RIDS

● TOP 10:未收集统计信息的索引

INDSCHEMA	INDNAME	TABSCHEMA	TABNAME

● 失效的视图

VIEWSCHEMA	VIEWNAME	VALID

● 失效的触发器

TRIGSCHEMA	TRIGNAME	VALID

● 失效的包

PKGSCHEMA	PKGNAME	VALID

● 失效的ROUTINE

ROUTINESCHEMA	ROUTINENAME	VALID

DATABASE HIT RATE

● 查看bufferpool -

BPNAME	BUFFERPOOLID	DBPGNAME	NPAGES	PAGESIZE	ESTORE	NUMBLOCKPAGES	BLOCKSIZE	NGNAME

● BUFFERPOOL HIT RATE

DBPARTITIONNUM	BP_NAME	DATA_HIT_RATIO_PERCENT	INDEX_HIT_RATIO_PERCENT	TOTAL_HIT_RATIO_PERCENT
0	IBMDEFAULTBP	0	0	0
0	IBMSYSTEMBP4K	0	0	0
0	IBMSYSTEMBP8K	0	0	0
0	IBMSYSTEMBP16K	0	0	0
0	IBMSYSTEMBP32K	0	0	0

● BUFFERPOOL READ TIME

DBPARTITIONNUM	BP_NAME	TOTAL_PHYSICAL_READS	AVERAGE_READ_TIME_MS	TOTAL_ASYNC_READS	AVERAGE_ASYNC_READ_TIME_MS	TOTAL_SYNC_READS	AVERAGE_SYNC_READ_TIME_MS	PERCENT_SYNC_READS
0	IBMDEFAULTBP	0	0	0	0	0	0	0
0	IBMSYSTEMBP4K	0	0	0	0	0	0	0
0	IBMSYSTEMBP8K	0	0	0	0	0	0	0
0	IBMSYSTEMBP16K	0	0	0	0	0	0	0
0	IBMSYSTEMBP32K	0	0	0	0	0	0	0

● BUFFERPOOL WRITE TIME

DBPARTITIONNUM	BP_NAME	TOTAL_WRITES	AVERAGE_WRITE_TIME_MS	TOTAL_ASYNC_WRITES	PERCENT_WRITES_ASYNC	AVERAGE_ASYNC_WRITE_TIME_MS	TOTAL_SYNC_WRITES	AVERAGE_SYNC_WRITE_TIME_MS
0	IBMDEFAULTBP	0	0	0	0	0	0	0
0	IBMSYSTEMBP4K	0	0	0	0	0	0	0
0	IBMSYSTEMBP8K	0	0	0	0	0	0	0
0	IBMSYSTEMBP16K	0	0	0	0	0	0	0
0	IBMSYSTEMBP32K	0	0	0	0	0	0	0

● CATALOG CACHE HIT RATE

DBPARTITIONNUM	PERCENT	CAT_CACHE_OVERFLOWS
0	100	0

● PACKAGE HIT RATE

DBPARTITIONNUM	PKG_CACHE_INSERTS	PKG_CACHE_LOOKUPS	PKG_HIT
0	1925	43852	.9562

SQL情况

● CONNECT APPLICATIONS

SNAPSHOT_TIMESTAMP	DBPARTITIONNUM	TOTAL_CONS	APPLS_CUR_CONS	COMMIT_SQL_STMTS	ROLLBACK_SQL_STMTS	INT_ROLLBACKS	INT_COMMITS	TRANSCATIONS	DYNAMIC_SQL_STMTS	STATIC_SQL_STMTS	DYNAMIC_STATIC_SQL_STMTS
2021-10-29-04.44.51.101042	0	2407	10	32547	240	2395	6250	41432	42924	35328	78252

● NUMS OF TRANSCATIONS

SNAPSHOT_TIMESTAMP	DBPARTITIONNUM	TRANSACTIONS	COMMIT_SQL_STMTS	ROLLBACK_SQL_STMTS	INT_ROLLBACKS	INT_COMMITS
2021-10-29-04.44.51.115178	0	41436	32551	240	2395	6250

● THE NUMBERS OF QUERY SQL FOR EVERY STMTS

SNAPSHOT_TIMESTAMP	DBPARTITIONNUM	NUM_SQL	COMMIT_SQL_STMTS	ROLLBACK_SQL_STMTS	INT_ROLLBACKS	INT_COMMITS
2021-10-29-04.44.51.129574	0	0	32555	240	2395	6250

● THE NUMBERS OF INSERT DELETE UPDATE FOR EVERY STMTS

SNAPSHOT_TIMESTAMP	DBPARTITIONNUM	INSERT_DELETE_UPDATE	COMMIT_SQL_STMTS	ROLLBACK_SQL_STMTS
2021-10-29-04.44.51.145211	0	.14	32559	240

● TOP 10:TOTAL EXECUTE TIME

NUM_EXECUTIONS	TOTAL_USR_CPU_TIME	TOTAL_USR_CPU_TIME_MS	TOTAL_SYS_CPU_TIME	TOTAL_SYS_CPU_TIME_MS	TOTAL_EXEC_TIME	AVG_EXEC_TIME	TOTAL_EXEC_TIME_MS	AVG_EXEC_TIME_MS	ROWS_READ	ROWS_WRITTEN	STMT_SORTS	SORT_OVERFLOWS	TOTAL_SORT_TIME	STMT_TEXT
2	0	0	0	0	0	.00	0	.00	0	0	0	0	0	SELECT ROUTINESCHEMA, ROUTINENAME FROM SYSCAT.ROUTINES WHERE ROUTINENAME LIKE ? WITH UR
214	0	0	0	0	0	.00	0	.00	0	0	0	0	0	call SYSIBM.SQLCAMESSAGECCSID(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
2	0	0	0	0	0	.00	0	.00	0	0	0	0	0	SELECT COUNT(DISTINCT NODENUM) FROM SYSIBM.SYSNODEGROUPDEF
3	0	0	0	0	0	.00	0	.00	0	0	0	0	0	SELECT * FROM SYSCAT.TABLES T , SYSCAT.VIEWS V WHERE V.VIEWSCHEMA = ? AND T.TABSCHEMA = V.VIEWSCHEMA AND T.TABNAME = V.VIEWNAME AND T.TYPE IN ('V','W') ORDER BY T.TABNAME WITH UR
16	0	0	0	0	0	.00	0	.00	0	0	0	0	0	SELECT POLICY FROM SYSTOOLS.POLICY WHERE MED='DB2TableMaintenanceMED' AND DECISION='TableRunstatsDecision' AND NAME='TableRunstatsPolicy'
6	0	0	0	0	0	.00	0	.00	0	0	0	0	0	SELECT * FROM SYSCAT.TABLES T , SYSCAT.VIEWS V WHERE V.VIEWSCHEMA = ? AND V.VIEWNAME = ? AND T.TABSCHEMA = V.VIEWSCHEMA AND T.TABNAME = V.VIEWNAME AND T.TYPE IN ('S') WITH UR
10	0	0	0	0	0	.00	0	.00	0	0	0	0	0	SELECT * FROM SYSCAT.INDEXES WHERE INDSCHEMA = ? AND INDNAME = ? WITH UR
1806	0	0	0	0	0	.00	0	.00	0	0	0	0	0	SET TENANT ?
6	0	0	0	0	0	.00	0	.00	0	0	0	0	0	UPDATE SYSTOOLS.STMG_DBSIZE_INFO SET SNAPSHOT_TIMESTAMP = ?, DB_SIZE = ?, DB_CAPACITY = ? WHERE SNAPSHOT_TIMESTAMP = ?
2	0	0	0	0	0	.00	0	.00	0	0	0	0	0	select sum(TBSP_USED_SIZE_KB)/1024 DB_SIZE_MB, sum(TBSP_TOTAL_SIZE_KB)/1024 DB_CAPACITY_MB from sysibmadm.TBSP_UTILIZATION with ur

● TOP 10:AVG EXECUTE TIME

NUM_EXECUTIONS	TOTAL_USR_CPU_TIME	TOTAL_USR_CPU_TIME_MS	TOTAL_SYS_CPU_TIME	TOTAL_SYS_CPU_TIME_MS	TOTAL_EXEC_TIME	AVG_EXEC_TIME	TOTAL_EXEC_TIME_MS	AVG_EXEC_TIME_MS	ROWS_READ	ROWS_WRITTEN	STMT_SORTS	SORT_OVERFLOWS	TOTAL_SORT_TIME	STMT_TEXT
2	0	0	0	0	0	.00	0	.00	0	0	0	0	0	SELECT ROUTINESCHEMA, ROUTINENAME FROM SYSCAT.ROUTINES WHERE ROUTINENAME LIKE ? WITH UR
214	0	0	0	0	0	.00	0	.00	0	0	0	0	0	call SYSIBM.SQLCAMESSAGECCSID(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
2	0	0	0	0	0	.00	0	.00	0	0	0	0	0	SELECT COUNT(DISTINCT NODENUM) FROM SYSIBM.SYSNODEGROUPDEF
3	0	0	0	0	0	.00	0	.00	0	0	0	0	0	SELECT * FROM SYSCAT.TABLES T , SYSCAT.VIEWS V WHERE V.VIEWSCHEMA = ? AND T.TABSCHEMA = V.VIEWSCHEMA AND T.TABNAME = V.VIEWNAME AND T.TYPE IN ('V','W') ORDER BY T.TABNAME WITH UR
16	0	0	0	0	0	.00	0	.00	0	0	0	0	0	SELECT POLICY FROM SYSTOOLS.POLICY WHERE MED='DB2TableMaintenanceMED' AND DECISION='TableRunstatsDecision' AND NAME='TableRunstatsPolicy'
6	0	0	0	0	0	.00	0	.00	0	0	0	0	0	SELECT * FROM SYSCAT.TABLES T , SYSCAT.VIEWS V WHERE V.VIEWSCHEMA = ? AND V.VIEWNAME = ? AND T.TABSCHEMA = V.VIEWSCHEMA AND T.TABNAME = V.VIEWNAME AND T.TYPE IN ('S') WITH UR
10	0	0	0	0	0	.00	0	.00	0	0	0	0	0	SELECT * FROM SYSCAT.INDEXES WHERE INDSCHEMA = ? AND INDNAME = ? WITH UR
1806	0	0	0	0	0	.00	0	.00	0	0	0	0	0	SET TENANT ?
6	0	0	0	0	0	.00	0	.00	0	0	0	0	0	UPDATE SYSTOOLS.STMG_DBSIZE_INFO SET SNAPSHOT_TIMESTAMP = ?, DB_SIZE = ?, DB_CAPACITY = ? WHERE SNAPSHOT_TIMESTAMP = ?
2	0	0	0	0	0	.00	0	.00	0	0	0	0	0	select sum(TBSP_USED_SIZE_KB)/1024 DB_SIZE_MB, sum(TBSP_TOTAL_SIZE_KB)/1024 DB_CAPACITY_MB from sysibmadm.TBSP_UTILIZATION with ur

● TOP 10:NUMBER EXECUTE

NUM_EXECUTIONS	TOTAL_USR_CPU_TIME	TOTAL_USR_CPU_TIME_MS	TOTAL_SYS_CPU_TIME	TOTAL_SYS_CPU_TIME_MS	TOTAL_EXEC_TIME	TOTAL_EXEC_TIME_MS	ROWS_READ	ROWS_WRITTEN	STMT_SORTS	SORT_OVERFLOWS	TOTAL_SORT_TIME	STMT_TEXT
3007	0	0	0	0	0	0	0	0	0	0	0	UPDATE SYSTOOLS.HMON_ATM_INFO SET TO_WAIT = ?, LAST_WAIT = ?, STATS_LOCK = 'N', STATS_STATE = ?, STATS_NOTIFY = ?, STATS_DETAIL = ?, STATS_HISTORY = ?, STATS_OPTS = ?, STATS_TIME = CURRENT TIMESTAMP, SIGNAL = (CASE SIGNAL WHEN 'N' THEN ? ELSE 'Y' END)WHERE SCHEMA = ? AND NAME = ? AND CREATE_TIME = ?
2895	0	0	0	0	0	0	0	0	0	0	0	SELECT STATS_TIME, INDEXTYPE FROM SYSIBM.SYSINDEXES WHERE TBCREATOR = ? AND TBNAME = ? WITH UR
2436	0	0	0	0	0	0	0	0	0	0	0	SELECT CREATE_TIME FROM SYSTOOLS.HMON_ATM_INFO WHERE SCHEMA = ? AND NAME = ? FOR UPDATE
1806	0	0	0	0	0	0	0	0	0	0	0	SET TENANT ?
1726	0	0	0	0	0	0	0	0	0	0	0	SET CURRENT LOCK TIMEOUT 5
1566	0	0	0	0	0	0	0	0	0	0	0	UPDATE SYSTOOLS.HMON_ATM_INFO SET STATS_LOCK = 'Y' WHERE CURRENT OF SQL_CURSH100C4
1526	0	0	0	0	0	0	0	0	0	0	0	SELECT STATS_LOCK, REORG_LOCK FROM SYSTOOLS.HMON_ATM_INFO WHERE SCHEMA = ? AND NAME = ? AND CREATE_TIME = ? FOR UPDATE
990	0	0	0	0	0	0	0	0	0	0	0	WITH DBAUTHCHECK(TESTVALUE) AS (SELECT 1 FROM TABLE(SYSPROC.AUTH_LIST_AUTHORITIES_FOR_AUTHID(CURRENT_USER, 'U')) WHERE AUTHORITY = 'DBADM' AND (D_USER = 'Y' OR D_GROUP ='Y' OR D_PUBLIC ='Y' OR ROLE_USER= 'Y' OR ROLE_GROUP='Y' OR ROLE_PUBLIC='Y' OR D_ROLE='Y')) SELECT CURRENT USER AS AUTHID, EXISTS(SELECT TESTVALUE FROM DBAUTHCHECK) AS HAS_DBADM FROM SYSIBM.SYSDUMMY1
721	0	0	0	0	0	0	0	0	0	0	0	CALL SYSPROC.SYSINSTALLOBJECTS('POLICY','V','','')
600	0	0	0	0	0	0	0	0	0	0	0	SELECT POLICY FROM SYSTOOLS.POLICY WHERE MED='DB2CommonMED' AND DECISION='NOP' AND NAME='CommonPolicy'

● TOP 10:TOTAL USER CPU TIME

NUM_EXECUTIONS	TOTAL_USR_CPU_TIME	AVG_USR_CPU_TIME	TOTAL_USR_CPU_TIME_MS	AVG_USR_CPU_TIME_MS	TOTAL_SYS_CPU_TIME	TOTAL_SYS_CPU_TIME_MS	TOTAL_EXEC_TIME	TOTAL_EXEC_TIME_MS	ROWS_READ	ROWS_WRITTEN	STMT_SORTS	SORT_OVERFLOWS	TOTAL_SORT_TIME	STMT_TEXT
2	0	.00	0	.00	0	0	0	0	0	0	0	0	0	SELECT ROUTINESCHEMA, ROUTINENAME FROM SYSCAT.ROUTINES WHERE ROUTINENAME LIKE ? WITH UR
214	0	.00	0	.00	0	0	0	0	0	0	0	0	0	call SYSIBM.SQLCAMESSAGECCSID(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
2	0	.00	0	.00	0	0	0	0	0	0	0	0	0	SELECT COUNT(DISTINCT NODENUM) FROM SYSIBM.SYSNODEGROUPDEF
3	0	.00	0	.00	0	0	0	0	0	0	0	0	0	SELECT * FROM SYSCAT.TABLES T , SYSCAT.VIEWS V WHERE V.VIEWSCHEMA = ? AND T.TABSCHEMA = V.VIEWSCHEMA AND T.TABNAME = V.VIEWNAME AND T.TYPE IN ('V','W') ORDER BY T.TABNAME WITH UR
16	0	.00	0	.00	0	0	0	0	0	0	0	0	0	SELECT POLICY FROM SYSTOOLS.POLICY WHERE MED='DB2TableMaintenanceMED' AND DECISION='TableRunstatsDecision' AND NAME='TableRunstatsPolicy'
6	0	.00	0	.00	0	0	0	0	0	0	0	0	0	SELECT * FROM SYSCAT.TABLES T , SYSCAT.VIEWS V WHERE V.VIEWSCHEMA = ? AND V.VIEWNAME = ? AND T.TABSCHEMA = V.VIEWSCHEMA AND T.TABNAME = V.VIEWNAME AND T.TYPE IN ('S') WITH UR
10	0	.00	0	.00	0	0	0	0	0	0	0	0	0	SELECT * FROM SYSCAT.INDEXES WHERE INDSCHEMA = ? AND INDNAME = ? WITH UR
1806	0	.00	0	.00	0	0	0	0	0	0	0	0	0	SET TENANT ?
6	0	.00	0	.00	0	0	0	0	0	0	0	0	0	UPDATE SYSTOOLS.STMG_DBSIZE_INFO SET SNAPSHOT_TIMESTAMP = ?, DB_SIZE = ?, DB_CAPACITY = ? WHERE SNAPSHOT_TIMESTAMP = ?
2	0	.00	0	.00	0	0	0	0	0	0	0	0	0	select sum(TBSP_USED_SIZE_KB)/1024 DB_SIZE_MB, sum(TBSP_TOTAL_SIZE_KB)/1024 DB_CAPACITY_MB from sysibmadm.TBSP_UTILIZATION with ur

● TOP 10:AVG USER CPU TIME

NUM_EXECUTIONS	TOTAL_USR_CPU_TIME	AVG_USR_CPU_TIME	TOTAL_USR_CPU_TIME_MS	AVG_USR_CPU_TIME_MS	TOTAL_SYS_CPU_TIME	TOTAL_SYS_CPU_TIME_MS	TOTAL_EXEC_TIME	TOTAL_EXEC_TIME_MS	ROWS_READ	ROWS_WRITTEN	STMT_SORTS	SORT_OVERFLOWS	TOTAL_SORT_TIME	STMT_TEXT
2	0	.00	0	.00	0	0	0	0	0	0	0	0	0	SELECT ROUTINESCHEMA, ROUTINENAME FROM SYSCAT.ROUTINES WHERE ROUTINENAME LIKE ? WITH UR
214	0	.00	0	.00	0	0	0	0	0	0	0	0	0	call SYSIBM.SQLCAMESSAGECCSID(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
2	0	.00	0	.00	0	0	0	0	0	0	0	0	0	SELECT COUNT(DISTINCT NODENUM) FROM SYSIBM.SYSNODEGROUPDEF
3	0	.00	0	.00	0	0	0	0	0	0	0	0	0	SELECT * FROM SYSCAT.TABLES T , SYSCAT.VIEWS V WHERE V.VIEWSCHEMA = ? AND T.TABSCHEMA = V.VIEWSCHEMA AND T.TABNAME = V.VIEWNAME AND T.TYPE IN ('V','W') ORDER BY T.TABNAME WITH UR
16	0	.00	0	.00	0	0	0	0	0	0	0	0	0	SELECT POLICY FROM SYSTOOLS.POLICY WHERE MED='DB2TableMaintenanceMED' AND DECISION='TableRunstatsDecision' AND NAME='TableRunstatsPolicy'
6	0	.00	0	.00	0	0	0	0	0	0	0	0	0	SELECT * FROM SYSCAT.TABLES T , SYSCAT.VIEWS V WHERE V.VIEWSCHEMA = ? AND V.VIEWNAME = ? AND T.TABSCHEMA = V.VIEWSCHEMA AND T.TABNAME = V.VIEWNAME AND T.TYPE IN ('S') WITH UR
10	0	.00	0	.00	0	0	0	0	0	0	0	0	0	SELECT * FROM SYSCAT.INDEXES WHERE INDSCHEMA = ? AND INDNAME = ? WITH UR
1806	0	.00	0	.00	0	0	0	0	0	0	0	0	0	SET TENANT ?
6	0	.00	0	.00	0	0	0	0	0	0	0	0	0	UPDATE SYSTOOLS.STMG_DBSIZE_INFO SET SNAPSHOT_TIMESTAMP = ?, DB_SIZE = ?, DB_CAPACITY = ? WHERE SNAPSHOT_TIMESTAMP = ?
2	0	.00	0	.00	0	0	0	0	0	0	0	0	0	select sum(TBSP_USED_SIZE_KB)/1024 DB_SIZE_MB, sum(TBSP_TOTAL_SIZE_KB)/1024 DB_CAPACITY_MB from sysibmadm.TBSP_UTILIZATION with ur

● TOP 10:TOTAL SYS CPU TIME

NUM_EXECUTIONS	TOTAL_USR_CPU_TIME	TOTAL_USR_CPU_TIME_MS	TOTAL_SYS_CPU_TIME	TOTAL_SYS_CPU_TIME_MS	TOTAL_EXEC_TIME	TOTAL_EXEC_TIME_MS	ROWS_READ	ROWS_WRITTEN	STMT_SORTS	SORT_OVERFLOWS	TOTAL_SORT_TIME	STMT_TEXT
2	0	0	0	0	0	0	0	0	0	0	0	SELECT ROUTINESCHEMA, ROUTINENAME FROM SYSCAT.ROUTINES WHERE ROUTINENAME LIKE ? WITH UR
1	0	0	0	0	0	0	0	0	0	0	0	CREATE OR REPLACE VIEW ABC AS select DBPARTITIONNUM, (1-(CAT_CACHE_INSERTS/CAT_CACHE_LOOKUPS))*100 percent, CAT_CACHE_OVERFLOWS from sysibmadm.snapdb with ur
1	0	0	0	0	0	0	0	0	0	0	0	CREATE OR REPLACE VIEW ABC AS select INDSCHEMA, INDNAME, TABSCHEMA, TABNAME, COMPRESS_ATTR, INDEX_COMPRESSED, INDEX_PARTITIONING, INDEX_REQUIRES_REBUILD, LARGE_RIDS from TABLE(sysproc.admin_get_index_info('','','')) where INDEX_REQUIRES_REBUILD='Y' with ur
1806	0	0	0	0	0	0	0	0	0	0	0	SET TENANT ?
1	0	0	0	0	0	0	0	0	0	0	0	CREATE OR REPLACE VIEW ABC AS select DBPARTITIONNUM, PKG_CACHE_INSERTS, PKG_CACHE_LOOKUPS, 1-dec((double(PKG_CACHE_INSERTS)/double(PKG_CACHE_LOOKUPS)),6,4) AS PKG_HIT from sysibmadm.snapdb with ur
1	0	0	0	0	0	0	0	0	0	0	0	select PKGSCHEMA, PKGNAME, valid from syscat.packages
6	0	0	0	0	0	0	0	0	0	0	0	UPDATE SYSTOOLS.STMG_DBSIZE_INFO SET SNAPSHOT_TIMESTAMP = ?, DB_SIZE = ?, DB_CAPACITY = ? WHERE SNAPSHOT_TIMESTAMP = ?
2	0	0	0	0	0	0	0	0	0	0	0	select sum(TBSP_USED_SIZE_KB)/1024 DB_SIZE_MB, sum(TBSP_TOTAL_SIZE_KB)/1024 DB_CAPACITY_MB from sysibmadm.TBSP_UTILIZATION with ur
1	0	0	0	0	0	0	0	0	0	0	0	SELECT USER FROM "SYSIBM".DUAL
1	0	0	0	0	0	0	0	0	0	0	0	select tabschema, tabname, isnull(stats_time,' ') stats_time from syscat.tables where stats_time is null and tabschema not like 'SYS%' fetch first 30 rows only with ur

● TOP 10:AVG SYS CPU TIME

NUM_EXECUTIONS	TOTAL_USR_CPU_TIME	TOTAL_USR_CPU_TIME_MS	TOTAL_SYS_CPU_TIME	AVG_SYS_CPU_TIME	TOTAL_SYS_CPU_TIME_MS	AVG_SYS_CPU_TIME_MS	TOTAL_EXEC_TIME	TOTAL_EXEC_TIME_MS	ROWS_READ	ROWS_WRITTEN	STMT_SORTS	SORT_OVERFLOWS	TOTAL_SORT_TIME	STMT_TEXT
2	0	0	0	.00	0	.00	0	0	0	0	0	0	0	SELECT ROUTINESCHEMA, ROUTINENAME FROM SYSCAT.ROUTINES WHERE ROUTINENAME LIKE ? WITH UR
214	0	0	0	.00	0	.00	0	0	0	0	0	0	0	call SYSIBM.SQLCAMESSAGECCSID(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
2	0	0	0	.00	0	.00	0	0	0	0	0	0	0	SELECT COUNT(DISTINCT NODENUM) FROM SYSIBM.SYSNODEGROUPDEF
3	0	0	0	.00	0	.00	0	0	0	0	0	0	0	SELECT * FROM SYSCAT.TABLES T , SYSCAT.VIEWS V WHERE V.VIEWSCHEMA = ? AND T.TABSCHEMA = V.VIEWSCHEMA AND T.TABNAME = V.VIEWNAME AND T.TYPE IN ('V','W') ORDER BY T.TABNAME WITH UR
16	0	0	0	.00	0	.00	0	0	0	0	0	0	0	SELECT POLICY FROM SYSTOOLS.POLICY WHERE MED='DB2TableMaintenanceMED' AND DECISION='TableRunstatsDecision' AND NAME='TableRunstatsPolicy'
6	0	0	0	.00	0	.00	0	0	0	0	0	0	0	SELECT * FROM SYSCAT.TABLES T , SYSCAT.VIEWS V WHERE V.VIEWSCHEMA = ? AND V.VIEWNAME = ? AND T.TABSCHEMA = V.VIEWSCHEMA AND T.TABNAME = V.VIEWNAME AND T.TYPE IN ('S') WITH UR
10	0	0	0	.00	0	.00	0	0	0	0	0	0	0	SELECT * FROM SYSCAT.INDEXES WHERE INDSCHEMA = ? AND INDNAME = ? WITH UR
1806	0	0	0	.00	0	.00	0	0	0	0	0	0	0	SET TENANT ?
6	0	0	0	.00	0	.00	0	0	0	0	0	0	0	UPDATE SYSTOOLS.STMG_DBSIZE_INFO SET SNAPSHOT_TIMESTAMP = ?, DB_SIZE = ?, DB_CAPACITY = ? WHERE SNAPSHOT_TIMESTAMP = ?
2	0	0	0	.00	0	.00	0	0	0	0	0	0	0	select sum(TBSP_USED_SIZE_KB)/1024 DB_SIZE_MB, sum(TBSP_TOTAL_SIZE_KB)/1024 DB_CAPACITY_MB from sysibmadm.TBSP_UTILIZATION with ur

● TOP 10:TOTAL SORTS NUM

NUM_EXECUTIONS	TOTAL_USR_CPU_TIME	TOTAL_USR_CPU_TIME_MS	TOTAL_SYS_CPU_TIME	TOTAL_SYS_CPU_TIME_MS	TOTAL_EXEC_TIME	TOTAL_EXEC_TIME_MS	ROWS_READ	ROWS_WRITTEN	STMT_SORTS	SORT_OVERFLOWS	TOTAL_SORT_TIME	STMT_TEXT
2	0	0	0	0	0	0	0	0	0	0	0	SELECT ROUTINESCHEMA, ROUTINENAME FROM SYSCAT.ROUTINES WHERE ROUTINENAME LIKE ? WITH UR
1	0	0	0	0	0	0	0	0	0	0	0	CREATE OR REPLACE VIEW ABC AS select DBPARTITIONNUM, (1-(CAT_CACHE_INSERTS/CAT_CACHE_LOOKUPS))*100 percent, CAT_CACHE_OVERFLOWS from sysibmadm.snapdb with ur
1	0	0	0	0	0	0	0	0	0	0	0	CREATE OR REPLACE VIEW ABC AS select INDSCHEMA, INDNAME, TABSCHEMA, TABNAME, COMPRESS_ATTR, INDEX_COMPRESSED, INDEX_PARTITIONING, INDEX_REQUIRES_REBUILD, LARGE_RIDS from TABLE(sysproc.admin_get_index_info('','','')) where INDEX_REQUIRES_REBUILD='Y' with ur
1806	0	0	0	0	0	0	0	0	0	0	0	SET TENANT ?
1	0	0	0	0	0	0	0	0	0	0	0	CREATE OR REPLACE VIEW ABC AS select DBPARTITIONNUM, PKG_CACHE_INSERTS, PKG_CACHE_LOOKUPS, 1-dec((double(PKG_CACHE_INSERTS)/double(PKG_CACHE_LOOKUPS)),6,4) AS PKG_HIT from sysibmadm.snapdb with ur
1	0	0	0	0	0	0	0	0	0	0	0	select PKGSCHEMA, PKGNAME, valid from syscat.packages
6	0	0	0	0	0	0	0	0	0	0	0	UPDATE SYSTOOLS.STMG_DBSIZE_INFO SET SNAPSHOT_TIMESTAMP = ?, DB_SIZE = ?, DB_CAPACITY = ? WHERE SNAPSHOT_TIMESTAMP = ?
2	0	0	0	0	0	0	0	0	0	0	0	select sum(TBSP_USED_SIZE_KB)/1024 DB_SIZE_MB, sum(TBSP_TOTAL_SIZE_KB)/1024 DB_CAPACITY_MB from sysibmadm.TBSP_UTILIZATION with ur
1	0	0	0	0	0	0	0	0	0	0	0	SELECT USER FROM "SYSIBM".DUAL
1	0	0	0	0	0	0	0	0	0	0	0	select tabschema, tabname, isnull(stats_time,' ') stats_time from syscat.tables where stats_time is null and tabschema not like 'SYS%' fetch first 30 rows only with ur

● TOP 10:AVG SORTS NUM

NUM_EXECUTIONS	TOTAL_USR_CPU_TIME	TOTAL_USR_CPU_TIME_MS	TOTAL_SYS_CPU_TIME	TOTAL_SYS_CPU_TIME_MS	TOTAL_EXEC_TIME	TOTAL_EXEC_TIME_MS	ROWS_READ	ROWS_WRITTEN	STMT_SORTS	AVG_STMT_SORTS	SORT_OVERFLOWS	TOTAL_SORT_TIME	STMT_TEXT
2	0	0	0	0	0	0	0	0	0	.00	0	0	SELECT ROUTINESCHEMA, ROUTINENAME FROM SYSCAT.ROUTINES WHERE ROUTINENAME LIKE ? WITH UR
214	0	0	0	0	0	0	0	0	0	.00	0	0	call SYSIBM.SQLCAMESSAGECCSID(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
2	0	0	0	0	0	0	0	0	0	.00	0	0	SELECT COUNT(DISTINCT NODENUM) FROM SYSIBM.SYSNODEGROUPDEF
3	0	0	0	0	0	0	0	0	0	.00	0	0	SELECT * FROM SYSCAT.TABLES T , SYSCAT.VIEWS V WHERE V.VIEWSCHEMA = ? AND T.TABSCHEMA = V.VIEWSCHEMA AND T.TABNAME = V.VIEWNAME AND T.TYPE IN ('V','W') ORDER BY T.TABNAME WITH UR
16	0	0	0	0	0	0	0	0	0	.00	0	0	SELECT POLICY FROM SYSTOOLS.POLICY WHERE MED='DB2TableMaintenanceMED' AND DECISION='TableRunstatsDecision' AND NAME='TableRunstatsPolicy'
6	0	0	0	0	0	0	0	0	0	.00	0	0	SELECT * FROM SYSCAT.TABLES T , SYSCAT.VIEWS V WHERE V.VIEWSCHEMA = ? AND V.VIEWNAME = ? AND T.TABSCHEMA = V.VIEWSCHEMA AND T.TABNAME = V.VIEWNAME AND T.TYPE IN ('S') WITH UR
10	0	0	0	0	0	0	0	0	0	.00	0	0	SELECT * FROM SYSCAT.INDEXES WHERE INDSCHEMA = ? AND INDNAME = ? WITH UR
1806	0	0	0	0	0	0	0	0	0	.00	0	0	SET TENANT ?
6	0	0	0	0	0	0	0	0	0	.00	0	0	UPDATE SYSTOOLS.STMG_DBSIZE_INFO SET SNAPSHOT_TIMESTAMP = ?, DB_SIZE = ?, DB_CAPACITY = ? WHERE SNAPSHOT_TIMESTAMP = ?
2	0	0	0	0	0	0	0	0	0	.00	0	0	select sum(TBSP_USED_SIZE_KB)/1024 DB_SIZE_MB, sum(TBSP_TOTAL_SIZE_KB)/1024 DB_CAPACITY_MB from sysibmadm.TBSP_UTILIZATION with ur

● TOP 10:TOTAL SORTS TIME

NUM_EXECUTIONS	TOTAL_USR_CPU_TIME	TOTAL_USR_CPU_TIME_MS	TOTAL_SYS_CPU_TIME	TOTAL_SYS_CPU_TIME_MS	TOTAL_EXEC_TIME	TOTAL_EXEC_TIME_MS	ROWS_READ	ROWS_WRITTEN	STMT_SORTS	SORT_OVERFLOWS	TOTAL_SORT_TIME	STMT_TEXT
2	0	0	0	0	0	0	0	0	0	0	0	SELECT ROUTINESCHEMA, ROUTINENAME FROM SYSCAT.ROUTINES WHERE ROUTINENAME LIKE ? WITH UR
1	0	0	0	0	0	0	0	0	0	0	0	CREATE OR REPLACE VIEW ABC AS select DBPARTITIONNUM, (1-(CAT_CACHE_INSERTS/CAT_CACHE_LOOKUPS))*100 percent, CAT_CACHE_OVERFLOWS from sysibmadm.snapdb with ur
1	0	0	0	0	0	0	0	0	0	0	0	CREATE OR REPLACE VIEW ABC AS select INDSCHEMA, INDNAME, TABSCHEMA, TABNAME, COMPRESS_ATTR, INDEX_COMPRESSED, INDEX_PARTITIONING, INDEX_REQUIRES_REBUILD, LARGE_RIDS from TABLE(sysproc.admin_get_index_info('','','')) where INDEX_REQUIRES_REBUILD='Y' with ur
1806	0	0	0	0	0	0	0	0	0	0	0	SET TENANT ?
1	0	0	0	0	0	0	0	0	0	0	0	CREATE OR REPLACE VIEW ABC AS select DBPARTITIONNUM, PKG_CACHE_INSERTS, PKG_CACHE_LOOKUPS, 1-dec((double(PKG_CACHE_INSERTS)/double(PKG_CACHE_LOOKUPS)),6,4) AS PKG_HIT from sysibmadm.snapdb with ur
1	0	0	0	0	0	0	0	0	0	0	0	select PKGSCHEMA, PKGNAME, valid from syscat.packages
6	0	0	0	0	0	0	0	0	0	0	0	UPDATE SYSTOOLS.STMG_DBSIZE_INFO SET SNAPSHOT_TIMESTAMP = ?, DB_SIZE = ?, DB_CAPACITY = ? WHERE SNAPSHOT_TIMESTAMP = ?
2	0	0	0	0	0	0	0	0	0	0	0	select sum(TBSP_USED_SIZE_KB)/1024 DB_SIZE_MB, sum(TBSP_TOTAL_SIZE_KB)/1024 DB_CAPACITY_MB from sysibmadm.TBSP_UTILIZATION with ur
1	0	0	0	0	0	0	0	0	0	0	0	SELECT USER FROM "SYSIBM".DUAL
1	0	0	0	0	0	0	0	0	0	0	0	select tabschema, tabname, isnull(stats_time,' ') stats_time from syscat.tables where stats_time is null and tabschema not like 'SYS%' fetch first 30 rows only with ur