I just began to use SAP DB last week and got the same problem because the lack of "first steps".
 
AFAIK, XSERVER is the service which DB admin tools connects.
_CTEMPSA have no idea.
 
You must create your own instance. Install the DBMGUI (Database Manager), open it and select from main menu Instance -> Install. It starts the dabase wizard. Follow each step. When I create my first instace I found two problems:
 
1. The data volumes should have at least 16 Mb because system tables and temp space are create there. If you use too small data volumes the wizard doesn't complain abaout and the step where system tables are created fail.
 
2. Dont use reserved word for DBO or DBA users. I use regulary FireBird (www.firebirdsql.org) and Interbase then I want SYSDBA as the DBA user but it is a reserved word then the system table create step fail also.
 
I still don't understand how works data volumes / log volumes / backup. It seems that the log is cleared until backup. I haven't chance to experiment to understand it but as far as I see, I think that SAP DB is a good replacement for my favorite OS DB: FireBird.
 
Regards.
"Alejandro Michelin Salomon ( Adinet )" <[EMAIL PROTECTED]> escribi� en el mensaje news:003401c29d25$a52373b0$0533010a@hercules...
I install the sap db server in my computer, from this package :
 
sapdb-server-win-32bit-i386-7_3_0_29.zip
 
The instalation create two services :
 
XSERVER
_CTEMPSA --> What is this service ?
 
 
The instalation create a db instance or i need to create a instance ?
 
The sap db server has a dba user for the entired server or each database has own dba user ?
 
Do you can help my ?
 
Alejandro Michelin Salomon
 

Reply via email to