home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC64453 Status: Closed

DB2PDCFG WITHOUT OPTION IS TO DISPLAY CURRRENT STATUS ONLY, IT SHOULD NOT
RUN -FLUSHBP OPTION

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
When run db2pdcfg without any option, it should just display 
current status/settings, it should not run -flushbp.  Following 
is what been observed :- 
hotel49:/home/hotel49/juntang:)db2pdcfg 
Current PD Control Block Settings: 
 
All error catch flag settings cleared. 
 
db2cos is enabled for engine traps. 
   PD Bitmap:      0x1000 
   Sleep Time:     3 
   Timeout:        30 
 
Current bitmap value:  0x0 
 
 
State of the bufferpools: 
Oldest LSN: 00000000023281AC 
Newest LSN: 0000000002352EB7 
Initiating background flush. 
You can use "db2pdcfg -flushbp q" to monitor the progress of 
the flush operation. 
When the oldest LSN reported by the q option is greater than the 
newest LSN reported during the initial flush, then the flush has 
completed. 
 
Instance is not in a sleep state 
 
DB2 trap resilience is enabled. 
   Current threshold setting :  0 ( disabled ) 
   Number of traps sustained : 0 
 
 
FODC (First Occurrence Data Capture) options: 
   Dump directory for large objects (DUMPDIR)= 
/home/hotel49/juntang/sqllib/db2dump/ 
   Dump Core files (DUMPCORE)= AUTO
Problem Summary:
Problem Description: 
DB2PDCFG WITHOUT OPTION IS TO DISPLAY CURRRENT STATUS ONLY, IT 
SHOULD NOT RUN -FLUSHBP OPTION 
Problem Summary: 
When run db2pdcfg without any option, it should just display 
 
current status/settings, it should not run -flushbp.  Following 
is what been observed :- 
hotel49:/home/hotel49/juntang:)db2pdcfg 
Current PD Control Block Settings: 
 
All error catch flag settings cleared. 
 
db2cos is enabled for engine traps. 
   PD Bitmap:      0x1000 
   Sleep Time:     3 
   Timeout:        30 
 
Current bitmap value:  0x0 
 
 
State of the bufferpools: 
Oldest LSN: 00000000023281AC 
Newest LSN: 0000000002352EB7 
Initiating background flush. 
You can use "db2pdcfg -flushbp q" to monitor the progress of 
the flush operation. 
When the oldest LSN reported by the q option is greater than the 
newest LSN reported during the initial flush, then the flush has 
completed. 
 
Instance is not in a sleep state 
 
DB2 trap resilience is enabled. 
   Current threshold setting :  0 ( disabled ) 
   Number of traps sustained : 0 
 
 
FODC (First Occurrence Data Capture) options: 
   Dump directory for large objects (DUMPDIR)= 
/home/hotel49/juntang/sqllib/db2dump/ 
   Dump Core files (DUMPCORE)= AUTO
Local Fix:
n/a
available fix packs:
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Solution
Problem is first fixed in Version 9.7 Fix Pack 2
Workaround
n/a
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
11.11.2009
13.05.2010
13.05.2010
Problem solved at the following versions (IBM BugInfos)
9.7.FP2
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.2 FixList