9 replies to this topic

[cartman]

Hi,

I daily purge the $U files, but do not run the reorganization very frequently, only usually when the performance seem to decrease or after a system crash.

Have you got any recommendation? Would once a month be enough?

Eric JT

[ciccio]

We run reorg every night...

[couak]

In my company we reorg every night for the Windows platform for stability and... once each time we change our outsourcer for the HP-UX version.

One thing to remember : purge removes entries from the internal database of $U BUT it doesn't remove it physically from the datafile (i.e. entries still remain in the *.dta file)
The only way to remove entries (and reduce the datafile's size as well) is to run a reorg

[Stefan Füßgen]

Hello,

we use a Maintance session which runs every day.

In this session we pruge in the job monitor all jobs older than 3 days. For some high frequently running jobs we keep the entry in the job monitor for 1 day and for some extreme jobs for only 3 hours (separate purge job).

We also delete job logs in this session or move them to archive them.

One day in the week we do an offline reorg (ux_vrf_rgz_rst).

But the reorg do not delete entries in one or two files. So this files growths and we must initialize this file (ux_raz_fic).
These file are u_fmtp50 and u_fmsp50.

I don't know if the problem exists in new versions than v5.0 with SP RE0025.

Edited by Stefan FÌßgen, 24 April 2008 - 07:39 AM.

[ciccio]

Is it not dangerous to use often raz_fic on that files (u_fmtp50 and u_fmsp50) ?

We use raz_fic only on these files:

u_fmpi50
u_fmhs50
u_fmph50
u_fmcm50
u_fseu50
u_fecd50
u_fecl50

Someone told me that using raz_fic on u_fmtp50 and u_fmsp50 could erase some futures launches, is it true ?
Maybe with old versions ( < 5.2 ) ?

[kenny]

To answer the original question :

- I run daily purges with short retention cycles (3 days in Job monitor, history files 1 month max)
- I run the offline reorganization every week-end.

To answer Ciccio's question :

raz_fic on u_fmtp50 and u_fmsp50 cannot erase any launch but could erase some information for the launches (linked to variables and parameters of the Launches)

Kenny

[Venkata Ragavan Shanmugam]

Hi Eric,

We run IU_PUR everyday during off peak hour when the load on $U is less. ( usually in the morning)

However we run the reorganization (IU_RTS) once in 6- 8 weeks or when the performace is hit.

In the past we have noticed that $U ( Version 5.0, OS : OpenVMS ) behaves strangely (mismatch of jobs in running state and the jobs in queue) and gives abnormal errors while executing jobs if reorganization is not done for a long period. Once IU_RTS is run the issues are solved.

So as an Administrator, you will be the best person to decide the frequency of run depending on the load imposed to $U

Hi Group,

Is "raz_fic" available for OpenVMS too ? Let me know the syntax to use it and the advantages.


Cheers
Venkata

[Stefan Füßgen]

ciccio, on April 24 2008, 02:08 PM, said:

...
Someone told me that using raz_fic on u_fmtp50 and u_fmsp50 could erase some futures launches, is it true ?
Maybe with old versions ( < 5.2 ) ?

There are problems with launches without task and launches where the launch window is not over.

But in the past we have problems with the size of these files.

[Vannara]

ciccio, on April 24 2008, 02:08 PM, said:

Is it not dangerous to use often raz_fic on that files (u_fmtp50 and u_fmsp50) ?

We use raz_fic only on these files:

u_fmpi50
u_fmhs50
u_fmph50
u_fmcm50
u_fseu50
u_fecd50
u_fecl50

Someone told me that using raz_fic on u_fmtp50 and u_fmsp50 could erase some futures launches, is it true ?
Maybe with old versions ( < 5.2 ) ?

Hi
For your question :
Is it not dangerous to use often raz_fic on that files (u_fmtp50 and u_fmsp50) ?
It's not dangerous, you just lost all launch. But when you want to reset the launch files, you have to raz_ric 3 files (u_fmtp50, u_fmsp50 and u_fmsb50).
Someone told me that using raz_fic on u_fmtp50 and u_fmsp50 could erase some futures launches, is it true ?
You just lost the manual launch (except all launch come from "task") by motif or "uxadd fla".

[men]

Hello,

please note that running "razfic" on a regular basis is absolutely not recommended! Only exception is when you have the agreement of Orsyp Dollar Access team.

Running "razfic" on u_fmtp50 and u_fmsp50 will not erase the launch but will erase information used by the launches (linked to variables and parameters of the Launches). This may create inconsitency with the u_fmsb50 file (the launch file).

Michel