Survey: How big is your F0911?

We are curious how our largest file ranks with other companies. We have 81 million records sizing out at about 60 gigs.
How big is your F0911?

[ QUOTE ]
We are curious how our largest file ranks with other companies. We have 81 million records sizing out at about 60 gigs.
How big is your F0911?

[/ QUOTE ]

A gentleman never brags about the size of his F0911.

Go ahead, make me laugh.

[ QUOTE ]
How big is your...
We are curious how our largest ...

[/ QUOTE ]
Ooooops, is it JDEList?

Would be interesting the count of different transactions.
ALSO:
- how many years in Production
- how many Company
- how many Business Unit
- (how many Users)

I had seen a setup once upon a time, where General Ledger were divided to several Sub Accounts / (SUB) and produced useless entries in F0911.

Regards,

Zoltán

I would add to Zoltán's list:

- How many ledgers

ok - since this is the JDE list and not the functional JDE Applications list, could you not change these requests to "how many records in the F0902, F0911 and F0006" or something similar - that way, Techies here have the ability to get you the info - otherwise, they'd be completely stumped...

(I'm not including myself of course !!!!)

OK, one more time for the dummies ... er ... techies (excluding Jon ... of course ... and may be others ... may be ...)

- how many years in Production
select count(distinct(glctry||glfy)) from f0911

- how many Company
select count(distinct(glco)) from f0911

- how many Business Unit
select count(distinct(glmcu)) from f0911

- (how many Users)
select count(distinct(gluser)) from f0911

- How many ledgers
select count(distinct(gllt)) from f0911

Yeah I know that the details above can be retrieved from other tables (respectively F0008, F0010, F0006, F0092, F0025) but it is possible and, in some cases, even likely, that some values do not exist in the F0911. However, running a SQL on the other tables would be a considerably quicker, but let's not tell the dummies ... er ... techies (excluding ... well you know the rest).

LOL funny!!!! I find that most companies that brag about the size of their F0911 are usually compensating for other shortcomings... like maybe an unusually small F42199.

[ QUOTE ]
LOL funny!!!! I find that most companies that brag about the size of their F0911 are usually compensating for other shortcomings... like maybe an unusually small F42199.

[/ QUOTE ]

And they drive around in overpriced muscle cars like Corvettes.....

I ran a SQL count last week and its still running. I'll let you know by end of NEXT month.

[ QUOTE ]
[ QUOTE ]
LOL funny!!!! I find that most companies that brag about the size of their F0911 are usually compensating for other shortcomings... like maybe an unusually small F42199.

[/ QUOTE ]

And they drive around in overpriced muscle cars like Corvettes.....

[/ QUOTE ]

And what is wrong with driving a vette? I drive one to overcompensate for um.. well... I shouldn't mention that here

96,000,000+ entries
75,787,182,080 bytes

ok - pulling this back on track....

Here is one customers F0911 counts on Intel platform running Microsoft SQL Server 2005, EnterpriseOne 8.12.8.96.2.2:

select count(*) from proddta.f0911
17705162
select count(distinct(glctry+glfy)) from proddta.f0911
13
select count(distinct(glco)) from proddta.f0911
6
select count(distinct(glmcu)) from proddta.f0911
2564
select count(distinct(gluser)) from proddta.f0911
106
select count(distinct(gllt)) from proddta.f0911
6

Another, manufacturing companies data - on AS/400 with EnterpriseOne 8.12.8.97:

select count(*) from proddta/f0911
5425532
select count(distinct(glctry||glfy)) from proddta/f0911
4
select count(distinct(glco)) from proddta.f0911
174
select count(distinct(glmcu)) from proddta.f0911
1505
select count(distinct(gluser)) from proddta.f0911
166
select count(distinct(gllt)) from proddta.f0911
12

We are approaching 223,000,000 rows...

heres our counts - we are on SQL Server 2005 SP3, Windows 2003 64 bit, E1 8.12, 8.97.1.1
select count(*) from proddta.f0911
9794453
select count(distinct(glctry+glfy)) from proddta.f0911
15
select count(distinct(glco)) from proddta.f0911
40
select count(distinct(glmcu)) from proddta.f0911
4645
select count(distinct(gluser)) from proddta.f0911
252
select count(distinct(gllt)) from proddta.f0911
12

[ QUOTE ]
We are approaching 223,000,000 rows...

[/ QUOTE ]Can you provide the F0911 searches, as others are doing - that way, we can really understand what "223million" rows actually equates to.

I know of customers with billions of rows - I'm trying to get those customers to run these SQL statements as well

Ok, since I posted the SQLs that most seem to be using, I suppose I'd better post my results too. Here they are:

- how many rows in F0911
select count(1) from proddta.f0911
14904406

- how many years in Production
select count(distinct(glctry||glfy)) from proddta.f0911
16

- how many Company
select count(distinct(glco)) from proddta.f0911
8

- how many Business Unit
select count(distinct(glmcu)) from proddta.f0911
14289

- (how many Users)
select count(distinct(gluser)) from proddta.f0911
165

- How many ledgers
select count(distinct(gllt)) from proddta.f0911
9

I want to throw our stats in!

how many rows in F0911
select count(1) from proddta.f0911

169,065,805

- how many years in Production
select count(distinct(glctry||glfy)) from proddta.f0911

15

- how many Company
select count(distinct(glco)) from proddta.f0911

244

- how many Business Unit
select count(distinct(glmcu)) from proddta.f0911

9735

- (how many Users)
select count(distinct(gluser)) from proddta.f0911

679

- How many ledgers
select count(distinct(gllt)) from proddta.f0911

7

-----------------------------------
Emma