ADSM-L

Re: inclexcl list for DB2 backup

2000-07-25 05:54:11
Subject: Re: inclexcl list for DB2 backup
From: Gyula Bereczky <bx AT MAIL.DATATRANS DOT HU>
Date: Tue, 25 Jul 2000 11:54:11 +0200
On Tue, Jul 25, 2000 at 12:43:46PM +0800, Eric Tang wrote:
> I have config db2 backup by ADSM. In order to exclude db2 files from
> filesystem incremental backup, how can I get the list of directories/files
> to be coded in the exclude list.
Eric,
you did not mention the operating system etc. things we always like to know..
Neway. On *ix systems the database default location in the db2 instance's
home directory, under instnce name. So if the instance is the default
db2inst1, then it would be at /home/db2inst1/db2inst1. _But_ this is the
default. The admin always can create the db on another path..
On non *ix systems generaly you put the db on a separate partiton.
You should search for a directory like SQLDBDIR.
For the logs it's easier. You can query the path by
db2 list db cfg for <yourdb> | grep log

Still the best to contact your DBA.
--
                        bx
                        bx

"Using vim will surely improve ones computer skills."
<Prev in Thread] Current Thread [Next in Thread>