DB2 Server for VSE: Messages and Codes
Bad DBSS Call Parameters
- -1 ILOPCODE
- Illegal OPCODE on DBSS call
- -2 ILLEGALP
- Illegal parameter (PARAMS) pointer on DBSS call (0, or not word/doubleword
aligned).
Illegal parameters for BASE. Some codes also used by
CBASE, SBASE.
- -3 ISEGMENT
- Illegal DBSPACE number, missing SCR, or type conflict with operator
- -4 ILLRID
- Illegal table ID or illegal operation for list
- -5 NFTID
- TID not found or open of an empty table or list
- -6 ILLPSEGM
- Illegal parent DBSPACE number
- -7 ILLPRID
- Illegal PRID or illegal operation for list
- -8 NFPTID
- PTID not found
- -9 ILSCANID
- Illegal scan ID
- -10 INKEYDOM
- Illegal number of key fields
- -11 ILLKPTR
- Illegal address of KDOMAINS
- -12 INREQDOM
- Illegal number of DOMAINS fields
- -13 ILLDPTR
- Illegal address of DOMAINS
- -14 INSARGS
- Illegal number of search arguments
- -15 ILLSPTR
- Illegal address of search arguments
- -16 ILLEGLID
- Illegal link ID
- -17 ILLEGIID
- Illegal index ID
- -18 ILLICOMP
- Illegal comparison operator (ICOMP)
- -19 ILLQUALF
- Illegal call qualifier in BASE (QUALF); illegal call qualifier in
CBASE (CQUALF)
Illegal Parameters in KDOMAINS
- -20 IKDOMPTR
- Illegal key-field address
- -21 IKDOMLTH
- Illegal key-field length
Illegal Parameters in DOMAINS
- -22 IFLDPTR
- Illegal field address
- -23 IFACLTH
- Illegal submitted field length
Illegal Parameters in Search Arguments
- -24 ISNUMBER
- Illegal field number in search arguments
- -25 ISPOINT
- Illegal field address in search arguments
- -26 ISLENGTH
- Illegal field length in search arguments
- -27 ISCOMP
- Illegal comparison operator in search arguments
- -28 ISBOP
- Illegal boolean operator in search arguments
Exceptional Conditions on a Scan
- -29 EMPSCAN
- Empty scan in SCANID
- -30 SCANOW
- Too many scans
are opened by RDS
- -31 UPDIRTY
- Write call using a dirty scan
- -32 NOTON
- Call different from NEXT, CLOSE using a scan which is not 'on'
Exceptional Conditions on an Index or on a Row
- -33 NFKEY
- Submitted key not found
- -34 UNIQKEY
- Violation of index key-uniqueness
- -35 LONGKEY
- Submitted key is too long
- -36 LONGTPLE
- Submitted row is too long
- -37 ILLTYPE2
- Illegal call for a Type 2 table. (Should never occur because the
database manager does not have Type 2 tables)
Exceptional Conditions on a Link
- -38 CLINKED
- Delete of a row illegally disconnecting some link; also connection of
a row in a link in which it is already connected
- -39 CNLINKED
- Disconnect, or delete and disconnect of a non-linked child; link open
on a non-linked child in a binary link; connect, insert and connect to a
non-linked child in a binary link
- -40 NOPARENT
- Parent does not exist (in PARENT call)
- -41 NOCHILD
- Child does not exist (in OPEN call)
Invalid Index Conditions
- -42 INVENTU
- Attempt made to use an index that has been marked invalid
- -43 INVENTM
- An index has been marked invalid during ROLLBACK or UNDO
- -44 NOINVALD
- The limit of invalid entities has been reached when combining the current
invalid indexes with the potentially invalid indexes due to active CREATE
INDEX and REORGANIZE INDEX operations.
Illegal Parameters in CBASE and Auxiliary Control Structures
- -45 IQUALFSG
- Illegal QUALFSEG
- -46 IAUXPTR
- Illegal auxiliary pointer
- -47 INPAGES
- Illegal NIPAGES or NHPAGES
- -48 ILLFREE
- Illegal percentage of free space in SCR or ICR
- -49 ILOCKPRT
- Illegal lock protocol in SCR or ICR
- -50 ILLNDOM
- Illegal number of field entries in MCR or ICR
- -51 ILLDOMS
- Illegal field entries (lengths in MCR, field numbers in ICR)
- -52 ILUNIQUE
- Illegal unique key specification
- -53 TOOMANYC
- Too many control objects as a result of a CINSERT
- -54 LISTSEGM
- Operation illegal on a list DBSPACE. Only scan operations, Insert
Row, and Sort are legal.
Illegal Parameter in BASE or SBASE
- -58 ILIXSARG
- Illegal index page search argument specified. Index is not being
used.
- -59 ILLHOLD
- Illegal HOLDIND or SHOLDIND value from RDS, bad Isolation level/Hold
value.
Illegal Conditions Related to Logical Unit of Work Management
- -60 NOSTART
- Begin Work was not issued prior to a Save Work call.
- -61 NOTEND
- COMMIT or ROLLBACK not issued prior to Begin Work call (logical unit of
work active)
- -62 NOLOG
- Operation requires a log, but none exists (should not occur on BEGIN WORK
or COMMIT as RDS does not support user log data)
- -63 INVSCHED
- SCHEDULE opcode issued for active logical unit of work
- -64 SYABORT
- System either requested logical unit of work abort, has run out of log
space, or transaction reached save point limit of 2147483647. Breaking
up the LUW into smaller LUWs with the COMMIT WORK statement will prevent
reaching the save point limit.
- -65 INLUW
- Operation not valid while agent has active logical unit of work
- -66 OPABORT
- Logical unit of work rolled back due to operator FORCE command
Illegal Parameters in SBASE
- -70 ILLEGALL
- Illegal length of the DBSPACE list
- -71 ILISTPTR
- Illegal pointer to DBSPACE list
Exceptional Conditions on a DBSPACE
- -72 SGISOPEN
- At least one DBSPACE already open
- -73 SEMPTIED
- Cannot be reopened until a synchronous save because CDELETE was issued
- -74 NOAVAILS
- No available temporary DBSPACE
- -75 NOTAVSEG
- DBSPACE not available or write operation with DBSPACE opened for
read
- -76 NOROOMH
- No header room in DBSPACE in write call
- -77 NOROOME
- No entity room in DBSPACE in write call
- -78 NOROOMI
- No index room in DBSPACE in write call
- -79 NOROOMSP
- No available space in storage pool nnn
DBSS Errors and Version Limitations
- -80 RSSERROR
- Error in DBSS code. Error ID in feedback area (Should not occur
since DBSS terminates the application server on any detected DBSS code error)
- -81 IOERROR
- DASD I/O error. DBSS always abends the application server on I/O
error. (Should not occur)
- -82 NOTIMPL
- Feature not yet implemented. (Should not occur)
- -83 NOMEMORY
- Unable to allocate needed main storage
RETURN CODES USED ONLY IN SYSTEM WITH LOG
Illegal Parameters in LUW Operators
- -85 OUTSIDE
- Pointer to user save data that is bad. (Should never occur because
RDS does not support user log data)
- -86 TOOLONG
- User wants to log more than 64K. (Should never occur because RDS
does not support user log data)
- -87 BADSAVNO
- Tried to back over non-existent save point
- -89 OKBUTMOR
- Read user log data but there was more. (Should never occur since
RDS does not support user log data)
- -90 INVIDLST
- Output area too small for INDOUBT list
- -91 SYBACKUP
- System requested LUW backup
RETURN CODES USED ONLY IN MULTI-USER SYSTEM
- -92 CHECKING
- Checkpoint in progress, try later
Illegal Parameters Related to Locking
- -94 BADCLVL
- Consistency level not 1, 2, or 3 (should not occur as RDS always uses
consistency level 3)
- -95 ILCKMODE
- Lock mode not in (SHAR,SIX,EXCL)
Exceptional Conditions Due to Locking
- -97 LOCKLIM
- Too many locks held by this LUW
- -98 PRIVSEGM
- Requested private DBSPACE is locked
LUW Backout Due to Locking; (Reached Save Point in
FEEDBACK(1))
- -99 DEADLOCK
- LUW backout due to deadlock
- -100 OVERLOAD
- LUW backout due to too many locks being held system-wide
- -101 DEADATSI
- Deadlock backout to a DBSI boundary...internal retry
failed
RETURN CODES USED ONLY IN SINGLE-USER SYSTEM
- -120 NOTMUL
- Operation not allowed in single-user system issued by operator command
OPCODE (OPCMMD)
MORE RETURN CODES RELATED TO LUW MANAGEMENT
- -123 ATTNBACK
- OPCODE terminated due to asynchronous request to terminate LUW;
caller should issue ROLLBACK. Can occur only if YTABLE1 flag ATTNATTN
set to Y. The database manager does not set ATTNATTN flag to Y.
Should not occur.
RETURN CODES USED BY THE SORT SUBSYSTEM
- -130 ILLSOPTR
- Illegal address of SORTSPEC
- -131 INORDSPC
- Illegal number of sort order specifications
- -132 ISORTSPC
- Illegal sort order specification
- -133 NOEXDOMN
- Field number does not exist for input table-id
- -134 IDUPELIM
- Illegal duplicate elimination option
- -135 INSLDOMS
- Illegal number of SORTLIST fields
- -136 NORMTPSG
- No space in temporary DBSPACE for write call
- -137 DUPFOUND
- Duplicate found during sort/merge; stop due to user option
- -138 ILLSLPTR
- Illegal pointer to SORTLIST specification
- -139 EMPTYSRT
- Empty set of rows to sort: sort DBSPACE is unchanged
- -140 ILTIDSPC
- Illegal TID specification: input list has no TIDs
- -141 ILDOMREP
- Illegal domain repetition: output list domain in SORTSPEC specified
more than once
- -142 ENCTPTLG
- Encoded row too long: does not fit in an intermediate page
- -143 ISORTERR
- Internal sort error: number of rows sorted and merged different
RETURN CODES SET BY RDS FOR DBSPACE ACCESS
- -200 DISABDB
- Attempt to access a disabled DBSPACE
RETURN CODES USED BY THE UPDATE STATISTICS COMMANDS
- -400 ILGMODE
- Illegal update statistics mode
- -401 ILNUMREL
- Illegal number of specified tables
- -402 DUPRELID
- Duplicate table-id in input list
- -403 IPATHTYP
- Illegal path type
- -404 ILPATHID
- Illegal path ID
- -405 MISMATCH
- RELID and PATHID do not correspond
- -406 NOTAROOT
- First table-id on input list is not a root
- -407 NOPARNT
- No parent specified for binary link
- -409 UNCLUSTI
- Unclustered indexes exist
- -410 INCONREL
- NREL or RELS(*) inconsistent with that previously specified with STARTUS
call.
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]