DB2 Trigger

-
1. Trigger 可以建立在view上

Comments

Post a Comment

Popular posts from this blog

Linux RHCE Preparation

-
RHCE 1. Start classroom-rh254 2. Set environment: yum install ./examrhce-0.0.1-l.el7.x86_64.rpm -y 3. Start server-rh254 4. Set lab environment: lab examrhce setup 5. Start desktop-rh254 6.  Set lab environment: lab examrhce setup 7. Check result: lab examrhcsa grade 1. Set Selinux A. Change config file: vim /etc/sysconfig/selinux B. Temporary set selinux: setenforce 1 C. Check selinux: getenforce If it used to be disabled, you need to restart to change to enforcing.  2. SSH Access Setting A. Disable the firewall for RHEL 6 i. systemctl mask iptables; ii. systemctl mask ip6tables; iii systemctl mask ebtable.service B. Start the firewall for RHEL 7 i. systemctl enable firewalld ii. systemctl start firewalld C. Set firewall rule i. Allow ssh: firewall-cmd --permanent --add-service=ssh ii. Block subnet for ssh: firewall-cmd --permanent --add-rich-rul='rule family=ipv4 source address=172.17.10.0/24 service=ssh reject' D. Reloa...
Read more

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

DB2 Error Collection

-
收集全面数据： db2support <output path> -d <database name> -s -m 将在相关路径下产生db2support.zip文件 db2diag -A： 在线切换日志（将之前日志另存为一个文件） db2diag -t 2012-03-06 -l error 查看从2012-03-06开始所有Error级别的信息 错误描述： 无法启动DB2数据库，系统报错SQL6048N [db2inst1@sdbf ~]$ db2start 05/25/2010 15:50:07 0 0 SQL6048N A communication error occurred during START or STOP DATABASE MANAGER processing. SQL1032N No start database manager command was issued. SQLSTATE=57019 原因：DB2配置文件中的主机名与系统主机名不同 解决方案： 1. 修改DB2配置文件中的主机名 例如： [commerce@wcs sqllib]$ more db2nodes.cfg 0 wcs.test.com 0 2. /etc/hosts文件中添加“IP 主机名” 错误描述： 恢复数据库后，无法连接进入数据库 db2 connect to <database name> SQL1117N A connection to or activation of database "<database name>" cannot be made because of ROLL-FORWARD PENDING. SQLSTATE=57019 原因：DB2认为需要回滚日志 解决方案： 输入命令：db2 rollforward db b2ctest1 to end of logs and stop 错误描述：启动instance后，无法 错误描述： 数据库连接超时 ERRORCODE=-4499 解决方案： db2set DB2COMM=TCPIP 错误描述 ：SQL1015N The database is in an inconsistent state. SQLSTATE=5502...
Read more