RE: [SYSTEM21] Fw: Access path size limit

["Brunk, Kevin" <KBrunk@xxxxxxxxxxxx>]

Hmmmm...Rose...you're reply is very interesting.  Our FLP062 size is (drum 
roll, please): 299,512,136 records! It bothers me to no end to see it that 
high, but as a percentage of our disk space it's not critically hurthing 
anything so it's easy to ignore.

I'm surprised by your answer of simply clearing the file and rebuilding the 
drill downs.  While I'm still fairly new to S21, I just assumed that the time 
to rebuild the drill downs was onerous and almost worth tolerating the huge 
file size we have.  What things are affected by FLP062 (i.e. is financial 
reporting dependent upon it) so if I do clear and rebuild I'll know what's 
temporarily unavailable?  How can I get the best tutorial understanding of 
FLP062's use?  How do you find out if the user-defined views are still in use - 
ask people?

==Kevin

-----Original Message-----
From: system21-bounces@xxxxxxxxxxxx
[mailto:system21-bounces@xxxxxxxxxxxx]On Behalf Of Rose Clarke
Sent: Wednesday, August 04, 2004 5:45 AM
To: System 21 Users
Subject: RE: [SYSTEM21] Fw: Access path size limit


We had a similar problem recently and given the size of FLP062 and the
alarming rate at which it grows we decided to totally clear it and then
just rebuild the drill downs for the user defined views which actually
needed drill down capability (we find that these are generally used to
view balances and the users are only likely to drill down if there is a
problem with the figures, so this drill down would only be required for
the month until GL is closed. Any drilldown that is deleted and then
required can easily be rebuilt and we'd rather do this than hold that
much unnecessary data.

It is probably worth finding out if all the user defined views are still
in use, we found that 60% were unused, so de-activating those made a
huge difference.

Unless you have a unlimited capacity for data, I think it would be much
better to handle the amount of data rather than 'fix' the files.

Regards,

Rose Clarke

-----Original Message-----
From: system21-bounces@xxxxxxxxxxxx
[mailto:system21-bounces@xxxxxxxxxxxx] On Behalf Of
GManoovaloo@xxxxxxxxxxxxx
Sent: 04 August 2004 10:22
To: System 21 Users
Subject: [SYSTEM21] Fw: Access path size limit

We need some feedback/views  on the following situation : 

 2 weeks ago , GLUPDATE crashed because one of the logicals (GLBLINKT)
of 
FLP062 had reached the maximum size allowed . The message indicated 'no 
recovery' . 
 The attribute *ACCPTHSIZ OF the 3 logicals ( GLGLTRAN , GLBLINKT , 
GLBLALLT ) based on FLP062, was found to be set to  *MAX4GB . . After 
investigation ,and in view of the size of FLP062 , there was no 
alternative than to CHGLF the file GLBLINKT , setting the *ACCPTHSIZ to 
*MAX1TB , a value that is allowed after  O/S V3R6M0 . Since then , there

is no apparent problem . Has someone hit this problem before ? Is it
right 
to extend the CHGLF to the other logicals to prevent recurrence of
problem 
?  Also , what about additionally issuing a  CHGPF to set this same 
parameter for FLP062 ? 
Thank you any help 
 
Gilbert Manoovaloo
_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.




_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.



**********************************************************************
CONFIDENTIALITY NOTICE:  The information transmitted in this message is 
intended only for the person or entity to which it is addressed and may contain 
confidential and/or privileged material.  Any review, retransmission, 
dissemination or other use of this information by persons or entities other 
than the intended recipient is prohibited.  If you received this in error, 
please contact the sender and destroy all copies of this document.  Thank you.  
The Butler Company
**********************************************************************