SAP ABAP Message Class DB6 (DB6: Alert Monitoring and Alert Configuration)

Basic Data

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB6 (Application Component) DB2 Universal Database for UNIX / NT
     ⤷ STU6 (Package) DB6: Performance-Monitor (UNIX/Windows)

Attributes

Message class	DB6
Short Description	DB6: Alert Monitoring and Alert Configuration
Changed On	20130531
Last Changed At	091009

Messages

#	Message	Message Short Text	Documentation status	Authorization check
1	022	No configuration entry exists for the reported value	Space: object requires documentation	☐
2	025	Not supported	The short text describes the object sufficiently	☐
3	100	Database buffer pool	Space: object requires documentation	☐
4	101	Buffering quality	Space: object requires documentation	☐
5	102	The buffer pool hit ratio is too low	Space: object requires documentation	☐
6	103	Buffer pool configuration	Space: object requires documentation	☐
7	104	The buffer pool size is &1	Space: object requires documentation	☐
8	105	DB configuration parameter BUFFPAGE is active	Space: object requires documentation	☐
9	107	Performance-relevant database buffers	Space: object requires documentation	☐
10	108	Catalog cache: Buffering of table description data	Space: object requires documentation	☐
11	109	The catalog cache hit ratio is too low	Space: object requires documentation	☐
12	110	Package cache: Buffering package information for SQL statements	Space: object requires documentation	☐
13	111	The package cache hit ratio is too low	Space: object requires documentation	☐
14	112	Sort heap: Number of sort overflows per day	Space: object requires documentation	☐
15	113	Too many overflows occur in the sort heap	Space: object requires documentation	☐
16	114	Application lock behavior	Space: object requires documentation	☐
17	115	Number of deadlocks per day	Space: object requires documentation	☐
18	116	Too many deadlocks occur in the system	Space: object requires documentation	☐
19	117	Number of lock escalations per hour	Space: object requires documentation	☐
20	118	Too many lock escalations occur in the system	Space: object requires documentation	☐
21	119	Number of exclusive lock escalations per hour	Space: object requires documentation	☐
22	120	Too many exclusive lock escalations occur in the system	Space: object requires documentation	☐
23	121	Number of lock timeouts per hour	Space: object requires documentation	☐
24	122	Too many lock timeouts occur in the system	Space: object requires documentation	☐
25	123	Number of lock waits per hour	Space: object requires documentation	☐
26	124	Too many lock waits occur in the system	Space: object requires documentation	☐
27	125	Measures to optimize performance	Space: object requires documentation	☐
28	126	Time passed since last table statistics update	Space: object requires documentation	☐
29	127	The table statistics are current	Space: object requires documentation	☐
30	128	The table statistics are no longer current	Space: object requires documentation	☐
31	129	So far no table statistics have run without errors	Space: object requires documentation	☐
32	130	Time passed since last table reorganization	Space: object requires documentation	☐
33	131	The tables have been reorganized	Space: object requires documentation	☐
34	132	The last table reorganization is too far back in time	Space: object requires documentation	☐
35	133	So far no tables have been reorganized successfully	Space: object requires documentation	☐
36	134	Maximum table change rate since the last statistics update	Space: object requires documentation	☐
37	135	The change rate is low for all tables	Space: object requires documentation	☐
38	136	Table &1 has a change rate of &2 percent	Space: object requires documentation	☐
39	137	Table &1 has a change rate of &2 percent; statistics update needed	Space: object requires documentation	☐
40	138	Maximum number of overflow page accesses since last REORG	Space: object requires documentation	☐
41	139	The number of overflow pages is low for all tables	Space: object requires documentation	☐
42	140	Table &1 has more than &2 percent of overflow page accesses	Space: object requires documentation	☐
43	141	Table &1 has more than &2 percent of overflow page accesses, REORG needed	Space: object requires documentation	☐
44	142	SAP traces	Space: object requires documentation	☐
45	143	Status of developer trace	Space: object requires documentation	☐
46	144	Developer trace is deactivated	Space: object requires documentation	☐
47	145	Developer trace is activated	Space: object requires documentation	☐
48	147	Status of cumulative DSBL trace	Space: object requires documentation	☐
49	148	Cumulative DBSL trace is deactivated	Space: object requires documentation	☐
50	149	Cumulative DBSL trace is activated	Space: object requires documentation	☐
51	151	Distribution of the IO cleaners in percent	Space: object requires documentation	☐
52	152	Percentage of the pool logspace cleaners	Space: object requires documentation	☐
53	153	The percentage of the pool logspace cleaners is too low	Space: object requires documentation	☐
54	154	Percentage of the dirty page steal cleaners	Space: object requires documentation	☐
55	155	The percentage of the dirty page steal cleaners is too high	Space: object requires documentation	☐
56	156	Percentage of the dirty page threshold cleaners	Space: object requires documentation	☐
57	157	The percentage of the dirty page threshold cleaners is too high	Space: object requires documentation	☐
58	158	Sort heap: Percentage of overflows during sort processing	Space: object requires documentation	☐
59	159	Percentage of overflows is &1 percent	Space: object requires documentation	☐
60	200	Database backup	Space: object requires documentation	☐
61	201	Time passed since last successful backup	Space: object requires documentation	☐
62	202	The last database backup is current	Space: object requires documentation	☐
63	203	The last database backup is too far back in time	Space: object requires documentation	☐
64	204	So far no database backup has been performed successfully	Space: object requires documentation	☐
65	205	Log files	Space: object requires documentation	☐
66	206	State of the DB2 user exits	Space: object requires documentation	☐
67	207	The user exit is active	Space: object requires documentation	☐
68	208	The user exit is functioning, but errors have occurred	Space: object requires documentation	☐
69	209	The user exit is not active	Space: object requires documentation	☐
70	210	State of the archiving program for the log files	Space: object requires documentation	☐
71	211	Archiving is functioning normally	Space: object requires documentation	☐
72	212	Archiving is functioning normally, but errors have occurred	Space: object requires documentation	☐
73	213	Archiving is not functioning	Space: object requires documentation	☐
74	214	Completeness of the log files for a recovery	Space: object requires documentation	☐
75	215	All log files exist or have been archived successfully	Space: object requires documentation	☐
76	217	Log files are missing or have not been archived successfully	Space: object requires documentation	☐
77	218	State of the AdminDB	Space: object requires documentation	☐
78	219	Availability and installation of the AdminDB	Space: object requires documentation	☐
79	220	The AdminDB is available	Space: object requires documentation	☐
80	222	The AdminDB is not available or has not been installed successfully	Space: object requires documentation	☐
81	223	Mirroring of the AdminDB contents to the SAP System	Space: object requires documentation	☐
82	224	The mirrored AdminDB data is current	Space: object requires documentation	☐
83	225	The mirrored AdminDB data is no longer current	Space: object requires documentation	☐
84	226	So far no data of the AdminDB have been mirrored	The short text describes the object sufficiently	☐
85	227	Online backup	Space: object requires documentation	☐
86	228	No online backup is running	Space: object requires documentation	☐
87	229	Online backup is running	Space: object requires documentation	☐
88	231	Log directory was changed after database restart	Space: object requires documentation	☐
89	232	Log directory has not been changed	Space: object requires documentation	☐
90	233	At the next database restart a new log directory will be used	Space: object requires documentation	☐
91	300	Objects defined in the ABAP Dictionary that are missing in the database	Space: object requires documentation	☐
92	301	Database tables	Space: object requires documentation	☐
93	302	All tables are defined in the ABAP Dictionary	Space: object requires documentation	☐
94	303	The &1 table is not defined in the ABAP Dictionary	Space: object requires documentation	☐
95	305	Database indexes	Space: object requires documentation	☐
96	306	All indexes have been created	Space: object requires documentation	☐
97	307	The &2 index defined on table &1 has not been created	Space: object requires documentation	☐
98	309	Objects defined in the database that are missing in the ABAP Dictionary	Space: object requires documentation	☐
99	310	SAP tables	Space: object requires documentation	☐
100	311	All tables have been created in the database	Space: object requires documentation	☐
101	312	The &1 table has not been created in the database	Space: object requires documentation	☐
102	314	Secondary key	Space: object requires documentation	☐
103	315	All secondary keys have been created in the database	Space: object requires documentation	☐
104	316	The secondary key &2 defined on table &1 is missing	Space: object requires documentation	☐
105	318	Inconsistencies between the database and the SAP definition	Space: object requires documentation	☐
106	319	Tables	Space: object requires documentation	☐
107	320	All tables are consistent	Space: object requires documentation	☐
108	321	The descriptions of table &1 in the DB and ABAP Dictionary are different	Space: object requires documentation	☐
109	323	Indexes	Space: object requires documentation	☐
110	324	All indexes are consistent	Space: object requires documentation	☐
111	325	The description of index &1 of table &2 is different	Space: object requires documentation	☐
112	327	Tablespaces	Space: object requires documentation	☐
113	328	All tablespaces are consistent	Space: object requires documentation	☐
114	329	The descriptions of TS &1 in the DB and ABAP Dictionary are different	Space: object requires documentation	☐
115	400	Check progam to prepare the selective statistics update	Space: object requires documentation	☐
116	401	Time passed since last successful job run	Space: object requires documentation	☐
117	402	Job ran successfully	Space: object requires documentation	☐
118	403	The last job run is too far back in time	Space: object requires documentation	☐
119	404	So far the job has not run successfully	Space: object requires documentation	☐
120	405	Job scheduling	Space: object requires documentation	☐
121	406	The job has been scheduled correctly	Space: object requires documentation	☐
122	407	The jobs are scheduled too far apart	Space: object requires documentation	☐
123	408	The job is not scheduled	Space: object requires documentation	☐
124	409	Runtime fluctuations	Space: object requires documentation	☐
125	410	The job runtimes fluctuate within the specified range	Space: object requires documentation	☐
126	411	The job runtimes are fluctuating considerably	Space: object requires documentation	☐
127	412	The fluctuation range of the runtimes is too high	Space: object requires documentation	☐
128	413	Statistics update for all tables of the SAP System	Space: object requires documentation	☐
129	414	Statistics update for critical tables of the SAP System	Space: object requires documentation	☐
130	415	Reorganization of database tables	Space: object requires documentation	☐
131	416	Archiving of log files	Space: object requires documentation	☐
132	417	Deletion of archived log files	Space: object requires documentation	☐
133	418	Mirroring of the AdminDB contents to the SAP System	Space: object requires documentation	☐
134	419	Database backup	Space: object requires documentation	☐
135	420	DB2 for Linux, UNIX, and Windows: System check	Space: object requires documentation	☐
136	500	DB2 for Linux, UNIX, and Windows: System check	Space: object requires documentation	☐
137	501	Time passed since last successful check run	Space: object requires documentation	☐
138	502	The last check is current	Space: object requires documentation	☐
139	503	The last check is too far back in time	Space: object requires documentation	☐
140	504	So far no check has been completed successfully	Space: object requires documentation	☐
141	505	Messages logged during the database system check	Space: object requires documentation	☐
142	506	Information: &1	Space: object requires documentation	☐
143	507	Warning: &2	Space: object requires documentation	☐
144	508	Error: &3	Space: object requires documentation	☐
145	509	Important configuration parameters of the database manager	Space: object requires documentation	☐
146	510	Database monitor settings	Space: object requires documentation	☐
147	511	Buffer pool monitoring	Space: object requires documentation	☐
148	512	The DFT_MON_BUFPOOL switch is set	Space: object requires documentation	☐
149	513	The DFT_MON_BUFPOOL switch is not set	Space: object requires documentation	☐
150	514	An invalid value has been returned for the DFT_MON_BUFPOOL switch	Space: object requires documentation	☐
151	515	Lock behavior monitoring	Space: object requires documentation	☐
152	516	The DFT_MON_LOCK switch is set	Space: object requires documentation	☐
153	517	The DFT_MON_LOCK switch is not set	Space: object requires documentation	☐
154	518	An invalid value has been returned for the DFT_MON_LOCK switch	Space: object requires documentation	☐
155	519	Sort heap monitoring	Space: object requires documentation	☐
156	520	The DFT_MON_SORT switch is set	Space: object requires documentation	☐
157	521	The DFT_MON_SORT switch is not set	Space: object requires documentation	☐
158	522	An invalid value has been returned for the DFT_MON_SORT switch	Space: object requires documentation	☐
159	523	Statement cache monitoring	Space: object requires documentation	☐
160	524	The DFT_MON_STMT switch is set	Space: object requires documentation	☐
161	525	The DFT_MON_STMT switch is not set	Space: object requires documentation	☐
162	526	An invalid parameter value has been returned for the DFT_MON_STMT switch	Space: object requires documentation	☐
163	527	Table access monitoring	Space: object requires documentation	☐
164	528	The DFT_MON_TABLE switch is set	Space: object requires documentation	☐
165	529	The DFT_MON_TABLE switch is not set	Space: object requires documentation	☐
166	530	An invalid value has been returned for the DFT_MON_TABLE switch	Space: object requires documentation	☐
167	531	Monitoring of the UOWs (Unit of Work)	Space: object requires documentation	☐
168	532	The DFT_MON_UOW switch is set	Space: object requires documentation	☐
169	533	The DFT_MON_UOW switch is not set	Space: object requires documentation	☐
170	534	An invalid value has been reported for the DFT_UOW switch	Space: object requires documentation	☐
171	535	Diagnosis	Space: object requires documentation	☐
172	536	Database error log scope	Space: object requires documentation	☐
173	537	Errors and warnings are logged	Space: object requires documentation	☐
174	538	Too many or too few diagnosis messages have been logged	Space: object requires documentation	☐
175	540	Important configuration parameters of the database engine	Space: object requires documentation	☐
176	541	Performance-relevant parameters	Space: object requires documentation	☐
177	542	Time interval to determine deadlock situations	Space: object requires documentation	☐
178	543	The DLCHKTIME parameter value is low enough	Space: object requires documentation	☐
179	544	Der DLCHKTIME parameter value is too high	Space: object requires documentation	☐
180	546	Threshold for starting the asynchronous page cleaners	Space: object requires documentation	☐
181	547	Der CHNGPGS_THRESH parameter value is within the valid range	Space: object requires documentation	☐
182	548	Der CHNGPGS_THRESH parameter value is out of range	Space: object requires documentation	☐
183	550	Time frame to resolve lock situations	Space: object requires documentation	☐
184	551	Der LOCKTIMEOUT parameter value is in the valid range	Space: object requires documentation	☐
185	552	The LOCKTIMEOUT parameter value is out of recommended range	Space: object requires documentation	☐
186	553	The LOCKTIMEOUT parameter is not set	Space: object requires documentation	☐
187	554	Logging-relevant parameters	Space: object requires documentation	☐
188	555	Ensuring roll forward recovery	Space: object requires documentation	☐
189	556	The LOGRETAIN parameter is set	Space: object requires documentation	☐
190	557	The LOGRETAIN parameter is not set	Space: object requires documentation	☐
191	558	An invalid value has been returned for the LOGRETAIN parameter	Space: object requires documentation	☐
192	559	Activation of the user exit	Space: object requires documentation	☐
193	560	The USEREXIT parameter is set	Space: object requires documentation	☐
194	561	The USEREXIT parameter is not set	Space: object requires documentation	☐
195	562	An invalid value has been returned for the USEREXIT parameter	Space: object requires documentation	☐
196	563	Soft checkpoints control	Space: object requires documentation	☐
197	564	The SOFTMAX parameter is within the valid range	Space: object requires documentation	☐
198	565	The SOFTMAX parameter is out of range	Space: object requires documentation	☐
199	567	State or availability of the tablespaces	Space: object requires documentation	☐
200	568	Availability of the tablespace and its containers	Space: object requires documentation	☐
201	569	Status of the tablespace	Space: object requires documentation	☐
202	570	The tablespace is available	Space: object requires documentation	☐
203	571	The tablespace is not available. Status = &1	Space: object requires documentation	☐
204	573	Status of the container	Space: object requires documentation	☐
205	574	The container is available	Space: object requires documentation	☐
206	575	The container is not available	Space: object requires documentation	☐
207	576	An invalid status value has been reported for the container	Space: object requires documentation	☐
208	577	State of database-specific file systems	Space: object requires documentation	☐
209	578	State of the log directory	Space: object requires documentation	☐
210	579	The log directory is available	Space: object requires documentation	☐
211	580	The log directory is not available	Space: object requires documentation	☐
212	582	State of the log archive	Space: object requires documentation	☐
213	583	The log archive is available	Space: object requires documentation	☐
214	584	The log archive is not available	Space: object requires documentation	☐
215	586	Log files of the database system	Space: object requires documentation	☐
216	587	Entries in the DB2 diag log	Space: object requires documentation	☐
217	588	Entries in the DB2 alert log	Space: object requires documentation	☐
218	589	Log files of the user exit	Space: object requires documentation	☐
219	590	Entries in the user exit log	Space: object requires documentation	☐
220	591	Entries in the user exit error log	Space: object requires documentation	☐
221	592	High-water marks	Space: object requires documentation	☐
222	593	Maximum fill level of the primary log files	Space: object requires documentation	☐
223	594	No storage shortages in the primary log file	Space: object requires documentation	☐
224	595	The primary log file may overflow	Space: object requires documentation	☐
225	596	The primary log file is full	Space: object requires documentation	☐
226	597	Maximum fill level of the secondary log files	Space: object requires documentation	☐
227	598	No storage shortages in the secondary log file	Space: object requires documentation	☐
228	599	The secondary log file may overflow	Space: object requires documentation	☐
229	600	The secondary log file is full	Space: object requires documentation	☐
230	601	Automatic reorganization of log tables	Space: object requires documentation	☐
231	602	Deletion of old entries in the alert message log	Space: object requires documentation	☐
232	603	Old entries have been deleted	Space: object requires documentation	☐
233	604	Old entries have not been deleted	Space: object requires documentation	☐
234	606	Deletion of old data collector entries	Space: object requires documentation	☐
235	607	Resetting old RUNSTATS check control table entries	Space: object requires documentation	☐
236	608	No old entries exist	Space: object requires documentation	☐
237	609	Old entries have been reset	Space: object requires documentation	☐
238	613	Maximum fill level of the database heap	Space: object requires documentation	☐
239	614	No storage shortages in the database heap	Space: object requires documentation	☐
240	615	The database heap may overflow	Space: object requires documentation	☐
241	616	The database heap is full	Space: object requires documentation	☐
242	617	Current resource consumption	Space: object requires documentation	☐
243	618	Current fill level of the log files	Space: object requires documentation	☐
244	619	Too many log files are full	Space: object requires documentation	☐
245	620	Technical restrictions of the database	Space: object requires documentation	☐
246	621	Maximum size of a tablespace	Space: object requires documentation	☐
247	622	The tablespace has almost reached its maximum size	Space: object requires documentation	☐
248	623	Maximum size of the log file	Space: object requires documentation	☐
249	624	The log file has almost reached its maximum size	Space: object requires documentation	☐
250	625	Current lock list usage	Space: object requires documentation	☐
251	626	The lock list contains too many locks	Space: object requires documentation	☐
252	627	Current database heap usage	Space: object requires documentation	☐
253	628	There is not enough free space in the database heap	Space: object requires documentation	☐
254	629	Database-specific kernel information	Space: object requires documentation	☐
255	630	Archiving of log files	Space: object requires documentation	☐
256	631	Redirected restore tool	Space: object requires documentation	☐
257	632	Restore of archived log files during recovery	Space: object requires documentation	☐
258	633	User exit for archiving log files	Space: object requires documentation	☐
259	634	Data collector for performance and alert monitor	Space: object requires documentation	☐
260	635	Reorganization of tablespaces	Space: object requires documentation	☐
261	636	Snapshot information	Space: object requires documentation	☐
262	637	Update statistics and reorganization check	Space: object requires documentation	☐
263	638	Tablespace and container configuration	Space: object requires documentation	☐
264	639	History of database backups	Space: object requires documentation	☐
265	640	Installation program of the AdminDB	Space: object requires documentation	☐
266	641	Mirroring of the AdminDB to the SAP System	Space: object requires documentation	☐
267	642	Command line processor interface	Space: object requires documentation	☐
268	643	Release &1 / platform &2 / &3 patch level &4	Space: object requires documentation	☐
269	645	Unable to execute program. Reason: &1	Space: object requires documentation	☐
270	646	Database backup using the DBA Planning Calendar	Space: object requires documentation	☐
271	647	User-defined functions installed on the database	Space: object requires documentation	☐
272	648	Configuration data of the file systems	Space: object requires documentation	☐
273	649	The function has been cataloged	Space: object requires documentation	☐
274	651	The function has not been cataloged	Space: object requires documentation	☐
275	652	Execution of operating system commands	Space: object requires documentation	☐
276	653	Settings of DB2-specific environment variables	Space: object requires documentation	☐
277	654	Path name of the log archive	Space: object requires documentation	☐
278	655	Value &1	Space: object requires documentation	☐
279	657	Environment variable not set	Space: object requires documentation	☐
280	659	Maximum number of objects in a tablespace	The short text describes the object sufficiently	☐
281	660	The tablespace has almost reached its maximum number of objects	The short text describes the object sufficiently	☐
282	661	Error messages from db2diag.log	The short text describes the object sufficiently	☐
283	662	Error message from db2diag.log	The short text describes the object sufficiently	☐
284	663	Informational message	The short text describes the object sufficiently	☐
285	664	Warning message	The short text describes the object sufficiently	☐
286	665	Error message	The short text describes the object sufficiently	☐
287	666	Warning messages from db2diag.log	The short text describes the object sufficiently	☐
288	667	Warning message from db2diag.log	The short text describes the object sufficiently	☐
289	668	Threshold violations	The short text describes the object sufficiently	☐
290	669	Thrshold predicate	The short text describes the object sufficiently	☐
291	670	No threshold violations	The short text describes the object sufficiently	☐
292	671	Threshold violation	The short text describes the object sufficiently	☐
293	700	Monitoring the disk space of DMS tablespaces	Space: object requires documentation	☐
294	701	Disk space usage of the tablespace in percent	Space: object requires documentation	☐
295	702	Not enough free space available	Space: object requires documentation	☐
296	703	Monitoring the disk space of database file systems	Space: object requires documentation	☐
297	704	Disk space usage of the file system in which the log directory is located	Space: object requires documentation	☐
298	705	Disk space usage of the file system in which the log archive is located	Space: object requires documentation	☐
299	706	Monitoring the disk space usage of SMS tablespaces	Space: object requires documentation	☐
300	707	Monitoring the disk space usage of the SMS tablespace containers	Space: object requires documentation	☐
301	708	Disk space usage of the file system in which the container is located	Space: object requires documentation	☐
302	709	Disk space usage of storage paths	The short text describes the object sufficiently	☐
303	710	Disk space usage of the file system in which the DB directory is located	The short text describes the object sufficiently	☐
304	711	Primary log usage (> 100% means secondary log files allocated)	The short text describes the object sufficiently	☐
305	712	Primary log is full (> 100% means secondary log files allocated)	The short text describes the object sufficiently	☐
306	800	Status of Remote Connection	Space: object requires documentation	☐

History

Last changed on/by	20130531	SAP
SAP Release Created in