Specifications
148 Optimizing IBM Netfinity Servers for SAP R/3 and Windows NT
5.4.1.4 Data Integrity Requirements
As data integrity is important in any database management system, hence it is
recommended that the file system containing the log files
(\db2\<SAPSID>\SQLOGDIR) should be mirrored.
5.4.1.5 Recommended Disk Configuration
This section covers the recommended configuration based on performance.
For example:
Disk1: \db2\<SAPSID>\SQLOGDIR
\USR\SAP\TRANS
Disk2: \db2\<SAPSID>\sapreorg
\db2\<SAPSID>\log_archive
Disk3: mirrored database log files (mirror of Disk1)
Disk4: \USR\SAP
\db2<SAPSID>
Disk5: \db2\<SAPSID>\sapdata1
Disk6: \db2\<SAPSID>\sapdata2
Disk7: \db2\<SAPSID>\sapdata3
Disk8: \db2\<SAPSID>\sapdata4
Disk9: \db2\<SAPSID>\sapdata5
Disk10:\db2\<SAPSID>\sapdata6
5.4.1.6 Minimal Disk Configuration
This configuration should only be used for test or demo systems.
Disk1: \db2\<SAPSID>\SQLOGDIR
\USR\SAP
Disk2: \db2\<SAPSID>\sapdata1
\db2\<SAPSID>\sapdata2
\db2\<SAPSID>\sapdata3
Disk3: \db2\<SAPSID>
\db2\<SAPSID>\sapreorg
\db2\<SAPSID>\log_archive
\db2\<SAPSID>\sapdata4
\db2\<SAPSID>\sapdata5
\db2\<SAPSID>\sapdata6
This
minimal configuration
satisfies the SAP security requirements but has the
following disadvantages:
• It doesn't ensure that both database files and log files will not be lost in a
single disk failure.
• The minimal configuration ensures that no data will be lost, but recovery will
be complicated and time consuming.
A production system must run in log retain mode. If a test system
is not running in log retain mode, all data which has been written
since the last complete backup will be lost after a system crash.
Note