openapi: 3.0.0
info:
  title: SAP API
  version: 1.0.0
servers:
- url: http://localhost:8080
paths:
  /rfc/DB02_DB4_GET_INFO:
    post:
      tags:
      - STU4_TCC
      summary: 'iSeries: Get info for DB02 Main Screen (Dynpro 0110)'
      operationId: /rfc/DB02_DB4_GET_INFO
      requestBody:
        content:
          application/json:
            schema:
              properties:
                IM_SYSDATA:
                  type: object
                  properties:
                    SYSID:
                      type: string
                      maxLength: 8
                      description: Name of the SAP System
                    SAPREL:
                      type: string
                      maxLength: 4
                      description: Release Status of SAP System
                    DBREL:
                      type: string
                      maxLength: 10
                      description: 'DB6: Database Release Level'
                    RFCDEST:
                      type: string
                      maxLength: 32
                      description: Logical Destination (Specified in Function Call)
                    DBHOST:
                      type: string
                      maxLength: 255
                      description: 'DBA Cockpit: Server Name'
                    SCHEMANAME:
                      type: string
                      maxLength: 20
                      description: 'DB6: Schema Name'
                    ENTRYSTATE:
                      type: integer
                      format: int32
                      description: 'State of entry: 1=INITIAL,2=COMPLETE,3=DISABLED'
                    ENTRYTYPE:
                      type: integer
                      format: int32
                      description: 'kind of system: 1=R/3 ,2=Non R/3'
                    DBCNAME:
                      type: string
                      maxLength: 30
                      description: Logical name for a database connection
                    DBSYS:
                      type: string
                      maxLength: 3
                      description: 'Database system  enumValues: DB2=DB2 UDB for OS/390,MSS=Microsoft SQL Server,ADA=SAP DB (ADABAS/D),INF=Informix,ORA=Oracle,DB4=DB2 UDB for AS/400,DB6=DB2 UDB for Unix and Windows'
                      enum:
                      - DB2
                      - MSS
                      - ADA
                      - INF
                      - ORA
                      - DB4
                      - DB6
                    DB_OPSYS:
                      type: string
                      maxLength: 10
                      description: Operating System of Application Server
                    COCKREL:
                      type: string
                      maxLength: 4
                      description: Release Status of SAP System
                    REALSID:
                      type: string
                      maxLength: 8
                      description: Name of the SAP System
                    DBSID:
                      type: string
                      maxLength: 128
                      description: 'DBA Cockpit: Database Name'
                    RZ20_MON:
                      type: string
                      maxLength: 1
                      description: Remote Alert Monitoring active ('X')/inactive (' ')
                    HIST_MON:
                      type: string
                      maxLength: 1
                      description: Remote History Collection active('X')/inactive(' ')
                    DESCRIPTION:
                      type: string
                      maxLength: 80
                      description: ''
                    CHANGEDATE:
                      type: string
                      format: date
                      description: Current Date of Application Server
                    CHANGETIME:
                      type: string
                      maxLength: 6
                      description: Current Time of Application Server
                    CHANGED_BY:
                      type: string
                      maxLength: 12
                      description: User Name
                    SYSTEMTYPE:
                      type: string
                      maxLength: 7
                      description: 'SAP DB: Instance Type  enumValues: CS=Content Server Database,LVC=liveCache,BW=Business Warehouse Database,OLTP=Online Transaction Processing Database'
                      enum:
                      - CS
                      - LVC
                      - BW
                      - OLTP
                    RFCDEST_2:
                      type: string
                      maxLength: 32
                      description: Logical Destination (Specified in Function Call)
                    REMOTE_COLL:
                      type: string
                      maxLength: 1
                      description: Collect data remote('X') or local (' ')
                    DBCON_VIA_RFC:
                      type: string
                      maxLength: 1
                      description: DB Connection via RFC Destination
                    PROMPT_USER_DATA:
                      type: string
                      maxLength: 1
                      description: Store password permanent
                    SLD_NAME:
                      type: string
                      maxLength: 255
                      description: ''
                    SLD_UPDATE:
                      type: string
                      maxLength: 14
                      description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                    DB13C_MON:
                      type: string
                      maxLength: 1
                      description: DB13C Integration active('X')/inactive('')
                ADDTL_INDEX:
                  type: array
                  items:
                    type: object
                    properties:
                      NAME:
                        type: string
                        maxLength: 40
                        description: Object Name in Object Directory
                ADDTL_TABLES:
                  type: array
                  items:
                    type: object
                    properties:
                      NAME:
                        type: string
                        maxLength: 40
                        description: Object Name in Object Directory
                ADDTL_VIEWS:
                  type: array
                  items:
                    type: object
                    properties:
                      NAME:
                        type: string
                        maxLength: 40
                        description: Object Name in Object Directory
                MISS_INDEX:
                  type: array
                  items:
                    type: object
                    properties:
                      NAME:
                        type: string
                        maxLength: 40
                        description: Object Name in Object Directory
                MISS_TABLES:
                  type: array
                  items:
                    type: object
                    properties:
                      NAME:
                        type: string
                        maxLength: 40
                        description: Object Name in Object Directory
                MISS_VIEWS:
                  type: array
                  items:
                    type: object
                    properties:
                      NAME:
                        type: string
                        maxLength: 40
                        description: Object Name in Object Directory
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                properties:
                  API_QWCRSSTS_RC:
                    type: integer
                    format: int32
                    description: Error code from API call
                  DB02_DISPLAYED_INFO:
                    type: object
                    properties:
                      DBSYS:
                        type: string
                        maxLength: 10
                        description: Central Database System
                      FS_A_DATE:
                        type: string
                        format: date
                        description: Date of analysis of file statistics (tables/indexes)
                      FS_A_TIME:
                        type: string
                        maxLength: 6
                        description: Time of analysis of file statistics (tables/indexes)
                      SYSID:
                        type: string
                        maxLength: 8
                        description: Name of the SAP System
                      TAB_CNT:
                        type: integer
                        format: int32
                        description: 'Tables: total number'
                      CST_CNT:
                        type: integer
                        format: int32
                        description: 'Primary key constraints: total number'
                      IDX_CNT:
                        type: integer
                        format: int32
                        description: 'Indexes: total number'
                      TAB_SIZE:
                        type: integer
                        format: int64
                        description: 'Tables: total size (KB)'
                      CST_SIZE:
                        type: integer
                        format: int64
                        description: 'Primary key constraints: total size (KB)'
                      IDX_SIZE:
                        type: integer
                        format: int64
                        description: 'Indexes: total size (KB)'
                      TAB_MIS_DB:
                        type: integer
                        format: int32
                        description: 'Tables: number of tables missing from database'
                      CST_MIS_DB:
                        type: integer
                        format: int32
                        description: 'Primary keys: number of constraints missing from database'
                      IDX_MIS_DB:
                        type: integer
                        format: int32
                        description: 'Indexes: number of indexes missing from database'
                      VIE_MIS_DB:
                        type: integer
                        format: int32
                        description: 'Views: Number of views missing from database'
                      TAB_MIS_DD:
                        type: integer
                        format: int32
                        description: 'Tables: number of tables not in ABAP Dictionary'
                      CST_MIS_DD:
                        type: integer
                        format: int32
                        description: 'Primary keys: number of constr. missing from ABAP Dictionary'
                      IDX_MIS_DD:
                        type: integer
                        format: int32
                        description: 'Indexes: number of indexes missing from ABAP Dictionary'
                      VIE_MIS_DD:
                        type: integer
                        format: int32
                        description: 'Views: Number of views missing from ABAP Dictionary'
                      SYS_ASP_P:
                        type: integer
                        format: int64
                        description: Percentage of system ASP used
                      SYS_ASP_S:
                        type: integer
                        format: int64
                        description: Size of system ASP
                      ASP_TOT_S:
                        type: integer
                        format: int64
                        description: Total ASP size
                  ADDTL_INDEX:
                    type: array
                    items:
                      type: object
                      properties:
                        NAME:
                          type: string
                          maxLength: 40
                          description: Object Name in Object Directory
                  ADDTL_TABLES:
                    type: array
                    items:
                      type: object
                      properties:
                        NAME:
                          type: string
                          maxLength: 40
                          description: Object Name in Object Directory
                  ADDTL_VIEWS:
                    type: array
                    items:
                      type: object
                      properties:
                        NAME:
                          type: string
                          maxLength: 40
                          description: Object Name in Object Directory
                  MISS_INDEX:
                    type: array
                    items:
                      type: object
                      properties:
                        NAME:
                          type: string
                          maxLength: 40
                          description: Object Name in Object Directory
                  MISS_TABLES:
                    type: array
                    items:
                      type: object
                      properties:
                        NAME:
                          type: string
                          maxLength: 40
                          description: Object Name in Object Directory
                  MISS_VIEWS:
                    type: array
                    items:
                      type: object
                      properties:
                        NAME:
                          type: string
                          maxLength: 40
                          description: Object Name in Object Directory
        '400':
          description: Bad request.
        5XX:
          description: Unexpected error.
