<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[congchu6058的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/congchu6058</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; congchu6058]]></copyright><item><title><![CDATA[查询每个节点每天的备份数据量]]></title><link>https://blog.youkuaiyun.com/congchu6058/article/details/100360852</link><guid>https://blog.youkuaiyun.com/congchu6058/article/details/100360852</guid><author>congchu6058</author><pubDate>Fri, 05 Jul 2013 12:53:34 +0800</pubDate><description><![CDATA[tsm: TSM53&gt;select entity,sum(bytes)/1024/1024/1024 as gb from summary where acti      vity='BACKUP' and st...]]></description><category></category></item><item><title><![CDATA[标识列]]></title><link>https://blog.youkuaiyun.com/congchu6058/article/details/100360853</link><guid>https://blog.youkuaiyun.com/congchu6058/article/details/100360853</guid><author>congchu6058</author><pubDate>Mon, 26 Apr 2010 17:12:16 +0800</pubDate><description><![CDATA[标识列缺省情况下生成的标识列db2 =&gt; create table test3 (id int generated by default as identity,name char(8))db2 =&gt; insert ...]]></description><category></category></item><item><title><![CDATA[序列相关]]></title><link>https://blog.youkuaiyun.com/congchu6058/article/details/100360810</link><guid>https://blog.youkuaiyun.com/congchu6058/article/details/100360810</guid><author>congchu6058</author><pubDate>Mon, 26 Apr 2010 16:54:45 +0800</pubDate><description><![CDATA[查看先前及下一个序列的值values previous value for db2inst1.dongseqvalues next value for db2inst1.dongseq新建一个序列db2 =&gt; create...]]></description><category></category></item><item><title><![CDATA[db2 自动删除备份]]></title><link>https://blog.youkuaiyun.com/congchu6058/article/details/100360854</link><guid>https://blog.youkuaiyun.com/congchu6058/article/details/100360854</guid><author>congchu6058</author><pubDate>Mon, 26 Apr 2010 09:41:00 +0800</pubDate><description><![CDATA[Number of database backups to retain   (NUM_DB_BACKUPS) = 2 Recovery history retention (days)     (REC_HIS_RETENTN...]]></description><category></category></item><item><title><![CDATA[db2 修改一列的默认值]]></title><link>https://blog.youkuaiyun.com/congchu6058/article/details/100360841</link><guid>https://blog.youkuaiyun.com/congchu6058/article/details/100360841</guid><author>congchu6058</author><pubDate>Mon, 26 Apr 2010 09:40:39 +0800</pubDate><description><![CDATA[C:\Documents and Settings\yudongdong&gt;db2 alter table yinji2 alter column email set with default 'donggua@125.co...]]></description><category></category></item><item><title><![CDATA[db2 日志详解]]></title><link>https://blog.youkuaiyun.com/congchu6058/article/details/100360864</link><guid>https://blog.youkuaiyun.com/congchu6058/article/details/100360864</guid><author>congchu6058</author><pubDate>Mon, 26 Apr 2010 09:39:54 +0800</pubDate><description><![CDATA[一.日志概述任何数据库管理系统都必须拥有确保数据一致性和可恢复性的机制。关系数据库系统为确保那些非常重要的特性所使用的众多机制之一是事务性日志记录。在本文中，我们将定义和讨论事务性日志记录的类型，及如何分配日志文件、如何存储它...]]></description><category></category></item><item><title><![CDATA[db2 获取当前schema]]></title><link>https://blog.youkuaiyun.com/congchu6058/article/details/100360861</link><guid>https://blog.youkuaiyun.com/congchu6058/article/details/100360861</guid><author>congchu6058</author><pubDate>Mon, 26 Apr 2010 09:39:28 +0800</pubDate><description><![CDATA[values current schemaordb2 =&gt; select CURRENT schema from sysibm.sysdummy1db2 =&gt; set current schema='DB2INST1...]]></description><category></category></item><item><title><![CDATA[db2 查看有几个备份]]></title><link>https://blog.youkuaiyun.com/congchu6058/article/details/100360808</link><guid>https://blog.youkuaiyun.com/congchu6058/article/details/100360808</guid><author>congchu6058</author><pubDate>Mon, 26 Apr 2010 09:39:02 +0800</pubDate><description><![CDATA[[db2inst1@oracle db2backup]$ db2 list history backup all for donggua                    List History File for dong...]]></description><category></category></item><item><title><![CDATA[db2 uninstall]]></title><link>https://blog.youkuaiyun.com/congchu6058/article/details/100360805</link><guid>https://blog.youkuaiyun.com/congchu6058/article/details/100360805</guid><author>congchu6058</author><pubDate>Mon, 26 Apr 2010 09:38:44 +0800</pubDate><description><![CDATA[Uninstalling DB2 on UNIX or LinuxUse these steps to uninstall DB2 on UNIX or Linux systems.About this taskTo unins...]]></description><category></category></item><item><title><![CDATA[db2 load copy yes no]]></title><link>https://blog.youkuaiyun.com/congchu6058/article/details/100360844</link><guid>https://blog.youkuaiyun.com/congchu6058/article/details/100360844</guid><author>congchu6058</author><pubDate>Mon, 26 Apr 2010 09:38:06 +0800</pubDate><description><![CDATA[copy yes    load表后，自动执行一次表空间的备份copy no     load表后，将表空间置于backup pending状态，等待备份，此时表不可用nonrecoverable      load表后，表可用...]]></description><category></category></item><item><title><![CDATA[db2 list history 命令详解]]></title><link>https://blog.youkuaiyun.com/congchu6058/article/details/100360806</link><guid>https://blog.youkuaiyun.com/congchu6058/article/details/100360806</guid><author>congchu6058</author><pubDate>Mon, 26 Apr 2010 09:37:40 +0800</pubDate><description><![CDATA[The report generated by this command contains the following symbols: Operation   A - Create table space   B - Back...]]></description><category></category></item><item><title><![CDATA[db2 获取表空间及缓冲池信息]]></title><link>https://blog.youkuaiyun.com/congchu6058/article/details/100360849</link><guid>https://blog.youkuaiyun.com/congchu6058/article/details/100360849</guid><author>congchu6058</author><pubDate>Mon, 26 Apr 2010 09:37:03 +0800</pubDate><description><![CDATA[db2 get snapshot for tablespaces on teps &gt; tablespace.infodb2 get snapshot for tables on teps &gt; tables.infod...]]></description><category></category></item><item><title><![CDATA[db2 dms sms]]></title><link>https://blog.youkuaiyun.com/congchu6058/article/details/100360804</link><guid>https://blog.youkuaiyun.com/congchu6058/article/details/100360804</guid><author>congchu6058</author><pubDate>Mon, 26 Apr 2010 09:36:43 +0800</pubDate><description><![CDATA[DMS SMSdb2中，DMS的表空间，分配的容器大小可以不一样，可以一个用完了，用下一个，。SMS的表空间，一个用完了，表空间就满了对于ｄｍｓ文件容器（和所有ｓｍｓ容器），操作系统可能会将页高速缓存在文件系统高速缓存中。对于ｄ...]]></description><category></category></item><item><title><![CDATA[db2新建删除实例]]></title><link>https://blog.youkuaiyun.com/congchu6058/article/details/100360798</link><guid>https://blog.youkuaiyun.com/congchu6058/article/details/100360798</guid><author>congchu6058</author><pubDate>Mon, 26 Apr 2010 09:36:07 +0800</pubDate><description><![CDATA[db2icrtdb2idrop
			
			
			
			
                                                            
                 ...]]></description><category></category></item><item><title><![CDATA[db2设置环境变量]]></title><link>https://blog.youkuaiyun.com/congchu6058/article/details/100360840</link><guid>https://blog.youkuaiyun.com/congchu6058/article/details/100360840</guid><author>congchu6058</author><pubDate>Mon, 26 Apr 2010 09:35:39 +0800</pubDate><description><![CDATA[db2set db2comm=tcpipdb2set *** -i 实例级别db2set **  -g 全局级别
			
			
			
			
                                     ...]]></description><category></category></item><item><title><![CDATA[db2日志控制参数]]></title><link>https://blog.youkuaiyun.com/congchu6058/article/details/100360850</link><guid>https://blog.youkuaiyun.com/congchu6058/article/details/100360850</guid><author>congchu6058</author><pubDate>Mon, 26 Apr 2010 09:35:17 +0800</pubDate><description><![CDATA[有什么参数可以控制日志？通过数据库配置参数在数据库级别上控制事务性日志记录。以下是影响事务性日志记录的参数：LOGRETAIN该参数使归档日志保留在数据库日志路径目录中。通过将它设置成“RECOVERY”来启用它，从而允许数据库...]]></description><category></category></item><item><title><![CDATA[db2交互命令行提示符]]></title><link>https://blog.youkuaiyun.com/congchu6058/article/details/100360792</link><guid>https://blog.youkuaiyun.com/congchu6058/article/details/100360792</guid><author>congchu6058</author><pubDate>Mon, 26 Apr 2010 09:34:47 +0800</pubDate><description><![CDATA[db2set db2_clpprompt="(Instance:%i,Db:%d):"%ia 如果存在实例链接,则为当前实例链接的授权标识%i	如果存在实例链接,则为该实例的本地别名%da 如果存在数据库链接,则为当前数据库链接...]]></description><category></category></item><item><title><![CDATA[db2 建表语句]]></title><link>https://blog.youkuaiyun.com/congchu6058/article/details/100360815</link><guid>https://blog.youkuaiyun.com/congchu6058/article/details/100360815</guid><author>congchu6058</author><pubDate>Mon, 26 Apr 2010 09:34:24 +0800</pubDate><description><![CDATA[db2 =&gt; create table test (name char(8) not null primary key,depid smallint,pay bigint)DB20000I  SQL 命令成功完成。db2 ...]]></description><category></category></item><item><title><![CDATA[db2 基础]]></title><link>https://blog.youkuaiyun.com/congchu6058/article/details/100360803</link><guid>https://blog.youkuaiyun.com/congchu6058/article/details/100360803</guid><author>congchu6058</author><pubDate>Mon, 26 Apr 2010 09:33:58 +0800</pubDate><description><![CDATA[db2setDB2INSTANCE 这个参数用来控制当前操作的实例db2start db2stop 开关当前实例，需要参照DB2INSTANCE参数db2level db2/db2cmdattach to INSTANCEcon...]]></description><category></category></item><item><title><![CDATA[db2 import]]></title><link>https://blog.youkuaiyun.com/congchu6058/article/details/100360801</link><guid>https://blog.youkuaiyun.com/congchu6058/article/details/100360801</guid><author>congchu6058</author><pubDate>Mon, 26 Apr 2010 09:33:27 +0800</pubDate><description><![CDATA[db2 import from test.txt of asc method L \(1 6\) insert into test从test.txt 文件导入，ASCII类型的源文件，第1到6个字符为第一列，insert到tes...]]></description><category></category></item></channel></rss>