Improve performances

[fyot]

What did you mean about :

For the CLUSTER: the temporary files is exactly the problem

In fact when I say temporary files, I spoke only about files in /ctm/tmp or /ctm/pid.
During the switch I will be better to stop and start Control-M Server.
So Control-M server build again those files.

[mauriziog]

In fact when I say temporary files, I spoke only about files in /ctm/tmp or /ctm/pid.

Yes but what about /ctm/STATUS directory ?
There there are the files of the daily executions, they can be many and there I have the bottleneck ...

[fyot]

Hi Meuriziog,

I never tried to move /ctm/STATUS in a FS in memory.
We need to try it.

So to keep inform everybody. It will be possible to create a Filesystem in memory on HP Unix plateform with the next version HP-UX 11.31.

[mauriziog]

Can you say if you have esperienced how to optimize the DB oracle of controlm?
I've readed somewhere that this can optimize the performance of read and write and if the db is dedicated only to controlm can be tested.

[fyot]

Sorry but no.

I only knew about standard installation.
I would like to have some feedback from an Oracle DBA.

So, anyhow, you can apply all other improvements, about FS in memory, to a Control-M Server running too with Oracle.

FS in memory doesn't depend on Dabases type.

[mauriziog]

I've recived some information on how improve performances of Oracle DB, can be usefull so I copy them here:

------------
CONTROL-M/Server and CONTROL-M/Enterprise Manager demonstrate performance degradation when:
1. Too much workload is put on too few hard disks.
2. When RedoLog files are placed on RAID-5 disks
3. When Rollback tablespace is placed on RAID-5 disks
To optimize your system:

1. Firstly install Oracle on a disk other than the one on which the Unix SWAP
file resides. (At least two hard disks).

2. Secondly assign the Redo Log to a separate disk drive.

3. Thirdly make sure that the Redo Log file is not using a RAID-5 disk. (No RAID,
RAID 0 or RAID 0+1 are OK).

4. Fourthly assign the Rollback tablespace Log to a separate disk drive.

5. Fifthly make sure that the Rollback tablespace file is not using a RAID-5 disk.
(No RAID, RAID 0 or RAID 0+1 are OK).

6. Sixthly assign the Control Files Log to a separate disk drive.

7. Seventhly make sure that the Control Files are not using a RAID-5 disk.
(No RAID, RAID 0 or RAID 0+1 are OK).

Note that each and everyone of these steps will improve the performance of the
database. It is more likely that the ones at the top of the list will improve the
performance than those lower down.
---------------

[philmalmaison]

you certainly can increase globaly use of memory of the database by increasing SGA, for sybase and if not in row data you can put all temporary FS in SWAP.
Philmalmaison