Database creation issue.

[anandknr]

Hi All,

I need to create a database having same schema of an existing one.

The steps i am following for that is
1) Copy the .ST files to a diff location
2) Modify the paths accordingly
3) Dump the DF from the existing DB.
4) prostrct create <DB-Name> <ST file name> -blocksize 8192
5) procopy $DLC/empty8 <DB-Name>
6) Load the DF to the newly created DB

Above steps perfectly when both the new and old db are in linux.

But now i need to create a db in windows having same schema as in linux db.
When i followed above mentioned step i got stuck with 5th step.
I am getting the error as below
"proenv>procopy $DLC\empty8 D:\cm\qm2\dsSHP\db\dsSHP
OpenEdge Release 10.2B as of Mon Dec 14 17:02:01 EST 2009
** Cannot find or open file C:\OpenEdge\WRK\$DLC\empty8.db, errno = 2. (43)
Event Logger error 997: Could not post a 'DSSHP_PROGRESS' event to the Event Vie
wer. (5180)"

Still i went to start the db using proserve command and it ended up in below error.
proenv>proserve D:\cm\qm2\dsSHP\db\dsSHP
OpenEdge Release 10.2B as of Mon Dec 14 17:02:01 EST 2009
13:42:08 BROKER Event Logger error 997: Could not post a 'DSSHP_PROGRESS' ev
ent to the Event Viewer. (5180)
13:42:08 BROKER This broker will terminate when session ends. (5405)
13:42:08 BROKER Event Logger error 997: Could not post a 'DSSHP_PROGRESS' ev
ent to the Event Viewer. (5180)
13:42:08 BROKER The startup of this database requires 28Mb of shared memory.
Maximum segment size is 128Mb.
13:42:08 BROKER 0: Event Logger error 997: Could not post a 'DSSHP_PROGRESS' ev
ent to the Event Viewer. (5180)
13:42:08- BROKER 0: D:\cm\qm2\dsSHP\db\dsSHP is a void multi-volume database.
(613)
13:42:09 BROKER Event Logger error 997: Could not post a 'DSSHP_PROGRESS' ev
ent to the Event Viewer. (5180)
13:42:09 BROKER ** This process terminated with exit code 1. (8619)



So is any alternative for step 5 in windows enviroment ? Please help..... Hi all,

 

[rstanciu]

on windows:
procopy %DLC%\empty8 <DB-Name>

 

[rzr]

that Or...

1. Open Datadictionary
2. From the menu, select Database - Create
3. Enter the physical database name. Ex: C:\MyDbFolder\NewDb ( NewDb is the name for new database )
4. Select "An Empty Database Option"
5. Press <Ok>

Now load the df file this new db from the data administration tool.

 

[anandknr]

In linux when i checked inside $DLC folder i had found an empty8.db file .
But in windows i can't find such an .db file. Where it could be ??

Also what is the windows version of echo $DLC command . I need to check the $DLC folder.

 

[anandknr]

Ok did it with datadictionary method...Thanx for the advice

 

[rstanciu]

echo %DLC% ???

 

[rzr]

yes from command promt type: echo %DLC%

the empty db's (1,2,4,8) will be present in the %DLC% directory.