<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[weixin36的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/weixin36</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; weixin36]]></copyright><item><title><![CDATA[libstdc++.so.5]]></title><link>https://blog.youkuaiyun.com/weixin36/article/details/84413881</link><guid>https://blog.youkuaiyun.com/weixin36/article/details/84413881</guid><author>weixin36</author><pubDate>Sat, 30 Mar 2013 11:05:54 +0800</pubDate><description><![CDATA[在centOs装DB2，出错报说是少libstdc++.so.5，公司机器不能联网，只能找安装包，
好不容易找到了，留下来，以防以后使用

可以联网的话，
   # yum whatprovides libstdc++.so.5
    # yum install compat-libstdc++-33

不能联网的话，可使用附件rpm包
# rpm -ivh xxxxxxxxxx...]]></description><category></category></item><item><title><![CDATA[DB2 除法]]></title><link>https://blog.youkuaiyun.com/weixin36/article/details/84377456</link><guid>https://blog.youkuaiyun.com/weixin36/article/details/84377456</guid><author>weixin36</author><pubDate>Mon, 07 Jan 2013 10:22:10 +0800</pubDate><description><![CDATA[select cast(1 as float)/3 from XXXX
结果：0.333333333333333

select 1/3 from XXXX
结果：0

select 1.0 / 3 from XXXX
结果：0.3333333333333333333333333333

[url]http://blog.youkuaiyun.com/dlodj/article/detail...]]></description><category></category></item><item><title><![CDATA[DB2修改日志模式报 SQLSTATE=57019]]></title><link>https://blog.youkuaiyun.com/weixin36/article/details/84377010</link><guid>https://blog.youkuaiyun.com/weixin36/article/details/84377010</guid><author>weixin36</author><pubDate>Sun, 06 Jan 2013 13:41:03 +0800</pubDate><description><![CDATA[总结一下
DB2 默认为循环归档，根据应用要求调整为日志归档模式

=============================================
修改之后启动时报错
SQL1116N  A connection to or activation of database &quot;XXX&quot; cannot be made 
because of BACKUP PENDING.  SQ...]]></description><category></category></item><item><title><![CDATA[DB2 Sqlstate: 40001 发生了伴随自动回滚的超时或死锁]]></title><link>https://blog.youkuaiyun.com/weixin36/article/details/84283928</link><guid>https://blog.youkuaiyun.com/weixin36/article/details/84283928</guid><author>weixin36</author><pubDate>Wed, 05 Sep 2012 16:23:01 +0800</pubDate><description><![CDATA[DB2 Sqlstate: 40001 发生了伴随自动回滚的超时或死锁

在客户端执行一个很简单的update的，不知道怎么的老是报40001，google下发现可能是表被锁住了，所以导致无法更新。...]]></description><category></category></item><item><title><![CDATA[DBI1501E during db2setup on LINUX]]></title><link>https://blog.youkuaiyun.com/weixin36/article/details/84278008</link><guid>https://blog.youkuaiyun.com/weixin36/article/details/84278008</guid><author>weixin36</author><pubDate>Fri, 24 Aug 2012 13:48:20 +0800</pubDate><description><![CDATA[QuestionWhy do I get the message DBI1501E during the db2setup of V9.5 on AIX 6.1? 

Cause
The common reason for DBI1501E message is a problem with DNS (Domain Name Server), one of these is happenin...]]></description><category></category></item><item><title><![CDATA[关于merge into 的使用认识]]></title><link>https://blog.youkuaiyun.com/weixin36/article/details/84277380</link><guid>https://blog.youkuaiyun.com/weixin36/article/details/84277380</guid><author>weixin36</author><pubDate>Thu, 23 Aug 2012 10:51:55 +0800</pubDate><description><![CDATA[之前不是很常使用merge into这个方法，最近因为有需求，研究了了一下，留个记录方便以后自己再用。

MERGE [INTO [schema .] table [t_alias] 
USING [schema .] { table | view | subquery } [t_alias] 
ON ( condition ) 
WHEN MATCHED THEN merge_upda...]]></description><category></category></item><item><title><![CDATA[DB2导入大数据量时遇到问题]]></title><link>https://blog.youkuaiyun.com/weixin36/article/details/84276206</link><guid>https://blog.youkuaiyun.com/weixin36/article/details/84276206</guid><author>weixin36</author><pubDate>Tue, 21 Aug 2012 10:06:47 +0800</pubDate><description><![CDATA[一般导DB2数据时，直接就使用load的方法，很是方便，但最近到一张很大的表的数据大概3个多G，导了一天一夜都没反应，然后就是各种纠结。。。，还好最后找到解决方法了
方法如下：
db2 &quot;import FROM 'xxxx.txt' OF DEL MODIFIED by compound=100 commitcount 10000 insert INTO  &quot;


参数：compound...]]></description><category></category></item><item><title><![CDATA[ DB2 SQL Error: SQLSTATE=54048的原因及解决方法 ]]></title><link>https://blog.youkuaiyun.com/weixin36/article/details/84274762</link><guid>https://blog.youkuaiyun.com/weixin36/article/details/84274762</guid><author>weixin36</author><pubDate>Fri, 17 Aug 2012 13:09:34 +0800</pubDate><description><![CDATA[[size=large]54048 具有足够页大小的临时表空间不存在[/size]

原因：一般是执行的数据比较大，临时表空间不够

解决方法：新建临时表空间
1.Create Bufferpool  Size 32 Pagesize 32768
2.CREATE TEMPORARY TABLESPACE IN DATABASE PARTITION GROUP IBMTEMPGROUP...]]></description><category></category></item><item><title><![CDATA[DB2 SQL Error: SQLCODE=-964, SQLSTATE=57011的原因及解决方法]]></title><link>https://blog.youkuaiyun.com/weixin36/article/details/84274646</link><guid>https://blog.youkuaiyun.com/weixin36/article/details/84274646</guid><author>weixin36</author><pubDate>Fri, 17 Aug 2012 09:27:55 +0800</pubDate><description><![CDATA[[size=large]DB2 SQL Error: SQLCODE=-964, SQLSTATE=57011的原因及解决方法[/size]
原因：该数据库的日志文件已满

解决办法：加大日志文件大小，增加日志文件个数，增加辅助日志文件个数

查看配置参数命令：get db cfg for ;

修改配置参数命令：

修改日志文件大小：update db cfg for  usi...]]></description><category></category></item></channel></rss>