Messages in Designer / Director

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
thurmy34
Premium Member
Premium Member
Posts: 198
Joined: Fri Mar 31, 2006 8:27 am
Location: Paris

Messages in Designer / Director

Post by thurmy34 »

Hi Gurus
Since 2 P.M today we receive when using the datastage interface ( Designer / Director) a tons of randoms messages like this:

Code: Select all

failed to open RT_LOGXXX followed by Unable to return an attached job or Cannot open executable job file RT_CONFIGXXX followed by Unable to return an attached job.
It's on all our project and on "every" jobs even the compilation failed randomly.

The job aborts then runs fine .
I don't known where to start my reseachs.I'll open a case tomorrow morning.

Thank you
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

If your compilations also fail randomly with this message then there are more serious problems than someone deleting the odd file from the OS level or changing permissions.

If your top priority is to get going again rather than determine what the cause might have been, I would do a full project export and then see if I can import that file into a temporary project and compile the jobs. If that is successful then you may either re-import (and overwrite) back into the original project or drop and re-create the original project from the backup.

I just looked at your post and see that your problem is on all projects... That's not good at all - you might have to research the root cause. If you look at permissions on the RT_LOGnnn files are they all the same? Do you know what might have changed on the system between the time that things worked and when they started going pear-shaped?
thurmy34
Premium Member
Premium Member
Posts: 198
Joined: Fri Mar 31, 2006 8:27 am
Location: Paris

Post by thurmy34 »

Hi all

With the help of the Ibm support we find out that all the entry of the T30Files table was use.
After a reboot the problem is gone.
Thx
Hope This Helps
Regards
PaulVL
Premium Member
Premium Member
Posts: 1315
Joined: Fri Dec 17, 2010 4:36 pm

Post by PaulVL »

Go out to your project directory and look to see if someone deleted all files from it. (not directories).

Something like a bad "rm *" command.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

There were no deleted files, their T30FILES setting in dsenv was too low. Once that number is exhausted, no more hashed files can be opened and that includes all of those that make up the repository. While the reboot made the problem 'go away', you may want to consider raising the value and then doing a uvregen.
-craig

"You can never have too many knives" -- Logan Nine Fingers
thurmy34
Premium Member
Premium Member
Posts: 198
Joined: Fri Mar 31, 2006 8:27 am
Location: Paris

Post by thurmy34 »

Hi Guru
For almost on year now i'm monitoring the use of T30FILES with the smat command.
I'm wondering why the value never goes down even with a restart of datastage.
The only way to really reduce it it's to reboot the server.

Can you tell me if i'm missing anything.
Here an example of my log :

Code: Select all

2015-08-18 11:10:23;373
2015-08-18 12:00:05;366
2015-08-18 22:00:04;329
2015-08-19 12:00:17;393
2015-08-19 22:00:11;382
2015-08-20 12:00:13;381
2015-08-20 22:00:13;332
2015-08-21 12:01:06;383
2015-08-21 22:00:11;291
2015-08-22 12:00:08;291
2015-08-22 22:00:04;282
2015-08-23 22:00:09;282
-- Reboot
2015-08-24 08:56:35;25
Hope This Helps
Regards
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Read your log again. It DOES go down. You had a high of 393 on August 19, but only 282 on August 23.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply