Home   |   Register   |   Rules   |   Calendar   |   Get Daily   |     |  
 


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.

 
Go Back  dBforums > Database Server Software > DB2 > DB2 backup failed

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 05-01-11, 22:15
ajiep ajiep is offline
Registered User
  
Join Date: Dec 2010
Posts: 11
Question DB2 backup failed
DB2 Version : DWBE v9.5.0.1
FIX PACK : 1
OS : AIX 5.3
==================================================

hi,

as usually i do backup database with crontab at 1 AM. now i have a problem, db2 cannot backup database all partitions. with log error

0000 SQL2001N The utility was interrupted. The output data may be incomplete.
0001 SQL1218N There are no pages currently available in bufferpool "44".
0002 SQL2001N The utility was interrupted. The output data may be incomplete.
0003 SQL1218N There are no pages currently available in bufferpool "44".
0004 SQL2001N The utility was interrupted. The output data may be incomplete.
0005 SQL1218N There are no pages currently available in bufferpool "44".
0006 SQL1218N There are no pages currently available in bufferpool "44".

SQL2429N The database backup failed. The following database partitions
returned errors: "1,3,5,6".
0.00.


and then i try to find detail of error from db2diag and its said


2011-05-01-01.00.20.404975+420 E11632271A545 LEVEL: Error
PID : 745582 TID : 15822 PROC : db2sysc 3
INSTANCE: bcuaix NODE : 003 DB : BCUDB
APPHDL : 0-499 APPID : *N0.bcuaix.110430180003
AUTHID : BCUAIX
EDUID : 15822 EDUNAME: db2bm.6065.21 (BCUDB) 3

FUNCTION: DB2 UDB, Common Trace API, sqlbFreeUpSlot, probe:122
MESSAGE : ADM6019E All pages in buffer pool "IBMSYSTEMBP32K" (ID "4099") are in use. Refer to the documentation for SQLCODE -1218.


all i know is "IBMSYSTEMBP32K" (ID "4099") is a hidden bufferpools.


bash-3.00$ db2pd -d bcudb -bufferpools

Database Partition 0 -- Database BCUDB -- Active -- Up 1 days 12:36:06

Bufferpools:
First Active Pool ID 4096
Max Bufferpool ID 0
Max Bufferpool ID on Disk 7
Num Bufferpools 4

Address Id Name PageSz PA-NumPgs BA-NumPgs BlkSize NumTbsp PgsToRemov CurrentSz PostAlter SuspndTSCt
0x070000002D6BAEC0 4096 IBMSYSTEMBP4K 4096 16 0 0 8 0 16 16 0
0x070000002D6BB2E0 4097 IBMSYSTEMBP8K 8192 16 0 0 0 0 16 16 0
0x070000002D6BB700 4098 IBMSYSTEMBP16K 16384 16 0 0 6 0 16 16 0
0x070000002D6BBB60 4099 IBMSYSTEMBP32K 32768 16 0 0 1 0 16 16 0

Bufferpool Statistics for all bufferpools (when BUFFERPOOL monitor switch is ON):

BPID DatLRds DatPRds HitRatio TmpDatLRds TmpDatPRds HitRatio IdxLRds IdxPRds HitRatio TmpIdxLRds TmpIdxPRds HitRatio
4096 1189344 312688 73.71% 192179005 5934046 96.91% 1277571 165602 87.04% 0 0 00.00%
4097 0 0 00.00% 0 0 00.00% 0 0 00.00% 0 0 00.00%
4098 948161410 19429123 97.95% 18188996 82473 99.55% 42037118 2234511 94.68% 0 0 00.00%
4099 0 0 00.00% 5715323 23298 99.59% 0 0 00.00% 0 0 00.00%

BPID DataWrts IdxWrts DirRds DirRdReqs DirRdTime DirWrts DirWrtReqs DirWrtTime
4096 3926939 3696 24523872 70889 982120 22936 8942 28232
4097 0 0 0 0 0 0 0 0
4098 135653 9322 768996832 1492149 21427988 240672 520 6469
4099 13672 0 0 0 0 0 0 0

BPID AsDatRds AsDatRdReq AsIdxRds AsIdxRdReq AsRdTime AsDatWrts AsIdxWrts AsWrtTime
4096 405 0 943 794 1796 22570 727 10046
4097 0 0 0 0 0 0 0 0
4098 4599 0 2 1 8989 26319 1424 8282
4099 0 0 0 0 0 1479 0 281

BPID TotRdTime TotWrtTime VectIORds VectIOReq BlockIORds BlockIOReq FilesClose NoVictAvl UnRdPFetch
4096 1145985 179939 0 0 0 0 0 140 4622793
4097 0 0 0 0 0 0 0 0 0
4098 31783733 280179 0 0 0 0 0 0 273248
4099 1154 2298 0 0 0 0 0 0 12287



kindly ask your advise and your guidance what should i do with this bufferpools. i am not very familliar with this issue.

Warm Regards,
Ajiep
Reply With Quote
  #2 (permalink)  
Old 05-01-11, 22:46
db2girl db2girl is offline
∞∞∞∞∞∞
  
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
You don't have any real bufferpools started - just the hidden ones.

Check previous messages in the diag.log, most likely there was not enough memory to allocate the real bufferpools so it started with hidden bufferpools.
Reply With Quote
  #3 (permalink)  
Old 05-02-11, 00:05
ajiep ajiep is offline
Registered User
  
Join Date: Dec 2010
Posts: 11
you right, there is not real bufferpool active when db2 start so db2 take all memory from hidden bufferpools.

what should do to activate real bufferpools?
Reply With Quote
  #4 (permalink)  
Old 05-02-11, 08:09
ajiep ajiep is offline
Registered User
  
Join Date: Dec 2010
Posts: 11
thanks alot for your guidance BELLO4KA... now the real buffer started again. the real buffer pool can't start because INSTANCE_MEMORY is to low. so i update to AUTOMATIC.


Regards,
Ajiep
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode 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
BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


 
 
 
Home  |   Register  |   Get New  |   FAQ's  |   Sitemap

Powered by vBulletin
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.