openapi: 3.0.0
info:
  title: SAP API
  version: 1.0.0
servers:
- url: http://localhost:8080
paths:
  /rfc/ST04_DB4_GET_IDA_INFO:
    post:
      tags:
      - STU4_TCC
      summary: 'OS/400: Get Indexes Advised info for ST04 Detail Analysis'
      operationId: /rfc/ST04_DB4_GET_IDA_INFO
      requestBody:
        content:
          application/json:
            schema:
              properties:
                RESETFLAG:
                  type: string
                  default: ' '
                  maxLength: 1
                  description: Character field of length one
                IDA_0100:
                  type: array
                  items:
                    type: object
                    properties:
                      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)'
                      QQLTLN:
                        type: string
                        maxLength: 128
                        description: 'iSeries: Library Name (Database Monitor)'
                      QQLTFN:
                        type: string
                        maxLength: 128
                        description: 'iSeries: Table Name (Database Monitor)'
                      QQQRYCNT:
                        type: integer
                        format: int64
                        description: 'iSeries: Number of Different Statements (Database Monitor)'
                      QQCNT:
                        type: integer
                        format: int64
                        description: 'iSeries: No. of Executions of a Statement (Database Monitor)'
                      QQCIA:
                        type: integer
                        format: int64
                        description: 'iSeries: Index Advice (Database Monitor)'
                      QQIDACNT:
                        type: integer
                        format: int64
                        description: 'iSeries: Index Advice (Database Monitor)'
                      QQTOTR:
                        type: integer
                        format: int64
                        description: 'iSeries: Total Rows in Table (Database Monitor)'
                      QQAVGT:
                        type: integer
                        format: int64
                        description: 'iSeries:  Average Time (Database Monitor)'
                      QQARSS:
                        type: integer
                        format: int64
                        description: 'iSeries: Average Result Set Size (Database Monitor)'
                      TOTTIME:
                        type: integer
                        format: int64
                        description: 'iSeries: Total Time (Database Monitor)'
                      QQUSER:
                        type: string
                        maxLength: 10
                        description: 'iSeries: Job User (Database Monitor)'
                IDA_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)'
                      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)'
                      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)'
                      QQLPTL:
                        type: string
                        maxLength: 128
                        description: 'iSeries: Base Library (Database Monitor)'
                      QQLPTF:
                        type: string
                        maxLength: 128
                        description: 'iSeries: Base Table (Database Monitor)'
                      QQLTLN:
                        type: string
                        maxLength: 128
                        description: 'iSeries: Library Name (Database Monitor)'
                      QQLTFN:
                        type: string
                        maxLength: 128
                        description: 'iSeries: Table Name (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)'
                      QQCIA:
                        type: integer
                        format: int64
                        description: 'iSeries: Index Advice (Database Monitor)'
                      QQTOTR:
                        type: integer
                        format: int64
                        description: 'iSeries: Total Rows in Table (Database Monitor)'
                      QQARSS:
                        type: integer
                        format: int64
                        description: 'iSeries: Average Result Set Size (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)'
                      QQIDXD:
                        type: string
                        maxLength: 1000
                        description: 'iSeries: Definition of Advised 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)'
                IDA_0300:
                  type: array
                  items:
                    type: object
                    properties:
                      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)'
                      QQLPTL:
                        type: string
                        maxLength: 128
                        description: 'iSeries: Base Library (Database Monitor)'
                      QQLPTF:
                        type: string
                        maxLength: 128
                        description: 'iSeries: Base Table (Database Monitor)'
                      QQCIA:
                        type: integer
                        format: int64
                        description: 'iSeries: Index Advice (Database Monitor)'
                      QQIDXD:
                        type: string
                        maxLength: 255
                        description: 'iSeries: Key Fields for the Advised Index'
                      QQUSER:
                        type: string
                        maxLength: 10
                        description: 'iSeries: Job User (Database Monitor)'
                TABLES_FOR_DETAILS:
                  type: array
                  items:
                    type: object
                    properties:
                      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)'
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                properties:
                  IDA_0100:
                    type: array
                    items:
                      type: object
                      properties:
                        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)'
                        QQLTLN:
                          type: string
                          maxLength: 128
                          description: 'iSeries: Library Name (Database Monitor)'
                        QQLTFN:
                          type: string
                          maxLength: 128
                          description: 'iSeries: Table Name (Database Monitor)'
                        QQQRYCNT:
                          type: integer
                          format: int64
                          description: 'iSeries: Number of Different Statements (Database Monitor)'
                        QQCNT:
                          type: integer
                          format: int64
                          description: 'iSeries: No. of Executions of a Statement (Database Monitor)'
                        QQCIA:
                          type: integer
                          format: int64
                          description: 'iSeries: Index Advice (Database Monitor)'
                        QQIDACNT:
                          type: integer
                          format: int64
                          description: 'iSeries: Index Advice (Database Monitor)'
                        QQTOTR:
                          type: integer
                          format: int64
                          description: 'iSeries: Total Rows in Table (Database Monitor)'
                        QQAVGT:
                          type: integer
                          format: int64
                          description: 'iSeries:  Average Time (Database Monitor)'
                        QQARSS:
                          type: integer
                          format: int64
                          description: 'iSeries: Average Result Set Size (Database Monitor)'
                        TOTTIME:
                          type: integer
                          format: int64
                          description: 'iSeries: Total Time (Database Monitor)'
                        QQUSER:
                          type: string
                          maxLength: 10
                          description: 'iSeries: Job User (Database Monitor)'
                  IDA_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)'
                        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)'
                        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)'
                        QQLPTL:
                          type: string
                          maxLength: 128
                          description: 'iSeries: Base Library (Database Monitor)'
                        QQLPTF:
                          type: string
                          maxLength: 128
                          description: 'iSeries: Base Table (Database Monitor)'
                        QQLTLN:
                          type: string
                          maxLength: 128
                          description: 'iSeries: Library Name (Database Monitor)'
                        QQLTFN:
                          type: string
                          maxLength: 128
                          description: 'iSeries: Table Name (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)'
                        QQCIA:
                          type: integer
                          format: int64
                          description: 'iSeries: Index Advice (Database Monitor)'
                        QQTOTR:
                          type: integer
                          format: int64
                          description: 'iSeries: Total Rows in Table (Database Monitor)'
                        QQARSS:
                          type: integer
                          format: int64
                          description: 'iSeries: Average Result Set Size (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)'
                        QQIDXD:
                          type: string
                          maxLength: 1000
                          description: 'iSeries: Definition of Advised 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)'
                  IDA_0300:
                    type: array
                    items:
                      type: object
                      properties:
                        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)'
                        QQLPTL:
                          type: string
                          maxLength: 128
                          description: 'iSeries: Base Library (Database Monitor)'
                        QQLPTF:
                          type: string
                          maxLength: 128
                          description: 'iSeries: Base Table (Database Monitor)'
                        QQCIA:
                          type: integer
                          format: int64
                          description: 'iSeries: Index Advice (Database Monitor)'
                        QQIDXD:
                          type: string
                          maxLength: 255
                          description: 'iSeries: Key Fields for the Advised Index'
                        QQUSER:
                          type: string
                          maxLength: 10
                          description: 'iSeries: Job User (Database Monitor)'
                  TABLES_FOR_DETAILS:
                    type: array
                    items:
                      type: object
                      properties:
                        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)'
        '400':
          description: Bad request.
        5XX:
          description: Unexpected error.
