IDS Forum

RE: Long Checkpoints with HDR and 11.5.

Posted By: Madison Pruet
Date: Monday, 15 March 2010, at 1:07 p.m.

In Response To: RE: Long Checkpoints with HDR and 11.5. (Knox, Ernest)

It sounds like there might be an imbalance between the primary and the
secondary. A couple of questions...

1) How many physical CPUs on the primary/secondary?
2) How many CPUVPS on the primary/secondary?
3) What is OFF_RECVRY_THREADS set to?
4) What is the output of onstat -g cpu on the secondary?

M.P.

=

From: "Knox, Ernest" <Ernest.Knox@searshc.com> =

=

To: ids@iiug.org =

=

Date: 03/15/2010 12:02 PM =

=

Subject: RE: Long Checkpoints with HDR and 11.5. [19336] =

=

Sent by: ids-bounces@iiug.org =

=

We are receiving extreme slowness and long checkpoints on our 11.50.FC3=

and now 11.50.FC5 versions on AIX 6.1, while running HDR.

Everything comes back to life when we cut HDR, but began again once we
upgraded to FC5.

Has anyone else had this issue and what was the resolution?

IBM asked us to upgrade from FC3 to FC5, but that still doesn't seem to=

be the answer.

Thanks,
*******************************************************************
Ernie Knox
IT Database Administrator Specialist
Sears Holdings
3333 Beverly Rd., B4-266A
Hoffman Estates, IL. 60179
Office: (847) 286-5735
Email: Ernest.Knox@searshc.com
Blackberry: 2244650553@messaging.sprintpcs.com
Page via Skytel: 2244650553@sprint.skytel.com
Informix or MySQL Primary: 9110210@skytel.com
Informix or MySQL Secondary: 7276872@skytel.com

" Yes we can make a Change! "
" It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS=
!
"
" Lets not forget - GO Pistons and Red Wings! "
GSU
*******************************************************************

-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Peter_Logan@spartanstores.com
Sent: Monday, March 15, 2010 11:53 AM
To: ids@iiug.org
Subject: Re: Strange sql behavior [19335]

Yes it does ... and Art's explaination straightened me out ...

Peter Logan
Senior Database Administrator
Phone: 616/878-8309

From:
"Fernando Nunes" <domusonline@gmail.com>
To:
ids@iiug.org
Date:
03/15/2010 12:51 PM
Subject:
Re: Strange sql behavior [19333]
Sent by:
ids-bounces@iiug.org

s_h_w_status or s_hw_status?
Does the column exist on table ps_s_payperiod? If it does it is correct=

behavior (You have my sympathy if you find this odd...)
regards

On Mon, Mar 15, 2010 at 3:39 PM, Peter_Logan@spartanstores.com <
Peter_Logan@spartanstores.com> wrote:

> Hello,
>
> I'm running ids 11.50.fc4 on Aix 5.3 ... the following query is givin=
g

> strange behavior ... Any advice is appreciated...
>
> SELECT count(*) FROM ps_S_PAYPERIOD_STS WHERE S_HW_STATUS NOT IN
(SELECT

> S_HW_STATUS FROM ps_S_UL_EE_STS_MVW) ;
>
> This returns the count of 0...
>
> SELECT S_HW_STATUS FROM ps_S_UL_EE_STS_MVW ;
> This returns a -217, column not found, s_h_w_status ...
>
> The -217 is correct since this column doesn't exist in the view.
>
> The question is why isn't the first sql also returning the error. It'=
s

> like it doesn't care ...
>
> Please advise...
>
> Peter Logan
> Senior Database Administrator
> Phone: 616/878-8309
>
>
>
>

***********************************************************************=
*
*******

> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--
Fernando Nunes
Portugal

http://informix-technology.blogspot.com
My email works... but I don't check it frequently...

--0016e6db2b159803c00481d9aded

***********************************************************************=
*
*******

Forum Note: Use "Reply" to post a response in the discussion forum.

***********************************************************************=
*
*******
Forum Note: Use "Reply" to post a response in the discussion forum.

***********************************************************************=
********

Forum Note: Use "Reply" to post a response in the discussion forum.

=

Messages In This Thread

• RE: Long Checkpoints with HDR and 11.5.
  Knox, Ernest -- Monday, 15 March 2010, at 1:01 p.m.
  • RE: Long Checkpoints with HDR and 11.5.
    Madison Pruet -- Monday, 15 March 2010, at 1:07 p.m.
    • RE: Long Checkpoints with HDR and 11.5.
      Knox, Ernest -- Monday, 15 March 2010, at 1:41 p.m.
      • RE: Long Checkpoints with HDR and 11.5.
        Madison Pruet -- Monday, 15 March 2010, at 2:33 p.m.
  • Re: RE: Long Checkpoints with HDR and 11.5.
    JACQUES RENAUT -- Monday, 15 March 2010, at 2:03 p.m.
    • Re: RE: Long Checkpoints with HDR and 11.5.
      Art Kagel -- Monday, 15 March 2010, at 2:29 p.m.
      • Re: RE: Long Checkpoints with HDR and 11.5.
        JACQUES RENAUT -- Monday, 15 March 2010, at 3:07 p.m.
        • RE: RE: Long Checkpoints with HDR and 11.5.
          Knox, Ernest -- Tuesday, 16 March 2010, at 4:44 p.m.
          • Re: RE: RE: Long Checkpoints with HDR and 11.5.
            JACQUES RENAUT -- Tuesday, 16 March 2010, at 5:21 p.m.
            • Re: RE: RE: Long Checkpoints with HDR and 11.5.
              Madison Pruet -- Tuesday, 16 March 2010, at 7:23 p.m.
            • RE: RE: RE: Long Checkpoints with HDR and 11.5.
              Knox, Ernest -- Tuesday, 16 March 2010, at 11:44 p.m.
    • Re: RE: Long Checkpoints with HDR and 11.5.
      Madison Pruet -- Monday, 15 March 2010, at 2:34 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.