|
对于db2diag.log里面的zrc的某些错误的简单描述,可以在这里找到
Table . DB2 Internal Return Codes
Internal 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 |
|