2002: The Year of Documenting.


43 views
Uploaded on:
Description
2. . . What We\'ll Cover. Chronicling benefitsDefinitions of termsArchiving featuresArchiving stepsStorage and managementArchiving by moduleWhat next?. 3. . . . . What is Archiving?. . Chronicling Program. Chronicle Files. . R/3 Database. Move information no more required in database to chronicle documents. Chronicling Session.
Transcripts
Slide 1

2002: The Year of Archiving Robert Parkinson PCS Limited "Making Solutions Through Knowledge"

Slide 2

What We\'ll Cover Archiving benefits Definitions of terms Archiving highlights Archiving steps Storage and administration Archiving by module What next?

Slide 3

What is Archiving? Move information no longer required in database to file documents R/3 Database Archiving Program Archive Files Archiving Session

Slide 4

Why Archive? Volume of information in the database expands Disk space Performance Size of record trees, full table sweeps, store hit proportions, ... Exertion and assets required for database organization Backup/reestablish, revamping, make record, insights, ... Business and legitimate necessities Auditing Record-keeping prerequisites Potential re-useability of information

Slide 5

Data Continues to Grow Yearly information development 400 GB, maintenance period 6 months Data not required online following 5 years: 1,800 GB Volume without information chronicling in 5 years: 1,000,000 GB Volume with information filing in 5 years: 225,000 GB Backup, reestablish and database organization time develops relative to database estimate without information filing

Slide 6

Archiving Requirements Independence of database rendition of variant and tweaking of use programming of equipment (codepage/numeric arrangement) Auditability Revenue powers – IRS, evaluators Data security authorities Integration in applications Direct get to Reporting capacities Performance and strength

Slide 7

What We\'ll Cover Archiving benefits Definition of terms Archiving highlights Archiving steps Storage and administration Archiving by module What next?

Slide 8

Optical Archiving ArchiveLink can be utilized to chronicle reports Original records or print records can be put away in optical file frameworks and showed, however can\'t be reloaded or broke down Archive documents which were made by R/3 information filing can be put away, perused, and reloaded utilizing ArchiveLink

Slide 9

Database Reorganization Should be performed after file Compelling reasons: Tables keep free space dispensed after file Gives free space back to the database Improves execution Reduces database upkeep times

Slide 10

Retention versus Home Period The maintenance time frame is the whole time that information spends in the database before its filed The living arrangement time frame is the base time allotment that information must spend in the database before its qualified to be filed

Slide 11

Backup & Restore Contains a duplicate of the database substance for security Backups are typically made at normal interims, as indicated by a standard methodology Reloading the reinforcement into the database is alluded to as reestablish In prior SAP discharges, the chronicling strategy required a database reinforcement. SAP expresses this is no more drawn out vital in Release 3.X and 4.X

Slide 12

What We\'ll Cover Archiving benefits Definition of terms Archiving highlights Archiving steps Storage and administration Archiving by module What next?

Slide 13

