<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/congditong6927</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; congditong6927]]></copyright><item><title><![CDATA[工作第一帖]]></title><link>https://blog.youkuaiyun.com/congditong6927/article/details/100468220</link><guid>https://blog.youkuaiyun.com/congditong6927/article/details/100468220</guid><author>congditong6927</author><pubDate>Mon, 10 May 2010 18:00:27 +0800</pubDate><description><![CDATA[开始工作了，从事Oracle相关的工作，发表第一帖在pub上面 哈哈
                                                            
        ...]]></description><category></category></item><item><title><![CDATA[db2 字符串问题]]></title><link>https://blog.youkuaiyun.com/congditong6927/article/details/100468212</link><guid>https://blog.youkuaiyun.com/congditong6927/article/details/100468212</guid><author>congditong6927</author><pubDate>Wed, 30 Sep 2009 13:40:15 +0800</pubDate><description><![CDATA[数据库里有字段的值是： '10,512' '10,12' '10,931' '10,592,592014' 如何用sql语句取得 0512 0012 0931 0592 即第一个逗号后的数字，如果不足4位前面补零

sel...]]></description><category></category></item><item><title><![CDATA[db2    index信息更新引起的性能问题  --分布统计信息]]></title><link>https://blog.youkuaiyun.com/congditong6927/article/details/100468210</link><guid>https://blog.youkuaiyun.com/congditong6927/article/details/100468210</guid><author>congditong6927</author><pubDate>Tue, 22 Sep 2009 16:13:03 +0800</pubDate><description><![CDATA[问题描述： 用户反馈应用系统某个常用的操作变慢，该操作对应的SQL语句如下：select distinct a.*,w.IM_WORK_TRAY_NAME as work_tray_name,i.IM_POLNO from SA...]]></description><category></category></item><item><title><![CDATA[DB2数据库发生死锁了怎么办]]></title><link>https://blog.youkuaiyun.com/congditong6927/article/details/100468205</link><guid>https://blog.youkuaiyun.com/congditong6927/article/details/100468205</guid><author>congditong6927</author><pubDate>Tue, 22 Sep 2009 13:29:22 +0800</pubDate><description><![CDATA[【IT168 技术文档】在新的数据库应用系统上线初期，由于测试不完善或不熟悉DB2的机制，常会出现锁等待死锁等现象存在于我们的应用系统中，如何捕获锁等待或死锁信息并解决锁问题，是保证平稳上线必须面对的问题。目前应用系统最常使用的...]]></description><category></category></item><item><title><![CDATA[对客户locklist的调整记录]]></title><link>https://blog.youkuaiyun.com/congditong6927/article/details/100468203</link><guid>https://blog.youkuaiyun.com/congditong6927/article/details/100468203</guid><author>congditong6927</author><pubDate>Tue, 22 Sep 2009 13:27:51 +0800</pubDate><description><![CDATA[2009-08-11-09.20.20.253256 Instance:db2inst1 Node:000PID:327876(db2agent (DB_NAME) 0) TID:1 Appid:*LOCAL.d...]]></description><category></category></item><item><title><![CDATA[db2    创建工具目录]]></title><link>https://blog.youkuaiyun.com/congditong6927/article/details/100468202</link><guid>https://blog.youkuaiyun.com/congditong6927/article/details/100468202</guid><author>congditong6927</author><pubDate>Sat, 19 Sep 2009 23:30:07 +0800</pubDate><description><![CDATA[因为要使用调度功能来定期备份数据库，所以要创建一个工具目录，命令如下：C:\Program Files\IBM\SQLLIB\BIN&gt;db2 connect to ehis user echo using 123 数据...]]></description><category></category></item><item><title><![CDATA[DB2RELOCATEDB  does not update the eventmonitor information]]></title><link>https://blog.youkuaiyun.com/congditong6927/article/details/100468219</link><guid>https://blog.youkuaiyun.com/congditong6927/article/details/100468219</guid><author>congditong6927</author><pubDate>Fri, 18 Sep 2009 10:58:50 +0800</pubDate><description><![CDATA[Problem summary USERS AFFECTED:  ALL
PROBLEM DESCRIPTION:  The DB2RELOCATEDB tool does not update the
necessary ...]]></description><category></category></item><item><title><![CDATA[linux下安装DB2的详细步骤]]></title><link>https://blog.youkuaiyun.com/congditong6927/article/details/100468208</link><guid>https://blog.youkuaiyun.com/congditong6927/article/details/100468208</guid><author>congditong6927</author><pubDate>Thu, 17 Sep 2009 22:36:39 +0800</pubDate><description><![CDATA[今天安装了db2，忙了好一阵子，上网找资料等，终于装好了，下面就把我的步骤跟大家分享一下。
第一步:检查程序包及其版本 compat-libstdc++-7.3-2.96.118.i386.rpm 在linux的安装...]]></description><category></category></item><item><title><![CDATA[DB2 MQT介绍]]></title><link>https://blog.youkuaiyun.com/congditong6927/article/details/100468217</link><guid>https://blog.youkuaiyun.com/congditong6927/article/details/100468217</guid><author>congditong6927</author><pubDate>Wed, 16 Sep 2009 23:01:22 +0800</pubDate><description><![CDATA[有时候，物理数据库结构中的一次简单更改会显著地改进查询性能。除了索引外，DB2® Universal Database™ 还为您提供实例化的查询表（在版本 7.2 和更早的发行版中，称为“总结表”），在许多情况下，这些表...]]></description><category></category></item><item><title><![CDATA[【DB2】物化查询表（MQT）详解]]></title><link>https://blog.youkuaiyun.com/congditong6927/article/details/100468215</link><guid>https://blog.youkuaiyun.com/congditong6927/article/details/100468215</guid><author>congditong6927</author><pubDate>Wed, 16 Sep 2009 22:42:54 +0800</pubDate><description><![CDATA[物化查询表（MQT）
1.物化查询表与视图的区别视图是一个查询语句。物化查询表是一个查询的结果集。
2.创建物化查询表物化查询表可以在创建临时表的时候定义，分为2种。
·系统维护的MQT系统维护的MQT分为2种，一种是re...]]></description><category></category></item><item><title><![CDATA[三大新特性，DB2 9.7 华丽登场]]></title><link>https://blog.youkuaiyun.com/congditong6927/article/details/100468216</link><guid>https://blog.youkuaiyun.com/congditong6927/article/details/100468216</guid><author>congditong6927</author><pubDate>Tue, 15 Sep 2009 12:18:59 +0800</pubDate><description><![CDATA[DB2 9.7的三种武器　三年前，IBM发布DB2 9开创了混合型数据库的先河。三年时间过去了，6月26日，IBM在北京发布了DB2 的最新版本——这款代号为“Cobra”的最新版DB2可大幅减少数据存储空间，帮助客户节约高达7...]]></description><category></category></item><item><title><![CDATA[db2高级诊断 db2dart查找停顿(quiesce)表空间的用户]]></title><link>https://blog.youkuaiyun.com/congditong6927/article/details/100468207</link><guid>https://blog.youkuaiyun.com/congditong6927/article/details/100468207</guid><author>congditong6927</author><pubDate>Sat, 12 Sep 2009 10:21:52 +0800</pubDate><description><![CDATA[db2dart和inspect概述 
当DB2数据库出现异常后，可以使用db2dart或inspect命令查看整个数据库的一致性。db2dart命令可以用来验证数据库以及相关的数据库对象是否正确，是否存在问题；还可以用来显示数...]]></description><category></category></item><item><title><![CDATA[db2 重置处于停顿（quiesce）状态的表空间后仍然遇到 SQL0290N 的错误]]></title><link>https://blog.youkuaiyun.com/congditong6927/article/details/100468194</link><guid>https://blog.youkuaiyun.com/congditong6927/article/details/100468194</guid><author>congditong6927</author><pubDate>Sat, 12 Sep 2009 10:11:46 +0800</pubDate><description><![CDATA[环境: 产品：DB2 UDB 平台：Unix, Linux &amp; Windows 版本：V7.2, V8.1 问题描述:如果用户由于遇到 SQL0290N 的报错，指出表空间由于处于停顿状态而不允许存取，从...]]></description><category></category></item><item><title><![CDATA[Oracle Peeking绑定变量的控制]]></title><link>https://blog.youkuaiyun.com/congditong6927/article/details/100468206</link><guid>https://blog.youkuaiyun.com/congditong6927/article/details/100468206</guid><author>congditong6927</author><pubDate>Thu, 10 Sep 2009 15:15:44 +0800</pubDate><description><![CDATA[们知道从Oracle9i开始，Oracle引入了Peeking of User-Defined Bind Variables的特性，这个特性可以用来在存在数据倾斜时对执行计划纠偏。
然而这一特性也可能带来一些副作用，所以Ora...]]></description><category></category></item><item><title><![CDATA[10g 特性： catalog start with 将RMAN备份集恢复到另一台机器]]></title><link>https://blog.youkuaiyun.com/congditong6927/article/details/100468193</link><guid>https://blog.youkuaiyun.com/congditong6927/article/details/100468193</guid><author>congditong6927</author><pubDate>Wed, 02 Sep 2009 17:30:49 +0800</pubDate><description><![CDATA[catalog start with 将RMAN备份集恢复到另一台机器

