cancel
Showing results for 
Search instead for 
Did you mean: 

AL11 - Length of file

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Dear Toan Do,

databases are working with sparse files. The database files initially are getting created

with the value you propose in sapinst - but at the beginning they are almost empty

and will be filled the longer the users make their updates. I hope this explains.

Kind regards,

Andreas

Former Member
0 Kudos

HI

Please check the following SAP notes:

32574 - Display the length of files in SAP directories

987732 - AL11: Length specification missing from attributes

I hope its of some help for you.

regards

Chen

Former Member
0 Kudos

Hi Chen,

Thanks, but it's not my case.

Regards,