KR20000024509A - method for monitoring computer room - Google Patents

Abstract

PURPOSE: A method for managing a computation room is provided to optimize an operation of computer by monitoring simultaneously all system resources. CONSTITUTION: A method for managing a computation room comprises the steps of: detecting log-in information to be connected to a server; connecting a user's personal computer to the server according to the log-in information; extracting a system resource and an error data from the server; converting the received data to be used on a personal computer; classifying the converted data to store the converted data to a data base; storing the classified data to the data base; and displaying the stored data on a user's screen.

Description

Method for monitoring computer room

The present invention relates to a computer room management method, in particular, to monitor all the resources required for system monitoring of all server systems and routers, such as Sunmicro system, Hewlett Packard, IBM, etc. at the same time, and stores the contents in a DB to manage and 24 hours 365 days It can be monitored and the 10 minute maximum value, 1 hour maximum value, daily maximum value and the desired part can be viewed in detail, so the computer manager can see a lot of data in an instant and the status of the resources managed by the server. It is about computer room management method that monitors the data, manages it with database, and delivers the contents to the person in charge by pager or email when there is an error.

Performance monitoring of conventional systems runs on Unix-based, which requires the use of enormously expensive equipment. Since the performance tool box runs on Unix-based systems, the system is expensive and Unix-based programs, so it is very difficult to install and only available on IBM-RS 6000 (UNIX server). And it's very hard to use this information, so only experts can see it.

The performance tool box (IBM) analyzes the resources of various systems and presents their trends. Then save the contents to a file. Therefore, monitoring is not available 24 hours a day, 365 days.

Such a performance tool box (PTX) uses a unix server, which is expensive and programs are expensive. Also, because PTX saves to file, it does not extract the desired value on the desired date as easily as DATA BASE. PTX does not have 10 minutes, 1 hour, daily maximum (or minimum), so it takes a long time to interpret and does not show daily trends at a glance like the computer room management system according to the present invention, IBM-RS 6000 (UNIX server) only monitoring.

PTX does not have a manager calling function when various errors occur in the system. Only system monitoring is required. PTX does not store and manage error details. If there is other monitoring program (monitor), it is only one-time because it shows and disappears on the screen, so it does not show past data but only present system information.

In terms of performance tuning, performance tuning refers to optimizing server system resources to make the best use of server performance. As a kind of auto tuner tunes to your personality, the server's settings vary depending on whether you are using it as a DATA Server, for scientific operations, or as a mail or other application. For example, thewall value in the server sets the size of the memory, a buffer that stores data in the middle of network communication. If you hold this too largely, the memory will be wasted because it is fixed in memory and used exclusively for network buffers. If you hold too little, the buffer value is too large because too many people need data buffers because too many people communicate. There is an error in network communication.

And in the case of hard disks, if many users access a single hard disk and keep a lot of data or use a lot of data, the system will hang (hang) because the hard drive can't handle it.

It monitors all the resources needed on other servers 24 hours a day and stores them as DATA BASE, so you can see system resource changes and bottlenecks of various resources. For example, even if the server has the best performance and can handle 5000 users, if tuning is wrong, the server will not be able to function even if less than 500 users enter. Therefore, optimizing a server's performance is essential to its role. However, in Korea, there is no performance tuning yet, and it is not possible to tune the server itself because it performs performance tuning in external fields that are not directly related to the system.

Since all resources of the system are managed by the server, you can use the server's proper performance by monitoring the server's resources and fixing the server's incorrect installation, design, and configuration. However, in the related art, it is impossible for a user to monitor the resource at all times for 24 hours, so when a problem occurs, the system resource can be analyzed and a huge amount of time is spent to find the problem. Depending on the user's change and what application is running at that time, instead of looking at the system resource, if the person viewing the tuning does not see the maximum value of the various system data that causes the system problem, the appropriate action cannot be taken. to be. Therefore, by always monitoring and storing the data, it is possible to find out in advance what causes the problem and take action accordingly.

The analysis of system resources also reveals what resources are needed for this system, for example, adding a central processing unit, adding memory, and configuring the file system of the hard disk properly. It is an important resource.

An object of the present invention is to provide a computer room management method.

In order to achieve the object of the present invention, a computer room management method comprises: a login information detection step of obtaining login information for accessing a server;

A login step of accessing the server according to the login information;

A data extraction step of extracting system resources and error data from the server;

A data conversion step of converting data so that the data received from the server can be used on a PC;

A data classification step of classifying the received and converted data for storage and display in a database;

A data storage step of storing the classified data in the database; And

