Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2008
    Location
    Toronto, Canada
    Posts
    399

    Unanswered: 'first failure 34' and 'archive status failure'

    DB2 v9.5.1 ESE on AIX v6.1
    we are deleting many recs from 2 tables in the DB and developers told me they commit only after thousands of deletes. everything is very slow. db2pd shows failure in Archive Status:
    db2pd -db prod_db -logs
    Logs:
    Current Log Number 71
    Pages Written 6141
    Method 1 Archive Status Failure
    Method 1 Next Log to Archive 71
    Method 1 First Failure 34
    Method 2 Archive Status n/a
    Method 2 Next Log to Archive n/a
    Method 2 First Failure n/a

    Address StartLSN State Size Pages Filename
    0x077000002002EF78 0x03D96FF90000 0x00000000 30000 30000 S0000070.LOG
    0x077000002047FF38 0x03D9774C0000 0x00000000 30000 30000 S0000071.LOG
    0x077000002002FE78 0x03D97E9F0000 0x00000000 30000 30000 S0000072.LOG
    0x077000002002FF38 0x03D985F20000 0x00000000 30000 30000 S0000073.LOG
    0x077000002001FE38 0x03D98D450000 0x00000000 30000 30000 S0000074.LOG
    0x077000002001FEF8 0x03D994980000 0x00000000 30000 30000 S0000075.LOG
    0x0770000020487658 0x03D99BEB0000 0x00000000 30000 30000 S0000076.LOG
    0x0770000020487718 0x03D9A33E0000 0x00000000 30000 30000 S0000077.LOG
    0x07700000204877D8 0x03D9AA910000 0x00000000 30000 30000 S0000078.LOG
    0x0770000020487898 0x03D9B1E40000 0x00000000 30000 30000 S0000079.LOG
    0x0770000020487958 0x03D9B9370000 0x00000000 30000 30000 S0000080.LOG
    0x0770000020487A18 0x03D9C08A0000 0x00000000 30000 30000 S0000081.LOG
    0x0770000020487AD8 0x03D9C7DD0000 0x00000000 30000 30000 S0000082.LOG
    0x0770000020487B98 0x03D9CF300000 0x00000000 30000 30000 S0000083.LOG
    0x077000022EA8FC98 0x03D9D6830000 0x00000000 30000 30000 S0000084.LOG


    what does it mean? I can not see anything special in other db2pd outputs or in snapshot outputs. Anything else I could look at to see where the problem is?

    thanks in advance
    DB2 9.5/9.7 on Unix/AIX 6.1/Linux

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

    what does it mean? I can not see anything special in other db2pd outputs or in snapshot outputs. Anything else I could look at to see where the problem is?
    How about db2diag.log?
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Dec 2008
    Location
    Toronto, Canada
    Posts
    399
    Quote Originally Posted by n_i View Post
    How about db2diag.log?
    no problems in the diag.log. Only STMM changing some parameters from time to time
    STMM log file (78) removed automatically to maintain space constraint.
    "Sheapthres_shr" From: "5000" <automatic> To: "7500" <automatic>
    "Sortheap" From: "500" <automatic> To: "750" <automatic>

    we have archive logging ON:
    (LOGARCHMETH1) = DISK:/dbbackup/<db_name>/offline/
    DB2 9.5/9.7 on Unix/AIX 6.1/Linux

  4. #4
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    what is the definition of slow?
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

  5. #5
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    You can find some info here (Scenario 10):
    IBM DB2 9.5 Information Center for Linux, UNIX, and Windows

  6. #6
    Join Date
    Dec 2008
    Location
    Toronto, Canada
    Posts
    399
    we figured there were not problems with DB2. the query developers were running were extremely unefficient (would take like 26hrs). they re-wrote the query and it runs much faster (10-15mins).
    DB2 9.5/9.7 on Unix/AIX 6.1/Linux

Posting Permissions

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