oracle10g 中rman的增强功能catalog start with 
将备份集注册到控制文件


1.prepare
ser...]]></description><category></category></item><item><title><![CDATA[DB2存储过程中的游标和动态SQL]]></title><link>https://blog.youkuaiyun.com/congditong6927/article/details/100468204</link><guid>https://blog.youkuaiyun.com/congditong6927/article/details/100468204</guid><author>congditong6927</author><pubDate>Fri, 21 Aug 2009 09:01:43 +0800</pubDate><description><![CDATA[drop procedure report.jqx_bd_test;CREATE procedure report.jqx_bd_test()language sqlbegin atomic   DECLARE...]]></description><category></category></item><item><title><![CDATA[db2 有没有函数判断一个字符串全部由数字组成]]></title><link>https://blog.youkuaiyun.com/congditong6927/article/details/100468209</link><guid>https://blog.youkuaiyun.com/congditong6927/article/details/100468209</guid><author>congditong6927</author><pubDate>Tue, 18 Aug 2009 19:19:40 +0800</pubDate><description><![CDATA[‘123’ ‘01’合法‘12a’ ‘12.3’不合法
C:\Documents and Settings\Administrator&gt;db2 "values trim(translate('3433.33'...]]></description><category></category></item><item><title><![CDATA[Statspack  各项指标分析]]></title><link>https://blog.youkuaiyun.com/congditong6927/article/details/100468189</link><guid>https://blog.youkuaiyun.com/congditong6927/article/details/100468189</guid><author>congditong6927</author><pubDate>Fri, 14 Aug 2009 10:54:58 +0800</pubDate><description><![CDATA[　　~~~~~~~~~~Per Second　　　 Per Transaction　　　　Redo size:　　　　 22,007.09　　　　2,921.10　　　--很重要的参数，表示你数据变更频率　　Logical re...]]></description><category></category></item><item><title><![CDATA[什么样的ddl语句才会隐式提交]]></title><link>https://blog.youkuaiyun.com/congditong6927/article/details/100468187</link><guid>https://blog.youkuaiyun.com/congditong6927/article/details/100468187</guid><author>congditong6927</author><pubDate>Wed, 12 Aug 2009 17:14:42 +0800</pubDate><description><![CDATA[oracle11.1.0.6版本下测试：情况一：SQL&gt; select * from test;  ID----------   1   3   2   4 ...]]></description><category></category></item><item><title><![CDATA[rman备份发现坏块之后的处理]]></title><link>https://blog.youkuaiyun.com/congditong6927/article/details/100468200</link><guid>https://blog.youkuaiyun.com/congditong6927/article/details/100468200</guid><author>congditong6927</author><pubDate>Thu, 06 Aug 2009 16:35:21 +0800</pubDate><description><![CDATA[RMAN&gt; backup datafile 28;启动 backup 于 28-11月-04使用通道 ORA_DISK_1通道 ORA_DISK_1: 正在启动 full 数据文件备份集通道 ORA_DISK_1: 正在指...]]></description><category></category></item></channel></rss>