And displaying the classified data on a screen selected by the user.

The invention will be more clearly understood from the following description with reference to the accompanying drawings.

1 is an overall configuration diagram of a computer room management method according to the present invention.

2 is a flow chart of a computer room management method program according to the present invention.

3 is a diagram illustrating a processing flow when an error occurs.

4 is a flowchart informing the help desk or a remote client of the details of the computer room.

5 is a diagram illustrating a process of processing when a problem occurs or a query is in the computer room.

6 is a diagram illustrating a flow of historical data.

7 is a diagram illustrating a processing flow of data in a refresh form.

1 is an overall configuration diagram of a computer room management method according to the present invention. As shown in FIG. 1, there are servers, routers, temperature, humidity, UPS, and the like that are managed, pagers, faxes, PCs, and e-mails that receive alarm signals when a problem occurs in the central management system or server. There is a remote client for remote monitoring.

The computer room management method according to the present invention simultaneously monitors the resources of all systems required for system monitoring of the Sun micro system, Hewlett Packard, IBM server and router, and stores the contents in a database to manage and monitor 24 hours 365 days. In addition, the resources of the IBM system are displayed as a graph to be processed at a glance, and the detailed data is output when the maximum value of 10 minutes, maximum of 1 hour, maximum of daily unit and the desired part are output. The advantage is that you can see it in a flash.

In the computer room management method according to the present invention, the status of resources managed by the system server is monitored and managed by the DB, and if there is an error, the contents are delivered to the person in charge by pager or email. For example, if the user is too busy and the process is so busy that it can't act as a server, it can send the contents of this to the administrator, and the PC notifies the contents of the alarm. is.

When an error occurs in the system, it automatically detects it and informs the computer, manages the error with a database, and inputs a solution according to this information in advance so that the administrator can see it and resolve it immediately. Previously, it was determined whether or not an error occurred by looking at an error code book, and the computer room system according to the present invention sends a solution of the error when a certain type of error occurs and is automatically processed when a simple error occurs. In addition, for monitoring purposes, every program has a space to store error contents.

The system according to the present invention is managed as a log file. When the contents of the log file are added, the contents of the error are checked in the database, and the corresponding actions are taken, that is, the alarm function, the solution, and the automatic recovery process.

In addition, the system according to the present invention is to monitor the temperature and humidity of the computer room and control the thermo-hygrostat by the integrated management of the computer room, by taking a picture of the inside of the computer room at regular intervals with the camera to see what outsiders are doing to access the computer room, Check the list of people who are accessing and using the server from time to time and store the contents in a database for management. Later, if something happened in a certain time frame, you can see who accessed this system, so even if hacked, it always manages system users and saves it as a database, so it is easy to deal with problems later, and the CPU of the process By constantly monitoring and storing the contents in the order of the highest share of the market share, it establishes a criterion to determine which program affects the system in a certain time period and to cope with it.

In addition, the system according to the present invention is made of PC base and can be used without burdening the user. And all contents are managed by database, and if you set a certain period, for example, 30 days, it saves 30 days of data every time the date changes. As long as the actual detailed data is preserved, the system resource state is kept for one hour or one day.

If an error occurs on the server, it is when system resources are used to the maximum, so the highest value of one hour of data is managed by the database, so the maximum value of one hour even if the data retention period, for example, 30 days, has passed. And keep the maximum of the day.

In addition, in the computer room management system (system monitored by the PC) according to the present invention by entering the IP (Internet address) through telnet to enter the user ID (user id) and password (password) to access the system problem in system security Of course, if you have telnet open to log in remotely, you can manage anywhere in the world and even if you have prevented telnet from logging in remotely for security reasons, the computer room management method according to the present invention is a problem because it enters the local system. If you want to see the data from the outside when you prevent access to the server from the outside, the computer room management program according to the present invention manages the system content and the client of the external computer room management system through tcp / ip Is delivered to the outside world without any security problems. It can be used to monitor the system requirements.

In addition, the computer room management method according to the present invention can be stored in the database that received the system resources from the client, the database can be duplicated, the computer room management system according to the present invention to see the past data at this time By importing a database stored on the server, analyzing the historical data, you save the database directly from the field, and the help desk stores all of the server's resources so you don't have to visit it.

It also allows multiple clients to be monitored remotely from multiple locations. It accesses the asp database contents from the web page from the web page, logs in, and sees past data contents.

In addition, the remote client can be made into an OCX control to function as a remote client directly on a web page. If you have a special client program and do not need to install it, and you are connected to the Internet anywhere in the world, you can view the contents of the computer room.

