DSXchange

Posted: **Wed Feb 23, 2011 9:08 am**

Is there need to bring down oracle xmeta instance before this file system back-up happen?

No. Just bring down all IBM IS components, then make file backup.

For Xmeta back-up file system backup is sufficient to restore or it has to be oracle export (export.dmp)

Just any of normal oracle database backup will be sufficient. It can be online backup or offline backup. Just do the backup while IBM IS components are shut down.

If so how can I write a single script to bring down everything and from where I can execute this script (which tier) ---sorry I am new to the scripting

Just write the script that will shutdown IBM IS components on all tiers using ssh connection (if Your OS is UNIX/Linux) from any of the tier nodes. Then script should do file backup and in the same time issue Your Oracle XMETA DB backup. Just please remember of correct shutdown sequence:
1. shutdown DS Engine
2. shutdown ASB
3. shutdown WebSphere
4. stop XMETA

If You need more help in writing such scripts I can be of service.

Regards
Tches

Posted: **Thu Dec 20, 2012 10:14 am**

how to stop the xmeta db after stopping all the services

Posted: **Thu Dec 20, 2012 10:46 am**

That depends on DB engine that You are using for XMETA

if XMETA is on db2 on linux then:

Code: Select all

su - db2inst1
db2 force application all
db2 deactivate database XMETA

Then You can do backup of XMETA using db2 backup command...

Posted: **Fri Dec 21, 2012 1:39 pm**

my xmeta repository is on oracle database server

Posted: **Fri Dec 21, 2012 1:51 pm**

That would have been useful to know at the outset.

Use the equivalent Oracle commands to quiesce the database. If you don't know the commands, consult your Oracle DBA.

Posted: **Thu Jan 17, 2013 7:13 am**

Is it compulsory to bring down the services of datastage before the DBA team shutdown the XMETA database for some upgradation plan on the Unix host.

Posted: **Thu Jan 17, 2013 1:57 pm**

DSXchange

Information server backup