Archiving Object Size Program

[Former Member]

Hi Experts,

Hope everyone are OK. I have written a program at Development Server (IBM I series + DB2) to get the archiving object sizing. But it is now showing the size. And in Production(IBM I series + DB2) system also it is not showing. But in IDES environment it is showing. The program I have written is at below link:

http://wiki.scn.sap.com/wiki/display/ABAP/program+to+get+the+archiving+object+size

The output in IDES server is like above image:

The output at Dev/Production server is like above image:

So If you have any findings please let me know.

Thanks,

ASAD

[Former Member]

Not sure why you want this information.

Below is my way of finding out:

I use this transaction code "AS_AFB"

This displays list of all files and size for each file in every object archived.

[Former Member]

Mr.Gagan let me correct you, AS_AFB cannot determine the size of archiving object since this transaction is used for to get the archived file details but not the archiving object size itself. For to get the archive object size you have to use Tcode DB15 and click on statistics.

[Former Member]

just scroll left window  ...u can see all files in session and size for each file in T code "AS_AFB" for functional perspective this information suffices

[Former Member]

Yes agreed but actual query is regarding Archiving object size (means the actual table size which are associated to an archiving object in the data base), which cannot be seen in AS_AFB.

[Former Member]

In other environment it is showing, see the first image. Is there any flag to show it ?

Asad

[nabheetscn]

Hi

Can you please check whether DB_TABLE_DATA_READ raises any exception. Because in the code it has not been handled.

I can see various C function call OS level call in it. It might happen you do not have authorization for the same.

Thanks

Nabheet

[Former Member]

I have copied and moved the report to my DEV and QA systems but the report is working fine i couldn't find any difference.

Better you check the function module 'DB_TABLE_DATA_READ' output, test run it and see the table stats.

[Former Member]

here, in DVT, QAS & PRD system information is not coming. Only IDES is OK. And if I run 'DB_TABLE_DATA_READ' function module at DEV,QAS, PRD system: showing result 0 entries. And at IDES it is showing values.

Asad

[nabheetscn]

Can you please debug the function module which i have mentioned.. when it is not working you debug.

[Former Member]

I think your DB statistics has no been updated and that is why it is not reading the size, better you debug the function module and let us know..!!!

[Former Member]

Hi Nabheet madan,

I debugged the FM at both system (IDES, DEV).. it ides the DB Type is DB6 and in DEV DB type is DB4. I think this is the problem..

Asad

[nabheetscn]

See i guess you are on the right path:)

[Former Member]

But how to resolve it?

[nabheetscn]

What does the following code returns in debugging pass DB6

[nabheetscn]

You can also check class CL_RSDDTREX_TABLSERVICE and CL_RSRV_UTILITIES

[Former Member]

It is not passing that option, cause DB type is DB4

[nabheetscn]

So for DB4 this function module wont work. Other way what we can do is do we have any standard tcode where you are able to see this data. If yes then we copy the logic from that program. I guess basis will be able to provide you with the tcode.

[nabheetscn]

Please check function module DB_STATISTICS_DATA_READ and program RSDSTDB4 both can handle DB4

[Former Member]

Try DB02 tcode, you should get the backend logic for table size.

[Former Member]

Hi All,

Thannks everyone. I have resolved the issue. changed the function module DB_STATISTICS_DATA_READ. And added the program RSDSTDB4 in condition DB Type DB4.

Thanks

Asad