During our SAP Refresh Activity, we have seen it’s taking too much time on VBAP table while performing the BDLS activity.
OS – SUSE SP12
DB2 Version – 11.1.3.3
SAP NW Version – 7.01
There are 2 ways to create, either you can create via SE11 then use SE14 to create in DB or else run below command to create directly in DB.
I have created the same directly in DB and once BDLS activity get completed, dropped the index.
db2 “create index VBAP_Z02 on
update runstats of table(Mandatory after creation of Index)
db2 “runstats on table
Post completion of above 2, you can trigger the BDLS.
Drop of Index (Post BDLS)
db2 “drop index VBAP_Z02”
Let me know if this helps you.