db2 get database configuration fordatabase_name 其中,database_name是資料庫的名稱。 例如,下列輸出顯示目錄伺服器實例ldapdb2的預設值: db2 get database configuration for ldapdb2 | egrep'HEAP|MAXLOCKS|MINCOMMIT' Percent. of lock lists per application (MAXLOCKS) = AUTOMATIC(98) Sort heap thres for...
Specifies the alias of the database whose configuration is to be displayed. You do not need to specify the alias if a connection to the database already exists. SHOW DETAIL Displays detailed information showing the current value of database configuration parameters as well as the value of the ...
get database configuration for sample or get db cfg for sample 如何將数据库SAMPLE的参数设置为默认数值? reset database configuration for sample or reset db cfg for sample 如何修改数据库SAMPLE配置参数数值? update database configuration for sample using <parameter name> <new value> or update db cf...
GET DATABASE CONFIGURATIONFORABC 73.如何将数据库ABC的参数设置为默认数值? RESET DATABASECONFIGURATIONFORABC 74.如何修改数据库ABC配置参数数值? UPDATE DATABASE CONFIGURATIONFORABC USING 75.如何重新启动数据库? RESTART DATABASE DATABASE_NAME 76.如何激活数据库? ACTIVATE DATABASE DATABASE_NAME 77.如何停止...
get database configuration for sample or get db cfg for sample 如何將数据库SAMPLE的参数设置为默认数值? reset database configuration for sample or reset db cfg for sample 如何修改数据库SAMPLE配置参数数值? update database configuration for sample ...
get database configuration for sample or get db cfg for sample 如何將数据库SAMPLE的参数设置为默认数值? reset database configuration for sample or reset db cfg for sample 如何修改数据库SAMPLE配置参数数值? update database configuration for sample ...
Log Space Configuration If the FineDB data volume is too large and the log space is insufficient, errors (SQLCODE=-964, SQLSTATE=57011) may occur during configuration. Therefore, the log space must be sufficient. get database configuration for DATABASENAME View the log configuration. The recomm...
[db2inst2@cognoswithdb2~]$ db2getdb cfgforsample Database ConfigurationforDatabase sample Database configuration release level=0x1000Database release level=0x1000Database territory=USDatabase code page=1208Database code set=UTF-8Database country/region code=1Database collating sequence=IDENTITYAlternat...
STEP 1修改trackmod 参数为on状态C: acunents and SettinsSAdninistratDrdb2 update db cfsf for ncc usinsr yesDB2aaa0T update database configuration 命今戒功気成VSQL13&3 21、W为i即修改而提交旳一个或多个参数耒动态更改.对于这些配置参数,有应用程序都与此数据库断开生按之后,更改才会主效。STEP ...
[db2inst1@enmodb2 ~]$ db2 connect to coco Database Connection Information Database server = DB2/LINUXX8664 10.5.9 SQL authorization ID = DB2INST1 Local database alias = COCO [db2inst1@enmodb2 ~]$ db2 get db cfg Database Configuration for Database Database configuration release level =...