<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/cmljts0270</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; cmljts0270]]></copyright><item><title><![CDATA[Q复制的一篇好文章]]></title><link>https://blog.youkuaiyun.com/cmljts0270/article/details/100299015</link><guid>https://blog.youkuaiyun.com/cmljts0270/article/details/100299015</guid><author>cmljts0270</author><pubDate>Mon, 31 Dec 2018 23:35:04 +0800</pubDate><description><![CDATA[今天看了Q复制的一篇好文章，其中的检查Q复制中的一些错误的脚本尤其好，可以作为以后工作过程中的一个工具了。



https://developer.ibm.com/recipes/tutorials/q-repli...]]></description><category></category></item><item><title><![CDATA[给虚拟机的增加空间]]></title><link>https://blog.youkuaiyun.com/cmljts0270/article/details/100299045</link><guid>https://blog.youkuaiyun.com/cmljts0270/article/details/100299045</guid><author>cmljts0270</author><pubDate>Tue, 04 Dec 2018 12:50:42 +0800</pubDate><description><![CDATA[[root@mqserver ~]# fdisk -l


Disk /dev/sda: 16.1 GB, 16106127360 bytes, 31457280 sectors

Units = sectors ...]]></description><category></category></item><item><title><![CDATA[在虚拟机中安装ftp]]></title><link>https://blog.youkuaiyun.com/cmljts0270/article/details/100299034</link><guid>https://blog.youkuaiyun.com/cmljts0270/article/details/100299034</guid><author>cmljts0270</author><pubDate>Tue, 04 Dec 2018 11:36:41 +0800</pubDate><description><![CDATA[安装ftp

yum -y install vsftpd 



查看

vsftpd -v


取消匿名登陆

修改vsftpd.conf文件

vi /etc/vsftpd/vsftpd....]]></description><category></category></item><item><title><![CDATA[DBA 那么多命令]]></title><link>https://blog.youkuaiyun.com/cmljts0270/article/details/100299008</link><guid>https://blog.youkuaiyun.com/cmljts0270/article/details/100299008</guid><author>cmljts0270</author><pubDate>Tue, 30 Oct 2018 17:58:12 +0800</pubDate><description><![CDATA[对于很多DBA来说，记住很多命令是一件很头疼的事情，尤其是在客户现场，用命令行解决问题的时候。

如果你没有达到那种精确记忆的水准，还是有一些办法来解决这个问题的，就拿DB2来说，你想做一个snapshot，但是命令有点...]]></description><category></category></item><item><title><![CDATA[pkg cache stmt包罗万象]]></title><link>https://blog.youkuaiyun.com/cmljts0270/article/details/100299018</link><guid>https://blog.youkuaiyun.com/cmljts0270/article/details/100299018</guid><author>cmljts0270</author><pubDate>Mon, 29 Oct 2018 15:21:04 +0800</pubDate><description><![CDATA[--执行时间长的SQL

select stmt_exec_time, num_executions, stmt_text

from table(mon_get_pkg_cache_stmt(null,null,n...]]></description><category></category></item><item><title><![CDATA[db2 reorg,runstats]]></title><link>https://blog.youkuaiyun.com/cmljts0270/article/details/100298984</link><guid>https://blog.youkuaiyun.com/cmljts0270/article/details/100298984</guid><author>cmljts0270</author><pubDate>Mon, 29 Oct 2018 14:58:22 +0800</pubDate><description><![CDATA[db2 -x "select 'reorgchk update statistics on table ' || rtrim(tabschema)||'.'||rtrim(tabname) || ';' from sysca...]]></description><category></category></item><item><title><![CDATA[一次DB2 DR演练]]></title><link>https://blog.youkuaiyun.com/cmljts0270/article/details/100299020</link><guid>https://blog.youkuaiyun.com/cmljts0270/article/details/100299020</guid><author>cmljts0270</author><pubDate>Sat, 13 Oct 2018 21:35:41 +0800</pubDate><description><![CDATA[1个Primary(TSA) ， 1个Standby做HA(TSA)， 1个Standby做DR的情况，数据库带dprop capture和apply


