July 8, 2009 at 8:04 pm
Symptom
Update to BIA 7.00 Revision 52
Other terms
Update, TREX, BIA, BWA, revision, newest Version, Support Package, BI Accelerator, news, SAP BusinessObjects Explorer
Reason and Prerequisites
This revision 52 will update every prior revision of BWA.In order to successfully apply Revision 51 on a SLES9 system you need libstdc++6. For details consider Note 1021236.Solution
the revision is yet not released
Download [...]
July 2, 2009 at 12:43 pm
Symptom
high enqueue waits after a reorganization/ change of extent size
Other terms
v$lock
ST-lock
enqueue
lock
insert, update , delete
DML
space management
coalesce free space
alter tablespace coalesce
reorganization
next extent size
Reason and Prerequisites
Performance is at a standstill, all workprocesses are occupied, oracle sessions show enqueue waits
there can be different reasons why an enqeue can cause severe performance impacts on the system. In order to [...]
June 26, 2009 at 9:48 pm
Symptom
Incorrect amounts are calculated for reverse and delete images as a result of the currency conversion.For example, positive amounts become negative amounts.However, negative amounts have to be calculated.
Other terms
Update, currency conversion, ODS object, 0RECORDMODE, record mode
Reason and Prerequisites
The ODS object extractor returns a conversion factor with reversed signs for reverse images and [...]
June 17, 2009 at 3:14 pm
Symptom
You can use the procedure described in this note to run parallel update statistics as of MaxDB Version 7.6.05 patch level 8 and as of Version 7.7.04.
Other terms
UPDATE STATISTICS AS PER SYSTEM TABLE, parallel update statistics, PTS 1159867
Reason and Prerequisites
You use at least MaxDB Version 7.6.05 patch level 8.
This function is also available in [...]