DSXchange

A short text to describe your forum
http://dsxchange.com./

What is the meaning of following errlog message?

http://dsxchange.com./viewtopic.php?f=8&t=125946

Page 1 of 1

What is the meaning of following errlog message?

Posted: Fri Mar 13, 2009 5:23 am
by parag.s.27
one of our job is taking long time in SIT compared to development env. i.e., 4 hrs in SIT and 2 mins in development. While doing analysis we used an environment variable APT_PERFORMANCE_DATA. After running the job errlog got generated in $DSHOME. Got the following message in errlog:
Fri Mar 13 08:30:17 0 iisGISit Program "DSD.RUN": Line 671, Message[040037]
Fri Mar 13 08:30:18 0 iisGISit Illegal flavor keyword, IDEAL flavor DataStage assumed
Fri Mar 13 08:32:07 0 iisGISit Program "DSD.WriteLog": Line 305, Message[050009]
Fri Mar 13 08:32:08 0 iisGISit Program "DSD.WriteLog": Line 305, Message[050009]
Fri Mar 13 08:32:08 0 iisGISit Program "DSD.WriteLog": Line 305, Message[050009]
Fri Mar 13 08:40:19 0 iisGISit Illegal flavor keyword, IDEAL flavor DataStage assumed
Fri Mar 13 08:40:22 0 iisGISit Illegal flavor keyword, IDEAL flavor DataStage assumed
Fri Mar 13 08:47:46 0 iisGISit Illegal flavor keyword, IDEAL flavor DataStage assumed
Fri Mar 13 08:47:46 0 iisGISit Program "DSD.RUN": Line 671, Message[040037]
Fri Mar 13 08:47:47 0 iisGISit Illegal flavor keyword, IDEAL flavor DataStage assumed
Fri Mar 13 08:52:41 0 iisGISit Program "DSD.RUN": Line 671, Message[040037]
Fri Mar 13 08:52:51 0 iisGISit Program "DSD.RUN": Line 671, Message[040037]
Fri Mar 13 08:53:05 0 iisGISit Program "DSD.RUN": Line 671, Message[040037]
Fri Mar 13 08:53:14 0 iisGISit Program "DSD.WriteLog": Line 305, Message[050009]
Fri Mar 13 08:55:35 0 iisGISit Illegal flavor keyword, IDEAL flavor DataStage assumed
Fri Mar 13 08:57:48 0 iisGISit Illegal flavor keyword, IDEAL flavor DataStage assumed
Fri Mar 13 08:57:49 0 iisGISit Program "DSD.RUN": Line 671, Message[040037]
Fri Mar 13 08:57:50 0 iisGISit Illegal flavor keyword, IDEAL flavor DataStage assumed
Fri Mar 13 08:58:47 0 iisGISit Program "DSD.RUN": Line 671, Message[040037]
Fri Mar 13 08:58:48 0 iisGISit Program "DSD.RUN": Line 671, Message[040037]
Fri Mar 13 08:58:48 0 iisGISit Illegal flavor keyword, IDEAL flavor DataStage assumed
Fri Mar 13 08:58:48 0 iisGISit Program "DSD.RUN": Line 671, Message[040037]
Fri Mar 13 08:58:49 0 iisGISit Illegal flavor keyword, IDEAL flavor DataStage assumed
Fri Mar 13 09:08:13 0 iisGISit Program "DSD.WriteLog": Line 305, Message[050009]
Fri Mar 13 09:08:50 0 iisGISit Illegal flavor keyword, IDEAL flavor DataStage assumed
Fri Mar 13 09:08:53 0 iisGISit Illegal flavor keyword, IDEAL flavor DataStage assumed
Fri Mar 13 09:10:02 0 iisLIDev Program "DSD.RUN": Line 671, Message[040037]
Fri Mar 13 09:10:17 0 iisLIDev Illegal flavor keyword, IDEAL flavor DataStage assumed
Fri Mar 13 09:20:32 0 iisLIDev Illegal flavor keyword, IDEAL flavor DataStage assumed
Fri Mar 13 09:20:36 0 iisGISit Program "DSD.RUN": Line 671, Message[040037]
Fri Mar 13 09:20:38 0 iisGISit Illegal flavor keyword, IDEAL flavor DataStage assumed
Fri Mar 13 09:20:38 0 iisGISit Program "DSD.RUN": Line 671, Message[040037]
Fri Mar 13 09:20:39 0 iisGISit Program "DSD.RUN": Line 671, Message[040037]
Fri Mar 13 09:20:41 0 iisGISit Illegal flavor keyword, IDEAL flavor DataStage assumed
Fri Mar 13 09:29:07 0 iisGISit Program "DSD.WriteLog": Line 305, Message[050009]
Fri Mar 13 09:30:42 0 iisGISit Illegal flavor keyword, IDEAL flavor DataStage assumed
Fri Mar 13 09:30:43 0 iisGISit Program "DSD.RUN": Line 671, Message[040037]
Fri Mar 13 09:30:44 0 iisGISit Illegal flavor keyword, IDEAL flavor DataStage assumed
Fri Mar 13 09:48:47 0 iisGISit Program "DSD.RUN": Line 671, Message[040037]
Fri Mar 13 09:48:47 0 iisGISit Illegal flavor keyword, IDEAL flavor DataStage assumed
Fri Mar 13 09:48:47 0 iisGISit Program "DSD.RUN": Line 671, Message[040037]
Fri Mar 13 09:48:48 0 iisGISit Illegal flavor keyword, IDEAL flavor DataStage assumed
Fri Mar 13 09:49:24 0 iisLIDev Illegal flavor keyword, IDEAL flavor DataStage assumed
Fri Mar 13 09:51:06 0 iisLIDev Program "DSD.RUN": Line 671, Message[040037]
Fri Mar 13 09:51:18 0 iisLIDev Illegal flavor keyword, IDEAL flavor DataStage assumed
Fri Mar 13 09:52:52 0 iisLIDev Illegal flavor keyword, IDEAL flavor DataStage assumed
Fri Mar 13 09:58:49 0 iisGISit Illegal flavor keyword, IDEAL flavor DataStage assumed
Fri Mar 13 10:08:26 0 iisLIDev Illegal flavor keyword, IDEAL flavor DataStage assumed
Fri Mar 13 10:08:28 0 iisLIDev The variable "APT_PERFORMANCE_DATA" is not in the environment.
Fri Mar 13 10:08:51 0 iisGISit Illegal flavor keyword, IDEAL flavor DataStage assumed
Fri Mar 13 10:08:53 0 iisGISit Illegal flavor keyword, IDEAL flavor DataStage assumed
Fri Mar 13 10:10:30 0 iisLIDev Illegal flavor keyword, IDEAL flavor DataStage assumed
Fri Mar 13 10:10:31 0 iisLIDev The variable "APT_PERFORMANCE_DATA" is not in the environment.
Fri Mar 13 10:11:03 0 iisLIDev Program "DSD.RUN": Line 671, Message[040037]
Fri Mar 13 10:11:17 0 iisLIDev Illegal flavor keyword, IDEAL flavor DataStage assumed
Fri Mar 13 10:11:35 0 iisGISit Program "DSD.RUN": Line 671, Message[040037]
Fri Mar 13 10:12:59 0 iisLIDev Illegal flavor keyword, IDEAL flavor DataStage assumed
Fri Mar 13 10:13:00 0 iisLIDev The variable "APT_PERFORMANCE_DATA" is not in the environment.
Fri Mar 13 10:13:52 0 iisLIDev Illegal flavor keyword, IDEAL flavor DataStage assumed
Fri Mar 13 10:13:53 0 iisLIDev The variable "APT_PERFORMANCE_DATA" is not in the environment.
Fri Mar 13 10:25:52 0 iisGISit Program "DSD.RUN": Line 671, Message[040037]
Fri Mar 13 10:25:52 0 iisGISit Program "DSD.RUN": Line 671, Message[040037]
Fri Mar 13 10:25:53 0 iisGISit Illegal flavor keyword, IDEAL flavor DataStage assumed
Fri Mar 13 10:25:53 0 iisGISit Program "DSD.RUN": Line 671, Message[040037]
Fri Mar 13 10:25:54 0 iisGISit Illegal flavor keyword, IDEAL flavor DataStage assumed
Fri Mar 13 10:30:49 0 iisGISit Program "DSD.WriteLog": Line 305, Message[050009]
Fri Mar 13 10:30:55 0 iisLIDev Illegal flavor keyword, IDEAL flavor DataStage assumed
Fri Mar 13 10:35:55 0 iisGISit Illegal flavor keyword, IDEAL flavor DataStage assumed
Fri Mar 13 10:35:57 0 iisGISit Program "DSD.RUN": Line 671, Message[040037]
Fri Mar 13 10:35:58 0 iisGISit Illegal flavor keyword, IDEAL flavor DataStage assumed
Fri Mar 13 10:37:00 0 iisLIDev Program "DSD.RUN": Line 671, Message[040037]
Fri Mar 13 10:37:13 0 iisLIDev Illegal flavor keyword, IDEAL flavor DataStage assumed
Fri Mar 13 10:41:42 0 iisLIDev Illegal flavor keyword, IDEAL flavor DataStage assumed
Fri Mar 13 07:46:22 0 iisGISit Program "DSD.WriteLog": Line 305, Message[050009]
Fri Mar 13 07:51:49 0 iisGISit Illegal flavor keyword, IDEAL flavor DataStage assumed
Fri Mar 13 07:51:51 0 iisGISit Program "DSD.RUN": Line 671, Message[040037]
Fri Mar 13 07:51:52 0 iisGISit Illegal flavor keyword, IDEAL flavor DataStage assumed
Fri Mar 13 07:55:58 0 iisGISit Illegal flavor keyword, IDEAL flavor DataStage assumed
Fri Mar 13 07:55:59 0 iisGISit Program "DSD.RUN": Line 671, Message[040037]
Fri Mar 13 07:55:59 0 iisGISit Program "DSD.RUN": Line 671, Message[040037]
Fri Mar 13 07:55:59 0 iisGISit Illegal flavor keyword, IDEAL flavor DataStage assumed
Fri Mar 13 07:56:00 0 iisGISit Program "DSD.RUN": Line 671, Message[040037]
Fri Mar 13 07:56:01 0 iisGISit Program "DSD.RUN": Line 671, Message[040037]
Fri Mar 13 07:56:07 0 iisGISit Illegal flavor keyword, IDEAL flavor DataStage assumed
Fri Mar 13 08:01:18 0 iisGISit Program "DSD.RUN": Line 671, Message[040037]
Fri Mar 13 08:01:28 0 iisGISit Program "DSD.WriteLog": Line 305, Message[050009]
Fri Mar 13 08:01:28 0 iisGISit Program "DSD.WriteLog": Line 305, Message[050009]
Fri Mar 13 08:01:28 0 iisGISit Program "DSD.WriteLog": Line 305, Message[050009]
Fri Mar 13 08:05:09 0 iisGISit Illegal flavor keyword, IDEAL flavor DataStage assumed
Fri Mar 13 08:05:10 0 iisGISit Program "DSD.WriteLog": Line 305, Message[050009]
Fri Mar 13 08:05:10 0 iisGISit Illegal flavor keyword, IDEAL flavor DataStage assumed
Fri Mar 13 08:06:01 0 iisGISit Illegal flavor keyword, IDEAL flavor DataStage assumed
Fri Mar 13 08:06:09 0 iisGISit Program "DSD.WriteLog": Line 305, Message[050009]
Fri Mar 13 08:06:09 0 iisGISit Program "DSD.WriteLog": Line 305, Message[050009]
Fri Mar 13 08:15:11 0 iisGISit Illegal flavor keyword, IDEAL flavor DataStage assumed
Fri Mar 13 08:15:14 0 iisGISit Illegal flavor keyword, IDEAL flavor DataStage assumed
Fri Mar 13 08:16:02 0 iisGISit Illegal flavor keyword, IDEAL flavor DataStage assumed
Fri Mar 13 08:16:03 0 iisGISit Program "DSD.RUN": Line 671, Message[040037]
Fri Mar 13 08:16:04 0 iisGISit Illegal flavor keyword, IDEAL flavor DataStage assumed
Fri Mar 13 08:30:17 0 iisGISit Illegal flavor keyword, IDEAL flavor DataStage assumed


