Method and device for information collection of operation system and database

Abstract

The invention discloses a method and device for information collection of an operation system and a database. The method comprises the steps that a shell script is used to call an information query command of the operation system and an information query command of the database; a document output after calling of the information query command of the operation system and a document output after calling of the information query command of the database are converted into documents of an HTML format; and each document of the HTML format is displayed via an FRAME page, and information of the operation system and information of the database can be displayed. The method has the advantages that the information of the operation system and the information of the database can be collected automatically; human cost can be reduced; and the information can be checked conveniently.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to an operating system and a database information collection method and device. Background technique [0002] At present, the collection of Inspur Tiansuo K1 system configuration information, system operation status, and database information running on K1 requires manual execution of corresponding operating system and database commands, which is a cumbersome process. For different types of databases such as ORACLE, DB2, mysql, etc., in order to obtain information such as database configuration, operation, and logs, different methods and commands need to be used according to the type of database, which requires operators to be familiar with various types of databases, which is undoubtedly very difficult things. And each operating system or database command generates an independent file. The generated file is generally a text file. There may be a lot of generated files, which also ...

AI Technical Summary

Problems solved by technology

[0002] At present, the collection of Inspur Tiansuo K1 system configuration information, system operation status, and database information running on K1 requires manual execution of corresponding operating system and database commands, which is a cumbersome process

For different types of databases such as ORACLE, DB2, mysql, etc., in order to obtain information such as database configuration, operation, and logs, different methods and commands need to be used according to the type of database, which requires operators to be familiar with various types of databases, which is undoubtedly very difficult things

And each operating system or database command generates an independent file. The generated file is generally a text file. There may be a lot of generated files, which also brings inconvenience to file viewing and reading.

Images