check_backup script required

[wishkid via DBMonster.com]

hey guys
i would be really appriciate if any of u guys can share a script with me
which check each database wether they take backups.since we dont need to
check the intigrity of the backps,script dont have to be tightly scripted.i
would realy appricite for any kinds help on this

[Pierre Saint-Jacques]

There's a simple command that you can use:

-LIST HISTORY--+-------------------+-------------------------->

+-BACKUP------------+
+-ROLLFORWARD-------+
+-DROPPED TABLE-----+
+-LOAD--------------+
+-CREATE TABLESPACE-+
+-ALTER TABLESPACE--+
+-RENAME TABLESPACE-+
+-REORG-------------+
'-ARCHIVE LOG-------'
--+-ALL--------------------------------+-----------------------> +-SINCE--timestamp-------------------+
'-CONTAINING--+-schema.object_name-+-'
'-object_name--------'
--FOR--+----------+--database-alias--------------------------->< +-DATABASE-+
'-DB-------'

--
The BACKUP and SINCE are what interests you.

You could create this command as a task in the task center and have it
scheduled to run whenever you'd feel like.
HTH, Pierre.
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"wishkid via DBMonster.com" <fo***@DBMonster.com> a écrit dans le message de
news: 54***********@DBMonster.com... hey guys
i would be really appriciate if any of u guys can share a script with me
which check each database wether they take backups.since we dont need to
check the intigrity of the backps,script dont have to be tightly
scripted.i
would realy appricite for any kinds help on this

[wishkid via DBMonster.com]

Pierre Saint-Jacques wrote:

There's a simple command that you can use:

-LIST HISTORY--+-------------------+-------------------------->

+-BACKUP------------+
+-ROLLFORWARD-------+
+-DROPPED TABLE-----+
+-LOAD--------------+
+-CREATE TABLESPACE-+
+-ALTER TABLESPACE--+
+-RENAME TABLESPACE-+
+-REORG-------------+
'-ARCHIVE LOG-------'

--+-ALL--------------------------------+----------------------->

+-SINCE--timestamp-------------------+
'-CONTAINING--+-schema.object_name-+-'
'-object_name--------'

--FOR--+----------+--database-alias---------------------------><

+-DATABASE-+
'-DB-------'

hey guys
i would be really appriciate if any of u guys can share a script with me
which check each database wether they take backups.since we dont need to
check the intigrity of the backps,script dont have to be tightly
scripted.i
would realy appricite for any kinds help on this

hey peierr
thankyou for the quick responce but i will not be able to run this command
against a mass list of servers i got to have a script to run it.
--
Message posted via DBMonster.com
http://www.dbmonster.com/Uwe/Forums....m-db2/200509/1

[Shyam Peri]

Not sure if you will be able to configure or not, the easy way to
manage with the "checking tasks" is to get notified.
DB2 solves the purpose by haivng a task center!

[Norbert Munkel]

Hi,

wishkid via DBMonster.com wrote:

Pierre Saint-Jacques wrote:

There's a simple command that you can use:

-LIST HISTORY--+-------------------+-------------------------->

hey peierr
thankyou for the quick responce but i will not be able to run this command
against a mass list of servers i got to have a script to run it.

Well, possible, isn't it? Could run on a single machine, connecting to
the servers subsequently.

My backup-scripts are reporting location, size, timestamp, backup-host
and other stuff to a central database or stores it locally if the
central catalog is not available so I can just do a simple select
against one database to get the full information, but that's just one
approach.

If you don't want to put much effort into this you would probably better
of with task center..

regards,

Norbert

[wishkid via DBMonster.com]

Norbert Munkel wrote:

Hi,

There's a simple command that you can use:

>-LIST HISTORY--+-------------------+-------------------------->

hey peierr
thankyou for the quick responce but i will not be able to run this command
against a mass list of servers i got to have a script to run it.

Well, possible, isn't it? Could run on a single machine, connecting to
the servers subsequently.

My backup-scripts are reporting location, size, timestamp, backup-host
and other stuff to a central database or stores it locally if the
central catalog is not available so I can just do a simple select
against one database to get the full information, but that's just one
approach.

If you don't want to put much effort into this you would probably better
of with task center..

regards,

Norbert

hey guys
thats what i was thinking to to run the script from one mechine against other
boxers,norbet would u mind posting a sample script for me
--
Message posted via DBMonster.com
http://www.dbmonster.com/Uwe/Forums....m-db2/200509/1

[Norbert Munkel]

Hi,

wishkid via DBMonster.com schrieb:

hey guys
thats what i was thinking to to run the script from one mechine against other
boxers,norbet would u mind posting a sample script for me

Sorry, I am not allowed to post my scripts here. I finally would not
have something ready. This is monitored by nagios at my place and you
would not want to have the perl-plugin I wrote.

You would either have to code that yourself or rely on task center.
Would not be _my_ choice but seems to be the easiest approach for you.

I can't tell you what fits your environment best as I don't know
anything about it. My scripts are designed to run in my special unix
environment.

sorry,

Norbert

[Pierre Saint-Jacques]

WishKid, if you look at the various possibilities to install the scheduling
facility, you'll find that you can set your admin servers (DAS) on each
server to point to a central TOOLSDB residing on a single server.
This provides you a single point of control to run tasks scheduled at
different times and/or different servers.
Look at, amongst other things, in admin cfg:
Scheduler Mode (SCHED_ENABLE) = ON
SMTP Server (SMTP_SERVER) = localhost
Tools Catalog Database (TOOLSCAT_DB) = TOOLSDB
Tools Catalog Database Instance (TOOLSCAT_INST) = SES
Tools Catalog Database Schema (TOOLSCAT_SCHEMA) = TOOLSDB

On that server, you can then specify the backup task for each server. Also,
the journal on that server will display for each server you select which
task ran when and how.

HTH, pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"wishkid via DBMonster.com" <fo***@DBMonster.com> a écrit dans le message de
news: 54***********@DBMonster.com...

Norbert Munkel wrote:

Hi,

There's a simple command that you can use:

>>-LIST HISTORY--+-------------------+-------------------------->

hey peierr
thankyou for the quick responce but i will not be able to run this
command
against a mass list of servers i got to have a script to run it.

Well, possible, isn't it? Could run on a single machine, connecting to
the servers subsequently.

My backup-scripts are reporting location, size, timestamp, backup-host
and other stuff to a central database or stores it locally if the
central catalog is not available so I can just do a simple select
against one database to get the full information, but that's just one
approach.

If you don't want to put much effort into this you would probably better
of with task center..

regards,

Norbert

hey guys
thats what i was thinking to to run the script from one mechine against
other
boxers,norbet would u mind posting a sample script for me
--
Message posted via DBMonster.com
http://www.dbmonster.com/Uwe/Forums....m-db2/200509/1