Troubleshooting
Problem
After successfully using the onunload utility to unload a database that has been fragmented across dbspaces that use non-consistent page sizes, you receive the following error: "pagesize of the target dbspace does not match with the pagesize of the partition on tape. ISAM error: Tape might contain a corrupt page (or) if you are executing onload command specify the correct DBspace name using the -d argument."
Cause
There are two possible causes of this error:
1) You have specified a dbspace when running the onload command, for example if you run:
'onload -t <pathToSource> -s <tapesize> -d <dbspace> <database>'
2) You have not yet created all the necessary dbspaces to hold the database you are attempting to load
Resolving The Problem
To resolve this issue, you must first create a dbspace to for each page size existing in the database that is being loaded.
For example, if the database contains data pages that exist in a 2k dbspace, but contains indexes that are stored in an 8k dbspace, you will need to create a 2k dbspace and an 8k dbspace on the target instance before running the onload utility.
You must also ensure that no dbspace is specified in the onload command, for example, if you run:
'onload -t <pathToSource> -s <tapesize> <database>'
As long as all the proper dbspaces exist, the data should load without error.
Was this topic helpful?
Document Information
Modified date:
29 September 2018
UID
swg21684463