Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2004
    Location
    Phoenix, AZ
    Posts
    42

    Unanswered: A hanging backup question

    All,

    Here's the problem -

    We are doing an online backup to disc and when the backup reaches a certain size, it hangs. Freeing up processes that either have been idol for a while or others holding locks cause the backup to complete. The backup reaches around 16.6 gig before it hangs. We have adjusted the AIX parameter-maxuproc hoping this would correct the issue. At first, we thought it was a locking issue, but, both IBM and the Application support say it is a memory issue and that the diaglog shows no errors at level 4.

    Has anyone experienced this type of behavior? What was done to correct it?

    Here are our specs:

    Database - db2 udb v. 7.2 (or 7.1 fp10)
    OS - AIX v. 5.1
    Application - Lawson 8.0.2/3

    Thanks for anything info.

    R

  2. #2
    Join Date
    Sep 2002
    Posts
    456

    Re: A hanging backup question

    What type of tablespaces you have i.e. SMS or DMS and are there any columns with type LOB on user tables?

    dollar


    Originally posted by rvsc36
    All,

    Here's the problem -

    We are doing an online backup to disc and when the backup reaches a certain size, it hangs. Freeing up processes that either have been idol for a while or others holding locks cause the backup to complete. The backup reaches around 16.6 gig before it hangs. We have adjusted the AIX parameter-maxuproc hoping this would correct the issue. At first, we thought it was a locking issue, but, both IBM and the Application support say it is a memory issue and that the diaglog shows no errors at level 4.

    Has anyone experienced this type of behavior? What was done to correct it?

    Here are our specs:

    Database - db2 udb v. 7.2 (or 7.1 fp10)
    OS - AIX v. 5.1
    Application - Lawson 8.0.2/3

    Thanks for anything info.

    R

  3. #3
    Join Date
    Jan 2004
    Location
    Phoenix, AZ
    Posts
    42

    Re: A hanging backup question

    Originally posted by dollar489
    What type of tablespaces you have i.e. SMS or DMS and are there any columns with type LOB on user tables?

    dollar
    We are using DMS tablespaces and we are not using LOB's as any of our datatypes.

    R

  4. #4
    Join Date
    Mar 2003
    Posts
    343
    Does the application use exception tables? Because those have CLOBS at the end - but I'm not sure that that would make the backup hang either.

    I think the locks may be the issue - wht kind of locks do the connections hold?

  5. #5
    Join Date
    Jan 2004
    Location
    Tallahassee, FL, USA
    Posts
    96
    check is there any problem with backup disks.

    you able terminate backup ?

  6. #6
    Join Date
    Dec 2002
    Location
    cincinnati
    Posts
    18

    backup script

    Since IBM is also involved, I think you have taken care of two issues.

    1)Wherever you are placing the backup the filesystem islarge file enabled.

    2) I think you might have taken care of ulimit -a to be unlimited.
    (note : I think, the file /etc/security/limits should also be changed)

    I will give one more idea, if you want you may use, if we follow this you will be able to compress the backup while it gets backed up, that way if still the failure occurs it may fail at 32 GB (appx) instead of 16GB.

    mkfifo DMDB001.pipe1
    cat DMDB001.pipe1 | compress > DMDB001.001.Z &
    backup database DMDB001 online to DMDB001.pipe1 with 8 buffers buffer 4096
    parallelism 4
    rm DMDB001.pipe1

    thanks
    Jagadish
    jagadish dara

Posting Permissions

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