DB2 – LUW – Schema SYSPROC

Background

Continuing down the DB/2 metadata review path, let us quickly identify functions exposed via the SYSPROC schema.

Functions

Function Definition CLP Command Similar Link
SYSPROC.ADMIN_GET_DBP_MEM_USAGE Instance Memory Utilization SYSPROC.ADMIN_GET_DBP_MEM_USAGE Link
SYSPROC.MON_GET_TABLESPACE Tablespaces LIST TABLESPACES Link
SYSPROC.SNAP_GET_APPL List Applications LIST APPLICATIONS Link
SYSPROC.SNAP_GET_TAB List Tables LIST Tables ADMINTABINFO Link
SYSPROC.MON_GET_PKG_CACHE_STMT List SQL Statements Link
SYSPROC.MON_GET_CONNECTION List DB Connections LIST APPLICATIONS Link
sysproc.mon_get_bufferpool List Buffer Pools db2 get snapshot for all bufferpools SYSIBMADM.MON_BP_UTILIZATION Link
sysproc.mon_get_extended_latch_wait Latch Link
sysproc.pd_get_diag_hist List Diagnostic History Link
sysproc.snap_get_tab_reorg List Table Re-Org History db2 get snapshot for tables on [database] SYSIBMADM.SNAPTAB_REORG Link

SYSPROC.ADMIN_GET_DBP_MEM_USAGE

Code


SELECT

	   tblMem.MAX_PARTITION_MEM / ( 1024 * 1024)
		AS memMaxGB

	   , tblMem.CURRENT_PARTITION_MEM / ( 1024 * 1024)
		AS memCurrentGB

	   , tblMem.PEAK_PARTITION_MEM / ( 1024 * 1024)
		AS memPeakGB           

FROM TABLE
      (

         SYSPROC.ADMIN_GET_DBP_MEM_USAGE
         (

            -- all database partitions
             -1

         )

     ) AS tblMem 

Output

SYSPROC.ADMIN_GET_MEM_USAGE.20180824_0231PM

SYSPROC.MON_GET_TABLESPACE

Code


/*
 * MON_GET_TABLESPACE table function - Get table space metrics
 * https://www.ibm.com/support/knowledgecenter/en/SSEPGG_9.8.0/com.ibm.db2.luw.sql.rtn.doc/doc/r0053943.html
 *
 *
 */
WITH cteESR
 (
	hostname
 )
 AS
 (
 	SELECT
	 		MAX
 			(
 				DECODE
 				(
 					  NAME
 					, 'HOST_NAME'
 					, VALUE
				)
			) AS "hostname"

 	FROM   SYSIBMADM.ENV_SYS_RESOURCES tblESR

 	WHERE  tblESR.NAME IN
 			(
 			   'HOST_NAME'
 			)

 )

SELECT
          cteESR.hostname AS "host"

		, tblEII.INST_NAME AS "INSTANCE"

        , tblTS.TBSP_NAME AS "name"

        , tblTS.TBSP_ID AS "id"

        , tblTS.TBSP_TYPE AS "type"

        , tblTS.TBSP_CONTENT_TYPE AS "contentType"

        , tblTS.TBSP_PAGE_SIZE AS "pageSize"

        , ( tblTS.TBSP_USED_PAGES * tblTS.TBSP_PAGE_SIZE )  / ( 1024  * 1024)
        	AS "usedMB"

        , ( tblTS.TBSP_FREE_PAGES * tblTS.TBSP_PAGE_SIZE )  / ( 1024  * 1024)
        	AS "freeMB"

        , ( tblTS.TBSP_TOTAL_PAGES * tblTS.TBSP_PAGE_SIZE )  / ( 1024 * 1024)
        	AS "totalMB"

        , cast
        	(

        		(
        			  ( tblTS.TBSP_USED_PAGES * 100.00 )
        			/ NULLIF
        				(
        					tblTS.TBSP_TOTAL_PAGES
        					, 0
        				)
				)
				AS decimal(10, 2)

        	) AS "used%"

FROM TABLE
      (

         SYSPROC.MON_GET_TABLESPACE
         (

             -- current database
         	 ''

         	-- all database partitions
             ,-1

         )

     ) AS tblTS 

CROSS JOIN cteESR

CROSS JOIN sysibmadm.env_inst_info tblEII 

ORDER BY

     ( tblTS.TBSP_TOTAL_PAGES * tblTS.TBSP_PAGE_SIZE ) desc

Output

sysproc.mon_get_tablespace.20180824.0247PM.PNG

