Db2 Error- REASON 00C90099

[krishrad]

When i am trying to laod a partition table i got an error as
UNEXPECTED PROCESSING ERROR, REASON=X'00E40318' ON TABLE
DSNUGBAC - RESOURCE UNAVAILABLE
REASON 00C90099
TYPE 00000220

It tells me that high key on index to be increased. How to fix this

Thanks

 

[MarcLodge]

Krishrad,
What this means is that you are attempting to load one of the partitions of the table, and it is full. You need to terminate the load utility and then alter the partition key if required.

See here for more info:

http://www-1.ibm.com/support/docview.wss?uid=swg21161927

Hope this helps.

Marc

 

[krishrad]

THe table got 15 partitioons. I was loading data as load with replace. I got this message at 8th partition.
It is like data copy from one subsystem to the other subsystem. The table defiitions are same in both the subsytems.

The partitions are defined as ENDING AT ('55555555555555555555555555555555')
PARTITION 12
ENDING AT ('66666666666666666666666666666666')
PARTITION 13
ENDING AT ('77777777777777777777777777777777')
PARTITION 14
ENDING AT ('88888888888888888888888888888888')
PARTITION 15
ENDING AT (MAXVALUE,MAXVALUE)

Let me know how acan i increase these values

Thanks