3 Replies Latest reply on Oct 18, 2016 8:33 AM by Peter Van Paesschen

    BMC database DMRPRDB1 and partitioning

    Peter Van Paesschen

      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 ?