Sorry for the messy of the following list. Copied it from somewhere. You can click on the post title to go to IBM site here.
Return Code SQL State Reason Code Description
80D3 -4977 Invalid export directory specified
80D4 -4978 Dropped table cannot be accessed
80D5 -4979 Unable to export the dropped table data
80D6 -1620 1 Unable to flush event monitor because it wasn't started
80D7 -1620 2 Unable to flush event monitor because it is running at a pre-version 6 output level
811E -996 Invalid user-specified directory
812F -290 Access not allowed: table space is quiesced
8130 -290 Access not allowed: table space is load-pending
8131 -290 Access not allowed: table space is delete-pending
8132 -290 Access not allowed: table space is backup-pending
8133 -290 Access not allowed: table space is rollforward-pending
8134 -290 Access not allowed: table space is rollforward-in-progress
8135 -290 Access not allowed: table space is recovery-pending
8136 -290 Access not allowed: table space is disabled
8137 -290 Access not allowed
8138 -291 Invalid state transition
8139 -294 Container is already being used
813A -295 Container names are too long
813B -297 Path name is too long
813C -298 Bad container path
813D -299 Duplicate container
813E -257 Raw device is not allowed
813F -258 Add containers pending
8146 -1442 Bad container size
8173 No dirty buffers
81A7 Invalid alternate
8201 +100 End of file reached
8203 -952 I/O Interrupt
8212 -804 Invalid request
8303 -952 Interrupt
8380 No term
8381 No interrupt
8382 No interrupt
8383 Incompatible release level
8384 Operation not supported
8385 Server/requester migration level incompatible
8386 ASP protocol error
8387 Bad ASP object OBJDSS
8388 Bad FDOCA object
8389 SNA protocol error
838A Invalid SQL request
838B Cursor already open
838C Cursor not open
838D Syntax error
838E Invalid FDOCA descriptor
8390 End of SQLDTAGRP
8394 Parameter Error
8395 Value Error
8396 SQLDA too small
8397 Invalid RPYDSS
8398 Parser syntax error
8399 FDOCA Error
839A End of input
839B Code point not found
839C SQLCODE set in parse
839D Data descriptor mismatch
839E Required parameter not received
839F Bad format
83A0 Duplicate parameters detected
83A3 Translation substitution
8401 +100 End of file reached
8403 -952 Interrupt
8404 -950 Active cursor
8406 -508 Invalid cursor position
842E -659 Check-pending state
8443 -804 General purpose validation error
844B -1477 Table not available because forward recovery encountered no log operation
8451 -680 Too many columns
8502 -911 Deadlock encountered
8503 -1044 Interrupt
8544 -911 Lock timeout with transaction rollback
8550 -913 Lock timeout with statement rollback
856D -902 SQLCA has been built and saved in a component-specific control block
8574 -1035 File open error
8575 -1015 Database needs recovery
8576 -1042 Deadlock start error
8577 Deadlock stop error
8578 -1034 Recovery failed
8579 Conditional conflict
85A1 Backup pending
85A2 Recovery pending
85A4 +993 Invalid new log path
85A5 +995 Invalid current log path
85A6 -1267 Exist file not found
85AA Table space rollforward stopped
85AB I/O error encountered
85AC Duplicate entry
85B3 Missing log extent
85B4 Log extent is of a different size
85B5 -1472 System clock difference exceeds max_time_diff on connect (log synchronization)
85B6 -1473 System clock difference exceeds max_time_diff on commit
85B7 +1474 System clock difference exceeds max_time_diff on commit (read-only)
85B8 -276 Restore pending
85B9 -1275 Invalid stop time for rollforward
85BA -1276 Invalid time to stop rollforward
85BB -4970 Rollforward is missing log files
85BC -4971 Rollforward log is already truncated
85BD -4972 Rollforward log path is full
85BE -4973 Rollforward log mismatch
85BF -4974 Rollforward query error
85C0 -4975 Rollforward cancelled
85C1 -4976 Rollforward not issued on catalog
85C3 -4906 Table space rollforward has invalid table space set
85C4 -1278 Table space rollforward required for rollback
85C5 -1280 Invalid stop time for table space rollforward
8659 Term characters not provided
865A Conversion table not loaded
865B No conversion table exists
865C Invalid target code page
865D Invalid source code page
865F -5123 Invalid code page
8660 -5124 Invalid country code
8661 -5125 Incompatible CP and CC
8662 Invalid stored procedure
8663 Invalid name
8664 Expired password
8665 Bad password
8666 User or group description over 8 characters
8667 User or group ID over 8 characters
8668 Password over 8 characters
8669 Bad group ID
866A Bad user ID
866E Not a descendant
866F SMG started in background
8670 Invalid thread ID
867F -10nn Dropped current directory
86A8 Range too large
86A9 Invalid user name
86AA Owner died
86AB Path error
86AC Programming error
86AD Exit list full
86AE Exit list not found
86AF Services not initialized
870B -138 Invalid SUBSTR parameter
8711 -910 Table or table space drop pending
8712 -804 Invalid request
8713 -804 Bad request context
8714 -804 Invalid section number
8719 -811 Non-unique answer
871D -994 Savepoint error
871E -996 Invalid directory, involving the path length of the REORG directory
874A -1476 Forced rollback on unit of work because of an error on number of log tables
876B Authorization error
876C Authorization with different ID
876D -902 SQLCA has been built and saved in a component-specific control block
877E RDS error
8803 -1044 Interrupt
8905 -803 Duplicate key
8971 Index scan incomplete
897A Index end of file
897B Index internal error
897D User ID suspended
8A72 Compilation error
8B07 -302 Output truncated
8B08 -413 Values out of range
8B09 -304 Conversion overflow converting date or time to character string
8B0A -303 Incompatible types
8B0C -309 Null input invalid
8B0D -305 Null output invalid
8B0E -804 Invalid output type
8B0F -822 Invalid input address
8B10 -802 Math overflow
8B15 -311 Negative SQLDA length
8B16 -301 Incompatible types (dynamic)
8B17 -180 Time or date syntax error
8B18 -181 Time or date range error
8B1A -404 String column overflow
8B1B -406 Numeric column overflow
8B1C -407 Non-nullable column
8B1F -183 Date/time arithmetic result out of range
8B20 -182 Date/time arithmetic duration out of range
8B21 -176 Translate scalar run-time error
8B22 -436 Null term missing on input CSTR
8B47 -304 Conversion overflow (numeric value)
8B48 -302 Numeric value out of range
8B49 -801 Divide by zero operation not allowed
8B4C -420 Invalid input format
8B4D -410 Float string too long
8B4E Null-only truncation
8B4F Date is truncated
8C03 -952 Interrupt
8C05 -803 Duplicate key
9301 Allocation failure
9302 Conversion failure
9303 Transaction processor (TP) not started
9304 TP limit reached
9305 Remote TP exit normal
9306 Allocation failed, attempting retry
9307 Allocation failed, no retry attempted
9308 General allocation error
9309 Conversion failed, no retry attempted
930A TP not started, no retry attempted
930B Remote TP abend
930C Communications Manager not loaded
930D Communications Manager abend
930E Bad security on conversation
930F Unknown APPC error
9310 Communications Manager parameter bad
9311 Communications Manager bad request state
9312 External communications error
9313 Remote TP send error
9332 Invalid name or name number
9333 Invalid session ID
9334 Invalid command
9335 Invalid data
9336 Adapter error
9337 Reset error
9338 Other NetBIOS error
9364 Node environment is corrupted
960C Communications Manager not loaded
960F Generic APPC error
9617 Already connected
9618 Connection in progress
9619 Connection refused
962A Connection timed out
962B Address already in use
962C No connection
962D Socket is bound already
962E Socket is not bound yet
962F Socket not writable/readable yet
9630 Partial message was sent
9631 Partial message was received
9C14 FCM communication error
9C15 FCM node not found
9C16 -1229 Node recovery
A602 -901 Invalid memory address
A603 -901 General memory management error
A604 -901 Memory management error: invalid size
AB01 -901 Internal error
AC01 -901 Internal program error
C107 -986 File error
C109 -8100 Segmented tables, page number too high
C119 -995 EMP indirect not found
C11A -995 EMP map information ended
C11B -995 EMP map information not found
C11C -996 Mapping information should exist, but cannot be found
C11D -292 Cannot create file
C11E -293 Container not accessible
C180 Agent file close error
C201 -970 Access denied
C211 Seek error
C212 Unknown media error
C213 File not found
C214 File already exists
C215 File in use
C216 Invalid file name
C217 Commit failed
C218 Undo failed
C40A -659 Maximum object size reached
C47E Index needs to be recreated
C47F File renamed
C57F File renamed
C601 -970 Access denied
C602 -972 Change disk
C603 -972 Not a DOS disk
C604 -974 Drive locked
C605 -976 Device not ready
C606 -978 File write-protected
C607 -986 File error
C608 -902 Delete directory error
C67C Device is busy
C721 -2423 Missing index during offline backup
C90A Maximum object size reached
CE0B -1614 1 Encountered an unknown event monitor target type
CE0C -1614 2 The event monitor target path was not sent
CE0D -1614 3 Access to event monitor target path was denied
CE0E -1614 4 Event monitor target path is not the name of a pipe
CE0F -1614 5 No process has opened the event monitor target pipe for reading
CE10 -1614 6 Encountered an unexpected I/0 error.
D085
21 Authentication failed due to no user licenses available
D107 -960 No more file tokens
D121 -289 Container full
D122 Exceeded maximum quiescers
D123 -296 Table space limit exceeded
D124 -259 Map too big
D20C -968 Disk full
D21A -930 No memory: UNDO heap
D315 No memory on requester
D316 No memory on server
D31D Vectored I/O request too big
D408 -962 Maximum tables in file
D40D -912 Too many locks
D411 -902 Maximum long field file size
D505 -930 Memory allocation failure
D509 -964 Log file full
D50A -912 Lock list full
D57F -1004 Disk full log file
D601 -954 No memory heap (for application)
D602 -956 No memory heap (for database)
D603 -101 No memory heap
D604 -930 Share buffer exceeded
D605 -930 Memory allocation failure
D606 -958 Too many open files
D607 -960 No more file tokens
D60B -955 No memory sort heap
D60C -968 Disk full
D60D -912 Too many locks
D60E -973 No memory
D610 -902 No memory BSU heap
D612 -953 No memory: AgentHeap
D613 -957, -959
No memory: ComHeap
D614 -961, -962
No memory: RSHeap
D615 No memory: Users/groups
D616 -930 No memory: DrIdx heap
D617 -930 No memory: ASP heap
D619 -930 No memory: Queue heap
D61A -930 No memory: UND heap
D61B -930 No memory: Lock heap
D61C -930 No memory: System heap
D61D -930 No memory
D61E -930 No memory
D620 -930 No memory
D625 -930 No memory
D62B -930 No memory
D67D Shared memory set exists
D67E -9 No memory for DosLoadMod
D905 -930 Memory allocation failure
D90F -990 Index structure problem
DC26 -6042 No FCM MSG_ANCHOR
DC27 -6040 No FCM buffer
DC28 -6041 No FCM connection entry
DC29 -6043 No FCM request block
DC2A -902 No high priority buffer
E101 -980 1 Bad page
E10A -980 10 File does not exist
E10E -982 Bad signature
E119 -1034 Page CHECKSUM error
E11A -1035 Bad database, won't flush it
E11B -980 27 Both primary and shadow ORFs are bad
E11C -980 28 Primary ORF is bad
E11D -980 29 Secondary ORF is bad
E11E -980 30 Both primary and shadow SSFs are bad
E11F -980 31 Primary SSF bad
E120 -980 32 Secondary SSF bad
E40B -980 11 Object does not exist
E50D -980 13 Bad log file
E510 -5123 Error in log control file
E511 -1258 Log control file not found
E512 -1259 I/O error accessing log control file
E513 -1260 Database not recoverable
E514 -1261 Recovery not pending
E515 -1263 Invalid log extent file
E516 -1264 Log extent file does not belong to the database
E517 -1265 Log extent file is the incorrect version
E518 -1266 Point in time prior to recovery
E521 -1034 Recovery failed
E522 -1269 Error while retrieving file during forward recovery
E57F -1036 Adjust log file error
E602 -980 2 CRC error
E603 -980 3 Disk error
E604 -980 4 General failure
E605 -980 5 Read fault
E606 -980 6 Seek error
E607 -980 7 Sector not found
E608 -980 8 Unknown media error
E609 -980 9 Write fault
E60A -980 10 File does not exist
E60C -980 12 Cannot open file
E60F -980 15 Network access denied
E623 -931 Too many open system files
F051 -1042 Invalid log record encountered during redo or undo: unknown component
F102 -902 2 BPS logic error
F103 -902 3 Invalid buffer pointer
F104 -902 4 No buffers
F109 -902 9 Data does not exist
F10A -902 10 File already exists
F10B -902 11 Unfixed buffer page
F10C -902 12 Invalid file token
F10D -902 13 Invalid file type
F110 -902 16 Invalid mode parameter
F117 -902 23 Invalid reference
F121 -902 33 RAM semaphore error
F124 -902 36 Bad configuration file
F136 -902 54 Bad header
F13B -902 59 File not found in the reorg linked list
F149 -902 73 Bad database path
F156 -902 86 Page already exists
F176 -902 118 Invalid pool ID
F17D State already off
F210 -902 16 Invalid mode parameter
F21B -902 27 Bad transaction ID
F225 -902 37 Invalid file handle
F331 -902 49 Bad selector
F33C -902 60 Tokenizer stack overflow
F345 The server STARTDBM failed
F34A -902 74 Node manager thread failed
F34B -902 75 Database is bad
F34C -902 76 Parser stack overflow
F34D -902 77 Token buffer overflow
F34E -902 78 Bad value in code page table
F34F -902 79 Configuration mismatch
F401 -902 1 DMS data file error
F418 -902 24 Bad table handle
F419 -902 25 Bad record ID
F42D -902 45 Reallocation error
F42E -902 46 Set signal error
F42F -902 47 Invalid mode
F432 -902 50 Floating point error
F451 -1042 Invalid log record encountered during redo or undo: bad record length
F455 -902 85 Program error
F47A -902 122 Record deleted
F47C -902 124 Missing defaults
F51B -902 27 Bad transaction ID
F51C -902 28 Log file overflow
F51D -902 29 Fatal logic error
F51E -902 30 No active transaction
F51F -902 31 Maximum save points
F520 -902 32 No active save point
F527 -902 39 Bad record type
F528 -902 40 Transaction ID table overflow
F529 -902 41 Invalid LSN
F52A -902 42 Transaction already started
F550 -902 80 Database in recovery mode
F605 -1068 Message file not found
F606 -1068 Message not found
F609 -902 9 Data does not exist
F60A -902 10 File already exists
F60B -902 11 Unfixed buffer page
F60C -902 12 Invalid file token
F60D -902 13 Invalid file type
F60E -902 14 Lock violation
F60F -902 15 Directory overflow
F610 -902 16 Invalid mode parameter
F611 -902 17 Invalid path
F612 -902 18 Invalid page number
F613 -902 19 Sector boundary error
F614 -902 20 System internal error
F616 -902 22 File sharing error
F617 -902 23 Invalid reference
F61A -902 26 Invalid selector
F621 -902 33 RAM semaphore error
F622 -902 34 Access error
F624 -902 36 Bad configuration file
F625 -902 37 Invalid file handle
F626 -902 38 No file descriptor
F631 -902 49 Bad selector
F635 -902 53 Conditional failure
F637 -902 55 Infinite retry
F638 -902 56 Stored procedure not found
F639 -902 57 Invalid drive
F63A -902 58 Bad heap ID
F63D -902 61 Duplicate queue
F63E -902 62 Bad queue handle
F63F -902 63 Queue message too big
F640 -902 64 No message in queue
F641 -902 65 Message not sent
F642 -902 66 Queue does not exist
F643 -902 67 Max queue limit
F644 -902 68 Invalid queue name
F690 DB2NODE environment variable has a bad value
F691 The db2nodes.cfg file contains an error
F730 -902 48 Invalid file
F733 -902 51 Invalid compile request
F85F -902 95 Generic LOB manager error
F860 -902 96 Cannot redo operation
F861 -902 97 Beginning segment (BSEG) already trimmed
F862 -902 98 Insufficient space
F863 -902 99 No mini directory
F864 -902 100 Invalid LM descriptor
F865 -902 101 Invalid address
F866 -902 102 LF space exhausted
F867 -902 103 BSEG size/address conflict
F868 -902 104 BSEG not free or allocated
F869 -902 105 Incorrect BSEG size
F86A -902 106 BSEG not free
F86B -902 107 Bad count array
F86C -902 108 Lock error
F86D -902 109 Not found error
F86E -902 110 Value out of bounds
F86F -902 111 Unexpected NULL value
F870 -902 112 Encountered fatal error
F871 -902 113 Bad state
F872 -902 114 Request too big
F873 No slots for threads
F874 Thread not waiting
F875 Owner died
F87B Too many active threads
F912 -902 18 Invalid page number
F915 -902 21 Memory allocation error
F92B -902 43 Index token does not exist
F92C -902 44 Key not found
F952 -902 82 SMP problems
F953 -902 83 Invalid database release
F954 -902 84 Program error
FB2E -902 46 Set signal error
FC07 -902 7 Severe internal error
FC21 -902 33 RAM semaphore error
FC7E -902 126 Component interface error
FC7F -902 127 FCM programming error
FC80 -902 128 FCM daemon not available
FC81 -902 129 FCM node configuration file error
FC88 -902 136 BDS communication error
FC89 -902 137 BDS partner error
FC8F -1445 No Context
FD8A -902 138 Invalid partition map ID
FD8B -902 139 Not able to fetch from catalog
FD8C -902 140 Invalid data type
FD8D Invalid partition number
FD8E PMAP is of a 1-node nodegroup
More information on interpreting db2diag.log entries.
Posts
No comments:
Post a Comment