Memory hogging after restore with a warning

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Grisha Golberg
    #1

    Memory hogging after restore with a warning

    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.
    Tags: None
    • Blair Adamache
      #2
      Re: Memory hogging after restore with a warning

      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/infocenter/db2help/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:
      [color=blue]
      > 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.[/color]

        Comment

        Previous template Next
        Working...