Abstract:
In a computer system with a DBMS running thereon, management of the performance of a storage apparatus is executed by using a performance indicator provided by a user job so as to simplify the management of the performance. For this reason, a management server employed in the computer system monitors an operating state of each system element, a response time onto a job and other information. A method for estimating a processing time is given to the management server, which issues a setting modification command based on an estimated processing time.
Abstract:
There is a program for transmitting a prefetch command to a database management system (DBMS) so that access data of the DBMS can be prefetched to a storage. The DBMS is able to generate an access plan conscious of prefetch and to access database (DB). The DBMS is, however, unable to recognize that a prefetch command program is halted and it cannot generate an access plan at a proper I/O cost. Database management system servers 1, 2, . . . monitor a prefetch program of a management server 5, understands that the prefetch program is halted and it can optimize an execution plan to access storage apparatus 3, 4, . . . by using an I/O cost changed when the prefetch program is halted.
Abstract:
Provided is a computer system including: a computer running as a DB server; a storage system including a plurality of disk drives for storing data; and a management module, in which: at least one of the plurality of disk drives stores data of a DB schema written by the computer; the management module specifies the DB schema to be accessed based on a received query, transmits, to the storage system, an instruction to copy at least a portion of the data of the specified DB schema from the disk drive to a memory, and transmits, to the storage system, an instruction to control an rpm of the disk drive that stores the data of the specified DB schema; and the storage system controls the rpm of the disk drive based on the instruction. Accordingly, power consumption of the storage system can be reduced even if installed disks increase in number.
Abstract:
A database recovery method including a computer and a storage system, in which: the storage system includes a disk drive for storing data; the disk drive includes a data volume, a snapshot volume, a database log for storing an update log, and an update journal for storing update information of the data volume; a recovery point for indicating an end point of a range to which the update journal is to be applied and a starting point of a range to which the database log is to be applied is recorded to recover the data volume; and when the database is to be recovered, the update journal is applied to the snapshot volume up to the recovery point, the snapshot volume after the update is switched to the data volume, and the database log after the recovery point is applied to the data volume that is set by switching.
Abstract:
A method include a configuration definition creation step of writing configuration information on a primary site into a storage subsystem; a data transfer step of copying the configuration information, which is written into a storage device, to a storage subsystem in a secondary site over a network; a data reception step of receiving the transferred configuration information and storing it in the storage subsystem in the secondary site; and a configuration definition step of reading the stored configuration information and settings up a server in the secondary site.
Abstract:
A host and a storage system each keep a shared identifier indicating a state of a system. The storage system acquires, at update of data, a data pair including data for a change through processing of the host and data before the update. The storage system relates the data pair to a shared identifier. When the host indicates an identifier, the storage system restores data using the data pair.
Abstract:
A disk rotation control part for controlling the rotations of a plurality of disk devices is provided. The configuration is such that a disk of a disk device for which an access will not be generated is rotated at a second rate of speed, which is faster than 0, and slower than a first rate of speed, which is the rotation speed at access time. DB management information comprises information denoting which DB schema inside a DB is stored in which location. The disk rotation control part, based on a query plan of a query received by the DBMS, and DB management information, specifies the storage location of a DB schema to be accessed when this query is processed, and rotates a disk of the disk device comprising the specified storage location at a first rate of speed.
Abstract:
A host and a storage system each keep a shared identifier indicating a state of a system. The storage system acquires, at update of data, a data pair including data for a change through processing of the host and data before the update. The storage system relates the data pair to a shared identifier. When the host indicates an identifier, the storage system restores data using the data pair.
Abstract:
An objective of the present invention is to carry out setting efficiently both a database management system and a storage subsystem. In an information processing system having computers 1, 2 and the storage subsystem 3, the following processes are executed. A system definition program 5 in the computer 1 generates based on the database design information, database definition information defining a structure of plural tables constituting the database and storage location volume of data of the plural tables, and volume definition information defining a condition for determining a volume configuration. A volume definition program 6 in the storage subsystem 3 determines based on the volume definition information from the management server 1, a storage device configuring the volume out of plural storage devices 36a . . . 36p. A database management system program 9 in the computer 2 stores the data of each table in the volume of the storage subsystem 3, based on the definition information from the management server 1, and accesses the volume in response to a request from outside.
Abstract:
Provided is a computer system, including: at least one of database computers, in which a database management system operates; a storage system for storing a database operated by the database management system; and a management computer for managing the database computer and the storage system, the storage system having a cache memory for storing data temporarily and a physical disk drive for storing the database, in which the management computer changes capacity of the cache memory which is allocated to the database computer where the database management system operates, and instructs the database management system to change an access plan according to the change in capacity of the cache memory allocated to the database computer.