Quick positioning method of DB2 process/ thread with high CPU (Central Processing Unit) consumption

The invention discloses a quick positioning method of a DB2 process/ thread with high CPU (Central Processing Unit) consumption. The quick positioning method comprises the following steps: a) firstly, checking a process which operates at present and the CPU use rate situation of the process, and jud...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: LIU ZIZHUAN, XU HUACHUN, CHENG YONGXIN
Format: Patent
Sprache:chi ; eng
Schlagworte:
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
container_end_page
container_issue
container_start_page
container_title
container_volume
creator LIU ZIZHUAN
XU HUACHUN
CHENG YONGXIN
description The invention discloses a quick positioning method of a DB2 process/ thread with high CPU (Central Processing Unit) consumption. The quick positioning method comprises the following steps: a) firstly, checking a process which operates at present and the CPU use rate situation of the process, and judging whether a high CPU consumption process in a system is the DB2 process or not; b) if a DB2 process is determined as the high CPU consumption process, monitoring a DB2 database, and positioning an agent which causes the high CPU consumption; and c) finally, positioning a database operation with the high CPU consumption in the agent. An operating system monitoring command and a database monitoring tool are subjected to combined use, the associated agent is found via the DB2 process which causes the high CPU consumption, finally, the database operation which causes the associated agent to use more CPU is positioned, and therefore, the DB2 process/ thread with the high CPU consumption and the associated database op
format Patent
fullrecord <record><control><sourceid>epo_EVB</sourceid><recordid>TN_cdi_epo_espacenet_CN106126404A</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>CN106126404A</sourcerecordid><originalsourceid>FETCH-epo_espacenet_CN106126404A3</originalsourceid><addsrcrecordid>eNqNjDEOgkAQAGksjPqHtdPCCEjo9dRYGUykJpdj4TbC7YVb4vcN0QdYTTMz88g8RjIv8BxIiB25FnoUyzVwA-dTCn5ggyHsQeyAuoY3iQVLrQVVlLBR6GTQHRRfbepLR7IFwy6MvZ-my2jW6C7g6sdFtL5enuq2Q88VBq8NOpRK3ZM4T9I8i7Pj4R_nA98ePRg</addsrcrecordid><sourcetype>Open Access Repository</sourcetype><iscdi>true</iscdi><recordtype>patent</recordtype></control><display><type>patent</type><title>Quick positioning method of DB2 process/ thread with high CPU (Central Processing Unit) consumption</title><source>esp@cenet</source><creator>LIU ZIZHUAN ; XU HUACHUN ; CHENG YONGXIN</creator><creatorcontrib>LIU ZIZHUAN ; XU HUACHUN ; CHENG YONGXIN</creatorcontrib><description>The invention discloses a quick positioning method of a DB2 process/ thread with high CPU (Central Processing Unit) consumption. The quick positioning method comprises the following steps: a) firstly, checking a process which operates at present and the CPU use rate situation of the process, and judging whether a high CPU consumption process in a system is the DB2 process or not; b) if a DB2 process is determined as the high CPU consumption process, monitoring a DB2 database, and positioning an agent which causes the high CPU consumption; and c) finally, positioning a database operation with the high CPU consumption in the agent. An operating system monitoring command and a database monitoring tool are subjected to combined use, the associated agent is found via the DB2 process which causes the high CPU consumption, finally, the database operation which causes the associated agent to use more CPU is positioned, and therefore, the DB2 process/ thread with the high CPU consumption and the associated database op</description><language>chi ; eng</language><subject>CALCULATING ; COMPUTING ; COUNTING ; ELECTRIC DIGITAL DATA PROCESSING ; PHYSICS</subject><creationdate>2016</creationdate><oa>free_for_read</oa><woscitedreferencessubscribed>false</woscitedreferencessubscribed></display><links><openurl>$$Topenurl_article</openurl><openurlfulltext>$$Topenurlfull_article</openurlfulltext><thumbnail>$$Tsyndetics_thumb_exl</thumbnail><linktohtml>$$Uhttps://worldwide.espacenet.com/publicationDetails/biblio?FT=D&amp;date=20161116&amp;DB=EPODOC&amp;CC=CN&amp;NR=106126404A$$EHTML$$P50$$Gepo$$Hfree_for_read</linktohtml><link.rule.ids>230,308,776,881,25542,76290</link.rule.ids><linktorsrc>$$Uhttps://worldwide.espacenet.com/publicationDetails/biblio?FT=D&amp;date=20161116&amp;DB=EPODOC&amp;CC=CN&amp;NR=106126404A$$EView_record_in_European_Patent_Office$$FView_record_in_$$GEuropean_Patent_Office$$Hfree_for_read</linktorsrc></links><search><creatorcontrib>LIU ZIZHUAN</creatorcontrib><creatorcontrib>XU HUACHUN</creatorcontrib><creatorcontrib>CHENG YONGXIN</creatorcontrib><title>Quick positioning method of DB2 process/ thread with high CPU (Central Processing Unit) consumption</title><description>The invention discloses a quick positioning method of a DB2 process/ thread with high CPU (Central Processing Unit) consumption. The quick positioning method comprises the following steps: a) firstly, checking a process which operates at present and the CPU use rate situation of the process, and judging whether a high CPU consumption process in a system is the DB2 process or not; b) if a DB2 process is determined as the high CPU consumption process, monitoring a DB2 database, and positioning an agent which causes the high CPU consumption; and c) finally, positioning a database operation with the high CPU consumption in the agent. An operating system monitoring command and a database monitoring tool are subjected to combined use, the associated agent is found via the DB2 process which causes the high CPU consumption, finally, the database operation which causes the associated agent to use more CPU is positioned, and therefore, the DB2 process/ thread with the high CPU consumption and the associated database op</description><subject>CALCULATING</subject><subject>COMPUTING</subject><subject>COUNTING</subject><subject>ELECTRIC DIGITAL DATA PROCESSING</subject><subject>PHYSICS</subject><fulltext>true</fulltext><rsrctype>patent</rsrctype><creationdate>2016</creationdate><recordtype>patent</recordtype><sourceid>EVB</sourceid><recordid>eNqNjDEOgkAQAGksjPqHtdPCCEjo9dRYGUykJpdj4TbC7YVb4vcN0QdYTTMz88g8RjIv8BxIiB25FnoUyzVwA-dTCn5ggyHsQeyAuoY3iQVLrQVVlLBR6GTQHRRfbepLR7IFwy6MvZ-my2jW6C7g6sdFtL5enuq2Q88VBq8NOpRK3ZM4T9I8i7Pj4R_nA98ePRg</recordid><startdate>20161116</startdate><enddate>20161116</enddate><creator>LIU ZIZHUAN</creator><creator>XU HUACHUN</creator><creator>CHENG YONGXIN</creator><scope>EVB</scope></search><sort><creationdate>20161116</creationdate><title>Quick positioning method of DB2 process/ thread with high CPU (Central Processing Unit) consumption</title><author>LIU ZIZHUAN ; XU HUACHUN ; CHENG YONGXIN</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-epo_espacenet_CN106126404A3</frbrgroupid><rsrctype>patents</rsrctype><prefilter>patents</prefilter><language>chi ; eng</language><creationdate>2016</creationdate><topic>CALCULATING</topic><topic>COMPUTING</topic><topic>COUNTING</topic><topic>ELECTRIC DIGITAL DATA PROCESSING</topic><topic>PHYSICS</topic><toplevel>online_resources</toplevel><creatorcontrib>LIU ZIZHUAN</creatorcontrib><creatorcontrib>XU HUACHUN</creatorcontrib><creatorcontrib>CHENG YONGXIN</creatorcontrib><collection>esp@cenet</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>LIU ZIZHUAN</au><au>XU HUACHUN</au><au>CHENG YONGXIN</au><format>patent</format><genre>patent</genre><ristype>GEN</ristype><title>Quick positioning method of DB2 process/ thread with high CPU (Central Processing Unit) consumption</title><date>2016-11-16</date><risdate>2016</risdate><abstract>The invention discloses a quick positioning method of a DB2 process/ thread with high CPU (Central Processing Unit) consumption. The quick positioning method comprises the following steps: a) firstly, checking a process which operates at present and the CPU use rate situation of the process, and judging whether a high CPU consumption process in a system is the DB2 process or not; b) if a DB2 process is determined as the high CPU consumption process, monitoring a DB2 database, and positioning an agent which causes the high CPU consumption; and c) finally, positioning a database operation with the high CPU consumption in the agent. An operating system monitoring command and a database monitoring tool are subjected to combined use, the associated agent is found via the DB2 process which causes the high CPU consumption, finally, the database operation which causes the associated agent to use more CPU is positioned, and therefore, the DB2 process/ thread with the high CPU consumption and the associated database op</abstract><oa>free_for_read</oa></addata></record>
fulltext fulltext_linktorsrc
identifier
ispartof
issn
language chi ; eng
recordid cdi_epo_espacenet_CN106126404A
source esp@cenet
subjects CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
title Quick positioning method of DB2 process/ thread with high CPU (Central Processing Unit) consumption
url https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-02-01T01%3A32%3A57IST&url_ver=Z39.88-2004&url_ctx_fmt=infofi/fmt:kev:mtx:ctx&rfr_id=info:sid/primo.exlibrisgroup.com:primo3-Article-epo_EVB&rft_val_fmt=info:ofi/fmt:kev:mtx:patent&rft.genre=patent&rft.au=LIU%20ZIZHUAN&rft.date=2016-11-16&rft_id=info:doi/&rft_dat=%3Cepo_EVB%3ECN106126404A%3C/epo_EVB%3E%3Curl%3E%3C/url%3E&disable_directlink=true&sfx.directlink=off&sfx.report_link=0&rft_id=info:oai/&rft_id=info:pmid/&rfr_iscdi=true