今天做DR演练，当fail back到Primary的时候，执...]]></description><category></category></item><item><title><![CDATA[Python Uses ibm_db connect to DB2]]></title><link>https://blog.youkuaiyun.com/cmljts0270/article/details/100299035</link><guid>https://blog.youkuaiyun.com/cmljts0270/article/details/100299035</guid><author>cmljts0270</author><pubDate>Thu, 11 Oct 2018 15:18:15 +0800</pubDate><description><![CDATA[安装好了Python和ibm_db以后，做了几个小例子测试一下


&gt;&gt;&gt; import ibm_db

&gt;&gt;&gt; ibm_db.__version__

'2.0.9'
...]]></description><category></category></item><item><title><![CDATA[AIX的yum安装]]></title><link>https://blog.youkuaiyun.com/cmljts0270/article/details/100298983</link><guid>https://blog.youkuaiyun.com/cmljts0270/article/details/100298983</guid><author>cmljts0270</author><pubDate>Tue, 09 Oct 2018 21:53:33 +0800</pubDate><description><![CDATA[之前在AIX上安装yum是按照步骤一步步来做，今天找到一个脚本，可以很方便的执行脚本来做


ftp://ftp.software.ibm.com/aix/freeSoftware/aixtoolbox/ezinsta...]]></description><category></category></item><item><title><![CDATA[安装c, c++编译器 on AIX]]></title><link>https://blog.youkuaiyun.com/cmljts0270/article/details/100299004</link><guid>https://blog.youkuaiyun.com/cmljts0270/article/details/100299004</guid><author>cmljts0270</author><pubDate>Tue, 09 Oct 2018 21:49:40 +0800</pubDate><description><![CDATA[安装xlc编译器 可以参考 https://www.ibm.com/developerworks/cn/aix/library/au-c_installation/index.html

默认安装路径是： /opt/IB...]]></description><category></category></item><item><title><![CDATA[Install python on AIX 7]]></title><link>https://blog.youkuaiyun.com/cmljts0270/article/details/100298982</link><guid>https://blog.youkuaiyun.com/cmljts0270/article/details/100298982</guid><author>cmljts0270</author><pubDate>Mon, 08 Oct 2018 17:21:32 +0800</pubDate><description><![CDATA[Download python install software from website http://www.aixtools.net/index.php/Packages

ftp pyton install so...]]></description><category></category></item><item><title><![CDATA[db2 hadr_spool_limit]]></title><link>https://blog.youkuaiyun.com/cmljts0270/article/details/100299054</link><guid>https://blog.youkuaiyun.com/cmljts0270/article/details/100299054</guid><author>cmljts0270</author><pubDate>Sat, 29 Sep 2018 22:36:16 +0800</pubDate><description><![CDATA[如果DB2 HADR的standby端的log replay很慢，很容易导致standby端的HADR receive buffer, HADR TCP receive buffer满,从而导致Primary端发的

消...]]></description><category></category></item><item><title><![CDATA[DB2 WLM]]></title><link>https://blog.youkuaiyun.com/cmljts0270/article/details/100299012</link><guid>https://blog.youkuaiyun.com/cmljts0270/article/details/100299012</guid><author>cmljts0270</author><pubDate>Fri, 28 Sep 2018 14:17:18 +0800</pubDate><description><![CDATA[最近遇到一个问题，一个不合理的SQL运行占用了400G的临时表空间，差点把数据库搞down，因此对某些用户的查询要做限制，我这里限制条件


1.返回1百万和记录



or


