Thanks, Noah, for the tip, that works great! One more question, do you all see customers running multiple sapdb database instances (from the same version or different version - 7.3 or/and 7.4) on the same machine often?
Also, if it's in a cluster environment, will they put multiple database instances in the same cluster (on the same cluster node or different nodes)? Thanks! -serine > To: Serine Wu <[EMAIL PROTECTED]> > Cc: [EMAIL PROTECTED] > Subject: Re: How to create the sapdb database instances ? > X-MIMETrack: S/MIME Sign by Notes Client on Noah J SILVA/INT/CHEM/Corp(Release 5.0.8 |June 18, 2001) at 02/06/2003 02:59:29 PM, Serialize by Notes Client on Noah J SILVA/INT/CHEM/Corp(Release 5.0.8 |June 18, 2001) at 02/06/2003 02:59:29 PM, Serialize complete at 02/06/2003 02:59:29 PM, S/MIME Sign failed at 02/06/2003 02:59:29 PM: The cryptographic key was not found, Serialize by Router on AMHB1SMG02/SRV/INT/CHEM/Corp(Release 5.0.8 |June 18, 2001) at 02/06/2003 09:00:16 PM, Serialize complete at 02/06/2003 09:00:16 PM > MIME-Version: 1.0 > Content-Transfer-Encoding: 7bit > > -Hi, > - > -I don't know much about SAPDB. I just installed the sapdb server 7.4 and > I need > -to create some database instances. The SAPDB installation manual didn't > cover > -how to do that and I don't see any scripts from the installation dir that > let > -you create a database besides the SDBINST script. > > Hi, > > There is a script that will create a test database. You could modify this > script to change the parameters. Alternatively, you could use the DBMGUI > program to create a new database manually. One pitfall to watch out for > is that you can't make very small databases (like 1mb or something), > because the system tables require space. Unfortunately, the DBMGUI > doesn't prevent you from trying to do this. > > -Then I was looking at the SAP DB Loader: SAP DB 7.4 manual, but the > commands are > -a bit over my head - the doc provides you with a command to extract the > DB > -<dbextract_statement>::=DBEXTRACT ..., but where do you run that command > ? The > -command looks like SQL. What tool I need to run first before I execute > the > -command? > > Loader is actually used to load data into (or save data out of) an > existing table in an existing database using an existing login account. > You can easil create a .BAT file (or shell script) that will call the DB > Loader and pass it a DB-Loader script file. The script file will contain > the DBEXTRACT (or whatever) statement. The DB-Loader can be used to do > other things like run arbitrary SQL code also. > > -I don't need to do any real work inside the database, just to bring it up > and > -down. Is there any other way to create some database instances like when > you > -install R/3, the oracle database is automatically install and populated > for you, > -or other docs that I should be reading? > > Again you should look at the test database. You can find this on the web > page at http://www.sapdb.org. > > -Thanks for any pointers in advance! > --serine > > thanks, > noah silva > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