As described above, according to the computer room management system according to the present invention, all matters of the computer room system are monitored and monitored, and all of them are managed in a database so that the changed contents can be seen later at a time without a separate administrator. In addition, the information of the computer room is taken with a camera and saved as a file, which is later managed to monitor the actual situation of the computer room by monitoring whether there are unnecessary people in the computer room or what the computer room is, and transmitting the contents of the computer room to the client through the Internet. Now you can see the image of the computer room. Therefore, if you can see the contents of the computer room like a surveillance camera in a bank, it is transmitted remotely, so it is not restricted to the place. You can see wherever the Internet is connected. For example, if a water pipe bursts in the computer room unless there is a manager, take immediate action by remotely monitoring this at the help desk.

In addition, the computer room management system according to the present invention centrally manages everything on the PC. In other words, the convenience of management and security, the automatic alarm function when a problem occurs, the database of all data can be seen later without the administrator.

In addition, the computer room management system according to the present invention does not require any special installation because it uses the monitoring commands for system resources supported by the operating system itself, and is made of a script (unix command and program entered) according to the present invention to affect the server. Do not give. Therefore, the system according to the present invention can be applied to all operating systems accessed through all telnet, and can be reinforced by making an executable file instead of a script by adding a program later when there is a special function.

In addition, multiple servers can be managed at the same time, and by monitoring and monitoring servers, users can create multiple servers to monitor and cope with them.

In addition, it immediately connects to experts in the field by notifying the system as soon as an error occurs, delivering alarms, calls and node error details, and fax and email solutions to error details and errors. Since the response to this error content is specified later and saved in the DB, it saves time to cope with the same error later and it is easy to solve because it refers to the solution before. Of course, in the case of a simple error, you can solve the problem by running a script that resolves the error.

In addition, by controlling the inflow of fresh air into the computer room, the inlet of fresh air into the computer room, such as eltalpy. It can be processed automatically by connecting it to a PC with a PLC or a dedicated controller.

2 is a flow chart of a computer room management method program according to the present invention. As shown in Figure 2, the computer room monitoring method according to the present invention is composed of the following steps. Each step is described as follows.

1) Login Condition Detect

Login information file is created in the program itself and the information is automatically read from the file when the program is executed. The content of the read information reads the server's IP address, ID, password, and other information about data reception corresponding to the socket number of each network. The information file can be added and deleted in the program, and the set file information can be viewed at any time in the program. You can also add new nodes in your program and try to connect at the same time to receive data.

2) Login to Server

This part attempts to connect to the server via remote telnet based on the read information. Attempt to connect to the server's IP address and send ID and password simultaneously. The server side receives the access signal, checks the accessor's ID and password, and if it does not match, sends a message to the access side that the access ID and password are incorrect and disconnects. If the ID and password match, the server uses the pre-entered script command that corresponds to the user's ID to get information about the various resources of the system and various system errors, and sends the data continuously until the connection is lost.

3) Get Translated Data from Server

If the connection with the server is successful, the connection side (program) requests the server for the data reception interval to receive data from the login information file, and the server side requests the data for its script command according to the data interval received. Send to the program side. In this case, the data to be transmitted is transmitted in accordance with the data reception intervals through one or more Telnets according to the type of data information.

When sending data from the server side to the program side via telnet, the program side cannot recognize what data is sent from the server side. Thus, the data is transformed according to the promised rules to recognize the value of each data.

If the script command is embedded on the server side (large server), it executes the appropriate infinite loop script according to the scan time (the time to get the data). If the script command is not embedded in the server, the program automatically sends the script contents line by line to the connection side (monitoring server).

Enter vmstat 5 command on one side of telnet connection or execute <script command to view the utilization of individual CPU> when connecting as root user.

Vmstat 5: Send Vmstat data through Telnet every 5 seconds

Vmstat: Command to view CPU, Memory, Thread, Faults, Paging space usage

The data transmitted from the server consists of a delimiter indicating the beginning of the data, the actual data content, and a delimiter indicating the end of the data.

<Example of script command to see utilization for individual CPU>

integer cpunum cpunum1

cpunum = $ (sar -P ALL 1 | wc -l)

while:

do

let cpunum1 = cpunum-4

echo cpunum $ cpunum1

sar -P ALL 2 | tail-$ cpunum1cut -c 10-50

mem1 = $ (vmstat | tail -1)

echo vmstat $ mem1

sleep 12

done

For another telnet connected to the server, type the following script command.

