{"id":538,"date":"2010-01-21T05:42:48","date_gmt":"2010-01-20T23:42:48","guid":{"rendered":"http:\/\/techsatwork.com\/blog\/?p=538"},"modified":"2016-01-07T11:31:10","modified_gmt":"2016-01-07T05:31:10","slug":"whats-the-plan-name-for-my-routine","status":"publish","type":"post","link":"https:\/\/techsatwork.com\/?p=538","title":{"rendered":"Whats the plan name for my routine ?"},"content":{"rendered":"<p>Ever tried to find the package \/ plan name for your stored procedure or function in DB2 LUW. Its not straight foward was I wish it was .\u00c2\u00a0 Here is an sql that will make your life a little easy :<\/p>\n<p><span style=\"color: #3366ff;\">select\u00c2\u00a0 deps.bschema SCHEMA,<br \/>\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 procs.routinename PROCEDURE,<br \/>\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 deps.bname PACKAGE,<br \/>\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 plan.last_bind_time BIND_TIME,<br \/>\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 procs.alteredts ALTER_TIME,<br \/>\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 procs.definer definer,<br \/>\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 procs.valid VALID<br \/>\n\u00c2\u00a0 from\u00c2\u00a0 sysibm.sysdependencies deps,<br \/>\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 sysibm.sysroutines procs,<br \/>\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 sysibm.sysplan plan<br \/>\n\u00c2\u00a0where\u00c2\u00a0 deps.dtype = &#8216;F&#8217;<br \/>\n\u00c2\u00a0\u00c2\u00a0 and\u00c2\u00a0 deps.btype = &#8216;K&#8217;<br \/>\n\u00c2\u00a0\u00c2\u00a0 and\u00c2\u00a0 procs.specificname\u00c2\u00a0 = deps.dname<br \/>\n\u00c2\u00a0\u00c2\u00a0 and\u00c2\u00a0 procs.routineschema = deps.dschema<br \/>\n\u00c2\u00a0\u00c2\u00a0 and deps.bname = plan.name<br \/>\n\u00c2\u00a0order\u00c2\u00a0 by 1,2,3;<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ever tried to find the package \/ plan name for your stored procedure or function in DB2 LUW. Its not straight foward was I wish it was .\u00c2\u00a0 Here is an sql that will make your life a little easy : select\u00c2\u00a0 deps.bschema SCHEMA, \u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 procs.routinename PROCEDURE, \u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 deps.bname PACKAGE, \u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 plan.last_bind_time BIND_TIME, \u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 procs.alteredts [&hellip;]<\/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":[3],"tags":[273,10,271,274,272],"class_list":["post-538","post","type-post","status-publish","format-standard","hentry","category-db2","tag-bind","tag-package","tag-plan","tag-procedure","tag-routines"],"_links":{"self":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/538","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=538"}],"version-history":[{"count":1,"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/538\/revisions"}],"predecessor-version":[{"id":539,"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/538\/revisions\/539"}],"wp:attachment":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=538"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=538"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=538"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}