A management method of access path

Abstract

The invention provides a management method of an access path. The management method comprises the following steps: establishing a source end test environment matched with a target environment, and importing the associated table data of the target environment into a first application table created in the source end test environment; then, according to the associated table data imported into the first application table, carrying out business simulation and analog in the source end environment; and after correction is carried out, generating first statistical information so as to cause the relatively stable statistical information to adapt to the constant change of the data in the table. In addition, since the statistical information is updated in the source end test environment, the operation time of a target environment system can be shortened, and the consumption of system resources is reduced. On the basis of the first statistical information, a source end program access path and a target program access path are independently generated, inconsistent result data is stored after comparison is carried out so as to bring convenience for manual analysis and correction, and the problem of the management hysteresis of the access path is solved.

Description

technical field [0001] The present invention relates to the field of computer technology, and more specifically, relates to a method for managing access paths. Background technique [0002] DB2 is a set of relational database management system developed by IBM in the United States. It is mainly used in large-scale application systems. It calculates and provides access paths through query optimizers, thereby improving the data query performance of programs and users, and supports multi-task parallel query. [0003] At present, the existing method of using DB2 to calculate, generate and maintain access paths is to calculate and collect statistical information on related tables through RUNSTAT and other UTILITY tools, and record them in DB2CATALOG; after that, for static SQL, BIND or The REBIND operation generates the access path of the program. At the same time, the DB2 optimizer calculates the theoretically optimal access path when the program is BIND according to the statist...

AI Technical Summary

Problems solved by technology

[0004] However, when DB2 calculates and generates access paths, because the statistical information of the table in the DB2 CATALOG information cannot be updated in real time, but the data of the table may change at any time, the statistical information used to calculate the access path in the CATALOG is time-point, resulting in The catalog collected at a certain point in time is difficult to be generally suitable for tables with constantly changing data, resulting in the original good access path suddenly deteriorating as the data in the table changes; secondly, when collecting statistical information in the catalog, through RUNSTAT It will cause high overhead of system resources such as CPU, and cannot be executed frequently; when maintaining access paths, manual analysis and intervention corrections can only be performed when performance problems occur, resulting in extensive management of access paths and lag.

Images