If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0636N Range specified for data partition "TEST_LEG_HISTORY_141215" is not
valid. Reason code = "10". SQLSTATE=56016

with MINVALUE and MAXVALUE specified, how do I proceed with rolling in / rolling out new/old partitions?
Any help would be appreciated, thank you very much in advance

I would detach the open partition : export this table
add new partition with new borders
add partition with open bounders
reload data from detached open partition (because there could be data now residing in lastest non-open partition)

Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certifiedhttp://www.infocura.be