深入理解mysqldump原理 --single-transaction --lock-all-tables --master-data
mysql搭建主从
The Db2 Recovery History File
The Db2 Recovery History File
linux修改系统参数
linux修改系统参数
nbu8.1测试版下载
nbu8.1测试版下载
Oracle psu查询
oracle psu查询
oracle最新补丁查询
oracle 补丁查询
oracle关闭状态删除活动日志报错恢复(一)
oracle关闭状态删除活动日志报错恢复
db2 清空表导致表出现Unavailable
db2 清空表导致表出现Unavailable
DB2 Performance Tips
DB2 Performance Tips
db2常用动态性能视图
db2常用动态性能视图
db2 构造测试数据
db2 构造测试数据
admin_move_table在线更改分区键
db2 "call sysproc.admin_move_table('RECV','TRANS_SERIAL_TABLE','','','','','','(CREATE_TIME) (PART PART1 STARTING (''2000-01-01'') ENDING (''2001-01-01'') EXCLUSIVE,PART PART2 STARTING (''2001-01-01'') ENDING (''2002-01-01'') EXCLUSIVE)','','','MOVE')"CREATE TABLE "RECV &nb...
oracle dblink用法总结和expdp和impdp利用dblink倒入导出到本地
oracle dblink用法总结和expdp和impdp利用dblink倒入导出到本地
CDC linux安装报错
需要安装32位的glibcyum -y install glibc*i686
admin_move_table在新添加删除字段
[db2inst1@dbmon ~]$ db2 connect to ibm Database Connection Information Database server = DB2/LINUXX8664 10.5.8 SQL authorization ID = DB2INST1 Local database alias = IBM[db2inst1@dbmon ~]$ db2 "create table xpf(...
linux udev裸设备绑定
KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="36000c29a340c7c2dc0a2c8248246121e", NAME="asm-crs1",OWNER="grid", GROUP="dba", MODE="0660"KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whit...
zabbix检查项
./zabbix_get -s 116.62.56.139 -p 10050 -k "db2status.status[APP_EXECUTING]"./zabbix_get -s 116.62.56.139 -p 10050 -k "db2status.status[AVG_DIRECT_READTIME]"./zabbix_get -s 116.62.56.139 -p 10050 -k "db2status.status[AVG_DIRECT_WRITETIME]"./zabbix_get -s 116.62.56.139 -p 10050 -k "db2status.status...
zabbix客户端无法启动并且没有日志
[root@dbmon etc]# service zabbix_agentd status● zabbix_agentd.service - SYSV: Starts and stops Zabbix Agent using chkconfig Loaded: loaded (/etc/rc.d/init.d/zabbix_agentd; bad; vendor preset: disabled) Active: active (exited) since Mon 2018-01-29 21:58:06 CST; 2min 24s ag...
centos6禁用ipv6
前三步骤可行,亲测可以centos6.5禁用IPv6IPv6还没有完全普及,但是安装完系统之后IPv6是有效的,在一定程度上影响网络性能,所以在我们在完全不使用IPv6的情况下,最好关闭IPv6。其实在上一篇网络设置的文章中,我们提到过是否激活IPv6,但是只是那一点设置还是不能完全关闭IPv6,所以本文以完整的步骤叙述一下如何关闭...
opatch rollback
[oracle@rman1 26925576]$ /u01/app/oracle/product/11204/oracle/OPatch/opatch rollback -id 26925576Oracle Interim Patch Installer version 11.2.0.3.17Copyright (c) 2018, Oracle Corporation. All rights reserved.Oracle Home : /u01/app/oracle/product/11204/oracleCentral ...