{"id":3550,"date":"2018-10-04T09:22:54","date_gmt":"2018-10-04T09:22:54","guid":{"rendered":"https:\/\/dbtut.com\/?p=3550"},"modified":"2018-12-21T23:04:52","modified_gmt":"2018-12-21T23:04:52","slug":"the-sysibm-sysstatfeedback-table-introduced-in-db2-for-z-os-v11","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/10\/04\/the-sysibm-sysstatfeedback-table-introduced-in-db2-for-z-os-v11\/","title":{"rendered":"The SYSIBM.SYSSTATFEEDBACK table introduced in Db2 for z\/OS V11"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p>IBM introduced a new Db2 table with Db2 for z\/OS V11 called SYSIBM.SYSSTATFEEDBACK.\u00a0 The table verifies if statistics were collected and if the correct statistics were collected.<\/p>\n<p>Instead of rehashing the information already covered in the IBM online magazine concerning the new Db2 table SYSIBM.SYSSTATFEEDBACK written by Willie Favero, which you can find <a href=\"http:\/\/ibmsystemsmag.com\/mainframe\/administrator\/db2\/db2-11-statistics-feedback\/?page=1\">here<\/a>, I would like to explain how you can use a User-Defined Function to get the integer column numbers from the COLGROUPCOLNO field in the new table.<\/p>\n<p>The COLGROUPCOLNO values are stored in a VARCHAR field.\u00a0 The User Defined Function (UDF) converts the Hex values to Integer values, which is the tables column number.<\/p>\n<p>I would advise that you read the article mentioned above first to get a broader understanding of what information the SYSIBM.SYSSTATFEEDBACK table stores and how you can use it to optimise your environment with updated statistics.<\/p>\n<p>When running a SELECT on the SYSIBM.SYSSTATFEEDBACK table, the COLGROUPCOLNO column values are usually displayed as periods (in red) below in Figure 1.<\/p>\n<h4>Figure 1:<\/h4>\n<pre class=\"lang:default decode:true \">********************************* Top of Data ********************************\r\n\r\nTBCREATOR TBNAME\u00a0 IXCREATOR IXNAME COLNAME\u00a0\u00a0\u00a0 NUMCOLUMNS COLGROUPCOLNO\r\n\r\n--------- ------- --------- ------ ---------- ---------- -------------\r\n\r\nTEST\u00a0\u00a0\u00a0\u00a0\u00a0 TMMP016\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 AIMPRM_PCT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1\r\n\r\nTEST\u00a0\u00a0\u00a0\u00a0\u00a0 TMMP016\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 PDTLNE_CDE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0 . .<\/pre>\n<p>&nbsp;<\/p>\n<p>When using the HEX function in your Select (HEX(COLGROUPCOLNO)) you will find the hex values displayed for each column number as shown below.<\/p>\n<p>&nbsp;<\/p>\n<h4>Figure 2:<\/h4>\n<pre class=\"lang:default decode:true \">********************************* Top of Data ********************************\r\n\r\nTBCREATOR TBNAME\u00a0 IXCREATOR IXNAME COLNAME\u00a0\u00a0\u00a0 NUMCOLUMNS COLGROUPCOLNO\r\n\r\n*\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 *\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 *\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 *\u00a0\u00a0\u00a0\u00a0\u00a0 *\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 * *\r\n\r\n--------- ------- --------- ------ ---------- ---------- -------------\r\n\r\nTEST\u00a0\u00a0\u00a0\u00a0\u00a0 TMMP016\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 AIMPRM_PCT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1\r\n\r\nTEST\u00a0\u00a0\u00a0\u00a0\u00a0 TMMP016\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 PDTLNE_CDE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2 00100011<\/pre>\n<p>&nbsp;<\/p>\n<p>As you can see in Figure 2 above the field value of COLGROUPCOLNO is shown as 00100011.<\/p>\n<p>These are the column numbers to be used in your Runstats statement.<\/p>\n<p>You will notice that the value in the NUMCOLUMNS field will tie in with the number of columns displayed in the COLGROUPCOLNO, NUMCOLUMNS = 2.<\/p>\n<p>The hex values convert as follows: 0010 converts to the integer value 16 and 0011 converts to integer value 17, in other words COLNO 16 and COLNO 17 of the table.<\/p>\n<p>In order to have the column numbers\u2019 hex values converted to integer (COLNO in SYSIBM.SYSCOLUMNS), in Db2, you need a Function for the conversion.<\/p>\n<p>The function, HEX2INT, can be found <a href=\"https:\/\/www.ibm.com\/developerworks\/community\/blogs\/SQLTips4DB2LUW\/entry\/bit_arithmetic19?lang=en\">here<\/a>. Simply search for HEX2INT.<\/p>\n<p>The one displayed below has been tailored to use a WLM on z\/OS.\u00a0 Yours might require further tailoring based on your environments ZPARMs.<\/p>\n<p>&nbsp;<\/p>\n<h4>Figure 3:<\/h4>\n<pre class=\"lang:default decode:true \">--#SET TERMINATOR `\r\n\r\nSET CURRENT SQLID='qualifier'`\r\n\r\nCREATE FUNCTION dba.HEX2INT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00e0 dba can be any name\r\n\r\n(STR VARCHAR(8))\r\n\r\nRETURNS INTEGER\r\n\r\nSPECIFIC HEX2INT\r\n\r\nDETERMINISTIC\r\n\r\nNO EXTERNAL ACTION\r\n\r\nCONTAINS SQL\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0&lt;-- Could also be READS SQL DATA\r\n\r\nWLM ENVIRONMENT FOR DEBUG MODE WLMENV\u00a0\u00a0\u00a0\u00a0\u00a0 &lt;--change WLM\r\n\r\nQUALIFIER qualifier\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 &lt;-- Change Qualifier\r\n\r\nPACKAGE OWNER qualifier\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 &lt;-- Change Qualifier\r\n\r\nBEGIN NOT ATOMIC\r\n\r\nDECLARE RES INTEGER DEFAULT 0 ;\r\n\r\nDECLARE POS INTEGER DEFAULT 1 ;\r\n\r\nDECLARE NIBBLE CHAR( 1) ;\r\n\r\nWHILE POS &lt;= LENGTH(STR)\r\n\r\nDO\r\n\r\nSET NIBBLE = SUBSTR(STR, POS, 1) ;\r\n\r\nSET RES = BITOR(CASE WHEN BITAND(RES, 134217728) != 0\r\n\r\nTHEN BITOR(16 * BITANDNOT(RES, 134217728),\r\n\r\n-2147483648)\r\n\r\nELSE 16 * RES END,\r\n\r\nCASE NIBBLE\r\n\r\nWHEN '0' THEN 0\r\n\r\nWHEN '1' THEN 1\r\n\r\nWHEN '2' THEN 2\r\n\r\nWHEN '3' THEN 3\r\n\r\nWHEN '4' THEN 4\r\n\r\nWHEN '5' THEN 5\r\n\r\nWHEN '6' THEN 6\r\n\r\nWHEN '7' THEN 7\r\n\r\nWHEN '8' THEN 8\r\n\r\nWHEN '9' THEN 9\r\n\r\nWHEN 'A' THEN 10\r\n\r\nWHEN 'a' THEN 10\r\n\r\nWHEN 'B' THEN 11\r\n\r\nWHEN 'b' THEN 11\r\n\r\nWHEN 'C' THEN 12\r\n\r\nWHEN 'c' THEN 12\r\n\r\nWHEN 'D' THEN 13\r\n\r\nWHEN 'd' THEN 13\r\n\r\nWHEN 'E' THEN 14\r\n\r\nWHEN 'e' THEN 14\r\n\r\nWHEN 'F' THEN 15\r\n\r\nWHEN 'f' THEN 15\r\n\r\nELSE RAISE_ERROR('78000', 'NOT A HEX STRING')\r\n\r\nEND), POS = POS + 1 ;\r\n\r\nEND WHILE ;\r\n\r\nRETURN RES ;\r\n\r\nEND `\r\n\r\n--#SET TERMINATOR ;\r\n\r\nCOMMIT;<\/pre>\n<p>&nbsp;<\/p>\n<p>Once the UDF has been created you should be able to do a Select as follows (the SELECT statement has been edited to remove the other 47 COL statements) to display the column numbers in the COLGROUPCOLNO.<\/p>\n<p>&nbsp;<\/p>\n<h4>Figure 4:<\/h4>\n<pre class=\"lang:default decode:true\">SELECT TBCREATOR, TBNAME, COLNAME, NUMCOLUMNS,\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 HEX(COLGROUPCOLNO) \"COLGROUPCOLNO\",\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 CASE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 WHEN CHAR(NUMCOLUMNS) &gt; 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 THEN DBA.HEX2INT(HEX(SUBSTR(COLGROUPCOLNO,1,2)))\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u2190Note length of 2\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ELSE 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 END\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n\r\n\u00a0\u00a0\u00a0 AS COL1,\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 CASE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 WHEN CHAR(NUMCOLUMNS) &gt;= 2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n\r\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0THEN DBA.HEX2INT(HEX(SUBSTR(COLGROUPCOLNO,3,2)))\u00a0\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u2190Note increments of 2\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ELSE 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 END\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\r\n\r\n\u00a0\u00a0\u00a0 AS COL2,\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 CASE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 WHEN CHAR(NUMCOLUMNS) &gt;= 3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 THEN DBA.HEX2INT(HEX(SUBSTR(COLGROUPCOLNO,5,2)))\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u2190Note increments of 2\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ELSE 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 END\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n\r\n\u00a0\u00a0\u00a0 AS COL3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n\r\n\u00a0FROM \"SYSIBM\".\"SYSSTATFEEDBACK\"\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n\r\n\u00a0WHERE TBNAME = 'TMMP016'<\/pre>\n<p>The Select statement will display the COLUMNS needed for the Runstats as follows:<\/p>\n<p>&nbsp;<\/p>\n<h4>Figure 5:<\/h4>\n<pre class=\"lang:default decode:true \">TBCREATOR TBNAME\u00a0 COLNAME\u00a0\u00a0\u00a0 NUMCOLUMNS COLGROUPCOLNO\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 COL1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 COL2\r\n\r\n--------- ------- ---------- ---------- ------------- ----------- -----------\r\n\r\nTEST\u00a0\u00a0\u00a0\u00a0\u00a0 TMMP016 AIMPRM_PCT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\r\n\r\nTEST\u00a0\u00a0\u00a0\u00a0\u00a0 TMMP016 PDTLNE_CDE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2 00100011\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a016\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 17<\/pre>\n<p>&nbsp;<\/p>\n<p>The non-zero values of COL1 and COL2 in the second row of Figure 5, displays the columns numbers of the Table needing updated statistics. The column values of the 2 rows selected in this example from SYSIBM.SYSFEEDBACK are as follows shown in Figure 6:<\/p>\n<p>&nbsp;<\/p>\n<h4>Figure 6:<\/h4>\n<pre class=\"lang:default decode:true\">Row 1\r\n\r\n\r\n\r\nTBCREATOR\u00a0\u00a0\u00a0\u00a0 = TEST\r\n\r\nTBNAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = TMPP016\r\n\r\nCOLNAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = AIMPRM_PCT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n\r\nNUMCOLUMNS\u00a0\u00a0\u00a0 = 1\r\n\r\nCOLGROUPCOLNO =\r\n\r\nTYPE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = F\r\n\r\nDBNAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = DMMP01\u00a0\u00a0\r\n\r\nTSNAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = SMMPPD16\r\n\r\nREASON\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = DEFAULT\u00a0\u00a0\r\n\r\nLASTDATE\u00a0\u00a0\u00a0\u00a0\u00a0 = 28.09.2018\r\n\r\nRow 2\r\n\r\n\r\n\r\nTBCREATOR\u00a0\u00a0\u00a0\u00a0 = TEST\r\n\r\nTBNAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = TMPP016\r\n\r\nCOLNAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = PDTLNE_CDE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n\r\nNUMCOLUMNS\u00a0\u00a0\u00a0 = 2\r\n\r\nCOLGROUPCOLNO = 00100011\r\n\r\nTYPE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = C\r\n\r\nDBNAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = DMMP01\u00a0\u00a0\r\n\r\nTSNAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = SMMPPD16\r\n\r\nREASON\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = COMPFFIX\u00a0 \u00a0\r\n\r\nLASTDATE\u00a0\u00a0\u00a0\u00a0\u00a0 = 26.09.2018<\/pre>\n<p>&nbsp;<\/p>\n<p>The TYPE and the REASON columns will determine what your RUNSTATS statement should look like when complete.<\/p>\n<p>&nbsp;<\/p>\n<h4>Row 1:<\/h4>\n<p>Type = F determines that the table lacks Frequency (FREQVAL) statistics.<\/p>\n<p>Reason = DEFAULT determines that a predicate references a value that is probably a default value.<\/p>\n<p>Row1\u2019s RUNSTATS statement should look as follows:<\/p>\n<pre class=\"lang:default decode:true \">RUNSTATS TABLESPACE DMMP01.SMMPPD16\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TABLE(TEST.TMMP016)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 COLGROUP(AIMPRM_PCT)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 FREQVAL COUNT 30\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SHRLEVEL CHANGE REPORT YES UPDATE ALL HISTORY NONE<\/pre>\n<p>&nbsp;<\/p>\n<h4>Row 2:<\/h4>\n<p>Type = C determines that the table lacks Cardinality statistics<\/p>\n<p>Reason = COMPFFIX determines that Multi-column cardinality statistics are needed for an index compound filter factor.<\/p>\n<p>And Row2\u2019s RUNSTATS statement should look as follows:<\/p>\n<pre class=\"lang:default decode:true \">RUNSTATS TABLESPACE DMMP01.SMMPPD16\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TABLE(TEST.TMMP016)\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 COLUMN(PDTLNE_CDE)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 COLGROUP(PDTLNE_CDE\u00a0\u00a0\u00a0\u00a0 \u00df Column 16 and 17\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ,MVTTYP_CDE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 )\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SHRLEVEL CHANGE REPORT YES UPDATE ALL HISTORY NONE<\/pre>\n<p>&nbsp;<\/p>\n<p>Remember that you need to follow up your RUNSTATS with a REBIND of your packages affected.<\/p>\n<p>You can find the second article of series below.<\/p>\n<p>&#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/12\/21\/the-sysibm-sysstatfeedback-table-introduced-in-db2-for-z-os-v11-part-2\/\" target=\"_blank\" rel=\"noopener\">The SYSIBM.SYSSTATFEEDBACK table introduced in Db2 for z\/OS V11 Part 2<\/a>&#8221;<\/p>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_3550\" class=\"pvc_stats all  \" data-element-id=\"3550\" 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; IBM introduced a new Db2 table with Db2 for z\/OS V11 called SYSIBM.SYSSTATFEEDBACK.\u00a0 The table verifies if statistics were collected and if the correct statistics were collected. Instead of rehashing the information already covered in the IBM online magazine concerning the new Db2 table SYSIBM.SYSSTATFEEDBACK written by Willie Favero, which you can find here, &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_3550\" class=\"pvc_stats all  \" data-element-id=\"3550\" 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":392,"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-3550","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>The SYSIBM.SYSSTATFEEDBACK table introduced in Db2 for z\/OS V11 - Database Tutorials<\/title>\n<meta name=\"description\" content=\"The SYSIBM.SYSSTATFEEDBACK table introduced in Db2 for z\/OS V11\" \/>\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\/04\/the-sysibm-sysstatfeedback-table-introduced-in-db2-for-z-os-v11\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The SYSIBM.SYSSTATFEEDBACK table introduced in Db2 for z\/OS V11 - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"The SYSIBM.SYSSTATFEEDBACK table introduced in Db2 for z\/OS V11\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/10\/04\/the-sysibm-sysstatfeedback-table-introduced-in-db2-for-z-os-v11\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-10-04T09:22:54+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-12-21T23:04:52+00:00\" \/>\n<meta name=\"author\" content=\"Ian Sampson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ian Sampson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 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\/04\/the-sysibm-sysstatfeedback-table-introduced-in-db2-for-z-os-v11\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/04\/the-sysibm-sysstatfeedback-table-introduced-in-db2-for-z-os-v11\/\"},\"author\":{\"name\":\"Ian Sampson\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/4e75eeb3774b0bedda6283e4834675e7\"},\"headline\":\"The SYSIBM.SYSSTATFEEDBACK table introduced in Db2 for z\/OS V11\",\"datePublished\":\"2018-10-04T09:22:54+00:00\",\"dateModified\":\"2018-12-21T23:04:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/04\/the-sysibm-sysstatfeedback-table-introduced-in-db2-for-z-os-v11\/\"},\"wordCount\":578,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"articleSection\":[\"DB2\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/10\/04\/the-sysibm-sysstatfeedback-table-introduced-in-db2-for-z-os-v11\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/04\/the-sysibm-sysstatfeedback-table-introduced-in-db2-for-z-os-v11\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/04\/the-sysibm-sysstatfeedback-table-introduced-in-db2-for-z-os-v11\/\",\"name\":\"The SYSIBM.SYSSTATFEEDBACK table introduced in Db2 for z\/OS V11 - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"datePublished\":\"2018-10-04T09:22:54+00:00\",\"dateModified\":\"2018-12-21T23:04:52+00:00\",\"description\":\"The SYSIBM.SYSSTATFEEDBACK table introduced in Db2 for z\/OS V11\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/04\/the-sysibm-sysstatfeedback-table-introduced-in-db2-for-z-os-v11\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/10\/04\/the-sysibm-sysstatfeedback-table-introduced-in-db2-for-z-os-v11\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/04\/the-sysibm-sysstatfeedback-table-introduced-in-db2-for-z-os-v11\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The SYSIBM.SYSSTATFEEDBACK table introduced in Db2 for z\/OS V11\"}]},{\"@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\/4e75eeb3774b0bedda6283e4834675e7\",\"name\":\"Ian Sampson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/b05a67cb1d29a61a808106b223d35990dbcbb3a01f81bcfb2ed902d6b40b66c8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/b05a67cb1d29a61a808106b223d35990dbcbb3a01f81bcfb2ed902d6b40b66c8?s=96&d=mm&r=g\",\"caption\":\"Ian Sampson\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/iansampson\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"The SYSIBM.SYSSTATFEEDBACK table introduced in Db2 for z\/OS V11 - Database Tutorials","description":"The SYSIBM.SYSSTATFEEDBACK table introduced in Db2 for z\/OS V11","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\/04\/the-sysibm-sysstatfeedback-table-introduced-in-db2-for-z-os-v11\/","og_locale":"en_US","og_type":"article","og_title":"The SYSIBM.SYSSTATFEEDBACK table introduced in Db2 for z\/OS V11 - Database Tutorials","og_description":"The SYSIBM.SYSSTATFEEDBACK table introduced in Db2 for z\/OS V11","og_url":"https:\/\/dbtut.com\/index.php\/2018\/10\/04\/the-sysibm-sysstatfeedback-table-introduced-in-db2-for-z-os-v11\/","og_site_name":"Database Tutorials","article_published_time":"2018-10-04T09:22:54+00:00","article_modified_time":"2018-12-21T23:04:52+00:00","author":"Ian Sampson","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Ian Sampson","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/04\/the-sysibm-sysstatfeedback-table-introduced-in-db2-for-z-os-v11\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/04\/the-sysibm-sysstatfeedback-table-introduced-in-db2-for-z-os-v11\/"},"author":{"name":"Ian Sampson","@id":"https:\/\/dbtut.com\/#\/schema\/person\/4e75eeb3774b0bedda6283e4834675e7"},"headline":"The SYSIBM.SYSSTATFEEDBACK table introduced in Db2 for z\/OS V11","datePublished":"2018-10-04T09:22:54+00:00","dateModified":"2018-12-21T23:04:52+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/04\/the-sysibm-sysstatfeedback-table-introduced-in-db2-for-z-os-v11\/"},"wordCount":578,"commentCount":1,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"articleSection":["DB2"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/10\/04\/the-sysibm-sysstatfeedback-table-introduced-in-db2-for-z-os-v11\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/04\/the-sysibm-sysstatfeedback-table-introduced-in-db2-for-z-os-v11\/","url":"https:\/\/dbtut.com\/index.php\/2018\/10\/04\/the-sysibm-sysstatfeedback-table-introduced-in-db2-for-z-os-v11\/","name":"The SYSIBM.SYSSTATFEEDBACK table introduced in Db2 for z\/OS V11 - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"datePublished":"2018-10-04T09:22:54+00:00","dateModified":"2018-12-21T23:04:52+00:00","description":"The SYSIBM.SYSSTATFEEDBACK table introduced in Db2 for z\/OS V11","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/04\/the-sysibm-sysstatfeedback-table-introduced-in-db2-for-z-os-v11\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/10\/04\/the-sysibm-sysstatfeedback-table-introduced-in-db2-for-z-os-v11\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/04\/the-sysibm-sysstatfeedback-table-introduced-in-db2-for-z-os-v11\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"The SYSIBM.SYSSTATFEEDBACK table introduced in Db2 for z\/OS V11"}]},{"@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\/4e75eeb3774b0bedda6283e4834675e7","name":"Ian Sampson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/b05a67cb1d29a61a808106b223d35990dbcbb3a01f81bcfb2ed902d6b40b66c8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b05a67cb1d29a61a808106b223d35990dbcbb3a01f81bcfb2ed902d6b40b66c8?s=96&d=mm&r=g","caption":"Ian Sampson"},"url":"https:\/\/dbtut.com\/index.php\/author\/iansampson\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/3550","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\/392"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=3550"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/3550\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=3550"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=3550"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=3550"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}