Reorg SYSIBM tables to reduce extents (XT) - change priqty &



IBM's flagship relational database management system

Reorg SYSIBM tables to reduce extents (XT) - change priqty &

Postby TechnoCaveman » Thu Feb 17, 2022 7:46 pm

Have a new DB2 V12 database on z/OS 2.4 z13. With hundreds of programs to rebind, sysibm.syspackage, sys.columns, sys.tables, etc will grow. Hence the need to reorganize the tablespace for performance. Maintenance window is one hour, so just one tables space is being done. Small space less than 700 tracks.

Goal: after updating PriQty and SecQty, reorg sysibm.sysplan in DSNDB01.SPT01 and index space DSNPPH01 to reduce extents (XT) and improve performance.

Q: Is reorg run on system tables the same as for user tables? Is there special IBEGENR (sp?) VSAM redefine needed for system tables?
In general, what is the best way to update the system tables and show them some love.

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)
TechnoCaveman
 
Posts: 1
Joined: Thu Feb 17, 2022 7:15 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Reorg SYSIBM tables to reduce extents (XT) - change priq

Postby engh » Thu Sep 22, 2022 1:51 pm

hello

everything is explained here :

https://www.ibm.com/docs/en/db2-for-zos/12?topic=tablespace-reorganizing-catalog-directory

Note that a full image copy is required before
engh
 
Posts: 9
Joined: Fri Jul 08, 2022 7:29 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Reorg SYSIBM tables to reduce extents (XT) - change priq

Postby sergeyken » Thu Sep 22, 2022 4:49 pm

It MUST be posted like this:

TechnoCaveman wrote:Have a new DB2 V12 database on z/OS 2.4 z13. With hundreds of programs to rebind, sysibm.syspackage, sys.columns, sys.tables, etc will grow. Hence the need to reorganize the tablespace for performance. Maintenance window is one hour, so just one tables space is being done. Small space less than 700 tracks.

Goal: after updating PriQty and SecQty, reorg sysibm.sysplan in DSNDB01.SPT01 and index space DSNPPH01 to reduce extents (XT) and improve performance.

Q: Is reorg run on system tables the same as for user tables? Is there special IBEGENR (sp?) VSAM redefine needed for system tables?
In general, what is the best way to update the system tables and show them some love.

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
//SYSIN   DD  *
 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)
Javas and Pythons come and go, but JCL and SORT stay forever.
User avatar
sergeyken
 
Posts: 408
Joined: Wed Jul 24, 2019 10:12 pm
Has thanked: 6 times
Been thanked: 40 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post