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