Skip to Content
0
Former Member
Oct 20, 2011 at 03:43 PM

update ztable is taking long time

661 Views

Hi All,

i have run the 5 jobs with the same program at a time but when we check the db trace

zs01 is taking long time as shown below.here zs01 is having small amount of data.

in the below dbtrace for updating zs01 is taking 2,315,485 seconds .how to reduce this?

HH:MM:SS.MS Duration Program ObjectName Op. Curs Array Rec RC Conn

2:36:15 AM 2,315,485 SAPLZS01 ZS01 FETCH 294 1 1 0 R/3

The code as shown below

you can check the code in the program SAPLZS01 include LZS01F01.

FORM UPDATE_ZS01.

IF ZS02-STATUS = '3'.
    IF Z_ZS02_STATUS = '3'.            "previous status is ERROR
      EXIT.
    ELSE.
      SELECT SINGLE FOR UPDATE * FROM  ZS01
             WHERE  PROC_NUM    = ZS02-PROC_NUM.
      CHECK SY-SUBRC = 0.
      ADD ZS02-MF_AMT TO ZS01-ERR_AMT.
      ADD 1           TO ZS01-ERR_INVOI.
      UPDATE ZS01.
    ENDIF.
  ENDIF.

my question is when updating the ztable why it is taking such long time,

how to reduce the time or how to make faster to update the ztable .

Thanks in advance,

regards

Suni