<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[cuishuobi4947的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/cuishuobi4947</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; cuishuobi4947]]></copyright><item><title><![CDATA[DB2编程序技巧]]></title><link>https://blog.youkuaiyun.com/cuishuobi4947/article/details/100463689</link><guid>https://blog.youkuaiyun.com/cuishuobi4947/article/details/100463689</guid><author>cuishuobi4947</author><pubDate>Thu, 18 Jul 2019 11:51:02 +0800</pubDate><description><![CDATA[1 DB2编程 1.1 建存储过程时CREATE 后一定不要用TAB键 3 1.2 使用临时表 3 1.3 从数据表中取指定前几条记录 3 1.4 游标的使用 4 注意commit和rollback 4 游标的两种定义方式 4 ...]]></description><category></category></item><item><title><![CDATA[DB2改服务器名字过程]]></title><link>https://blog.youkuaiyun.com/cuishuobi4947/article/details/100463678</link><guid>https://blog.youkuaiyun.com/cuishuobi4947/article/details/100463678</guid><author>cuishuobi4947</author><pubDate>Thu, 18 Jul 2019 09:39:02 +0800</pubDate><description><![CDATA[1.停止事例和数据库db2stopdb2admin stop2.改计算机名字并重启原来为ZXT修改为ZXTZ重启3.修改IBMSQLLIBDB2下的db2nodes.cfg原来为0 zxt ZXT 01 zxt ZXT 1
修...]]></description><category></category></item><item><title><![CDATA[DB2 基础: 物化查询表简介]]></title><link>https://blog.youkuaiyun.com/cuishuobi4947/article/details/100463628</link><guid>https://blog.youkuaiyun.com/cuishuobi4947/article/details/100463628</guid><author>cuishuobi4947</author><pubDate>Wed, 17 Jul 2019 20:57:02 +0800</pubDate><description><![CDATA[DB2 基础: 物化查询表简介"物化查询表（MQT）的定义是以一次查询的结果为基础的。MQT 可以显著提高查询的性能。本文将介绍 MQT、总结表（summary）和 staging 表，并通过一些实用的例子展示如何创建和使用物化...]]></description><category></category></item><item><title><![CDATA[BEA dev2dev 在线]]></title><link>https://blog.youkuaiyun.com/cuishuobi4947/article/details/100510383</link><guid>https://blog.youkuaiyun.com/cuishuobi4947/article/details/100510383</guid><author>cuishuobi4947</author><pubDate>Wed, 17 Jul 2019 20:33:02 +0800</pubDate><description><![CDATA[BEA dev2dev 在线链接:http://dev2dev.bea.com.cn/bbs/index.jspa
                                                        ...]]></description><category></category></item><item><title><![CDATA[piner]]></title><link>https://blog.youkuaiyun.com/cuishuobi4947/article/details/100463676</link><guid>https://blog.youkuaiyun.com/cuishuobi4947/article/details/100463676</guid><author>cuishuobi4947</author><pubDate>Wed, 17 Jul 2019 19:36:02 +0800</pubDate><description><![CDATA[piner链接:http://www.ixdba.com
                                                            
                    
   ...]]></description><category></category></item><item><title><![CDATA[DB2服务器链接中几种遇到的出错的解决]]></title><link>https://blog.youkuaiyun.com/cuishuobi4947/article/details/100463614</link><guid>https://blog.youkuaiyun.com/cuishuobi4947/article/details/100463614</guid><author>cuishuobi4947</author><pubDate>Wed, 17 Jul 2019 18:03:02 +0800</pubDate><description><![CDATA[1、DB2中几种遇到的SQL1032N出错的解决 在使用DB2以来，碰到了几次出现提示SQL1032N错误，每次出错时出错信息大概如下：11/21/2004 22:15:33 0 0 SQL1042C 发生意外的系统错误。SQL...]]></description><category></category></item><item><title><![CDATA[Windows上DB2 UDB脚本编制简介]]></title><link>https://blog.youkuaiyun.com/cuishuobi4947/article/details/100463677</link><guid>https://blog.youkuaiyun.com/cuishuobi4947/article/details/100463677</guid><author>cuishuobi4947</author><pubDate>Wed, 17 Jul 2019 09:45:01 +0800</pubDate><description><![CDATA[除了提供对结构化查询语言（Structure Query Language，SQL）的支持外，IBM® DB2® Universal Database™ 还提供一组丰富且广泛的管理应用程序编程接口（API）。因为正确维护 DB2...]]></description><category></category></item><item><title><![CDATA[让db2系统定时runstats、reorg]]></title><link>https://blog.youkuaiyun.com/cuishuobi4947/article/details/100463613</link><guid>https://blog.youkuaiyun.com/cuishuobi4947/article/details/100463613</guid><author>cuishuobi4947</author><pubDate>Wed, 17 Jul 2019 08:03:01 +0800</pubDate><description><![CDATA[让db2系统定时runstats、reorgQ:定期runstats、reorgA:在db2 v8.2以上可以使用 CALL SYSPROC.ADMIN_CMD来实现,这里主要讲在v8.2以前的版本中利用shell或者批处理来实...]]></description><category></category></item><item><title><![CDATA[OLTP 应用程序的 DB2 调优技巧]]></title><link>https://blog.youkuaiyun.com/cuishuobi4947/article/details/100463611</link><guid>https://blog.youkuaiyun.com/cuishuobi4947/article/details/100463611</guid><author>cuishuobi4947</author><pubDate>Wed, 17 Jul 2019 07:42:02 +0800</pubDate><description><![CDATA[简介DB2 Universal Database®（UDB）是第一个支持多媒体和 Web 的关系数据库管理系统，它的功能非常强大，足以满足大公司的需求，并且它非常灵活，足以满足中小企业的要求。DB2 产品系列软件和因特网技术的结...]]></description><category></category></item><item><title><![CDATA[dbafan]]></title><link>https://blog.youkuaiyun.com/cuishuobi4947/article/details/100463675</link><guid>https://blog.youkuaiyun.com/cuishuobi4947/article/details/100463675</guid><author>cuishuobi4947</author><pubDate>Wed, 17 Jul 2019 07:21:01 +0800</pubDate><description><![CDATA[dbafan链接:http://www.dbafan.com
                                                            
                    
 ...]]></description><category></category></item><item><title><![CDATA[联邦数据库的使用过程！]]></title><link>https://blog.youkuaiyun.com/cuishuobi4947/article/details/100463673</link><guid>https://blog.youkuaiyun.com/cuishuobi4947/article/details/100463673</guid><author>cuishuobi4947</author><pubDate>Tue, 16 Jul 2019 22:42:02 +0800</pubDate><description><![CDATA[首先呢非常非常感谢diablo2和wangzhonnew和pub的很多人对我最近以来的帮助和鼓励!联邦数据库的理解就不说了哈！下边就一个例子来配置：在3.40上创建基于4.5的联邦数据库的过程：1.设置联邦数据库开关db2 up...]]></description><category></category></item><item><title><![CDATA[puschitz.com]]></title><link>https://blog.youkuaiyun.com/cuishuobi4947/article/details/100463627</link><guid>https://blog.youkuaiyun.com/cuishuobi4947/article/details/100463627</guid><author>cuishuobi4947</author><pubDate>Tue, 16 Jul 2019 22:27:02 +0800</pubDate><description><![CDATA[puschitz.com链接:http://www.puschitz.com/
                                                            
             ...]]></description><category></category></item><item><title><![CDATA[将表格的某一列转换成逗号分隔的字符串的另类方法]]></title><link>https://blog.youkuaiyun.com/cuishuobi4947/article/details/100463612</link><guid>https://blog.youkuaiyun.com/cuishuobi4947/article/details/100463612</guid><author>cuishuobi4947</author><pubDate>Tue, 16 Jul 2019 21:30:01 +0800</pubDate><description><![CDATA[将表格的某一列转换成逗号分隔的字符串的另类方法A：dbms_utility.table_to_comma的使用一：首先建立测试表create table table1(dz varchar2(100))insert into t...]]></description><category></category></item><item><title><![CDATA[Metalink]]></title><link>https://blog.youkuaiyun.com/cuishuobi4947/article/details/100463700</link><guid>https://blog.youkuaiyun.com/cuishuobi4947/article/details/100463700</guid><author>cuishuobi4947</author><pubDate>Tue, 16 Jul 2019 20:39:02 +0800</pubDate><description><![CDATA[Metalink链接:http://metalink.oracle.com
                                                            
               ...]]></description><category></category></item><item><title><![CDATA[Tom]]></title><link>https://blog.youkuaiyun.com/cuishuobi4947/article/details/100463609</link><guid>https://blog.youkuaiyun.com/cuishuobi4947/article/details/100463609</guid><author>cuishuobi4947</author><pubDate>Tue, 16 Jul 2019 20:00:02 +0800</pubDate><description><![CDATA[Tom链接:http://tkyte.blogspot.com/
                                                            
                    ...]]></description><category></category></item><item><title><![CDATA[在DB2中恢复删除表的技巧-转]]></title><link>https://blog.youkuaiyun.com/cuishuobi4947/article/details/100463672</link><guid>https://blog.youkuaiyun.com/cuishuobi4947/article/details/100463672</guid><author>cuishuobi4947</author><pubDate>Tue, 16 Jul 2019 19:57:02 +0800</pubDate><description><![CDATA[这边转载了一个恢复drop后的表的一个操作，类似于oracle 10g中的闪回！DB2在历史文件中保存了备份，恢复，装载数据，删除表等操作. 假设数据库名为sample, 您可以用下面的命令列出删除表的记录: db2 "list...]]></description><category></category></item><item><title><![CDATA[关于oracle的锁以及死进程的处理学习]]></title><link>https://blog.youkuaiyun.com/cuishuobi4947/article/details/100463608</link><guid>https://blog.youkuaiyun.com/cuishuobi4947/article/details/100463608</guid><author>cuishuobi4947</author><pubDate>Tue, 16 Jul 2019 18:57:02 +0800</pubDate><description><![CDATA[关于oracle的锁以及死进程的处理
