Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Adding enumerations in database table

  Hi,

when we add some custom enumerations in project area, we can choose whether it will be stored in PA process or database.
If we choose database, these enumerations are not visible in PA process configuration source, right?
So, there are stored in RICALM.REQUEST_ENUMERATION table, right?

My question is next:
Can I add more literals to this enumeration through this table, not via Project Configuration, so these new literal can be visible in Project Configuration or on work item which use this enumeration?

Regards,

0 votes



One answer

Permanent link
Hi Milan,

you should not attempt to modify the database directly at all, as far as I know. Unless support tells you so, the DB should be off limits to direct modification, unless you want to potentially get yourself into serious trouble.

If you want to modify things use the UI and the API if necessary. The UI and API go through the applications persistence layer that knows how to manage things and in which (potentially multiple) locations changes need to be made to be consistent. 

With respect to the DB backed Enumerations, please be aware that they currently don't take part in process sharing and unless this is addressed in future versions, you need to consider this shortcoming.

1 vote

Comments

There are some DB maintenance activities that might be exceptions to the rule not to modify the database.These don't modify the data in the database but metadata that is used by the DBMS to access and organize the database more efficient. Again, be careful, because some actions might have also a bad effect on performance.

Another exception is of course backup and restore. Please, again, be aware that these operations need to be considered carefully too. For example with respect to backing up a database that is in usage. Look into the https://jazz.net/library and the support pages for more information on this.

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,033

Question asked: Mar 28 '13, 4:56 a.m.

Question was seen: 3,846 times

Last updated: Mar 28 '13, 7:46 a.m.

Confirmation Cancel Confirm