To fully reclaim space in the data object of a regular Db2 table, a data-moving REORG operation is necessary. To perform such a space-reclaiming REORG operation, the Db2 routineADMIN_MOVE_TABLEcan be used that allows you to perform such space reclaiming REORGs online. The SAPDB6CONVutility ...
1. what are the tasks of archiving team in the reorg activity and how can they help the DBA , Basis team on the reorg? 2. are there any real time examples that some one can share on a reorg task. it could be ex: FI_DOCUMNT archiving followed by reorg of the tables related to t...
SAP--MM归档
51CTO博客已为您找到关于sap启动db2数据库的相关内容,包含IT学习相关文档代码介绍、相关教程视频课程,以及sap启动db2数据库问答内容。更多sap启动db2数据库相关解答可以来51CTO博客参与分享和学习,帮助广大IT技术人实现成长和进步。
'/db2/PRD/sapdatat_L/PSAPTEMP2.container002' 512000)" 执行类似命令,继续添加PSAPTEMP2.container003~ PSAPTEMP2.container007 sapdev:root #date; su - db2dev -c "/db2/DEV/sqllib/bin/db2 "reorg table sapr3.acctit index sapr3.acctit~0 use psaptemp2" " ; date ...
UTILS:REORG_TS >> REORG TABLESPACE &OBJECT. SHRLEVEL CHANGE MAPPINGTABLE DB2ADM.MAPTABLE COPYDDN(COPYTPL) //UTILS:TEMPL_COPYDD RECOVERYDDN(COPYTPL) UNLDDN(UNLDTPL) SORTDEVT SYSDA DRAIN_WAIT 15 DRAIN ALL MAXRO 240 DELAY 900 ...
SAP常用数据库表 ABAP AL01AL02AL03AL04AL05AL06AL07AL08AL09AL10AL11AL12 SAPAlertMonitorDatabasealertmonitorOperatingsystemalertmonitorMonitorcalldistributionMonitorcurrentworkloadPerformance:Upload/DownloadEarlyWatchReportUsersLoggedOnDatafordatabaseexpertiseDownloadtoEarlyWatchDisplaySAPDirectoriesDisplaytablebuffer(...
SAP ASE SAP Note: 2543407 - reorg rebuild with online - SAP ASE for Business Suite [Requires SAP Portal Access] IBM Db2 SAP Note: 1942183 - DB6: When to consider a table or index reorganization [Requires SAP Portal Access] Oracle SAP Note: 541538 - FAQ: Reorganization [Requires SAP ...
SAP系统操作手册及问题解决方案 SAP系统操作手册及问题解决方案 会计期间关闭 首先要打开相应的会计年度和记帐期间（OB52）。其次，维护FI的Number Range（FBN1）和CO 中的Number Range（KANK）。特别是CO Number range中的COIN业务一定要分配Number range 新建工厂后新建订单Shipping Point找不到 有一个shippingpoint...
you need to run a db reorg to defrag those empty pages. Cheers, Nicholas Chang Former Member 2016 Sep 02 12:35 PM 0 Kudos Thanks, Nicholas, so you mean the figure(total size) comes from the database size rather than table size?basically truncate cleans up the used pages but...