Results 1 to 9 of 9

Thread: Table freezing

  1. #1
    Join Date
    Nov 2006
    Posts
    6

    Unhappy Unanswered: Table freezing

    Hi,

    I have a table who when I access it for first time, on day, its 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 its freezing again.
    Whats the problem??? Somebody pass for this problem??

    Thanks,
    Alexandre.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    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

  3. #3
    Join Date
    Nov 2006
    Posts
    6
    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.

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    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

  5. #5
    Join Date
    Nov 2006
    Posts
    6
    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.

  6. #6
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    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

  7. #7
    Join Date
    Jul 2002
    Location
    ATL
    Posts
    170
    Just Run the runstats on the table

  8. #8
    Join Date
    Nov 2006
    Posts
    6
    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.

  9. #9
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Can you post the access plan for the query?

    Andy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •