Search found 45 matches

by PaulS
Tue Oct 14, 2014 4:26 am
Forum: General
Topic: Lost DB, holding xmeta repository
Replies: 2
Views: 1940

Lost DB, holding xmeta repository

Hi, We're a bit stuck - unfortunately our SAN has had lost four discs, and is unrecoverable. Our DB server is on this SAN, in particular the one in which the metadata schema xmeta is installed. We have no backups to restore to. What are our options in this senario? DS 8.5.0.3 (on redhat linux) Xmeta...
by PaulS
Thu Nov 28, 2013 8:15 am
Forum: General
Topic: Poor performance from hashed file following RedHat upgrade
Replies: 6
Views: 3488

Please let it be d).. maybe it'll loop back to when the sun always shined, Texan bars were just 10p and I'd never heard of Datastage!
by PaulS
Thu Nov 28, 2013 8:14 am
Forum: General
Topic: Poor performance from hashed file following RedHat upgrade
Replies: 6
Views: 3488

Please let it be d).. maybe it'll loop back to when the sun always shined, Texan bars were just 10p and I'd never heard of Datastage!
by PaulS
Thu Nov 28, 2013 6:17 am
Forum: General
Topic: Poor performance from hashed file following RedHat upgrade
Replies: 6
Views: 3488

I'm sure ArndW replied to this message - Admins, any idea where it's gone?!

Paul
by PaulS
Wed Nov 27, 2013 7:11 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Poor performance from hashed file following RedHat upgrade
Replies: 2
Views: 2569

Thanks ArndW - I've taken you advice and created as dynamic 500009.. CREATE.FILE FILENAME DYNAMIC MINIMUM.MODULUS 500009 32BIT The file is in the project directory, but the vpar uses the same area/discs on the san. I'm not going to try moving it just yet. I've also enabled write caching on each on t...
by PaulS
Wed Nov 27, 2013 4:19 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Poor performance from hashed file following RedHat upgrade
Replies: 2
Views: 2569

Poor performance from hashed file following RedHat upgrade

Hi, We have recently upgraded the o/s from redhat 5.5 to 5.9,.. one job in particular has dramatically slowed down. Lots of stages write to one hashed file, i'm getting poor performance from this hashed file.. It was being created as dynamic, so I've used the HFC to get the settings for a static fil...
by PaulS
Wed Nov 27, 2013 4:17 am
Forum: General
Topic: Poor performance from hashed file following RedHat upgrade
Replies: 6
Views: 3488

Poor performance from hashed file following RedHat upgrade

Hi, We have recently upgraded the o/s from redhat 5.5 to 5.9,.. one job in particular has dramatically slowed down. Lots of stages write to one hashed file, i'm getting poor performance from this hashed file.. It was being created as dynamic, so I've used the HFC to get the settings for a static fil...
by PaulS
Tue Jul 30, 2013 4:52 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ORA-03113: end-of-file on communication channel
Replies: 12
Views: 14566

Did you find a cause for this?
by PaulS
Tue Jul 30, 2013 4:46 am
Forum: General
Topic: Unscheduling problems
Replies: 2
Views: 1749

I guess not then... :D Just me! :lol:
by PaulS
Wed Jul 24, 2013 2:23 am
Forum: General
Topic: Unscheduling problems
Replies: 2
Views: 1749

Unscheduling problems

Hi,

Has anyone come across a problem/bug in the scheduler, whereby rescheduling jobs sometimes unschedules other jobs in different categories?

It seems completely random. Only happened a few times, but I've now become very wary of rescheduling.

Thanks
Paul
by PaulS
Tue Jun 18, 2013 7:36 am
Forum: General
Topic: Querying xmeta (in Oracle)
Replies: 2
Views: 2330

Perfect - works a treat! Thank you.

Paul
by PaulS
Tue Jun 18, 2013 5:24 am
Forum: General
Topic: Querying xmeta (in Oracle)
Replies: 2
Views: 2330

Querying xmeta (in Oracle)

Hi All, Anyone got a nice example of a time conversion from an xmeta repository residing in an oracle db please? The one I'm looking at is the lock table,... LOCKED_AT is a number(38,7 ),.. what's that? desc XMETA.XMETALOCKINFO Name Null Type REPOSITORY_ID NOT NULL VARCHAR2(64) LOCKED_AT NOT NULL NU...
by PaulS
Mon Jun 03, 2013 3:31 am
Forum: General
Topic: Searching in &COMO&
Replies: 1
Views: 1967

Searching in &COMO&

We have random aborts in our project, usually connecting to and inserting into oracle tables. I have switch server tracing on, but as this is random,.. I've had to wait for an error to occur before switching back off again. Unfortunately it has product a large number of files in &COMO&. How ...
by PaulS
Tue Apr 09, 2013 3:53 am
Forum: General
Topic: Resource_Tracker/Operations Console,.. in 8.5!
Replies: 1
Views: 1318

Resource_Tracker/Operations Console,.. in 8.5!

8.7s Operations Console does look very good and I believe it makes use of some of the o/s metrics produced via the resource_tracker,.. but while very useful with 8.7, how can 8.5 make use of the stats produced by this ticker? Is there an basic version of the Operations Console in 8.5? How else can I...