SYSPROC.SNAP_GET_APPL

Code


SELECT  

           tblApp.AUTHID AS "authID"

         , tblSAI.APPL_NAME AS "appName"

         , tblSAI.APPL_STATUS AS "appStatus"

         , tblApp.APPL_ID AS "applID"        

         , tblApp.ROWS_WRITTEN AS "RowsWritten"

         , tblApp.ROWS_READ AS "RowsRead"

         , tblApp.ROWS_DELETED AS "RowsDeleted"

         , tblApp.ROWS_INSERTED AS "RowsInserted"        

         , tblApp.ROWS_UPDATED AS "RowsUpdated"

         , tblApp.ROWS_SELECTED AS "RowsSelected"        

         , tblApp.SELECT_SQL_STMTS AS "SQLSelectStmts"

         , tblApp.FAILED_SQL_STMTS AS "failedSQLStmts"

         , tblApp.COMMIT_SQL_STMTS AS "CommitSQLStmts"

         , tblApp.ROLLBACK_SQL_STMTS AS "RollbackSQLStmts"      

         , tblApp.DDL_SQL_STMTS AS "DDLSQLStmts"        

         , ROUND
            (

                  ( tblApp.AGENT_USR_CPU_TIME_MS / 1E6 )

                , 3

            ) AS "AgentUserCPUTimeInSec"

         , tblApp.ELAPSED_EXEC_TIME_S
             AS "ElapsedExecTimeInSec"

         -- , tblApp.*

FROM TABLE
      (

         SYSPROC.SNAP_GET_APPL
         (

             -- '' current database, NULL all databases
              NULL

            -- all database partitions
             ,-1

         )

     ) AS tblApp 

/*

    CROSS JOIN SYSIBMADM.ENV_INST_INFO tblII

*/
INNER JOIN SYSIBMADM.SNAPAPPL_INFO tblSAI
    ON tblApp.AGENT_ID = tblSAI.AGENT_ID

INNER JOIN SYSIBMADM.APPLICATIONS tblApp
    ON tblSAI.APPL_ID = tblApp.APPL_ID

ORDER BY
           (
                  tblApp.ROWS_READ 

                + tblApp.ROWS_WRITTEN

           )  DESC

         , tblAPP.ROWS_INSERTED DESC

Output

SYSPROC.SNAP_GET_APPL.20180824.0258PM.PNG

sysproc.SNAP_GET_TAB

Code


WITH cteESR
 (
    hostname
 )
 AS
 (
    SELECT
            MAX
            (
                DECODE
                (
                      NAME
                    , 'HOST_NAME'
                    , VALUE
                )
            ) AS "hostname"

    FROM   SYSIBMADM.ENV_SYS_RESOURCES tblESR

    WHERE  tblESR.NAME IN
            (
               'HOST_NAME'
            )

 )
 SELECT 

          cteESR.hostname AS "host"

        , tblEII.INST_NAME AS "instance"          

        , SUBSTR(tblTab.TABSCHEMA,1,8) AS "schema"

        , SUBSTR(tblTab.TABNAME,1,15) AS "table"

        , tblTab.TAB_TYPE AS "tabType"

        , tblSTT.TBSPACE as "tabSpace"

        , tblSTT.INDEX_TBSPACE as "indexTabSpace"

    --  , tblSTT.LONG_TBSPACE

        , VARCHAR_FORMAT
        	(
        		  tblSTT.STATS_TIME
        		, 'YYYY-MM-DD HH24:MI:SS'
    		) AS "StatsTS"

        , tblTSD.PAGESIZE AS "pageSizeInBytes"

        -- , tblSTT.npages AS "#ofPagesN"
        -- , tblSTT.mpages AS "#ofPagesM"
        , tblSTT.fpages AS "#ofPagesF"      

        , (
                  tblATI.DATA_OBJECT_P_SIZE
                + tblATI.INDEX_OBJECT_P_SIZE
                + tblATI.LONG_OBJECT_P_SIZE
                + tblATI.LOB_OBJECT_P_SIZE
                + tblATI.XML_OBJECT_P_SIZE
          )
          /
          (1024)
            AS totalSizeInMBBasedOnAdminGetTabInfo

        , ( tblSTT.fpages * tblTSD.PAGESIZE)
              / (1024 * 1024)
              AS "sizeInMBBasedOnPages"

FROM TABLE
      (
         /*
          * Data Returned in KB
          */
         sysproc.SNAP_GET_TAB
         (

             -- current database
              ''

            -- all database partitions
             ,-2

         )

     ) AS tblTab 

