Data Element list used by SAP ABAP Table MSQ_DBDATA (Contains information on a database)
SAP ABAP Table
MSQ_DBDATA (Contains information on a database) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | MSQDBARTA | ARITHABORT: Terminates on overflow or divide-by-zero error. | ||
| 2 | MSQDBASCRE | AUTO_CREATE_STATISTICS: missing statistics auto. generated. | ||
| 3 | MSQDBASUPD | AUTO_UPDATE_STATISTICS: Out of date statistics auto. updated | ||
| 4 | MSQDBAUTCL | The database will close down when the last user logs out | ||
| 5 | MSQDBAUTSH | AUTO_SHRINK: when 25% of the file is unused, file is shrunk. | ||
| 6 | MSQDBCLNSD | Database was cleanly shutdown | ||
| 7 | MSQDBCMPLV | Compatibility level SQL Server is running on. | ||
| 8 | MSQDBCNULL | CONCAT_NULL_YIELDS_NULL: NULLs concatenated result in NULL. | ||
| 9 | MSQDBCREDT | Date the database was created. | ||
| 10 | MSQDBCURCM | Cursor close on commit:any cursors open are closed on commit | ||
| 11 | MSQDBDBO | RESTRICTED_USER: Only the DB owner can access the database. | ||
| 12 | MSQDBEMRGY | Database is in emergency mode. | ||
| 13 | MSQDBFLTXT | Initializes fulltext indexing or removes all fulltext catalg | ||
| 14 | MSQDBFREE | Database free space in data files in MB. | ||
| 15 | MSQDBLOAD | The database is in a loading state. | ||
| 16 | MSQDBLOCDF | CURSOR_DEFAULT LOCAL: cursor declarations default to LOCAL | ||
| 17 | MSQDBNAME | The name of the database in SQL Server instance. | ||
| 18 | MSQDBNDUSR | Number of different users connected to SAP database | ||
| 19 | MSQDBNOTRC | The database is not recovering | ||
| 20 | MSQDBNULL | ANSI_NULLS: any comparisons to a NULL value evaluate to NULL | ||
| 21 | MSQDBNUMPC | Number of non-SAP processes connected to SAP database. | ||
| 22 | MSQDBOFFLN | The database is in status OFFLINE. | ||
| 23 | MSQDBPRERC | The database is in a prerecovering state | ||
| 24 | MSQDBQUTID | Quoted identifier: " can be used to surround identifiers. | ||
| 25 | MSQDBRDOLY | The database is in read only mode. | ||
| 26 | MSQDBRECTR | RECURSIVE_TRIGGERS: enables recursive firing of triggers. | ||
| 27 | MSQDBRECVR | Recovery of the database is underway. | ||
| 28 | MSQDBRNDA | NUMERIC_ROUNDABORT: error on loss of precision in expression | ||
| 29 | MSQDBSAPPC | Number of connections to SAP database from SAP application. | ||
| 30 | MSQDBSHTDW | Database encountered a problem during startup. | ||
| 31 | MSQDBSIZE | Database size in MB (data files). | ||
| 32 | MSQDBSNGLE | SINGLE_USER: the database is in single user mode. | ||
| 33 | MSQDBSTDBY | Database is functioning as a standby server. | ||
| 34 | MSQDBSUSPC | Database is marked as suspect. | ||
| 35 | MSQDBTPDET | TORN_PAGE_DETECTION: incomplete pages can be detected. | ||
| 36 | MSQDBTRCLG | Trunc. log on chkpt.: checkpoint when log is 70% full. | ||
| 37 | MSQDBULKCP | SELECT INTO and fast bulk copies are allowed. | ||
| 38 | MSQDBUSED | Database used space in data files in MB. | ||
| 39 | MSQDBUSRAN | ANSI_NULL_DEFAULT: NULL values allowed as default. | ||
| 40 | MSQDBWARN | ANSI_WARNINGS: null values in aggregate fcns, or divide by 0 | ||
| 41 | MSQLOGFREE | Free space in database transaction log in MB . | ||
| 42 | MSQLOGSIZE | Size of the database transaction log in MB. | ||
| 43 | MSQLOGUSED | Used space in database transaction log in MB. |