--1.查询系统中DML的锁，以及锁的sql
Select t2.SQL_TEXT,t.*,t1.*,t2.* From V$lock t,
V$session t1,
/*V$sq...]]></description><category></category></item><item><title><![CDATA[探讨SQL语句技巧 优化DB2应用程序性能]]></title><link>https://blog.youkuaiyun.com/cuishuobi4947/article/details/100463667</link><guid>https://blog.youkuaiyun.com/cuishuobi4947/article/details/100463667</guid><author>cuishuobi4947</author><pubDate>Tue, 16 Jul 2019 18:39:02 +0800</pubDate><description><![CDATA[本文以IBM的关系数据库管理系统DB2 Universal Database(通用数据库) 版本7.1为背景，与大家共同探讨编写好的SQL语句的技巧，以求DB2应用程序以求DB2应用程序获得更优的性能。　　当我们设计一个新的或分...]]></description><category></category></item><item><title><![CDATA[Itpub]]></title><link>https://blog.youkuaiyun.com/cuishuobi4947/article/details/100463599</link><guid>https://blog.youkuaiyun.com/cuishuobi4947/article/details/100463599</guid><author>cuishuobi4947</author><pubDate>Tue, 16 Jul 2019 17:51:01 +0800</pubDate><description><![CDATA[Itpub链接:http://www.itpub.net
                                                            
                    
   ...]]></description><category></category></item><item><title><![CDATA[dmreview]]></title><link>https://blog.youkuaiyun.com/cuishuobi4947/article/details/100463618</link><guid>https://blog.youkuaiyun.com/cuishuobi4947/article/details/100463618</guid><author>cuishuobi4947</author><pubDate>Tue, 16 Jul 2019 17:18:02 +0800</pubDate><description><![CDATA[dmreview链接:http://www.dmreview.com
                                                            
                  ...]]></description><category></category></item></channel></rss>