Skip to Content
author's profile photo Former Member
Former Member

DB - IDES exploding on Mobile Clients - HELP

Hello,

I'm facing a strong issue since few days. Everyday I have a mobile client which has it's IDES database full.

We are limited to 2GO on local machine and it's been only a 3 months we went live.

Some work has been done (on subscription etc) to limit the download of data , we have few attachements - but still we have this issue today and I was wondering if you know what I could do (on local machines for ex) to avoid this huge problem.

Thank you guys for your help,

Mi

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 21, 2007 at 04:05 PM

    Hi,

    do you already have tried to defragment/shrink the local database? For this please refer to note 417539.

    Especially after initial load or heavy data exchange this might help to lower the database volume.

    The attached files to this note help you to do this job on a regular basis.

    Regards,

    Wolfhard

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 21, 2007 at 05:39 PM

    Hello and thank you for your reply.

    I know about this Note and I ask the sales force team to run a reorg' of their database at least once a week.

    The fact is that some of them can forget to do this and that I cannot check all the 200 Mobile Client database to see if they are reaching these 2GO Ides space or not.

    I was wondering if someone knew an automatic solution (like a script running each week when PC is launched ) I could install on Mobile Client PC...

    Thank you again for your replu,

    Mi

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      of course you could do this automatically by sending the particular command file by client update via conntrans every week or month or even put this cmd file in the PC startup folder.

      Obviously you were using MSDE because of the mentioned limitation. As far as I know this is changed to 4 GB for the newest MSDE version. For this you should check the PAM (product availability matrix) on SAP homepage.

      Regards,

      Wolfhard

  • author's profile photo Former Member
    Former Member
    Posted on Nov 27, 2007 at 03:44 PM

    Hello and thank you again for your reply.

    I know we have a limited MSDE and we could have a 4GB if we go to SP12 but now it's not planned so I have to find an other solution. (I'm going to script a DB reorg a week on our Mobile Clients, but I know it's not enough).

    I noticed that one of my biggest table on IDES is SMOCONDXML which contains I suppose conditions linked to sales transaction.

    Then I have those syscomments, sysindexes and syscolumns tables who are quite big even after reorganising my DB ... they are system tables they should empty by themselves , or not?

    Anyway I'm still searching for a solution.

    Cheers ,

    Mi

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      I am sorry to say that only a redefinition of the data distribution could help (e.g. additional filtering on sales docs based on status etc) to avoid to keep old historical data on the laptop which is not needed anymore.

      But also in case you were using unicode laptop configuration (which costs twice database storage amount!!!) you could think of using non-unicode local installation in case unicode is not used at all in your business processes.

      Regards,

      Wolfhard

  • Posted on Dec 03, 2007 at 03:01 PM

    Hi,

    reading all comments below I would suggest first thing: Analyze your IDES Databse which Dable has which Size. Based on this think about strategies to reduce this specific Dataobjects (or change to a different DB like the follow up of MSDE with 4 GB limit)

    Andreas

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hello ,

      Thank you again for your replies !

      I'm still trying to find out a solution to my problems here and I realised (after another DB explosion one morning) that someone in some old time created for some specific data issue a Z_SOMETHING replication object typed "dependent" with no criteria fields and linked to CAPGEN_OBJECT_WRT . It also shares same publication obj. and suscription as CAPGEN. (which means "hell" if I want to change anything).

      For me the only dependency you really have on these data is useful when you launch a complete extract for mobile clients (since the key is the BP number).

      These specific data go to mobile clients once a day when a program is run (and specific bdoc created) .

      We are suppose to have maximum one BDOC per BP ... BUT on a mobile client with 200 BPs I can get up to 3000 messages from the same object a day...

      When I ask why this object was created as dependent and not intellignet with filtering the answer was " to optimize the middleware, entries in the Lookup table"... I still don't understand why..

      (and I'm wondering to have some cust_hierarchy modification but for now I'm still analyzing the issue - I'm also going to make a cut on some attachments soon)

      Anyway merry xmas to everyone 😊 and thank you again for your replies they help me to find te way to optimise my DBs !

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.