INNER JOIN SYSCAT.TABLES tblSTT

    ON  tblTAB.TABSCHEMA = tblSTT.TABSCHEMA
    AND tblTAB.TABNAME = tblSTT.TABNAME

INNER JOIN SYSCAT.TABLESPACES tblTSD

    ON tblSTT.TBSPACE = tblTSD.TBSPACE

-- INNER JOIN  SYSIBMADM.ADMINTABINFO tblATI

INNER JOIN TABLE
    (

        sysproc.admin_get_tab_info
        (
              -- schema
              tblSTT.TABSCHEMA

              -- table
            , tblSTT.TABNAME

        )

    ) tblATI    

    ON  tblSTT.TABSCHEMA = tblATI.TABSCHEMA
    AND tblSTT.TABNAME = tblATI.TABNAME

CROSS JOIN cteESR

CROSS JOIN sysibmadm.env_inst_info tblEII

/*
    Skip catalog tables
*/
WHERE  tblTab.TAB_TYPE NOT IN
         (
            'CATALOG_TABLE'
         )

ORDER BY

      tblTab.TABSCHEMA

    , tblTab.TABNAME

Output

sysproc.snap_get_tab.20180824.0315PM

SYSPROC.MON_GET_PKG_CACHE_STMT

Code


WITH cteESR
 (
    hostname
 )
 AS
 (
    SELECT
            MAX
            (
                DECODE
                (
                      NAME
                    , 'HOST_NAME'
                    , VALUE
                )
            ) AS "hostname"

    FROM   SYSIBMADM.ENV_SYS_RESOURCES tblESR

    WHERE  tblESR.NAME IN
            (
               'HOST_NAME'
            )

 )
SELECT 

           cteESR.HOSTNAME AS "host"

        , tblEII.INST_NAME AS "instance"      

        , tblCS.STMT_TEXT AS "SQL"

        --, tblCS.STMTID AS "stmtID"
        --, tblCS.PLANID AS "planID"
        --, tblCS.EXECUTABLE_ID AS "executableID"

        , tblCS.TOTAL_CPU_TIME AS "totalCPUTime"

        , tblCS.NUM_EXECUTIONS AS "# of Exec"

        , tblCS.STMT_EXEC_TIME AS "stmtExecTime"        

        , tblCS.QUERY_COST_ESTIMATE AS "queryCostEstimate"

        , tblCS.STMT_TYPE_ID AS "stmtType"

        , (
              tblCS.ROWS_DELETED
            + tblCS.ROWS_INSERTED
            + tblCS.ROWS_UPDATED

          )  AS "Rows Affected"

        -- , tblCS.POOL_DATA_P_READS AS "poolReadsPhysical"

        --, tblCS.POOL_DATA_L_READS AS "poolReadsLogical"

    --  , tblCS.*

FROM TABLE
        (
            SYSPROC.MON_GET_PKG_CACHE_STMT
            ( 

                  'D' -- section type S/D

                , NULL -- executable_id

                -- , NULL -- search_args
                --, '360'
                , NULL

                /* Specify -1 for the current database member, or -2 for all active database members */
                , -2
            )
        ) as tblCS 

CROSS JOIN cteESR

CROSS JOIN sysibmadm.env_inst_info tblEII

WHERE (

                ( tblCS.STMT_TEXT NOT LIKE '%SYSPROC%')

            AND ( tblCS.STMT_TEXT NOT LIKE '%SYSIBMADM%')

      )

ORDER BY 

          TOTAL_CPU_TIME DESC

        , ( tblCS.NUM_EXECUTIONS * tblCS.QUERY_COST_ESTIMATE ) DESC

-- FETCH FIRST 10 ROWS ONLY     

Output

sysproc.mon_get_pkg_cache_stmt.20180824.0343PM

SYSPROC.MON_GET_CONNECTION

Code


/*
 * 1a) MON_GET_CONNECTION table function - Get connection metrics
 *     https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.5.0/com.ibm.db2.luw.sql.rtn.doc/doc/r0053938.html
 *
 *
 */

WITH cteESR
 (
    hostname
 )
 AS
 (
    SELECT
            MAX
            (
                DECODE
                (
                      NAME
                    , 'HOST_NAME'
                    , VALUE
                )
            ) AS "hostname"

    FROM   SYSIBMADM.ENV_SYS_RESOURCES tblESR

    WHERE  tblESR.NAME IN
            (
               'HOST_NAME'
            )

 )