<Example of script command to see resource change about Network, I / O, Process, Error>

export LANG = en_US

integer oldnum1 newnum1 errno1 errtail1 numtop netnum1 netnum2

iostat 15 &

numtop = 1

erroldnum1 = $ (errpt | wc -l)

netnum1 = $ (netstat -i | wc -l)

while:

do

echo etsgo

let numtop = numtop + 1

netstat -m | grep mbuf

let netnum2 = netnum1-1

netstat -i | tail-$ netnum2

ps gu | head -11

errnewnum1 = $ (errpt | wc -l)

if ((erroldnum1 <errnewnum1))

then

let errtail1 = errnewnum1-1

let errno1 = errnewnum1-erroldnum1

echo error $ errno1

errpt | tail-$ errtail1 | head-$ errno1

echo errend

fi

erroldnum1 = errnewnum1

echo etsend

sleep 13

done

If necessary, monitor various log files via another server connection telnet.

By using the Tail -f command in the background, when the contents of the log file change, the changed contents are displayed and sent to the server side.

It also recognizes the server side of the console (eg shutdown) and handles it automatically. If necessary, create a monitoring program on the server side to receive more specific data.

4) Data Classification

Classify data to store only general data part of received data in database.

<Database list of general data received>

CPU: user, system, idle, wait

Memory: avm, free

Page: page_re, page_pi, page_po, page_fr, page_sr, page_cy

Thread: kthr_r, kthr_b

Faults: faults_in, faults_sy, faults_cs

Mbuf: clustpi, kbal, inuse, denied, calls, failed, memuse, memmax, mapd

Network IO (Hdisk): hdisk0 (read, write, tm_act) hdisk1 (read, write, tm_act)

Hdisk2 (read, write, tm_act) hdisk3 (read, write, tm_act) hdisk4 (read, write, tm_act)

Hdisk5 (read, write, tm_act) hdisk6 (read, write, tm_act) hdisk7 (read, write, tm_act)

Hdisk8 (read, write, tm_act) hdisk9 (read, write, tm_act) hdisk10 (read, write, tm_act)

Hdisk11 (read, write, tm_act) hdisk12 (read, write, tm_act) hdisk13 (read, write, tm_act)

Hdisk14 (read, write, tm_act) hdisk15 (read, write, tm_act) hdisk16 (read, write, tm_act)

Hdisk17 (read, write, tm_act) hdisk18 (read, write, tm_act) hdisk19 (read, write, tm_act)

Network Packet: lo0 (Ipkes, Ierrs, Opkts, Oerrs, Coll), en0 (Ipkes, Ierrs, Opkts, Oerrs, Coll)

En1 (Ipkes, Ierrs, Opkts, Oerrs, Coll), en2 (Ipkes, Ierrs, Opkts, Oerrs, Coll)

at0 (Ipkes, Ierrs, Opkts, Oerrs, Coll), so0 (Ipkes, Ierrs, Opkts, Oerrs, Coll)

tr0 (Ipkes, Ierrs, Opkts, Oerrs, Coll), fi0 (Ipkes, Ierrs, Opkts, Oerrs, Coll)

css0 (Ipkes, Ierrs, Opkts, Oerrs, Coll)

Detail Cpu (cpu1 ~ cpu24): cpu1 (user, system, idle, wait), cpu2 (user, system, idle, wait)

Cpu3 (user, system, idle, wait), cpu4 (user, system, idle, wait), cpu5 (user, system, idle, wait)

Cpu6 (user, system, idle, wait), cpu7 (user, system, idle, wait)

5) determining whether there is an error

The data from the server always contains the number and contents of the error data, so it is determined whether the error data of the Unix system exists. If the currently received data includes error data, the error processing processor operates separately from the general data processing processor to separately process an error part. That is, it processes general data and error data.

6) Save to Database

Store the classified data in a database.

<How data is stored>

The data is stored in the database at the time the data is received according to the reception data interval (per second) set by the user. Further, the maximum value (or minimum value) of each item of the received data for 10 minutes is obtained, and the maximum (minimum) value of each item within 10 minutes is stored in the database every 10 minutes. In addition, the maximum (minimum) value of the received data for one hour is obtained and stored in a database such as storage of ten minute data at one hour intervals. That is, it stores data per second (actually received data) and data with a maximum (minimum) value of 10 minutes and 1 hour.

<Type of database to be saved>

The program finds the current time (year, month, and day) at run time, and then searches if the folder with the current year exists in the program's executable file. If the folder does not exist, the program automatically creates a folder with the name of the current year and copies the Today.mdb database file, which is automatically copied during installation, to the name of the current month.mdb in the current year's folder.

