Watson Supply Chain Ideas

Use this form to submit an idea for a new product feature. The product team will review your input and provide status updates as decisions are made regarding the request.

Before you submit a new idea, please view requests that have already been submitted. If your idea has already been submitted, you can add comments or vote on the existing idea, thereby indicating your agreement with the idea. We may use this information to help prioritize development of new features.


Submit ideas for Watson Marketing and Watson Commerce products

Add created_timestamp to TRANS_DATA as Partinioning Key for Oracle

We can not identify a suitable PARTIONING KEY in TRANS_DATA to setup partioning. With 11.2 VIRTUAL COLUMNS are supported to provide this PARTIONING KEY. With a timestamp in the physical record one could easily define mod(to_integer(day((created_timestamp)),20) as a virtual column to create such a partion key for 20 generations.

Please bear in min that the current defined LOB Datataypes are NOT reorganization free and require regular re-organization.

Alternativly you could support secure files instaed of LOBS here.
  • Avatar32.5fb70cce7410889e661286fd7f1897de Guest
  • Dec 19 2017
  • Uncommitted Candidate
How will this idea be used?
What is your industry?
What is the idea priority? High
DeveloperWorks ID DW_ID61602
Link to original RFE http://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=61602
  • Attach files