<?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>Sat, 13 Jun 2026 12:27:18 +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>What an AllTrails Subscription Unlocks for Your Next Outdoor Adventure</title>
      <link>https://52yfw.com/forum.php?mod=viewthread&amp;tid=2395</link>
      <description><![CDATA[Picture this: you\'ve driven two hours to a trailhead, laced up your boots, and set off into the wilderness — only to lose the trail halfway through, with no cell service and no reliable way to find your way back. It\'s a scenario that plays out more  ...]]></description>
      <category>[DB2数据库]</category>
      <author>katharineee</author>
      <pubDate>Sat, 16 May 2026 01:37:04 +0000</pubDate>
    </item>
    <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>