openapi: 3.0.0 info: title: SAP API version: 1.0.0 servers: - url: http://localhost:8080 paths: /rfc/DB02N_GET_TBDYN_IN_TS_DB2: post: tags: - S_DB02N_DB2 summary: Get TableDynamics for all tables in a specific TS operationId: /rfc/DB02N_GET_TBDYN_IN_TS_DB2 requestBody: content: application/json: schema: properties: CREATOR: type: string maxLength: 8 description: DB2 creator name DBNAME: type: string maxLength: 8 description: Database name TSNAME: type: string maxLength: 8 description: Name of the tablespace TABLES_IN_TS: 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)) required: - TSNAME responses: '200': description: OK content: application/json: schema: properties: TABLES_IN_TS: 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.