Method and apparatus for managing faults in storage system having job management function

• US 7,552,138 B2
• Filed: 10/12/2005
• Issued: 06/23/2009
• Est. Priority Date: 03/28/2003
• Status: Expired due to Fees

• Current Assignee: Hitachi, Ltd.
• Original Assignee: Hitachi, Ltd.
• Inventors: Mogi, Kazuhiko, Nishikawa, Norifumi, Kawamura, Nobuo, Nemoto, Naokazu
• Primary Examiner(s): AL HASHEMI, SANA A
• Application Number:
  US11/247,210
• Publication Number:
  US 20060031270A1
• Time in Patent Office: 1,350 Days
• Field of Search: 707100-102
• US Class Current: 1/1
• CPC Class Codes: G06F 11/0709 in a distributed system consisting of a plurality of standalone computer nodes, e.g. clusters, client-server systems
• CPC Class Codes: G06F 11/0727 in a storage system, e.g. in a DASD or network based storage system drivers for digital recording or reproducing units G06F3/06; circuits for error detection or correction within digital recording or reproducing units G11B20/18; for distributed storage of data in networks, e.g. transport arrangements for network file system [NFS], storage area networks [SAN] or network attached storage [NAS], H04L67/1097
• CPC Class Codes: G06F 11/0748 in a remote unit communicating with a single-box computer node experiencing an error/fault remote testing G06F11/2294
• CPC Class Codes: G06F 11/0775 Content or structure details of the error report, e.g. specific table structure, specific error fields
• CPC Class Codes: G06F 11/2294 by remote test
• CPC Class Codes: G06F 3/0617 in relation to availability
• CPC Class Codes: G06F 3/0635 by changing the path, e.g. traffic rerouting, path reconfiguration
• CPC Class Codes: G06F 3/067 Distributed or networked storage systems, e.g. storage area networks [SAN], network attached storage [NAS]
• CPC Class Codes: H04L 67/1097 for distributed storage of data in networks, e.g. transport arrangements for network file system [NFS], storage area networks [SAN] or network attached storage [NAS]
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

A computer system identifies jobs affected by a fault which occurs in any device or mechanism in a storage system to control the execution of such jobs. The computer system includes a DBMS server device, a virtualization switch device, and storage device. Each of these devices holds part of data mapping information on a data mapping path from a particular DB table accessed by a job, through a logical volume for storing the table, to physical disk units for distributively storing data on the volume. The management server device acquires the part of data mapping information from each device, and integrates the data mapping information on a job-by-job basis. When any device or mechanism fails on the data mapping path, the management server device identifies jobs affected by the fault with reference to the data mapping information. The management server device also controls the execution of these jobs.

Claims

1. A computer-readable medium having computer-executable instructions for a server computer, comprising:

collection code causing the server computer to collect a storage device management information on a storage association between a plurality of physical disk units and a plurality of logical disk units of a storage device, and to collect a DBMS server Information on an DBMS computer association between a plurality of jobs and a plurality of database tables configured by a DBMS server and a plurality of files of a file system, the DBMS server and the file system being executed by a DBMS computer;

integration code causing the server computer to integrate the DBMS computer association and the storage association into a server management information stored in the server computer, as data mapping paths from the plurality of jobs to the plurality of physical disk units;

receiving code causing the server computer to receive a report identifying a fault physical disk unit from the plurality of physical disk units; and

identification code causing a job affected by the fault physical disk unit to be identified from the plurality of jobs, based on the server management information and the report, for displaying the job affected.

2. A computer-readable medium having computer-executable instructions for a server computer according to claim 1, further comprising:

a virtualizer collection code causing the server computer to collect a virtualization information on a virtualizer association between a plurality of virtual volumes and the plurality of logical disk units from a virtualizer device coupled to the DBMS computer and the storage device, and

a virtualizer integration code causing the server computer to integrate the virtualizer association into the server management information.

3. A computer-readable medium having computer-executable instructions for a server computer according to claim 1, wherein, the DMBS server information comprising a job execution control table and a DBMS server management table.

4. A computer-readable medium having computer-executable instructions for a server computer according to claim 1, further comprising:

storing code causing the server computer to store a code of the report and an identifier of the fault physical disk unit in an event dictionary.