[Brilliant technological restoration practices] DB2, the leader in the big data age

Source: Internet
Author: User
Tags db2 installation

Currently, popular database software include DB2, Access, Sybase, SQL server, ORACLE, and Foxpro. Among them, IBM's DB2 database is the leader in large databases, and DB2 is an important product of IBM, providing services on different operating system platforms.

Starting from the launch of the first DB2 product, IBM has continuously made reform and innovation attempts. Starting from the introduction of a single traditional relational database concept, IBM has gradually promoted hybrid database products. In its long-term development, DB2 is now compatible with various hardware and software platforms. From the deployment of DB2 products in various industry IT cases to the comprehensive and innovative IBM technology. In today's era of developed networks, DB2 enables applications on the distributed platform to perform database read/write operations, just as local databases can quickly and conveniently manage local data. DB2 innovatively promotes the creation of databases in the form of a "consultant" Wizard. The operation wizard not only completes tasks, but also provides suggested help functions based on some input elements, after the information is collected, it is pointed out that the database administrator may not take into account the options, help the database administrator to execute complex configurations, and guide the optimization options. If the database is not complete in the configuration phase, it will have a certain impact on the subsequent database maintenance phase. DB2 effectively reduces the problem of imperfect configuration through the "consultant" Wizard, which is of great help to the "problem management" of the database project improved by large enterprises. DB2 database checks and filters data from the pre-issue control phase. The wizard guides the appropriate configuration and deployment options to reflect the key points of large-scale deployment process from a macro perspective, and also focuses on phased deployment details at the micro level. Innovative technologies provide a comprehensive technical support platform for the IT field to promote the transformation and continuous development of E-commerce with technological innovation.

The core components of each DB2 database version are based on the consistency principle. You can select different price component configurations for IT project deployment as needed. IT is reflected in the use of any DB2 version of the application in the IT project, can be used directly on other advanced DB2 versions without modification, and for DB2 technical staff, the operating and deployment technology mastered in a DB2 version can be applied in other DB2 versions, reflecting the strong compatibility of the DB2 series products. That is to say, considering the compatibility of Enterprise updates to DB2, and the consistency of database management skills.

650) this. width = 650; "title =" 1.jpg" src = "http://www.bkjia.com/uploads/allimg/131228/2243132620-0.jpg"/>

The ever-changing technologies bring challenges and opportunities for IT project implementation and management. In the past, people were the key factors. In the age of rapid technological development, excellent software tools were the key to winning. IBM is constantly exploring the DB2 product to cater to the pace of the times, using smart wizard form, using the optimal deployment recommendations, to give enterprises the best solution. DB2 is the first outstanding database software product in the enterprise because of its dazzling appearance in similar database products.

Now, we will share with you the advantages and powerful functions of DB2 in practice, including "installation", "buffer pool" configuration, and "automatic maintenance" configuration in the DB2 database software, please experience the charm of the DB2 "consultant" smart wizard installation and configuration process. Now let's start our DB2 experience journey.


I. DB2Easy installation


The following operations describe the DB2 installation process. It demonstrates the advantages of easy and easy to install DB2 and wizard-based installation.


650) this. width = 650; "style =" float: none "title =" 2.jpg" src = "http://www.bkjia.com/uploads/allimg/131228/2243134S6-1.jpg"/>

650) this. width = 650; "style =" float: none "title =" 3.jpg" src = "http://www.bkjia.com/uploads/allimg/131228/2243134G4-2.jpg"/>

650) this. width = 650; "style =" float: none "title =" 4.jpg" src = "http://www.bkjia.com/uploads/allimg/131228/22431342W-3.jpg"/>

2. DB2Buffer Pool Configuration

The buffer pool technology plays an important role in improving database performance. The buffer pool caches table and index data in the database in the memory. It reduces direct sequential I/O access and provides asynchronous reading and writing to improve system performance. The size of the buffer pool page is 4 K, 8 K, 16 K, and 32 K in the memory. Each database requires at least one buffer pool, and there must be at least one buffer pool of the same page size for the specified page size tablespace. For example, if the tablespace is 8 K, the buffer pool must also match 8 K ). Sufficient buffer pool size is the key to database performance because it reduces the time-consuming operation of disk I/O. Large buffer pools also affect query optimization, because more work is done in the memory, and I/O read/write is not required.

The following operations demonstrate the creation and configuration of the DB2 buffer pool. You can see the simplicity of the DB2 smart wizard operation and the powerful function of optimizing the Buffer Pool performance.


1) You can create a graphical interface wizard in two ways from the buffer pool ).


Create a buffer pool on the graphic interface: In the DB2 control center, right-click "buffer pool" and choose create. In the create wizard, enter the buffer pool name, select the page size that matches the tablespace, and enter configuration information such as the buffer pool size.


650) this. width = 650; "title =" 5.jpg" src = "http://www.bkjia.com/uploads/allimg/131228/2243131310-4.jpg"/>


Command to create a buffer pool:


650) this. width = 650; "title =" 6.jpg" src = "http://www.bkjia.com/uploads/allimg/131228/2243131243-5.jpg"/>


Buffer Pool created successfully:


650) this. width = 650; "title =" 7.jpg" src = "http://www.bkjia.com/uploads/allimg/131228/2243133521-6.jpg"/>


2) observe the impact of the database on system performance after the buffer pool is created.


CPU and memory usage when DB2 is stopped


650) this. width = 650; "title =" 1.jpg" src = "http://www.bkjia.com/uploads/allimg/131228/2243132442-7.jpg"/>


CPU and memory usage after DB2 is started


650) this. width = 650; "title =" 2.jpg" src = "http://www.bkjia.com/uploads/allimg/131228/22431361G-8.jpg"/>


CPU and memory usage after connecting to the DB2 database instance


650) this. width = 650; "title =" 3.jpg" src = "http://www.bkjia.com/uploads/allimg/131228/2243133562-9.jpg"/>



After the buffer pool is established, the system memory is gradually used from the DB2 start to the database instance connection process. Due to the role of the buffer pool, the memory usage is reasonably allocated and maintained at a stable level. It does not cause problems with server performance because the memory is fully occupied or the memory is insufficient.


Iii. Automatic Configuration Maintenance

DB2 automatically executes most tasks and has automatic maintenance capabilities. This self-management capability is very beneficial for small and medium businesses that cannot employ a full-time database administrator to manage DB servers. On the other hand, if a database administrator is hired, he will get more time to deal with the company's advanced technologies and improve work efficiency. Currently, we mainly describe the advantages of DB2 automatic maintenance through actual operations.

Select a database from the control center. The database size, last backup time, and automatic maintenance settings are displayed in the lower right corner of the database ). Displays the current database status in the form of a view, and allows the DB administrator to quickly determine the maintenance required for the current database. Based on the Smart wizard and Smart Information Reference Guide for database administrators, DB2 reduces the trouble of maintaining and configuring database administrators.


650) this. width = 650; "title =" 4.jpg" src = "http://www.bkjia.com/uploads/allimg/131228/2243132514-10.jpg"/>



1) Select a database in the control center, right-click and select "automatic configuration maintenance", and configure it through the wizard.


650) this. width = 650; "title =" 5.jpg" src = "http://www.bkjia.com/uploads/allimg/131228/2243133938-11.jpg"/>


2) automatic maintenance allows DB2 to automatically execute maintenance jobs such as REORG, RUNSTATS, and BACKUP.

The smart wizard configuration consists of the following parts:

● You define a maintenance window in which maintenance tasks can be executed with minimal interference. For example, if the system has at least activity between and on Sunday, a maintenance window can be created during this period.

● There are two maintenance periods, one for online operations and the other for offline operations.

● During the maintenance window, DB2 automatically performs maintenance operations when maintenance is required.

The following operations describe the automatic maintenance configuration process:


650) this. width = 650; "style =" float: none "title =" 6.jpg" src = "http://www.bkjia.com/uploads/allimg/131228/2243132934-12.jpg"/>

650) this. width = 650; "style =" float: none "title =" 7.jpg" src = "http://www.bkjia.com/uploads/allimg/131228/224313F53-13.jpg"/>

650) this. width = 650; "style =" float: none "title =" 8.jpg" src = "http://www.bkjia.com/uploads/allimg/131228/224313H46-14.jpg"/>



Summary:

Innovation is the cornerstone of technological progress. Innovation in IBM is an extremely important part of the development of database servers. As early as the 60 or 70 s of the last century, IBM, as a pioneer in this field, has developed advanced data management technologies. Until now, IBM has maintained this innovative spirit, thousands of IBM technical experts are constantly innovating in the information management field. This is evidenced by the acquisition of data management patents. After the unremitting efforts of IBM, many large industries and fields in the world, including telecommunications, finance, and education, all rely on IBM products, IBM provides them with data management solutions that meet the greatest source and competency challenges. DB2 provides new capabilities from innovation, reduces the burden of database management, improves database operation performance, and reduces the cost of infrastructure construction. By choosing IBM's innovative technologies, we will see a brighter world.



This article is from the blog "Yang Jian blog space". For more information, contact the author!

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.