Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2010
    Location
    The Netherlands
    Posts
    20

    Unanswered: runstats keeps giving sql964

    We are running runstats on a table with about 36 million records

    Te log file size of the db is 100000, primary log files are 20 and secondary log files are also 20.

    First we used the command
    Code:
    runstats on table xxx and indexes all
    this resulted in sql964 ( The transaction log for the database is full).

    After this we used the command
    Code:
    runstats on table xxx
    and increased the secondary log files to 50.
    But with the same result.

    In our last try we used the command
    Code:
    runstats on table xxx on columns (id)
    and increade the secondary log files to 100.
    But also with the same result.

    There is enough disk space.

    Does anyone have an id how to succesfully execute the runstats?

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Nov 2010
    Location
    The Netherlands
    Posts
    20
    We are using Db2 V9.7.3

    So the issue explained in your link shouldn't be the problem for us.

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by tsluijter View Post

    Does anyone have an id how to succesfully execute the runstats?
    Try sampling (the TABLESAMPLE clause).
    ---
    "It does not work" is not a valid problem statement.

Tags for this Thread

Posting Permissions

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