starting the database-basic question

R

richieasir

Member
hi to all,
i have created a database with prostrct create utility.
now i want to start the database.before that as a root i started admin server using "proadsv -start".i got as "admin server alive"after that i used my login id and password and i tried to start the database but i got the error as follows:

"OpenEdge Release 10.0B05 as of Sat Apr 15 00:44:33 EDT 2006
ERROR: Unable to locate database <sports2000> (DBMan005)"

from home only i gave the command and i specified the full path where the DB has located

i dont know what wrong exactly i did. please help it out to start the DB in a clear way and pls give me a brief description in it(how to start and all)

regards
Richards
 
hi Richards,

Please let me know which command u have tried and the syntax which u were trying...

and if it is ok, then try/check whether u have used the correct database name and correct database path.

Thanks.
Praba.
 
hi,
i created the database using prodel.i just created the database using the existing one which has got created during progress installation.
after that i want to start the database(am not using any gui tool)..si i studied that beore starting u hav to start the admin server.so as a root i started the adminserver as proadsv -start in which i got the respond as adminserver alive.then i used my login id and password to enter.
after that i gave the cmd dbman -database db name(here i gave the full path of the database) -start

after that i got error as
"OpenEdge Release 10.0B05 as of Sat Apr 15 00:44:33 EDT 2006
ERROR: Unable to locate database <sports2000> (DBMan005)"
can u give me before starting the database what are the thing i want to do and the command to start the database.

regards
Richards
 
richieasir said:
hi,
i created the database using prodel
Click to expand...

I hope not. PRODEL deletes databases. It doesn't create them.

...
after that i got error as
"OpenEdge Release 10.0B05 as of Sat Apr 15 00:44:33 EDT 2006
ERROR: Unable to locate database <sports2000> (DBMan005)"
Click to expand...

That would be the expected error after using prodel.

To create a database for testing purposes use something like:

prodb sports sports

You can start that db using:

proserve sports

And start a session connecting to it with:

mpro sports
 
Does proserve sports2000 work?

Unless you're a glutton for punishment or have some reason other than starting databases for using the admin server I would just use proserve.
 
hi all,
thanks a lot for ur kind reply.....

ya proserve is working fine
but my doubt is"without starting the admin server how am able to start the database using proserve."
what is the usage of admin server and do it have any relation in starting the database using proserve utility..if it please explain me in detail?
with pro and mpro am able to connectto the database bu i didnt use any commands to start the admin server...how?

regards
Richards
 
The admin server is the back-end for the GUI tool used for administering databases and app servers.

That tool is fondly known as "Progress Exploder". It is quite possibly the worst GUI tool ever created. It is not actually possible to describe how bad it is. That can only be understood by trying to use it. Trust me, you are better off not going through that experience.

Luckily you don't have to actually use Exploder. You can script your db admin process the old fashioned way. Or you can use "dbman". Unless you're planning to use app servers there really isn't much incentive to go down the admin server path.

The admin server is optional. You do not have to use it to start and stop databases or to do anything else with databases.

But if you are a glutton for punishment and insist on using it anyway you will need to get comfortable with conmgr.properties. Your original problem was probably a lack of configuration of your target database in conmgr.properties. The canonical way to set that up is to use exploder. But, as I mentioned above, that is not something that I would wish upon anyone. Except maybe Bill Gates and Larry Ellison.
 
hi all,
thanks for ur kind reply
now i started using dbman utility to start the database but am getting the error "Unable to locate the database"

i know that wen using dbman,the database name should match with conmgr.properies file DB name...

now my question is

1) "how i can edit the conmgr.properties file bcos the document stated that u should not touch conmgr.properties file directly instead use progress explorer tool to edit it but am not using any such GUI tool.can i use vi editor to edit it(i didnt try,with ur advice i will do)?"

2) is ubroker.properties is same as conmgr.properties file,what is its difference?

please explain me in detail of the above mentioned?"

regards
Richards
 
Yes, you can edit conmgr.properties with any text editor. Be aware that if anyone ever uses exploder on your system it will probably completely screw up your changes. So make sure that you have a good backup of the file.

conmgr.properties is for databases ubroker.properties is used for everything that the adminserver does except for starting databases.
 
hi tom,
thanks for ur kind reply

but "is progress exploder a GUI tool as same as progress explorer"
(am not having any GUI tool in my system)

could u please say me

1) the relation between block size and records per block bcos

2) i got an information that there is no relation between block size and extent size,is it true Mr.tom?

3) i created a large database which extent size crosses some GB's.first i created it with block size 4096 and in large.st file, i gave records per block as 32 and while defining the application area,i gave one variable and one fixed extent for all the applications. now i copied the structure file of the large DB which i created already and i created another one .st file (say largedb.st)and created a database with 8192 block size and i added some extents to already existing application area of the new .st file(say largedb.st) using prostrct add dbname new .stfile and the extent i created is a variable one.(i didnt define size for the variable extents for both the database say large.st and largedb.st)

Already i defined one variable extent there and am adding a new variable extent to it and after adding , i gave the cmd prostrct list largedb(just for updation).In that i could observe that the new extent which i added was there (which is a variable one) and already existing variable extent becomes a fixed one but i could see the new extent size of that fixed one is 128 and the newly added variable extent size is 32.

( i know that if we are not mentioning variable extent size,initially it wil be defined as 32 since its a default value but

why such variations(how 128 comes in it)? how the extent size has to be defined..based on records pr block or based on block size?
 
"Exploder" = "Explorer". If you are running Windows it is installed.

I've started a new thread for your other question.
 
You must log in or register to reply here.
Back
Top