Data per second (actually received data) and 10-minute data are stored in the current month day .mdb database file automatically generated by the program, and hourly data is stored in the Year.mdb database file that is automatically copied at program installation. Whenever the date of the system is changed, the program searches for the existence of the folder of the current year and automatically creates a folder of the current year, copies the Today.mdb file to the current month.mdb in the current year's folder, and copies the current year's folder. If exists, copy Today.mdb file to current month.mdb in current year's folder and connect it with current month's folder.

7) Show Data

The classified data is displayed on the screen selected by the user in the program.

<Screen structure showing current received data in the program>

Among the data received from the current server, the CPU data is drawn in real time as a graph and shows the data for a total of 8 nodes. All received data including CPU shows data in real time in text form. In addition, all data of all nodes (total of eight) can be viewed in the form of text at once, and can be viewed in detail for each node.

9) Save Error to Database

ErrorDB.mdb, which is automatically copied when the program is installed, stores data about errors when receiving error data. The list of stored error data stores the number of the node where the error occurred, the identifier of the error, the error occurrence time of the server, the error description, and the data of the error resource.

10) Steps to Take Action on Errors (Error Execute)

The program can choose from the following three things the program will do when the user receives the error data.

① Always handle error even if any error data is received.

② Even if error data is received, error processing is not performed.

③ When error data is received, only error that matches process list is processed in error database.

<Handling list of error database>

The program is able to record the list of errors to be handled by the user and the actions to be taken so that the error can be selectively handled when the error is received. If a user wants to do some processing (eg pager call) when an error is received, add the information about the error to the error database (ErrorDB.mdb). The error list can be added, modified, or deleted at any time, and the handling of errors can be set at the same time.

<Action Plan for Error>

The program has an administrator pager call 1 on and off, an administrator pager call 2 on and off, and an e-mail sender on and off for handling errors.

<Enabling and disabling pager calls and sending e-mails>

The user can set the pager number to call, two pager messages, and the address to send E_mail for each of the eight nodes. That is, if the error data received when error data is received at node 1, the email is sent to the email address set by the user at node 1, and if the error is received at node 2, the error is processed. The email is sent to the email address set in node 2.

3 is a diagram illustrating a processing flow when an error occurs.

As shown in FIG. 3, FIG. 3 describes a routine for processing an error when an error occurs in the computer room monitoring method according to the present invention.

1) Compare Error Database

2) Checking if an error exists in the database (Error exist in DB)

Compares the received error data with the error database. If the received error does not exist in the error database, the error routine is terminated.

3) Ringing Alarm Signal (Alarm)

An alarm is triggered if a received error exists in the error database.

4) Determining the Selection of the Phaser 1 Call

Determines whether the pager 1 call is selected among the user input methods in the error database.

5) Calling Phaser 1

If pager 1 call is selected in the processing method, pager is called according to the processing method of error database.

6) Steps to determine the selection of pager 2 calls

Determines whether the pager 2 call is selected among the actions entered by the user in the error database.

7) Calling Phaser 2

If pager 2 call is selected as the processing method, pager is called according to the processing method of error database.

8) Steps to determine the choice of sending an email

Determines whether e-mail transmission is selected among user input methods in error database.

9) Steps to Send Email

If Send Email is selected as the processing method, send email according to the processing method of error database. The e-mail is sent with the contents of the error handling, the error handling method, and which server issued the error.

If the error routine is described in detail, the user selects what action the program should take when receiving the error data, and always selects the error processing no matter what error data is received. It handles the error and if it doesn't exist, it just exits after alarming.

If you choose to handle only the errors that match the error list in the error database, compare the received error data with the error database. If the received error does not exist in the error database, the error routine is terminated. If an error exists in the error database, the alarm is triggered and the error set in the error list is processed.

<Error Handling>

Error handling is programmed to run a process separate from the current process so that the speed of the program does not slow down. It determines whether pager 1 call is selected among the processing methods inputted by the user in the error database. If pager 1 call is selected in the processing method, pager message is called to pager 1 of the node where error data is received. It determines whether pager 2 call is selected among the processing methods inputted by the user in the error database. If pager 2 is selected as the processing method, pager is called by pager 2 calling number of the node where error data is received.

It is determined whether the e-mail transmission is selected among the processing methods input by the user in the error database, and when the e-mail transmission is selected, the e-mail is sent to the e-mail address of the node where the error data is received. When sending an e-mail, the e-mail contains the error description, the server where the error occurred, a description of the error, and a solution to the error.

