
April 30th, 2007, 12:40 AM
|
|
Registered User
|
|
Join Date: Mar 2007
Posts: 1
Time spent in forums: 1 h 3 m 21 sec
Reputation Power: 0
|
|
|
Db2 restore error
Hi guys,
Am trying to do a restore of a database but am getting this error " SQL2009C There is no enough memory available to run the utility". When backing up, i increased util_heap_sz and dbheap configuration parameters of the database before backing up.I have also increased the restbufsz configuration parameter but am still getting the same error.Am using v7.1 on a windows platform.The backup and restore are on different servers.The restore command is as follows: "restore database Dt from C:\backup into NewDb without prompting" and the backup command is "Backup database Dt to C:\backup with 2 buffers buffer 1024". The value for util_heap_sz is 5000 for the backup server and i am unable to set it for the restore server since there exists no other database on it.The backed up database will be the first.
Thnx.
|