AL11 - Length of file

[Former Member]

Dear all,

My SAP system is ERP 6.0 with SQL Server 2005 in Wins 2k3.

I find a strange situation as below:

- In TCode AL11, every file has column "Length of file". I find that the column "Length of file" shows the real size of each file (in Wins); but for SQL data files & SQL log file, it's NOT true. Here's an example:

TSTDATA1.MDF:

• AL11: 1497366528*

• Wins: 29.3GB*

TSTDATA2.NDF:

• AL11: 301989888*

• Wins: 28.2GB*

TSTDATA3.NDF:

• AL11: 301989888*

• Wins: 28.2GB*

TSTDATA4.NDF:

• AL11: 427819008*

• Wins: 28.3GB*

TSTDATA5.NDF:

• AL11: 553648128*

• Wins: 28.5GB*

TSTDATA6.NDF:

• AL11: 742391808*

• Wins: 28.6GB*

TSTDATA7.NDF:

• AL11: 994050048*

• Wins: 28.9GB*

TSTLOG1.LDF

• AL11: 52166656*

• Wins: 7.95GB*

Column "Length of file"'s value is very different from Wins' value. Anyone can explain this situation?

Thanks,

Toan Do

[Former Member]

Hi J. Haynes,

Real file size (OS file size) is in the row "Wins: <x>GB".

Hi Antarpreet,

About AL11 folder mapping/configuration, can you show me how to check it?

Hi Eric Brunelle,

My DB backup file is more than 200GB and AL11 showa the exact size, so I think there's no problem with 2GB or bigger size file.

Regards,

Toan Do

[Former Member]

Hello Toan,

This must have been done in the file transaction. Because the Datafiels are usually in other drive and by default not visible in AL11 transaction!

The path defined in File transaction needs to be rechecked!

Hope this helps!

Thanks & Regards,

Antarpreet

[Former Member]

Hi Antarpreet,

I'm afraid that I cannot find a relationship bet. AL11 & FILE (for defining logical file path) :(.

Regards,

Toan Do

[former_member204746]

my feeling is that AL11 has problems with files that are 2GB or more.

[Former Member]

Hi,

It seems that the AL11 folder mapping/ configuration needs to be rechecked!

Thanks,

Antarpreet

[Former Member]

SAP pulls this information using a C call (via the kernel) to the operating system. So this is more than likely just a rounding issue. When you view the files on the server in the properties screen, what are the file sizes you are seeing there?

J. Haynes