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

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

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?

check is there any problem with backup disks.

you able terminate backup ?

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