Can someone explain me what the log means.

Posted: Fri Mar 13, 2009 8:13 am
by chulett
Hmmm... the only mention of either APT_PARAMETER_DATA or Illegal flavor keyword in the bajillions of posts here is in this one. Googling for the latter phrase gets me one hit in the 8.0.1 Release Notes where they post the 'workaround' as 'Contact IBM customer support'.

Posted: Fri Mar 13, 2009 9:54 am
by parag.s.27
chulett wrote:Hmmm... the only mention of either APT_PARAMETER_DATA or Illegal flavor keyword in the bajillions of posts here is in this one. Googling for the latter phrase gets me one hit in the 8.0.1 Release Notes where they post the 'workaround' as 'Contact IBM customer support'.

Hi Chulett,

Thanks a lot for your quick help. Actually we've already raised a PMR with IBM 2 weeks back but still there is no respond to the same. We needed to monitor the performance because many of our IIS jobs are getting killed abruptly. There is no fatal or warning shown in the job log. But the job status window in Director shows that the IIS job is aborted.

Posted: Fri Mar 13, 2009 10:12 am
by chulett
Sorry I really couldn't help more, but it seems that IBM is still your best bet. Out of curiousity, where did you find APT_PARAMETER_DATA? I can find no mention of it anywhere in my docs or via Google.

