By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,287 Members | 1,284 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,287 IT Pros & Developers. It's quick & easy.

check_backup script required

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
7 Replies


P: n/a
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


Nov 12 '05 #2

P: n/a
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
Nov 12 '05 #3

P: n/a
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!

Nov 12 '05 #4

P: n/a
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

Nov 12 '05 #5

P: n/a
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
Nov 12 '05 #6

P: n/a
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
Nov 12 '05 #7

P: n/a
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


Nov 12 '05 #8

This discussion thread is closed

Replies have been disabled for this discussion.