DB2 v7.1.0.68 on AIX 4.3.3.0.

A db2 backup contains Database configuration (db cfg) parameters, but
not Database Manager (dbm cfg) parameters.
1) Is there a simple way to backup/restore dbm cfg parameters?
2) Is there an equivalent file to SQLDBCON that stores dbm cfg
parameters?

Thank you.

Bruce

On v7 it is db2systm in the db2 home directory.
Windows: \Program Files\SQLLIB\DB2

Bruce Pullen wrote:

>DB2 v7.1.0.68 on AIX 4.3.3.0.
>
>A db2 backup contains Database configuration (db cfg) parameters, but
>not Database Manager (dbm cfg) parameters.
>1) Is there a simple way to backup/restore dbm cfg parameters?
>2) Is there an equivalent file to SQLDBCON that stores dbm cfg
>parameters?
>
>Thank you.
>
>Bruce
>
>

--
Anton Versteeg
IBM Certified DB2 Specialist
IBM Netherlands

But, I do not think that you can restore this file and bring up the
system if the configuration was changed. I do think you would want to
update the dbm cfg again and stop and start the instance if you wish
to reenable them.

Has anyone tried restoring the file db2systm under $insthome/sqllib/?
Does it work?

Anton Versteeg <anton_versteeg@nnll.iibbmm.com> wrote in message news:<3F1E848E.2070701@nnll.iibbmm.com>...
> On v7 it is db2systm in the db2 home directory.
> Windows: \Program Files\SQLLIB\DB2
>
> Bruce Pullen wrote:
>
> >DB2 v7.1.0.68 on AIX 4.3.3.0.
> >
> >A db2 backup contains Database configuration (db cfg) parameters, but
> >not Database Manager (dbm cfg) parameters.
> >1) Is there a simple way to backup/restore dbm cfg parameters?
> >2) Is there an equivalent file to SQLDBCON that stores dbm cfg
> >parameters?
> >
> >Thank you.
> >
> >Bruce
> >
> >

Bruce,

You can take backup of DBM cfg by exporting to a file using DB2CFEXP
and can restore by importing using DB2CFIMP system commands.

Thanks,
Venkat.

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.

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.