4 is a flowchart informing the help desk or a remote client of the details of the computer room. As shown in FIG. 4,

(1) Help desk (where the computer room is managed centrally) In the entrance, select the computer room you want to connect to the management server there. It communicates with the management server there via socket communication.

(2) Check ID and Password to access computer management server.

(3) If ID and Password are wrong, teach that they are wrong and ask if you want to reconnect again.

(4) It is the part that transmits data. Through TCP / IP, TCP / IP transmits the general information of the system (CPU, MEMORY, IO, NETWORK, various errors, etc.) by the promised protocol of each other. It keeps sending until you disconnect.

(5) Receive the data of the transmitted part by the promised protocol and recognize the contents of the data.

(6) It is the part that shows the trend which is easy to see the data transmitted and received.

(7) The management server stores the data in the computer room. However, in case of help desk or remote client, the data should be stored when it is needed, so it is determined whether to save the data by selecting the data.

(8) The transferred data is saved in DB and managed.

(9) End.

5 is a diagram illustrating a process of processing when a problem occurs or a query is in the computer room. As shown in FIG. 5, when a problem occurs or a question is in the computer room, the help desk is immediately connected to solve the problem by using an image or a paintbrush or a file transfer, and the help desk or a remote client connects to the person in charge of the computer room. It is not difficult to manage and operate the computer room by freely communicating or transferring files from time to time as necessary. This is the program logic for exchanging and communicating data with the administrator and helpdesk or remote client.

(1) determining whether to communicate with the manager

You are asked whether you want to communicate with each other by selecting the manager you want or the computer room you want.

(2) determining video communication

It is a question of whether or not to communicate with each other through burns.

(2-1) Creating a Socket

Create a jacket. Connect the port number which is different from the existing port number.

(2-1) step of transmitting multimedia data

Perform multimedia communication using UDP / IP. It frequently sends and receives image and video data to the screen and speakers.

(3) determining the use of paint

Judgment whether you use the mouse or the tablet to show each other's thoughts on the board at the same time to communicate with each other on the board.

(3-1) step of creating a jacket

Create the jackets with each other. So prepare for data communication.

(3-2) step of transmitting coordinate data

The x that moves as the mouse or tablet point moves. The y coordinate value is transmitted and the transmitted coordinate values are lined up sequentially so that the picture appears. This is x. Giving and receiving y coordinates is like drawing multiple people on the same board.

(4) Determining whether there is a file transfer

Determine whether to transfer the file.

(4-1) Steps for connecting FTP

FTP transfers files together to transfer files.

(4-2) Step of transferring the selected file

Select the file to transfer and transfer the file.

(5) creating a communication socket

Create a TCP / IP socket.

(6) sending the text

Sends textual content to the generated communication socket that tells each other what they want to say.

6 is a diagram illustrating a flow of historical data.

As shown in Fig. 6, the program of the present invention has a total of eight node numbers, one of which is necessarily selected. The program always has the node number selected by the user as a variable until the end.

<When node is changed by user>

All data shown on the current screen is updated with the data for the selected node, and the data shown on the screen is updated by <Refresh Form Data Logic>.

<When you want to see the data you want>

The program first checks to see if the screen showing the selected data is currently running. When the screen is executed, <Refresh Form Data Logic> is used to update the data and show the updated data on the currently executed screen. When the screen is not executed (initial execution), the currently selected field (Date) , Week, and Month are checked.

<If data field is selected>

Takes the currently selected date from the program's calendar and checks whether there is a folder with the name of the selected year and a database file with the name of the selected month date in the folder. If the folder or file does not exist, a message is displayed and only a blank screen without data is displayed. If the folder and file exist, the data is displayed on the screen by connecting to the file.

<If Week field is selected>

Gets the date from Monday to Sunday of the week corresponding to the currently selected date in the program's calendar. It searches whether there is even one week of data corresponding to Year.mdb. If there is no data, a message is displayed and only a blank screen without data is displayed. If data exists, data corresponding to the selected week is displayed on the screen.

<Month field is selected>

Gets the currently selected month from the program's calendar, and searches Year.mdb for at least one month's worth of data. If there is no data, a message is displayed and only a blank screen without data is displayed. If data exists, the data corresponding to the selected month is shown on the screen.

7 is a diagram illustrating a processing flow of data in a refresh form. As shown in FIG. 7, when the screen for the data desired to be viewed by the user is executed, it is checked whether any of the currently selected fields (Date, Week, and Month) is selected. .

