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
April 08, 2010, 12:41 AM
Waz
What type of file are you using ?
Where is the file being loaded ?
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
April 08, 2010, 02:59 AM
Sophie
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
April 08, 2010, 06:13 AM
Gobinath Velusamy
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
April 08, 2010, 06:49 AM
Tony A
quote:
we can divide the reports
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
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
April 08, 2010, 08:46 AM
jgelona
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.
April 08, 2010, 05:38 PM
Waz
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...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
April 09, 2010, 11:12 AM
susannah
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 ..
In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
April 10, 2010, 04:16 AM
FrankDutch
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.
Frank
prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7
April 11, 2010, 08:56 AM
Tony A
quote:
Xfocus ....... (unlicensed)
Not sure that it is an extra cost?
quote:
why would you convert a nice oracle database to a focus database?
I've seen speed advantages by doing this so, why wouldn't you want to convert?
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
April 12, 2010, 04:19 AM
<JG>
quote:
Not sure that it is an extra cost?
Tony, it's totally an extra cost, and if you want the MDI index feature as well that's an additional extra cost.
April 14, 2010, 12:40 AM
Sophie
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
April 14, 2010, 01:55 AM
Tony A
Thanks for setting the facts JG!
Sophie, use LOCATION to split your FOCUS files into separate files.
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