It's all about the answers!

Ask a question

What is the recommended maintence tasks for CLM V5 and V6


Mark Ireland (26115147) | asked 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

3 answers



permanent link
Madan Kumar (111) | answered 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


Comments
Mark Ireland commented 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 (111) | answered 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





Comments
Mark Ireland commented 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 (111) | answered 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

Comments
Mark Ireland commented 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 to post your answer.