Results 1 to 8 of 8

Thread: STACK BIN Files

  1. #1
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655

    Unanswered: STACK BIN Files

    Hi

    We have just Upgraded to V9.5 from v8.1.9

    We are noticing following Bin files eating up space on C:\ which is serious.

    Code:
    Volume Serial Number is 1C47-6EB6
    
     
    
     Directory of C:\Program Files\IBM\SQLLIB\DB2
    
     
    
    06/02/2009  09:10 AM    <DIR>          .
    
    06/02/2009  09:10 AM    <DIR>          ..
    
    10/21/2008  10:34 AM                 0 .prf
    
    06/02/2009  09:08 AM     1,137,356,798 1000.000.stack.bin
    
    06/02/2009  09:08 AM     2,182,713,344 2196.000.stack.bin
    
    06/02/2009  09:08 AM       497,807,359 2868.000.stack.bin
    
    06/02/2009  05:56 AM         4,742,699 4972.000.stack.bin
    Please Help ... . This is in Production

    Thanks
    DBinder

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Is there anything in the db2diag.log file?

    Andy

  3. #3
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    Yes,

    Its huge file.

    What to look far ?

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Everything with a timestamp near the timestamp of the files.

    Andy

  5. #5
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    2009-06-02-06.00.48.060000-240 I50785379F888 LEVEL: Error
    PID : 2304 TID : 1000 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000
    EDUID : 1000 EDUNAME: db2pfchr (ECX)
    FUNCTION: DB2 UDB, buffer pool services, sqlbBlockAreaErrorHandler, probe:0
    DATA #1 : Object descriptor, PD_TYPE_SQLB_OBJECT_DESC, 72 bytes
    Obj: {pool:103;obj:4;type:0} Parent={103;4}
    lifeLSN: 0291E13BE7AD
    tid: 0 0 0
    extentAnchor: 1672112
    initEmpPages: 0
    poolPage0: 1672128
    poolflags: 102
    objectState: 27
    lastSMP: 0
    pageSize: 4096
    extentSize: 16
    bufferPoolID: 1
    partialHash: 262247
    bufferPool: 0x000007ffe72aaa40

    2009-06-02-06.00.48.060000-240 I50786269F431 LEVEL: Error
    PID : 2304 TID : 1000 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000
    EDUID : 1000 EDUNAME: db2pfchr (ECX)
    FUNCTION: DB2 UDB, buffer pool services, sqlbReadAndReleaseBlock, probe:110
    MESSAGE : ZRC=0x860F0006=-2045837306=SQLO_DSEK "seek error (DD)"
    DIA8720C A device SEEK error has occurred.

    2009-06-02-06.00.48.060000-240 I50786702F447 LEVEL: Error
    PID : 2304 TID : 1000 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000
    EDUID : 1000 EDUNAME: db2pfchr (ECX)
    FUNCTION: DB2 UDB, buffer pool services, sqlbReadAndReleaseBlock, probe:110
    DATA #1 : String, 105 bytes
    Tablespace 103 (TSD1) flags=102 HighWaterMark=2082368ConOffset=2599485440, startpage=1903904, numPages=16

    2009-06-02-06.00.48.060000-240 I50787151F431 LEVEL: Error
    PID : 2304 TID : 1000 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000
    EDUID : 1000 EDUNAME: db2pfchr (ECX)
    FUNCTION: DB2 UDB, buffer pool services, sqlbReadAndReleaseBlock, probe:100
    MESSAGE : ZRC=0x860F0006=-2045837306=SQLO_DSEK "seek error (DD)"
    DIA8720C A device SEEK error has occurred.
    These errors are still happening contineously

    A prefetcher ERROR

    I need to find all parameter that affect PREFETCHER.

    Can we turn it off to see what happens


    DBFinder

  6. #6
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Did the restore/migration from v8 to v9.5 complete successful for all tablespaces? When you do "list tablespaces show detail", are all tablespaces in normal state? Are users reporting any errors when accessing the database?


    Please check the Windows event log to see if there are any errors reported around the same time. You may try to restart the db/instance and, if that doesn't resolve the errors, apply the latest fixpak. If the errors still continue, consider opening a pmr.

  7. #7
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    As Bella said try a restart. Yesterday googling your question I came up with an entree on IBM that said restart worked.
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

  8. #8
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    Yes Restart was tried.

    No help.

    A PMR was opened, No solution suggested so far. IBM seemes to know the reason, they suggested fixpack 3b.

    Actually I found that one of the tablespace is in Blocked mode. a big number.
    But that was running on the same machine for long time.

    Blocked mode prefetch is generating Disk seek error. I may decrerase the Blocks and try or set Blocked prefetch pages to 0.

    That is what we plan to try. Any way IBM should have told us. I had a PMR open while testing the migration on mirror. Now they suggesting after we have lost few hours on migration.

    IBM suggested to delete these dump files via scheduled delete job. So I am deleting these files every 30 minutes. There was no error while upgrade and we do not see any gain or loss in performance. CPU and other parameters are quite the same.

    So finally I am sure it is bufferpool PREFETCHER error which IBM says was seen in pre fixpack 2 installations.

    Not sure when but we might have to apply fixpack 3b.


    Thanks for all your effort to help.

    DBFinder

Posting Permissions

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