欢迎您的来访！

db2 GET RECOMMENDATIONS FOR HEALTH INDICATOR db.deadlock_ratedb2 GET DESCRIPTION FOR HEALTH INDICATOR db.deadlock_rate$ db2 GET DESCRIPTION FOR HEALTH INDICATOR db.deadlock_rateDESCRIPTION

测试环境： aix 6.1 + db2 v9.5ALTER TABLE table_name ALTER COLUMN column_name SET DATA TYPE CLOB ( 3M ) ;

select * from viewname 做查询的时候报错SQL0575N View or materialized query table "DB2INST1.LATEFEEVIEW" cannot be used because it has been marked inoperative. SQLSTATE=51024通过查询syscat.tables确认，哪些视图是无效的状态se

db2 jdbc db2jcc.jar db2jcc4.jar

DIAGSIZE 设为 1024MB（1GB）。这允许 DB2 创建至多 10 个 10MB 的管理通知日志文件和至多 10 个 90MB 的诊断日志文件IBM官网 关于db2 v9.7 诊断日志的论述

近日巡检发现db2diag.log经常有类似如下报错，2015-07-01-10.27.35.993282+480 E4715A711 LEVEL: Error (OS)PID : 3489924 TID : 1 PROC : db2bpINSTANCE: db2inst1 NODE : 000A

DDL = Data Definition Language DML = Data Manipulation Language DCL = Data Control Language

1、DB2中：nextval for seq_test例如：values nextval for seq_test;2、select * from syscat.sequences

db2 支持truncate命令清空表，测试的环境为v9.7和v10.5

db2leveldb2licm -vdb2pd -v lslpp -l |grep db2 (AIX)