Unlock instant, AI-driven research and patent intelligence for your innovation.

Method and device for partitioning DB2 database table of mainframe

A database and table partitioning technology, which is applied in the direction of database indexing, structured data retrieval, special data processing applications, etc., can solve problems such as low efficiency, error-prone, time-consuming and labor-intensive manual writing, etc., and achieve the effect of flexible configuration and convenient operation

Pending Publication Date: 2020-11-20
BANK OF CHINA
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] Under the existing z / os operating system TSO environment, only the partition statement of the DB2 database table is manually written, and the partition statement cannot be generated in batches according to the specific table partition requirements, and manual writing is time-consuming, laborious, inefficient, and error-prone

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 device for partitioning DB2 database table of mainframe
  • Method and device for partitioning DB2 database table of mainframe
  • Method and device for partitioning DB2 database table of mainframe

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0027] In order to make the purpose, technical solutions and advantages of the embodiments of the present invention more clear, the embodiments of the present invention will be further described in detail below in conjunction with the accompanying drawings. Here, the exemplary embodiments and descriptions of the present invention are used to explain the present invention, but not to limit the present invention.

[0028] figure 1 It is a schematic diagram of a method for partitioning a mainframe DB2 database table according to an embodiment of the present invention, as figure 1 As shown, the embodiment of the present invention provides a kind of mainframe DB2 database table partitioning method, realizes automatic batch generation partition statement and carries out the partitioning of DB2 database table, comprises:

[0029] Step 101: configure table partition parameter files and batch job files according to DB2 database table partition requirements;

[0030] Step 102: use the...

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 provides a method and device for partitioning a DB2 database table of a mainframe, and the method comprises the steps: configuring a table partitioning parameter file and a batch operation file according to the partitioning demands of the DB2 database table; executing REXX script programs in batches by utilizing the batch job files, and customizing tables under PDS in the DB2 database according to the table partition parameter files to determine partition statements; and partitioning the DB2 database table according to the partition statement. According to the invention, the characteristic of flexible REXX language configuration is utilized to call the REXX script program, the partition statements of the DB2 database table are automatically generated in batches according to specific DB2 table partition requirements, configuration table partition parameter files and batch operation files, the partition statements of the required table can be generated in batches only by simply configuring partition parameters, and the method is convenient, rapid, flexible in configuration and convenient to operate.

Description

technical field [0001] The invention relates to the technical field of computer data processing, in particular to a method and device for partitioning a mainframe DB2 database table. Background technique [0002] This section is intended to provide a background or context for implementations of the invention that are recited in the claims. The descriptions herein are not admitted to be prior art by inclusion in this section. [0003] In systems such as large-scale aviation, insurance, and banking, due to their stability requirements and the characteristics of extremely large data volumes, the systems used are mostly the mainframe z / os operating system, and the database system is mostly DB2. In order to protect the DB2 database The relative isolation of table data and the access efficiency of data access, usually DB2 database tables need to be partitioned. In the overseas core banking system, the DB2 database is used for data storage. Because it involves the storage of mass...

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): G06F16/22
CPCG06F16/2282
Inventor 严安宁朱政赵天衢安宏伟
Owner BANK OF CHINA
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

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

© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com