zOs/SQL/DSNACE11
dsnaccox v11 00010000
( ( (QueryType= REORG OR QueryType= ALL ) AND 00020001
(ObjectType= TS OR ObjectType= ALL )) AND 00030001
(Object is not in Persistent Read Only (PRO) status) AND 00040001
( REORGLASTTIME IS NULL AND LOADRLASTTIME IS NULL) OR 00050001
(NACTIVE IS NULL OR NACTIVE > 5) AND 00060001
( ( ( (REORGINSERTS×100)/TOTALROWS>RRTInsertsPct) AND 00070001
REORGINSERTS>RRTInsertsAbs) OR 00080001
( ( (REORGDELETE×100)/TOTALROWS>RRTDeletesPct) AND 00090001
REORGDELETE>RRTDeletesAbs) OR 00100001
( REORGCLUSTERSENS > 0 AND (REORGUNCLUSTINS×100) 00110001
/TOTALROWS>RRTUnclustInsPct) OR 00111001
( REORGDISORGLOB×100)/TOTALROWS>RRTDisorgLOBPct OR 00120001
( SPACE×1024)/DATASIZE>RRTDataSpaceRat OR 00130001
( (REORGNEARINDREF+REORGFARINDREF)×100) 00140001
/TOTALROWS>RRTIndRefLimit OR 00141001
REORGMASSDELETE>RRTMassDelLimit OR 00150001
EXTENTS>ExtentLimit) ) OR 00160001
( (QueryType= REORG OR QueryType= ALL ) AND 00170001
ObjectType= ALL AND 00180001
overflow index for hash access is used2, and 00190001
( overflow index TOTALENTRY x 100) 00200001
/ TOTALROWS > RRTHashOvrFlwRatio) OR 00201001
( ( QueryType= RESTRICT OR QueryType= ALL OR QueryType= REORG ) AND 00210001
( ObjectType= TS OR ObjectType= ALL ) AND 00220001
The table space is in advisory or informational reorg pending status) 00230001