崩溃恢复(crashrecovery)与AUTORESTART参数
关于这个参数设置的影响,在生产系统中经历过两次: 第一次是有套不太重要的系统安装在虚拟机,这套系统所有应用(DB2 WAS IHS)都配置到/etc/rc.local中,每次启动机器会自动拉起应用,然后有次虚拟机宕机,重启后检查了各个应用进程都正常启动,但是前台页
关于这个参数设置的影响,在生产系统中经历过两次:第一次是有套不太重要的系统安装在虚拟机,这套系统所有应用(DB2 WAS IHS)都配置到/etc/rc.local中,每次启动机器会自动拉起应用,然后有次虚拟机宕机,重启后检查了各个应用进程都正常启动,但是前台页面访问异常无法访问,然后到后台手动连接数据库报:
SQL1015N The database is in an inconsistent state. SQLSTATE=55025
根据SQL1015N提示:需要执行RESTART DATABASE DBNAME命令,执行后然后数据库可以正常连接
第二次是一套HA服务器的主机电源故障发生系统切换,切换到备机后,检查应用都正常被拉起,但是前台无法访问,和第一次是相同的问题,AUTORESTART参数被设置了OFF
这个参数解释如下:如果DB2数据库遭受断电或者异常关闭,数据库没有干净的关闭,那么数据库在启动的时候将会进行crash recovery. 但是如果数据库参数AUTORESTART设置为OFF的话,在启动数据库后DB2不会进行CRASH RECOVERY。关于crash recovery,在db2diag.log日志会有相关体现
下面重现这一场景:
/* 1 设置AUTORESTART为OFF */ [db2inst1@limt ~]$ db2 UPDATE DATABASE CONFIGURATION for limtdb USING AUTORESTART OFF IMMEDIATE DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully. [db2inst1@limt ~]$ db2 get db cfg for limtdb|grep -i AUTORESTART Auto restart enabled (AUTORESTART) = OFF [db2inst1@limt yunwei]$ db2 connect to limtdb Database Connection Information Database server = DB2/LINUXX8664 10.1.0 SQL authorization ID = DB2INST1 Local database alias = LIMTDB /* 2 插入一条数据但不提交,为了数据库处于不一致性 */ [db2inst1@limt yunwei]$ db2 +c "insert into A values(15485,'asdas','asdas')" DB20000I The SQL command completed successfully. [db2inst1@limt yunwei]$ /* 3 kill数据库,模拟异常宕机情况 */ [db2inst1@limt yunwei]$ ps -ef|grep db2sys db2inst1 5287 5285 1 08:07 pts/1 00:00:04 db2sysc 0 db2inst1 5827 3612 0 08:12 pts/1 00:00:00 grep db2sys [db2inst1@limt yunwei]$ kill -9 5287 /* 4 启动数据库,此时数据库没有进行崩溃恢复,因为AUTORESTART为OFF */ [db2inst1@limt yunwei]$ [db2inst1@limt yunwei]$ db2start 12/19/2014 08:13:04 0 0 SQL1063N DB2START processing was successful. SQL1063N DB2START processing was successful. [db2inst1@limt yunwei]$ [db2inst1@limt yunwei]$ /* 5 此处报错是因为刚才的db2bp进程没有terminate */ [db2inst1@limt yunwei]$ db2 connect to limtdb SQL0752N Connecting to a database is not permitted within a logical unit of work when the CONNECT type 1 setting is in use. SQLSTATE=0A001 [db2inst1@limt yunwei]$ db2 terminate DB20000I The TERMINATE command completed successfully. /* 6 再次启动时候报数据库不一致 */ [db2inst1@limt yunwei]$ db2 connect to limtdb SQL1015N The database is in an inconsistent state. SQLSTATE=55025 /* 7 db2 ? SQL1015N 有一条建议: using the RESTART DATABASE command*/ [db2inst1@limt yunwei]$ db2 restart database limtdb DB20000I The RESTART DATABASE command completed successfully. /* 8 数据库可以正常连接*/ [db2inst1@limt yunwei]$ db2 connect to limtdb Database Connection Information Database server = DB2/LINUXX8664 10.1.0 SQL authorization ID = DB2INST1 Local database alias = LIMTDB /* 9 以下是设置AUTORESTART为ON情况下,数据库宕机重启(不需要执行RESTART DATABASE) */ [db2inst1@limt yunwei]$ [db2inst1@limt yunwei]$ db2 UPDATE DATABASE CONFIGURATION for limtdb USING AUTORESTART ON IMMEDIATE DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully. [db2inst1@limt yunwei]$ [db2inst1@limt yunwei]$ db2 get db cfg for limtdb|grep -i AUTORESTART Auto restart enabled (AUTORESTART) = ON [db2inst1@limt yunwei]$ [db2inst1@limt yunwei]$ [db2inst1@limt yunwei]$ db2 +c "insert into A values(15485,'asdas','asdas')" DB20000I The SQL command completed successfully. [db2inst1@limt yunwei]$ ps -ef|grep db2sys db2inst1 5870 5868 1 08:13 pts/1 00:00:03 db2sysc 0 db2inst1 6122 3612 0 08:16 pts/1 00:00:00 grep db2sys [db2inst1@limt yunwei]$ kill -9 5870 [db2inst1@limt yunwei]$ db2start 12/19/2014 08:16:35 0 0 SQL1063N DB2START processing was successful. SQL1063N DB2START processing was successful. [db2inst1@limt yunwei]$ db2 connect to limtdb SQL0752N Connecting to a database is not permitted within a logical unit of work when the CONNECT type 1 setting is in use. [db2inst1@limt yunwei]$ db2 terminate DB20000I The TERMINATE command completed successfully. [db2inst1@limt yunwei]$ db2 connect to limtdb Database Connection Information Database server = DB2/LINUXX8664 10.1.0 SQL authorization ID = DB2INST1 Local database alias = LIMTDB

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics











