Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2010
    Posts
    11

    Question Unanswered: 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

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    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.

  3. #3
    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?

  4. #4
    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

Posting Permissions

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