Reorg SYSIBM tables to reduce extents (XT) - change priqty & secQTY
0
votes
1
answer
246
views
I have a new DB2 V12 database on z/OS 2.4 z13, with hundreds of programs to rebind, such as: sysibm.syspackage, sys.columns, sys.tables, etc. These will grow, hence the need to reorganize the tablespace for performance.
Maintenance window is one hour, so just one tables space is being done.
1. Is reorg run on system tables the same as for user tables?
2. Is there special IBEGENR (sp?) VSAM redefine needed for system tables.
Sample JCL:
//REORGS1 EXEC PGM=DSNUTILB,PARM='MT03,REORG1DB'
//STEPLIB DD DSN=DSNC10.SDSNLOAD,DISP=SHR
//SYSREC DD DSN=&&SYSREC,DISP=(NEW,DELETE,DELETE),
// SPACE=(TRK,(9000,5000),,,ROUND),UNIT=SYSDA
LISTDEF TBLSLIST
INCLUDE TABLESPACES DATABASE TR032
REORG
TABLESPACE LIST TBLSLIST COPYDDN(CDD1) LOG NO
SHRLEVEL REFERENCE
SORTKEYS SORTDATA SORTDEVT SYSDA
STATISTICS TABLE(ALL) INDEX(ALL)
`
Asked by TechnoCaveman
(1 rep)
Feb 17, 2022, 01:43 PM
Last activity: May 25, 2025, 02:01 AM
Last activity: May 25, 2025, 02:01 AM