 |
|||||
|
As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Focal Point 
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [CLOSED] File size limit for release 7.6.8
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [CLOSED] File size limit for release 7.6.8 Read-Only TopicGo | Search | Notify | Tools |
| [CLOSED] File size limit for release 7.6.8 | Login/Join |
| Silver Member |
Hi, We have a large data file (greater than 2GB) that need to be downloaded into WebFOCUS, we are currently using Release 5.2 and in the progress of upgrading to 7.6.8. 1. What is the file size limit for Release 7.6.8? 2. What is the alternative and the best way to handle large file size in the current Release 5.2? Thanks SophieThis message has been edited. Last edited by: Kerry, WebFOCUS 5.2 upgrading to the latest version at the moment. UNIX HTML | ||
|
| Expert |
What type of file are you using ? Where is the file being loaded ? Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Silver Member |
It's Oracle type file (11 million records) trying to load into WebFOCUS 5.2 Thanks Sophie WebFOCUS 5.2 upgrading to the latest version at the moment. UNIX HTML | |||
|
| Platinum Member |
Hi If the file size is very large.you can use Reportcaster functionality . Using Bursting option,we can divide the reports and put in some locations WebFOCUS 7610 Windows | |||
|
| Expert |
I didn't notice that reports were mentioned? Sophie, When you say "into WebFOCUS 5.2", I guess that you mean FOCUS or an XFOCUS db and not MSSQL, Oracle etc. ? Working on the assumption that it's FOCUS then the limit (I believe) is over 2GB after early 7 release(?). XFOCUS has a greater limit so it might be adviseable for you to look at that. If you still hit problems size wise (you only say that it's over 2Gb) then there are always other methods that you can use, such as the LOCATION attribute. I'm sure that tech support coudl answer specifics acording to your set-up / release(s) etc., so it might be work while getting a case raised to ask those specifics. T
| |||||||||
|
| Master |
I currently have an XFOCUS file that is about 3.5GB. Another option, if the data lends it self to it would be to split the file into logical units like yearr, make year part of the file name and controll which files are used by using a USE statement. We do that as well. In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux. | |||
|
| Expert |
We still don't know the destination file type. This seems to be existing functionality, so the destination type must be known. As Tony says, if the destination is FOCUS, it has a 2gb limit, per file. You can break the data up into multiple FOCUS files. I think that there was a discussion about XFOCUS a while back that ended up shoing that XFOCUS is a licensed product. One important question, your signature says UNIX, what flavour is it? We currently have a case with IBI with running 32 bit software on solaris 9, reading large files, over 2gb, fails. Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Expert |
We have found that even our interim extracts and work hold files (.ftm) have to be turned into .foc (xfocus) when we're working with large (>2g) extracts. I don't think we have any special licensing for ON TABLE HOLD FORMAT XFOCUS ..
| |||||
|
| Virtuoso |
I have tried Xfocus a few times (unlicensed) the advantage is the much bigger size, but I found out that you can not update records. My question in this is, why would you convert a nice oracle database to a focus database? And if it is a matter of downsizing, can you keep the new file at oracle format.
| |||||||
|
| Expert |
Not sure that it is an extra cost? I've seen speed advantages by doing this so, why wouldn't you want to convert? T
| |||||||||
|
| <JG> |
Tony, it's totally an extra cost, and if you want the MDI index feature as well that's an additional extra cost. | ||
|
| Silver Member |
Thanks for the responses so far. The destination file type will be text file to the SQL server destination. Our UNIX OS also has a limit of 2GB file size. Therefore, any suggestionss to bypass this would be very much appreciated. Thanks Sophie WebFOCUS 5.2 upgrading to the latest version at the moment. UNIX HTML | |||
|
| Expert |
Thanks for setting the facts JG! Sophie, use LOCATION to split your FOCUS files into separate files. T
| |||||||||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicFocal Point Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [CLOSED] File size limit for release 7.6.8
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [CLOSED] File size limit for release 7.6.8Copyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |