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

What is the recommended maintence tasks for CLM V5 and V6

Questions
Tags
Users
Badges
Mark Ireland
(261●2●57●48) Feb 15 '16, 8:54 a.m.
Hi,

What regular maintenance tasks should we be doing for CLM please?

This is on a websphere windows server, using DB2 on Linux.

Best wishes

Mark

0 votes

3 answers
4,842 views
0 votes

3 answers

Permanent link
Madan Kumar
(11●1) Feb 17 '16, 5:19 a.m.
 Hi Mark

We don't recommend users to run these commands unless there are some specific issues.

repotools -deleteJFSResources 
repotools -compactdb
repotools -reindex
Database Reorg and Runstats

For maintenance activities in CLM we suggest backup information mentioned in this URI:
https://jazz.net/wiki/bin/view/Deployment/BackupCLM

For running any any repotools command, please raise a PMR with Support.

Thanks & Regards,
Madan

1 vote

Comments
Mark Ireland
Feb 17 '16, 5:55 a.m.

Hi,

We run the IBM shared service and as such our databases grow with projects coming and going.
The DB's and indexes are being updated constantly. We need a way to remove and clean up old data, along with ensuring that the servers run at optimal efficiency.

Best wishes

Mark.

Permanent link
Madan Kumar
(11●1) Feb 17 '16, 12:29 a.m.
 Hi Mark

As regular maintenance tasks, please ensure the following:

1) Ensure you take full offline backup of CLM databases on DB2 server on a daily basis.
When taking the backup, you should stop the WAS profiles hosting CLM applications.

E.g. db2 BACKUP DATABASE jts TO C:\Installers\DB2\Newbackup
Repeat this for all the other CLM databases.

2) Parallely take complete folder backups of JTS_HOME\server directory so that the indices folders are backed up when Databases are backed up.

3) You could take Websphere profile backup using this step on a weekly basis:

START WAS profile hosting CLM, and then cd to 
<WAS_INSTALLATION_ROOT>/AppServer/profiles/<PROFILENAME>/bin folder
Then Run the Command --backupConfig.bat <Backup_File_Name_Date_WITH_PATH>.zip

Thanks & Regards,
Madan




0 votes

Comments
Mark Ireland
Feb 17 '16, 4:43 a.m.

HI,

Many thanks, we already do all this. My question was more directed to Repotools commands etc run on a regular basis to perform reindex, or deletes etc.
Also, do you recommend any DB activities?

Many thanks

Mark.

Permanent link
Madan Kumar
(11●1) Feb 19 '16, 3:17 a.m.
 Hi Mark

Please raise a PMR to check on removing and cleaning up old data.

Thanks & Regards,
Madan

0 votes

Comments
Mark Ireland
Mar 31 '16, 10:08 a.m.

Does anybody have a set task list for DB2 maintenance tasks?

re-orgs etc etc

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,493

Question asked: Feb 15 '16, 8:54 a.m.

Question was seen: 4,842 times

Last updated: Mar 31 '16, 10:08 a.m.

Confirmation Cancel Confirm