IDS Forum

Re: RE: Light append partition after onpload

Posted By: JOHAN BACKLUND
Date: Sunday, 20 January 2008, at 4:23 a.m.

In Response To: RE: Light append partition after onpload (Alexey Sonkin)

Thanks for the quick response!

> 1. 10.0xC6 is a very problematic version of IDS. Avoid using it.
> Upgrade to xC7 or downgrade to xC5 (if you don't use HDR) or xC4.
> With xC6, make sure, that you have ' VP_MEMORY_CACHE_KB 0' in your
> $ONCONFIG (or have it set to something like 20000, if you are familiar
> with this)

This version is used because of requirements from an applicationt this customer is using. An upgrade to TC7 has been estimated to involve 4-5 months of testing. Since they don't want to delay the migration from 7.31 we just have to play with what we've got.

However, I would be more than interested in some of the worst problems with xC6 because then I could try and navigate the customer past these problems.

I've seen comments that the VP_MEMORY_CACHE_KB bug wasn't present in the Windows version, but one test did started doing excessive allocation of segments until it hit SHMTOTAL - but with some 40-50% free space in each segment. Next week I will run same tests with VP_MEMORY_CACHE_KB=0 and see if it makes a difference.

> 2. If you have a 'Passport Advantage' support contract, you are entitled
> to call IBM 24x7 'Advanced Support / System Down group'. In my opinion,
> this can be classified as 'system down' situation. Guys from Advanced
> Support can login into the system, make all the possible diagnostics,
> and, possibly, even perform binary fix of Informix disk structures.

Unfortunately, the Informix support goes through the application supplier, and although they can escalate to IBM, there is a long turnaround time before a competent answer is returned. And I am contractor from a small company, so that's why I'm knocking on this forums door.

Anyways, the customer is still in the testing phase, so none of the problems I've mentioned have affected production systems. However, planned migration date is only like 4 weeks away...

> 3. Run oncheck's on problematic tables (-cc, -cI, -cD); dump 'oncheck
-pT'

Ran all the onchecks I could think of without any problems. I'm not sure that the oncheck -pT output is still available, but if it is I will add it later. However, I looked through quite carefully when it happended but could not see anything strange - apart maybe from the fact that the table flags did NOT mention anything about Light Append Partition. This flag was only present in the sysmaster:sysptnhdr table.

> 4. Verify, that you are doing Logical log backups properly

hmm, this could be interesting. So far, all the testing has occurred with logical log backups disabled (LTAPEDEV set to NUL). Can this really have caused the problem?

> 5. Check 'online.log' for any helpful information

online.log reported nothing bad.

thanks again,

Johan

Messages In This Thread

• Light append partition after onpload
  JOHAN BACKLUND -- Saturday, 19 January 2008, at 7:31 a.m.
  • RE: Light append partition after onpload
    Alexey Sonkin -- Saturday, 19 January 2008, at 12:37 p.m.
    • Re: RE: Light append partition after onpload
      JOHAN BACKLUND -- Sunday, 20 January 2008, at 4:23 a.m.
      • FW: Re: RE: Light append partition after onpload
        Marcus Haarmann -- Sunday, 20 January 2008, at 3:52 p.m.
        • Re: FW: Re: RE: Light append partition after onplo
          JOHAN BACKLUND -- Monday, 21 January 2008, at 2:27 p.m.
    • RE: Light append partition after onpload
      Jerry Hamilton -- Tuesday, 22 January 2008, at 9:34 a.m.
      • Re: Light append partition after onpload
        Art S. Kagel (Oninit LLC) -- Tuesday, 22 January 2008, at 9:41 a.m.
  • Re: Light append partition after onpload
    John Miller iii -- Saturday, 19 January 2008, at 9:26 p.m.
    • Re: Light append partition after onpload
      JOHAN BACKLUND -- Sunday, 20 January 2008, at 4:35 a.m.
      • Re: Light append partition after onpload
        JOHAN BACKLUND -- Monday, 21 January 2008, at 2:24 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.