You are planning to install or currently managing an SAP system with the DB2 database. The SAP system which has been installed with the database – Oracle, MaxDB, MSSQL or DB2 has their own way of layout configuration. Some of the DB2 file system naming may look the same with the other databases – sapdata / saptemp – some are not. To get the idea, you can refer to the below namings, so in future – you will not get confused with the other databases.
DB2 Layout
• The DB2 main ABAP, JAVA & BI/BW tablespace
/db2/<SAPSID>/sapdataX/NODE0000
• The DB2 temporary tablespace
/db2/<SAPSID>/saptempX/NODE0000
• The DB2 online log files
/db2/<DB2SID>/log_dir/NODE0000
• The DB2 offline log files
/db2/<DB2SID>/log_archive
• The DB2 archived log file
/db2/<DB2SID>/log_retrieve
• The DB2 dump files
/db2/<DB2SID>/db2dump
• The DB2 instance home directory
/db2/db2<DB2SID>
• The DB2 local directory
/db2/<DB2SID>/db2<DB2SID>/NODE0000
