Ansicht
Dokumentation
04770 - Reorganizing SAP tables
PERFORM Short Reference BAL Application Log DocumentationThis documentation is copyright by SAP AG.
Reorganizing SAP tables
Jill, one of the things I do on a biweekly basis is goto DATABASE PERFORMANC:TABLES AND INDEXES (TA DB02) and refresh this and look at the deleted row
analysis and reorganize the top 20 tables in the database. Then I r do an IPL
which will reclaim the deleted space. This is help full when you are running
close to SAP threshold.
Crosby Sinclair
SAP/AS400 System Administrator
Thomson Industries Inc.
Internet www.thomsonind.com
E-mail csinclairZt...
Phone (516) 944-1337
Fax (516) 944-7505
>>> <mdmsystemsZe...> 01/24 6:10 PM >>>
Jill
How are you ? If you run a report you can see that there are normally 10-20
files with the most wasted space. A weekly RGZPFM is pretty good to keep down
waste. It is fairly easy to run a DSPFFD to an *outfile and write a CL to RGZPFM
the whole database occasionally. But most of the benefit comes from the top
10-20 files with deleted records.
Matt Milne
Freelance AS/400 SAP Consultant
----- Original Message -----
From: jlsiegmund
To: DoNotReply@consolut.eu
Sent: Thursday, January 24, 2002 2:37 PM
Subject: Reorganizing SAP tables
Does anyone run RGZPFM against individual SAP tables on a daily or
other schedule? If so, which tables and which transactions do they
benefit(as far as response time)? I've heard of people running
RGZPFM right in their nightly backup CL program, with SAP up and
running.
Thank you.
Durban Tours - Südafrika Safari
BAL_S_LOG - Application Log: Log header data ABAP Short Reference
This documentation is copyright by SAP AG.
Length: 2316 Date: 20240602 Time: 015618 sap01-206 ( 3 ms )