Tips to Avoid Long Running BDLS

BDLS is a program developed by SAP for logical system name conversion. You can access the program from transaction code BDLS. You will use BDLS program during the system copy and system refresh. Basically, it is a normal for the BDLS to be long running but if it is extremely long running. That’s going to be a big problem! So, to avoid this, you can follow below steps.

1. Disable the archive log before running the BDLS. For Oracle, you can follow this step.

2. Run the BDLS in Test run first.

3. Create additional indexes for large table so that the updating and reading will be faster! You can add additional table as per your SAP system. This is example if your database is Oracle.

CREATE INDEX SAPSR3."GLPCA~ZZ" ON SAPSR3.GLPCA (RCLNT, AWSYS, LOGSYS) 
NOLOGGING TABLESPACE PSAPSR3 PARALLEL 20;
ALTER INDEX SAPSR3."GLPCA~ZZ" NOPARALLEL;
ANALYZE INDEX SAPSR3."GLPCA~ZZ" ESTIMATE STATISTICS SAMPLE 2 PERCENT;

CREATE INDEX SAPSR3."GLFUNCA~ZZ" ON SAPSR3.GLFUNCA (RCLNT, LOGSYS) 
NOLOGGING TABLESPACE PSAPSR3 PARALLEL 20;
ALTER INDEX SAPSR3."GLFUNCA~ZZ" NOPARALLEL;
ANALYZE INDEX SAPSR3."GLFUNCA~ZZ" ESTIMATE STATISTICS SAMPLE 2 PERCENT;

CREATE INDEX SAPSR3."COEP~ZZ" ON SAPSR3.COEP (MANDT, LOGSYSO, LOGSYSP) 
NOLOGGING TABLESPACE PSAPSR3 PARALLEL 20;
ALTER INDEX SAPSR3."COEP~ZZ" NOPARALLEL;
ANALYZE INDEX SAPSR3."COEP~ZZ" ESTIMATE STATISTICS SAMPLE 2 PERCENT;

CREATE INDEX SAPSR3."BKPF~ZZ" ON SAPSR3.BKPF (MANDT, AWSYS) 
NOLOGGING TABLESPACE PSAPSR3 PARALLEL 20;
ALTER INDEX SAPSR3."BKPF~ZZ" NOPARALLEL;
ANALYZE INDEX SAPSR3."BKPF~ZZ" ESTIMATE STATISTICS SAMPLE 2 PERCENT;

CREATE INDEX SAPSR3."STXH~ZZ" ON SAPSR3.STXH (MANDT, LOGSYS) 
NOLOGGING TABLESPACE PSAPSR3 PARALLEL 20;
ALTER INDEX SAPSR3."STXH~ZZ" NOPARALLEL;
ANALYZE INDEX SAPSR3."STXH~ZZ" ESTIMATE STATISTICS SAMPLE 2 PERCENT;

CREATE INDEX SAPSR3."LIPS~ZZ" ON SAPSR3.LIPS (MANDT, VGSYS) 
NOLOGGING TABLESPACE PSAPSR3 PARALLEL 20;
ALTER INDEX SAPSR3."LIPS~ZZ" NOPARALLEL;
ANALYZE INDEX SAPSR3."LIPS~ZZ" ESTIMATE STATISTICS SAMPLE 2 PERCENT;

CREATE INDEX SAPSR3."BCST_BOR~ZZ" ON SAPSR3.BCST_BOR (MANDT, LOGSYS) 
NOLOGGING TABLESPACE PSAPSR3 PARALLEL 20;
ALTER INDEX SAPSR3."BCST_BOR~ZZ" NOPARALLEL;
ANALYZE INDEX SAPSR3."BCST_BOR~ZZ" ESTIMATE STATISTICS SAMPLE 2 PERCENT;

CREATE INDEX SAPSR3."CATSDB~ZZ" ON SAPSR3.CATSDB (MANDT, EXTSYSTEM, LOGSYS) 
NOLOGGING TABLESPACE PSAPSR3 PARALLEL 20;
ALTER INDEX SAPSR3."CATSDB~ZZ" NOPARALLEL;
ANALYZE INDEX SAPSR3."CATSDB~ZZ" ESTIMATE STATISTICS SAMPLE 2 PERCENT;

CREATE INDEX SAPSR3."VBFA~ZZ" ON SAPSR3.CATSDB (MANDT, LOGSYS) 
NOLOGGING TABLESPACE PSAPSR3 PARALLEL 20;
ALTER INDEX SAPSR3."VBFA~ZZ" NOPARALLEL;
ANALYZE INDEX SAPSR3."VBFA~ZZ" ESTIMATE STATISTICS SAMPLE 2 PERCENT;

Remember to drop your created indexes after the BDLS is completed.