openapi: 3.0.0
info:
  title: SAP API
  version: 1.0.0
servers:
- url: http://localhost:8080
paths:
  /rfc/DB6_PM_1ST4:
    post:
      tags:
      - SDB6PMST04
      summary: 'DB6: Calculation of Figures for ST04 Initial Screen (RFC Layer 1)'
      operationId: /rfc/DB6_PM_1ST4
      requestBody:
        content:
          application/json:
            schema:
              properties:
                ACTION:
                  type: integer
                  format: int32
                  description: what the function should do
                CONNECTION:
                  type: string
                  maxLength: 30
                  description: Logical name for a database connection
                PARTITN:
                  type: integer
                  format: int32
                  description: Partition Number
                IT_DB6PM1ST4:
                  type: array
                  items:
                    type: object
                    properties:
                      DBMSTRTTME:
                        type: string
                        maxLength: 14
                        description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                      COMPTIME:
                        type: string
                        maxLength: 14
                        description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                      LAST_RESET:
                        type: string
                        maxLength: 14
                        description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                      BUFFPAGE:
                        type: integer
                        format: int64
                        description: Default Buffer Pool Size of DB CFG (4 KB Pages)
                      BP_SZ:
                        type: integer
                        format: int64
                        description: Total Buffer Pool Size (KB)
                      BP_QAL:
                        type: integer
                        format: int64
                        description: Overall Buffer Quality (%)
                      BP_AV_RTM:
                        type: integer
                        format: int64
                        description: Average Physical Read Time (ms)
                      BP_AV_WTM:
                        type: integer
                        format: int64
                        description: Average Physical Write Time (ms)
                      BP_D_HITRT:
                        type: integer
                        format: int64
                        description: Buffer Pool Data Hit Ratio (%)
                      BP_I_HITRT:
                        type: integer
                        format: int64
                        description: Buffer Pool Index Hit Ratio (%)
                      BP_NUM:
                        type: integer
                        format: int64
                        description: Number of Buffer Pools
                      PL_D_LRS:
                        type: integer
                        format: int64
                        description: Data Logical Reads
                      PL_D_PRS:
                        type: integer
                        format: int64
                        description: Data Physical Reads
                      PL_D_WS:
                        type: integer
                        format: int64
                        description: Data Physical Writes
                      BP_D_SPRS:
                        type: integer
                        format: int64
                        description: Data Synchronous Physical Reads
                      BP_D_SWS:
                        type: integer
                        format: int64
                        description: Data Synchronous Physical Writes
                      PL_I_LRS:
                        type: integer
                        format: int64
                        description: Index Logical Reads
                      PL_I_PRS:
                        type: integer
                        format: int64
                        description: Index Physical Reads
                      PL_I_WS:
                        type: integer
                        format: int64
                        description: Index Physical Writes
                      BP_I_SPRS:
                        type: integer
                        format: int64
                        description: Index Synchronous Physical Reads
                      BP_I_SWS:
                        type: integer
                        format: int64
                        description: Index Synchronous Physical Writes
                      PL_RD_TM:
                        type: integer
                        format: int64
                        description: Pool Read Time
                      PL_WT_TM:
                        type: integer
                        format: int64
                        description: Pool Write Time
                      CATCA_SZ:
                        type: integer
                        format: int64
                        description: Catalog Cache Size (KB)
                      CATCA_QAL:
                        type: integer
                        format: int64
                        description: Catalog Cache Quality %
                      MAXAPPLS:
                        type: integer
                        format: int64
                        description: Maximum Number of Active Applications
                      PKG_CA_SZ:
                        type: integer
                        format: int64
                        description: Package Cache Size (KB)
                      PKG_CA_QAL:
                        type: integer
                        format: int64
                        description: Package Cache Quality (%)
                      CATCA_LKU:
                        type: integer
                        format: int64
                        description: Catalog Cache Lookups
                      CATCA_INS:
                        type: integer
                        format: int64
                        description: Catalog Cache Inserts
                      CATCA_OF:
                        type: integer
                        format: int64
                        description: Catalog Cache Overflows
                      CATCA_HPFL:
                        type: integer
                        format: int64
                        description: Catalog Cache Heap Full
                      PKG_CA_LKU:
                        type: integer
                        format: int64
                        description: Package Cache Lookups
                      PKG_CA_INS:
                        type: integer
                        format: int64
                        description: Package Cache Inserts
                      PKG_NUM_OV:
                        type: integer
                        format: int64
                        description: Package Cache Number Overflows
                      PKG_SZ_TOP:
                        type: integer
                        format: int64
                        description: Package Cache Size Top
                      NUM_IOSVRS:
                        type: integer
                        format: int64
                        description: Number of I/O Servers
                      AV_ASP_RTM:
                        type: integer
                        format: int64
                        description: Average Asynchronous Physical Read Time (ms)
                      NUM_IOCLNS:
                        type: integer
                        format: int64
                        description: Number of I/O Cleaners
                      AV_ASP_WTM:
                        type: integer
                        format: int64
                        description: Average Asynchronous Physical Write Time (ms)
                      PL_A_DRS:
                        type: integer
                        format: int64
                        description: Data Asynchronous Physical Reads
                      PL_A_DWS:
                        type: integer
                        format: int64
                        description: Data Asynchronous Physical Writes
                      PL_A_IRS:
                        type: integer
                        format: int64
                        description: Index Asynchronous Physical Reads
                      PL_A_IWS:
                        type: integer
                        format: int64
                        description: Index Asynchronous Physical Writes
                      PL_A_RTM:
                        type: integer
                        format: int64
                        description: Asynchronous Read Time
                      PL_A_WTM:
                        type: integer
                        format: int64
                        description: Asynchronous Write Time
                      LCKLISTSZ:
                        type: integer
                        format: int64
                        description: Lock List Size (KB)
                      LCK_LSTIU:
                        type: integer
                        format: int64
                        description: Lock List in Use (KB)
                      LCK_ESCALS:
                        type: integer
                        format: int64
                        description: Lock Escalations
                      X_LCK_ESCA:
                        type: integer
                        format: int64
                        description: Exclusive Lock Escalations
                      LCK_WAITS:
                        type: integer
                        format: int64
                        description: Total Lock Waits
                      LCK_W_TM:
                        type: integer
                        format: int64
                        description: Time Waited for Locks (ms)
                      AV_WTM_LCK:
                        type: integer
                        format: int64
                        description: Average Wait Time per Lock (ms)
                      LCKS_HELD:
                        type: integer
                        format: int64
                        description: Locks Currently Held
                      DEADLOCKS:
                        type: integer
                        format: int64
                        description: Deadlocks Detected
                      LCK_TMOUT:
                        type: integer
                        format: int64
                        description: Lock Timeouts
                      CMMT_SQLST:
                        type: integer
                        format: int64
                        description: COMMITs
                      RBCK_SQLST:
                        type: integer
                        format: int64
                        description: ROLLBACKs
                      SELC_SQLST:
                        type: integer
                        format: int64
                        description: SELECT Statements
                      UID_SQLST:
                        type: integer
                        format: int64
                        description: UPDATE/INSERT/DELETE Statements
                      DYN_SQLST:
                        type: integer
                        format: int64
                        description: Dynamic SQL Statements
                      STC_SQLST:
                        type: integer
                        format: int64
                        description: Static SQL Statements
                      FAIL_SQLST:
                        type: integer
                        format: int64
                        description: Failed SQL Statements
                      DDL_SQLST:
                        type: integer
                        format: int64
                        description: Data Definition Language Statements
                      RW_DELETED:
                        type: integer
                        format: int64
                        description: Rows Deleted
                      RW_INSRTED:
                        type: integer
                        format: int64
                        description: Rows Inserted
                      RW_SELECED:
                        type: integer
                        format: int64
                        description: Rows Selected
                      RW_UPDATED:
                        type: integer
                        format: int64
                        description: Rows Updated
                      SORTHEAPSZ:
                        type: integer
                        format: int64
                        description: Total Sort Heap Size (KB)
                      SRT_HP_ALO:
                        type: integer
                        format: int64
                        description: Sort Heap Allocated (KB)
                      TOT_SORTS:
                        type: integer
                        format: int64
                        description: Total Sorts
                      TOT_SRT_TM:
                        type: integer
                        format: int64
                        description: Total Sort Time (ms)
                      AV_SORT_TM:
                        type: integer
                        format: int64
                        description: Average Sort Time (ms)
                      SRT_OF:
                        type: integer
                        format: int64
                        description: Sort Overflows
                      ACTIV_SORT:
                        type: integer
                        format: int64
                        description: Active Sorts
                      DIRCT_RDS:
                        type: integer
                        format: int64
                        description: Direct Reads
                      DIRCT_WTS:
                        type: integer
                        format: int64
                        description: Direct Writes
                      DIRCT_RTM:
                        type: integer
                        format: int64
                        description: Direct Read Time
                      DIRCT_WTM:
                        type: integer
                        format: int64
                        description: Direct Write Time
                      DIRCT_RRQS:
                        type: integer
                        format: int64
                        description: Direct Read Requests
                      DIRCT_WRQS:
                        type: integer
                        format: int64
                        description: Direct Write Requests
                      AV_DCT_RTM:
                        type: integer
                        format: int64
                        description: Average Direct Read Time
                      AV_DCT_WTM:
                        type: integer
                        format: int64
                        description: Average Direct Write Time
                      AV_DCT_RDS:
                        type: integer
                        format: int64
                        description: Average Direct Reads
                      AV_DCT_WTS:
                        type: integer
                        format: int64
                        description: Average Direct Writes
                      PL_D_TE:
                        type: integer
                        format: int64
                        description: Pool Data to Extended Storage
                      PL_D_FE:
                        type: integer
                        format: int64
                        description: Pool Data from Extended Storage
                      PL_I_TE:
                        type: integer
                        format: int64
                        description: Pool Index to Extended Storage
                      PL_I_FE:
                        type: integer
                        format: int64
                        description: Pool Index from Extended Storage
                      TOT_LGUTOP:
                        type: integer
                        format: int64
                        description: Maximum Total Log Space Used
                      SEC_LGUSTP:
                        type: integer
                        format: int64
                        description: Maximum Secondary Log Space Used
                      SEC_LGALLO:
                        type: integer
                        format: int64
                        description: Number of Secondary Logs Allocated
                      LOG_READS:
                        type: integer
                        format: int64
                        description: Number of Log Pages Read
                      LOG_WRITES:
                        type: integer
                        format: int64
                        description: Number of Log Pages Written
                      TOT_LGUSED:
                        type: integer
                        format: int64
                        description: Log Space Used by Database
                      TOT_LGAVL:
                        type: integer
                        format: int64
                        description: Log Space Available for Database
                      LOGFILSIZ:
                        type: integer
                        format: int64
                        description: Size of Log Files (Pages 4 KB) Configured
                      LOGPRIMARY:
                        type: integer
                        format: int64
                        description: Number of Primary Log Files Configured
                      LOGSECOND:
                        type: integer
                        format: int64
                        description: Number of Secondary Log Files Configured
                      TOT_HAJN:
                        type: integer
                        format: int64
                        description: Number of Hash Joins
                      TOT_HALOOP:
                        type: integer
                        format: int64
                        description: Number of Hash Loops
                      HAJN_OF:
                        type: integer
                        format: int64
                        description: Number of Hash Join Overflows
                      HAJN_SM_OF:
                        type: integer
                        format: int64
                        description: Small Hash Join Overflows
                      PL_TD_LRS:
                        type: integer
                        format: int64
                        description: Temp Data Logical Reads
                      PL_TD_PRS:
                        type: integer
                        format: int64
                        description: Temp Data Physical Reads
                      PL_TI_LRS:
                        type: integer
                        format: int64
                        description: Temp Index Logical Reads
                      PL_TI_PRS:
                        type: integer
                        format: int64
                        description: Temp Index Physical Reads
                      PL_A_DRRQ:
                        type: integer
                        format: int64
                        description: Asynchronous Data Read Requests
                      PL_A_IRRQ:
                        type: integer
                        format: int64
                        description: Asynchronous Index Read Requests
                      CATCASZTOP:
                        type: integer
                        format: int64
                        description: Catalog Cache  Size Top (High Water Mark)
                      LSNGAP_PCT:
                        type: integer
                        format: int64
                        description: LSN Gap
                      RESTRTRNGE:
                        type: integer
                        format: int64
                        description: Restart Range
                      AVGLWTPPAG:
                        type: integer
                        format: int64
                        description: Average Log Write Time / Page
                      AVGLWTPIO:
                        type: integer
                        format: int64
                        description: Average Log Write Time / IO
                      AVGLRTPPAG:
                        type: integer
                        format: int64
                        description: Average Log Read Time / Page
                      AVGLRTPIO:
                        type: integer
                        format: int64
                        description: Average Log Read Time / IO
                      LGBUFHITRT:
                        type: integer
                        format: int64
                        description: Log Buffer Hit Ratio
                      LOGREADTS:
                        type: integer
                        format: int64
                        description: Log Read Time (seconds)
                      LOGREADTNS:
                        type: integer
                        format: int64
                        description: Log Read Time (micro seconds)
                      LOGWRITS:
                        type: integer
                        format: int64
                        description: Log Write Time (seconds)
                      LOGWRITNS:
                        type: integer
                        format: int64
                        description: Log Write Time (micro seconds)
                      NUMLOGWRIO:
                        type: integer
                        format: int64
                        description: Number of Log Write IO
                      NUMLOGRDIO:
                        type: integer
                        format: int64
                        description: Number of Log Read IO
                      NUMLOGPPIO:
                        type: integer
                        format: int64
                        description: num_log_part_page_io
                      NUMLOGBFUL:
                        type: integer
                        format: int64
                        description: num_log_buffer_full
                      NUMLOGDFND:
                        type: integer
                        format: int64
                        description: num_log_data_found_in_buffer
                      LOGREDOREC:
                        type: integer
                        format: int64
                        description: log_to_redo_for_recovery
                      LOGHELDDTY:
                        type: integer
                        format: int64
                        description: log_held_by_dirty_pages
                      SOFTMAX:
                        type: integer
                        format: int32
                        description: SOFTMAX Parameter
                      SCPERHOUR:
                        type: integer
                        format: int64
                        description: Soft Checkpoints / hour
                      ACTIVE_HASH_JOIN:
                        type: integer
                        format: int64
                        description: Active Hash Joins
                      DBNAME:
                        type: string
                        maxLength: 100
                        description: DB Name
                      PL_ASYNC_XDA_RDS:
                        type: integer
                        format: int64
                        description: Pool Async XDA Reads
                      PL_ASYNC_XDA_RRQ:
                        type: integer
                        format: int64
                        description: Pool Async XDA Read Requests
                      PL_ASYNC_XDA_WRT:
                        type: integer
                        format: int64
                        description: Pool Async XDA Writes
                      PL_TEMP_XDA_L_RD:
                        type: integer
                        format: int64
                        description: Pool Temp XDA Logical Reads
                      PL_TEMP_XDA_P_RD:
                        type: integer
                        format: int64
                        description: Pool Temp XDA Physical Reads
                      POOL_XDA_L_READS:
                        type: integer
                        format: int64
                        description: Pool XDA Logical Reads
                      POOL_XDA_P_READS:
                        type: integer
                        format: int64
                        description: Pool XDA Physical Reads
                      POOL_XDA_WRITES:
                        type: integer
                        format: int64
                        description: Pool XDA Writes
                      POST_SHRTHRS_HAJ:
                        type: integer
                        format: int64
                        description: post_shrthreshold_hash_joins
                      POST_SHRTHRS_SRT:
                        type: integer
                        format: int64
                        description: post_shrthreshold_sorts
                      SMALLEST_LOG_AVL:
                        type: integer
                        format: int64
                        description: Smallest Log available
                      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
                      SHEAPTRES:
                        type: integer
                        format: int64
                        description: sortheap_threshold
              required:
              - ACTION
              - PARTITN
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                properties:
                  IT_DB6PM1ST4:
                    type: array
                    items:
                      type: object
                      properties:
                        DBMSTRTTME:
                          type: string
                          maxLength: 14
                          description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                        COMPTIME:
                          type: string
                          maxLength: 14
                          description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                        LAST_RESET:
                          type: string
                          maxLength: 14
                          description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                        BUFFPAGE:
                          type: integer
                          format: int64
                          description: Default Buffer Pool Size of DB CFG (4 KB Pages)
                        BP_SZ:
                          type: integer
                          format: int64
                          description: Total Buffer Pool Size (KB)
                        BP_QAL:
                          type: integer
                          format: int64
                          description: Overall Buffer Quality (%)
                        BP_AV_RTM:
                          type: integer
                          format: int64
                          description: Average Physical Read Time (ms)
                        BP_AV_WTM:
                          type: integer
                          format: int64
                          description: Average Physical Write Time (ms)
                        BP_D_HITRT:
                          type: integer
                          format: int64
                          description: Buffer Pool Data Hit Ratio (%)
                        BP_I_HITRT:
                          type: integer
                          format: int64
                          description: Buffer Pool Index Hit Ratio (%)
                        BP_NUM:
                          type: integer
                          format: int64
                          description: Number of Buffer Pools
                        PL_D_LRS:
                          type: integer
                          format: int64
                          description: Data Logical Reads
                        PL_D_PRS:
                          type: integer
                          format: int64
                          description: Data Physical Reads
                        PL_D_WS:
                          type: integer
                          format: int64
                          description: Data Physical Writes
                        BP_D_SPRS:
                          type: integer
                          format: int64
                          description: Data Synchronous Physical Reads
                        BP_D_SWS:
                          type: integer
                          format: int64
                          description: Data Synchronous Physical Writes
                        PL_I_LRS:
                          type: integer
                          format: int64
                          description: Index Logical Reads
                        PL_I_PRS:
                          type: integer
                          format: int64
                          description: Index Physical Reads
                        PL_I_WS:
                          type: integer
                          format: int64
                          description: Index Physical Writes
                        BP_I_SPRS:
                          type: integer
                          format: int64
                          description: Index Synchronous Physical Reads
                        BP_I_SWS:
                          type: integer
                          format: int64
                          description: Index Synchronous Physical Writes
                        PL_RD_TM:
                          type: integer
                          format: int64
                          description: Pool Read Time
                        PL_WT_TM:
                          type: integer
                          format: int64
                          description: Pool Write Time
                        CATCA_SZ:
                          type: integer
                          format: int64
                          description: Catalog Cache Size (KB)
                        CATCA_QAL:
                          type: integer
                          format: int64
                          description: Catalog Cache Quality %
                        MAXAPPLS:
                          type: integer
                          format: int64
                          description: Maximum Number of Active Applications
                        PKG_CA_SZ:
                          type: integer
                          format: int64
                          description: Package Cache Size (KB)
                        PKG_CA_QAL:
                          type: integer
                          format: int64
                          description: Package Cache Quality (%)
                        CATCA_LKU:
                          type: integer
                          format: int64
                          description: Catalog Cache Lookups
                        CATCA_INS:
                          type: integer
                          format: int64
                          description: Catalog Cache Inserts
                        CATCA_OF:
                          type: integer
                          format: int64
                          description: Catalog Cache Overflows
                        CATCA_HPFL:
                          type: integer
                          format: int64
                          description: Catalog Cache Heap Full
                        PKG_CA_LKU:
                          type: integer
                          format: int64
                          description: Package Cache Lookups
                        PKG_CA_INS:
                          type: integer
                          format: int64
                          description: Package Cache Inserts
                        PKG_NUM_OV:
                          type: integer
                          format: int64
                          description: Package Cache Number Overflows
                        PKG_SZ_TOP:
                          type: integer
                          format: int64
                          description: Package Cache Size Top
                        NUM_IOSVRS:
                          type: integer
                          format: int64
                          description: Number of I/O Servers
                        AV_ASP_RTM:
                          type: integer
                          format: int64
                          description: Average Asynchronous Physical Read Time (ms)
                        NUM_IOCLNS:
                          type: integer
                          format: int64
                          description: Number of I/O Cleaners
                        AV_ASP_WTM:
                          type: integer
                          format: int64
                          description: Average Asynchronous Physical Write Time (ms)
                        PL_A_DRS:
                          type: integer
                          format: int64
                          description: Data Asynchronous Physical Reads
                        PL_A_DWS:
                          type: integer
                          format: int64
                          description: Data Asynchronous Physical Writes
                        PL_A_IRS:
                          type: integer
                          format: int64
                          description: Index Asynchronous Physical Reads
                        PL_A_IWS:
                          type: integer
                          format: int64
                          description: Index Asynchronous Physical Writes
                        PL_A_RTM:
                          type: integer
                          format: int64
                          description: Asynchronous Read Time
                        PL_A_WTM:
                          type: integer
                          format: int64
                          description: Asynchronous Write Time
                        LCKLISTSZ:
                          type: integer
                          format: int64
                          description: Lock List Size (KB)
                        LCK_LSTIU:
                          type: integer
                          format: int64
                          description: Lock List in Use (KB)
                        LCK_ESCALS:
                          type: integer
                          format: int64
                          description: Lock Escalations
                        X_LCK_ESCA:
                          type: integer
                          format: int64
                          description: Exclusive Lock Escalations
                        LCK_WAITS:
                          type: integer
                          format: int64
                          description: Total Lock Waits
                        LCK_W_TM:
                          type: integer
                          format: int64
                          description: Time Waited for Locks (ms)
                        AV_WTM_LCK:
                          type: integer
                          format: int64
                          description: Average Wait Time per Lock (ms)
                        LCKS_HELD:
                          type: integer
                          format: int64
                          description: Locks Currently Held
                        DEADLOCKS:
                          type: integer
                          format: int64
                          description: Deadlocks Detected
                        LCK_TMOUT:
                          type: integer
                          format: int64
                          description: Lock Timeouts
                        CMMT_SQLST:
                          type: integer
                          format: int64
                          description: COMMITs
                        RBCK_SQLST:
                          type: integer
                          format: int64
                          description: ROLLBACKs
                        SELC_SQLST:
                          type: integer
                          format: int64
                          description: SELECT Statements
                        UID_SQLST:
                          type: integer
                          format: int64
                          description: UPDATE/INSERT/DELETE Statements
                        DYN_SQLST:
                          type: integer
                          format: int64
                          description: Dynamic SQL Statements
                        STC_SQLST:
                          type: integer
                          format: int64
                          description: Static SQL Statements
                        FAIL_SQLST:
                          type: integer
                          format: int64
                          description: Failed SQL Statements
                        DDL_SQLST:
                          type: integer
                          format: int64
                          description: Data Definition Language Statements
                        RW_DELETED:
                          type: integer
                          format: int64
                          description: Rows Deleted
                        RW_INSRTED:
                          type: integer
                          format: int64
                          description: Rows Inserted
                        RW_SELECED:
                          type: integer
                          format: int64
                          description: Rows Selected
                        RW_UPDATED:
                          type: integer
                          format: int64
                          description: Rows Updated
                        SORTHEAPSZ:
                          type: integer
                          format: int64
                          description: Total Sort Heap Size (KB)
                        SRT_HP_ALO:
                          type: integer
                          format: int64
                          description: Sort Heap Allocated (KB)
                        TOT_SORTS:
                          type: integer
                          format: int64
                          description: Total Sorts
                        TOT_SRT_TM:
                          type: integer
                          format: int64
                          description: Total Sort Time (ms)
                        AV_SORT_TM:
                          type: integer
                          format: int64
                          description: Average Sort Time (ms)
                        SRT_OF:
                          type: integer
                          format: int64
                          description: Sort Overflows
                        ACTIV_SORT:
                          type: integer
                          format: int64
                          description: Active Sorts
                        DIRCT_RDS:
                          type: integer
                          format: int64
                          description: Direct Reads
                        DIRCT_WTS:
                          type: integer
                          format: int64
                          description: Direct Writes
                        DIRCT_RTM:
                          type: integer
                          format: int64
                          description: Direct Read Time
                        DIRCT_WTM:
                          type: integer
                          format: int64
                          description: Direct Write Time
                        DIRCT_RRQS:
                          type: integer
                          format: int64
                          description: Direct Read Requests
                        DIRCT_WRQS:
                          type: integer
                          format: int64
                          description: Direct Write Requests
                        AV_DCT_RTM:
                          type: integer
                          format: int64
                          description: Average Direct Read Time
                        AV_DCT_WTM:
                          type: integer
                          format: int64
                          description: Average Direct Write Time
                        AV_DCT_RDS:
                          type: integer
                          format: int64
                          description: Average Direct Reads
                        AV_DCT_WTS:
                          type: integer
                          format: int64
                          description: Average Direct Writes
                        PL_D_TE:
                          type: integer
                          format: int64
                          description: Pool Data to Extended Storage
                        PL_D_FE:
                          type: integer
                          format: int64
                          description: Pool Data from Extended Storage
                        PL_I_TE:
                          type: integer
                          format: int64
                          description: Pool Index to Extended Storage
                        PL_I_FE:
                          type: integer
                          format: int64
                          description: Pool Index from Extended Storage
                        TOT_LGUTOP:
                          type: integer
                          format: int64
                          description: Maximum Total Log Space Used
                        SEC_LGUSTP:
                          type: integer
                          format: int64
                          description: Maximum Secondary Log Space Used
                        SEC_LGALLO:
                          type: integer
                          format: int64
                          description: Number of Secondary Logs Allocated
                        LOG_READS:
                          type: integer
                          format: int64
                          description: Number of Log Pages Read
                        LOG_WRITES:
                          type: integer
                          format: int64
                          description: Number of Log Pages Written
                        TOT_LGUSED:
                          type: integer
                          format: int64
                          description: Log Space Used by Database
                        TOT_LGAVL:
                          type: integer
                          format: int64
                          description: Log Space Available for Database
                        LOGFILSIZ:
                          type: integer
                          format: int64
                          description: Size of Log Files (Pages 4 KB) Configured
                        LOGPRIMARY:
                          type: integer
                          format: int64
                          description: Number of Primary Log Files Configured
                        LOGSECOND:
                          type: integer
                          format: int64
                          description: Number of Secondary Log Files Configured
                        TOT_HAJN:
                          type: integer
                          format: int64
                          description: Number of Hash Joins
                        TOT_HALOOP:
                          type: integer
                          format: int64
                          description: Number of Hash Loops
                        HAJN_OF:
                          type: integer
                          format: int64
                          description: Number of Hash Join Overflows
                        HAJN_SM_OF:
                          type: integer
                          format: int64
                          description: Small Hash Join Overflows
                        PL_TD_LRS:
                          type: integer
                          format: int64
                          description: Temp Data Logical Reads
                        PL_TD_PRS:
                          type: integer
                          format: int64
                          description: Temp Data Physical Reads
                        PL_TI_LRS:
                          type: integer
                          format: int64
                          description: Temp Index Logical Reads
                        PL_TI_PRS:
                          type: integer
                          format: int64
                          description: Temp Index Physical Reads
                        PL_A_DRRQ:
                          type: integer
                          format: int64
                          description: Asynchronous Data Read Requests
                        PL_A_IRRQ:
                          type: integer
                          format: int64
                          description: Asynchronous Index Read Requests
                        CATCASZTOP:
                          type: integer
                          format: int64
                          description: Catalog Cache  Size Top (High Water Mark)
                        LSNGAP_PCT:
                          type: integer
                          format: int64
                          description: LSN Gap
                        RESTRTRNGE:
                          type: integer
                          format: int64
                          description: Restart Range
                        AVGLWTPPAG:
                          type: integer
                          format: int64
                          description: Average Log Write Time / Page
                        AVGLWTPIO:
                          type: integer
                          format: int64
                          description: Average Log Write Time / IO
                        AVGLRTPPAG:
                          type: integer
                          format: int64
                          description: Average Log Read Time / Page
                        AVGLRTPIO:
                          type: integer
                          format: int64
                          description: Average Log Read Time / IO
                        LGBUFHITRT:
                          type: integer
                          format: int64
                          description: Log Buffer Hit Ratio
                        LOGREADTS:
                          type: integer
                          format: int64
                          description: Log Read Time (seconds)
                        LOGREADTNS:
                          type: integer
                          format: int64
                          description: Log Read Time (micro seconds)
                        LOGWRITS:
                          type: integer
                          format: int64
                          description: Log Write Time (seconds)
                        LOGWRITNS:
                          type: integer
                          format: int64
                          description: Log Write Time (micro seconds)
                        NUMLOGWRIO:
                          type: integer
                          format: int64
                          description: Number of Log Write IO
                        NUMLOGRDIO:
                          type: integer
                          format: int64
                          description: Number of Log Read IO
                        NUMLOGPPIO:
                          type: integer
                          format: int64
                          description: num_log_part_page_io
                        NUMLOGBFUL:
                          type: integer
                          format: int64
                          description: num_log_buffer_full
                        NUMLOGDFND:
                          type: integer
                          format: int64
                          description: num_log_data_found_in_buffer
                        LOGREDOREC:
                          type: integer
                          format: int64
                          description: log_to_redo_for_recovery
                        LOGHELDDTY:
                          type: integer
                          format: int64
                          description: log_held_by_dirty_pages
                        SOFTMAX:
                          type: integer
                          format: int32
                          description: SOFTMAX Parameter
                        SCPERHOUR:
                          type: integer
                          format: int64
                          description: Soft Checkpoints / hour
                        ACTIVE_HASH_JOIN:
                          type: integer
                          format: int64
                          description: Active Hash Joins
                        DBNAME:
                          type: string
                          maxLength: 100
                          description: DB Name
                        PL_ASYNC_XDA_RDS:
                          type: integer
                          format: int64
                          description: Pool Async XDA Reads
                        PL_ASYNC_XDA_RRQ:
                          type: integer
                          format: int64
                          description: Pool Async XDA Read Requests
                        PL_ASYNC_XDA_WRT:
                          type: integer
                          format: int64
                          description: Pool Async XDA Writes
                        PL_TEMP_XDA_L_RD:
                          type: integer
                          format: int64
                          description: Pool Temp XDA Logical Reads
                        PL_TEMP_XDA_P_RD:
                          type: integer
                          format: int64
                          description: Pool Temp XDA Physical Reads
                        POOL_XDA_L_READS:
                          type: integer
                          format: int64
                          description: Pool XDA Logical Reads
                        POOL_XDA_P_READS:
                          type: integer
                          format: int64
                          description: Pool XDA Physical Reads
                        POOL_XDA_WRITES:
                          type: integer
                          format: int64
                          description: Pool XDA Writes
                        POST_SHRTHRS_HAJ:
                          type: integer
                          format: int64
                          description: post_shrthreshold_hash_joins
                        POST_SHRTHRS_SRT:
                          type: integer
                          format: int64
                          description: post_shrthreshold_sorts
                        SMALLEST_LOG_AVL:
                          type: integer
                          format: int64
                          description: Smallest Log available
                        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
                        SHEAPTRES:
                          type: integer
                          format: int64
                          description: sortheap_threshold
        '400':
          description: Bad request.
        5XX:
          description: Unexpected error.
