Worldwriter F0911 Logical Files

  • Thread starter Graham_Aberdein1
  • Start date

Graham_Aberdein1

Active Member
Hi there,

We are experiencing some fairly lengthy run times (sometimes in excess of
2-3 hours) for Worldwriters extracting data from the F0911 file (our F0911
has close to 60 million records). In looking at the joblogs, it appears
that where we have joined the F0911 to another file (e.g. the F0006 to get
BU category code information or BU description, or the F0010 to get current
reporting date and fiscal year), the program zeroes in on the joined fields
as the "keys" for indexing. It also appears that in some cases it cannot
use an existing logical file and creates one (I may be wrong on this
assumption).

The question is, can you define a specific logical file within the
Worldwriter screens? It appears to us that the optimizer scans the logical
files for the "best fit" based on the extraction criteria including joins
within the Worldwriter (again, I may be wrong on this). If so, can we
create our own logical file(s) and specify the appropriate one to be used
with each Worldwriter?

Another related question is, has anyone created "partitions" of their F0911
(e.g. current reporting month transactions only) for reporting against?

Any assistance is appreciated.

Thanks,

Graham G. Aberdein
Clarica
(519) 888-3900 x-4293
email address: [email protected]
running Worldsoftware A7.3 cume 11
 
Hi, Graham
Try to build your own logicals first, then use it in each world writer.By the way, your logical can key the way you want your WW sort, it will speed up quite a bit, good luck...

Carolyn Yen
SR. Programmer/Analyst
Silgan Containers Manafacturing Corp
Phone: 818 - 710 - 3743
Email: [email protected]

>>> Graham Aberdein <[email protected]> 01/05/01 09:54AM >>>

Hi there,

We are experiencing some fairly lengthy run times (sometimes in excess of
2-3 hours) for Worldwriters extracting data from the F0911 file (our F0911
has close to 60 million records). In looking at the joblogs, it appears
that where we have joined the F0911 to another file (e.g. the F0006 to get
BU category code information or BU description, or the F0010 to get current
reporting date and fiscal year), the program zeroes in on the joined fields
as the "keys" for indexing. It also appears that in some cases it cannot
use an existing logical file and creates one (I may be wrong on this
assumption).

The question is, can you define a specific logical file within the
Worldwriter screens? It appears to us that the optimizer scans the logical
files for the "best fit" based on the extraction criteria including joins
within the Worldwriter (again, I may be wrong on this). If so, can we
create our own logical file(s) and specify the appropriate one to be used
with each Worldwriter?

Another related question is, has anyone created "partitions" of their F0911
(e.g. current reporting month transactions only) for reporting against?

Any assistance is appreciated.

Thanks,

Graham G. Aberdein
Clarica
(519) 888-3900 x-4293
email address: [email protected]
running Worldsoftware A7.3 cume 11





--------------------------
To view this thread, visit the JDEList forum at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=W&Number=3424
*************************************************************
This is the JDEList World Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
*************************************************************
 
How about going right to a SQL command to parse the F0911 to a workable size
and using a SQL select to join the smaller F0911 with the F0006 and F0010.

Worldewriter is based on SQL.
If you want you can put the SQL into an RPG or CL program.

Edward Hassman
Sprint E-solutions
[email protected]


>From: Graham Aberdein <[email protected]>
>Reply-To: [email protected]
>To: [email protected]
>Subject: Worldwriter F0911 Logical Files ~~0:3424
>Date: Fri, 5 Jan 2001 09:54:23 -0800 (PST)
>
>Hi there,
>
>We are experiencing some fairly lengthy run times (sometimes in excess of
>2-3 hours) for Worldwriters extracting data from the F0911 file (our F0911
>has close to 60 million records). In looking at the joblogs, it appears
>that where we have joined the F0911 to another file (e.g. the F0006 to get
>BU category code information or BU description, or the F0010 to get current
>reporting date and fiscal year), the program zeroes in on the joined fields
>as the "keys" for indexing. It also appears that in some cases it cannot
>use an existing logical file and creates one (I may be wrong on this
>assumption).
>
>The question is, can you define a specific logical file within the
>Worldwriter screens? It appears to us that the optimizer scans the logical
>files for the "best fit" based on the extraction criteria including joins
>within the Worldwriter (again, I may be wrong on this). If so, can we
>create our own logical file(s) and specify the appropriate one to be used
>with each Worldwriter?
>
>Another related question is, has anyone created "partitions" of their F0911
>(e.g. current reporting month transactions only) for reporting against?
>
>Any assistance is appreciated.
>
>Thanks,
>
>Graham G. Aberdein
>Clarica
>(519) 888-3900 x-4293
>email address: [email protected]
>running Worldsoftware A7.3 cume 11
>
>
>
>
>
>--------------------------
>To view this thread, visit the JDEList forum at:
>http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=W&Number=3424
>*************************************************************
>This is the JDEList World Mailing List.
>Archives and information on how to SUBSCRIBE, and
>UNSUBSCRIBE can be found at http://www.JDELIST.com
>*************************************************************
>

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
 
