Recently one of my blog readers asked me about installing the Netweaver Developer Studio using an alternative version of MaxDB. This is something I haven’t thought about much, since the installations that I’ve done were local installations, for my own use, and normally from scratch. They served the only purpose to allow myself to have a local portal system on my laptop, enabling me to build and run my own custom Web Dynpro applications, run ESS and MSS applications, etc. without having to use a “middleware” framework such as the NWDI (Netweaver Developer Infrastructure).
For anyone who doesn’t know this fact, from version 7.5, SAP DB is distributed under a new name which is MaxDB.
If your scenario is a fresh installation of Netweaver Developer Workplace but the MaxDB version doesn’t suit your needs, please take a look at the steps below, it will help you to learn how to install or drop a MaxDB instance.
1. How to install a MaxDB Instance
Start by creating a new database instance and specify the First Database Manager Operator:
dbmcli db_create <database_name> <DBM_user>,<DBM_password>
At this stage, you will have several different options to consider, depending on your needs and objective:
If you have more than one version of the database software installed, you must specify the version to be used, indicating the option:
-R <dependent_path>
To install a new database instance remotely, use the following option, to specify the remote computer and identify yourself towards the operating system of this computer:
-n <server_node> dbmcli -n <server_node> db_create <database_name> <DBM_user> ,<DBM_password> <OS_userid>,<OS_password>
In case you use a Unix operating system, it doesn’t distinguish between remote and local communication. Therefore, you always must identify yourself towards the operating system. If you create a new database locally, you can avoid the identification using the option -s:
dbmcli -s db_create <database_instance> <DBM_user>,<DBM_password>
Use a Database Manager CLI script to complete the installation.
dbmcli -d <database_name> -u <DBM_user>,<DBM_password> -i <script_file>
Sample script:
param_startsession param_init param_put MAXUSERTASKS 5 param_checkall param_commitsession param_addvolume 1 LOG LOG_001 F 2000 param_addvolume 1 DATA DAT_001 F 10000 db_admin util_connect util_execute INIT CONFIG util_activate <SYSDBA_userid>,<SYSDBA_password> util_release load_systab -ud <DOMAIN_password>
Of course you should change the parameters to suit your own needs. User SYSDBA is the first Database User, which is able to create additional users for the new database instance.
2. How to drop a MaxDB Instance
Start by stopping the database instance
dbmcli -d <database_instance> -u <DBM_userid>,<DBM_password> db_stop
Delete the database instance on the database server
dbmcli -d <database_instance> -u <DBM_userid>,<DBM_password> db_drop
The result is the deletion of the database instance.
Working as an Information Systems Consultant for over 10 years now, I've found that working with SAP brought me added value on how to deal and manage IT and Information Systems Projects. More than a hobby, this blog is aimed to propagate SAP knowledge exchange and help other SAP technology or functional Consultants finding any piece of useful information. Please participate with your comments and opinions, it will help enrich the SAP community. Thanks!
SAP Tutorial
Useful post… I just got many idea. I just came across your site and wanted to say that I’ve really enjoyed reading your posts. In any case I’ll be subscribing to your feed and I hope you will keep a good work!
Regards,
webmaster
Hi,
Thanks for your feedback. I’ll try to submit new posts soon!
Regards.
Saplab
Luz
Hi, i am trying to install SAP IDES 4.7 with maxdb, i could install central instance without any problem, but when i try to install Database instance, after several hours, i have problems with that:
“An error occurred while processing service SAP R3E 4.7 Extension Set SSR1/ABAP/SYSTEM/MaxDB/Non-unicode/database instance Installation.
… Log file are written to C:archives de programa/sapinst_instdir/R3E47X2/SYSTEM/ABAP/ADA/NUC/DB”
Error
MSC-01015 Process finished with error(s), chenk log file C:/ archivos de programa/sapinst_instdir/R3E47X2/SYSTEM/ABAP/ADA/NUC/DB0/SAPAPPLO.log
MSC-01015 Process finished with error(s), chenk log file C:/ archivos de programa/sapinst_instdir/R3E47X2/SYSTEM/ABAP/ADA/NUC/DB0/SAPAPPLI.log
MSC-01015 Process finished with error(s), chenk log file C:/ archivos de programa/sapinst_instdir/R3E47X2/SYSTEM/ABAP/ADA/NUC/DB0/SAPSSEXC.log
MSC-01015 Process finished with error(s), chenk log file C:/ archivos de programa/sapinst_instdir/R3E47X2/SYSTEM/ABAP/ADA/NUC/DB0/SAPAPPLI.log
Can you help me with that?
Thank you so much!
webmaster
Hi Luz.
Have you consulted the full detailed log? And what are your Unicode requirements? (if you’re considering unicode at all).
Thanks.
Antonio