{"id":3887,"date":"2018-10-17T12:03:16","date_gmt":"2018-10-17T12:03:16","guid":{"rendered":"https:\/\/dbtut.com\/?p=3887"},"modified":"2018-11-26T11:20:03","modified_gmt":"2018-11-26T11:20:03","slug":"why-is-so-much-data-being-written-into-dbql","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/10\/17\/why-is-so-much-data-being-written-into-dbql\/","title":{"rendered":"Why is so much data being written into DBQL?"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p>There are thousands of queries submitted per minute and it is too much data.<\/p>\n<p>But, To avoid the performance impact on the database due to these logged queries,We need to be pro-active and choosy about the data we want to log.<\/p>\n<p>So we save the space, resources,performance and etc etc.<\/p>\n<p>Note : DBQL can only be improvised but can&#8217;t be ignored.Its a pillar for Admins as well,helps in disasters \ud83d\ude00<\/p>\n<p>But,if space and other issues are concerened, below tips can help you some:<\/p>\n<p><strong>1.\u00a0<\/strong>DBQLRules need to be modified.<\/p>\n<p><strong>Example:<\/strong><\/p>\n<pre class=\"lang:default decode:true \">select\u00a0UserName, accountstring, summaryflag\u00a0from\u00a0dbc.dbqlrules;\r\n\r\nUserName\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Account\u00a0\u00a0\u00a0\u00a0Summary\r\n\r\n------------\u00a0\u00a0---------\u00a0\u00a0-------\r\n\r\nUSER\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0F\r\n\r\nWEB_TACTICAL\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0F\r\n\r\nAll\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0F<\/pre>\n<p>&nbsp;<\/p>\n<p><strong>Suggested modifications:<\/strong><\/p>\n<p>Detail logging of non-tactical work<\/p>\n<pre class=\"lang:default decode:true \">BEGIN\u00a0QUERY\u00a0LOGGING\u00a0with\u00a0SQL,\u00a0OBJECTS, UTILITYINFO\u00a0LIMITSQLTEXT=0\u00a0ON\u00a0ALL;<\/pre>\n<p>&nbsp;<\/p>\n<p>Summary threshold logging for tactical work by account name<\/p>\n<pre class=\"lang:default decode:true \">BEGIN\u00a0QUERY\u00a0LOGGING\u00a0with\u00a0SQL,\u00a0OBJECTS\u00a0LIMIT\u00a0THRESHOLD\u00a0= 100\u00a0CPUTIME\u00a0ON\u00a0ALL\u00a0ACCOUNT\u00a0= '$M00WXYZ&amp;D&amp;H';<\/pre>\n<p>&nbsp;<\/p>\n<p>Summary threshold logging for the Viewpoint user<\/p>\n<pre class=\"lang:default decode:true \">BEGIN\u00a0QUERY\u00a0LOGGING\u00a0with\u00a0SQL,\u00a0OBJECTS\u00a0LIMIT\u00a0THRESHOLD\u00a0= 100\u00a0CPUTIME\u00a0ON\u00a0VIEWPOINT;<\/pre>\n<p>&nbsp;<\/p>\n<p><strong>2.<\/strong>\u00a0Change TASM Logging Interval from 600 to 60 in Workload Designer General &gt; Other &gt; Intervals for logging better suited to tactical work<\/p>\n<p>Untill next \ud83d\ude42<\/p>\n<p>Thanks &amp; Regards,<\/p>\n<p>Pankaj Chahar<\/p>\n<p>Pankajchahar052@gmail.com<\/p>\n<p>+91-8802350184<\/p>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_3887\" class=\"pvc_stats all  \" data-element-id=\"3887\" 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; There are thousands of queries submitted per minute and it is too much data. But, To avoid the performance impact on the database due to these logged queries,We need to be pro-active and choosy about the data we want to log. So we save the space, resources,performance and etc etc. Note : DBQL can &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_3887\" class=\"pvc_stats all  \" data-element-id=\"3887\" 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":72,"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":[1307],"tags":[1479,1480,1354],"class_list":["post-3887","post","type-post","status-publish","format-standard","","category-teradata","tag-dbql","tag-query-logging","tag-teradata"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":151,"today_views":0},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Why is so much data being written into DBQL? - Database Tutorials<\/title>\n<meta name=\"description\" content=\"There are thousands of queries submitted per minute and it is too much data.But, To avoid the performance impact on the database due to these logged queries,We need to be pro-active and choosy about the data we want to log.So we save the space, resources,performance and etc etc.Note : DBQL can only be improvised but can&#039;t be ignored.Its a pillar for Admins as well,helps in disasters :D\" \/>\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\/17\/why-is-so-much-data-being-written-into-dbql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Why is so much data being written into DBQL? - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"There are thousands of queries submitted per minute and it is too much data.But, To avoid the performance impact on the database due to these logged queries,We need to be pro-active and choosy about the data we want to log.So we save the space, resources,performance and etc etc.Note : DBQL can only be improvised but can&#039;t be ignored.Its a pillar for Admins as well,helps in disasters :D\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/10\/17\/why-is-so-much-data-being-written-into-dbql\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-10-17T12:03:16+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-11-26T11:20:03+00:00\" \/>\n<meta name=\"author\" content=\"Pankaj Chahar\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Pankaj Chahar\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\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\/17\/why-is-so-much-data-being-written-into-dbql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/17\/why-is-so-much-data-being-written-into-dbql\/\"},\"author\":{\"name\":\"Pankaj Chahar\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/e8489438a2fab8a7d16e910b4edcfdb7\"},\"headline\":\"Why is so much data being written into DBQL?\",\"datePublished\":\"2018-10-17T12:03:16+00:00\",\"dateModified\":\"2018-11-26T11:20:03+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/17\/why-is-so-much-data-being-written-into-dbql\/\"},\"wordCount\":165,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"keywords\":[\"DBQL\",\"query logging\",\"Teradata\"],\"articleSection\":[\"TERADATA\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/10\/17\/why-is-so-much-data-being-written-into-dbql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/17\/why-is-so-much-data-being-written-into-dbql\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/17\/why-is-so-much-data-being-written-into-dbql\/\",\"name\":\"Why is so much data being written into DBQL? - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"datePublished\":\"2018-10-17T12:03:16+00:00\",\"dateModified\":\"2018-11-26T11:20:03+00:00\",\"description\":\"There are thousands of queries submitted per minute and it is too much data.But, To avoid the performance impact on the database due to these logged queries,We need to be pro-active and choosy about the data we want to log.So we save the space, resources,performance and etc etc.Note : DBQL can only be improvised but can't be ignored.Its a pillar for Admins as well,helps in disasters :D\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/17\/why-is-so-much-data-being-written-into-dbql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/10\/17\/why-is-so-much-data-being-written-into-dbql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/17\/why-is-so-much-data-being-written-into-dbql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Why is so much data being written into DBQL?\"}]},{\"@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\/e8489438a2fab8a7d16e910b4edcfdb7\",\"name\":\"Pankaj Chahar\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/41a12e5f6ca3afb247a6085b3ed6c1aceec4d42276c392ae5ce8be25038533ea?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/41a12e5f6ca3afb247a6085b3ed6c1aceec4d42276c392ae5ce8be25038533ea?s=96&d=mm&r=g\",\"caption\":\"Pankaj Chahar\"},\"description\":\"I'm an IT Professional from India, active Blogger. Have written many blogs for my previous firms,LinkedIn and own my blog. Professional Skills Primary : Teradata, Netezza, Unix Secondary : AWS Redshift ,PostgreSQL, MongoDB, Cassandra and other AWS services, EC2,S3,Cloudwatch,datapipeline and etc. You may reach me at pankajchahar052@gmail.com\/ +91-8802350184\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/pchahar\/\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/pankajchahar\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Why is so much data being written into DBQL? - Database Tutorials","description":"There are thousands of queries submitted per minute and it is too much data.But, To avoid the performance impact on the database due to these logged queries,We need to be pro-active and choosy about the data we want to log.So we save the space, resources,performance and etc etc.Note : DBQL can only be improvised but can't be ignored.Its a pillar for Admins as well,helps in disasters :D","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\/17\/why-is-so-much-data-being-written-into-dbql\/","og_locale":"en_US","og_type":"article","og_title":"Why is so much data being written into DBQL? - Database Tutorials","og_description":"There are thousands of queries submitted per minute and it is too much data.But, To avoid the performance impact on the database due to these logged queries,We need to be pro-active and choosy about the data we want to log.So we save the space, resources,performance and etc etc.Note : DBQL can only be improvised but can't be ignored.Its a pillar for Admins as well,helps in disasters :D","og_url":"https:\/\/dbtut.com\/index.php\/2018\/10\/17\/why-is-so-much-data-being-written-into-dbql\/","og_site_name":"Database Tutorials","article_published_time":"2018-10-17T12:03:16+00:00","article_modified_time":"2018-11-26T11:20:03+00:00","author":"Pankaj Chahar","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Pankaj Chahar","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/17\/why-is-so-much-data-being-written-into-dbql\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/17\/why-is-so-much-data-being-written-into-dbql\/"},"author":{"name":"Pankaj Chahar","@id":"https:\/\/dbtut.com\/#\/schema\/person\/e8489438a2fab8a7d16e910b4edcfdb7"},"headline":"Why is so much data being written into DBQL?","datePublished":"2018-10-17T12:03:16+00:00","dateModified":"2018-11-26T11:20:03+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/17\/why-is-so-much-data-being-written-into-dbql\/"},"wordCount":165,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"keywords":["DBQL","query logging","Teradata"],"articleSection":["TERADATA"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/10\/17\/why-is-so-much-data-being-written-into-dbql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/17\/why-is-so-much-data-being-written-into-dbql\/","url":"https:\/\/dbtut.com\/index.php\/2018\/10\/17\/why-is-so-much-data-being-written-into-dbql\/","name":"Why is so much data being written into DBQL? - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"datePublished":"2018-10-17T12:03:16+00:00","dateModified":"2018-11-26T11:20:03+00:00","description":"There are thousands of queries submitted per minute and it is too much data.But, To avoid the performance impact on the database due to these logged queries,We need to be pro-active and choosy about the data we want to log.So we save the space, resources,performance and etc etc.Note : DBQL can only be improvised but can't be ignored.Its a pillar for Admins as well,helps in disasters :D","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/17\/why-is-so-much-data-being-written-into-dbql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/10\/17\/why-is-so-much-data-being-written-into-dbql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/17\/why-is-so-much-data-being-written-into-dbql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Why is so much data being written into DBQL?"}]},{"@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\/e8489438a2fab8a7d16e910b4edcfdb7","name":"Pankaj Chahar","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/41a12e5f6ca3afb247a6085b3ed6c1aceec4d42276c392ae5ce8be25038533ea?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/41a12e5f6ca3afb247a6085b3ed6c1aceec4d42276c392ae5ce8be25038533ea?s=96&d=mm&r=g","caption":"Pankaj Chahar"},"description":"I'm an IT Professional from India, active Blogger. Have written many blogs for my previous firms,LinkedIn and own my blog. Professional Skills Primary : Teradata, Netezza, Unix Secondary : AWS Redshift ,PostgreSQL, MongoDB, Cassandra and other AWS services, EC2,S3,Cloudwatch,datapipeline and etc. You may reach me at pankajchahar052@gmail.com\/ +91-8802350184","sameAs":["https:\/\/www.linkedin.com\/in\/pchahar\/"],"url":"https:\/\/dbtut.com\/index.php\/author\/pankajchahar\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/3887","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\/72"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=3887"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/3887\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=3887"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=3887"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=3887"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}