Re: dbm cfg backup/restore See below.
Bruce Pullen wrote:
> Thanks Venkat. That's just what I was after.
> Do you know of a similar system command for db cfg parameters (i.e. to
> be used if I need to clone these settings quickly on another machine
> in a disaster recovery situation)?
> I know the SQLDBCON file is included in the DB2 BACKUP image but it
> appears that if restoring to a new database on a new machine, the DB
> CFG used during the restore will contain all the default values.
This last point is not quite accurate. In the restore, there's a
batabase seed unique identifier. DB2 uses this to determine if
restoring new, new with same name or replace existing. In your case,
all restores would be new, I assume, therefore the SQLDBCON win the
image will be used with whatever parms are in it, unless they don't make
sense (ie: logpath can't be identified).
Also, as you create the instance, DB2 creates a file DB2SYSTM in the
instance path (X:\SQLLIB\instname\db2systm) that is your DBM CFG.
HTH, Pierre. |