DB2 for z/OS: JC Greatest Hits, War Stories, Best Practices 2016
Project and Program:
Information Management,
Database
Tags:
Proceedings,
2017,
SHARE San Jose 2017
This presentation will provide an opprtunity to learn recommended best practice for DB2 for z/OS, and to learn from the positive and negative experiences of other customer installations. The following topics will be covered: System parameter DEL_CFSTRUCTS_ON_RESTART=YES setting, automated DB2 restart and misuse of “Restart Light”, REAL memory planning LFAREA IEASYSxx parameter, ALTER BUFFERPOOL bpname immediate, Global Lock Manager (GLM) cleanup and recovery in data sharing, Fast REORG with SORTDATA NO RECLUSTER NO, Housekeeping: REORG INDEX and REORG TABLESPACE, Conversion to table-controlled partitioning, Alter limit key with table-controlled partitioning, Value of rebind for migrated static SQL packages, Multi-site data sharing group and extended distance, and zIIP capacity.-John Campbell-IBM
Back to Proceedings File Library