SAP Note 122599 - DB2/390: Performance of the update

Composant : DB2 for z/OS -

Solution : https://service.sap.com/sap/support/notes/122599 (Connexion à SAP Service Marketplace requise)

Mots Clés :
rdisp/vb_key_comp = /host/synr/wpnr/date/time/stmp/, sapdb01locksize rowlockpart yeslockmax 0ccsid asciibufferpool bp4numparts 4, create type 2 unique index vbdata____0, sap bc database administration guide, bc sap database administration guide, create type 2 unique index vbhdr_____0, create type 2 unique index vbmod_____0, system assigns update log tables, stogroup sapsg01 priqty 36720 secqty 3672, stogroup sapsg02 priqty 36720 secqty 3672

Notes associées :

1312704DB2-z/OS: Handling of VBDATA (with DB2 v9.1)
1094550Local update and update key in old format
823245DB2-z/OS: Transports & Support Packages (7.0 and higher)
822248DB2-z/OS: Growth of the tablespace of table VBDATA
493577DB2/390: Transports and Support Packages for 6.20
480180Download and installation of attachments for SAP notes
427392DB2/390: Table tuning after the upgrade
417920DB2/390: Corrections for 6.10 and 6.20
191191Partitioning update tables
184399DB2/390: DDIC corrections (Releases 4.6A,4.6B,4.6C,4.6D)
135207DB2/390: Partitioning of tables
118901DB2/390: Transports for 4.5A
116698DB2/390: Optimizing Access to Tables VBHDR, VBMOD, VBDATA
109515Update groups for asynchronous updates
103707DB2/390: Transports for 4.0B
102353Update control
101303DB2/390: Transports for 3.1I
82953DB2/390: Tables Isolation and Buffer Pools Tuning