openapi: 3.0.0
info:
  title: SAP API
  version: 1.0.0
servers:
- url: http://localhost:8080
paths:
  /rfc/DB6_PM_DBSNAP:
    post:
      tags:
      - SDB6PM
      summary: 'DB6: Get DB Snapshot'
      operationId: /rfc/DB6_PM_DBSNAP
      requestBody:
        content:
          application/json:
            schema:
              properties:
                ACTION:
                  type: integer
                  format: int32
                CALLERFLAG:
                  type: string
                  maxLength: 1
                  description: Who Has Called this Program
                COMPTIME:
                  type: string
                  maxLength: 14
                  description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                CONNECTION:
                  type: string
                  maxLength: 30
                  description: Logical name for a database connection
                PARTITN:
                  type: integer
                  format: int32
                  description: Partition Number
                IT_DB6PMSD:
                  type: array
                  items:
                    type: object
                    properties:
                      COMPTIME:
                        type: string
                        maxLength: 14
                        description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                      PARTITN:
                        type: integer
                        format: int32
                        description: Partition Number
                      CALLERFLAG:
                        type: string
                        maxLength: 1
                        description: Who Has Called this Program
                      DBMSTRTTME:
                        type: string
                        maxLength: 14
                        description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                      PRGVERS:
                        type: string
                        maxLength: 20
                        description: Version of Program Inserted this Row
                      IN_DB_ALIA:
                        type: string
                        maxLength: 20
                        description: 'DB6: General identifier'
                      DB_NAME:
                        type: string
                        maxLength: 20
                        description: 'DB6: General identifier'
                      DB_PATH:
                        type: string
                        maxLength: 255
                        description: 'DB6: File Path'
                      LCKS_HELD:
                        type: integer
                        format: int64
                        description: 'locks_held: Locks Currently Held'
                      LCK_WAITS:
                        type: integer
                        format: int64
                        description: 'lock_waits: Lock Waits Since First Connect'
                      LCK_W_TM:
                        type: integer
                        format: int64
                        description: 'lock_wait_time: Total Time Database Waited for Locks'
                      LCK_LSTIU:
                        type: integer
                        format: int64
                        description: 'lock_list_in_use: Total Lock List Memory in Use'
                      DEADLOCKS:
                        type: integer
                        format: int64
                        description: 'deadlocks: Deadlocks Since First DB Connect'
                      LCK_ESCALS:
                        type: integer
                        format: int64
                        description: 'lock_escals: Lock Escalations Since First DB Connect'
                      X_LCK_ESCA:
                        type: integer
                        format: int64
                        description: 'x_lock_escals: X Lock Escalations Since First DB Connect'
                      LCK_WTING:
                        type: integer
                        format: int64
                        description: 'locks_waiting: Agents Currently Waiting for Locks'
                      SRT_HP_ALO:
                        type: integer
                        format: int64
                        description: 'sort_heap_allocated: Total Sort Heap Allocated'
                      TOT_SORTS:
                        type: integer
                        format: int64
                        description: 'total_sorts: Number of Sorts Since First Connect'
                      TOT_SRT_TM:
                        type: integer
                        format: int64
                        description: 'total_sort_time: Elapsed Time Spent in Sorts'
                      SRT_OF:
                        type: integer
                        format: int64
                        description: 'sort_overflows: Number of Sort Overflows'
                      ACTIV_SORT:
                        type: integer
                        format: int64
                        description: 'active_sorts: Sorts Currently Active'
                      PL_D_LRS:
                        type: integer
                        format: int64
                        description: 'pool_data_l_reads: Pool Data Logical Reads Since Connect'
                      PL_D_PRS:
                        type: integer
                        format: int64
                        description: 'pool_data_p_reads: Pool Data Reads Since First Connect'
                      PL_D_WS:
                        type: integer
                        format: int64
                        description: 'pool_data_writes: Pool Data Writes Since First Connect'
                      PL_I_LRS:
                        type: integer
                        format: int64
                        description: 'pool_index_l_reads: Pool Index Logical Reads Since Connect'
                      PL_I_PRS:
                        type: integer
                        format: int64
                        description: 'pool_index_p_reads: Pool Index Reads Since First Connect'
                      PL_I_WS:
                        type: integer
                        format: int64
                        description: 'pool_index_writes: Pool Index Writes Since First Connect'
                      PL_RD_TM:
                        type: integer
                        format: int64
                        description: 'pool_read_time: Buffer Pool Read Time Since First Connect'
                      PL_WT_TM:
                        type: integer
                        format: int64
                        description: 'pool_write_time: Buffer Pool Write Time Since First Connect'
                      FLS_CLOSED:
                        type: integer
                        format: int64
                        description: 'files_closed: Files Closed Since First DB Connect'
                      CMMT_SQLST:
                        type: integer
                        format: int64
                        description: 'commit_sql_stmts: Number of COMMIT SQL Statements Since Conn'
                      RBCK_SQLST:
                        type: integer
                        format: int64
                        description: 'rollback_sql_stmts: No. of ROLLBACK SQL Stmts Since Connect'
                      DYN_SQLST:
                        type: integer
                        format: int64
                        description: 'dynamic_sql_stmts: Number of Dynamic SQL Stmts Since Connect'
                      STC_SQLST:
                        type: integer
                        format: int64
                        description: 'static_sql_stmts: Number of Static SQL Statements Since Conn'
                      FAIL_SQLST:
                        type: integer
                        format: int64
                        description: 'failed_sql_stmts: Number of Failed SQL Stmts Since Connect'
                      SELC_SQLST:
                        type: integer
                        format: int64
                        description: 'select_sql_stmts: Number of SQL SELECT Stmts Since Connect'
                      DDL_SQLST:
                        type: integer
                        format: int64
                        description: 'ddl_sql_stmts: Number of Data Definition Language Statements'
                      UID_SQLST:
                        type: integer
                        format: int64
                        description: 'uid_sql_stmts: Number of UPDATE/INSERT/DELETE Statements'
                      INT_ATRBND:
                        type: integer
                        format: int64
                        description: 'int_auto_rebinds: Number of Auto Rebinds Since First Connect'
                      INT_RW_DEL:
                        type: integer
                        format: int64
                        description: 'int_rows_deleted: No. of Casc. Deletes Since First Connect'
                      INT_RW_UPD:
                        type: integer
                        format: int64
                        description: 'int_rows_updated: Number of Set Null Deletes Since Connect'
                      INT_CMMTS:
                        type: integer
                        format: int64
                        description: 'int_commits: Number of Int. COMMITs Since First Connect'
                      INT_RB:
                        type: integer
                        format: int64
                        description: 'int_rollbacks: Number of Int. ROLLBACKs Since First Connect'
                      INT_DL_RB:
                        type: integer
                        format: int64
                        description: 'int_deadlock_rollbacks: # of ROLLBACKs due to Deadlock Since'
                      RW_DELETED:
                        type: integer
                        format: int64
                        description: 'rows_deleted: Number of Rows Deleted Since Connect'
                      RW_INSRTED:
                        type: integer
                        format: int64
                        description: 'rows_inserted: Number of Rows Inserted Since Connect'
                      RW_UPDATED:
                        type: integer
                        format: int64
                        description: 'rows_updated: Number of Rows Updated Since Connect'
                      RW_SELECED:
                        type: integer
                        format: int64
                        description: 'rows_selected: Number of Rows Selected Since Connect'
                      BIND_PRECC:
                        type: integer
                        format: int64
                        description: 'binds_precompiles: # of BINDs/PRECOMPILEs Since First Conn.'
                      DB_CN_TM:
                        type: string
                        maxLength: 14
                        description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                      LAST_RESET:
                        type: string
                        maxLength: 14
                        description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                      LAST_BKUP:
                        type: string
                        maxLength: 14
                        description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                      TOTAL_CONS:
                        type: integer
                        format: int64
                        description: 'total_cons: Connects Since First DB Connect'
                      APL_CUR_CO:
                        type: integer
                        format: int64
                        description: 'appls_cur_cons: Applications Currently Connected'
                      APL_IN_DB2:
                        type: integer
                        format: int64
                        description: 'appls_in_db2: Applications Executing in DB2'
                      SEC_LGUSTP:
                        type: integer
                        format: int64
                        description: 'sec_log_used_top: Maximum Secondary Log Space Used'
                      TOT_LGUTOP:
                        type: integer
                        format: int64
                        description: 'tot_log_used_top: Maximum Total Log Space Used'
                      SEC_LGALLO:
                        type: integer
                        format: int64
                        description: 'sec_logs_allocated: Number of Secondary Logs Allocated'
                      NUM_SCDBS:
                        type: integer
                        format: int64
                        description: 'num_sec_dbase_structs: Secondary Database Information'
                      PL_A_IRS:
                        type: integer
                        format: int64
                        description: 'pool_async_index_reads: Asynchronous Pool Index Reads'
                      PL_D_TE:
                        type: integer
                        format: int64
                        description: 'pool_data_to_estore: No. of Pages Copied from BP to ExStor.'
                      PL_I_TE:
                        type: integer
                        format: int64
                        description: 'pool_index_to_estore: No. of Pages Copied from BP to ExStor.'
                      PL_I_FE:
                        type: integer
                        format: int64
                        description: 'pool_index_from_estore: No of Pages Copied from ExStor to BP'
                      PL_D_FEI:
                        type: integer
                        format: int64
                        description: 'pool_data_from_estorei: No of Pages Copied from ExStor to BP'
                      DB_STATUS:
                        type: string
                        maxLength: 25
                        description: 'db_status: Status of the Database'
                      LCK_TMOUT:
                        type: integer
                        format: int64
                        description: 'lock_timeouts: Number of Lock Timeouts Since First Connect'
                      CN_TOP:
                        type: integer
                        format: int64
                        description: 'connections_top: High Water Mark for Current Connections'
                      DB_HP_TOP:
                        type: integer
                        format: int64
                        description: 'db_heap_top: High Water Mark for Database Heap (Bytes)'
                      PL_A_DRS:
                        type: integer
                        format: int64
                        description: 'pool_async_data_reads: Asynchronous Pool Data Reads'
                      PL_A_DWS:
                        type: integer
                        format: int64
                        description: 'pool_async_data_writes: Asynchronous Pool Data Writes'
                      PL_A_IWS:
                        type: integer
                        format: int64
                        description: 'pool_async_index_writes: Asynchronous Pool Index Writes'
                      PL_A_RTM:
                        type: integer
                        format: int64
                        description: 'pool_async_read_time: Total Asynchronous Read Time'
                      PL_A_WTM:
                        type: integer
                        format: int64
                        description: 'pool_async_write_time: Total Asynchronous Write Time'
                      PL_A_DRRQ:
                        type: integer
                        format: int64
                        description: 'pool_async_data_read_reqs: No. of Asynchronous Read Requests'
                      PL_LSNGCL:
                        type: integer
                        format: int64
                        description: 'pool_lsn_gap_clns: LSN Gap Cleaner Triggers'
                      PL_DPSCL:
                        type: integer
                        format: int64
                        description: 'pool_drty_pg_steal_clns: Dirty Page Steal Cleaner Trig.'
                      PL_DPTCL:
                        type: integer
                        format: int64
                        description: 'pool_drty_pg_thrsh_clns: Dirty List Threshold Cleaner Trig.'
                      DIRCT_RDS:
                        type: integer
                        format: int64
                        description: 'direct_reads: Direct Reads Since First Connect'
                      DIRCT_WTS:
                        type: integer
                        format: int64
                        description: 'direct_writes: Direct Writes Since First Connect'
                      DIRCT_RRQS:
                        type: integer
                        format: int64
                        description: 'direct_read_reqs: Direct Read Requests'
                      DIRCT_WRQS:
                        type: integer
                        format: int64
                        description: 'direct_write_reqs: Direct Write Requests'
                      DIRCT_RTM:
                        type: integer
                        format: int64
                        description: 'direct_read_time: Direct Read Time Since First Connect'
                      DIRCT_WTM:
                        type: integer
                        format: int64
                        description: 'direct_write_time: Direct Write Time Since First Connect'
                      INT_RW_INS:
                        type: integer
                        format: int64
                        description: 'int_rows_inserted: Number of Rows Inserted for Trigger'
                      LOG_READS:
                        type: integer
                        format: int64
                        description: 'log_reads: Number of Log Pages Read Since First Connect'
                      LOG_WRITES:
                        type: integer
                        format: int64
                        description: 'log_writes: Number of Log Pages Read Since First Connect'
                      PKG_CA_LKU:
                        type: integer
                        format: int64
                        description: 'pkg_cache_lookups: Number of Section Lookups'
                      PKG_CA_INS:
                        type: integer
                        format: int64
                        description: 'pkg_cache_inserts: Number of Sections Inserted into Cache'
                      CATCA_LKU:
                        type: integer
                        format: int64
                        description: 'cat_cache_lookups: Number of Table Descriptor Lookups'
                      CATCA_INS:
                        type: integer
                        format: int64
                        description: 'cat_cache_inserts: Number of Table Descriptors Inserted'
                      CATCA_OF:
                        type: integer
                        format: int64
                        description: 'cat_cache_overflows: Number of Catalog Cache Overflows'
                      CATCA_HPFL:
                        type: integer
                        format: int64
                        description: 'cat_cache_heap_full: Number of Overflows due to DB Heap Full'
                      CAT_NODE:
                        type: integer
                        format: int64
                        description: 'catalog_node: Catalog Node Number'
                      TOT_SEC_CN:
                        type: integer
                        format: int64
                        description: 'total_sec_cons: Secondary Connects Since First Connect'
                      NUM_ASS_AG:
                        type: integer
                        format: int64
                        description: 'num_assoc_agents: Current Number of Agents Associated'
                      AGENTS_TOP:
                        type: integer
                        format: int64
                        description: 'agents_top: Maximum Number of Agents Associated at Once'
                      CRD_AG_TOP:
                        type: integer
                        format: int64
                        description: 'coord_agents_top: Max. No. of Coord. Agents Connected to DB'
                      DB_LOCAT:
                        type: string
                        maxLength: 25
                        description: 'db_location: Local or Remote to Application Snapshot'
                      SERV_PLATF:
                        type: string
                        maxLength: 25
                        description: 'server_platform: Operating System on Which DBM Runs'
                      CAT_ND_NME:
                        type: string
                        maxLength: 32
                        description: 'DB6: Long identifier'
                      PF_WTTM:
                        type: integer
                        format: int64
                        description: 'prefetch_wait_time: Time Waited for Prefetch (ms)'
                      AP_SEC_LKU:
                        type: integer
                        format: int64
                        description: 'appl_section_lookups: Number of Section Lookups'
                      AP_SEC_INS:
                        type: integer
                        format: int64
                        description: 'appl_section_inserts: Number of Sections Inserted'
                      TOT_HAJN:
                        type: integer
                        format: int64
                        description: 'total_hash_joins: Number of Hash Joins'
                      TOT_HALOOP:
                        type: integer
                        format: int64
                        description: 'total_hash_loops: Number of Hash Loops'
                      HAJN_OF:
                        type: integer
                        format: int64
                        description: 'hash_join_overflows: Number of Hash Join Overflows'
                      HAJN_SM_OF:
                        type: integer
                        format: int64
                        description: 'hash_join_small_overflows: Small Hash Join Overflows'
                      TOT_LGUSED:
                        type: integer
                        format: int64
                        description: 'total_log_used: Log Space Used by Database'
                      TOT_LGAVL:
                        type: integer
                        format: int64
                        description: 'total_log_available: Log Space Available in Database'
                      UNREADPFPG:
                        type: integer
                        format: int64
                        description: 'unread_prefetch_pages: Unread prefetched pages'
                      PKG_NUM_OV:
                        type: integer
                        format: int64
                        description: 'pkg_cache_num_overflows: Package Cache Number Overflows'
                      PKG_SZ_TOP:
                        type: integer
                        format: int64
                        description: 'pkg_cache_size_top: Package Cache Size Top'
                      PL_TD_LRS:
                        type: integer
                        format: int64
                        description: pool_temp_data_l_reads
                      PL_TD_PRS:
                        type: integer
                        format: int64
                        description: pool_temp_data_p_reads
                      PL_TI_LRS:
                        type: integer
                        format: int64
                        description: pool_temp_index_l_reads
                      PL_TI_PRS:
                        type: integer
                        format: int64
                        description: pool_temp_index_p_reads
                      PL_A_IRRQ:
                        type: integer
                        format: int64
                        description: pool_async_indec_read_reqs
                      CATCASZTOP:
                        type: integer
                        format: int64
                        description: cat_cache_size_top
                      LOGREADTS:
                        type: integer
                        format: int64
                        description: ''
                      LOGREADTNS:
                        type: integer
                        format: int64
                        description: ''
                      LOGWRITS:
                        type: integer
                        format: int64
                        description: 'log_writes: Number of Log Pages Read Since First Connect'
                      LOGWRITNS:
                        type: integer
                        format: int64
                        description: ''
                      NUMLOGWRIO:
                        type: integer
                        format: int64
                        description: ''
                      NUMLOGRDIO:
                        type: integer
                        format: int64
                        description: ''
                      NUMLOGPPIO:
                        type: integer
                        format: int64
                        description: ''
                      NUMLOGBFUL:
                        type: integer
                        format: int64
                        description: ''
                      NUMLOGDFND:
                        type: integer
                        format: int64
                        description: ''
                      LOGREDOREC:
                        type: integer
                        format: int64
                        description: ''
                      LOGHELDDTY:
                        type: integer
                        format: int64
                        description: ''
                      ACTIVE_HASH_JOIN:
                        type: integer
                        format: int64
                        description: ''
                      DBNAME:
                        type: string
                        maxLength: 100
                        description: ''
                      PL_ASYNC_XDA_RDS:
                        type: integer
                        format: int64
                        description: ''
                      PL_ASYNC_XDA_RRQ:
                        type: integer
                        format: int64
                        description: ''
                      PL_ASYNC_XDA_WRT:
                        type: integer
                        format: int64
                        description: ''
                      PL_TEMP_XDA_L_RD:
                        type: integer
                        format: int64
                        description: ''
                      PL_TEMP_XDA_P_RD:
                        type: integer
                        format: int64
                        description: ''
                      POOL_XDA_L_READS:
                        type: integer
                        format: int64
                        description: ''
                      POOL_XDA_P_READS:
                        type: integer
                        format: int64
                        description: ''
                      POOL_XDA_WRITES:
                        type: integer
                        format: int64
                        description: ''
                      POST_SHRTHRS_HAJ:
                        type: integer
                        format: int64
                        description: ''
                      POST_SHRTHRS_SRT:
                        type: integer
                        format: int64
                        description: ''
                      SMALLEST_LOG_AVL:
                        type: integer
                        format: int64
                        description: ''
                      APPL_ID_OLDEST_X:
                        type: integer
                        format: int64
                        description: appl_id_oldest_xact
                      ELPSD_EXC_TIM_MS:
                        type: integer
                        format: int64
                        description: elapsed_exec_time_ms
                      ELPSD_EXC_TIM_S:
                        type: integer
                        format: int64
                        description: elapsed_exec_time_s
                      NUM_DB_STORPATHS:
                        type: integer
                        format: int64
                        description: num_db_storage_paths
                      NUM_INDOUBT_TRAN:
                        type: integer
                        format: int64
                        description: num_indoubt_trans
                      PL_NO_VICTIM_BUF:
                        type: integer
                        format: int64
                        description: pool_no_victim_buffer
                      ROWS_READ:
                        type: integer
                        format: int64
                        description: rows_read
                      PRV_WS_NUM_OVFL:
                        type: integer
                        format: int64
                        description: priv_workspace_num_overflows
                      PRV_WS_SCT_INSRT:
                        type: integer
                        format: int64
                        description: priv_workspace_section_inserts
                      PRV_WS_SCT_LKUP:
                        type: integer
                        format: int64
                        description: priv_workspace_section_lookups
                      PRV_WS_SIZE_TOP:
                        type: integer
                        format: int64
                        description: priv_workspace_size_top
                      SHR_WS_NUM_OVFL:
                        type: integer
                        format: int64
                        description: shr_workspace_num_overflows
                      SHR_WS_SCT_INSRT:
                        type: integer
                        format: int64
                        description: shr_workspace_section_inserts
                      SHR_WS_SCT_LKUP:
                        type: integer
                        format: int64
                        description: shr_workspace_section_lookups
                      SHR_WS_SIZE_TOP:
                        type: integer
                        format: int64
                        description: shr_workspace_size_top
                      SORT_SHRHEAP_ALL:
                        type: integer
                        format: int64
                        description: sort_shrheap_allocated
                      SORT_SHRHEAP_TOP:
                        type: integer
                        format: int64
                        description: sort_shrheap_top
              required:
              - ACTION
              - CALLERFLAG
              - PARTITN
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                properties:
                  IT_DB6PMSD:
                    type: array
                    items:
                      type: object
                      properties:
                        COMPTIME:
                          type: string
                          maxLength: 14
                          description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                        PARTITN:
                          type: integer
                          format: int32
                          description: Partition Number
                        CALLERFLAG:
                          type: string
                          maxLength: 1
                          description: Who Has Called this Program
                        DBMSTRTTME:
                          type: string
                          maxLength: 14
                          description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                        PRGVERS:
                          type: string
                          maxLength: 20
                          description: Version of Program Inserted this Row
                        IN_DB_ALIA:
                          type: string
                          maxLength: 20
                          description: 'DB6: General identifier'
                        DB_NAME:
                          type: string
                          maxLength: 20
                          description: 'DB6: General identifier'
                        DB_PATH:
                          type: string
                          maxLength: 255
                          description: 'DB6: File Path'
                        LCKS_HELD:
                          type: integer
                          format: int64
                          description: 'locks_held: Locks Currently Held'
                        LCK_WAITS:
                          type: integer
                          format: int64
                          description: 'lock_waits: Lock Waits Since First Connect'
                        LCK_W_TM:
                          type: integer
                          format: int64
                          description: 'lock_wait_time: Total Time Database Waited for Locks'
                        LCK_LSTIU:
                          type: integer
                          format: int64
                          description: 'lock_list_in_use: Total Lock List Memory in Use'
                        DEADLOCKS:
                          type: integer
                          format: int64
                          description: 'deadlocks: Deadlocks Since First DB Connect'
                        LCK_ESCALS:
                          type: integer
                          format: int64
                          description: 'lock_escals: Lock Escalations Since First DB Connect'
                        X_LCK_ESCA:
                          type: integer
                          format: int64
                          description: 'x_lock_escals: X Lock Escalations Since First DB Connect'
                        LCK_WTING:
                          type: integer
                          format: int64
                          description: 'locks_waiting: Agents Currently Waiting for Locks'
                        SRT_HP_ALO:
                          type: integer
                          format: int64
                          description: 'sort_heap_allocated: Total Sort Heap Allocated'
                        TOT_SORTS:
                          type: integer
                          format: int64
                          description: 'total_sorts: Number of Sorts Since First Connect'
                        TOT_SRT_TM:
                          type: integer
                          format: int64
                          description: 'total_sort_time: Elapsed Time Spent in Sorts'
                        SRT_OF:
                          type: integer
                          format: int64
                          description: 'sort_overflows: Number of Sort Overflows'
                        ACTIV_SORT:
                          type: integer
                          format: int64
                          description: 'active_sorts: Sorts Currently Active'
                        PL_D_LRS:
                          type: integer
                          format: int64
                          description: 'pool_data_l_reads: Pool Data Logical Reads Since Connect'
                        PL_D_PRS:
                          type: integer
                          format: int64
                          description: 'pool_data_p_reads: Pool Data Reads Since First Connect'
                        PL_D_WS:
                          type: integer
                          format: int64
                          description: 'pool_data_writes: Pool Data Writes Since First Connect'
                        PL_I_LRS:
                          type: integer
                          format: int64
                          description: 'pool_index_l_reads: Pool Index Logical Reads Since Connect'
                        PL_I_PRS:
                          type: integer
                          format: int64
                          description: 'pool_index_p_reads: Pool Index Reads Since First Connect'
                        PL_I_WS:
                          type: integer
                          format: int64
                          description: 'pool_index_writes: Pool Index Writes Since First Connect'
                        PL_RD_TM:
                          type: integer
                          format: int64
                          description: 'pool_read_time: Buffer Pool Read Time Since First Connect'
                        PL_WT_TM:
                          type: integer
                          format: int64
                          description: 'pool_write_time: Buffer Pool Write Time Since First Connect'
                        FLS_CLOSED:
                          type: integer
                          format: int64
                          description: 'files_closed: Files Closed Since First DB Connect'
                        CMMT_SQLST:
                          type: integer
                          format: int64
                          description: 'commit_sql_stmts: Number of COMMIT SQL Statements Since Conn'
                        RBCK_SQLST:
                          type: integer
                          format: int64
                          description: 'rollback_sql_stmts: No. of ROLLBACK SQL Stmts Since Connect'
                        DYN_SQLST:
                          type: integer
                          format: int64
                          description: 'dynamic_sql_stmts: Number of Dynamic SQL Stmts Since Connect'
                        STC_SQLST:
                          type: integer
                          format: int64
                          description: 'static_sql_stmts: Number of Static SQL Statements Since Conn'
                        FAIL_SQLST:
                          type: integer
                          format: int64
                          description: 'failed_sql_stmts: Number of Failed SQL Stmts Since Connect'
                        SELC_SQLST:
                          type: integer
                          format: int64
                          description: 'select_sql_stmts: Number of SQL SELECT Stmts Since Connect'
                        DDL_SQLST:
                          type: integer
                          format: int64
                          description: 'ddl_sql_stmts: Number of Data Definition Language Statements'
                        UID_SQLST:
                          type: integer
                          format: int64
                          description: 'uid_sql_stmts: Number of UPDATE/INSERT/DELETE Statements'
                        INT_ATRBND:
                          type: integer
                          format: int64
                          description: 'int_auto_rebinds: Number of Auto Rebinds Since First Connect'
                        INT_RW_DEL:
                          type: integer
                          format: int64
                          description: 'int_rows_deleted: No. of Casc. Deletes Since First Connect'
                        INT_RW_UPD:
                          type: integer
                          format: int64
                          description: 'int_rows_updated: Number of Set Null Deletes Since Connect'
                        INT_CMMTS:
                          type: integer
                          format: int64
                          description: 'int_commits: Number of Int. COMMITs Since First Connect'
                        INT_RB:
                          type: integer
                          format: int64
                          description: 'int_rollbacks: Number of Int. ROLLBACKs Since First Connect'
                        INT_DL_RB:
                          type: integer
                          format: int64
                          description: 'int_deadlock_rollbacks: # of ROLLBACKs due to Deadlock Since'
                        RW_DELETED:
                          type: integer
                          format: int64
                          description: 'rows_deleted: Number of Rows Deleted Since Connect'
                        RW_INSRTED:
                          type: integer
                          format: int64
                          description: 'rows_inserted: Number of Rows Inserted Since Connect'
                        RW_UPDATED:
                          type: integer
                          format: int64
                          description: 'rows_updated: Number of Rows Updated Since Connect'
                        RW_SELECED:
                          type: integer
                          format: int64
                          description: 'rows_selected: Number of Rows Selected Since Connect'
                        BIND_PRECC:
                          type: integer
                          format: int64
                          description: 'binds_precompiles: # of BINDs/PRECOMPILEs Since First Conn.'
                        DB_CN_TM:
                          type: string
                          maxLength: 14
                          description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                        LAST_RESET:
                          type: string
                          maxLength: 14
                          description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                        LAST_BKUP:
                          type: string
                          maxLength: 14
                          description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                        TOTAL_CONS:
                          type: integer
                          format: int64
                          description: 'total_cons: Connects Since First DB Connect'
                        APL_CUR_CO:
                          type: integer
                          format: int64
                          description: 'appls_cur_cons: Applications Currently Connected'
                        APL_IN_DB2:
                          type: integer
                          format: int64
                          description: 'appls_in_db2: Applications Executing in DB2'
                        SEC_LGUSTP:
                          type: integer
                          format: int64
                          description: 'sec_log_used_top: Maximum Secondary Log Space Used'
                        TOT_LGUTOP:
                          type: integer
                          format: int64
                          description: 'tot_log_used_top: Maximum Total Log Space Used'
                        SEC_LGALLO:
                          type: integer
                          format: int64
                          description: 'sec_logs_allocated: Number of Secondary Logs Allocated'
                        NUM_SCDBS:
                          type: integer
                          format: int64
                          description: 'num_sec_dbase_structs: Secondary Database Information'
                        PL_A_IRS:
                          type: integer
                          format: int64
                          description: 'pool_async_index_reads: Asynchronous Pool Index Reads'
                        PL_D_TE:
                          type: integer
                          format: int64
                          description: 'pool_data_to_estore: No. of Pages Copied from BP to ExStor.'
                        PL_I_TE:
                          type: integer
                          format: int64
                          description: 'pool_index_to_estore: No. of Pages Copied from BP to ExStor.'
                        PL_I_FE:
                          type: integer
                          format: int64
                          description: 'pool_index_from_estore: No of Pages Copied from ExStor to BP'
                        PL_D_FEI:
                          type: integer
                          format: int64
                          description: 'pool_data_from_estorei: No of Pages Copied from ExStor to BP'
                        DB_STATUS:
                          type: string
                          maxLength: 25
                          description: 'db_status: Status of the Database'
                        LCK_TMOUT:
                          type: integer
                          format: int64
                          description: 'lock_timeouts: Number of Lock Timeouts Since First Connect'
                        CN_TOP:
                          type: integer
                          format: int64
                          description: 'connections_top: High Water Mark for Current Connections'
                        DB_HP_TOP:
                          type: integer
                          format: int64
                          description: 'db_heap_top: High Water Mark for Database Heap (Bytes)'
                        PL_A_DRS:
                          type: integer
                          format: int64
                          description: 'pool_async_data_reads: Asynchronous Pool Data Reads'
                        PL_A_DWS:
                          type: integer
                          format: int64
                          description: 'pool_async_data_writes: Asynchronous Pool Data Writes'
                        PL_A_IWS:
                          type: integer
                          format: int64
                          description: 'pool_async_index_writes: Asynchronous Pool Index Writes'
                        PL_A_RTM:
                          type: integer
                          format: int64
                          description: 'pool_async_read_time: Total Asynchronous Read Time'
                        PL_A_WTM:
                          type: integer
                          format: int64
                          description: 'pool_async_write_time: Total Asynchronous Write Time'
                        PL_A_DRRQ:
                          type: integer
                          format: int64
                          description: 'pool_async_data_read_reqs: No. of Asynchronous Read Requests'
                        PL_LSNGCL:
                          type: integer
                          format: int64
                          description: 'pool_lsn_gap_clns: LSN Gap Cleaner Triggers'
                        PL_DPSCL:
                          type: integer
                          format: int64
                          description: 'pool_drty_pg_steal_clns: Dirty Page Steal Cleaner Trig.'
                        PL_DPTCL:
                          type: integer
                          format: int64
                          description: 'pool_drty_pg_thrsh_clns: Dirty List Threshold Cleaner Trig.'
                        DIRCT_RDS:
                          type: integer
                          format: int64
                          description: 'direct_reads: Direct Reads Since First Connect'
                        DIRCT_WTS:
                          type: integer
                          format: int64
                          description: 'direct_writes: Direct Writes Since First Connect'
                        DIRCT_RRQS:
                          type: integer
                          format: int64
                          description: 'direct_read_reqs: Direct Read Requests'
                        DIRCT_WRQS:
                          type: integer
                          format: int64
                          description: 'direct_write_reqs: Direct Write Requests'
                        DIRCT_RTM:
                          type: integer
                          format: int64
                          description: 'direct_read_time: Direct Read Time Since First Connect'
                        DIRCT_WTM:
                          type: integer
                          format: int64
                          description: 'direct_write_time: Direct Write Time Since First Connect'
                        INT_RW_INS:
                          type: integer
                          format: int64
                          description: 'int_rows_inserted: Number of Rows Inserted for Trigger'
                        LOG_READS:
                          type: integer
                          format: int64
                          description: 'log_reads: Number of Log Pages Read Since First Connect'
                        LOG_WRITES:
                          type: integer
                          format: int64
                          description: 'log_writes: Number of Log Pages Read Since First Connect'
                        PKG_CA_LKU:
                          type: integer
                          format: int64
                          description: 'pkg_cache_lookups: Number of Section Lookups'
                        PKG_CA_INS:
                          type: integer
                          format: int64
                          description: 'pkg_cache_inserts: Number of Sections Inserted into Cache'
                        CATCA_LKU:
                          type: integer
                          format: int64
                          description: 'cat_cache_lookups: Number of Table Descriptor Lookups'
                        CATCA_INS:
                          type: integer
                          format: int64
                          description: 'cat_cache_inserts: Number of Table Descriptors Inserted'
                        CATCA_OF:
                          type: integer
                          format: int64
                          description: 'cat_cache_overflows: Number of Catalog Cache Overflows'
                        CATCA_HPFL:
                          type: integer
                          format: int64
                          description: 'cat_cache_heap_full: Number of Overflows due to DB Heap Full'
                        CAT_NODE:
                          type: integer
                          format: int64
                          description: 'catalog_node: Catalog Node Number'
                        TOT_SEC_CN:
                          type: integer
                          format: int64
                          description: 'total_sec_cons: Secondary Connects Since First Connect'
                        NUM_ASS_AG:
                          type: integer
                          format: int64
                          description: 'num_assoc_agents: Current Number of Agents Associated'
                        AGENTS_TOP:
                          type: integer
                          format: int64
                          description: 'agents_top: Maximum Number of Agents Associated at Once'
                        CRD_AG_TOP:
                          type: integer
                          format: int64
                          description: 'coord_agents_top: Max. No. of Coord. Agents Connected to DB'
                        DB_LOCAT:
                          type: string
                          maxLength: 25
                          description: 'db_location: Local or Remote to Application Snapshot'
                        SERV_PLATF:
                          type: string
                          maxLength: 25
                          description: 'server_platform: Operating System on Which DBM Runs'
                        CAT_ND_NME:
                          type: string
                          maxLength: 32
                          description: 'DB6: Long identifier'
                        PF_WTTM:
                          type: integer
                          format: int64
                          description: 'prefetch_wait_time: Time Waited for Prefetch (ms)'
                        AP_SEC_LKU:
                          type: integer
                          format: int64
                          description: 'appl_section_lookups: Number of Section Lookups'
                        AP_SEC_INS:
                          type: integer
                          format: int64
                          description: 'appl_section_inserts: Number of Sections Inserted'
                        TOT_HAJN:
                          type: integer
                          format: int64
                          description: 'total_hash_joins: Number of Hash Joins'
                        TOT_HALOOP:
                          type: integer
                          format: int64
                          description: 'total_hash_loops: Number of Hash Loops'
                        HAJN_OF:
                          type: integer
                          format: int64
                          description: 'hash_join_overflows: Number of Hash Join Overflows'
                        HAJN_SM_OF:
                          type: integer
                          format: int64
                          description: 'hash_join_small_overflows: Small Hash Join Overflows'
                        TOT_LGUSED:
                          type: integer
                          format: int64
                          description: 'total_log_used: Log Space Used by Database'
                        TOT_LGAVL:
                          type: integer
                          format: int64
                          description: 'total_log_available: Log Space Available in Database'
                        UNREADPFPG:
                          type: integer
                          format: int64
                          description: 'unread_prefetch_pages: Unread prefetched pages'
                        PKG_NUM_OV:
                          type: integer
                          format: int64
                          description: 'pkg_cache_num_overflows: Package Cache Number Overflows'
                        PKG_SZ_TOP:
                          type: integer
                          format: int64
                          description: 'pkg_cache_size_top: Package Cache Size Top'
                        PL_TD_LRS:
                          type: integer
                          format: int64
                          description: pool_temp_data_l_reads
                        PL_TD_PRS:
                          type: integer
                          format: int64
                          description: pool_temp_data_p_reads
                        PL_TI_LRS:
                          type: integer
                          format: int64
                          description: pool_temp_index_l_reads
                        PL_TI_PRS:
                          type: integer
                          format: int64
                          description: pool_temp_index_p_reads
                        PL_A_IRRQ:
                          type: integer
                          format: int64
                          description: pool_async_indec_read_reqs
                        CATCASZTOP:
                          type: integer
                          format: int64
                          description: cat_cache_size_top
                        LOGREADTS:
                          type: integer
                          format: int64
                          description: ''
                        LOGREADTNS:
                          type: integer
                          format: int64
                          description: ''
                        LOGWRITS:
                          type: integer
                          format: int64
                          description: 'log_writes: Number of Log Pages Read Since First Connect'
                        LOGWRITNS:
                          type: integer
                          format: int64
                          description: ''
                        NUMLOGWRIO:
                          type: integer
                          format: int64
                          description: ''
                        NUMLOGRDIO:
                          type: integer
                          format: int64
                          description: ''
                        NUMLOGPPIO:
                          type: integer
                          format: int64
                          description: ''
                        NUMLOGBFUL:
                          type: integer
                          format: int64
                          description: ''
                        NUMLOGDFND:
                          type: integer
                          format: int64
                          description: ''
                        LOGREDOREC:
                          type: integer
                          format: int64
                          description: ''
                        LOGHELDDTY:
                          type: integer
                          format: int64
                          description: ''
                        ACTIVE_HASH_JOIN:
                          type: integer
                          format: int64
                          description: ''
                        DBNAME:
                          type: string
                          maxLength: 100
                          description: ''
                        PL_ASYNC_XDA_RDS:
                          type: integer
                          format: int64
                          description: ''
                        PL_ASYNC_XDA_RRQ:
                          type: integer
                          format: int64
                          description: ''
                        PL_ASYNC_XDA_WRT:
                          type: integer
                          format: int64
                          description: ''
                        PL_TEMP_XDA_L_RD:
                          type: integer
                          format: int64
                          description: ''
                        PL_TEMP_XDA_P_RD:
                          type: integer
                          format: int64
                          description: ''
                        POOL_XDA_L_READS:
                          type: integer
                          format: int64
                          description: ''
                        POOL_XDA_P_READS:
                          type: integer
                          format: int64
                          description: ''
                        POOL_XDA_WRITES:
                          type: integer
                          format: int64
                          description: ''
                        POST_SHRTHRS_HAJ:
                          type: integer
                          format: int64
                          description: ''
                        POST_SHRTHRS_SRT:
                          type: integer
                          format: int64
                          description: ''
                        SMALLEST_LOG_AVL:
                          type: integer
                          format: int64
                          description: ''
                        APPL_ID_OLDEST_X:
                          type: integer
                          format: int64
                          description: appl_id_oldest_xact
                        ELPSD_EXC_TIM_MS:
                          type: integer
                          format: int64
                          description: elapsed_exec_time_ms
                        ELPSD_EXC_TIM_S:
                          type: integer
                          format: int64
                          description: elapsed_exec_time_s
                        NUM_DB_STORPATHS:
                          type: integer
                          format: int64
                          description: num_db_storage_paths
                        NUM_INDOUBT_TRAN:
                          type: integer
                          format: int64
                          description: num_indoubt_trans
                        PL_NO_VICTIM_BUF:
                          type: integer
                          format: int64
                          description: pool_no_victim_buffer
                        ROWS_READ:
                          type: integer
                          format: int64
                          description: rows_read
                        PRV_WS_NUM_OVFL:
                          type: integer
                          format: int64
                          description: priv_workspace_num_overflows
                        PRV_WS_SCT_INSRT:
                          type: integer
                          format: int64
                          description: priv_workspace_section_inserts
                        PRV_WS_SCT_LKUP:
                          type: integer
                          format: int64
                          description: priv_workspace_section_lookups
                        PRV_WS_SIZE_TOP:
                          type: integer
                          format: int64
                          description: priv_workspace_size_top
                        SHR_WS_NUM_OVFL:
                          type: integer
                          format: int64
                          description: shr_workspace_num_overflows
                        SHR_WS_SCT_INSRT:
                          type: integer
                          format: int64
                          description: shr_workspace_section_inserts
                        SHR_WS_SCT_LKUP:
                          type: integer
                          format: int64
                          description: shr_workspace_section_lookups
                        SHR_WS_SIZE_TOP:
                          type: integer
                          format: int64
                          description: shr_workspace_size_top
                        SORT_SHRHEAP_ALL:
                          type: integer
                          format: int64
                          description: sort_shrheap_allocated
                        SORT_SHRHEAP_TOP:
                          type: integer
                          format: int64
                          description: sort_shrheap_top
        '400':
          description: Bad request.
        5XX:
          description: Unexpected error.
