{"published":"2020-06-09 00:00:00","title":"\u3010Db2\u3011SQL1117N cannot be made because of ROLL-FORWARD PENDING\u3068\u3044\u3046\u30a8\u30e9\u30fc","image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/m/mtiit/20190220/20190220103611.jpg","author_name":"mtiit","url":"https://www.mtioutput.com/entry/db2-sql1117-error","provider_name":"Hatena Blog","provider_url":"https://hatena.blog","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fwww.mtioutput.com%2Fentry%2Fdb2-sql1117-error\" title=\"\u3010Db2\u3011SQL1117N cannot be made because of ROLL-FORWARD PENDING\u3068\u3044\u3046\u30a8\u30e9\u30fc - (O+P)ut\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","blog_title":"(O+P)ut","description":"\u4e8b\u8c61 \u4e0b\u8a18\u30b3\u30de\u30f3\u30c9\u3067\u53d6\u5f97\u3057\u305f\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u30d5\u30a1\u30a4\u30eb\u3092 $ db2 backup db sample to /tmp/\u4e0b\u8a18\u30b3\u30de\u30f3\u30c9\u3067\u30ea\u30b9\u30c8\u30a2\u3092\u8a66\u307f $ db2 restore db sample from /tmp\u8a72\u5f53\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u63a5\u7d9a\u3092\u8a66\u307f\u308b\u3082\u4ee5\u4e0b\u30a8\u30e9\u30fc\u3068\u306a\u308b\u3002 $ db2 connect to sample SQL1117N A connection to or activation of database \"SAMPLE\" cannot be made because of ROLL-FORWARD PENDING. SQLSTATE=57019 \u74b0\u5883\u60c5\u5831 DB2 v11.5 CentOS \u2026","blog_url":"https://www.mtioutput.com/","author_url":"https://blog.hatena.ne.jp/mtiit/","categories":["Database","Database-db2"],"height":"190","type":"rich","width":"100%","version":"1.0"}