We started recently loading data in database DMRPRDB1 . Some of these tables are rather big (especiall the DM%DTL) and would take advantage of range partitioning (UTS PBR) . Creating new partitions and dropping old partitions could be done by the rotate partition . We usually in such cases use dummy load of the oldest partition before running the rotate , however, this is not compatible with the rowid (GENERATED ALWAYS) in these BMC tables . Error : DSNU269I -DBA1 286 14:49:36.71 DSNURNFL - FIELD ROWID IS NOT ALLOWED
Does anyone has similar setup and how dealing with this issue ?
...and its a DB2 11 on z/OS .
Peter, what Application and Version is this for?
Hi LJ, I guess this needs to go to Solutions for DB2 ...