Results 1 to 13 of 13
  1. #1
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655

    Unanswered: Online Backup Failling - Disk Full.

    Hi Guys,

    DB2 V9.1.3 on Win 2k3

    We have a recent issue of backup failling because of disk becoming full.

    Till yesterday as I know, Image size was varying within 165GB - 185GB. The disk size is 200GB.
    Here is database size info.
    D:\>db2 "CALL GET_DBSIZE_INFO (?, ?, ?, -1)"

    Value of output parameters
    --------------------------
    Parameter Name : SNAPSHOTTIMESTAMP
    Parameter Value : 2009-08-09-09.26.48.978000

    Parameter Name : DATABASESIZE
    Parameter Value : 179610378240

    Parameter Name : DATABASECAPACITY
    Parameter Value : 654944332800

    Return Status = 0

    D:\>
    Today morning it failed just 47 mins after its normal completion time (1:00 am - 3:00am)
    Assuming that there might have been too many activities during weekend night, I just restarted ONLINE BACKUP again. This time it Failed again around 6:00am taking about 50 minutes more than normal.
    I restarted again without investigating, just in hurry to get mirror up in least time. This time again it failed after 3 hours.

    I am not really expert of backup & restore. The database size seems as before. What factors affect ONLINE BACKUP ?? Can it be real-time applications that misbehave during backup resulting bigger backup image ??.

    DATA satying the same, what factors force DB2 to generate bigger image ??.

    here is command used and result

    backup database GAM_PROD online to "h:\online_image" with 10 buffers buffer 256 UTIL_IMPACT_PRIORITY 20 without prompting
    SQL2419N The target disk "h:\online_image" has become full.
    While monitoring remotely I observed too many commit_Active 's take place at same time.

    APP_HNDL STATUS_CHANGE_TIME THREAD_AGE APPL_STATUS APPL_NAME DBNAME

    -------- -------------------------- -------------- ------------ -------------------- ----------

    1458 2009-08-09-07.51.58.168129 -13.66 UOWEXEC java.exe GC_PROD

    2399 2009-08-09-07.51.58.323025 -13.81 UOWEXEC db2bp.exe GC_PROD

    2297 2009-08-09-07.51.58.391900 -13.88 COMMIT_ACT java.exe GC_PROD

    3189 2009-08-09-07.51.58.390825 -13.88 COMMIT_ACT java.exe GC_PROD

    2307 2009-08-09-07.51.58.386922 -13.88 COMMIT_ACT java.exe GC_PROD

    1090 2009-08-09-07.51.58.391190 -13.88 COMMIT_ACT java.exe GC_PROD

    716 2009-08-09-07.51.58.406542 -13.90 COMMIT_ACT java.exe GC_PROD

    I believe these COMMIT_ACT at same TIMEstamp originate from DISK or NETWORK inconsistency ?? - not sure !

    Please hep me figure out the cause, so that I may be able to take ONLINE backup.

    Thanks
    DBFinder

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,368
    Quote Originally Posted by DBFinder
    DATA satying the same, what factors force DB2 to generate bigger image ??.
    Online backup doesn't include logs by default in v9.1 so that can't a contributing factor. DB2 doesn't backup temporary tablespaces so even if applications are using a lot of tempspace, it shouldn't affect the backup image size. DB2 will backup DMS tablespaces up to the HWM so if HWM increased so will the backup image. The HWM can go up even without adding more data (in some cases, reorg may cause HWM to go up).

  3. #3
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    Any way to reduce HWM. Since I had noticed some HWM are over 20G above the actual data size.

    If there is a way then I can reduce sige signifcantly. I have over 10 tablespaces with unreasonably high HWMs.

    Regards
    DBFinder

  4. #4
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,368
    Please take a look at the following technote:
    IBM - Lowering the High-Water Mark of a Tablespace

  5. #5
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    Thanks Bella

  6. #6
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    Two things.

    1. As Bell pointed out your backup images are worthless with out log files. Unless you store log files some place else and know which one belongs to which back up. So, if you keep doing online backup include logs.

    2. From personal experience with HWM, the only way to lower them is to rebuild table and its tablespaces. It might have been fixed in 9.5, I just haven't tried it yet.
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

  7. #7
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,368
    I've been able to lower the HWM in different versions of DB2. It really depends on what's holding it.

  8. #8
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    Quote Originally Posted by db2girl
    I've been able to lower the HWM in different versions of DB2. It really depends on what's holding it.
    Woman's touch
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

  9. #9
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,368
    hahaha

  10. #10
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    Quote Originally Posted by db2girl
    I've been able to lower the HWM in different versions of DB2. It really depends on what's holding it.
    Using db2dart ?? Offline ??

  11. #11
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,368
    The technote is a bit old... v9 manual states the following:

    "In general, db2dart requests are to be run when the database is offline. However, for the /DHWM and /LHWM actions, an offline database is not strictly required. The report could be generated without the database being offline, but the reliability of the results will vary depending on how much write/update activity has occurred recently (less activity implies more reliable results). "


    Starting from v9.1 fp4, you can use db2dart /dhwm and /lhwm while the db is online: IBM - IZ04647: DB2DART /DHWM AND /LHWM COULD BE RUN WHEN DB IS ACTIVE/INCONSISTENT (ONLINE) TO GENERATE REPORTS FROM V91FP4.

  12. #12
    Join Date
    Sep 2003
    Posts
    237
    I was wondering why you are not using the COMPRESS in the backup? It definitely should be able to 'squeeze in' the backup.
    mota

  13. #13
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    Quote Originally Posted by dbamota
    I was wondering why you are not using the COMPRESS in the backup? It definitely should be able to 'squeeze in' the backup.
    OUPS. that is a good point that we all have missed
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

Posting Permissions

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