2 .运行时间超过30分...]]></description><category></category></item><item><title><![CDATA[几种常见的NO SQL DB]]></title><link>https://blog.youkuaiyun.com/cmljts0270/article/details/100298981</link><guid>https://blog.youkuaiyun.com/cmljts0270/article/details/100298981</guid><author>cmljts0270</author><pubDate>Wed, 26 Sep 2018 14:02:16 +0800</pubDate><description><![CDATA[NO SQL数据库


Key value类型的

riak

redis

memcached

Oracle Berkeley DB

Hamster DB (embedded database...]]></description><category></category></item><item><title><![CDATA[DB2 HADR takeover 问题 SQL1387W]]></title><link>https://blog.youkuaiyun.com/cmljts0270/article/details/100299001</link><guid>https://blog.youkuaiyun.com/cmljts0270/article/details/100299001</guid><author>cmljts0270</author><pubDate>Sat, 22 Sep 2018 19:33:24 +0800</pubDate><description><![CDATA[今天做DB2 HADR takeover的时候遇到一个问题



SQL1387W A DB2 High Availability Disaster Recovery (HADR)



takeover ...]]></description><category></category></item><item><title><![CDATA[DB2 HADR的heartbeat检测]]></title><link>https://blog.youkuaiyun.com/cmljts0270/article/details/100299030</link><guid>https://blog.youkuaiyun.com/cmljts0270/article/details/100299030</guid><author>cmljts0270</author><pubDate>Fri, 21 Sep 2018 21:22:37 +0800</pubDate><description><![CDATA[DB2的Primary和Standby之间是通过发送心跳信号来检测对方是否存在的

与此心跳有关的几个db2pd -db xxx -hadr 监控指标

HEARTBEAT_INTERVAL(seconds) =...]]></description><category></category></item><item><title><![CDATA[DB2查看索引的使用情况]]></title><link>https://blog.youkuaiyun.com/cmljts0270/article/details/100298999</link><guid>https://blog.youkuaiyun.com/cmljts0270/article/details/100298999</guid><author>cmljts0270</author><pubDate>Fri, 21 Sep 2018 16:47:35 +0800</pubDate><description><![CDATA[db2pd可以查看应用对数据库中的表和索引的访问情况

db2pd -db dbname -tcbstats all -file db2pd_tab_all.txt

有时候，你只想查看对某一个表和其上的索引的访问情...]]></description><category></category></item><item><title><![CDATA[DB2 和SQL Server自增列比较]]></title><link>https://blog.youkuaiyun.com/cmljts0270/article/details/100298998</link><guid>https://blog.youkuaiyun.com/cmljts0270/article/details/100298998</guid><author>cmljts0270</author><pubDate>Fri, 21 Sep 2018 14:57:58 +0800</pubDate><description><![CDATA[最近由于对SQL Server的自增列理解不够好，导致了一个设计问题，做了2个小例子解释一下


SQL Server的自增列

create table identitytest(

 id int...]]></description><category></category></item><item><title><![CDATA[把Oracle的命令输出发送到文件的命令]]></title><link>https://blog.youkuaiyun.com/cmljts0270/article/details/100299032</link><guid>https://blog.youkuaiyun.com/cmljts0270/article/details/100299032</guid><author>cmljts0270</author><pubDate>Tue, 18 Sep 2018 15:57:50 +0800</pubDate><description><![CDATA[set echo off

set heading off 

set verify off 

set feedback off 

set show off 

set trim off 

se...]]></description><category></category></item><item><title><![CDATA[Oracle查看执行计划的命令]]></title><link>https://blog.youkuaiyun.com/cmljts0270/article/details/100299029</link><guid>https://blog.youkuaiyun.com/cmljts0270/article/details/100299029</guid><author>cmljts0270</author><pubDate>Tue, 18 Sep 2018 15:56:09 +0800</pubDate><description><![CDATA[在SQL*PLUS(PL/SQL的命令窗口和SQL窗口均可)下执行下面步骤

EXPLAIN PLAN FOR

SELECT XXX FROM DUAL;

set linesize 4000;

set ...]]></description><category></category></item></channel></rss>