ITPub博客

手动漂移scan ip：[grid@rac1 ~]$ srvctl relocate scan_listener -i 1 -n rac1手工漂移vip：[grid@rac1 ~]$ srvctl relocate vip -i rac1 -n rac2 -f -vVIP was relocated successfully.[grid@rac1 ~]$ srvctl relocate vip -i rac1 -n rac1 -f -vVIP was relocated successfully

[db2inst1@db21 tbs1]$ db2 "create large tablespace tbs1 managed by system using('/tbs1/')" DB21034E  The command was processed as an SQL statement because it was not a valid Command Line Processor command.  During SQL processing it returned:SQL0288N  The statement failed ...

power  cpu:mem  1:8 cpu:dbsize 1:300~500GBx86cpu:mem 1:4cpu:dbsize 1:200~300GB

CREATE DATABASE PERFDB  AUTOMATIC STORAGE YES  ON '/db2data' DBPATH ON '/db2data/db2inst1'  ALIAS PERFDB  USING CODESET GBK TERRITORY CN  COLLATE USING SYSTEM  PAGESIZE 8192   NUMSEGS 1  DFT_EXTENT_SZ 32  CATALOG TABLESPACE    MAN...

Restrictions for high availability disaster recovery (HADR)

EXAMPLES: Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log  Backup ID -- --- ------------------ ---- --- ------------ ------------ --------------  B  D  20171130230002001   N    D  S0034060.LOG S0034062.LOG   -----------...

   DB2_HADR_BUF_SIZE操作系统：所有操作系统缺省值：2*logbufsz此变量指定备用日志接收缓冲区大小（以日志页为单位）。如果未设置此变量，那么 DB2 将主要 logbufsz 配置参数值的两倍大小用作备用接收缓冲区大小。可以指定的最大大小是 4 GB。应该在备用实例中设置...

对于动态数据仓储、主控方数据管理、应用程序合并或迁移、运营 BI 以及启用 SOA 项目之类的关键信息管理活动，CDC Replication 能够以影响性较低的方式捕获数据更改并高速传递这些更改。另外，通过仅发送更改的数据，CDC Replication 还可以帮助降低处理开销和网络流量。复制可连续执行，也可定期执行。数据从...

 [sql] view plain copy print?scott@DEVDB> select * from v$version where rownum<2;    BANNER  -------------------------------------------------------------...

srvctl 添加监听的语法如下:grid@rac1:/home/grid>srvctl add listener -h将监听程序配置添加到 Oracle Clusterware。用法: srvctl add listener [-l <lsnr_name>] [-s] [-p "[TCP:]<port>[, ...][/IPC:<key>][/NMP:...

yum -y install libstdc*i686 pam*i686 gcc* kernel-devel sg3_utils* sg_persist* [root@onekey server_t]# ./db2prereqcheck -v 10.5.0.8                                               &...

vi .bashrcalias cp='cp -i'alias egrep='egrep --color=auto'alias fgrep='fgrep --color=auto'alias grep='grep --color=auto'alias l.='ls -d .* --color=auto'alias ll='ls -l --color=auto'alias ls='ls --color=auto'alias mv='mv -i'alias rm='rm -i'alias which='alias | /usr/bin/which --tty-only --r...

环境: db2v9.7,  RedHat 5首先创建一个目录用于存放事件监控，例：[db2inst1@esi-202 ~]$ mkdir emondir创建一个sql语句的事件监控[db2inst1@esi-202 ~]$ db2 "create event monitor emon1 for statements writ...

https://www-01.ibm.com/marketing/iwm/iwm/web/reg/download.do?source=swg-rddsm&S_PKG=ov35121&S_CMP=web_dw_rt_swd&lang=zh_CN&cp=UTF-8&S_TACT=000000VY&dlmethod=http

linux下查看最消耗CPU、内存的进程 1.CPU占用最多的前10个进程：ps auxw|head -1;ps auxw|sort -rn -k3|head -102.内存消耗最多的前10个进程ps auxw|head -1;ps auxw|sort -rn -k4|head -103.虚拟内存使用最多的前10个进程ps auxw|head -1;ps auxw|sort -rn -k5|head -10...

cd $ORACLE_HOMEcd sqlplus cd adminvi globin.sql加入set sqlprompt '&_USER.@&_CONNECT_IDENTIFIER.>'