Guidelines in increasing the space of the hold files
Hi,
I would like to know the guidelines in increasing the space of the hold files. By increasing the capacity of hold files, i should not be compromising on the performance. Could someone suggest me the guidelines for the same??
Thanks VixThis message has been edited. Last edited by: Vikas,
7.2.3IBM system Z9 Business class Flat files, excel and CSV files.
May 19, 2008, 03:55 PM
Darin Lee
It's usually best to include some description of your issue in the thread title instead of just "Hi" - more likely to get someone who can help you with your specific problem. There is no limitation on the size/space for hold files. The limitation may be on the amount of disk space available in the environment or any system limitations placed on specific users. As for part 2 - there is always a compromise. If you use up all the disk space available to the system with hold files, the performance dies. If you have extremely large hold files, there is a performance issue because hold files are usually not the most efficient way to store and/or retrieve data. If the hold files are FOCUS files that are being updated, they should be rebuilt periodically for size and efficiency purposes.
Hard to give a specific answer to a very broad question.
Regards,
Darin
In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat
May 20, 2008, 01:50 AM
Vikas
Thanks a lot Darin for your immediate response..I shall take care of the thread title next time...Thanks for your time...
7.2.3IBM system Z9 Business class Flat files, excel and CSV files.
May 20, 2008, 02:45 AM
Tony A
Vikas,
Why wait until next time? If you edit your first post then as you are the originator, you have the ability to change the topic description. Try it now by clicking the middle icon in the lower right of your first post and make that change.
T
In FOCUS since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
WebFOCUS App Studio 8.2.06 standalone on Windows 10
May 20, 2008, 09:13 AM
PBrightwell
From your previous post, it makes me think you are doing this thru JCL. If that is the case you create a DD for each hold file. Without a JCL sample to reference I can't remember all of the syntax, but talk to your systems people about creating temporary storage.
Pat WF 7.6.8, AIX, AS400, NT AS400 FOCUS, AIX FOCUS, Oracle, DB2, JDE, Lotus Notes