BC525_EN_46B_FV_010807[2] - DB2 for OS400.pdf

(4799 KB) Pobierz
BC525 Database Administration DB2 for OS/400
Database Administration
DB2 for OS/400
R/3 Release 4.6B
50038146
R/3 Release 4.6B
50038146
SAP AG 1999
Jun-6-2000
894210539.095.png 894210539.106.png 894210539.117.png 894210539.128.png
 
Copyright
Copyright 2000 SAP AG. All rights reserved.
Neither this training manual nor any part thereof may
be copied or reproduced in any form or by any means,
or translated into another language, without the prior
consent of SAP AG. The information contained in this
document is subject to change and supplement without prior
notice.
All rights reserved.
SAP AG 1999
n Trademarks:
n Microsoft ®, Windows ®, NT ®, PowerPoint ®, WinWord ®, Excel ®, Project ®, SQL-Server ®, Multimedia Viewer ®,
Video for Windows ®, Internet Explorer ®, NetShow ®, and HTML Help ® are registered trademarks of Microsoft
Corporation.
n Lotus ScreenCam ® is a registered trademark of Lotus Development Corporation.
n Vivo ® and VivoActive ® are registered trademarks of RealNetworks, Inc.
n ARIS Toolset ® is a registered Trademark of IDS Prof. Scheer GmbH, Saarbrücken
n Adobe ® and Acrobat ® are registered trademarks of Adobe Systems Inc.
n TouchSend Index ® is a registered trademark of TouchSend Corporation.
n Visio ® is a registered trademark of Visio Corporation.
n IBM ®, OS/2 ®, DB2/6000 ® and AIX ® are a registered trademark of IBM Corporation.
n Indeo ® is a registered trademark of Intel Corporation.
n Netscape Navigator ®, and Netscape Communicator ® are registered trademarks of Netscape Communications, Inc.
n OSF/Motif ® is a registered trademark of Open Software Foundation.
n ORACLE ® is a registered trademark of ORACLE Corporation, California, USA.
n INFORMIX ®-OnLine for SAP is a registered trademark of Informix Software Incorporated.
n UNIX ® and X/Open ® are registered trademarks of SCO Santa Cruz Operation.
n ADABAS ® is a registered trademark of Software AG
n The following are trademarks or registered trademarks of SAP AG; ABAP/4, InterSAP, RIVA, R/2, R/3, R/3 Retail, SAP
(Word), SAPaccess, SAPfile, SAPfind, SAPmail, SAPoffice, SAPscript, SAPtime, SAPtronic, SAP-EDI, SAP EarlyWatch,
SAP ArchiveLink, SAP Business Workflow, and ALE/WEB. The SAP logo and all other SAP products, services, logos, or
brand names included herein are also trademarks or registered trademarks of SAP AG.
n Other products, services, logos, or brand names included herein are trademarks or registered trademarks of their respective
owners.
(C) SAP AG
BC525
ii
894210539.011.png 894210539.022.png 894210539.033.png 894210539.044.png 894210539.051.png
 
