openapi: 3.0.0 info: title: SAP API version: 1.0.0 servers: - url: http://localhost:8080 paths: /rfc/DB02N_GET_TBSIZE_DYNAMICS_DB2: post: tags: - S_DB02N_DB2 operationId: /rfc/DB02N_GET_TBSIZE_DYNAMICS_DB2 requestBody: content: application/json: schema: properties: TABLESIZE_DYNAMICS: type: array items: type: object properties: CREATOR: type: string maxLength: 8 description: DB2 creator name TBNAME: type: string maxLength: 18 description: Name of the table on which the index is defined DBNAME: type: string maxLength: 8 description: Database name TSNAME: type: string maxLength: 8 description: Name of the tablespace TBSIZE: type: number description: 'Real Time Statistics: Table size = TOTALENTRIES*AvgRowLen KB' TBSIZE_LAST: type: number description: 'Tx DB02: Absolute difference in comparison to previous run' TBSIZE_PERC: type: integer format: int32 description: 'Tx DB02: Difference (percent) in comparison to previous run' TBSIZE_FIRST: type: number description: 'Tx DB02: Absolute difference in comparison to first run' D_TBSIZE: type: number description: RTS Table size (= TOTALENTRIES*AvgRowLen KB) daily changes W_TBSIZE: type: number description: RTS Table size (= TOTALENTRIES*AvgRowLen KB) weekly changes M_TBSIZE: type: number description: RTS Table size (= TOTALENTRIES*AvgRowLen KB) monthly changes RTS_TOTALROWS: type: number description: 'DB2/zOS: Real-Time Statistics tablespace TOTALROWS' TOTALROWS_LAST: type: number description: 'Tx DB02: Absolute difference in comparison to previous run' TOTALROWS_PERC: type: integer format: int32 description: 'Tx DB02: Difference (percent) in comparison to previous run' TOTALROWS_FIRST: type: number description: 'Tx DB02: Absolute difference in comparison to first run' D_TOTALROWS: type: number description: 'Number of Rows: changes per day' W_TOTALROWS: type: number description: 'Number of Rows: changes per week' M_TOTALROWS: type: number description: 'Number of Rows: changes per month' SPACEF: type: number description: 'Column SYSIBM.SYSTABLES(SPACEF): DASD space used for table' SPACEF_LAST: type: number description: 'Tx DB02: Absolute difference in comparison to previous run' SPACEF_PERC: type: integer format: int32 description: 'Tx DB02: Difference (percent) in comparison to previous run' SPACEF_FIRST: type: number description: 'Tx DB02: Absolute difference in comparison to first run' D_SPACEF: type: number description: Change/day for DASD space (SYSIBM.SYSTABLES(SPACEF)) W_SPACEF: type: number description: Change/week for DASD space (SYSIBM.SYSTABLES(SPACEF)) M_SPACEF: type: number description: Change/month for DASD space (SYSIBM.SYSTABLES(SPACEF)) responses: '200': description: OK content: application/json: schema: properties: HISTORY_RANGE: type: object properties: FIRSTDAY: type: string format: date description: First day in DB02 history FIRSTTIME: type: string maxLength: 6 description: Time of first run in DB02 history 2NDLASTDAY: type: string format: date description: The execution previous to the latest execution 2NDLASTTIME: type: string maxLength: 6 description: Time of execution previous to the latest execution LASTDAY: type: string format: date description: Last day in DB02 history LASTTIME: type: string maxLength: 6 description: Time of latest execution in DB02 history ANZDAYS: type: integer format: int32 description: Number of days covered FIRSTWEEK: type: string format: date description: First week in DB02 history LASTWEEK: type: string format: date description: Last week in DB02 history ANZWEEKS: type: integer format: int32 description: Number of weeks covered FIRSTMONTH: type: string format: date description: First month in DB02 history LASTMONTH: type: string format: date description: Last month in DB02 history ANZMONTHS: type: integer format: int32 description: Number of months covered TABLESIZE_DYNAMICS: type: array items: type: object properties: CREATOR: type: string maxLength: 8 description: DB2 creator name TBNAME: type: string maxLength: 18 description: Name of the table on which the index is defined DBNAME: type: string maxLength: 8 description: Database name TSNAME: type: string maxLength: 8 description: Name of the tablespace TBSIZE: type: number description: 'Real Time Statistics: Table size = TOTALENTRIES*AvgRowLen KB' TBSIZE_LAST: type: number description: 'Tx DB02: Absolute difference in comparison to previous run' TBSIZE_PERC: type: integer format: int32 description: 'Tx DB02: Difference (percent) in comparison to previous run' TBSIZE_FIRST: type: number description: 'Tx DB02: Absolute difference in comparison to first run' D_TBSIZE: type: number description: RTS Table size (= TOTALENTRIES*AvgRowLen KB) daily changes W_TBSIZE: type: number description: RTS Table size (= TOTALENTRIES*AvgRowLen KB) weekly changes M_TBSIZE: type: number description: RTS Table size (= TOTALENTRIES*AvgRowLen KB) monthly changes RTS_TOTALROWS: type: number description: 'DB2/zOS: Real-Time Statistics tablespace TOTALROWS' TOTALROWS_LAST: type: number description: 'Tx DB02: Absolute difference in comparison to previous run' TOTALROWS_PERC: type: integer format: int32 description: 'Tx DB02: Difference (percent) in comparison to previous run' TOTALROWS_FIRST: type: number description: 'Tx DB02: Absolute difference in comparison to first run' D_TOTALROWS: type: number description: 'Number of Rows: changes per day' W_TOTALROWS: type: number description: 'Number of Rows: changes per week' M_TOTALROWS: type: number description: 'Number of Rows: changes per month' SPACEF: type: number description: 'Column SYSIBM.SYSTABLES(SPACEF): DASD space used for table' SPACEF_LAST: type: number description: 'Tx DB02: Absolute difference in comparison to previous run' SPACEF_PERC: type: integer format: int32 description: 'Tx DB02: Difference (percent) in comparison to previous run' SPACEF_FIRST: type: number description: 'Tx DB02: Absolute difference in comparison to first run' D_SPACEF: type: number description: Change/day for DASD space (SYSIBM.SYSTABLES(SPACEF)) W_SPACEF: type: number description: Change/week for DASD space (SYSIBM.SYSTABLES(SPACEF)) M_SPACEF: type: number description: Change/month for DASD space (SYSIBM.SYSTABLES(SPACEF)) '400': description: Bad request. 5XX: description: Unexpected error.