Enable large files.

Arunselvan

Member
Hi all,

I have doubt about Large files.

While creating Database, in .st file, if we specify size of any extent more than 2 gb, It will be large file enabled database.

Consider if i am creating a database with structure like below
#
b .
#
d “Schema Area” .
#
d “Employee” :7,32 /usr1/emp f 1024
d “Employee” :7,32 /usr1/emp


here i didn't specify 2 gb for any extend.

my question is, if it is not a large files enabled database, the variable length extents in this database wont grow more than 2 gb?
 

TomBascom

Curmudgeon
Large files are usually enabled by using proutil.

The values that you put in a .st file will result in "large files" being turned on if you happen to have an extent larger that 2GB.

If you do not use "proutil dbname -C enablelargefiles" or have a large extent in your structure file you will have a "small files" db.

You can check your db, and satisfy your doubt, using "proutil dbname -C describe".
 

Arunselvan

Member
Thank you Tom.

if any variable length extent cross 2 gb, Then will it become large file DB?

If that means what is the use of having separate utility to enable large file?
 

Rob Fitzpatrick

ProgressTalk.com Sponsor
If a database is not currently enabled for large files then variable extents will not grow past 2 GB. When an extent reaches 2 GB in size, an attempt to write to it will fail and the database will shut down.

If you use only Enterprise licenses with your database then there is no reason not to enable large file support in it.
 
Top