Posted: Fri Feb 23, 2007 11:26 am
DO an exact search on 'SQL27959N'.
Brian a complete DB2 search give me the following:DSguru2B wrote:DO an exact search on 'SQL27959N'.
This is the only reason you need to look at, since you original error message specifically mentions reason code 1.fmartinsferreira wrote:
SQL27959N The partitioned database configuration option
"<option-name>" is invalid. Reason code =
"<reason-code>".
Explanation:
The partitioned database configuration option named in the error
message is incorrectly specified or is incompatible with one of
the other load options specified.
The possible reason codes are as follows:
1 Partitioned database configuration options cannot be specified
in a non-partitioned database environment or when the
DB2_PARTITIONEDLOAD_DEFAULT registry variable is set to OFF.
Code: Select all
[myuserid@myserver] % db2set -i db2edwd1 DB2_PARTITIONEDLOAD_DEFAULT
DBI1303W Variable not set.
Explanation:
The variable was not set in the profile registry.
User Response:
No further action is required.
Sorry Ray, but how can I do this?ray.wurlod wrote:Try disabling automatic load ...
Brad, second my DBA we are using v8.2 and the variable DB2_PARTITIONEDLOAD_DEFAULT is ON.bcarlson wrote:What DB2 version are you using? I checked on the IBM website, and it looks like the variable DB2_PARTITIONEDLOAD_DEFAULT may not be necessary for v8.1 or later. We are using 8.2 and it is not set. You can determine its value with the db2set command:
The manual says:bcarlson wrote: Check to see if your database is partitioned - your DBA should be able to determine that.
Brad