SAP Note 1149824 - DB2-z/OS: BI 7.x: DB settings and performance

Composant : BW DB2 for OS/390 -

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

Mots Clés :
starjoin 2 sjtables 4 mxtbjoin 225 tables_joined_threshold 10 mxqbce 1023 max_opt_cpu 2 max_opt_elap 4 sjmxpool >= 128 mb sjmissky, sap profile parameter dbs/db2/use_define_no = 0, sap profile parameter dbs/db2/use_define_no=1, dsnutils stored procedures sap bi, psa}_bpool_{data_index}buffer pool, fact table-> note 579863db2_runstats_optionadditional option, db2 dsnutils stored procedure, optimizer access method dynamic indexanding, recommended db2 parameter settings, db2 service programs runstats

Notes associées :

390016DB2/390: BW: Database settings and performance
81737DB2-z/OS: APAR List