| |
|
If this is your first visit, be sure to check out the FAQ by clicking the link above.
You may have to register before you can post: click the register link above to proceed.
To start viewing messages, select the forum that you want to visit from the selection below.
|
 |
06-02-09, 09:25
|
|
Registered User
|
|
Join Date: Sep 2008
Location: Toronto,Canada
Posts: 606
|
|
|
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
|
|
06-02-09, 10:22
|
|
Registered User
|
|
Join Date: Jan 2003
Posts: 3,575
|
|
Is there anything in the db2diag.log file?
Andy
|
|
06-02-09, 10:29
|
|
Registered User
|
|
Join Date: Sep 2008
Location: Toronto,Canada
Posts: 606
|
|
|
|
Yes,
Its huge file.
What to look far ?
|
|
06-02-09, 11:36
|
|
Registered User
|
|
Join Date: Jan 2003
Posts: 3,575
|
|
Everything with a timestamp near the timestamp of the files.
Andy
|
|
06-02-09, 12:39
|
|
Registered User
|
|
Join Date: Sep 2008
Location: Toronto,Canada
Posts: 606
|
|
Quote:
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
|
|
06-02-09, 18:34
|
|
∞∞∞∞∞∞
|
|
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
|
|
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.
|
|
06-03-09, 09:49
|
|
Registered User
|
|
Join Date: Nov 2005
Location: IL
Posts: 554
|
|
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.1.0.2 os 5.3.0.0
|
|
06-03-09, 13:37
|
|
Registered User
|
|
Join Date: Sep 2008
Location: Toronto,Canada
Posts: 606
|
|
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
|
|
| Thread Tools |
Search this Thread |
|
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|
dBforums
>
STACK BIN Files
