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

List of database activities performed during the CLM server upgrade / rename

Questions
Tags
Users
Badges
Bharath Rao
(915●2●41) Mar 06 '19, 6:23 a.m.
Do you have a comprehensive list of database activities performed during CLM Server Upgrade / Rename ?
Also, what are the privileges necessary to a database user to perform the same ?

0 votes

1 answer
1,635 views
0 votes

One answer

Permanent link
Bharath Rao
(915●2●41) edited
Mar 06 '19, 6:28 a.m.

At a higher level, when performing a rename/upgrade, the database users needs to be able to create/modify/delete tables, create/delete indices, run stats, modify the schema (either the single schema, Oracle and SQL Server, or the app specific schema for DB2).
To get more details, you could enable the SQL transaction loggers. The below technote has the details on enabling the same:


Regarding privileges,
The creation and setup of a DB2 database assumes that the user installing Jazz has only DBADM authority over the database and that the database and its underlying tablespace storage has been created ahead of time by a SYSADM user.
For the rename / upgrade, DBADM authority is necessary.

0 votes

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.

Ask a question
Guidelines
FAQ
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
× 7,498

Question asked: Mar 06 '19, 6:23 a.m.

Question was seen: 1,635 times

Last updated: Mar 06 '19, 6:28 a.m.

Confirmation Cancel Confirm