The DB2 Performance Turning Technology And Application In STMA

Performance is an eternal topic of database applications, and also an important index of a project's success. But, it involves many aspects and is not easy to let a system possess best performance. This paper starts with the project's requirements, and discusses several methods to optimize DB2's performance and then builds the database self-adapt tuning framework. Through the established framework, the self-adapter based on database initiative characteristic is carried out.The target of Production Management & Decision-making System of Tobacco Industry brought forward by the State Monopolization Bureau of Tobacco is to realize the integration of tobacco trade's industry data and commerce data, to construct Production Management Decision-making system of Tobacco Industry based on existing network. After building the system, system data warehouse will be the hinge of tobacco industry's data center. And it is the base of information integration of tobacco industry. The system is also to establish the total basic data of national tobacco industry through gathering the data in tobacco industry and tobacco commerce timely, and accurately. It relates to financing, business, import and export system. And this can help state bureau's leaders know the development direction of tobacco industry in time, roundly, well and truly.Considering the above preconditions, aiming at tobacco daily business and requirements of data, this article presents the following:1.to analyze business logic and data info a flow chart, based on software including IBM AIX OS, DB2 UDB according to the Tobacco Number One's total design thoughtfulness2.to analyze the factors affecting DB2 database performance in detail in allusion to the characteristic of tobacco industry including large data, lots of users, data updating rapidly, and frequent visits;3. To designa set of optimizing database blue prints, including partitions meeting the needs of adding nodes at any time;4. to design MDC cooperating database partition meeting the needs of quick response to users'query;...