SAP ABAP Table MSQ_DBDATA (Contains information on a database)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-MSS (Application Component) Microsoft SQL Server
     ⤷ STUN_MSS (Package) Package for new SQL Server monitoring objects

Basic Data

Table Category	INTTAB	Structure
Structure	MSQ_DBDATA	Table Relationship Diagram
Short Description	Contains information on a database

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	DBNAME	☐	MSQDBNAME	CHAR255	CHAR	255	0	The name of the database in SQL Server instance.
2	CRDATE	☐	MSQDBCREDT	CHAR12	CHAR	12	0	Date the database was created.
3	CMPTLEVEL	☐	MSQDBCMPLV	INT4	INT4	10	0	Compatibility level SQL Server is running on.
4	AUTOSTCRE	☐	MSQDBASCRE	CHAR1	CHAR	1	0	AUTO_CREATE_STATISTICS: missing statistics auto. generated.
5	AUTOSTUPD	☐	MSQDBASUPD	CHAR1	CHAR	1	0	AUTO_UPDATE_STATISTICS: Out of date statistics auto. updated
6	AUTOCLOSE	☐	MSQDBAUTCL	CHAR1	CHAR	1	0	The database will close down when the last user logs out
7	BULKCOPY	☐	MSQDBULKCP	CHAR1	CHAR	1	0	SELECT INTO and fast bulk copies are allowed.
8	TRUCLOG	☐	MSQDBTRCLG	CHAR1	CHAR	1	0	Trunc. log on chkpt.: checkpoint when log is 70% full.
9	TORNPGDET	☐	MSQDBTPDET	CHAR1	CHAR	1	0	TORN_PAGE_DETECTION: incomplete pages can be detected.
10	LOADING	☐	MSQDBLOAD	CHAR1	CHAR	1	0	The database is in a loading state.
11	PRERECVY	☐	MSQDBPRERC	CHAR1	CHAR	1	0	The database is in a prerecovering state
12	RECOVERY	☐	MSQDBRECVR	CHAR1	CHAR	1	0	Recovery of the database is underway.
13	NOTRECVR	☐	MSQDBNOTRC	CHAR1	CHAR	1	0	The database is not recovering
14	DBOFFLINE	☐	MSQDBOFFLN	CHAR1	CHAR	1	0	The database is in status OFFLINE.
15	READONLY	☐	MSQDBRDOLY	CHAR1	CHAR	1	0	The database is in read only mode.
16	DBOONLY	☐	MSQDBDBO	CHAR1	CHAR	1	0	RESTRICTED_USER: Only the DB owner can access the database.
17	SINGLEUSER	☐	MSQDBSNGLE	CHAR1	CHAR	1	0	SINGLE_USER: the database is in single user mode.
18	EMERGYMD	☐	MSQDBEMRGY	CHAR1	CHAR	1	0	Database is in emergency mode.
19	AUTOSHRINK	☐	MSQDBAUTSH	CHAR1	CHAR	1	0	AUTO_SHRINK: when 25% of the file is unused, file is shrunk.
20	CLNSHTDWN	☐	MSQDBCLNSD	CHAR1	CHAR	1	0	Database was cleanly shutdown
21	ANSINULDEF	☐	MSQDBUSRAN	CHAR1	CHAR	1	0	ANSI_NULL_DEFAULT: NULL values allowed as default.
22	CCNULL	☐	MSQDBCNULL	CHAR1	CHAR	1	0	CONCAT_NULL_YIELDS_NULL: NULLs concatenated result in NULL.
23	RECTRIGGER	☐	MSQDBRECTR	CHAR1	CHAR	1	0	RECURSIVE_TRIGGERS: enables recursive firing of triggers.
24	DEFLOCCUR	☐	MSQDBLOCDF	CHAR1	CHAR	1	0	CURSOR_DEFAULT LOCAL: cursor declarations default to LOCAL
25	QUOTEDID	☐	MSQDBQUTID	CHAR1	CHAR	1	0	Quoted identifier: " can be used to surround identifiers.
26	CCONCOMMIT	☐	MSQDBCURCM	CHAR1	CHAR	1	0	Cursor close on commit:any cursors open are closed on commit
27	ANSINULLS	☐	MSQDBNULL	CHAR1	CHAR	1	0	ANSI_NULLS: any comparisons to a NULL value evaluate to NULL
28	ANSIWARN	☐	MSQDBWARN	CHAR1	CHAR	1	0	ANSI_WARNINGS: null values in aggregate fcns, or divide by 0
29	FULLTXTEN	☐	MSQDBFLTXT	CHAR1	CHAR	1	0	Initializes fulltext indexing or removes all fulltext catalg
30	DBSUSPECT	☐	MSQDBSUSPC	CHAR1	CHAR	1	0	Database is marked as suspect.
31	DBSHUTDOWN	☐	MSQDBSHTDW	CHAR1	CHAR	1	0	Database encountered a problem during startup.
32	DBSTANDBY	☐	MSQDBSTDBY	CHAR1	CHAR	1	0	Database is functioning as a standby server.
33	ARITHABORT	☐	MSQDBARTA	CHAR1	CHAR	1	0	ARITHABORT: Terminates on overflow or divide-by-zero error.
34	NUMRNDABRT	☐	MSQDBRNDA	CHAR1	CHAR	1	0	NUMERIC_ROUNDABORT: error on loss of precision in expression
35	DBSIZE	☐	MSQDBSIZE		DEC	16	0	Database size in MB (data files).
36	DBFREE	☐	MSQDBFREE	INT4	INT4	10	0	Database free space in data files in MB.
37	DBUSED	☐	MSQDBUSED	INT4	INT4	10	0	Database used space in data files in MB.
38	LOGSIZE	☐	MSQLOGSIZE	INT4	INT4	10	0	Size of the database transaction log in MB.
39	LOGFREE	☐	MSQLOGFREE	INT4	INT4	10	0	Free space in database transaction log in MB .
40	LOGUSED	☐	MSQLOGUSED	INT4	INT4	10	0	Used space in database transaction log in MB.
41	DBNUMSAP	☐	MSQDBSAPPC	INT4	INT4	10	0	Number of connections to SAP database from SAP application.
42	DBNUMOTHER	☐	MSQDBNUMPC	INT4	INT4	10	0	Number of non-SAP processes connected to SAP database.
43	DBNDIFFUSE	☐	MSQDBNDUSR	INT4	INT4	10	0	Number of different users connected to SAP database

History

Last changed by/on	SAP	20110908
SAP Release Created in