topic Re: Archiving Object Size Program in Application Development and Automation Discussions

Archiving Object Size Program

Former Member — Wed, 09 Oct 2013 05:30:52 GMT

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

Re: Archiving Object Size Program

Former Member — Mon, 14 Oct 2013 16:35:07 GMT

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.

Re: Archiving Object Size Program

Former Member — Tue, 15 Oct 2013 04:58:51 GMT

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.

Re: Archiving Object Size Program

Former Member — Wed, 16 Oct 2013 15:01:25 GMT

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

Re: Archiving Object Size Program

Former Member — Thu, 17 Oct 2013 04:55:52 GMT

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.

Re: Archiving Object Size Program

Former Member — Mon, 21 Oct 2013 03:50:54 GMT

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

Asad

Re: Archiving Object Size Program

nabheetscn — Mon, 21 Oct 2013 05:15:20 GMT

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

Re: Archiving Object Size Program

Former Member — Mon, 21 Oct 2013 05:20:37 GMT

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.

Re: Archiving Object Size Program

Former Member — Mon, 21 Oct 2013 05:51:01 GMT

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

Re: Archiving Object Size Program

nabheetscn — Mon, 21 Oct 2013 05:53:07 GMT

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

Re: Archiving Object Size Program

Former Member — Mon, 21 Oct 2013 05:59:39 GMT

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..!!!

Re: Archiving Object Size Program

Former Member — Mon, 21 Oct 2013 08:05:16 GMT

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

Re: Archiving Object Size Program

nabheetscn — Mon, 21 Oct 2013 08:06:47 GMT

See i guess you are on the right path:)

Re: Archiving Object Size Program

Former Member — Mon, 21 Oct 2013 09:53:40 GMT

But how to resolve it?

Re: Archiving Object Size Program

nabheetscn — Mon, 21 Oct 2013 09:59:24 GMT

What does the following code returns in debugging pass DB6

Re: Archiving Object Size Program

nabheetscn — Mon, 21 Oct 2013 10:01:25 GMT

You can also check class CL_RSDDTREX_TABLSERVICE and CL_RSRV_UTILITIES

Re: Archiving Object Size Program

Former Member — Tue, 22 Oct 2013 03:30:26 GMT

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

Re: Archiving Object Size Program

nabheetscn — Tue, 22 Oct 2013 04:23:22 GMT

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.

Re: Archiving Object Size Program

nabheetscn — Tue, 22 Oct 2013 04:28:55 GMT

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

Re: Archiving Object Size Program

Former Member — Tue, 22 Oct 2013 04:56:11 GMT

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