Hi all,

I am trying to move a database from one machine to another.
I backed up in offline mode, then I do a restore (without
rolling forward), which
finishes successfully but with warning 2529 (what's that?)

After that db2syscs hogs pretty much all available memory
on the machine whenever I attempt to connect to the database,
with no end in sight.

I am using DB2 8.1 on Win2K.

Thanks.

If you move to Fixpak 2, there is a DB2 enhancement called "throttle
utilities" - you can read about it by searching on "throttle" here:
http://publib.boulder.ibm.com/infoce...help/index.jsp

This will keep backup from using all of the resources.

You cna read about SQL2529 here:

C:\tmp>db2 ? sql2529 |more


SQL2529W Warning! Restoring to an existing database that is
different from the backup image database, and the alias
name "<dbase>" of the existing database does not match
the alias name "<dbase>" of the backup image, and the
database name "<dbname>" of the existing database does
not match the database name "<dbname>" of the backup
image. The target database will be overwritten by the
backup version. The Roll-forward recovery logs
associated with the target database will be deleted.

Explanation:

The database aliases of the target and database image are not the
same, the database names are not the same, and the database seeds
are not the same, indicating these are different databases. The
current database will be overwritten by the backup version. The
Roll-forward recovery logs associated with the target database
will be deleted. The current configuration file will be
overwritten with the backup version.

User Response:

Return to the utility with the callerac parameter indicating
processing to continue or end.

Grisha Golberg wrote:

> Hi all,
>
> I am trying to move a database from one machine to another.
> I backed up in offline mode, then I do a restore (without
> rolling forward), which
> finishes successfully but with warning 2529 (what's that?)
>
> After that db2syscs hogs pretty much all available memory
> on the machine whenever I attempt to connect to the database,
> with no end in sight.
>
> I am using DB2 8.1 on Win2K.
>
> Thanks.