openapi: 3.0.0
info:
  title: SAP API
  version: 1.0.0
servers:
- url: http://localhost:8080
paths:
  /rfc/MSQ_DB02_DOWNLOAD:
    post:
      tags:
      - STUS
      summary: MS SQL Server DB02 main screen download
      operationId: /rfc/MSQ_DB02_DOWNLOAD
      requestBody:
        content:
          application/json:
            schema:
              properties:
                DBNAME:
                  type: string
                  default: '0'
                  maxLength: 255
                SESDESC:
                  type: string
                  default: ' '
                  maxLength: 8
                  description: Text of length 8 char
                SESTYPE:
                  type: string
                  default: ' '
                  maxLength: 8
                  description: Text of length 8 char
                DBDATA:
                  type: array
                  items:
                    type: object
                    properties:
                      DBNAME:
                        type: string
                        maxLength: 255
                        description: MS SQL server Database name
                      CRDATE:
                        type: string
                        maxLength: 12
                        description: Date the SQLSever database was created
                      CMPTLEVEL:
                        type: integer
                        format: int32
                        description: SQLServer release level that the DB is compatible to
                      AUTOSTCRE:
                        type: string
                        maxLength: 1
                        description: Missing statistics auto. built for query during optimization
                      AUTOSTUPD:
                        type: string
                        maxLength: 1
                        description: Out of date Statistics built for query during optimization
                      AUTOCLOSE:
                        type: string
                        maxLength: 1
                        description: The database will close down when the last user logs out
                      BULKCOPY:
                        type: string
                        maxLength: 1
                        description: SELECT INTO and fast bulk copies are allowed
                      TRUCLOG:
                        type: string
                        maxLength: 1
                        description: The db is checkpointed when log is 70% full
                      TORNPGDET:
                        type: string
                        maxLength: 1
                        description: Incomplete pages can be detected
                      LOADING:
                        type: string
                        maxLength: 1
                        description: The database is in a loading state
                      PRERECVY:
                        type: string
                        maxLength: 1
                        description: The database is in a prerecovering state
                      RECOVERY:
                        type: string
                        maxLength: 1
                        description: The database is in a recovering state
                      NOTRECVR:
                        type: string
                        maxLength: 1
                        description: The database is not recovering
                      DBOFFLINE:
                        type: string
                        maxLength: 1
                        description: The database is offline
                      READONLY:
                        type: string
                        maxLength: 1
                        description: The database is read only
                      DBOONLY:
                        type: string
                        maxLength: 1
                        description: Only the database owner can access the database
                      SINGLEUSER:
                        type: string
                        maxLength: 1
                        description: The database is in single user mode
                      EMERGYMD:
                        type: string
                        maxLength: 1
                        description: Database is in emergency mode
                      AUTOSHRINK:
                        type: string
                        maxLength: 1
                        description: When 25% or more of the file is unused, file is auto. shrunk
                      CLNSHTDWN:
                        type: string
                        maxLength: 1
                        description: Database was cleanly shutdown
                      ANSINULDEF:
                        type: string
                        maxLength: 1
                        description: Allows the user to control the database default nullability
                      CCNULL:
                        type: string
                        maxLength: 1
                        description: Null operands result in a Null if concatenated
                      RECTRIGGER:
                        type: string
                        maxLength: 1
                        description: Enables recursive firing of triggers
                      DEFLOCCUR:
                        type: string
                        maxLength: 1
                        description: Cursor declarations default to LOCAL
                      QUOTEDID:
                        type: string
                        maxLength: 1
                        description: '" can be used to surround delimited identifiers'
                      CCONCOMMIT:
                        type: string
                        maxLength: 1
                        description: Any cursors open are closed on commit or roll back
                      ANSINULLS:
                        type: string
                        maxLength: 1
                        description: Any comparisons to a null value evaluate to NULL
                      ANSIWARN:
                        type: string
                        maxLength: 1
                        description: Null values in aggregate fcns, or divide by 0, cause warning
                      FULLTXTEN:
                        type: string
                        maxLength: 1
                        description: Initailizes fulltext indexing or removes all full-text catlg
                      DBSUSPECT:
                        type: string
                        maxLength: 1
                        description: Database is marked as suspect
                      DBSHUTDOWN:
                        type: string
                        maxLength: 1
                        description: Database encountered a problem during startup
                      DBSTANDBY:
                        type: string
                        maxLength: 1
                        description: Database is functioning as a standby server
                      DBSIZE:
                        type: integer
                        format: int32
                        description: MS SQL server database size
                      DBFREE:
                        type: integer
                        format: int32
                        description: MSQ server database free size
                      DBUSED:
                        type: integer
                        format: int32
                        description: MSQ server database used size
                      LOGSIZE:
                        type: integer
                        format: int32
                        description: MS SQL server - size of the log file
                      LOGFREE:
                        type: integer
                        format: int32
                        description: MS SQL server -  free log size
                      LOGUSED:
                        type: integer
                        format: int32
                        description: MS SQL server -  used log size
                      DBNUMSAP:
                        type: integer
                        format: int32
                        description: Number of SAP processes connected to the database
                      DBNUMOTHER:
                        type: integer
                        format: int32
                        description: Number of non-SAP processes connected to the database
                      DBNDIFFUSE:
                        type: integer
                        format: int32
                        description: Number of different users connected to the database
                DBFILES:
                  type: array
                  items:
                    type: object
                    properties:
                      FILEGRPNA:
                        type: string
                        maxLength: 256
                        description: MS SQL server - file group name
                      FILEGRPDEF:
                        type: string
                        maxLength: 1
                        description: Default file grp contains objects created w/o defined filegp
                      FGRPRDONLY:
                        type: string
                        maxLength: 1
                        description: The file group is read only
                      LOGFILENA:
                        type: string
                        maxLength: 256
                        description: MS SQL server logical filename of the database file
                      PHYFILENA:
                        type: string
                        maxLength: 520
                        description: MS SQL server physical device filename with full path
                      DEVFREE:
                        type: integer
                        format: int32
                        description: size in MB of free space left on device
                      DEVSIZE:
                        type: integer
                        format: int32
                        description: The size in MB of the logical device the file resides upon
                      FLSIZEMB:
                        type: integer
                        format: int32
                        description: True file size in MB
                      FLMAXSZMB:
                        type: integer
                        format: int32
                        description: True Max file size in MB (-1 means file will grow disk full)
                      FLGRWPCT:
                        type: string
                        maxLength: 1
                        description: SQL Server file has growth represented in percentage
                      FLGROWTH:
                        type: integer
                        format: int32
                        description: Growth size size of the SQL Server database file
                      FLGROWMB:
                        type: integer
                        format: int32
                        description: True file growth in MB
                      FLEXTENTS:
                        type: integer
                        format: int32
                        description: Total number of extents assigned to a file
                      FLUSDEXTS:
                        type: integer
                        format: int32
                        description: Ttl num of used extents(8 contiguous pgs) assigned to file
                      FILEPRMRY:
                        type: string
                        maxLength: 1
                        description: Primary file containing startup information and also data
                      FLDEFDEV:
                        type: string
                        maxLength: 1
                        description: file is on default device
                      FLDISKFILE:
                        type: string
                        maxLength: 1
                        description: file is a disk file
                      FLLOGDEV:
                        type: string
                        maxLength: 1
                        description: file is a log file
                      FLWRITEBU:
                        type: string
                        maxLength: 1
                        description: file has been written to since the last backup was done
                      FLCREATEDB:
                        type: string
                        maxLength: 1
                        description: file was created with a CREATE DB command
                      FLDBCREATE:
                        type: string
                        maxLength: 1
                        description: file created during Database creation
                DBOPTIONS:
                  type: array
                  items:
                    type: object
                    properties:
                      DBOPTIONS:
                        type: string
                        maxLength: 255
                        description: MS SQL server Database name
                DBSTATS:
                  type: array
                  items:
                    type: object
                    properties:
                      DBNAME:
                        type: string
                        maxLength: 255
                        description: MS SQL server Database name
                      DBSIZE:
                        type: integer
                        format: int32
                        description: MS SQL server database size
                      DBUSEDSIZE:
                        type: integer
                        format: int32
                        description: MS SQL server - total number of reserved pages allocated
                      DBFREESIZE:
                        type: integer
                        format: int32
                        description: MS SQL server - free space of the database
                      DBUNUSEDSZ:
                        type: integer
                        format: int32
                        description: MS SQL server - unused space of the database
                      TOTTABNUM:
                        type: integer
                        format: int32
                        description: MS SQL server - number of user tables in the database
                      TOTTABSIZE:
                        type: integer
                        format: int32
                        description: MS SQL server - total size of all user tables
                      TOTINDNUM:
                        type: integer
                        format: int32
                        description: MS SQL server - total number of indexes
                      TOTINDSIZE:
                        type: integer
                        format: int32
                        description: MS SQL server - total size of all indexes
                      TOTSPNUM:
                        type: integer
                        format: int32
                        description: MS SQL server - total number of stored procedures
                      TOTSPSIZE:
                        type: integer
                        format: int32
                        description: MS SQL server - total size of stored procedures
                DB_HIST:
                  type: array
                  items:
                    type: object
                    properties:
                      DATE:
                        type: string
                        format: date
                        description: Date
                      TIME:
                        type: string
                        maxLength: 6
                        description: Time
                      DBNAME:
                        type: string
                        maxLength: 128
                        description: Database name
                      DB_SIZE:
                        type: integer
                        format: int64
                        description: Database size in MB
                      DB_ALLOC:
                        type: integer
                        format: int64
                        description: Allocated space in database in MB
                      LOG_SIZE:
                        type: integer
                        format: int64
                        description: Log size in MB
                      LOG_ALLOC:
                        type: integer
                        format: int64
                        description: Allocated space in log in MB
                      RESERVED:
                        type: integer
                        format: int64
                        description: Reserved size in KB
                      NUMTABS:
                        type: integer
                        format: int32
                        description: Number of user tables
                      TABDATA:
                        type: integer
                        format: int64
                        description: Data size in KB
                      NUMINDS:
                        type: integer
                        format: int32
                        description: Number of indexes of user tables
                      INDDATA:
                        type: integer
                        format: int64
                        description: Index size in KB
                      UNUSED:
                        type: integer
                        format: int64
                        description: Unused size in KB
                      NUMPROCS:
                        type: integer
                        format: int32
                        description: Number of stored procedures created in DBI
                TEMPFILES:
                  type: array
                  items:
                    type: object
                    properties:
                      FILEGRPNA:
                        type: string
                        maxLength: 256
                        description: MS SQL server - file group name
                      FILEGRPDEF:
                        type: string
                        maxLength: 1
                        description: Default file grp contains objects created w/o defined filegp
                      FGRPRDONLY:
                        type: string
                        maxLength: 1
                        description: The file group is read only
                      LOGFILENA:
                        type: string
                        maxLength: 256
                        description: MS SQL server logical filename of the database file
                      PHYFILENA:
                        type: string
                        maxLength: 520
                        description: MS SQL server physical device filename with full path
                      DEVFREE:
                        type: integer
                        format: int32
                        description: size in MB of free space left on device
                      DEVSIZE:
                        type: integer
                        format: int32
                        description: The size in MB of the logical device the file resides upon
                      FLSIZEMB:
                        type: integer
                        format: int32
                        description: True file size in MB
                      FLMAXSZMB:
                        type: integer
                        format: int32
                        description: True Max file size in MB (-1 means file will grow disk full)
                      FLGRWPCT:
                        type: string
                        maxLength: 1
                        description: SQL Server file has growth represented in percentage
                      FLGROWTH:
                        type: integer
                        format: int32
                        description: Growth size size of the SQL Server database file
                      FLGROWMB:
                        type: integer
                        format: int32
                        description: True file growth in MB
                      FLEXTENTS:
                        type: integer
                        format: int32
                        description: Total number of extents assigned to a file
                      FLUSDEXTS:
                        type: integer
                        format: int32
                        description: Ttl num of used extents(8 contiguous pgs) assigned to file
                      FILEPRMRY:
                        type: string
                        maxLength: 1
                        description: Primary file containing startup information and also data
                      FLDEFDEV:
                        type: string
                        maxLength: 1
                        description: file is on default device
                      FLDISKFILE:
                        type: string
                        maxLength: 1
                        description: file is a disk file
                      FLLOGDEV:
                        type: string
                        maxLength: 1
                        description: file is a log file
                      FLWRITEBU:
                        type: string
                        maxLength: 1
                        description: file has been written to since the last backup was done
                      FLCREATEDB:
                        type: string
                        maxLength: 1
                        description: file was created with a CREATE DB command
                      FLDBCREATE:
                        type: string
                        maxLength: 1
                        description: file created during Database creation
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                properties:
                  DBDATA:
                    type: array
                    items:
                      type: object
                      properties:
                        DBNAME:
                          type: string
                          maxLength: 255
                          description: MS SQL server Database name
                        CRDATE:
                          type: string
                          maxLength: 12
                          description: Date the SQLSever database was created
                        CMPTLEVEL:
                          type: integer
                          format: int32
                          description: SQLServer release level that the DB is compatible to
                        AUTOSTCRE:
                          type: string
                          maxLength: 1
                          description: Missing statistics auto. built for query during optimization
                        AUTOSTUPD:
                          type: string
                          maxLength: 1
                          description: Out of date Statistics built for query during optimization
                        AUTOCLOSE:
                          type: string
                          maxLength: 1
                          description: The database will close down when the last user logs out
                        BULKCOPY:
                          type: string
                          maxLength: 1
                          description: SELECT INTO and fast bulk copies are allowed
                        TRUCLOG:
                          type: string
                          maxLength: 1
                          description: The db is checkpointed when log is 70% full
                        TORNPGDET:
                          type: string
                          maxLength: 1
                          description: Incomplete pages can be detected
                        LOADING:
                          type: string
                          maxLength: 1
                          description: The database is in a loading state
                        PRERECVY:
                          type: string
                          maxLength: 1
                          description: The database is in a prerecovering state
                        RECOVERY:
                          type: string
                          maxLength: 1
                          description: The database is in a recovering state
                        NOTRECVR:
                          type: string
                          maxLength: 1
                          description: The database is not recovering
                        DBOFFLINE:
                          type: string
                          maxLength: 1
                          description: The database is offline
                        READONLY:
                          type: string
                          maxLength: 1
                          description: The database is read only
                        DBOONLY:
                          type: string
                          maxLength: 1
                          description: Only the database owner can access the database
                        SINGLEUSER:
                          type: string
                          maxLength: 1
                          description: The database is in single user mode
                        EMERGYMD:
                          type: string
                          maxLength: 1
                          description: Database is in emergency mode
                        AUTOSHRINK:
                          type: string
                          maxLength: 1
                          description: When 25% or more of the file is unused, file is auto. shrunk
                        CLNSHTDWN:
                          type: string
                          maxLength: 1
                          description: Database was cleanly shutdown
                        ANSINULDEF:
                          type: string
                          maxLength: 1
                          description: Allows the user to control the database default nullability
                        CCNULL:
                          type: string
                          maxLength: 1
                          description: Null operands result in a Null if concatenated
                        RECTRIGGER:
                          type: string
                          maxLength: 1
                          description: Enables recursive firing of triggers
                        DEFLOCCUR:
                          type: string
                          maxLength: 1
                          description: Cursor declarations default to LOCAL
                        QUOTEDID:
                          type: string
                          maxLength: 1
                          description: '" can be used to surround delimited identifiers'
                        CCONCOMMIT:
                          type: string
                          maxLength: 1
                          description: Any cursors open are closed on commit or roll back
                        ANSINULLS:
                          type: string
                          maxLength: 1
                          description: Any comparisons to a null value evaluate to NULL
                        ANSIWARN:
                          type: string
                          maxLength: 1
                          description: Null values in aggregate fcns, or divide by 0, cause warning
                        FULLTXTEN:
                          type: string
                          maxLength: 1
                          description: Initailizes fulltext indexing or removes all full-text catlg
                        DBSUSPECT:
                          type: string
                          maxLength: 1
                          description: Database is marked as suspect
                        DBSHUTDOWN:
                          type: string
                          maxLength: 1
                          description: Database encountered a problem during startup
                        DBSTANDBY:
                          type: string
                          maxLength: 1
                          description: Database is functioning as a standby server
                        DBSIZE:
                          type: integer
                          format: int32
                          description: MS SQL server database size
                        DBFREE:
                          type: integer
                          format: int32
                          description: MSQ server database free size
                        DBUSED:
                          type: integer
                          format: int32
                          description: MSQ server database used size
                        LOGSIZE:
                          type: integer
                          format: int32
                          description: MS SQL server - size of the log file
                        LOGFREE:
                          type: integer
                          format: int32
                          description: MS SQL server -  free log size
                        LOGUSED:
                          type: integer
                          format: int32
                          description: MS SQL server -  used log size
                        DBNUMSAP:
                          type: integer
                          format: int32
                          description: Number of SAP processes connected to the database
                        DBNUMOTHER:
                          type: integer
                          format: int32
                          description: Number of non-SAP processes connected to the database
                        DBNDIFFUSE:
                          type: integer
                          format: int32
                          description: Number of different users connected to the database
                  DBFILES:
                    type: array
                    items:
                      type: object
                      properties:
                        FILEGRPNA:
                          type: string
                          maxLength: 256
                          description: MS SQL server - file group name
                        FILEGRPDEF:
                          type: string
                          maxLength: 1
                          description: Default file grp contains objects created w/o defined filegp
                        FGRPRDONLY:
                          type: string
                          maxLength: 1
                          description: The file group is read only
                        LOGFILENA:
                          type: string
                          maxLength: 256
                          description: MS SQL server logical filename of the database file
                        PHYFILENA:
                          type: string
                          maxLength: 520
                          description: MS SQL server physical device filename with full path
                        DEVFREE:
                          type: integer
                          format: int32
                          description: size in MB of free space left on device
                        DEVSIZE:
                          type: integer
                          format: int32
                          description: The size in MB of the logical device the file resides upon
                        FLSIZEMB:
                          type: integer
                          format: int32
                          description: True file size in MB
                        FLMAXSZMB:
                          type: integer
                          format: int32
                          description: True Max file size in MB (-1 means file will grow disk full)
                        FLGRWPCT:
                          type: string
                          maxLength: 1
                          description: SQL Server file has growth represented in percentage
                        FLGROWTH:
                          type: integer
                          format: int32
                          description: Growth size size of the SQL Server database file
                        FLGROWMB:
                          type: integer
                          format: int32
                          description: True file growth in MB
                        FLEXTENTS:
                          type: integer
                          format: int32
                          description: Total number of extents assigned to a file
                        FLUSDEXTS:
                          type: integer
                          format: int32
                          description: Ttl num of used extents(8 contiguous pgs) assigned to file
                        FILEPRMRY:
                          type: string
                          maxLength: 1
                          description: Primary file containing startup information and also data
                        FLDEFDEV:
                          type: string
                          maxLength: 1
                          description: file is on default device
                        FLDISKFILE:
                          type: string
                          maxLength: 1
                          description: file is a disk file
                        FLLOGDEV:
                          type: string
                          maxLength: 1
                          description: file is a log file
                        FLWRITEBU:
                          type: string
                          maxLength: 1
                          description: file has been written to since the last backup was done
                        FLCREATEDB:
                          type: string
                          maxLength: 1
                          description: file was created with a CREATE DB command
                        FLDBCREATE:
                          type: string
                          maxLength: 1
                          description: file created during Database creation
                  DBOPTIONS:
                    type: array
                    items:
                      type: object
                      properties:
                        DBOPTIONS:
                          type: string
                          maxLength: 255
                          description: MS SQL server Database name
                  DBSTATS:
                    type: array
                    items:
                      type: object
                      properties:
                        DBNAME:
                          type: string
                          maxLength: 255
                          description: MS SQL server Database name
                        DBSIZE:
                          type: integer
                          format: int32
                          description: MS SQL server database size
                        DBUSEDSIZE:
                          type: integer
                          format: int32
                          description: MS SQL server - total number of reserved pages allocated
                        DBFREESIZE:
                          type: integer
                          format: int32
                          description: MS SQL server - free space of the database
                        DBUNUSEDSZ:
                          type: integer
                          format: int32
                          description: MS SQL server - unused space of the database
                        TOTTABNUM:
                          type: integer
                          format: int32
                          description: MS SQL server - number of user tables in the database
                        TOTTABSIZE:
                          type: integer
                          format: int32
                          description: MS SQL server - total size of all user tables
                        TOTINDNUM:
                          type: integer
                          format: int32
                          description: MS SQL server - total number of indexes
                        TOTINDSIZE:
                          type: integer
                          format: int32
                          description: MS SQL server - total size of all indexes
                        TOTSPNUM:
                          type: integer
                          format: int32
                          description: MS SQL server - total number of stored procedures
                        TOTSPSIZE:
                          type: integer
                          format: int32
                          description: MS SQL server - total size of stored procedures
                  DB_HIST:
                    type: array
                    items:
                      type: object
                      properties:
                        DATE:
                          type: string
                          format: date
                          description: Date
                        TIME:
                          type: string
                          maxLength: 6
                          description: Time
                        DBNAME:
                          type: string
                          maxLength: 128
                          description: Database name
                        DB_SIZE:
                          type: integer
                          format: int64
                          description: Database size in MB
                        DB_ALLOC:
                          type: integer
                          format: int64
                          description: Allocated space in database in MB
                        LOG_SIZE:
                          type: integer
                          format: int64
                          description: Log size in MB
                        LOG_ALLOC:
                          type: integer
                          format: int64
                          description: Allocated space in log in MB
                        RESERVED:
                          type: integer
                          format: int64
                          description: Reserved size in KB
                        NUMTABS:
                          type: integer
                          format: int32
                          description: Number of user tables
                        TABDATA:
                          type: integer
                          format: int64
                          description: Data size in KB
                        NUMINDS:
                          type: integer
                          format: int32
                          description: Number of indexes of user tables
                        INDDATA:
                          type: integer
                          format: int64
                          description: Index size in KB
                        UNUSED:
                          type: integer
                          format: int64
                          description: Unused size in KB
                        NUMPROCS:
                          type: integer
                          format: int32
                          description: Number of stored procedures created in DBI
                  TEMPFILES:
                    type: array
                    items:
                      type: object
                      properties:
                        FILEGRPNA:
                          type: string
                          maxLength: 256
                          description: MS SQL server - file group name
                        FILEGRPDEF:
                          type: string
                          maxLength: 1
                          description: Default file grp contains objects created w/o defined filegp
                        FGRPRDONLY:
                          type: string
                          maxLength: 1
                          description: The file group is read only
                        LOGFILENA:
                          type: string
                          maxLength: 256
                          description: MS SQL server logical filename of the database file
                        PHYFILENA:
                          type: string
                          maxLength: 520
                          description: MS SQL server physical device filename with full path
                        DEVFREE:
                          type: integer
                          format: int32
                          description: size in MB of free space left on device
                        DEVSIZE:
                          type: integer
                          format: int32
                          description: The size in MB of the logical device the file resides upon
                        FLSIZEMB:
                          type: integer
                          format: int32
                          description: True file size in MB
                        FLMAXSZMB:
                          type: integer
                          format: int32
                          description: True Max file size in MB (-1 means file will grow disk full)
                        FLGRWPCT:
                          type: string
                          maxLength: 1
                          description: SQL Server file has growth represented in percentage
                        FLGROWTH:
                          type: integer
                          format: int32
                          description: Growth size size of the SQL Server database file
                        FLGROWMB:
                          type: integer
                          format: int32
                          description: True file growth in MB
                        FLEXTENTS:
                          type: integer
                          format: int32
                          description: Total number of extents assigned to a file
                        FLUSDEXTS:
                          type: integer
                          format: int32
                          description: Ttl num of used extents(8 contiguous pgs) assigned to file
                        FILEPRMRY:
                          type: string
                          maxLength: 1
                          description: Primary file containing startup information and also data
                        FLDEFDEV:
                          type: string
                          maxLength: 1
                          description: file is on default device
                        FLDISKFILE:
                          type: string
                          maxLength: 1
                          description: file is a disk file
                        FLLOGDEV:
                          type: string
                          maxLength: 1
                          description: file is a log file
                        FLWRITEBU:
                          type: string
                          maxLength: 1
                          description: file has been written to since the last backup was done
                        FLCREATEDB:
                          type: string
                          maxLength: 1
                          description: file was created with a CREATE DB command
                        FLDBCREATE:
                          type: string
                          maxLength: 1
                          description: file created during Database creation
        '400':
          description: Bad request.
        5XX:
          description: Unexpected error.