SAP Basis Administration Training 4.6
Core Competence
Expert Competence
BC505
3 days
Database
Administration Oracle
MBC30
2 days
R/3-Technical
Implementation and
Operation Management
BC511
5 days
Database
Administration Informix
BC515
2 days
BC305
3 days
BC tcc *
5 days
Database
Administration SAP DB
Advanced R/3
System Administration
Technical Core
Competence
BC520 3 days
Database Administration
MS SQL Server
BC315 3 days
Workload Analysis
BC325 3 days
Software Logistics
BC525 3 days
Database Administration
DB2/400
BC350** 3 days
TCC Workplace
MY301 2 days
Workplace
BC530 5 days
Database Administration
DB2/390
*Technical Core Competence Versions
BC535 3 days
Database Administration
DB2 UDB
BC310
Windows NT / Oracle
BC312
Windows NT / SAP DB
BC314
Windows NT MS SQL Server
BC317
(Windows NT / UNIX) / DB2
BC555 2 days
LiveCache Administration
BC360
UNIX / Oracle
BC361
UNIX / Informix
BC362
UNIX / SAP DB
BC370
IBM AS400
Corresponding R/3 Basis
Knowledge Product and/or
SAP Expert Knowledge Book
Database
Administration Training
BC390
IBM /390
**BC350
Workplace (combined with MY301)
SAP AG 1999
(C) SAP AG
BC525
iii
894210539.052.png 894210539.053.png 894210539.054.png 894210539.055.png 894210539.056.png 894210539.057.png 894210539.058.png 894210539.059.png 894210539.060.png 894210539.061.png 894210539.062.png 894210539.063.png 894210539.064.png 894210539.065.png 894210539.066.png 894210539.067.png 894210539.068.png 894210539.069.png 894210539.070.png 894210539.071.png 894210539.072.png 894210539.073.png 894210539.074.png 894210539.075.png 894210539.076.png 894210539.077.png 894210539.078.png 894210539.079.png 894210539.080.png 894210539.081.png 894210539.082.png 894210539.083.png 894210539.084.png 894210539.085.png 894210539.086.png 894210539.087.png 894210539.088.png 894210539.089.png 894210539.090.png 894210539.091.png 894210539.092.png 894210539.093.png 894210539.094.png 894210539.096.png 894210539.097.png 894210539.098.png 894210539.099.png 894210539.100.png 894210539.101.png 894210539.102.png 894210539.103.png 894210539.104.png 894210539.105.png 894210539.107.png 894210539.108.png 894210539.109.png 894210539.110.png 894210539.111.png 894210539.112.png 894210539.113.png
SAP‘s Knowledge Transfer Model
SAP Basis Administration Training 4.6
C ore C ompetenc e
Expert Compe tence
MBC30
2 da ys
B C505 3 da ys
D ata base Adm inis trati on
ORACLE
R/3 -Techni ca l
Imp l eme nta tio n a n d
Ope rati o n Ma n ageme nt
Techn ical C ore
C omp eten ce
B C tcc *
D ata base Adm inis trati on
SAP DB
B C515
2 da ys
B C 30 5
3 day s
5 da ys
Technical Training and
Workshops
http://sapnet.sap.com/EducationServices
Advan ced R /3
Syste m Admin istr ation
B C520 3 da ys
D ata base Adm inis trati on
MS SQL Serv er
Empowe ring Workshops - Applicatio n and Cr oss
Applicat ion
B C32 5
3 da ys
Softwa re Logi stics
B C535 3 da ys
D ata base Adm inis trati on
D B2 UDB
Expert Knowledge
Book Series
http://sapnet.sap.com/Books
Empowering Workshops
Technical Optimizatio n
o f Pr icing
EWA10 (SD )
2 days
Technical Optimizatio n
of Due List Proc essin g
in clud ing Sched ulin g
EWA11 (SD )
Tec hnica l Op timiz ation
o f Bac kflushing of
Produ ction Orders
EWA 12 ( PP)
2 day s
T echn ical Optim izat ion
o f Profitab ility Analysis
EWA18 (C O)
2 days
IB U sp ecific
and Global
W orkshops
* Technic al Core Competenc e Versions
BC310
2 days
Technical Optimizatio n
of Batch Determinatio n
EWA13 (SD )
EWA 20 ( PP)
2 day s
Win dows NT / Orac le
BC 314
Win dows NT M S SQL Server
Tec hnica l Op timiz ation
of MR P Ru n an d
Lo ng T erm Planning
BC 317
(Window s NT / UN IX) / D B2
2 days
Technical Optimizatio n
o f Credit M anag eme nt
EW A14 (SD )
BC 360
UNI X / Oracle
Cor resp ond ing R/3 Bas is
Kno wledge Pr o duct
BC 362
UNI X / SAP D B
T echn ical Optim izat ion
of Calc ulatio n of
Pro duction Orders
EWC13 (PP/CO )
2 days
Tec hnica l Op timiz ation
of th e Av ailab ility C heck
EWC 10 ( SD/PP)
2 day s
SAP AG 1999 filen ame ( author) / 2
2 days
Technical Optimizatio n
of Text Det erminatio n
EW A15 (SD )
1 day
Technical Optimizatio n
o f Produc t Selectio n
EW A16 (SD )
Tech nica l Opt imization
o f Co nfiguratio n
of Variants
EWC 11 (SD/PP)
2 days
1 day
Technical Optimizatio n
of Partn er D eterminat ion
EW A17 (SD )
Tec hnica l Op timiz ation
Shipping and
Ware hous e Managemen t
EWC 16 (SD)
2 days
1 day
SAP AG KTM mySAP.com f or T ec hn. Impl., IT Cons., Sys. Integration UH / 7
SAP GoingLive Check http://sapnet.sap.com/GoingLiveCheck
SAP EarlyWatch Service http://sapnet.sap.com/EarlyWatch
SAP EarlyWatchAlert http://sapnet.sap.com/EWA
SAP Consulting Services http://sapnet.sap.com/ConsultingServices
TeamSAP Support
http://sapnet.sap.com/BasisKnProd
http://sapnet.sap.com/TeamSAPsupport
Knowledge
Products
Technical
Certifications
http://sapnet.sap.com/pa
http://sapnet.sap.com/TechNet
SAP AG 1999
(C) SAP AG
BC525
iv
894210539.114.png 894210539.115.png 894210539.116.png 894210539.118.png 894210539.119.png 894210539.120.png 894210539.121.png 894210539.122.png 894210539.123.png 894210539.124.png 894210539.125.png 894210539.126.png 894210539.127.png 894210539.129.png 894210539.130.png 894210539.131.png 894210539.132.png 894210539.133.png 894210539.134.png 894210539.135.png 894210539.136.png 894210539.137.png 894210539.138.png 894210539.001.png 894210539.002.png 894210539.003.png 894210539.004.png 894210539.005.png 894210539.006.png 894210539.007.png 894210539.008.png 894210539.009.png 894210539.010.png 894210539.012.png 894210539.013.png 894210539.014.png 894210539.015.png 894210539.016.png 894210539.017.png 894210539.018.png 894210539.019.png 894210539.020.png 894210539.021.png 894210539.023.png 894210539.024.png 894210539.025.png 894210539.026.png 894210539.027.png 894210539.028.png 894210539.029.png 894210539.030.png 894210539.031.png 894210539.032.png 894210539.034.png 894210539.035.png 894210539.036.png 894210539.037.png 894210539.038.png 894210539.039.png 894210539.040.png 894210539.041.png 894210539.042.png 894210539.043.png 894210539.045.png 894210539.046.png 894210539.047.png 894210539.048.png 894210539.049.png 894210539.050.png
Contents
Course Overview ................................................................................................................................................... 1
Course Prerequisites - Target Group - Duration ................................................................................................ 2
Course Goals ..................................................................................................................................................... 3
Course Content .................................................................................................................................................. 4
DB2/400 Architecture and Naming Conventions .................................................................................................. 5
DB2/400 Architecture and Naming Conventions .............................................................................................. 6
Three-Tier System ............................................................................................................................................. 7
R/3 Work Management: Review ....................................................................................................................... 8
The R/3 Work Processes ................................................................................................................................... 9
What is an Instance? ........................................................................................................................................ 10
Relation Between Work Process and Job ........................................................................................................ 11
The Shadow Processes .................................................................................................................................... 12
Names of Shadow Processes ........................................................................................................................... 13
Integration of DB2/400 into the Operating System ......................................................................................... 14
The Common User Interface ........................................................................................................................... 15
Features of DB2/400........................................................................................................................................ 16
Local and Remote Database Access ................................................................................................................ 17
Data Management: The Integrated File System .............................................................................................. 18
The Integrated File System (IFS) .................................................................................................................... 19
Accessing Data Through Links ....................................................................................................................... 20
The R/3 File System ........................................................................................................................................ 21
The R/3 Libraries............................................................................................................................................. 22
Data Management: Database Objects.............................................................................................................. 23
The Optimizer.................................................................................................................................................. 24
The SQL Collection......................................................................................................................................... 25
The Primary Index ........................................................................................................................................... 26
Naming Conventions for Indexes (1) .............................................................................................................. 27
Naming Conventions for Indexes (2) .............................................................................................................. 28
Journaling ........................................................................................................................................................ 29
SQL Packages.................................................................................................................................................. 30
Package Information........................................................................................................................................ 31
ODP Cleanup................................................................................................................................................... 32
Summary: Database Objects............................................................................................................................ 33
Data Management: Security ............................................................................................................................ 34
The <SID>OFR (Superuser)............................................................................................................................ 35
R/3 Operator .................................................................................................................................................... 36
R/3 User........................................................................................................................................................... 37
User Profiles on AS/400 .................................................................................................................................. 38
User Profiles Within a Three-Tier System ...................................................................................................... 39
The R/3 Operator Group.................................................................................................................................. 40
Unit Summary ................................................................................................................................................. 41
Unit Actions .................................................................................................................................................... 42
Exercises for: DB2/400 Architecture and Naming Conventions ..................................................................... 43
Solutions for: DB2/400 Architecture and Naming Conventions ..................................................................... 44
System Configuration and Architecture .............................................................................................................. 46
System Configuration and Architecture .......................................................................................................... 47
Hardware Requirements .................................................................................................................................. 48
Elements of System Configuration.................................................................................................................. 49
Memory Pools ................................................................................................................................................. 50
Checking Pools................................................................................................................................................ 51
Job State Transitions........................................................................................................................................ 52
What Do You Need for R/3? ........................................................................................................................... 53
Changing Pool Parameters .............................................................................................................................. 54
Elements of System Configuration.................................................................................................................. 55
Disk Layout ..................................................................................................................................................... 56
Disk Layout: Performance............................................................................................................................... 57
Hot Spot When Adding a New Disk Unit ....................................................................................................... 58
Add More Disks to ASP1 (1) .......................................................................................................................... 59
Add More Disks to ASP1 (2) .......................................................................................................................... 60
Add More Disks to ASP1 (3) .......................................................................................................................... 61
(C) SAP AG
BC525
v

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika:

Zgłoś jeśli naruszono regulamin