For a long time, I relied on my siebel admins to get Siebel ETL timings and often struggled to get certain information. Last week, I realized why bother when all the info are available on DB2 tables. This sql gives you the timing which can be imported into an excel spreadsheet to make pretty graphs and trend analysis :<\/p>\n
with temp1 (etl_date,start_time,end_time,success_rows,failed_rows) as \u00c2\u00a0 <\/span> For a long time, I relied on my siebel admins to get Siebel ETL timings and often struggled to get certain information. Last week, I realized why bother when all the info are available on DB2 tables. This sql gives you the timing which can be imported into an excel spreadsheet to make pretty graphs […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-container-style":"default","site-container-layout":"default","site-sidebar-layout":"default","site-transparent-header":"default","disable-article-header":"default","disable-site-header":"default","disable-site-footer":"default","disable-content-area-spacing":"default","footnotes":""},"categories":[53,3],"tags":[943,177,181,180,178,183,179,8,182],"class_list":["post-314","post","type-post","status-publish","format-standard","hentry","category-applications","category-db2","tag-db2","tag-etl","tag-etl-througput","tag-etl-tiings","tag-siebel","tag-siebel-and-db2","tag-siebel-etl","tag-sql","tag-trend-analysis"],"_links":{"self":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/314","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=314"}],"version-history":[{"count":6,"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/314\/revisions"}],"predecessor-version":[{"id":1544,"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/314\/revisions\/1544"}],"wp:attachment":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=314"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=314"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=314"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n(
\nselect date(start_ts)as “ETL_DATE” ,min(start_ts) as “START_TIME” ,max(end_ts) as “END_TIME”,
\nsum(sucess_rows) as “ROWS_SUCCEFULLY_PROCESSED”,sum(failed_rows) as “ROWS_FAILED”
\nfrom siebdac.W_ETL_RUN_STEP
\ngroup by date(start_ts),run_wid order by min(start_ts))<\/span><\/p>\n
\nselect etl_date,start_time,end_time,success_rows,failed_rows,timestampdiff(4,char(timestamp(end_time) – timestamp(start_time)))as “Duration_in_minutes” ,
\n((success_rows + failed_rows)\/timestampdiff(2,char(timestamp(end_time) – timestamp(start_time)))) as “Rows_processed_per_second”
\nfrom temp1;<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"