SELECT 

           cteESR.HOSTNAME AS "host"

        , tblEII.INST_NAME AS "instance"      

        , tblMGC.SESSION_AUTH_ID AS "authIDSession"

        , tblMGC.SYSTEM_AUTH_ID AS "authIDSystem"

        , tblMGC.execution_ID AS "executionID"

        , tblMGC.IS_SYSTEM_APPL AS "isSystemAppl"

        , tblMGC.CLIENT_APPLNAME AS "appClient"

        , tblMGC.APPLICATION_NAME AS "appName"

        , tblMGC.CLIENT_WRKSTNNAME AS "workstation"

        , tblMGC.POOL_DATA_L_READS  AS "poolDataReadsLogical"

        , tblMGC.POOL_INDEX_L_READS AS "poolIndexReadsLogical"

      --  , tblMGC.POOL_TEMP_DATA_L_READS  AS "poolTempDataReadsLogical"

      --  , tblMGC.POOL_TEMP_INDEX_L_READS AS "poolTempIndexReadLogical"

        , tblMGC.POOL_DATA_P_READS AS "poolDataReadsPhysical"

        , tblMGC.POOL_INDEX_P_READS AS "poolIndexReadsPhysical"

        , tblMGC.TOTAL_CPU_TIME AS "cpuTime"

       -- , TOTAL_APP_COMMITS AS "appCommits"

        , tblMGC.TCPIP_RECV_VOLUME AS "tcpReceive"

        , tblMGC.TCPIP_SEND_VOLUME AS "tcpSend"

        , tblMGC.rows_returned

            AS "rowsReturned"

        , tblMGC.rows_read

            AS "rowsRead"

        , tblMGC.rows_modified

            AS "rowsModified"

        , (
              tblMGC.rows_deleted
            + tblMGC.rows_inserted
            + tblMGC.rows_updated
          )

            AS "rowsAffected"

        , tblMGC.*

FROM TABLE
        (
            SYSPROC.MON_GET_CONNECTION
            ( 

                  -- application_handle
                  NULL 

                /* Specify -1 for the current database member, or -2 for all active database members */
                , -2

                -- system_appls
                , 1
            )

        ) as tblMGC 

CROSS JOIN cteESR

CROSS JOIN sysibmadm.env_inst_info tblEII

ORDER BY 

        (
              tblMGC.POOL_INDEX_L_READS
            + tblMGC.POOL_INDEX_L_READS
            + tblMGC.POOL_TEMP_DATA_L_READS
            + tblMGC.POOL_TEMP_INDEX_L_READS

            + tblMGC.POOL_DATA_P_READS
            + tblMGC.POOL_INDEX_P_READS

        ) desc

        , (
            tblMGC.rows_returned
          ) DESC

/*
    FETCH FIRST 10 ROWS ONLY
*/

Output

sysproc.mon_get_connection.20180825.0644AM

sysproc.mon_get_bufferpool

Code


/*
 * 1a) The MON_GET_BUFFERPOOL table function returns monitor metrics for one or more buffer pools.
 *     https://www.ibm.com/support/knowledgecenter/hu/SSEPGG_9.7.0/com.ibm.db2.luw.sql.rtn.doc/doc/r0053942.html
*/

WITH cteESR
 (
    hostname
 )
 AS
 (
    SELECT
            MAX
            (
                DECODE
                (
                      NAME
                    , 'HOST_NAME'
                    , VALUE
                )
            ) AS "hostname"

    FROM   SYSIBMADM.ENV_SYS_RESOURCES tblESR

    WHERE  tblESR.NAME IN
            (
               'HOST_NAME'
            )

 )

, cteBufferPool
as
(

    SELECT
              --tblBP.MEMBER

              tblBP.BP_Name AS bufferPool

            ,
               pool_data_l_reads + pool_temp_data_l_reads +
               pool_index_l_reads + pool_temp_index_l_reads +
               pool_xda_l_reads + pool_temp_xda_l_reads
                as logicalReads

            ,
               pool_data_p_reads + pool_temp_data_p_reads
             + pool_index_p_reads + pool_temp_index_p_reads
             + pool_xda_p_reads + pool_temp_xda_p_reads
                as physicalReads

    FROM TABLE
        (
            sysproc.mon_get_bufferpool
            ( 

                /* Buffer Pool */
                null

                /* Specify -1 for the current database member, or -2 for all active database members */
                , -2

            )

        ) as tblBP

)

