Extend Database (NF 2.51 on AIX)

kszymanski

Hello,

cause we get in trouble with our databaseusage (yet round about 90% from 32 gig) we install a new (64 gig) license (we
received from our solution partner) on our rs6000. Works fine. Now we can extend aour database upto 96 gig.

Now all databasefiles (called fin1.fdb to fin16.fdb) have a size of 2 gig. So io try to extend the first databasefile to 3 gig.

But the i get an error (sorry, only german):

Der Server meldet

Das Betriebssystem meldet einen Fehler
(22):

invalid argument.

There is enought space on disk (total 70 gig so 48 gig left for extending databasefiles). Also i can access the drive (i create a 32 gigfile with trash for testing on this partition by hand).

What is going wrong ?

Thanks.

Kai.

John_Tegelaar

1) Total size is limited to 64G (not 96)

2) Each segment still has limit of 2G, so you need to make more segments.

3) Better to upgrade to 2.60(F) or Attain.

John

kszymanski

Hi John,

> 1) Total size is limited to 64G (not 96)

I know <img border="0" title="" alt="" src="images/smiles/icon_wink.gif" />

> 2) Each segment still has limit of 2G, so > you need to make more segments.

Not on a 64bit Processor...or is this a
'Navisionfeature' ? But i try to create a new 2gig File instead. Then i get the errormessage 'You can only have 16 databasefiles' (i translate it from german).

> 3) Better to upgrade to 2.60(F) or Attain.

Exists 2.60(F) for AIX (without using Microsoft SQL Server) ? What is the different between 2.51 and 2.60(F) ?

> John

Kai.

kszymanski

Hi once again John.

I extend our Database on our development machine (Windows NT 4.0). There i can create databasefiles with 4 gig (16 pieces). Are
you sure that i can do it on AIX ?

Bye,
Kai.

John_Tegelaar

Don't have experience with AIX myself, but even on the latest Attain version, an AIX server is still included.

In fact, when Navision (NL) announced the 64GB expansion option, it was clearly stated that it would be available for Windows and AIX only. And for NF version 2.60E up.

Looking at the Readme file for AIX server on the CD, there are some notes on parameters to set. One of these is MAX FILE SIZE.

Your processor might be 64 bits, but if the code is still using 16 bit adressing, your file limit will still be 2 GB. Could be a reason to have a look at a later version of the AIX server. NF 2.5 is quite old (1999) and many improvements has been implemented since then.

John

Luc_VanDyck

I remember a problem we had with Progress on an IBM RS/6000 (AIX) machine. Our application crashed, when the database reached the limit of 2 GB. The problem was the ULIMIT parameter. When you type ULIMIT on a Unix prompt, it shows you the max. filesize. You can modify this value somewhere (we used the setup-program SMIT for that).

Hope this helps.