XMETA database is down. shall I run the jobs?

mandyli · Post by **mandyli** » Thu Feb 18, 2016 8:03 pm

Hi

Our DBA said need to reboot Oracle Database server. which we have XMETA repository is placed.

I hope we can able to run the job via script only we can;t able to login Datastage Designer and Director.

Shall we need to stop the whole Datastage services if XMETA is down?

Thanks
Man

vmcburney · Post by **vmcburney** » Fri Feb 19, 2016 1:55 am

You cannot run any jobs until XMETA is back up.

ray.wurlod · Post by **ray.wurlod** » Sun Feb 21, 2016 3:18 pm

Theoretically you should stop engine, services and repository in that order, and start them in the reverse of that order.

Practically all tiers are reasonably robust, and will re-establish connections. In version 11.x even the client tier is able to re-establish connection.

BillB · Post by **BillB** » Mon Feb 22, 2016 6:51 pm

We run DataStage 8.7 on Windows Server 2008 with jobs scheduled via the Windows Task Scheduler.

From time to time, our XMETA database goes down.

Our experience is, that while the database is unavailable:
- We can't use Director, Designer or Administrator.
- Scheduled jobs start at their scheduled time, and run normally.

When the database is back, we have to shut down and restart as described by Ray in order to regain access to Director, Designer and Administrator.