What is the meaning of following errlog message?

parag.s.27 · Post by **parag.s.27** » Fri Mar 13, 2009 5:23 am

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.

chulett · Post by **chulett** » Fri Mar 13, 2009 8:13 am

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'.

parag.s.27 · Post by **parag.s.27** » Fri Mar 13, 2009 9:54 am

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.

chulett · Post by **chulett** » Fri Mar 13, 2009 10:12 am

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.

priyadarshikunal · Post by **priyadarshikunal** » Fri Mar 13, 2009 11:20 am

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.

chulett · Post by **chulett** » Fri Mar 13, 2009 12:38 pm

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.

ray.wurlod · Post by **ray.wurlod** » Fri Mar 13, 2009 1:34 pm

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

parag.s.27 · Post by **parag.s.27** » Mon Mar 16, 2009 7:48 am

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.

ray.wurlod · Post by **ray.wurlod** » Mon Mar 16, 2009 3:13 pm

You learn about APT_PERFORMANCE_DATA in IBM training - in the advanced class if I recall correctly.

ray.wurlod · Post by **ray.wurlod** » Mon Mar 16, 2009 3:14 pm

You learn about APT_PERFORMANCE_DATA in IBM training - in the advanced class if I recall correctly.

priyadarshikunal · Post by **priyadarshikunal** » Wed Mar 18, 2009 7:29 am

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.