openapi: 3.0.0 info: title: SAP API version: 1.0.0 servers: - url: http://localhost:8080 paths: /rfc/DB6_ADM_REORGCHK: post: tags: - SDB6ADM summary: 'DB6: RUNSTATS and REORGCHK of table' operationId: /rfc/DB6_ADM_REORGCHK requestBody: content: application/json: schema: properties: CONNECTION: type: string maxLength: 30 description: Logical name for a database connection SYSTEM_ID: type: string maxLength: 8 description: Logical name for a database connection TABNAME: type: string maxLength: 128 description: 'DB6: Table Name' TABSCHEMA: type: string maxLength: 20 description: 'DB6: Schema Name' IT_DB6IREORG: type: array items: type: object properties: DB6IOWNER: type: string maxLength: 20 description: 'DB6: Schema Name' DB6INAME: type: string maxLength: 128 description: 'DB6: Indexname' DB6TOWNER: type: string maxLength: 20 description: 'DB6: Schema Name' DB6TNAME: type: string maxLength: 18 description: Table Name DB6TSPACE: type: string maxLength: 18 description: Tablespace Name DB6CARD: type: string maxLength: 10 description: Cardinality (Number of Rows) in a Table DB6ISIZE: type: integer format: int32 description: Index Size DB6F4: type: string maxLength: 3 description: Formula 4 of REORGCHK Analysis DB6F5: type: string maxLength: 3 description: Formula 5 of REORGCHK Analysis DB6F6: type: string maxLength: 3 description: Formula 6 of REORGCHK Analysis DB6REORG: type: string maxLength: 3 description: REORGCHK - Recommendation DB6DATETIM: type: string maxLength: 26 description: 'DB6: Built-In UDB Type Timestamp' DB6ITYPE: type: string maxLength: 1 description: 'Type of Index: U=unique P=primary D=duplicates' DB6F7: type: integer format: int32 description: '' DB6F8: type: integer format: int32 description: '' DB6REORG2: type: string maxLength: 2 description: '' required: - TABNAME responses: '200': description: OK content: application/json: schema: properties: DB6TREORG: type: object properties: DB6TOWNER: type: string maxLength: 20 description: 'DB6: Schema Name' DB6TNAME: type: string maxLength: 18 description: 'DB6: Table Name' DB6TSPACE: type: string maxLength: 18 description: SYSCAT;Tablespace Name DB6TSIZE: type: integer format: int32 description: 'ADMIN_GET_TAB_INFO: Table Size at last runstats' DB6F1: type: string maxLength: 3 description: 'REORGCHK_TB_STATS: Formula 1 for REORGCHK Table' DB6F2: type: string maxLength: 3 description: 'REORGCHK_TB_STATS: Formula 2 of REORGCHK Analysis' DB6F3: type: string maxLength: 3 description: 'REORGCHK_TB_STATS: Formula 3 of REORGCHK Analysis' DB6REORG: type: string maxLength: 3 description: REORGCHK_TB_STATS:REORGCHK - Recommendation DB6DATETIM: type: string maxLength: 26 description: 'DB6: Built-In UDB Type Timestamp' DB6RUNTIME: type: string maxLength: 6 description: 'SAP Reorg Jobs: Runtime of Last REORG' DB6REODATE: type: string format: date description: SAP Reorg Jobs:Date of Last REORG DB6REOSIZE: type: integer format: int32 description: SAP Reorg Jobs:Table size at last reorg TSPTYPE: type: string maxLength: 1 description: SYSCAT:Tablespace Type PCTPAGESAVED: type: integer format: int32 description: 'SYSCAT: Percentage of pages saved by compression' COMPRESSION: type: string maxLength: 1 description: 'SYSCAT: Type of compression' DATA_OBJ_L_SIZE: type: integer format: int64 description: Number of logically allocated data pages DATA_OBJ_P_SIZE: type: integer format: int64 description: Number of physically allocated data pages INDEX_OBJ_L_SIZE: type: integer format: int64 description: Number of logically allocated index pages INDEX_OBJ_P_SIZE: type: integer format: int64 description: Number of physically allocated index pages LONG_OBJ_L_SIZE: type: integer format: int64 description: Number of logically allocated long pages LONG_OBJ_P_SIZE: type: integer format: int64 description: Number of physically allocated long pages LOB_OBJ_L_SIZE: type: integer format: int64 description: Number of logically allocated LOB pages LOB_OBJ_P_SIZE: type: integer format: int64 description: Number of physically allocated LOG pages XML_OBJ_L_SIZE: type: integer format: int64 description: Number of logically allocated XML pages XML_OBJ_P_SIZE: type: integer format: int64 description: Number of physically allocated XML pages LOAD_STATUS: type: string maxLength: 32 description: LOAD Status (IN_PROGRESS/PENDING) LARGE_RIDS: type: string maxLength: 10 description: Large RIDs (YES/NO) REORG_PENDING: type: string maxLength: 10 description: REORG pending (YES/NO) INDEX_TYPE: type: string maxLength: 10 description: Index Type (Type-1/Type-2) AVAILABLE: type: string maxLength: 10 description: Availability (YES/NO) IT_DB6IREORG: type: array items: type: object properties: DB6IOWNER: type: string maxLength: 20 description: 'DB6: Schema Name' DB6INAME: type: string maxLength: 128 description: 'DB6: Indexname' DB6TOWNER: type: string maxLength: 20 description: 'DB6: Schema Name' DB6TNAME: type: string maxLength: 18 description: Table Name DB6TSPACE: type: string maxLength: 18 description: Tablespace Name DB6CARD: type: string maxLength: 10 description: Cardinality (Number of Rows) in a Table DB6ISIZE: type: integer format: int32 description: Index Size DB6F4: type: string maxLength: 3 description: Formula 4 of REORGCHK Analysis DB6F5: type: string maxLength: 3 description: Formula 5 of REORGCHK Analysis DB6F6: type: string maxLength: 3 description: Formula 6 of REORGCHK Analysis DB6REORG: type: string maxLength: 3 description: REORGCHK - Recommendation DB6DATETIM: type: string maxLength: 26 description: 'DB6: Built-In UDB Type Timestamp' DB6ITYPE: type: string maxLength: 1 description: 'Type of Index: U=unique P=primary D=duplicates' DB6F7: type: integer format: int32 description: '' DB6F8: type: integer format: int32 description: '' DB6REORG2: type: string maxLength: 2 description: '' '400': description: Bad request. 5XX: description: Unexpected error.