<If data field is selected>

(1) Compare whether the date currently selected in the program's calendar is the same as the date of data displayed on the screen.

If the calendar date is the same as the data date on the screen, focus on the screen. If the calendar date is different from the data date on the screen, check whether there are folders and files for the calendar date. If the folder and file do not exist, a message is displayed and only the blank screen without data is displayed. If the folder and file exist, the data is displayed on the screen by connecting to the file.

<When Week field is selected>

Compares the currently selected week in the program's calendar with the week of the data being displayed.

If the calendar date is the same as the data date on the screen, focus on the screen. If the calendar date is different from the data date on the screen, the Monday to Sunday date of the week corresponding to the date currently selected in the program calendar is selected. It retrieves and retrieves whether there is at least one week's data corresponding to Year.mdb.

If there is no data, a message is displayed and only a blank screen without data is displayed. If data exists, data corresponding to the selected week is displayed on the screen.

<Month field is selected>

Compares the month currently selected in the program's calendar with the month of the data on the screen.

If the date of the calendar is the same as the date of data on the screen, focus on the screen. If the date of the calendar is different from the date of data on the screen, the current month selected from the program's calendar is obtained and selected in Year.mdb. Retrieves if there is at least one month's data.

If there is no data, a message is displayed and only a blank screen without data is displayed. If data exists, the data corresponding to the selected month is shown on the screen.

<Data on the screen>

The data displayed on the screen in the program is divided into two types. Show the data in graph form. Show the data in tabular text.

The program stores the data received from the large server in the database every second, ten minutes, one hour, and one day, and the stored data can be viewed in a way that users want to view monthly, weekly, and daily.

<Graph type screen>

The screen shown in graph form has two graphs each. In the screen showing monthly data, the first graph shows the maximum (minimum) value of the data of the selected month in a graph, and the second graph is the first. The graph shows the maximum (minimum) value data per 10 minutes for the date selected on the graph.

In the weekly data display, the first graph displays the maximum (minimum) data per hour of the selected week, and the second graph displays the maximum (minimum) data per 10 minutes for the date selected in the first graph. To show.

In the daily data screen, the first graph shows the maximum (minimum) value data for every 10 minutes of the selected date, and the second graph shows the data per second (the data received from the actual large server) for the time selected in the first graph. ) As a graph.

<Table form>

The tabular screen allows the user to select data per second (data received from a large server), 10 minutes data, 1 hour data, and 1 day data, and to select the desired date, week, and month for viewing. It is supposed to be.

As described above, the present invention can monitor the remote control of the Internet remotely and control the state of computer equipment, and control the external air supply by using the air conditioner used in the computer room as a system with computer load rate, error, and alarm functions. Remote monitoring can be controlled through the Internet. In addition, the present invention is an outdoor enthalpy operation air supply controller that can be installed in combination with the existing constant temperature and humidity chamber used in the computer room can obtain energy savings in the region of the seasonal, temporal changes in temperature and humidity of the outside air. That is, the present invention, in the control of computer room air using outside air, receives the input of the temperature humidity sensor of the outside air and the temperature humidity sensor of the computer room, and compares with the enthalpy state stored in the computer and the computer-controlled temperature-humidity condition table to calculate and control the amount of outside air intake. It is characterized in that it is controlled to determine the change, and the function of transmitting and receiving data of CPU load rate and various system resources and errors in computer equipment with server for computer room monitoring control monitor through telnet and temperature and humidity of client PC and computer room in server. It is equipped with the function to monitor the operation status, CPU load rate of computer equipment and error occurrences to wireless paging, fax, cordless telephone, client PC, and monitoring status monitor data.

As described above, according to the present invention, various system resources can be analyzed through constant monitoring and DB management of the system resources, and can be operated using its own system separate from the computerized system, and can be operated every minute, hour, day, week, and month. The analysis of the data makes it easy to understand the resource usage and can call e-mails and pagers in the event of a server error, providing stable and optimized operation of the data center.

Detailed description of the effects of the present invention, the present invention monitors and monitors up to eight servers at the same time, calls the pager when an error occurs, monitors the status of the CPU, Memory, Network, Hard Disk processes, and analyzes the daily weekly monthly trend curve System, easy to install, easy to use, easy to guide performance tuning through data analysis, console monitoring, error detection and warning, 24 hours 365 days system Surveillance Monitoring, Graphical Program, Maximize Usability and Convenience, PC-Based Monitoring that Anyone Can Read Easily, Encode Errors to Databases for Each Solution, Manager Call in Case of Error, Email Content Has a remarkable effect that can be managed by.

