ST File

D

dipu

New Member
Hi

Can any body help me ?
I did one line manually added in ST file. after that I restore the database, but changes is not reflecting. still getting error messages *_7.d2 is over limited.

What i have to do ?

Thanks
 
You could start by sharing the exact and complete error message as well as providing the relevant portion of the .st file.

You should also reveal the version of Progress that you are using and what OS you are using it with.
 
Hi Tom

Error message is "Attempted to exceed maximum size of file *_7.d3". d3 is already exceed 2 GB. How i will modify st file and update.

Thanks
 
Well, Tom asked you a few things:
  • content of st file
  • Exact error message
  • Progress version (+ sp level)
  • OS
Thusfar you failed to answer any of these, so I think it is unlikely that you will get an answer.

Casper
 
1. St file : mfgprod.st file contians some many line including following lines

d "TRANSACTION":7,64 L:\DB\TRANSACTION\mfgprod_7.d1 f 1572864
d "TRANSACTION":7,64 L:\DB\TRANSACTION\mfgprod_7.d2 f 1048576
d "TRANSACTION":7,64 L:\DB\TRANSACTION\mfgprod_7.d3

2. Error : Attempt to exceed maximum size of on file L:\DB\TRANSACTION\mfgprod_7.d3

3. Prgoress version : 9.1D

4. OS : Win2000

Now I want to add two more line in mfgprod.st file and restore database:

d "TRANSACTION":7,64 L:\DB\TRANSACTION\mfgprod_7.d3 f 1048576
d "TRANSACTION":7,64 L:\DB\TRANSACTION\mfgprod_7.d4

ERROR message is shoiwng while i am trying to restore the database and
currently L:\DB\TRANSACTION\mfgprod_7.d3 which exceed 2 GB.


Thanks
 
Read about the prostruct command, you need to do a prostruct add to add a new variable extent. You can not just modify the .st and restore the database.
 
Reading between the lines a bit, it sounds like you have already reached the 2GB limit on your d3 extent. If that is the case, you can't just do an add, I don't believe. I think you are on the right track of doing a backup and restore, but I suspect that what you have neglected to do is to erase the old database and build a void database based on the modified .st file before starting your restore.
 
You need to create an add.st file that will change the current variable extent to fixed and add a new fixed and a new variable.

the command is
prostrct add dbname add.st

Please see the Progress knowledge base (P7697) or read the Database Administration manual for examples.
 
Cecil

Thanks , restored the database and working.
I have one question ? Instated of another new st file, can we add
new lines in existing st file ? if yes then how ?
example: Current st file is "A" , what i did create new st file "B" with new lines. I want to update "A" with new lines .

Thanks again for your co operation.
 
There are two very different approaches. One is a new .st with only the changes in order to add extents without backup and restore. The other is a complete .st used to build a void database. There is no edit the existing .st and the get it to notice what's different.

Note too the list option to get a .st that corresponds to the current DB. Useful when you do the add.st bit.
 
dipu said:
Cecil

Thanks , restored the database and working.
I have one question ? Instated of another new st file, can we add
new lines in existing st file ? if yes then how ?
example: Current st file is "A" , what i did create new st file "B" with new lines. I want to update "A" with new lines .

Thanks again for your co operation.
Click to expand...

Perform a "prostrct dbname list", this will generate a new dbname.st file from the current physical structure of the database. I have seen places that generate a new .st file every backup cycle, this is copied to a backup location in case of a hardware failure that would require a recovery from backup to new hardware. This will allow for appropriate editing of the .st file to match the new hardware if there are differences.
 
You must log in or register to reply here.
Back
Top