Question Need to enable large file.

[Mike]

Progress version: - 10.2b
db size:- 120 GB

How to enable large file here. Is that below steps correct? Please correct me if i am missing any steps.
1:- Shut down the database.
2:- proutil dbname -C enablelargefile.
3:- Start the db

Do we need to truncate bi ??
Please correct me if i am wrong.


Below is structure file of Database:-
#
b /db1/batchq.b1
#
d "Schema Area":6,64;1 /db1/batchq.d1
#
d "Data Area":7,32;1 /db1/batchq_7.d1 209000
d "Data Area":7,32;1 /db1/batchq_7.d2
#
d "Index Area":8,32;1 /db1/batchq_8.d1

 

[Rob Fitzpatrick]

That will work, though note that the proutil qualifier is enablelargefiles (note the "s" at the end). You don't need to truncate the BI. This requires an Enterprise RDBMS license.

 

[Mike]

That will work, though note that the proutil qualifier is enablelargefiles (note the "s" at the end). You don't need to truncate the BI. This requires an Enterprise RDBMS license.

Hi Rob,

Appreciated for your reply.
One more doubt Is large file will work on Bi file 2 gb limit as well? for example if we enable large file and bi file cross limit of 2gb .Will it works?

 

[Cringer]

Yes.

 

[TomBascom]

You say that you are on 10.2B so there is no longer a 2GB bi limit.

 

[Patrice Perrot]

You can use largefile with a size limit if you specify v + size,
Example below is a limit of 2Gb for a variable BI
b . v 2048000