User Guide

SAP AG November 2002
SAP DB Loader ................................................................................................................ 63
Options (LOADERCLI).................................................................................................. 64
Loader Commands ....................................................................................................... 64
SQL Studio: Introduction .................................................................................................. 65
SQL Studio.................................................................................................................... 65
Options (SQL Studio) ................................................................................................ 66
Web SQL ...................................................................................................................... 66
Directory Structure of the Database for SAP Systems ........................................................ 67
Variables........................................................................................................................... 68
Distribution of the SAP DB Directories on the Hard Disk................................................. 68
Security Requirements ................................................................................................. 68
Performance Requirements.......................................................................................... 69
Example Configuration ................................................................................................. 69
Various Database Systems .......................................................................................... 70
SAP DB Directories ...................................................................................................... 70
Instance Data ............................................................................................................ 71
Programs that Are Independent of the Database Software Version......................... 71
Libraries for the Client Run-time Environment.......................................................... 72
Programs that Are Dependent on the Database Software Version .......................... 72
Client Tools ............................................................................................................... 73
Example: SAP DB Directory Structure...................................................................... 73
Display SAP DB Directories ...................................................................................... 73
Define SAP DB Directories ....................................................................................... 74
Directory Structure of the Database System for Open Source............................................ 74
Variables........................................................................................................................... 75
Distribution of the SAP DB Directories on the Hard Disk................................................. 75
Security Requirements ................................................................................................. 75
Performance Requirements.......................................................................................... 76
Example Configuration ................................................................................................. 77
Various Database Systems .......................................................................................... 77
SAP DB Directories ...................................................................................................... 77
Display SAP DB Directories ...................................................................................... 78
Define SAP DB Directories ....................................................................................... 79
Database Parameters .......................................................................................................... 79
General Database Parameters......................................................................................... 79
Special Database Parameters (Extended)....................................................................... 80
Support Database Parameters......................................................................................... 80
BACKUP_BLOCK_CNT ................................................................................................... 81
CACHE_SIZE................................................................................................................... 81
CAT_CACHE_SUPPLY ................................................................................................... 81
User Manual: SAP DB 7