Issue the command db2 update db CFG for icmnlsdb using trackmod on.
运行命令db2updatedb cfgfor icmnlsdb using trackmod on。
Run db2 get db cfg for dbname for the database(s) and save the result.
对数据库运行db2getdb cfgfor dbname并保存结果。
The database's code page can be determined by running "get db CFG for".
数据库的代码页可以通过运行“getdb cfg for”来确定。
Save your database configuration information as db CFG, DBM CFG, and data row counts.
将数据库配置信息保存为db cfg、d bm cfg和数据行计数。
For example, to set logretain to on, issue the command update db CFG using logretain on.
例如,要将logretain设置为on,应该发出命令updatedb cfgusing logretain on。
Finally, if you need to go back to the system default settings, issue the command reset db cfg for
最后,如果需要恢复系统默认设置,那么应该发出命令resetdb cfg for
Each database has its own configuration file, called the database configuration file (DB CFG) at the database level.
每个数据库都具有自己的数据库级配置文件,称作数据库配置文件(DB CFG)。
In order to turn to the archive log mode, simply issue the command db2 update db CFG for icmnlsdb using logretain on.
为转换到归档日志模式,只需运行命令db2updatedb cfgfor icmnlsdb using logretain on即可。
To figure out which log is active and which are archived, use the DB2 command GET DB CFG to view the 'First active log file'.
要确定哪个日志是活动的,哪些日志是归档的,请使用DB2命令GETDB CFG来查看“第一个活动日志文件”。
Should you ever change your mind about this setting, a quick way to revert is to issue the command reset db cfg for
如果想恢复这个设置,简便的方法是发出命令resetdb cfg for
Solution: check your ulimit Settings, also check the DBM CFG parameters for your instance, and the DB CFG parameters for the database.
解决方案:检查ulimit设置,还要检查实例的DBMCFG参数以及数据库的DB CFG参数。
By enabling STMM through the DB CFG parameter self_tuning_mem, you can let DB2 tune memory structures depending upon fluctuations in workload.
通过DB CFG参数self_tuning_mem启用STMM之后,您可以让DB 2根据工作负载的波动调优内存结构。
Note: Use the command db2 "get db cfg for " in order to look at these parameters and db2 "update db cfg for using ") to update a database configuration parameter.
注意:使用命令db2 "getdb cfgfor "来查看这些参数,以及使用 db2 "update db cfg forusing ") 来更新数据库配置参数。
If you would like to manually change a specific database parameter from the CLP, use the command UPDATE DB CFG FOR <database name> USING <parameter name>
如果想在CLP 中手工更改特定的数据库参数,可以使用命令UPDATEDB CFG FOR <databasename>USING <parameter name> <new value>。
As we mentioned in the previous section, instance level configuration can be done in the DBM CFG file while the database level configuration is done in the DB CFG file.
在前一节中已经提到,实例级的配置可以在DBMCFG文件中完成,而数据库级的配置在DB CFG文件中完成。
Nevertheless, to change a DB CFG parameter online, a connection to the database is mandatory, and the UPDATE DB CFG command must include the option IMMEDIATE, as shown in Listing 15.
尽管如此,要在线改变DB CFG参数,对数据库的连接是强制性的,而且UPDATE DB CFG命令必须包含IMMEDIATE选项,如清单15所示。
This section describes example scenario 4 that generates a dependency problem, and it describes how to resolve the problem by setting the DB CFG parameter AUTO_REVAL to DEFERRED_FORCE.
本节描述的示例场景4 中出现了一个依赖性问题,可通过将DB CFG 的 AUTO_REVAL参数设置为 DEFERRED_FORCE 来解决此问题。
This section describes example scenario 4 that generates a dependency problem, and it describes how to resolve the problem by setting the DB CFG parameter AUTO_REVAL to DEFERRED_FORCE.
本节描述的示例场景4 中出现了一个依赖性问题,可通过将DB CFG 的 AUTO_REVAL参数设置为 DEFERRED_FORCE 来解决此问题。
应用推荐