Tips for using the universal database query analyzer (16)

Tips for using the universal database query analyzer (16) --- SQL Execution Plan new in version 6.02 database connection Automatic Recovery Summary This article introduces the universal database query analyzer in detail, the SQL Execution Plan Database Connection automatic recovery function is added in the Chinese database query analyzer and DBQueryAnalyzer 6.02. In C

Tips for using the universal database query analyzer (16) --- SQL Execution Plan new in version 6.02 database connection Automatic Recovery Summary This article introduces the universal database query analyzer in detail, the SQL Execution Plan Database Connection automatic recovery function is added in the Chinese version of DB Query Analyzer and the English version of DB Query Analyzer 6.02. In C

Tips for using the universal database query analyzer (16)

--- The new SQL Execution Plan Database in version 6.02 is automatically restored.

SummaryThis article describes in detail the "universal database query analyzer ", the SQL "Execution Plan" database connection automatic recovery function is added in the Chinese version of DB Query Analyzer and the English version of DB Query Analyzer 6.02. In the article "Interview Ma genfeng with CSDN", the editor asked me what I would do if I had time? I said it will implement the "Execution Plan" function of the universal database query analyzer to automatically restore the database connection. I am very glad that this function was finally implemented in this period of time.

From version 6.02, you only need to set the option "SQL Execution Plan connection Automatic Recovery" in the "tool-à option" window to "selected" status, even if the database server goes down during the "SQL Execution Plan" period, as long as the database server processes the startup status at the time of the "SQL Execution Plan, the "SQL Execution Plan" will be executed.

KeywordsDB query Analyzer and DBQuery Analyzer

1 Introduction

Ma genfeng, a local programmer in China (Interview with Ma genfeng in CSDN: A Chinese programmer who is a master of massive data processing and analysis) Released personal work ---- universal database Query Analyzer, Chinese Version DB Query Analyzer and English version DB Query Analyzer. It has powerful functions, friendly operation interface, good operability, spanning a variety of database platforms and even EXCEL and text files.

You can use it①Query ODBC data sources (including all databases, TXT/CSV files, and EXCEL files in the world.②You can execute multiple DML statements and even the storage process at the same time, and the results will be returned in the table, text box, and file you set;③When exporting tens of millions of data records from a database, the efficiency is no different from that of DBMS;④With the powerful SQL "Execution Plan" function, you only need to set the option "SQL Execution Plan connection Automatic Recovery" in the "tool-à option" window to "selected" status, even if the database server goes down during the "SQL Execution Plan" period, as long as the database server processes the startup status at the time of the "SQL Execution Plan, the "SQL Execution Plan" will be executed.

The online download volume of DB query analyzer in Zhongguancun exceeds0.1 millionTimes, ranking in the entire database rankingsBefore10 digits.

In the "New Product & tool comments" section of "programmer" 2007, "Special Recommendation" was edited and the "universal database query analyzer" was released.

I also wrote about the related technologies of "universal database query analyzer ".71Article, published on "computer programming skills and maintenance", "software", "Computer Age", "computer programming skills and maintenance", Baidu Library, CSDN resources, and my blog (CSDN blog, Sina Blog, QQ space, and Sohu blog ).

This article will take the Chinese version DB query analyzer version 6.02 as an example to introduce in detail the newly added SQL "Execution Plan" database connection automatic recovery function in version 6.02. From version 6.02, you only need to set the option "SQL Execution Plan connection Automatic Recovery" in the "tool-à option" window to "selected" status, even if the database server goes down during the "SQL Execution Plan" period, as long as the database server processes the startup status at the time of the "SQL Execution Plan, the "SQL Execution Plan" will be executed.

2 6.02 Chinese Version DB query analyzer as an Example

The following uses the Chinese version of the "universal database query analyzer" database query analyzer 6.02 as an example to access the DB2 database based on AIX.

Operating System: Windows XP

Foreground program: DB query analyzer 6.02

Background Database: DB2/WINDOWSXP

Unlike earlier Windows operating systems (including WinXP, VISTA, Windows2000, WindowsNt, and Win98), Windows 7, Windows 8, and Windows 10 use the default delimiter "/". the default Delimiter is "-".

This will cause problems during the operation of the universal database query analyzer,ReminderFor Windows 7, Windows 8, and Windows 10 operating systems, set the short date separator to "-".

I will solve this problem in "universal database Query Analyzer" Chinese version "DB Query Analyzer" 6.03 version and English version "DB Query Analyzer" 6.03 version. We apologize for any inconvenience.

Log on to the background database

How to obtain the Chinese version of "universal database Query Analyzer" DB Query Analyzer "and the English version of" DB Query Analyzer "in" Zhongguancun online"Source installation packageFor details, see How to use the ZOL one-click installer to download the Zhongguancun online source installation package and How to downloadthe installation package by ZOL Downer.)

3 SQL Execution Plan Database Connection Automatic Recovery

Execute a script

Force stop the operation of the background database system

Run the SQL query statement in "DB query analyzer ".

Start the operation of the background database system

Run the query SQL statement in "DB query analyzer". The current database connection has been interrupted.

Click "tools-> options" to open the "system parameter configuration" window, and select "Automatic Recovery of SQL Execution Plan connections"

Figure 8 click "query-> Execution Plan" to open the "Execution Plan" Window

Figure 9 Add an execution plan"

As long as the execution plan time is the past time, the SQL script will be executed immediately. When the "Automatic Recovery of SQL Execution Plan connections" option is selected, when the database connection is interrupted, the universal database query analyzer will restore the database connection.

0. After the execution plan is executed, the result is returned.

Note:

The scheduling interval of the "Execution Plan" scheduler is 5 seconds, so the scheduled time is xx:Xx:01, but the execution start time is xx:Xx:01 and xx:Xx:Between 04.