Very slow job stat display in director / crashing

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
foryou
Participant
Posts: 12
Joined: Thu Jun 23, 2005 1:47 am

Very slow job stat display in director / crashing

Post by foryou »

We are experiencing very slow job stat display in director or sometime its just crashing or some time just not able to connect to Datastate.

On investigation, found out that XMETA is appearing in Alarm state in HEALTH CHECK - DB2COY With

LogFileSystem Utilization to 100%

Database automatic storage utilization to 100% .

How can free up the Log file space and database storage as per one of the recommendation to get rid off of these issues.

thanks
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Which exact 8.x version are you running? 8.1 defaults to storing the job logs in the XMETA database from what I recall, but there's a "logging" ini parameter you can change to switch it back to the "Universe" repository. Don't recall the exact name, though. That should help.

For the "storage utilization" part of the problem, seems to me the recommendation would be to allocate more space to it.
-craig

"You can never have too many knives" -- Logan Nine Fingers
foryou
Participant
Posts: 12
Joined: Thu Jun 23, 2005 1:47 am

Post by foryou »

we are using IIS 8.1..
asorrell
Posts: 1707
Joined: Fri Apr 04, 2003 2:00 pm
Location: Colleyville, Texas

Post by asorrell »

Andy Sorrell
Certified DataStage Consultant
IBM Analytics Champion 2009 - 2020
Post Reply