SELECT 

          cteESR.HOSTNAME AS "host"

        , tblEII.INST_NAME AS "instance"      

        , cteBP.*

        , ( cteBP.LogicalReads * 100.00 )
            / NULLIF
                (
                    ( cteBP.LogicalReads + cteBP.PhysicalReads)
                    , 0
                )
            AS "Hit Ratio"

FROM cteBufferPool cteBP

CROSS JOIN cteESR

CROSS JOIN sysibmadm.env_inst_info tblEII
<span id="mce_SELREST_start" style="overflow:hidden;line-height:0;"></span>

Output

sysproc.mon_get_bufferpool.20180825.0826AM

sysproc.mon_get_extended_latch_wait

Code

/*
 * 1a) MON_GET_EXTENDED_LATCH_WAIT table function - Return information for latches
 *     https://www.ibm.com/support/knowledgecenter/es/SSEPGG_10.1.0/com.ibm.db2.luw.sql.rtn.doc/doc/r0059271.html
*/

WITH cteESR
 (
    hostname
 )
 AS
 (
    SELECT
            MAX
            (
                DECODE
                (
                      NAME
                    , 'HOST_NAME'
                    , VALUE
                )
            ) AS "hostname"

    FROM   SYSIBMADM.ENV_SYS_RESOURCES tblESR

    WHERE  tblESR.NAME IN
            (
               'HOST_NAME'
            )

 )

, cteExtendedLatchWait
as
(

    SELECT
             tblELW.*

    FROM TABLE
        (

            sysproc.mon_get_extended_latch_wait
            ( 

                /* Specify -1 for the current database member, or -2 for all active database members */
                -2

            )

        ) as tblELW

)

SELECT 

/*
          cteESR.HOSTNAME AS "host"

        , tblEII.INST_NAME AS "instance"      

*/
          cteELW.LATCH_NAME AS "latch"

        , cteELW.TOTAL_EXTENDED_LATCH_WAIT_TIME AS "latchWaitTime"

        , cteELW.TOTAL_EXTENDED_LATCH_WAITS AS "latchWaits" 

FROM cteExtendedLatchWait cteELW

CROSS JOIN cteESR

CROSS JOIN sysibmadm.env_inst_info tblEII

ORDER BY

        cteELW.TOTAL_EXTENDED_LATCH_WAIT_TIME DESC

Output

sysproc.mon_get_extended_latch_wait.20180825.1140AM

sysproc.pd_get_diag_hist

Code


/*
 * 1a) PD_GET_DIAG_HIST table function - Return records from a given facility
 https://www.ibm.com/support/knowledgecenter/en/SSEPGG_9.5.0/com.ibm.db2.luw.sql.rtn.doc/doc/r0052903.html

*/

WITH cteESR
 (
    hostname
 )
 AS
 (
    SELECT
            MAX
            (
                DECODE
                (
                      NAME
                    , 'HOST_NAME'
                    , VALUE
                )
            ) AS "hostname"

    FROM   SYSIBMADM.ENV_SYS_RESOURCES tblESR

    WHERE  tblESR.NAME IN
            (
               'HOST_NAME'
            )

 )

, cteDiagHist
as
(

    SELECT
             tblDH.*

    FROM TABLE
        (

            sysproc.pd_get_diag_hist
            ( 

                  'ALL'
                , 'ALL'
                , 'POTENTIAL'
                , CAST (NULL AS TIMESTAMP)
                , CAST (NULL AS TIMESTAMP)

            )

        ) as tblDH

)

SELECT
          cteDH.LEVEL

        , case cteDH.LEVEL
            WHEN 'C' THEN 'Critical'
            WHEN 'E' THEN 'Error'
            WHEN 'I' THEN 'Informational'
            WHEN 'S' THEN 'Severe'
            WHEN 'W' THEN 'Warning'
          END AS "levelLiteral"

        , cteDH.IMPACT

        , varchar_format
            (
                (
                         cteDH.TIMESTAMP
                    +    (  cteDH.TIMEZONE / 60) HOURS
                    + MOD(  cteDH.TIMEZONE, 60) MINUTES
                )
                , 'YYYY-MM-DD HH24:MI AM'

            )
                AS "TS"

        , cteDH.MSG
        , cteDH.DUMPFILE
    --  , cteDH.*

FROM cteDiagHist cteDH

CROSS JOIN cteESR

CROSS JOIN sysibmadm.env_inst_info tblEII

ORDER BY
        cteDH.TIMESTAMP DESC

