fragmented table and pdq
In testing we want to play with testing of setting pdq to 5 across the
board, we have always run pdq at - except when indexing or updating
stats.
What we found when pdq is set this sql does not stop at the first 5000
records.
IDS is 11.5.FC3
Os is Solaris 10
set pdqpriority 5;
create table gh_test
(
doc_ref serial not null,
ssn_ref integer not null,
doc_type char(1),
detail_ref integer,
detail_type char(1),
date_time datetime year to second not null,
spoke_with varchar(40) not null,
confidential smallint default 0,
details varchar(255) not null,
user_id char(8),
valid_call smallint,
method char(1),
delete_dt date
)
Fragment by expression
(MOD(ssn_ref, 3) = 0 ) in support1,
(MOD(ssn_ref, 3) = 1 ) in support2,
(MOD(ssn_ref, 3) = 2 ) in support3
extent size 100 next size 50
lock mode row;
insert into gh_test
select first 5000 * from doc;
Bruce Simms
Data Base Services
TALX Corporation
2330 Ball Drive
St. Louis, MO 63146
Phone (314) 214-7703
FAX (314) 983-3238
bsimms@talx.com
BUG! Open a case.
Art
On Wed, Nov 19, 2008 at 1:37 PM, Bruce Simms <BSimms@talx.com> wrote:
> In testing we want to play with testing of setting pdq to 5 across the
> board, we have always run pdq at - except when indexing or updating
> stats.
>
> What we found when pdq is set this sql does not stop at the first 5000
> records.
>
> IDS is 11.5.FC3
> Os is Solaris 10
>
> set pdqpriority 5;
> create table gh_test
> (>
> doc_ref serial not null,
>
> ssn_ref integer not null,
>
> doc_type char(1),
>
> detail_ref integer,
>
> detail_type char(1),
>
> date_time datetime year to second not null,
>
> spoke_with varchar(40) not null,
>
> confidential smallint default 0,
>
> details varchar(255) not null,
>
> user_id char(8),
>
> valid_call smallint,
>
> method char(1),
>
> delete_dt date
> )
> Fragment by expression
>
> (MOD(ssn_ref, 3) = 0 ) in support1,
>
> (MOD(ssn_ref, 3) = 1 ) in support2,
>
> (MOD(ssn_ref, 3) = 2 ) in support3
> extent size 100 next size 50
> lock mode row;
>
> insert into gh_test
> select first 5000 * from doc;>
> Bruce Simms
> Data Base Services
> TALX Corporation
> 2330 Ball Drive
> St. Louis, MO 63146
>
> Phone (314) 214-7703
> FAX (314) 983-3238
> bsimms@talx.com
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do
those opinions reflect those of other individuals affiliated with any entity
with which I am affiliated nor those of the entities themselves.