Finding if large database file is enabled

T

tej

New Member
Hi

just regsitered to this forum as i have just started programming in progress!

I have a question regarding large database sizes.

Is there anyway of finding out within progress to see if the large database file access has been enabled.

I have run a proutil which made an entry in the .lg file as shown below:

11:07:44 proutil -C enableLargeFiles session begin for administrator on CON:. (451)
11:07:44 Large database file access enabled for database tejdb. (9425)
11:07:44 proutil -C enableLargeFiles session end. (334)

My problem is that the log files will be massive and processing will take some time depending on the size.

Is there a flag which is set within progress to show that the large databases have been enabled.

Look forward to the reply.

Cheers
TJ
 
Hi Tej,

The easiest way to do that is look in the db log file to see if it has been enabeleds....

If you want another solution(s) you could take a look at KBP35250:


o To see if Large File Support is enabled you can run the
undocumented and unsupported dbrpr utility, option 4, to dump the
master block.
You will first need to truncate the bi and this is an offline utility,
so it can't be run against the live database. It is reasonable to
assume, in the absence of change management procedures, that the
database would have been backed up before this operation was
undertaken, so that last known backup could be restored and
investigated, or a probkup -norecover of a hotspare database could be
used.
Dump DBKEY 32 for all block sizes except 8K.
For 8K database blocksize, dump DBKEY 64.
In the resulting 32.dmp or 64.dmp file:
HEX offset 22 is the largefile enabled flag and is equal to:
01 if Large Files are enabled,
00 if they are not.
Below is an example:
# BLOCK REPAIR UTILITIES
# DATABASE = /usr/db/sports.db
# AREA = Schema Area
# DBKEY = 32
# BLOCK NUM = 1

>0000 0000 0020 017F 0002 0000 0000 0000 000B
>0010 045B 0000 0000 0003 0000 0000 0002 0000
>0020 0000 0100 0000 0000 0001 4CD3 0000 0000
mmmmmmmmmmm^^
Click to expand...

http://tinyurl.com/damfy

HTH,

Casper.
 
You must log in or register to reply here.
Back
Top