Hi,

I have a table who when I access it for first time, on day, it´s wait a long time for return their lines. After that first access the other accesss for me and other users have a normal answer time. Past 1 or 2 hours it´s freezing again.
What´s the problem??? Somebody pass for this problem??

Thanks,
Alexandre.

What DB2 version and OS are you using?
What is the definition of the table?
What is the SQL you are using to access it?
What is your DB2 configuration, especially bufferpools?

Andy

What DB2 version and OS are you using?
DB2 Udb 8 for Windows NT.
What is the definition of the table?
I don´t undestand. Its a comun-table.
What is the SQL you are using to access it?
select column from table_name;
What is your DB2 configuration, especially bufferpools?
1 IBMbufferpool (4 kb)

Thanks.

I need the definition of the table (CREATE TABLE ...).
I need the exact SELECT statement you are using on the table above.
Run: "select bpname,npages,pagesize from syscat.bufferpools" and post results for bufferpool configuration.
Also how many rows in the table? Any indexes?

Andy

create table ASPAU001.I_SP_AU028
(
COD_GRANEL VARCHAR(15) not null with default,
METODO_GRANEL VARCHAR(1) not null with default,
COD_EMBALAGEM VARCHAR(15) not null with default,
METODO_EMBALAGEM VARCHAR(1) not null with default,
FLG_VINCULADO CHAR(1) ,
FLG_LIBERADO CHAR(1) ,
primary key (COD_GRANEL, METODO_GRANEL, COD_EMBALAGEM, METODO_EMBALAGEM)
)
in TS_AU028;

comment on table ASPAU001.I_SP_AU028 is 'VINCULOS DE GRANEL_EMBAL';

comment on column ASPAU001.I_SP_AU028.COD_GRANEL is 'COD_GRANEL';

comment on column ASPAU001.I_SP_AU028.METODO_GRANEL is 'METODO_GRANEL';

comment on column ASPAU001.I_SP_AU028.COD_EMBALAGEM is 'COD_EMBALAGEM';

comment on column ASPAU001.I_SP_AU028.METODO_EMBALAGEM is 'METODO_EMBALAGEM';

comment on column ASPAU001.I_SP_AU028.FLG_VINCULADO is 'Informa se há vinculo';

comment on column ASPAU001.I_SP_AU028.FLG_LIBERADO is 'informa os projetos liberados para aprovação';

create unique index SQL0004170801097502222 on ASPAU001.I_SP_AU028 (COD_GRANEL asc, METODO_GRANEL asc);

select * from
where COD_GRANEL = 'OLSNA001' and
METODO_GRANEL = '1';

That´s table has 156234 rows.

Please Run: "select bpname,npages,pagesize from syscat.bufferpools" and post results for bufferpool configuration.

Also have you done a runstats on the table and indexes?

Andy

Just Run the runstats on the table

Guys,

select bpname,npages,pagesize from syscat.bufferpools

BPNAME NPAGES PAGESIZE
------------------ ----------- -----------
IBMDEFAULTBP 67500 4096
BP_32K 5229 32768
APL 8125 8192

The Runstat is executed every night.

Thnks,
Alexandre.

Can you post the access plan for the query?

Andy