http://www.knowsky.com/article.asp?typeid=174 DB2教程 rss zh-cn Copyright 2000-2009 www.knowsky.com http://www.knowsky.com/441678.htmlwww.knowsky.comDB2教程2008-10-23 <p><a href="http://feedads.g.doubleclick.net/~a/Li9IQ93YUcptjG_7pEDRO2UWQhM/0/da"><img src="http://feedads.g.doubleclick.net/~a/Li9IQ93YUcptjG_7pEDRO2UWQhM/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/Li9IQ93YUcptjG_7pEDRO2UWQhM/1/da"><img src="http://feedads.g.doubleclick.net/~a/Li9IQ93YUcptjG_7pEDRO2UWQhM/1/di" border="0" ismap="true"></img></a></p>在DB2的开发过程中，贯穿整个开发过程还有很重要的一部分工作就是数据库的维护；对于维护一个庞大信息系统来说是非常必要的；留一份简易的维护手册，以备不时之需；以下收集到的部分维护命令，以飨我们的维护工.....<a href='http://www.knowsky.com/441678.html'>点击浏览详细内容</a><br/><br/>-------------------------------------<br/>导航:<a href='http://www.knowsky.com/developer.asp' target='_blank'>编程</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/zhanzhang.asp' target='_blank'>站长</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/web.asp' target='_blank'>网页</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/photo.asp' target='_blank'>图形</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/system.asp' target='_blank'>系统</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/internet.asp' target='_blank'>冲浪</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/qq.asp' target='_blank'>QQ</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/soft.asp' target='_blank'>软件</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/office.asp' target='_blank'>办公</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/shoujixueyuan.asp' target='_blank'>手机</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/mailserver.asp' target='_blank'>邮件</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/networksecurity.asp' target='_blank'>安全</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/exam.asp' target='_blank'>认证</a>http://www.knowsky.com/440286.htmlwww.knowsky.comDB2教程2008-08-14 <p><a href="http://feedads.g.doubleclick.net/~a/M27Tt7g8nTGcuaAitWfgZtHHBos/0/da"><img src="http://feedads.g.doubleclick.net/~a/M27Tt7g8nTGcuaAitWfgZtHHBos/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/M27Tt7g8nTGcuaAitWfgZtHHBos/1/da"><img src="http://feedads.g.doubleclick.net/~a/M27Tt7g8nTGcuaAitWfgZtHHBos/1/di" border="0" ismap="true"></img></a></p>dos下执行db2cmd，然后： db2 connect to yourdb user your_user using your_pwd db2 sql1.sql db2插入6000条数.....<a href='http://www.knowsky.com/440286.html'>点击浏览详细内容</a><br/><br/>-------------------------------------<br/>导航:<a href='http://www.knowsky.com/developer.asp' target='_blank'>编程</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/zhanzhang.asp' target='_blank'>站长</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/web.asp' target='_blank'>网页</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/photo.asp' target='_blank'>图形</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/system.asp' target='_blank'>系统</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/internet.asp' target='_blank'>冲浪</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/qq.asp' target='_blank'>QQ</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/soft.asp' target='_blank'>软件</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/office.asp' target='_blank'>办公</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/shoujixueyuan.asp' target='_blank'>手机</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/mailserver.asp' target='_blank'>邮件</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/networksecurity.asp' target='_blank'>安全</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/exam.asp' target='_blank'>认证</a>http://www.knowsky.com/400324.htmlwww.knowsky.comDB2教程2008-08-07 <p><a href="http://feedads.g.doubleclick.net/~a/ul7BNNbgIpofqa36CkccspDoUJg/0/da"><img src="http://feedads.g.doubleclick.net/~a/ul7BNNbgIpofqa36CkccspDoUJg/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/ul7BNNbgIpofqa36CkccspDoUJg/1/da"><img src="http://feedads.g.doubleclick.net/~a/ul7BNNbgIpofqa36CkccspDoUJg/1/di" border="0" ismap="true"></img></a></p>今天试着修改了下DB2的一个备份参数LOGARCHMETH1,试着将其值改为USEREXIT 改完之后,退出,然后就连不上数据库了,重启一下,报错如下: D:\Documents and S.....<a href='http://www.knowsky.com/400324.html'>点击浏览详细内容</a><br/><br/>-------------------------------------<br/>导航:<a href='http://www.knowsky.com/developer.asp' target='_blank'>编程</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/zhanzhang.asp' target='_blank'>站长</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/web.asp' target='_blank'>网页</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/photo.asp' target='_blank'>图形</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/system.asp' target='_blank'>系统</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/internet.asp' target='_blank'>冲浪</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/qq.asp' target='_blank'>QQ</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/soft.asp' target='_blank'>软件</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/office.asp' target='_blank'>办公</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/shoujixueyuan.asp' target='_blank'>手机</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/mailserver.asp' target='_blank'>邮件</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/networksecurity.asp' target='_blank'>安全</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/exam.asp' target='_blank'>认证</a>http://www.knowsky.com/400314.htmlwww.knowsky.comDB2教程2008-08-07 <p><a href="http://feedads.g.doubleclick.net/~a/eHZC0tX2Yo9cMrrUPb94yNHqPTs/0/da"><img src="http://feedads.g.doubleclick.net/~a/eHZC0tX2Yo9cMrrUPb94yNHqPTs/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/eHZC0tX2Yo9cMrrUPb94yNHqPTs/1/da"><img src="http://feedads.g.doubleclick.net/~a/eHZC0tX2Yo9cMrrUPb94yNHqPTs/1/di" border="0" ismap="true"></img></a></p>使用 MQT物化查询表（Materialized Query Tables, MQT） MQT 的定义基于查询的结果。MQT 可以显著提高查询的性能。本教程将介绍 MQT、总结表（summary.....<a href='http://www.knowsky.com/400314.html'>点击浏览详细内容</a><br/><br/>-------------------------------------<br/>导航:<a href='http://www.knowsky.com/developer.asp' target='_blank'>编程</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/zhanzhang.asp' target='_blank'>站长</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/web.asp' target='_blank'>网页</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/photo.asp' target='_blank'>图形</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/system.asp' target='_blank'>系统</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/internet.asp' target='_blank'>冲浪</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/qq.asp' target='_blank'>QQ</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/soft.asp' target='_blank'>软件</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/office.asp' target='_blank'>办公</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/shoujixueyuan.asp' target='_blank'>手机</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/mailserver.asp' target='_blank'>邮件</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/networksecurity.asp' target='_blank'>安全</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/exam.asp' target='_blank'>认证</a>http://www.knowsky.com/400313.htmlwww.knowsky.comDB2教程2008-08-07 <p><a href="http://feedads.g.doubleclick.net/~a/3RNzomeb2qoIH1BHk4YKRxyp_ok/0/da"><img src="http://feedads.g.doubleclick.net/~a/3RNzomeb2qoIH1BHk4YKRxyp_ok/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/3RNzomeb2qoIH1BHk4YKRxyp_ok/1/da"><img src="http://feedads.g.doubleclick.net/~a/3RNzomeb2qoIH1BHk4YKRxyp_ok/1/di" border="0" ismap="true"></img></a></p>对表进行任何操作都不被允许，提示SQLSTATE=57016 SQLCODE=-668 ，原因码 "7"的错误：SQL0668N Operation not allowed for reason c.....<a href='http://www.knowsky.com/400313.html'>点击浏览详细内容</a><br/><br/>-------------------------------------<br/>导航:<a href='http://www.knowsky.com/developer.asp' target='_blank'>编程</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/zhanzhang.asp' target='_blank'>站长</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/web.asp' target='_blank'>网页</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/photo.asp' target='_blank'>图形</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/system.asp' target='_blank'>系统</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/internet.asp' target='_blank'>冲浪</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/qq.asp' target='_blank'>QQ</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/soft.asp' target='_blank'>软件</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/office.asp' target='_blank'>办公</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/shoujixueyuan.asp' target='_blank'>手机</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/mailserver.asp' target='_blank'>邮件</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/networksecurity.asp' target='_blank'>安全</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/exam.asp' target='_blank'>认证</a>http://www.knowsky.com/400225.htmlwww.knowsky.comDB2教程2008-08-04 <p><a href="http://feedads.g.doubleclick.net/~a/jNAPxiCd5aoAsbKGd8zpLBV_vmM/0/da"><img src="http://feedads.g.doubleclick.net/~a/jNAPxiCd5aoAsbKGd8zpLBV_vmM/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/jNAPxiCd5aoAsbKGd8zpLBV_vmM/1/da"><img src="http://feedads.g.doubleclick.net/~a/jNAPxiCd5aoAsbKGd8zpLBV_vmM/1/di" border="0" ismap="true"></img></a></p>本文详细描述了 DB2&reg; Universal Database&#8482;（DB2 UDB）代理的工作原理以及连接集中器的特性，并对 DB2 连接上常见的问题及代理的优化作了详细的分析。希.....<a href='http://www.knowsky.com/400225.html'>点击浏览详细内容</a><br/><br/>-------------------------------------<br/>导航:<a href='http://www.knowsky.com/developer.asp' target='_blank'>编程</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/zhanzhang.asp' target='_blank'>站长</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/web.asp' target='_blank'>网页</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/photo.asp' target='_blank'>图形</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/system.asp' target='_blank'>系统</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/internet.asp' target='_blank'>冲浪</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/qq.asp' target='_blank'>QQ</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/soft.asp' target='_blank'>软件</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/office.asp' target='_blank'>办公</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/shoujixueyuan.asp' target='_blank'>手机</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/mailserver.asp' target='_blank'>邮件</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/networksecurity.asp' target='_blank'>安全</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/exam.asp' target='_blank'>认证</a>http://www.knowsky.com/400179.htmlwww.knowsky.comDB2教程2008-08-01 <p><a href="http://feedads.g.doubleclick.net/~a/GKw0PSw08xnAciSWdbpwOBwlZDU/0/da"><img src="http://feedads.g.doubleclick.net/~a/GKw0PSw08xnAciSWdbpwOBwlZDU/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/GKw0PSw08xnAciSWdbpwOBwlZDU/1/da"><img src="http://feedads.g.doubleclick.net/~a/GKw0PSw08xnAciSWdbpwOBwlZDU/1/di" border="0" ismap="true"></img></a></p>WPAR（工作负载分区）是 IBM&reg; AIX&reg; 610 中附带的许可程序产品。本文将向您介绍 WPAR 的相关概念及其配置。通过学习本文中的示例，您将能够在系统和应用程序 WPAR .....<a href='http://www.knowsky.com/400179.html'>点击浏览详细内容</a><br/><br/>-------------------------------------<br/>导航:<a href='http://www.knowsky.com/developer.asp' target='_blank'>编程</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/zhanzhang.asp' target='_blank'>站长</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/web.asp' target='_blank'>网页</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/photo.asp' target='_blank'>图形</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/system.asp' target='_blank'>系统</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/internet.asp' target='_blank'>冲浪</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/qq.asp' target='_blank'>QQ</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/soft.asp' target='_blank'>软件</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/office.asp' target='_blank'>办公</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/shoujixueyuan.asp' target='_blank'>手机</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/mailserver.asp' target='_blank'>邮件</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/networksecurity.asp' target='_blank'>安全</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/exam.asp' target='_blank'>认证</a>http://www.knowsky.com/400173.htmlwww.knowsky.comDB2教程2008-08-01 <p><a href="http://feedads.g.doubleclick.net/~a/iO1aj3z0lOoSaARows7HnyDWEB4/0/da"><img src="http://feedads.g.doubleclick.net/~a/iO1aj3z0lOoSaARows7HnyDWEB4/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/iO1aj3z0lOoSaARows7HnyDWEB4/1/da"><img src="http://feedads.g.doubleclick.net/~a/iO1aj3z0lOoSaARows7HnyDWEB4/1/di" border="0" ismap="true"></img></a></p>root中，su - db2admin报Segmentation fault ，在装有DB2 数据库的AIX 环境中，当以客户root用户的身份登陆到系统，然后用su命令到db2admin（#su .....<a href='http://www.knowsky.com/400173.html'>点击浏览详细内容</a><br/><br/>-------------------------------------<br/>导航:<a href='http://www.knowsky.com/developer.asp' target='_blank'>编程</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/zhanzhang.asp' target='_blank'>站长</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/web.asp' target='_blank'>网页</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/photo.asp' target='_blank'>图形</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/system.asp' target='_blank'>系统</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/internet.asp' target='_blank'>冲浪</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/qq.asp' target='_blank'>QQ</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/soft.asp' target='_blank'>软件</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/office.asp' target='_blank'>办公</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/shoujixueyuan.asp' target='_blank'>手机</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/mailserver.asp' target='_blank'>邮件</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/networksecurity.asp' target='_blank'>安全</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/exam.asp' target='_blank'>认证</a>http://www.knowsky.com/400172.htmlwww.knowsky.comDB2教程2008-08-01 <p><a href="http://feedads.g.doubleclick.net/~a/uI9yQ1y6rQFzuzE3RFBjhYr4tAs/0/da"><img src="http://feedads.g.doubleclick.net/~a/uI9yQ1y6rQFzuzE3RFBjhYr4tAs/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/uI9yQ1y6rQFzuzE3RFBjhYr4tAs/1/da"><img src="http://feedads.g.doubleclick.net/~a/uI9yQ1y6rQFzuzE3RFBjhYr4tAs/1/di" border="0" ismap="true"></img></a></p>前天开始安装省总服务器，先建数据库，又打包程序进行安装，一切按部就班，很是顺利，可最后程序总是连不上数据库，用以下命令进行测试： catalog tcpip node local remote .....<a href='http://www.knowsky.com/400172.html'>点击浏览详细内容</a><br/><br/>-------------------------------------<br/>导航:<a href='http://www.knowsky.com/developer.asp' target='_blank'>编程</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/zhanzhang.asp' target='_blank'>站长</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/web.asp' target='_blank'>网页</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/photo.asp' target='_blank'>图形</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/system.asp' target='_blank'>系统</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/internet.asp' target='_blank'>冲浪</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/qq.asp' target='_blank'>QQ</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/soft.asp' target='_blank'>软件</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/office.asp' target='_blank'>办公</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/shoujixueyuan.asp' target='_blank'>手机</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/mailserver.asp' target='_blank'>邮件</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/networksecurity.asp' target='_blank'>安全</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/exam.asp' target='_blank'>认证</a>http://www.knowsky.com/400171.htmlwww.knowsky.comDB2教程2008-08-01 <p><a href="http://feedads.g.doubleclick.net/~a/79S-iPZ1qKSstQy4ZDOj3kVWv98/0/da"><img src="http://feedads.g.doubleclick.net/~a/79S-iPZ1qKSstQy4ZDOj3kVWv98/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/79S-iPZ1qKSstQy4ZDOj3kVWv98/1/da"><img src="http://feedads.g.doubleclick.net/~a/79S-iPZ1qKSstQy4ZDOj3kVWv98/1/di" border="0" ismap="true"></img></a></p>这篇论坛文章（赛迪网技术社区）着重介绍了DB2数据库逻辑卷的复制，详细内容请参考下文： 周末加班，需要把db2的instance和数据迁移到datavg下（原来的“DBA”给部署到rootvg下.....<a href='http://www.knowsky.com/400171.html'>点击浏览详细内容</a><br/><br/>-------------------------------------<br/>导航:<a href='http://www.knowsky.com/developer.asp' target='_blank'>编程</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/zhanzhang.asp' target='_blank'>站长</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/web.asp' target='_blank'>网页</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/photo.asp' target='_blank'>图形</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/system.asp' target='_blank'>系统</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/internet.asp' target='_blank'>冲浪</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/qq.asp' target='_blank'>QQ</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/soft.asp' target='_blank'>软件</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/office.asp' target='_blank'>办公</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/shoujixueyuan.asp' target='_blank'>手机</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/mailserver.asp' target='_blank'>邮件</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/networksecurity.asp' target='_blank'>安全</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/exam.asp' target='_blank'>认证</a>