SAP Note 70964 - DB2/390: Performance

Composant : DB2 for z/OS -

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

Mots Clés :
rsdb/max_blocking_factor         = 10rsdb/max_in_blocking_factor      = 10rsdb/min_blocking_factor         = 3rsdb/min_in_blocking_factor      = 3rsdb/prefer_fix_blocking         = 0rsdb/prefer_union_all            = 1rsdb/prefer_in_itab_opt          = 1these settings attempt, db2 dynamic statement cache, optimal sql statement, entries performs poorly, separate sql statements, db2 optimizer, terms union, list reason, sap profile, prerequisites

Notes associées :

380377RSQL error 13, ANEP_READ_BWAGR_MULTI_AFABE, AB08
48230Parameters for the SELECT ... FOR ALL ENTRIES statement