Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email email@example.com
AW: Instance_type changed after Upgrade
From: Zabach, Elke (elke.zabachsap.com)
Date: Tue Feb 01 2005 - 04:12:14 CST
Dirk Zugenmaier wrote:
> after upgrading from SapDB 184.108.40.206 to MaxDB 220.127.116.11 we experienced
> some troubles with Indexes not beeing used. So we upgraded to MaxDB
> But now the Instance_type of the Database has suddenly changed.
> Previously we used the BW-Type AFAIK (No Log since it is used for a
> DataWareHouse) but now it has changed to OLTP (as it is defined in
> cserv.pcf, since the BW-type does not longer seem to exist).
> The Documentation says, there is no way in changing it, but how did
> update change it? There must be another way then exporting all data
> creating a new instance.
Do not worry at all.
As we have had some INSTANCE_TYPE defined (for future use), but in the
meantime decided, not to use them, but to destroy three of them, we had
to change them in the parameter-files of the databases using them.
As we did not use them in a special way (they were handled like
INSTANCE_TYPE OLTP) nothing will work differently now because of this
'changed' INSTANCE_TYPE. The 'change' was only done internally to fulfil
the constraint of allowed INSTANCE_TYPEs even for your database having
had another one, which was destroyed.
BW did use the LOG as OLTP does.
SAP Labs Berlin
> Thanks for your help,
> Dirk Zugenmaier
> MaxDB Discussion Mailing List
> For list archives: http://lists.mysql.com/maxdb
> To unsubscribe:
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb