Hi All,
I happen to come across OE10.2B documentation, in the 'Database Administration > OpenEdge Data Management:Database Administration > Creating and Deleting Databases > Creating a database with PROSTRCT CREATE > Adding schema to a void database', mentioned the following:
When you use the PROSTRCT CREATE utility on a .st file, the resulting database files are referred to as a void database. A void database does not contain any OpenEdge RDBMS metaschema. The void database consists of the .db extent and whatever .bi, .ai, .tl, and .dn extents you defined in the .st file. You must add metaschema information to a void database. The OpenEdge RDBMS provides an empty database in the size of each supported database block size for this purpose.
To add metaschema information to a void database:
1. Use the PROCOPY utility to copy the system tables...
Is it alright for me to do just 'PROCOPY empty*.db db-name.db' only (with .st file)? If I did not understand wrongly, the 'empty*.db' contains the metaschema (system tables), the asterisk in 'empty*.db' defines the database blocksize and the '.st' file contains the .bi, .ai, extents, etc.
Thank you.
procopy will do a prostrct create if there is no db. so the answer is no.
procopy will do a prostrct create if there is no db. so the answer is no.
Thanks [mention:6e5d866d67d1447f8be4769c4267a1a1:e9ed411860ed4f2ba0265705b8793d05]!
no, do not procopy empty*.db
use the correct one.
empty.db has the default block size, whatever that may be. empty4.db has 4k block size. empty8.db has 8k block size.
if you are restoring a backup, you can do prostrct create followed by prorest.
Flag this post as spam/abuse.
Marek, you are right.
But usually, i want to change the extent layout so i do a prostrct create beforehand to be sure it works the way i want and does not run out of room.
My 1c
Gus
> On Sep 3, 2015, at 4:15 PM, Marek Bujnarowski wrote:
>
>[collapse] From: Marek Bujnarowski
> Post: RE: Is it always necessary to do 'PROSTRCT CREATE' then 'PROCOPY'?
> Posted in: Forum
> Link: https://community.progress.com/community_groups/openedge_general/f/26/p/20000/71056.aspx#71056
>
> It’s even better: you don’t have to do proctrct create before prorest. Just restore to a destination with the valid .st file.
> Running prorest with –verbose option will reveal how extents are formatted.
>
> My 2c
> Marek
>
>
>[collapse] From: gus [mailto:bounce-gus@community.progress.com]
>
> Sent: Thursday, September 03, 2015 7:50 PM
> To: TU.OE.General@community.progress.com
> Subject: Re: [Technical Users - OE General] Is it always necessary to do 'PROSTRCT CREATE' then 'PROCOPY'?
>
>
>
>
> Re: Is it always necessary to do 'PROSTRCT CREATE' then 'PROCOPY'?
>
>
> Reply by gus
>
>
> no, do not procopy empty*.db
>
> use the correct one.
>
> empty.db has the default block size, whatever that may be. empty4.db has 4k block size. empty8.db has 8k block size.
>
> if you are restoring a backup, you can do prostrct create followed by prorest.
>
>
> Stop receiving emails on this subject.
>
>
>
> Flag
> this post as spam/abuse.
>
>
> --
> You were sent this email because you opted to receive email notifications when someone created a new thread.
>
> To unsubscribe[collapse] from:
> - ...only this thread, disable notifications at https://community.progress.com/community_groups/openedge_general/f/26/p/20000/71056.aspx#71056.
> - ...all email notifications from Progress Community, navigate to "Settings", click on the "Email" tab, then under the "Email Configuration" section, set Send Notifications to "No".
>[/collapse][/collapse][/collapse]