Informix Error -23906: Dbslice lookup failed.
Cause and resolution
Dbslice lookup failed.
This code indicates that the dbslice specified in the operation (for example, in the IN clause of the CREATE TABLE ... FRAGMENT BY statement) has not been defined. Make sure that the specified dbslice is indeed the name of an existing dbslice and not of a dbspace. You can run the onstat utility with the -d option to see the names of defined dbspaces. Names ending with .number are dbspaces that belong to a dbslice (for example, dbsl.1 and dbsl.2 are two spaces in the dbslice dbsl).
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-23906 fires when an operation (for example, CREATE TABLE ... FRAGMENT BY ... IN)
names a dbslice that hasn't been defined — per the official guidance.
- A named dbslice that doesn't exist, per the official guidance — the direct, only cause; possibly a dbspace name was used where a dbslice is required.
Solutions / Resolution
- Confirm the specified name is an existing dbslice, not a dbspace, per the
official guidance. Use
onstat -dto see defined dbspaces — names ending in.numberbelong to a dbslice (e.g.dbsl.1/dbsl.2are spaces in dbslicedbsl).
Examples
Checking defined dbspaces/dbslices
$ onstat -d
Diagnostic Checks
- Run
onstat -dto confirm the named dbslice actually exists, and correct the name if it's actually a dbspace.
Related Errors / Related Topics
No closely related error codes are cross-referenced for -23906 in this set yet.
The specified dbslice wasn't found — confirm it's an actual dbslice name via onstat -d, not a dbspace name.