Information server backup

[tcheslav]

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

[mikva2012]

how to stop the xmeta db after stopping all the services

[tcheslav]

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...

[mikva2012]

my xmeta repository is on oracle database server

[ray.wurlod]

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.

[mikva2012]

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.

[ray.wurlod]

Yes.