getting error while loading data in db2 udb

Deb Kumar

getting error while loading data in db2 udb

SQL0327N The row cannot be inserted into table "table1"

because it is outside the bounds of the defined data partition ranges.

SQLSTATE=22525

Database and table both are  partition

How to check the partition range so that I can load data

Jack Campbell

RE: getting error while loading data in db2 udb
(in response to Deb Kumar)

You didn't mention the version of DB2 (z/os or luw), so to keep it simple. The easiest way to check the partitions values is to retrieve the DDL using you favorite extract tool and look at the table definition - find the "PARTITION BY" clause and look at the column name and  values for each partition. The value specified is the maximum value allowed in that partition.

Check you have not exceeded the highest value allowed, also check your LOAD is not specifying a specific partition number (if so check the high value is within that range).

I am a little out of date on LUW DPF - so there may be additional considerations there if you are using DPF

HTH

Jack



In Reply to Deb Kumar:

SQL0327N The row cannot be inserted into table "table1"

because it is outside the bounds of the defined data partition ranges.

SQLSTATE=22525

Database and table both are  partition

How to check the partition range so that I can load data