DB2-常用命令

最新推荐文章于 2023-06-01 09:41:46 发布

编程秀

最新推荐文章于 2023-06-01 09:41:46 发布

阅读量378

点赞数

分类专栏： 02-Database 文章标签： db2

本文链接：https://blog.csdn.net/kevin12306/article/details/110127117

版权

26 篇文章 1 订阅

订阅专栏

db2 connect to database_name

db2 list tablespaces show detail

db2 get db cfg for sample

db2pd -d sample -tablespaces

db2set DB2_COMPATIBILITY_VECTOR=ORA

db2stop force

db2start

db2 "force application (11348)"

   1. db2pd -db lopdb -locks show detail
   2. SELECT * FROM TABLE (SNAP_GET_LOCK ('', -1)) AS T WHERE lock_object_type = 'TABLE_LOCK'

db2 update db cfg for lopdb using LOGFILSIZ 4096

db2 update db cfg for lopdb using LOGPRIMARY 220

db2 update db cfg for lopdb using LOGSECOND 20

LOGFILSIZ * (LOGPRIMARY + LOGSECOND)

create BUFFERPOOL slopbuff SIZE 5000 PAGESIZE 32K

CREATE TABLESPACE sloptablespace PAGESIZE 32K BUFFERPOOL slopbuff

db2 list applications show detail | grep 11348

db2 get dbm cfg
--
db2 update dbm cfg using SYSMON_GROUP {group_name}

db2 grant connect on database to user lvkc_01

db2 rename SLOP_BIZ.T_LOP_OI to T_LOP_OI_20200610
db2 update db cfg for lopdb using STMTHEAP 8192 AUTOMATIC

db2 get dbm cfg|grep SVC

tail -10 /etc/services|grep DB2_db2inst2

--netstat -lnp | grep 50000

alter table SLOP_BIZ.t_md_oi_20200701 activate not logged initially;

关注