Unable to Increase the size of DAT file

[Kumar_Sanjay]

I created few files for the database.

$ MCR sysgen CREATE/SIZE=1000 $1$DGA5123:[APPDEV.RND]INDH.DAT
$ set file/backup $1$DGA51111:[APPDEV.RND]INDH.DAT

dir Directory $1$DGA5123:[APPDEV.RND]

INDH.DAT;1 1000/1020 21-AUG-2007 08:07:48.97

Now I want to Increse the size of this dat file and I tried with
$ Set file/exten=8000 $1$DGA5123:[APPDEV.RND]INDH.DAT

but after that if i do the dir...it is showing same as old.
Can please someone help.

[Duncan Morris]

Hi,

the SET FILE/EXTEN command is used to set the extend quantity default for the file.

You should use SYSGEN CREATE to extend your file.

DEVT02> MCR sysgen CREATE/SIZE=1000 x.y
%SYSGEN-I-CREATED, DISK$USERS:[MORRISD]X.Y;1 created
DEVT02> dir/siz=all x.y

Directory DISK$USERS:[MORRISD]

X.Y;1 1000/1035

Total of 1 file, 1000/1035 blocks.
DEVT02> MCR sysgen CREATE/SIZE=8000 x.y
%SYSGEN-I-EXTENDED, DISK$USERS:[MORRISD]X.Y;1 extended
DEVT02> dir/siz=all x.y

Directory DISK$USERS:[MORRISD]

X.Y;1 8000/8004

Total of 1 file, 8000/8004 blocks.
DEVT02>

Regards,

Duncan

[Jan van den Ende]

Hi,

For (nearly) all file activity, the VMS filesystem (RMS) will automagically extend the file when needed (exceptions, as eg relative files) need o.a. special FDSs when creating the file).
The amount witt which such extension happens, can be influenced with SET FILE /EXTEND=..
A file. like that created with your command, will need NO special actions to extend, other than writing to it when it has no more capacity.

hth

Proost.

Have one on me.

jpe

[Jan van den Ende]

and, if you want to see the effect of SET FILE/EXTEND, do a DIR/FULL INDH.DAT.

Look for the text Exted Quantity.

Do a SET FILE/EXTEND- with some other value, repeat the DIR, and notice the differenc.

btw,
what is your intent with SET FILE/BACKUP ?

Any created file automatically has that attribute set, unless (by FDL) it has been explicitly switched off, or after creation a SET FILE /NOBACKUP has been issued.
It controls how the BACKUP command deal with the content of the file.

hth

Proost.

Have one on me.

jpe

[Robert Gezelter]

CA1467620,

As has been previously noted, the file can be extended.

The post implies that the file was believed to be marked NOBACKUP. Why? As Jan has noted, BACKUP is the default.

- Bob Gezelter, http://www.rlgsc.com

[Jon Pinkley]

Bob,

The reason it is marked /nobackup (and most likely /nomove) is because it was created with SYSGEN, which normally is used to create PAGE and SWAP files.

[Jan van den Ende]

Jon,

You are right. I stand corrected. I just read CREATE, and overlooked SYSGEN.
That also means my ramblings about FDL are out of place.
But then again, it never occurred to me to create data files with SYSGEN.
Only goes to show one is never too old to learn new means to use utilities...
I leave it open to discussion wether is _IS_ a specific use, or an abuse. I would be curious about legitimate uses of SYSGEN CREATE apart from the obvious system files.

Hein???

Proost.

Have one on me.

jpe

[Kumar_Sanjay]

This is the application requirement that you must create the file using SYSGEN for Database.
Also the second command â set file/backupâ is also requirement of application.

[Jan van den Ende]

CA1467620,

Now you got me interested. What is the database management system?

And like Jon explained, SET FILE/BACKUP _IS_ quite the thing to do after SYSGEN CREATE.

Proost.

Have one on me.

jpe

[Robert Gezelter]

Jon,

I beg to differ. At least on 7.3-2, a simple experiment using SYSGEN CREATE does not set the NOBACKUP flag (log attached; same behavior seen on 6.2).

I to expected SYSGEN create to set the NOBACKUP bit. I do not have time at this instant to track down who actually sets the bit in the case of the page file. An earlier version of the attached test seems to indicate (but I have not verified) that the bit is propagated when later versions are created).

- Bob Gezelter, http://www.rlgsc.com