DB2 配置参数

-
查看DB2概要文件中已经配置的变量：db2set -all
查看DB2概要文件中所有变量：db2set -lr
修改DB2概要文件中变量：db2set <参数名>=<参数值> 例如：db2set DB2COMM=TCPIP
恢复DB2概要文件变量默认值：db2set <参数名> =           例如：db2set DB2COMM=
概要文件级别：
[e]：当前会话或环境所设置的注册库
[u]：用户级注册库
[n]：节点级注册库
[i]：实例级注册库
[g]：全局级注册库
 
设置当前实例
Linux：export DB2INSTANCE=<instance_name>
Windows：set DB2INSTANCE=<instance_name>
 
查看数据库管理器（实例）配置文件：db2 get dbm cfg
修改数据库管理器（实例）配置文件：db2 update dbm cfg using 参数名字 参数值（部分参数需要重启实例才能生效）
重置回默认值：db2 reset dbm cfg
在线更改数据库管理器（实例）配置文件：
立即生效：db2 update dbm cfg using 参数名字 参数值 immediate
重启后生效：db2 update dbm cfg using 参数名字 参数值 deferred
查看延期生效值：
db2 attach to <instance_name>
db2 get dbm cfg show detail
 
查看数据库配置文件：db2 get db cfg for 数据库名
 
修改数据库配置文件：db2 update db cfg for 数据库名 using 参数名字 参数值
 
在线更改数据库配置文件：
立即生效：db2 update db cfg for <db_name> using 参数名字 参数值 immediate
重启后生效：db2 update db cfg for <db_name> using  参数名字 参数值 deferred
查看延期生效值：
db2 connect to <db_name>
db2 get db cfg for <db_name> show detail
 
查看配置管理服务器（das）：db2 get admin cfg
修改配置管理服务器（das）：db2 update admin cfg using
重置回默认值：                            db2 reset admin cfg

Comments

Post a Comment

Popular posts from this blog

Nginx Proxy & Load Balance & LNMP

-
Nginx Proxy Service E-commerce website Server 1: provide image request response (  apache / nginx ) Server 2: provide dynamic request response ( php-fpm / apache-php ) Server 3: provide static request response ( apache / nginx ) Server 4: provide data request response ( mysql ) It need one additional nginx server 1. Install nginx 2. proxy to specific server Example location / {      proxy_pass http://192.168.199.187:80/; } location /bbs/ {      proxy_pass http://192.168.199.187:80/bbs/; } location ~* \.(jpg|png|gif)$  {      proxy_pass http://172.16.100.7; } Enhance the log information and specific the hostname location / {      proxy_pass  http://192.168.199.187:80/;      proxy_set_header <parameter name>  $host;  (client requst the hostname )      proxy_set_header <parameter name> $remote_addr; ...
Read more

Snort+barnyard2+Snorby CentOS 6.5_64 Installation

-
#download packages: daq-2.0.2.tar.gz ImageMagicK-6.8.9-8.tar.gz oinkmaster-2.0.tar.gz ruby-1.9.3-p547.tar.gz snort-2.9.6.2.tar.gz snortrules-snapshot-2962.tar.gz MySQL-server-5.5.40-1.rhel5.x86_64.rpm MySQL-client-5.6.21-1.rhel5.x86_64.rpm MySQL-devel-5.6.21-1.rhel5.x86_64.rpm MySQL-shared-5.6.21-1.rhel5.x86_64.rpm epel-release-6-8.noarch.rpm barnyard2-2.1.13.tar.gz #install yum package rpm -ivh epel-release-6-8.noarch.rpm yum install gcc-c++ patch readline readline-devel zlib zlib-devel flex git yum install libyaml-devel libffi-devel openssl-devel make  yum install bzip2 autoconf automake libtool bison iconv-devel libxml2-devel libxslt  yum install gcc g++ build-essential libssl-devel libreadline5-devel zlib1g-devel linux-headers-generic libsqlite3-devel libxslt-devel curl-devel sqlite-devel yum --enablerepo=epel install jasper jasper-libs jasper-devel #Mysql install yum remove mysql mysql-libs rpm -ivh MySQL-server-5.5.40-1.rh...
Read more

ORACLE Error

-
Image
oracle official error explanation  http://docs.oracle.com/cd/E11882_01/server.112/e17766/toc.htm 从服务器下载ALERT日志文件，传输方式需要选择"ASCII" ORA-01078: failure in processing system parameters 发生场景：新建数据库第一次启动时 SQL> startup ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file ‘/home/oracle/oracle/product/10.2.0/db_1/dbs/initorcl.ora’ 原因：oracle_sid没有配置正确 解决方案： 1. 修改oracle用户.bash_profile文件中ORACLE_SID后的内容； 2. 重新已oracle用户登录； ORA-01157: cannot identify/lock data file string - see DBWR trace file  Cause: The background process was either unable to find one of the data files or failed to lock it because the file was already in use. The database will prohibit access to this file but other files will be unaffected. However the first instance to open the database will need to access all online data files. Accompanying error from the operating system describes why the file could not be identified. Action: Have operating system make file ...
Read more