Cannot change chunk status. ISAM error: illegal argument to ISAM function
When you use onspaces to change the status of a down chunk to online, you receive the error "Cannot change chunk status. ISAM error: illegal argument to ISAM function"
The database server has one or more chunks marked as down. You are attempting to bring the down chunks back online using the onspaces -s command and you receive the error "Cannot change chunk status. ISAM error: illegal argument to ISAM function". The chunk remains offline.
onspaces -s dbs1 -p /path/to/dbs1chunk1 -o 0 -O
Warning: Bringing chunk back online.
Do you really want to continue? (y/n) y
Verifying physical disk space, please wait ...
Cannot change chunk status.
ISAM error: illegal argument to ISAM function.
The dbspace has been flagged as disabled and all of the chunks in the same dbspace are marked as down.
A dbspace can be flagged as disabled due to a problem accessing the first chunk in the dbspace or due to corruption in the first chunk of the dbspace. The subsequent action by the database server will depend in the setting of the configuration parameter ONDBSPACEDOWN.
- If the ONDBSPACEDOWN configuration parameter is set to 2 (wait), the database server will wait for intervention from the database administrator before flagging the dbspace as disabled.
- If the database server is blocked on a checkpoint request due to down dbspace, the dbspace is currently flagged as disabled in memory and the onspaces -s command will fail.
- If the database server was blocked on a checkpoint request due to down dbspace and onmode -O was issued, the dbspace is flagged as disabled in the reserved pages and in memory, so the onspaces -s command will fail.
- If the ONDBSPACEDOWN configuration parameters is set to 0 (continue) the database server has automatically disabled the dbspace on detection of a problem with the first chunk in that dbspace, without giving a warning to the user.
Resolving the problem
Restore the dbspace from an archive.
Tip: If the dbspace has been flagged as disabled due to a physical access problem, check with the operating system administrator that this problem has been fixed, and contact Technical Support for advice on the possibility of enabling the dbspace without a restore from archive.
More support for:
Software version: 10.0, 11.1, 11.5, 11.7, 11.70, 12.1
Operating system(s): AIX, HP-UX, Linux, OS X, Solaris, Windows
Reference #: 1153097
Modified date: 26 June 2014