openapi: 3.0.0 info: title: SAP API version: 1.0.0 servers: - url: http://localhost:8080 paths: /rfc/DB4_INDEX_CREATED_INFO: post: tags: - STU4_ST04 summary: 'AS/400: Get index created info for ST04 Detail Analysis' operationId: /rfc/DB4_INDEX_CREATED_INFO requestBody: content: application/json: schema: properties: CURRENT_SYSTEM: 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('') RESETFLAG: type: string default: ' ' maxLength: 1 description: Feld vom Typ CHAR z.Zt nicht verwendet IDC_0100: type: array items: type: object properties: 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)' QQLPTL: type: string maxLength: 128 description: 'iSeries: Base Library (Database Monitor)' QQLPTF: type: string maxLength: 128 description: 'iSeries: Base Table (Database Monitor)' QQQRYCNT: type: integer format: int64 description: 'iSeries: Number of Different Statements (Database Monitor)' QQCIC: type: integer format: int64 description: 'iSeries: Number of Index Creates (Database Monitor)' QQTOTR: type: integer format: int64 description: 'iSeries: Total Rows in Table (Database Monitor)' QQRIDX: type: integer format: int64 description: 'iSeries: Number of Entries in Created Index' QQRROW: type: integer format: int64 description: 'iSeries: Result Rows (Database Monitor)' QQAVGT: type: integer format: int64 description: 'iSeries: Average Time (Database Monitor)' QQTTIM: type: integer format: int64 description: 'iSeries: Time for Index Create (Database Monitor)' TOTTIME: type: integer format: int64 description: 'iSeries: Total Time (Database Monitor)' QQUSER: type: string maxLength: 10 description: 'iSeries: Job User (Database Monitor)' IDC_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)' 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)' 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)' QQLILN: type: string maxLength: 128 description: 'iSeries: Index Library (Database Monitor)' QQLIFN: type: string maxLength: 128 description: 'iSeries: Index 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)' QQCIC: type: integer format: int64 description: 'iSeries: Number of Index Creates (Database Monitor)' QQTOTR: type: integer format: int64 description: 'iSeries: Total Rows in Table (Database Monitor)' QQRIDX: type: integer format: int64 description: 'iSeries: Number of Entries in Created Index' QQRROW: type: integer format: int64 description: 'iSeries: Result Rows (Database Monitor)' TOTTIME: type: integer format: int64 description: 'iSeries: Total Time (Database Monitor)' QQAVGT: type: integer format: int64 description: 'iSeries: Average 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)' QQTTIM: type: integer format: int64 description: 'iSeries: Time for Index Create (Database Monitor)' QQIDXA: type: string maxLength: 1 description: 'iSeries: Optimizer Advised Index (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)' QQRCOD: type: string maxLength: 2 description: 'iSeries: Reason Code (Database Monitor)' QQCRTK: type: string maxLength: 1000 description: 'iSeries: Key Fields of Created 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)' 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: IDC_0100: type: array items: type: object properties: 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)' QQLPTL: type: string maxLength: 128 description: 'iSeries: Base Library (Database Monitor)' QQLPTF: type: string maxLength: 128 description: 'iSeries: Base Table (Database Monitor)' QQQRYCNT: type: integer format: int64 description: 'iSeries: Number of Different Statements (Database Monitor)' QQCIC: type: integer format: int64 description: 'iSeries: Number of Index Creates (Database Monitor)' QQTOTR: type: integer format: int64 description: 'iSeries: Total Rows in Table (Database Monitor)' QQRIDX: type: integer format: int64 description: 'iSeries: Number of Entries in Created Index' QQRROW: type: integer format: int64 description: 'iSeries: Result Rows (Database Monitor)' QQAVGT: type: integer format: int64 description: 'iSeries: Average Time (Database Monitor)' QQTTIM: type: integer format: int64 description: 'iSeries: Time for Index Create (Database Monitor)' TOTTIME: type: integer format: int64 description: 'iSeries: Total Time (Database Monitor)' QQUSER: type: string maxLength: 10 description: 'iSeries: Job User (Database Monitor)' IDC_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)' 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)' 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)' QQLILN: type: string maxLength: 128 description: 'iSeries: Index Library (Database Monitor)' QQLIFN: type: string maxLength: 128 description: 'iSeries: Index 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)' QQCIC: type: integer format: int64 description: 'iSeries: Number of Index Creates (Database Monitor)' QQTOTR: type: integer format: int64 description: 'iSeries: Total Rows in Table (Database Monitor)' QQRIDX: type: integer format: int64 description: 'iSeries: Number of Entries in Created Index' QQRROW: type: integer format: int64 description: 'iSeries: Result Rows (Database Monitor)' TOTTIME: type: integer format: int64 description: 'iSeries: Total Time (Database Monitor)' QQAVGT: type: integer format: int64 description: 'iSeries: Average 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)' QQTTIM: type: integer format: int64 description: 'iSeries: Time for Index Create (Database Monitor)' QQIDXA: type: string maxLength: 1 description: 'iSeries: Optimizer Advised Index (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)' QQRCOD: type: string maxLength: 2 description: 'iSeries: Reason Code (Database Monitor)' QQCRTK: type: string maxLength: 1000 description: 'iSeries: Key Fields of Created 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)' 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.