Graham,

I not sure if I had understood your questions as well. But some afirmation
sould be usefull for you:

- You can choose any logical file that already exist in your WW - You must
discover the right LF for your report-. The LF normally have the same name
of the Phisical plus a "L#" , where # is a complement such a "A" or a "B" in
order to allow many LF names.


- When you link diferent files in your WW, you creat a Join file. This
practice is usual and you can do it as free.

- Your F0911 is too BIG. I recomend a PURGE.

- You can creat news Logicals Files. But this is a technical operation based
at DDS system.



R.P.G.


From: Graham Aberdein <[email protected]>
Reply-To: [email protected]
To: [email protected]
Subject: Worldwriter F0911 Logical Files ~~0:3424
Date: Fri, 5 Jan 2001 09:54:23 -0800 (PST)

Hi there,

We are experiencing some fairly lengthy run times (sometimes in excess of
2-3 hours) for Worldwriters extracting data from the F0911 file (our F0911
has close to 60 million records). In looking at the joblogs, it appears
that where we have joined the F0911 to another file (e.g. the F0006 to get
BU category code information or BU description, or the F0010 to get current
reporting date and fiscal year), the program zeroes in on the joined fields
as the "keys" for indexing. It also appears that in some cases it cannot
use an existing logical file and creates one (I may be wrong on this
assumption).

The question is, can you define a specific logical file within the
Worldwriter screens? It appears to us that the optimizer scans the logical
files for the "best fit" based on the extraction criteria including joins
within the Worldwriter (again, I may be wrong on this). If so, can we
create our own logical file(s) and specify the appropriate one to be used
with each Worldwriter?

Another related question is, has anyone created "partitions" of their F0911
(e.g. current reporting month transactions only) for reporting against?

Any assistance is appreciated.

Thanks,

Graham G. Aberdein
Clarica
(519) 888-3900 x-4293
email address: [email protected]
running Worldsoftware A7.3 cume 11





--------------------------
To view this thread, visit the JDEList forum at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=W&Number=3424
*************************************************************
This is the JDEList World Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
*************************************************************


_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
 
Now .. this guy has the right idea about files ... he is more flagrant than
I ... I say systematic archive ...... He says .... PURGE!!
 
Graham,

Assuming you are a technical person, You can wrap a CL around the WW program.
In the CL enter the following command prior to calling the WW: CHGQRYA
QRYTIMLMT(0). Submit the CL. The job should end immediately. It will produce
a large joblog which will basically tell you exactly what the query optimizer
is looking for. You can then create a logical to speed up the process, but
with 60 mil. records it's never going to be super fast unless your logical has
selection criteria in it.

Good luck!

Gary
 
Hi Graham

We've taken the approach of dividing GL transactions into current reporting
(in our case previous 12 - 18 months) in the F0911 and prior to that in a
new file F0911OLD. We have created new join logicals over the two of these
so users can select based on what they want to see. The F0911OLD
transactions have been purged from the F0911 so the joins exclude 'BF'
documents. We have a similar record count to you.

I posted details on the List about a year ago - if you cannot trace I can
e-mail you directly, let me know. We're running A7.3 cum 10 on a 730 under
v4r4.

Regards
Nanda

Nanda Raoté
TotalFinaElf UK Limited
T: (+44) 20 8982 1406
F: (+44) 20 8795 4249
E: [email protected]




>
 
Back
Top