SAP ERP.In DBA planning calendar I return only 1 TableSpace: A100X997.DB2MISC

[Former Member]

Hi! When I planning reorg_al_ts in DBA planning calendar I return only 1 TableSpace: A100X997.DB2MISC. But objects in requiring reorg very big. In my satellite centre stay DB2 for Z/OS v10.1 and SAP NetViewer 7 EHP6 approximately.  I known, that DB2 use stored procedure SYSPROC.DSNACCOR for build the list of TableSpace requiring reorg. Maybe change parameters in DBACOOKPIT->Configuration->DB Alert Settings ?

DB2->Jobs->Jobs Control->Utility Skeletons
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      

LONGLOG CONTINUE      

TIMEOUT TERM    

RETRY 20      

RETRY_DELAY 15    

DEADLINE NONE

UTILS:TEMPL_COPYDD >>

TEMPLATE COPYTPL

UNIT SYSDA

DATACLAS SORTSAP

DISP(NEW,DELETE,DELETE)

SPACE(300000,300000) TRK

DSN ('SORTSAP3.&DB..&SN..&UQ.')

[maria_shen · Accepted solution]

Hello Oleg,

This seems to be a specific issue to IBM DB2 on z/OS, therefore, the correct space is:
http://scn.sap.com/community/db2-for-z-os

On the other hand, please also specify the SAP basis relase version and SP level there.

Thanks and kind regards
Maria

[Former Member · Accepted solution]

Sorry,Maria.  Component version: EHP7 for SAP ERP 6.0.