|
|
|
The CA MICS DB2 Analyzer includes predefined exception routines that can alert the data center staff of situations affecting the operation of DB2. These routines can be modified or deleted as needed. In addition, other exceptions can be added. This section lists the standard exceptions provided for the DB2 Information Area. The exceptions are listed by their exception number, and with their severity level, management area code, and descriptive title. The DB2 exceptions are listed in Figure 4-3.
+--------+------------+-----------------+-----------------------------------------+ | Number | Severity | Management Area | Exception Description | +--------+------------+-----------------+-----------------------------------------+ | 10000 | Warning | Security | Instrumentation Buffer Error | | 10001 | Warning | Security | Instrumentation Not Active Error | | 10002 | Warning | Security | Instrumentation Record Not Accepted | | 10003 | Warning | Security | Instrumentation Writer Failure | | 10004 | Warning | Security | Instrumentation Record Unsuccessful | | 10005 | Warning | Security | System IFCID Record Not Written | | 10006 | Warning | Security | System IFCID Record Not Desired | | 10007 | Warning | Security | System IFCID Buffer Not Available | | 10008 | Warning | Security | System IFCID Collection Failure | | 10009 | Warning | Security | Data Base IFCID Record Not Written | | 10010 | Warning | Security | Data Base IFCID Record Not Desired | | 10011 | Warning | Security | Data Base IFCID Buffer Not Available | | 10012 | Warning | Security | Data Base IFCID Collection Failure | | 10013 | Warning | Security | User IFCID Record Not Written | | 10014 | Warning | Security | User IFCID Record Not Desired | | 10015 | Warning | Security | User IFCID Buffer Not Available | | 10016 | Warning | Security | User IFCID Collection Failure | | 10017 | Warning | Productivity | Successful Abort | | 10018 | Warning | Productivity | Indoubt Thread | | 10019 | Warning | Productivity | End Of Task ABEND | | 10020 | Warning | Productivity | End Of Memory | | 10021 | Warning | Performance | Start Data Base Command | | 10022 | Warning | Performance | Start Trace Command | | 10023 | Warning | Performance | Start DB2 Command | | 10024 | Warning | Performance | Stop Data Base Command | | 10025 | Warning | Performance | Stop Trace Command | | 10026 | Warning | Performance | Stop DB2 Command | | 10027 | Warning | Performance | Unavailable Resource Failure | | 10028 | Warning | Performance | Allocation Deadlock Failure | | 10029 | Warning | Performance | Invalid Resource Failure | | 10030 | Warning | Performance | Error Return From GETMAIN/FREEMAIN | | 10031 | Warning | Performance | Short On Storage Contraction | | 10032 | Warning | Performance | Short Of Storage | | 10033 | Warning | Performance | Shortage Of Storage ABEND | | 10034 | Warning | Performance | Resident Trace Turned On | | 10035 | Warning | Performance | Resident Trace Turned Off | | 10036 | Warning | Performance | GTF Trace Turned On | | 10037 | Warning | Performance | GTF Trace Turned Off | | 10038 | Warning | Performance | Local Trace Turned On | | 10039 | Warning | Performance | Local Trace Turned Off | | 10040 | Warning | Performance | Reads Delayed For Archive Allocation | | 10041 | Warning | Performance | ICF Checkpoints Taken | | 10042 | Warning | Security | Instrumentation Buffer Error | | 10043 | Warning | Security | Instrumentation Buffer Error | | 10044 | Warning | Security | Instrumentation Buffer Error | | 10045 | Warning | Security | Instrumentation Buffer Error | | 10046 | Warning | Security | Instrumentation Not Active Error | | 10047 | Warning | Security | Instrumentation Not Active Error | | 10048 | Warning | Security | Instrumentation Not Active Error | | 10049 | Warning | Security | Instrumentation Not Active Error | | 10050 | Warning | Performance | Create Tablespace Statement | | 10051 | Warning | Performance | Create Data Base Statement | | 10052 | Warning | Performance | Drop Tablespace Statement | | 10053 | Warning | Performance | Drop Data Base Statement | | 10054 | Warning | Performance | Allocate Requests Nonexistent Plan | | 10055 | Warning | Performance | Binds Without Plan ID | | 10056 | Warning | Performance | Maximum Size Expansion Failure Buffer 0 | | 10057 | Warning | Performance | Storage Shortage Expansion Failure Buf0 | | 10058 | Warning | Performance | Maximum Size Expansion Failure Buffer 1 | | 10059 | Warning | Performance | Storage Shortage Expansion Failure Buf1 | | 10060 | Warning | Performance | Maximum Size Expansion Failure Buffer 2 | | 10061 | Warning | Performance | Storage Shortage Expansion Failure Buf2 | | 10062 | Warning | Performance | Maximum Size Expansion Failure Buffer 3 | | 10063 | Warning | Performance | Storage Shortage Expansion Failure Buf3 | | 10064 | Warning | Performance | Read Pagefixed Without Real Storage B0 | | 10065 | Warning | Performance | Write Pagefixed Without Real Storage B0 | | 10066 | Warning | Performance | Read Pagefixed Without Real Storage B1 | | 10067 | Warning | Performance | Write Pagefixed Without Real Storage B1 | | 10068 | Warning | Performance | Read Pagefixed Without Real Storage B2 | | 10069 | Warning | Performance | Write Pagefixed Without Real Storage B2 | | 10070 | Warning | Performance | Read Pagefixed Without Real Storage B3 | | 10071 | Warning | Performance | Write Pagefixed Without Real Storage B3 | | 10072 | Warning | Performance | NO. Lock Escalations Exclusive Mode | | 10073 | Warning | Performance | Maximum Page Locks Held | | 10074 | Warning | Performance | Prefetch Request Disabled No Buffers 0 | | 10075 | Warning | Performance | Prefetch Disabled No Read Engine Buf 0 | | 10076 | Warning | Performance | NO. Times Write Engine Unavailable Buf 0| | 10077 | Warning | Performance | NO. Times Deferred Write threshold Buf 0| | 10078 | Warning | Performance | NO. Times WPHFWT Threshold Reached Buf 0| | 10079 | Warning | Performance | Prefetch Request Disabled No Buffers 1 | | 10080 | Warning | Performance | Prefetch Disabled No Read Engine Buf 1 | | 10081 | Warning | Performance | NO. Times Write Engine Unavailable Buf 1| | 10082 | Warning | Performance | NO. Times Deferred Write Threshold Buf 1| | 10083 | Warning | Performance | NO. Times WPHFWT Threshold Reached Buf 0| | 10084 | Warning | Performance | Prefetch Disabled Due to No Buffers 2 | | 10085 | Warning | Performance | Prefetch Disabled No Read Engine Buf 2 | | 10086 | Warning | Performance | NO. Times Write Engine Unavailable Buf 2| | 10087 | Warning | Performance | NO. Times Deferred Write Threshold Buf 2| | 10088 | Warning | Performance | NO. Times WPHFWT Threshold Reached Buf 2| | 10089 | Warning | Performance | Prefetch Request Disabled No Buffers 3 | | 10090 | Warning | Performance | Prefetch Disabled No Read Engine Buf 3 | | 10091 | Warning | Performance | NO. Times Write Engine Unavailable Buf 3| | 10092 | Warning | Performance | NO. Times Deferred Write Threshold Buf 3| | 10093 | Warning | Performance | NO. Times WPHFWT Threshold Reached Buf 3| | 10094 | Warning | Performance | NO. Failures Due to Full EDM Pool | | 10095 | Warning | Security | Instrumentation Record Not Accepted | | 10096 | Warning | Security | Instrumentation Record Not Accepted | | 10097 | Warning | Security | Instrumentation Record Not Accepted | | 10098 | Warning | Security | Instrumentation Record Not Accepted | | 10099 | Warning | Security | Instrumentation Writer Failure | | 10100 | Warning | Security | Instrumentation Writer Failure | | 10101 | Warning | Security | Instrumentation Writer Failure | | 10102 | Warning | Security | Instrumentation Writer Failure | | 10103 | Warning | Security | Instrumentation Record Unsuccessful | | 10104 | Warning | Security | Instrumentation Record Unsuccessful | | 10105 | Warning | Security | Instrumentation Record Unsuccessful | | 10106 | Warning | Security | Instrumentation Record Unsuccessful | +--------+------------+-----------------+-----------------------------------------+
Figure 4-3. DB2 Exception List
| Copyright © 2012 CA. All rights reserved. | Tell Technical Publications how we can improve this information |