FETCH FIRST 100 ROWS ONLY

Output

sysproc.pd_get_diag_hist.20180825.0620PM

sysproc.snap_get_tab_reorg

Code


/*
 * 1a) SNAPTAB_REORG administrative view and SNAP_GET_TAB_REORG table function - Retrieve table reorganization snapshot information
       https://www.ibm.com/support/knowledgecenter/no/SSEPGG_9.7.0/com.ibm.db2.luw.sql.rtn.doc/doc/r0021997.html

*/

WITH cteESR
(
    hostname
)
AS
(
    SELECT
            MAX
            (
                DECODE
                (
                      NAME
                    , 'HOST_NAME'
                    , VALUE
                )
            ) AS "hostname"

    FROM   SYSIBMADM.ENV_SYS_RESOURCES tblESR

    WHERE  tblESR.NAME IN
            (
               'HOST_NAME'
            )

 )

, cteTableReorg
as
(

    SELECT
             tblDH.*

    FROM TABLE
        (

            sysproc.snap_get_tab_reorg
            ( 

                    ''
                  , -2

            )

        ) as tblDH

)

SELECT 

          cteTR.TABSCHEMA       AS "schema"
        , cteTR.TABNAME         AS "table"
        , cteTR.PAGE_REORGS     AS "pageReOrgs"
        , cteTR.REORG_TYPE      AS "type"
        , cteTR.REORG_STATUS    AS "status"
        , cteTR.REORG_START     AS "tsStart"
        , cteTR.REORG_END       AS "tsEnd"
        , cteTR.REORG_INDEX_ID  AS "ind_id"
        , cteTR.REORG_TBSPC_ID  AS "tsID"

        -- cteTR.*

FROM cteTableReorg cteTR

CROSS JOIN cteESR

CROSS JOIN sysibmadm.env_inst_info tblEII

ORDER BY
          cteTR.REORG_END   DESC
        , cteTR.REORG_START DESC

FETCH FIRST 100 ROWS ONLY

Output

sysproc.snap_get_tab_reorg.20180826.1243PM

References

  1. IBM
    • DB2 LUW
      • Monitor procedures and functions
        • Monitor
          • Monitor procedures and functions
            Link
        • MON_GET_CONNECTION
          • MON_GET_CONNECTION table function – Get connection metrics
            Link
        • MON_GET_CONTAINER
          • MON_GET_CONTAINER table function – Get table space container metrics
            Link
        • MON_GET_DATABASE
          • MON_GET_DATABASE table function – Get database metrics
            Link
        • MON_GET_EXTENDED_LATCH_WAIT
          • MON_GET_EXTENDED_LATCH_WAIT table function – Return information for latches
            Link
        • ADMIN_GET_TAB_INFO
          • ADMIN_GET_TAB_INFO table function – Retrieve size and state information for tables
            Link
        • PD_GET_DIAG_HIST
          • ADMIN_GET_TAB_INFO table function – Retrieve size and state information for tables
            Link
      • SYSCAT
        • SYSCAT.TABLES
          • SYSCAT.TABLES catalog view
            Link
        •  SYSCAT.TABLESPACES
          • SYSCAT.TABLESPACES catalog view
            Link
    • IBM Integrated Analytics System \ Db2 Warehouse\ Monitor procedures and functions
      • MON_GET_CONTAIN
      •  ER
        • MON_GET_CONTAINER table function – Get table space container metrics
          Link
    • IBM Knowledge Center
      • Home > Db2 on Cloud, Db2 Warehouse, Db2 Warehouse on Cloud, Integrated Analytics System. . .>Scalar functions
        • VARCHAR_FORMAT
          • VARCHAR_FORMAT scalar function
            Link
        • Current Date
      • Home > DB2 for Linux UNIX and Windows 10.1.0. . >.Administrative routines and ADMIN_CMD procedure
        • Administrative routines and ADMIN_CMD procedure
          • ADMINTABINFO administrative view and ADMIN_GET_TAB_INFO table function – retrieve table size and state information
            Link
          • SNAPSHOT_APPL
            •  

              SNAPSHOT_APPL table function
              Link

    • Developer Works
      • Learn
        • BigData Analytics
          • DB2 monitoring: Migrate from snapshot monitor interfaces to in-memory metrics monitor interfaces
            Link
  2. Dangerous DBA
    • Record the size of your DB2 tables – SYSIBMADM.ADMINTABINFO
      Link

Source Control

Github

DanielAdeniji/IBMUDBSchemaSYSPROC
Link

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s