BC515_EN_46C_FV_010807[1] - Database Admin - SAP DB.pdf

(2850 KB) Pobierz
%&'DWDEDVH$GPLQLVWUDWLRQ6$3 '%
%&'DWDEDVH$GPLQLVWUDWLRQ6$3 '%
'DWDEDVH$GPLQLVWUDWLRQ
6$3 '%
%&
55HOHDVH&
ã SAP AG 2001
R/3
February 2001
Material Number 5004 3494
894211034.106.png 894211034.117.png 894211034.128.png 894211034.139.png 894211034.001.png
&RS\ULJKW
&RS\ULJKW6$3$*$OOULJKWVUHVHUYHG
1RSDUWRIWKLVSXEOLFDWLRQPD\EHUHSURGXFHGRUWUDQVPLWWHGLQ
DQ\IRUPRUIRUDQ\SXUSRVHZLWKRXW
WKHH[SUHVVSHUPLVVLRQRI6$3$*7KHLQIRUPDWLRQFRQWDLQHG
KHUHLQPD\EHFKDQJHGZLWKRXWSULRUQRWLFH
$OOULJKWVUHVHUYHG
ã SAP AG 2001
7UDGHPDUNV
n Some software products marketed by SAP AG and its distributors contain proprietary software
components of other software vendors.
n Microsoft ® , WINDOWS ® , NT ® , EXCEL ® , Word ® , PowerPoint ® and SQL Server ® are registered
trademarks of Microsoft Corporation.
n IBM ® , DB2 ® , OS/2 ® , DB2/6000 ® , Parallel Sysplex ® , MVS/ESA ® , RS/6000 ® , AIX ® , S/390 ® ,
AS/400 ® , OS/390 ® , and OS/400 ® are registered trademarks of IBM Corporation.
n ORACLE ® is a registered trademark of ORACLE Corporation.
n INFORMIX ® -OnLine for SAP and INFORMIX ® Dynamic Server TM are registered trademarks of
Informix Software Incorporated.
n UNIX ® , X/Open ® , OSF/1 ® , and Motif ® are registered trademarks of the Open Group.
n HTML, DHTML, XML, XHTML are trademarks or registered trademarks of W3C ® , World Wide
Web Consortium, Massachusetts Institute of Technology.
n JAVA ® is a registered trademark of Sun Microsystems, Inc.
n JAVASCRIPT ® is a registered trademark of Sun Microsystems, Inc., used under license for
technology invented and implemented by Netscape.
n SAP, SAP Logo, R/2, RIVA, R/3, ABAP, SAP ArchiveLink, SAP Business Workflow, WebFlow,
SAP EarlyWatch, BAPI, SAPPHIRE, Management Cockpit, mySAP.com Logo and mySAP.com
are trademarks or registered trademarks of SAP AG in Germany and in several other countries all
over the world. All other products mentioned are trademarks or registered trademarks of their
respective companies.
© SAP AG
BC515
ii
894211034.012.png 894211034.023.png 894211034.034.png 894211034.045.png 894211034.056.png 894211034.062.png
6$3%DVLV$GPLQLVWUDWLRQ7UDLQLQJ
&RUH&RPSHWHQFH
([SHUW&RPSHWHQFH
3 days
Database
Administration Oracle
2 days
R/3-Technical
Implementation and
Operation Management
5 days
Database
Administration Informix
2 days
3 days
5 days
Database
Administration SAP DB
Advanced R/3
System Administration
Technical Core
Competence
3 days
Database Administration
MS SQL Server
3 days
Workload Analysis
3 days
Software Logistics
3 days
Database Administration
DB2/400
3 days
TCC Workplace
p “ Sf ” m G O • C
Workplace
5 days
Database Administration
DB2/390
3 days
Database Administration
DB2 UDB
M = Sfgmih
H FG >Q1Ckj ‘ LY ZbT,n M
2 days
LiveCache Administration
ã SAP AG 1999
© SAP AG
BC515
iii
894211034.063.png 894211034.064.png 894211034.065.png 894211034.066.png 894211034.067.png 894211034.068.png 894211034.069.png 894211034.070.png 894211034.071.png 894211034.072.png 894211034.073.png 894211034.074.png 894211034.075.png 894211034.076.png 894211034.077.png 894211034.078.png 894211034.079.png 894211034.080.png 894211034.081.png 894211034.082.png 894211034.083.png 894211034.084.png 894211034.085.png 894211034.086.png 894211034.087.png 894211034.088.png 894211034.089.png 894211034.090.png 894211034.091.png 894211034.092.png 894211034.093.png 894211034.094.png 894211034.095.png 894211034.096.png 894211034.097.png 894211034.098.png 894211034.099.png 894211034.100.png 894211034.101.png 894211034.102.png 894211034.103.png 894211034.104.png 894211034.105.png 894211034.107.png 894211034.108.png 894211034.109.png 894211034.110.png 894211034.111.png 894211034.112.png 894211034.113.png 894211034.114.png 894211034.115.png 894211034.116.png 894211034.118.png 894211034.119.png 894211034.120.png 894211034.121.png 894211034.122.png 894211034.123.png 894211034.124.png 894211034.125.png
6$3¶V .QRZOHGJH7UDQVIHU0RGHO
2 da y s
3 da y s
D ata bas e A dm inis trati on
ORA CLE
R/3 -Tec hni ca l
Imp l em e nta tio n a n d
Ope rati o n Ma n ageme nt
Tec hn ical C ore
C omp eten ce
• ‚ ˚¸¸ ¨
2 da y s
3 day s
D ata bas e A dm inis trati on
S A P DB
• ‚ „ ”„
5 da ys
A dvan ced R /3
S y ste m A dmin is tr ation
3 da y s
D ata bas e A dm inis trati on
M S S QL S erv er
3 da ys
S oftwa re Logi s tic s
3 da y s
D ata bas e A dm inis trati on
D B2 UDB
G ” "# ‡E b‹ "1–@
–‡— — ˜ E ™ š š › g œ ˜ g ž— Ÿ › ! œ ˜ Ÿ   g¡¢1 š HJILK g   œ ! — M ¡ ON E ž OP
(SD )
2 d ays
( PP)
2 day s
(C O)
2 days
Te chn ic al Co re Compe tenc e Versions
B C3 10
(SD )
2 d ays
QRM   ! ž g ›
W in do ws NT / Orac le
( PP)
2 day s
ß óô÷ ÷ô
BC 3 14
Win dows NT M S S QL S erve r
ò óô ı ö÷ô łøœ ß ü÷ý ÷þ ł ü÷ÿ ö
ÿ
òóô ı ö÷ô ł øœß ü÷ý ÷þ ł ü÷ÿ ö
ÿ
ł ö
7 ø ÿ łø
÷ô÷ö
ł ô
ø
ı ÷ö ÿ
ò óô ı ö ÷ô ł ø œß ü÷ý ÷þ ł ü÷ÿö
ÿ
BC 3 17
(W in dow s NT / UN IX ) / D B2
ÿ ÷ü ł ÷ ø ÷ü
ö łø
÷
ÿ
ı ÿ ß
BC 3 60
UNI X / Oracle
(SD )
2 d ays
ÿ
ôü÷ÿö œ
ó
BC 3 62
UNI X / S AP D B
ò óô ı ö÷ô łøœ ß ü÷ý ÷þ ł ü÷ÿ ö
ÿ
(P P/ CO )
2 days
ó ÷ ü
ÿô ó
÷ö
÷ö ô ø
÷ö
ô ı ó
ø ÷ö
2 day s
òóô ı ö÷ô ł øœß ü÷ý ÷þ ł ü÷ÿ ö
ÿ
( SD/PP )
ã S AP A G 199 9 fi len ame ( au tho r) / 2
(SD )
2 d ays
ö ł ö
ÿ ö ò ó ý øł öö÷ö
ò óô ı ö÷ô łøœ ß ü÷ý ÷þ ł ü÷ÿ ö
ÿ
ł üô ı óüó ý ÷ö ł ü÷ÿ ö
(SD )
1 da y
(SD/P P)
2 da ys
ò óô ı ö ÷ô ł ø œß ü÷ý ÷þ ł ü÷ÿö
ÿ
łø ô øł ü÷ÿ ö ÿ
òóô ı ö÷ô ł øœß ü÷ý ÷þ ł ü÷ÿ ö
ÿ ü ı ó
ÿ
ôü÷ÿö œ
ó
ò óô ı ö÷ô łøœ ß ü÷ý ÷þ ł ü÷ÿ ö
ÿ
ł ÷ øł ÷ ø ÷ü
ı óô
ó ÷ü ł ö ł óý ó öü
(SD )
1 da y
ò óô ı ö÷ô łøœ ß ü÷ý ÷þ ł ü÷ÿ ö
ÿ òó ü óüó ý ÷ö ł ü÷ÿ ö
òóô ı ö÷ô ł øœ ß ü÷ý ÷þ ł ü÷ÿö
ÿ
(SD)
2 da ys
ÿ ö ÷
ł ü÷ÿ ö
(SD )
1 da y
ÿ
8 ł ÷ ł öü
ò óô ı ö÷ô łøœ ß ü÷ý ÷þ ł ü÷ÿ ö
ÿ
ÿ
ôü ó ø óôü÷ÿ ö
òóô ı ö÷ô ł øœß ü÷ý ÷þ ł ü÷ÿ ö
ı ÷ ß ß ÷ö ł ö
ł ó ı ÿ
ò óô ı ö÷ô łøœ ß ü÷ý ÷þ ł ü÷ÿ ö
ÿ
ł üö ó
ã SA P AG K TM m ySAP .com f or T ec hn. Im pl., IT Con s., S ys. Integ r ation UH / 7
óüó ý ÷ö ł ü÷ÿö
ó ł ö ł óý óöü
· K' WV K" )( YX b Z
–— — ˜ ™ š š › ! œ ˜ g ž ! — Ÿ › ! œ ˜ Ÿ   !¡¢1 š [ )¡ LM T\L]JM
Q g ž T^ – g ž  
¯ ’ ’ § _‘G ” «’‹.·1 ’ aZ 1 «
–— — ˜ ™ š š › ! œ ˜ g ž ! — Ÿ › ! œ ˜ Ÿ   !¡¢1 š H œ RP
ced k œ g —   –
¯ ’ ’ § _‘G ” «’‹ d§ ’ A
–— — ˜ ™ š š › ! œ ˜ g ž ! — Ÿ › ! œ ˜ Ÿ   !¡¢1 š HOdgf
› " @ b“’§ ! )(<·& ’ aZ # «
–— — ˜ ™ š š › ! œ ˜ g ž ! — Ÿ › ! œ ˜ Ÿ   !¡¢1 š ^ @¡ g › hKRb — aM T\LN ž TP
QRM   g ž ›
– ! — — ˜ S ™ š š › ! œ ˜ ž‡— Ÿ › ! œ ˜ Ÿ   g¡¢1 š µ E œ g › OM › TS RUJP ¡ RI
–— — ˜ ™ š š › ! œ ˜ g ž ! — Ÿ › ! œ ˜ Ÿ   !¡¢1 š £ žœ ¢ iNJf‘U › hK ˜ ˜ ¡ LP —
ã SAP AG 2001
© SAP AG
BC515
iv
894211034.126.png 894211034.127.png 894211034.129.png 894211034.130.png 894211034.131.png 894211034.132.png 894211034.133.png 894211034.134.png 894211034.135.png 894211034.136.png 894211034.137.png 894211034.138.png 894211034.140.png 894211034.141.png 894211034.142.png 894211034.143.png 894211034.144.png 894211034.145.png 894211034.146.png 894211034.147.png 894211034.148.png 894211034.149.png 894211034.002.png 894211034.003.png 894211034.004.png 894211034.005.png 894211034.006.png 894211034.007.png 894211034.008.png 894211034.009.png 894211034.010.png 894211034.011.png 894211034.013.png 894211034.014.png 894211034.015.png 894211034.016.png 894211034.017.png 894211034.018.png 894211034.019.png 894211034.020.png 894211034.021.png 894211034.022.png 894211034.024.png 894211034.025.png 894211034.026.png 894211034.027.png 894211034.028.png 894211034.029.png 894211034.030.png 894211034.031.png 894211034.032.png 894211034.033.png 894211034.035.png 894211034.036.png 894211034.037.png 894211034.038.png 894211034.039.png 894211034.040.png 894211034.041.png 894211034.042.png 894211034.043.png 894211034.044.png 894211034.046.png 894211034.047.png 894211034.048.png 894211034.049.png 894211034.050.png 894211034.051.png 894211034.052.png 894211034.053.png 894211034.054.png 894211034.055.png 894211034.057.png 894211034.058.png 894211034.059.png 894211034.060.png 894211034.061.png
&RQWHQWV
Course Overview................................................................................................................................................... 1
Course Prerequisites .......................................................................................................................................... 2
Target Group ..................................................................................................................................................... 3
Course Goals ..................................................................................................................................................... 4
Course Content .................................................................................................................................................. 5
Database Basic Knowledge ................................................................................................................................... 6
Database Basic Knowledge ............................................................................................................................... 7
R/3 System and SAP DB................................................................................................................................... 8
SAP R/3 Client/Server Architecture.................................................................................................................. 9
SAP DB as Content Server.............................................................................................................................. 10
Content Server Administration........................................................................................................................ 11
SAP DB Server: Basic Structure ..................................................................................................................... 12
SAP R/3 and SAP DB Communication........................................................................................................... 13
Remote Access to SAP DB ............................................................................................................................. 14
SQLMODE ..................................................................................................................................................... 15
SAP R/3 Change and Transport System.......................................................................................................... 16
Appendix: Server Landscape........................................................................................................................... 17
Database Basic Knowledge: Exercises............................................................................................................ 18
Database Basic Knowledge: Solutions ............................................................................................................ 19
SAP DB Processes and Storage Architecture...................................................................................................... 20
SAP DB Processes and Storage Architecture.................................................................................................. 21
Operating System Users and Database Users.................................................................................................. 22
Automated Logon: XUSER............................................................................................................................. 23
SAP DB Operation Modes .............................................................................................................................. 24
SAP DB Processes and Their Tasks................................................................................................................ 25
Task Description ............................................................................................................................................. 26
Caches and Kernel Parameters ........................................................................................................................ 27
Subdirectories in DBROOT ............................................................................................................................ 28
New Directory Structure in SAP DB Version 7.2.4 ........................................................................................ 29
SAP Directory Structure.................................................................................................................................. 30
Database Manager DBMGUI: Main Screen.................................................................................................... 31
Database Manager DBMGUI: Menus ............................................................................................................. 32
SAP DB Processes and Storage Architecture: Exercises ................................................................................ 33
SAP DB Processes and Storage Architecture: Solutions................................................................................. 34
Hard Disk Areas and Logging............................................................................................................................. 36
Hard Disk Areas and Logging......................................................................................................................... 37
Data Devspaces ............................................................................................................................................... 38
System Devspace and Converter ..................................................................................................................... 39
SAP DB Log Modes........................................................................................................................................ 40
Log Devspaces and Log Segmenting .............................................................................................................. 41
Savepoint and Checkpoint............................................................................................................................... 42
SAP DB Savepoint Phases .............................................................................................................................. 43
Copy from Log into Data Areas ...................................................................................................................... 44
Redo Region.................................................................................................................................................... 45
Log Full (Wait for Savepoint) ......................................................................................................................... 46
Modifications to Configuration with DBMGUI .............................................................................................. 47
Hard Disk Areas and Logging: Exercises........................................................................................................ 48
Hard Disk Areas and Logging: Solutions........................................................................................................ 49
Backup and Recovery.......................................................................................................................................... 50
Backup and Recovery...................................................................................................................................... 51
SAP DB Backup Concept................................................................................................................................ 52
Data Backup: Complete - Incremental ............................................................................................................ 53
Parallel Data Backup ....................................................................................................................................... 54
Archive Log Backup ....................................................................................................................................... 55
DBMGUI Media Manager .............................................................................................................................. 56
Recommended Backup Strategy...................................................................................................................... 57
Backup Weekly Planner .................................................................................................................................. 58
Recovery Situation .......................................................................................................................................... 59
© SAP AG
BC515
v

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika:

Zgłoś jeśli naruszono regulamin