Results 1 to 2 of 2

Thread: Extents

  1. #1
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1

    Unanswered: Extents

    Hi,

    I need the formula to calculate extents, buffers, locks and how to configure two server and I have a high speed en performance.

    Thanks you.
    DBA DB2 for LUW

  2. #2
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    Check the sysmaster database

    Extents per table:
    select * from sysextents
    per extent the offset in the dbspace and the size in pages. Do a SUM(size).
    select * from sysptnhdr.
    In the system catalof in systables you can also find some info on extents.

    Locks and buffers per table:
    select * from sysptprof
    total amount of lock requests and lockwaits per table since server came up. bufreads and bufwrites per table.

    Do you want to configure two servers on one machine?
    Do you currently have performance problems?
    rws

Posting Permissions

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