Method and system for improving availability of DB2 DPF

An availability, one-to-one correspondence technology, applied in the database field, can solve problems such as inability to access partitioned data, low availability, and reduced user experience

Inactive Publication Date: 2015-12-02
INSPUR BEIJING ELECTRONICS INFORMATION IND
View PDF11 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] However, when any node in DPF fails, because DPF adopts a non-shared architecture mode, the application of the client cannot access the partition data under the fail...

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method and system for improving availability of DB2 DPF
  • Method and system for improving availability of DB2 DPF

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0038] Below will combine the embodiment of the present invention Attached picture , clearly and completely describe the technical solutions in the embodiments of the present invention, obviously, the described embodiments are only some of the embodiments of the present invention, not all of them. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0039] The embodiment of the present invention discloses a method for improving the usability of DB2DPF, which is applied to DB2DPF. DB2DPF includes N nodes, where N is an integer not less than 2; see figure 1 As shown, the method includes:

[0040] Step S101: Allocate NAS network storage to N nodes, so as to use NAS network storage to store the sqllib control file in DB2DPF.

[0041] It should be noted that in the existing DB2DPF, the sqllib control file is stored on a...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention discloses a method for improving the availability of a DB2 DPF. The method is used for the DPF including N nodes and comprises steps of: allocating NAS network storage to the N nodes in order that a sqllib control file in the DPF is stored in the NAS network storage; creating M failed resource sets; dividing the N nodes into M groups; configuring partition resources corresponding to M groups of nodes to the M failed resource sets one to one; and when any one of the N nodes is faulted, transferring the failed resource set corresponding to the faulted node to any other normally-operating node. An application of a client may acquire the partition resource corresponding to the faulted node by accessing the node provided with the failed resource set corresponding to the faulted node, thereby guaranteeing that data service can be still normally provided for an external unit when a single node is faulted and improving the availability of DPF.

Description

Technical field [0001] The invention involves the field of database technology, which especially involves a method and system for improving the availability of DB2DPF. Background technique [0002] DB2 is a set of relational database management system developed by IBM, which can be applied to a variety of operating systems.DPF (DPF, that is, DataBasePartitation Feature, database partition characteristics) is a multi -zone database of DB2. It can divide a large database into multiple database partitions. Different database partitions can run under different nodes and use the non -shared architecture mode., Enable multiple database partitions of DPF to use parallel work loads to handle workloads. [0003] However, when any node in DPF fails, because the DPF uses a non -shared architecture mode, the client's application cannot access the partition data under the fault node.question.It can be seen that the problem of single -point failure in DPF itself makes it lower available and re...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
IPC IPC(8): H04L12/24H04L1/22
Inventor 段利宁
Owner INSPUR BEIJING ELECTRONICS INFORMATION IND
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap