openapi: 3.0.0
info:
  title: SAP API
  version: 1.0.0
servers:
- url: http://localhost:8080
paths:
  /rfc/ST04_DB4_GET_IDU_INFO:
    post:
      tags:
      - STU4_TCC
      summary: 'AS/400: Get index used info for ST04 Detail Analysis'
      operationId: /rfc/ST04_DB4_GET_IDU_INFO
      requestBody:
        content:
          application/json:
            schema:
              properties:
                RESETFLAG:
                  type: string
                  default: ' '
                  maxLength: 1
                  description: Feld vom Typ CHAR z.Zt nicht verwendet
                IDU_0100:
                  type: array
                  items:
                    type: object
                    properties:
                      QQKEY:
                        type: string
                        maxLength: 17
                        description: 'iSeries: Key Field (Database Monitor)'
                      QQILNM:
                        type: string
                        maxLength: 10
                        description: 'iSeries: System Name of Index Library (Database Monitor)'
                      QQIFNM:
                        type: string
                        maxLength: 18
                        description: 'iSeries: System Name of Index (Database Monitor)'
                      QQPTLN:
                        type: string
                        maxLength: 10
                        description: 'iSeries: System Name of Base Library (Database Monitor)'
                      QQPTFN:
                        type: string
                        maxLength: 30
                        description: 'iSeries: System Name of Base Table (Database Monitor)'
                      QQLILN:
                        type: string
                        maxLength: 128
                        description: 'iSeries: Index Library (Database Monitor)'
                      QQLIFN:
                        type: string
                        maxLength: 128
                        description: 'iSeries: Index Name (Database Monitor)'
                      QQLPTL:
                        type: string
                        maxLength: 128
                        description: 'iSeries: Base Library (Database Monitor)'
                      QQLPTF:
                        type: string
                        maxLength: 128
                        description: 'iSeries: Base Table (Database Monitor)'
                      QQCIU:
                        type: integer
                        format: int64
                        description: 'iSeries: Index Usage (Database Monitor)'
                      QQQRYCNT:
                        type: integer
                        format: int64
                        description: 'iSeries: Number of Different Statements (Database Monitor)'
                      QQTOTR:
                        type: integer
                        format: int64
                        description: 'iSeries: Total Rows in Table (Database Monitor)'
                      QQRROW:
                        type: integer
                        format: int64
                        description: 'iSeries: Result Rows (Database Monitor)'
                      QQAVGT:
                        type: integer
                        format: int64
                        description: 'iSeries:  Average Time (Database Monitor)'
                      QQCST:
                        type: string
                        maxLength: 1
                        description: 'iSeries: Constraint Used (Y/N) (Database Monitor)'
                      TOTTIME:
                        type: integer
                        format: int64
                        description: 'iSeries: Total Time (Database Monitor)'
                      QQUSER:
                        type: string
                        maxLength: 10
                        description: 'iSeries: Job User (Database Monitor)'
                IDU_0200:
                  type: array
                  items:
                    type: object
                    properties:
                      SYSID:
                        type: string
                        maxLength: 8
                        description: Name of the SAP System
                      IPLTIME:
                        type: string
                        maxLength: 14
                        description: Text field length 14
                      QQKEY:
                        type: string
                        maxLength: 17
                        description: 'iSeries: Key Field (Database Monitor)'
                      QQILNM:
                        type: string
                        maxLength: 10
                        description: 'iSeries: System Name of Index Library (Database Monitor)'
                      QQIFNM:
                        type: string
                        maxLength: 18
                        description: 'iSeries: System Name of Index (Database Monitor)'
                      QQTLN:
                        type: string
                        maxLength: 10
                        description: 'iSeries: System Name of Library (Database Monitor)'
                      QQTFN:
                        type: string
                        maxLength: 30
                        description: 'iSeries: System Name of Table (Database Monitor)'
                      QQPTLN:
                        type: string
                        maxLength: 10
                        description: 'iSeries: System Name of Base Library (Database Monitor)'
                      QQPTFN:
                        type: string
                        maxLength: 30
                        description: 'iSeries: System Name of Base Table (Database Monitor)'
                      QQLILN:
                        type: string
                        maxLength: 128
                        description: 'iSeries: Index Library (Database Monitor)'
                      QQLIFN:
                        type: string
                        maxLength: 128
                        description: 'iSeries: Index Name (Database Monitor)'
                      QQLTLN:
                        type: string
                        maxLength: 128
                        description: 'iSeries: Library Name (Database Monitor)'
                      QQLTFN:
                        type: string
                        maxLength: 128
                        description: 'iSeries: Table Name (Database Monitor)'
                      QQLPTL:
                        type: string
                        maxLength: 128
                        description: 'iSeries: Base Library (Database Monitor)'
                      QQLPTF:
                        type: string
                        maxLength: 128
                        description: 'iSeries: Base Table (Database Monitor)'
                      QQPLIB:
                        type: string
                        maxLength: 10
                        description: 'iSeries: Package/Program Library (Database Monitor)'
                      QQPNAM:
                        type: string
                        maxLength: 10
                        description: 'iSeries: Package/Program Name (Database Monitor)'
                      QQSNAM:
                        type: string
                        maxLength: 18
                        description: 'iSeries: Statement Name (Database Monitor)'
                      QQCNT:
                        type: integer
                        format: int64
                        description: 'iSeries: No. of Executions of a Statement (Database Monitor)'
                      QQCIU:
                        type: integer
                        format: int64
                        description: 'iSeries: Index Usage (Database Monitor)'
                      QQTOTR:
                        type: integer
                        format: int64
                        description: 'iSeries: Total Rows in Table (Database Monitor)'
                      QQRROW:
                        type: integer
                        format: int64
                        description: 'iSeries: Result Rows (Database Monitor)'
                      QQAVGT:
                        type: integer
                        format: int64
                        description: 'iSeries:  Average Time (Database Monitor)'
                      TOTTIME:
                        type: integer
                        format: int64
                        description: 'iSeries: Total Time (Database Monitor)'
                      QQMINT:
                        type: integer
                        format: int64
                        description: 'iSeries: Minimum Time  (Database Monitor)'
                      QQMAXT:
                        type: integer
                        format: int64
                        description: 'iSeries: Maximum Time (Database Monitor)'
                      QQMETU:
                        type: string
                        maxLength: 26
                        description: 'iSeries: Timest. of Most Expensive Stmt.  (Database Monitor)'
                      QQCST:
                        type: string
                        maxLength: 1
                        description: 'iSeries: Constraint Used (Y/N) (Database Monitor)'
                      QQCSTN:
                        type: string
                        maxLength: 18
                        description: 'iSeries: Constraint Name (Database Monitor)'
                      QQIDXA:
                        type: string
                        maxLength: 1
                        description: 'iSeries: Optimizer Advised Index (Database Monitor)'
                      QQRCOD:
                        type: string
                        maxLength: 2
                        description: 'iSeries: Reason Code for Used Index (Database Monitor)'
                      QQSTTX_LEN:
                        type: integer
                        format: int32
                        description: 2 byte integer (signed)
                      QQSTTX:
                        type: string
                        maxLength: 8000
                        description: 'iSeries: Statement Text (Database Monitor)'
                      QQUSER:
                        type: string
                        maxLength: 10
                        description: 'iSeries: Job User (Database Monitor)'
                INDEXES_FOR_DETAILS:
                  type: array
                  items:
                    type: object
                    properties:
                      QQILNM:
                        type: string
                        maxLength: 10
                        description: 'iSeries: System Name of Index Library (Database Monitor)'
                      QQIFNM:
                        type: string
                        maxLength: 18
                        description: 'iSeries: System Name of Index (Database Monitor)'
                      QQCST:
                        type: string
                        maxLength: 1
                        description: 'iSeries: Constraint Used (Y/N) (Database Monitor)'
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                properties:
                  IDU_0100:
                    type: array
                    items:
                      type: object
                      properties:
                        QQKEY:
                          type: string
                          maxLength: 17
                          description: 'iSeries: Key Field (Database Monitor)'
                        QQILNM:
                          type: string
                          maxLength: 10
                          description: 'iSeries: System Name of Index Library (Database Monitor)'
                        QQIFNM:
                          type: string
                          maxLength: 18
                          description: 'iSeries: System Name of Index (Database Monitor)'
                        QQPTLN:
                          type: string
                          maxLength: 10
                          description: 'iSeries: System Name of Base Library (Database Monitor)'
                        QQPTFN:
                          type: string
                          maxLength: 30
                          description: 'iSeries: System Name of Base Table (Database Monitor)'
                        QQLILN:
                          type: string
                          maxLength: 128
                          description: 'iSeries: Index Library (Database Monitor)'
                        QQLIFN:
                          type: string
                          maxLength: 128
                          description: 'iSeries: Index Name (Database Monitor)'
                        QQLPTL:
                          type: string
                          maxLength: 128
                          description: 'iSeries: Base Library (Database Monitor)'
                        QQLPTF:
                          type: string
                          maxLength: 128
                          description: 'iSeries: Base Table (Database Monitor)'
                        QQCIU:
                          type: integer
                          format: int64
                          description: 'iSeries: Index Usage (Database Monitor)'
                        QQQRYCNT:
                          type: integer
                          format: int64
                          description: 'iSeries: Number of Different Statements (Database Monitor)'
                        QQTOTR:
                          type: integer
                          format: int64
                          description: 'iSeries: Total Rows in Table (Database Monitor)'
                        QQRROW:
                          type: integer
                          format: int64
                          description: 'iSeries: Result Rows (Database Monitor)'
                        QQAVGT:
                          type: integer
                          format: int64
                          description: 'iSeries:  Average Time (Database Monitor)'
                        QQCST:
                          type: string
                          maxLength: 1
                          description: 'iSeries: Constraint Used (Y/N) (Database Monitor)'
                        TOTTIME:
                          type: integer
                          format: int64
                          description: 'iSeries: Total Time (Database Monitor)'
                        QQUSER:
                          type: string
                          maxLength: 10
                          description: 'iSeries: Job User (Database Monitor)'
                  IDU_0200:
                    type: array
                    items:
                      type: object
                      properties:
                        SYSID:
                          type: string
                          maxLength: 8
                          description: Name of the SAP System
                        IPLTIME:
                          type: string
                          maxLength: 14
                          description: Text field length 14
                        QQKEY:
                          type: string
                          maxLength: 17
                          description: 'iSeries: Key Field (Database Monitor)'
                        QQILNM:
                          type: string
                          maxLength: 10
                          description: 'iSeries: System Name of Index Library (Database Monitor)'
                        QQIFNM:
                          type: string
                          maxLength: 18
                          description: 'iSeries: System Name of Index (Database Monitor)'
                        QQTLN:
                          type: string
                          maxLength: 10
                          description: 'iSeries: System Name of Library (Database Monitor)'
                        QQTFN:
                          type: string
                          maxLength: 30
                          description: 'iSeries: System Name of Table (Database Monitor)'
                        QQPTLN:
                          type: string
                          maxLength: 10
                          description: 'iSeries: System Name of Base Library (Database Monitor)'
                        QQPTFN:
                          type: string
                          maxLength: 30
                          description: 'iSeries: System Name of Base Table (Database Monitor)'
                        QQLILN:
                          type: string
                          maxLength: 128
                          description: 'iSeries: Index Library (Database Monitor)'
                        QQLIFN:
                          type: string
                          maxLength: 128
                          description: 'iSeries: Index Name (Database Monitor)'
                        QQLTLN:
                          type: string
                          maxLength: 128
                          description: 'iSeries: Library Name (Database Monitor)'
                        QQLTFN:
                          type: string
                          maxLength: 128
                          description: 'iSeries: Table Name (Database Monitor)'
                        QQLPTL:
                          type: string
                          maxLength: 128
                          description: 'iSeries: Base Library (Database Monitor)'
                        QQLPTF:
                          type: string
                          maxLength: 128
                          description: 'iSeries: Base Table (Database Monitor)'
                        QQPLIB:
                          type: string
                          maxLength: 10
                          description: 'iSeries: Package/Program Library (Database Monitor)'
                        QQPNAM:
                          type: string
                          maxLength: 10
                          description: 'iSeries: Package/Program Name (Database Monitor)'
                        QQSNAM:
                          type: string
                          maxLength: 18
                          description: 'iSeries: Statement Name (Database Monitor)'
                        QQCNT:
                          type: integer
                          format: int64
                          description: 'iSeries: No. of Executions of a Statement (Database Monitor)'
                        QQCIU:
                          type: integer
                          format: int64
                          description: 'iSeries: Index Usage (Database Monitor)'
                        QQTOTR:
                          type: integer
                          format: int64
                          description: 'iSeries: Total Rows in Table (Database Monitor)'
                        QQRROW:
                          type: integer
                          format: int64
                          description: 'iSeries: Result Rows (Database Monitor)'
                        QQAVGT:
                          type: integer
                          format: int64
                          description: 'iSeries:  Average Time (Database Monitor)'
                        TOTTIME:
                          type: integer
                          format: int64
                          description: 'iSeries: Total Time (Database Monitor)'
                        QQMINT:
                          type: integer
                          format: int64
                          description: 'iSeries: Minimum Time  (Database Monitor)'
                        QQMAXT:
                          type: integer
                          format: int64
                          description: 'iSeries: Maximum Time (Database Monitor)'
                        QQMETU:
                          type: string
                          maxLength: 26
                          description: 'iSeries: Timest. of Most Expensive Stmt.  (Database Monitor)'
                        QQCST:
                          type: string
                          maxLength: 1
                          description: 'iSeries: Constraint Used (Y/N) (Database Monitor)'
                        QQCSTN:
                          type: string
                          maxLength: 18
                          description: 'iSeries: Constraint Name (Database Monitor)'
                        QQIDXA:
                          type: string
                          maxLength: 1
                          description: 'iSeries: Optimizer Advised Index (Database Monitor)'
                        QQRCOD:
                          type: string
                          maxLength: 2
                          description: 'iSeries: Reason Code for Used Index (Database Monitor)'
                        QQSTTX_LEN:
                          type: integer
                          format: int32
                          description: 2 byte integer (signed)
                        QQSTTX:
                          type: string
                          maxLength: 8000
                          description: 'iSeries: Statement Text (Database Monitor)'
                        QQUSER:
                          type: string
                          maxLength: 10
                          description: 'iSeries: Job User (Database Monitor)'
                  INDEXES_FOR_DETAILS:
                    type: array
                    items:
                      type: object
                      properties:
                        QQILNM:
                          type: string
                          maxLength: 10
                          description: 'iSeries: System Name of Index Library (Database Monitor)'
                        QQIFNM:
                          type: string
                          maxLength: 18
                          description: 'iSeries: System Name of Index (Database Monitor)'
                        QQCST:
                          type: string
                          maxLength: 1
                          description: 'iSeries: Constraint Used (Y/N) (Database Monitor)'
        '400':
          description: Bad request.
        5XX:
          description: Unexpected error.