Archiving Features High information security amid documenting Optical chronicle association by means of ArchiveLink Data pressure Online information filing Archiving without database reinforcement Random and successive access to filed information objects, reload to the database conceivable Automatic change of old file records The ADK (Archive Developer\'s Toolkit)

Slide 14

Security Provided in Archiving is a two stage prepare: Create file documents Read information from document and execute erase program Storage of the file records on other media Provides information security in the event of issues amid the filing procedure

Slide 15

Archive record Step 1 Create the Archive File Archiving program R/3 Data-base

Slide 16

Archiving program R/3 Data-base R/3 Data-base Archive record Delete program Archive record Archive record Delete program Archive record Delete program Step 2 Execute Delete Program

Slide 17

R/3 Data-base Archive document Archive record Delete program Step 3 Store the Archive Files ArchiveLink HSM-Systems

Slide 18

R/3 System ArchiveLink Archive framework Optical Archive Link ArchiveLink The file documents can be put away on tertiary stockpiling media Files can be put away physically or consequently Hierarchical stockpiling administration frameworks (HSM frameworks) Archive documents can likewise be passed to a HSM framework HSM frameworks can utilize optical and optomagnetic capacity media The HSM framework deals with the file documents naturally

Slide 19

Compression Data is consequently compacted ( Up to a component of 5 or more noteworthy) Online information filing Data filing may keep running in parallel to exchange and bunch preparing Data filing without database reinforcement Data filing is completely recoverable

Slide 20

Access to Archived Data There are two approaches to get to filed information: Sequential access to a dataset (reporting) Random access to individual information objects Archive records can be Read Analyzed (for reporting purposes) Reloaded (Not Recommended – just directly subsequent to filing!) Actions rely on upon filing object Access for reporting and reloading requires that the record is in the record framework Access to individual items relies on upon a list

Slide 21

Conversion of Old Archive Files Necessary transformations are performed consequently Temporary change amid information access In uncommon cases, transformation projects are given

Slide 22

The ADK Database R/3 System L D B Archiving Class ABAP/4 Program Codepage, Number Format, Structure Conversion Direct Access, Compression, Batch-Handling, . . . . ADK: Archive File ArchiveLink physically HSM Archive System with Tertiary Storage Media

Slide 23

Archive Database R/3 System What is an Archiving Object? Key to chronicling idea Description of database articles Collection of projects

Slide 24

Customization During Data Archiving Creating a documenting object Define file question utilizing exchange AOBJ Create programs for filing Archive program Delete program Reload program Index program Create programs for getting to filed information Reports Direct get to by means of online exchange

Slide 25

What We\'ll Cover Archiving benefits Definition of terms Archiving highlights Archiving steps Storage and administration Archiving by module What next?

Slide 26

Archiving Personnel Archiving can be performed by the Basis Administrator by the application division Motivation (and purpose of section) for both are distinctive Basis Administrator The Basis Administrator checks the database/table size Archiving object relationship must be resolved Application Dept. Application Dept. performs filing for different reasons (occasionally – month end, quarter end, year end) Application Dept. utilizes coordinate purpose of passage

Slide 27

Archiving Flowchart

Slide 28

Identifying Critical Tables Database Performance Screen (DB02) Overall database development examination Determine size of tablespaces and tables Free storage room – assigned versus utilized space Table Call Statistics Screen (ST10) Locate the most dynamic tables Which tables are developing Which tables have moderate reaction

Slide 29

Identifying Critical Archiving Objects Use file organization (SARA) Browse through the filing objects Determine which tables are in the filing objects Schedule all required chronicle programs Use CCMS database organization (DB15) Determine which filing objects utilize a table Check online space data for all tables of a filing object

Slide 30

Business Requirements for Archiving Objects (SD_VBAK) Document has status "Complete" All reports in record stream have status "Complete" Financial report is adjusted Additional tweaked checks conceivable

Slide 31

What We\'ll Cover Archiving benefits Definition of terms Archiving highlights Archiving steps Storage and administration Archiving by module What next?

Slide 32

Storage & Management Automated capacity Low administration exertion Manual stockpiling Data medium upkeep Data medium administration Archive generation

Slide 33

Storage of Archive Files Choice of medium is basic for: Utilization of the usefulness offered by SAP Effort required for support Effort required to get to information Durability of chronicle Protection of speculation by method for joined system Data file records Workflow for approaching and active records DMS (Document Mgmt. Framework) specialized records Printed reports Automation of database reinforcement and reestablish

Slide 34

Archive Files on Hard Disk Advantages Single record get to < 5 seconds Quick access for reporting Disadvantages File framework restrictions Considerable manual administration exertion required Replicate the chronicle documents Storage of file records Data security

Slide 35

Archive Files on HSM System Advantages Single report get to < 30 seconds (with square get to) Quick access for reporting (with piece get to) Scalable document framework Long information medium maintenance period Data medium administration bolster Disadvantages Can be an exorbitant arrangement

Slide 36

HSM System Requirements "Write through" ought to be conceivable Increased information security, as the file records relocate before the erase program runs Data held in "magnetic cache" as duplicate "Random access" to documents must be conceivable "Hardware sharing" is valuable Use of a jukebox by means of both HSM and ArchiveLink "Media management" ought to be upheld Replicate file records Store file records

Slide 37

Archive Files on Jukebox by means of ArchiveLink Advantages Scalable framework Long information medium maintenance period Data medium administration bolster Jukebox can likewise be utilized for other R/3 undertakings Disadvantages Can be an expensive arrangement Single archive get to possible for little file records Access time intensely relies on upon file document estimate

Slide 38

ArchiveLink Capabilities With ArchiveLink you can: Archive approaching R/3 records Archive data made in R/3 Directly get to the optically filed archives from the R/3 application

Recommended
View more...