View previous topic :: View next topic
|
Author |
Message |
shweta bansal5
New User
Joined: 02 Aug 2011 Posts: 10 Location: India
|
|
|
|
Hi,
I am getting -327 on a table when trying to insert a date greater than '2011-08-04'. This date column is not part of index columns. This topic had already been started in 2006 but I could not get a proper answer from that. Can someone please help me in this regard.
ibmmainframes.com/viewtopic.php?t=24060&highlight=327
Thanks,
Shweta. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
is says simply that the intended insert creates a value which is greater than that allocated for the last range.
stop arguing with db2. determine how the partition range is calculated,
and determine which column is causing the violation.
2011-08-04 is a really odd place to start/stop a range.
i would not be suprised if the violating column is not the date column.
but, you need to perform some research to determine the range calculation. / i.e. what columns are involved. |
|
Back to top |
|
|
|