Troubleshooting
Problem
There are times when a database administrator is reorganizing an instance and needs to drop a chunk but the operation fails with ISAM Error: Can not drop first chunk
Symptom
You receive this error message when attempting to drop a chunk:
ISAM error: Can not drop first chunk
Cause
You cannot drop the root chunk of a dbspace. A dbspace must have at least one chunk associated to it.
Resolving The Problem
If a dbspace contains only one chunk and the chunk is empty, use onspaces to drop the dbspace.
- 1. Login as user informix and from a command line window, execute:
- onspaces -d spacename
- -d
- Drop a DBspace, BLOBspace, SBLOBspace, Extspace
- The name of the DBspace to drop
- Example:
- $ onspaces -d dbs2
- WARNING: Dropping a DBspace.
Do you really want to continue? (y/n)y
Space successfully dropped.
** WARNING ** A level 0 archive will need to be done before any chunks from DBspace dbs2 can be reused (see Dynamic Server Administrator's manual).
Related Information
[{"Product":{"code":"SSGU8G","label":"Informix Servers"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"--","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions","Edition":"Workgroup;Enterprise","Line of Business":{"code":"","label":""}}]
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21154980