Posted: Fri Mar 13, 2009 11:20 am
by priyadarshikunal
chulett wrote:Sorry I really couldn't help more, but it seems that IBM is still your best bet. Out of curiousity, where did you find APT_PARAMETER_DATA? I can find no mention of it anywhere in my docs or via Google.
I think its APT_PERFORMANCE_DATA which is mentioned in the log.

Posted: Fri Mar 13, 2009 12:38 pm
by chulett
Right... it's in the log because they "used it" but I'm wondering where they found out about it to use it as it doesn't seem to be documented anywhere that I could find, unless it is new for 8.

Posted: Fri Mar 13, 2009 1:34 pm
by ray.wurlod
In the Administrator client, with exclusive access to the project and logged in as an administrator, execute the following command:

Code: Select all

UPDATE.ACCOUNT IDEAL

Posted: Mon Mar 16, 2009 7:48 am
by parag.s.27
chulett wrote:Right... it's in the log because they "used it" but I'm wondering where they found out about it to use it as it doesn't seem to be documented anywhere that I could find, unless it is new for 8.
This APT_PERFORMANCE_DATA is used to dump the details about performance of any job. It can give the performance details about each stage in the job and it can also tell about the bottlenecks in the jobs.

Posted: Mon Mar 16, 2009 3:13 pm
by ray.wurlod
You learn about APT_PERFORMANCE_DATA in IBM training - in the advanced class if I recall correctly.

Posted: Mon Mar 16, 2009 3:14 pm
by ray.wurlod
You learn about APT_PERFORMANCE_DATA in IBM training - in the advanced class if I recall correctly.

Posted: Wed Mar 18, 2009 7:29 am
by priyadarshikunal
ray.wurlod wrote:You learn about APT_PERFORMANCE_DATA in IBM training - in the advanced class if I recall correctly.
Well i don't know if its there in advance classes or not but its there in version 8 Parallel Job Advanced Developer Guide.

APT_PERFORMANCE_DATA
Set this variable to turn on performance data output generation. APT_PERFORMANCE_DATA can be either set with no value, or be set to a valid path which will be used as the default location for performance data output.

Possibly its in their curriculam.
All times are UTC-06:00
Page 1 of 1

Powered by phpBB® Forum Software © phpBB Limited