Performance Analysis

[Former Member]

Hi,

I can test the performance of an ABAP Object using SE30.

Is there a way to change a few lines and test the new code in the same transaction rather than creating another and then testing?

Also using ST05, I get the following error when I press the Explain tab for the SQL statement:

DATA: lt_spfli type table of spfli.

select * from spfli into table lt_spfli

where carrid = 'LH'.

SQL errorcode 443-

<u>SQL Statement</u>

SELECT

REPLACE(REPLACE(SUBSTR(VARCHAR(DB2START_TIME),1,1

9),'.',''),'-','') FROM TABLE( SNAPSHOT_DBM ( 0

)) AS SNAP

<u>Error Text</u>

SQL0443N Routine "SYSPROC.SNAPSHOT_DBM" (specific

name "SNAPSHOT_DBM") has returned an error

SQLSTATE with diagnostic text "memory allocation

error". SQLSTATE=38553

Regards,

Rachita

[Former Member]

Hi rachita,

paste your code in the 'TIPS AND TRICKS' of the runtime analysis..

there you can compare two codes

modify the code and run..

you can see the time difference immediately

regards

satesh

[Former Member]

Hi,

That gives me an immediate analysis.

Don't know about the ST05 error yet.

Thanks,

Rachita

[Former Member]

Hi,

You can test the parts of your code in the Tips and Tricks section where you can compare the two codes.

But other than that I think there is no way that you could simulatenously edit and measure performance.

For q2,

DATA: lt_spfli type table of spfli.

select * from spfli into table lt_spfli

where carrid = 'LH'.

I tried the same and didn't get any error.

[Former Member]

Hi rachita,

the piece of code you gave doesn't give me any error

regards

satesh

[Former Member]

Hi,

Use TIPS AND TRICKS in SE30.

paste your code without REPORT or PROGRAM statement

and execute.

Regarding the error, there is nothing much an ABAPer ca do as it is a database level error.

contact your BASIS admin.

Regards,

Shashank