While preferred embodiments of the present invention have been described using specific terms, such descriptions are for illustrative purposes only and various changes and modifications may be made without departing from the spirit and scope of the following claims. It must be understood.

Claims (20)

A login information detection step of obtaining login information for accessing a server; A login step of accessing the server according to the login information; A data extraction step of extracting system resources and error data from the server; A data conversion step of converting data so that the data received from the server can be used on a PC; A data classification step of classifying the received and converted data for storage and display in a database; A data storage step of storing the classified data in the database; And Computing room management method comprising the screen display step of showing the classified data on the screen selected by the user. The method of claim 1, wherein in the data extraction step, information about various resources of a computer room system is received from the server using a script command from the server. The computer room management method of claim 1, wherein in the log-in step, the log-in is accessed through telnet. The method of claim 1, wherein in the data storing step, the storing of the data stores the maximum value or the minimum value data of every second, 10 minutes, 1 hour, and the data per second and the 10 minute data are stored in the current month day database file. And, 1 hour data is stored in the year database. 5. The computer room management method of claim 4, wherein the data is output as text in a graph form or a tabular form. The method of claim 1, wherein the computer room management method comprises: an error data determination step of determining whether the classified data is an error; An error storing step of storing the error data in a database; And an error processing step of deciding what processing is to be performed on the received error data. The method of claim 1, wherein the computer room management method further comprises an error routine for processing the error if an error list already exists in the database after the error data is received. The method of claim 7, wherein the error routine step, An error database comparing step of comparing whether the received error data exists in an error database; An alarm sounding an alarm if there is information on the error; A pager call determining step of determining whether a pager call is selected among the processing methods for the error inputted into the error database; And a pager call step of calling a pager when the pager call is selected as a processing method for an error. 8. The method of claim 7, wherein the error routine step comprises: an email transmission discrimination step of determining whether an email transmission is selected among the processing methods for an error input to the error database; Comprising an email transmission step of transmitting the email if the email transmission is selected as the processing method for the error. The method of claim 1, wherein the computer room management method further comprises a computer room report reporting step of notifying the help desk or a remote client of the computer room information. The method of claim 10, wherein the computer room report step, A computer room selecting step of selecting a computer room and connecting to a management server of the computer room; Ida / password confirmation step of confirming the ID and password to access the computer room management server; A data transmission step of transmitting the data; A data classification step of recognizing and classifying contents of the data; Showing data showing trends of the transmitted and received data; Computing room management method comprising the data storage step of storing the data in the database of the computer room. The computer room management method of claim 9, wherein the data transmission step is performed through socket communication through TCP / IP. The method of claim 9, wherein the transmitted data is a central processing unit, a memory, an IO, a network, and various kinds of errors. The method of claim 1, wherein the computer room management method further comprises a data exchange and conversation step of exchanging and communicating data with a computer manager and a help desk or a remote client when a problem occurs in the computer room or inquiries. Computer room management method characterized in that. The method of claim 14, wherein the data exchange and dialogue step, Determining whether to communicate by selecting a desired manager or computer room; An image communication decision step of asking whether or not to communicate with each other through an image; A socket forming step of forming a socket for communication; And Computing room management method comprising a multimedia communication step of performing a multimedia communication for transmitting and receiving image and image data. The method of claim 14, wherein the data exchange and dialogue step, Paint exchange decision step asking whether to exchange in the paint using a mouse or tablet; A socket forming step of forming a socket for data communication; And Computational room management method comprising the step of transmitting the coordinate data for the point of the mouse or tablet. The method of claim 14, wherein the data exchange and dialogue step, A file transfer determining step of asking whether a file is transferred; FTP connection step of connecting FTP to each other to transfer the file; And And a file transfer step of transmitting the file by selecting the file to be transmitted. 18. The method of claim 17, wherein the file transfer step comprises: a communication socket generation step of creating a TCP / IP socket; And Computing room management method further comprising a text transmission step of transmitting the content of the text. The method of claim 1, wherein the computer room management method further comprises a server changing step of changing a server to be managed. 20. The method of claim 19, wherein changing the server comprises: a data screen checking step of checking whether a screen showing the selected data is currently executed; A data display step of displaying data on a screen when data of a corresponding file exists when a day part is selected; A data display step of displaying data on a screen when data of a corresponding file exists when a month portion is selected; And Computing room management method characterized in that it further comprises a data screen output step of showing the data on the screen if the data of the file, if the year (year) is selected.