Open WeChat, select Settings in Me, select General and then select Storage Space, select Management in Storage Space, select the conversation in which you want to restore files and select the exclamation mark icon. Tutorial Applicable Model: iPhone13 System: iOS15.3 Version: WeChat 8.0.24 Analysis 1 First open WeChat and click the Settings option on the My page. 2 Then find and click General Options on the settings page. 3Then click Storage Space on the general page. 4 Next, click Manage on the storage space page. 5Finally, select the conversation in which you want to recover files and click the exclamation mark icon on the right. Supplement: WeChat files generally expire in a few days. If the file received by WeChat has not been clicked, the WeChat system will clear it after 72 hours. If the WeChat file has been viewed,

Private browsing is a very convenient way to browse and protect your privacy when surfing the Internet on your computer or mobile device. Private browsing mode usually prevents the browser from recording your visit history, saving cookies and cache files, and preventing the website you are browsing from leaving any traces in the browser. However, for some special cases, we may need to restore the browsing history of Incognito Browsing. First of all, we need to make it clear: the purpose of private browsing mode is to protect privacy and prevent others from obtaining the user’s online history from the browser. Therefore, incognito browsing

Recently, some friends have encountered the problem of large characters on the win11 keyboard. They don't know which key to press to restore it. In fact, this may be because our keyboard is locked and we only need to unlock it. Which key should I press to recover if I can’t type on the win11 keyboard? 1. First, we press the “left shift+left alt+numlock” key combination on the keyboard. 2. Then, after opening the menu shown below, click the "Yes" button to enable the mouse keys. 3. Next, click the "Start Menu" or "Search" icon to open the taskbar. 4. After that, enter "osk" in the search box above to open the on-screen keyboard application. 5. Finally, click the "numlock" key in the lower right corner of the on-screen keyboard. Ps: If you are using a laptop, then

On Douyin, a short video platform full of creativity and vitality, we can not only enjoy a variety of exciting content, but also have in-depth communications with like-minded friends. Among them, chat sparks are an important indicator of the intensity of interaction between the two parties, and they often inadvertently ignite the emotional bonds between us and our friends. However, sometimes due to some reasons, the chat spark may be disconnected. So what should we do if we want to restore the chat spark? This tutorial guide will bring you a detailed introduction to the content strategy, hoping to help everyone. How to restore the spark of Douyin chat? 1. Open the Douyin message page and select a friend to chat. 2. Send messages and chat to each other. 3. If you send messages continuously for 3 days, you can get the spark logo. On a 3-day basis, send pictures or videos to each other

How to restore Xiaomi Cloud Photo Album to local? You can restore Xiaomi Cloud Photo Album to local in Xiaomi Cloud Photo Album APP, but most friends don’t know how to restore Xiaomi Cloud Photo Album to local. The next step is to restore Xiaomi Cloud Photo Album to local. Local method graphic tutorials, interested users come and take a look! How to restore Xiaomi cloud photo album to local 1. First open the settings function in Xiaomi phone and select [Personal Avatar] on the main interface; 2. Then enter the Xiaomi account interface and click the [Cloud Service] function; 3. Then jump to Xiaomi For the function of cloud service, select [Cloud Backup]; 4. Finally, in the interface as shown below, click [Cloud Album] to restore the album to local.

If we change our system account avatar but don’t want it anymore, we can’t find how to change the default avatar in win11. In fact, we only need to find the folder of the default avatar to restore it. Restore the default avatar in win11 1. First click on the "Windows Logo" on the bottom taskbar 2. Then find and open "Settings" 3. Then enter "Account" on the left column 4. Then click on "Account Information" on the right 5. After opening, click "Browse Files" in the selected photo. 6. Finally, enter the "C:\ProgramData\Microsoft\UserAccountPictures" path to find the system default avatar picture.

When we use the keyboard every day, we always encounter various keyboard problems. Most of them have updated the win10 system, and even more so. What should we do when the keyboard has become a shortcut key? Let’s take a look at the specific solutions below. How to restore the win10 keyboard to shortcut keys 1. It may be that the + shortcut key is turned on. 2. The method of closing is + (cannot press it backwards and forwards). 3. Another thing is to + return to the lock screen interface to log in. 4. Another possibility is to lock the keyboard. Press + to try. 5. If that doesn't work, just press ++ and then cancel. The above is the recovery method for converting the Win10 keyboard into shortcut keys that this website asked you. I hope it can solve your confusion. If you want to know more questions, please bookmark this site. welcome

Windows 10's May 2019 Update features a new, brighter default desktop background. It looks great - with the new light theme. If you use Windows 10’s dark theme, you may want a darker background. Strangely, the original Windows 10 desktop background has been removed from the latest version of Windows 10. You have to download it from the web or copy its files from an old Windows 10 PC. Although we were unable to find this wallpaper image on Microsoft's official website, you can download it from other sources. We found a copy of the original Windows 10 desktop wallpaper in 4K resolution on Imgur. Additionally, there are other sizes and more default walls
