IDS Forum

RE: Long Checkpoints with HDR and 11.5.

Posted By: Madison Pruet
Date: Monday, 15 March 2010, at 2:33 p.m.

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

ok - a couple of things.

1) You need to have the same number (or even more) cpuvps on the
secondary.
2) The number of OFF_RECVRY_THREADS should be a near prime number and =
at
least 3 times the number of CPUVPS.

You're already going to make it more difficult for the secondary to kee=
p up
with the primary because it doesn't have the same horsepower. You migh=
t be
able to overcome that a bit by increasing the offline recovery threads.=

Making them a near prime number will tend to balance the usage a bit. =
A
near prime number would be one which is not evenly divisible by
2,5,7,11,13. So 10 is not a good one. Maybe something more like 23 wo=
uld
be better. Remember - the offline recovery threads have to balance the=

updating activity of the primary and the offline recovery threads need =
to
have a balanced load.

We have done some recent work arround checkpoint performance with HDR. =
We
now have the ability to stage the logs in a temporary space which the
checkpoint is underway. We then subsequently will apply those staged l=
ogs.

Another couple of comments.

It is best to not use indexes which are contained within the tablespace=

that the data pages are contained in (i.e. online-5 style indexes).

=

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

=

To: ids@iiug.org =

=

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

=

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

=

Sent by: ids-bounces@iiug.org =

=

M.P. this is what we have:

Answers:

1) physical cpus on both are 8

2) The number of cpuvps on primary is set to 6, on secondary it is set
to 4

3) OFF_RECVRY_THREADS is set to 10

4) Secondary is currently down. cannot give onstat -g cpu info at the
time.

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
<mailto:2244650553@messaging.sprintpcs.com)>

Page via Skytel: 2244650553@sprint.skytel.com
<mailto:2244650553@sprint.skytel.com>

Informix or MySQL Primary: 9110210@skytel.com
<mailto:9110210@skytel.com>

Informix or MySQL Secondary: 7276872@skytel.com
<mailto: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: Villagomez, Mary
Sent: Monday, March 15, 2010 12:29 PM
To: Knox, Ernest
Subject: RE: Long Checkpoints with HDR and 11.5. [19337]

Answers:

1) physical cpus on both are 8

2) The number of cpuvps on primary is set to 6, on secondary it is set
to 4

3) OFF_RECVRY_THREADS is set to 10

4) Secondary is currently down. cannot give onstat -g cpu info at the
time.

Mary Villagomez

IT Database Specialist

Sears Holdings Corporation IT

3333 Beverly Road B2-260A

Hoffman Estates, IL 60179

Phone: 847-286-1768

Pager: 2244650493@sprint.skytel.com

Blackberry: 2244650493@messaging.sprintpcs.com

________________________________

From: Knox, Ernest
Sent: Mon 03/15/2010 12:14 PM
To: Villagomez, Mary
Subject: FW: Long Checkpoints with HDR and 11.5. [19337]

Answer these and I can send it back.

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
Madison Pruet
Sent: Monday, March 15, 2010 12:08 PM
To: ids@iiug.org
Subject: RE: Long Checkpoints with HDR and 11.5. [19337]

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.

=3D

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

=3D

To: ids@iiug.org =3D

=3D

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

=3D

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

=3D

Sent by: ids-bounces@iiug.org =3D

=3D

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

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=
=3D

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=
=3D

!
"
" 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=
=3D

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=
=3D

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'=
=3D

s

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

***********************************************************************=
=3D

*
*******

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

--
Fernando Nunes
Portugal

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

--0016e6db2b159803c00481d9aded

***********************************************************************=
=3D

*
*******

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

***********************************************************************=
=3D

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

***********************************************************************=
=3D

********

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

=3D

***********************************************************************=
*
*******
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.