<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0">
  <channel>
    <title>吾爱缘分 - [DB2数据库]</title>
    <link>https://52yfw.com/forum.php?mod=forumdisplay&amp;fid=4</link>
    <description>Latest 20 threads of [DB2数据库]</description>
    <copyright>Copyright(C) 吾爱缘分</copyright>
    <generator>Discuz! Board by Comsenz Inc.</generator>
    <lastBuildDate>Tue, 28 Jul 2026 22:30:53 +0000</lastBuildDate>
    <ttl>60</ttl>
    <image>
      <url>https://52yfw.com/static/image/common/logo_88_31.gif</url>
      <title>吾爱缘分</title>
      <link>https://52yfw.com/</link>
    </image>
    <item>
      <title>DB2数据库服务重新启动</title>
      <link>https://52yfw.com/forum.php?mod=viewthread&amp;tid=34</link>
      <description><![CDATA[1.先把所有的java进程结束掉，并且把数据库管理工具也关闭；
2.按  【win】+【r】   打开输入“db2cmd” 回车出来命令框，然后输“db2stop”，

3.等待停止后输“db2start”启动服务，提示处理成功即可；

4.输入“db2  connect to hy2234”后敲回车，可能会有点慢；


 ...]]></description>
      <category>[DB2数据库]</category>
      <author>admin</author>
      <pubDate>Thu, 06 Feb 2025 07:17:15 +0000</pubDate>
    </item>
    <item>
      <title>DB2数据库查询是否锁表</title>
      <link>https://52yfw.com/forum.php?mod=viewthread&amp;tid=33</link>
      <description><![CDATA[1.查询是否有锁表：                                                                                          
SELECT * FROM TABLE (SNAP_GET_LOCK (\'\', -1)) AS T WHERE lock_object_type = \'TABLE_LOCK\'

2.查询所有被锁的表

SELECT \'CALL SYSPROC.ADMIN_CMD(\&quot; ...]]></description>
      <category>[DB2数据库]</category>
      <author>admin</author>
      <pubDate>Thu, 06 Feb 2025 07:13:26 +0000</pubDate>
    </item>
    <item>
      <title>db2数据库cmd备份与还原</title>
      <link>https://52yfw.com/forum.php?mod=viewthread&amp;tid=3</link>
      <description><![CDATA[运行：

db2 force application all

备份：
db2 backup db sample to d:\\db2_bk

还原：
db2 restore db ncdb from d:\\db2_bk]]></description>
      <category>[DB2数据库]</category>
      <author>admin</author>
      <pubDate>Thu, 16 Jan 2025 03:04:37 +0000</pubDate>
    </item>
    <item>
      <title>SQL1117N 因为处于 ROLL-FORWARD PENDING 状态，所以不能连接或激活数据库</title>
      <link>https://52yfw.com/forum.php?mod=viewthread&amp;tid=2</link>
      <description><![CDATA[安装db2数据库后，进入数据库出错，可借鉴

执行命令db2 connect to cydb

出现SQL1117N  因为处于 ROLL-FORWARD PENDING 状态，所以不能连接或激活数据库\&quot;CYDB\&quot;。

需要执行命令：

D:\\&gt;db2 rollforward db cydb to end of logs and stop



                          ...]]></description>
      <category>[DB2数据库]</category>
      <author>admin</author>
      <pubDate>Wed, 15 Jan 2025 07:05:39 +0000</pubDate>
    </item>
  </channel>
</rss>