{"id":3756,"date":"2018-10-13T17:48:24","date_gmt":"2018-10-13T17:48:24","guid":{"rendered":"https:\/\/dbtut.com\/?p=3756"},"modified":"2018-11-26T11:01:04","modified_gmt":"2018-11-26T11:01:04","slug":"db2-database-monitoring-2","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/10\/13\/db2-database-monitoring-2\/","title":{"rendered":"DB2-Database Monitoring-2"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p>Hello Everyone , I am back with next part of Database monitoring .<\/p>\n<p>You should read the first article of this series. &#8220;<a title=\"DB2-Database Monitoring-1\" href=\"https:\/\/dbtut.com\/index.php\/2018\/09\/23\/db2-database-monitoring-1\/\" target=\"_blank\" rel=\"noopener\">DB2-Database Monitoring-1<\/a>&#8221;<\/p>\n<p>I have been preparing db2 materials for learners or freshers.Therefore, this materials contains very basic language to make understand everyone.<\/p>\n<p>Currently, many are performance monitoring tool has been introduced\u00a0 from v8.x to v11.x.On daily basis ,we all are learning something new.<\/p>\n<p>Currently most important performance monitoring tool introduce is DSM (Data Server Manager).<\/p>\n<p dir=\"ltr\">Recently I learned about a neat DB2 monitoring tool and I wanted to share it with you all.<\/p>\n<h3 dir=\"ltr\"><\/h3>\n<h3 dir=\"ltr\">&lt; DSM Tool&gt;<\/h3>\n<p dir=\"ltr\">The <a href=\"http:\/\/www.ibm.com\/developerworks\/downloads\/im\/dsm\/index.html\" target=\"_blank\" rel=\"noopener\">Data\u00a0Server\u00a0Manager<\/a> (DSM) tool has a simple install and a <strong>no-charge <\/strong>option that allows you to monitor a DB2 database in real time.\u00a0 You can see active SQLs, locks, package cache statistics, and most of the key metrics you use for day-to-day database performance work.<\/p>\n<p dir=\"ltr\"><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/10\/674.png\" width=\"687\" height=\"346\" \/><\/p>\n<p dir=\"ltr\">\n<p dir=\"ltr\">DSM also comes in the Enterprise edition that, among other things, enables you to monitor multiple databases and to look at historical data (e.g. &#8220;Top 10 SQLs during yesterday&#8217;s outage&#8221; ).<\/p>\n<p dir=\"ltr\"><strong>Here is the link to explore more :<\/strong><\/p>\n<p dir=\"ltr\">1. http:\/\/www.db2dean.com\/Previous\/DSM1.html<\/p>\n<p dir=\"ltr\">2.https:\/\/www.ibm.com\/developerworks\/data\/library\/techarticle\/dm-1503db2-data-server\/index.html<\/p>\n<p>&nbsp;<\/p>\n<h3>&lt; Snapshot &gt;<\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/10\/734.png\" width=\"580\" height=\"413\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Notes:<\/strong><br \/>\nThe overhead associated with collecting the detailed snapshot statistics varies depending on the application workload. A test performed using a OLTP transaction system showed that about 6 percent overhead was added if all of the snapshot switches were turned on.<\/p>\n<p>The snapshot monitoring facilities are based on a set of C programming language API calls. The SQL wrappers that provide the results for the DB2 snapshot based administrative functions and views utilize the same C based API calls which are executed as fenced routines. These routines use the Snapshot API calls to retrieve a complete set of statistics and then filter the data to match the specific SQL statement.<\/p>\n<p>So a SQL statement might request a few data elements for one table space, but all the detailed information about every table space would be collected and brought into memory. In some cases, system temporary table space would be used to produce the results.<\/p>\n<p>In order to access the snapshot-based statistics using the SQL functions or views a user needs to be a member of one of the DB2 instance level group authorizations, SYSADM, SYSCTRL, SYSMAINT or SYSMON.<\/p>\n<p>&nbsp;<\/p>\n<h3>&lt;Memory metrics&gt;<\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/10\/990.png\" width=\"577\" height=\"435\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/10\/484.png\" width=\"611\" height=\"377\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/10\/955.png\" width=\"579\" height=\"393\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Notes:<\/strong><br \/>\nAs application requests are processed by the database manager, the various statistics are added to each level used for reporting.<\/p>\n<p>The detailed processing metrics are added to the specific unit of work that generated the database request. Each unit of work is added to the statistics for the connection associated with the unit of work.<\/p>\n<p>The statistics are also added to the workload and service subclass that the request was processed under.<\/p>\n<ul style=\"list-style-type: square;\">\n<li><span style=\"color: #003366;\"><strong><span style=\"text-decoration: underline;\">Monitoring system information using table functions\u00a0 :<br \/>\n<\/span><\/strong><\/span><\/li>\n<\/ul>\n<p>\u2022The system monitoring perspective encompasses all the work and effort expended by the data server to process application requests.<\/p>\n<p>\u2022You can determine what the data server is doing as a whole or for particular subsets of application requests.<\/p>\n<p>\u2022Table functions are provided in pairs:<\/p>\n<p>\u2013One returns the most commonly used metrics in a column-based format and is the most performance efficient method of retrieving metrics.<\/p>\n<p>\u2013One (DETAILS) returns the entire set of available metrics in an XML document format, which provides maximum flexibility for formatting output.<\/p>\n<p>\u2013Use the following table functions for accessing current system monitoring information:<\/p>\n<p>\u2022MON_GET_SERVICE_SUBCLASS and MON_GET_SERVICE_SUBCLASS_DETAILS<\/p>\n<p>\u2022MON_GET_WORKLOAD and MON_GET_WORKLOAD_DETAILS<\/p>\n<p>\u2022MON_GET_CONNECTION and MON_GET_CONNECTION_DETAILS<\/p>\n<p>\u2022MON_GET_UNIT_OF_WORK and MON_GET_UNIT_OF_WORK_DETAILSMonitoring<\/p>\n<p>&nbsp;<\/p>\n<p>The system monitoring information is collected by these table functions by default for a new database. You can change default settings using one or both of the following settings:<\/p>\n<p>\u2022The database configuration parameter mon_req_metrics specifies the minimum level of collection in all service classes.<br \/>\n\u2022The COLLECT REQUEST METRICS clause of the CREATE\/ALTER SERVICE CLASS statement specifies the level of collection for a service super-class.\u00a0\u00a0\u00a0\u00a0\u00a0 Use this setting to increase the level of collection for a given service class over the minimum level of collection set for all service classes.<\/p>\n<p><span style=\"color: #3366ff;\">The possible values for each setting are the following:<\/span><br \/>\n-None \u2013 No request monitor elements are collected<br \/>\n-Base \u2013 All request monitor elements are collected<\/p>\n<p>For example, to collect system monitoring information for only a subset of service classes, do the following:<\/p>\n<p>\u2022Set the database configuration parameter mon_req_metrics to NONE.<br \/>\n\u2022For each desired service class, set the COLLECT REQUEST METRICS clause of the CREATE\/ALTER SERVICE CLASS statement to BASE.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/10\/155-1.png\" width=\"537\" height=\"374\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/10\/761.png\" width=\"544\" height=\"379\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-size: 14pt;\"><strong>Note :<\/strong><\/span><\/p>\n<p>Elapsed time is not the same as elapsed time as measured on a clock; if the overall time spent was split among multiple threads, the time spent in each thread is represented in this number.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/10\/649.png\" width=\"585\" height=\"377\" \/><\/p>\n<p>&nbsp;<\/p>\n<h3>&lt; db2pd &gt;<\/h3>\n<p>Here,comes most important monitoring tool is DB2pd, which is very useful in all the db2 versions.We all have been using this tool for troubleshoot an any issue.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/10\/341.png\" width=\"569\" height=\"366\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Notes:<\/strong><br \/>\nListing of OS processes and threads has changed (Linux and UNIX):<br \/>\nDue to the move to the multithreaded architecture in DB2 Version 9.5, the output for the ps command has changed.<\/p>\n<p>Also, the db2pd command has -edus option lists all engine dispatchable units (EDUs) for a database partition.<\/p>\n<p>To display the individual threads associated with the db2sysc process, you must use the applicable thread options on the ps command. On the Linux operating system, for example, you can use the -lLfp option. On the AIX operating system, you can use the -m -o THREAD options.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Example<\/strong><br \/>\n1. The <strong><em>ps -fu<\/em><\/strong> command now displays only two processes, as shown in the following example:<\/p>\n<pre class=\"lang:default decode:true \">$ ps -fu lpham\r\nUID PID PPID C STIME TTY TIME CMD\r\nlpham 25996 25946 0 12:19 pts\/12 00:00:00 -ksh\r\nlpham 27688 27676 0 12:21 pts\/12 00:01:46 db2sysc\r\nlpham 27716 27676 0 12:21 pts\/12 00:00:00 db2acd\r\nlpham 29321 26567 0 12:30 pts\/12 00:00:00 ps -fu lpham<\/pre>\n<p>&nbsp;<\/p>\n<p>2. db2pd \u2013db testdb\u2013storagegroupsDatabase<\/p>\n<p>Using this command -storagegroups option of the db2pd command. The report show the current default storage group and the paths assigned to each storage group.<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"text-decoration: underline; font-size: 14pt;\"><strong>Unit summary :<\/strong><\/span><\/p>\n<p>Having completed this unit, you should be able to:<\/p>\n<p>\u2022DSM tool: <span style=\"font-size: 12pt;\">Manage performance and administer DB2 databases using IBM Data Server Manager<\/span><\/p>\n<p>\u2022Compare the infrastructure used to support SNAPSHOT monitoring with the monitoring infrastructure introduced in DB2 9.7<\/p>\n<p>\u2022Configure a database to collect the activity and object metrics returned by the Monitoring Table functions<\/p>\n<p>\u2022Use the db2pd to perform performance analysis or problem determination for a DB2 database<\/p>\n<p>\u2022Utilize the DB2 provided table functions and views with SQL in reporting and monitoring of the database system, data objects, and the package cache to help you quickly identify issues that might be causing problems<\/p>\n<p>\u2022Configure the DB2 Database configuration options that control the collection of request, activity and object level metrics on the entire database<\/p>\n<p>&nbsp;<\/p>\n<p>And here completes database monitoring unit.<\/p>\n<p>Thank you all for your support<\/p>\n\n<p>&nbsp;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_3756\" class=\"pvc_stats all  \" data-element-id=\"3756\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; Hello Everyone , I am back with next part of Database monitoring . You should read the first article of this series. &#8220;DB2-Database Monitoring-1&#8221; I have been preparing db2 materials for learners or freshers.Therefore, this materials contains very basic language to make understand everyone. Currently, many are performance monitoring tool has been introduced\u00a0 from &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_3756\" class=\"pvc_stats all  \" data-element-id=\"3756\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":148,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[1305],"tags":[],"class_list":["post-3756","post","type-post","status-publish","format-standard","","category-db2"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>DB2-Database Monitoring-2 - Database Tutorials<\/title>\n<meta name=\"description\" content=\"DB2-Database Monitoring-2\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2018\/10\/13\/db2-database-monitoring-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"DB2-Database Monitoring-2 - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"DB2-Database Monitoring-2\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/10\/13\/db2-database-monitoring-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-10-13T17:48:24+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-11-26T11:01:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/10\/674.png\" \/>\n<meta name=\"author\" content=\"Tina Bhagwati\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tina Bhagwati\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/13\/db2-database-monitoring-2\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/13\/db2-database-monitoring-2\/\"},\"author\":{\"name\":\"Tina Bhagwati\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc6d5f1c9a40b3e3e7eee412dbef5574\"},\"headline\":\"DB2-Database Monitoring-2\",\"datePublished\":\"2018-10-13T17:48:24+00:00\",\"dateModified\":\"2018-11-26T11:01:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/13\/db2-database-monitoring-2\/\"},\"wordCount\":1151,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/13\/db2-database-monitoring-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/10\/674.png\",\"articleSection\":[\"DB2\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/10\/13\/db2-database-monitoring-2\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/13\/db2-database-monitoring-2\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/13\/db2-database-monitoring-2\/\",\"name\":\"DB2-Database Monitoring-2 - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/13\/db2-database-monitoring-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/13\/db2-database-monitoring-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/10\/674.png\",\"datePublished\":\"2018-10-13T17:48:24+00:00\",\"dateModified\":\"2018-11-26T11:01:04+00:00\",\"description\":\"DB2-Database Monitoring-2\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/13\/db2-database-monitoring-2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/10\/13\/db2-database-monitoring-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/13\/db2-database-monitoring-2\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/10\/674.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/10\/674.png\",\"width\":929,\"height\":468},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/13\/db2-database-monitoring-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"DB2-Database Monitoring-2\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc6d5f1c9a40b3e3e7eee412dbef5574\",\"name\":\"Tina Bhagwati\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/524573c91e9d024534beb004c7f3e1a11da8d11f972fbf95c331644843e4a154?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/524573c91e9d024534beb004c7f3e1a11da8d11f972fbf95c331644843e4a154?s=96&d=mm&r=g\",\"caption\":\"Tina Bhagwati\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/tinabhagwati\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"DB2-Database Monitoring-2 - Database Tutorials","description":"DB2-Database Monitoring-2","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2018\/10\/13\/db2-database-monitoring-2\/","og_locale":"en_US","og_type":"article","og_title":"DB2-Database Monitoring-2 - Database Tutorials","og_description":"DB2-Database Monitoring-2","og_url":"https:\/\/dbtut.com\/index.php\/2018\/10\/13\/db2-database-monitoring-2\/","og_site_name":"Database Tutorials","article_published_time":"2018-10-13T17:48:24+00:00","article_modified_time":"2018-11-26T11:01:04+00:00","og_image":[{"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/10\/674.png","type":"","width":"","height":""}],"author":"Tina Bhagwati","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tina Bhagwati","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/13\/db2-database-monitoring-2\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/13\/db2-database-monitoring-2\/"},"author":{"name":"Tina Bhagwati","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc6d5f1c9a40b3e3e7eee412dbef5574"},"headline":"DB2-Database Monitoring-2","datePublished":"2018-10-13T17:48:24+00:00","dateModified":"2018-11-26T11:01:04+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/13\/db2-database-monitoring-2\/"},"wordCount":1151,"commentCount":1,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/13\/db2-database-monitoring-2\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/10\/674.png","articleSection":["DB2"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/10\/13\/db2-database-monitoring-2\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/13\/db2-database-monitoring-2\/","url":"https:\/\/dbtut.com\/index.php\/2018\/10\/13\/db2-database-monitoring-2\/","name":"DB2-Database Monitoring-2 - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/13\/db2-database-monitoring-2\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/13\/db2-database-monitoring-2\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/10\/674.png","datePublished":"2018-10-13T17:48:24+00:00","dateModified":"2018-11-26T11:01:04+00:00","description":"DB2-Database Monitoring-2","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/13\/db2-database-monitoring-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/10\/13\/db2-database-monitoring-2\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/13\/db2-database-monitoring-2\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/10\/674.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/10\/674.png","width":929,"height":468},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/13\/db2-database-monitoring-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"DB2-Database Monitoring-2"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc6d5f1c9a40b3e3e7eee412dbef5574","name":"Tina Bhagwati","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/524573c91e9d024534beb004c7f3e1a11da8d11f972fbf95c331644843e4a154?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/524573c91e9d024534beb004c7f3e1a11da8d11f972fbf95c331644843e4a154?s=96&d=mm&r=g","caption":"Tina Bhagwati"},"url":"https:\/\/dbtut.com\/index.php\/author\/tinabhagwati\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/3756","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/148"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=3756"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/3756\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=3756"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=3756"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=3756"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}