DB2设置配置项

1. db2set

用法：

• db2set with no variable name displays all defined variables.
• db2set <variable> displays <variable>'s value.
• db2set <variable>= (nothing) deletes the <variable>.
• db2set <variable>=<value> modifies the <variable>'s value.
• db2set <variable> -null sets <variable>'s value to NULL.
• db2set <variable> -all displays all defined <variable>'s values.
• db2set -ur refreshes the current user profile.
• db2set <variable> -ul displays defined <variables> at the user level.
• db2set -all displays all defined variables in all registry levels.

2. db2 database manager configuration

查询

$ db2 get dbm cfg | grep <CONFIG-NAME>

设置

$ db2 update dbm cfg using <CONFIG-NAME> <CONFIG-VALUE>

清除

$ db2 update dbm cfg using <CONFIG-NAME> NULL

参考的是设置语法，除了<CONFIG-VALUE>必须是大写的NULL。