SORT produces a INFO message but no rows passed through
Posted: Fri Jul 11, 2014 8:53 am
I have Server Shared Container that perform a sort in it.
The Sort is producing a "INFO" message for every row processed that provides no information:
330876905 INFO Fri Jul 11 03:07:12 2014
jLandMF025_POD_ALL_200_TNCB101A_1File.DID_LandMF025_2_POD__fzb_TNCB101_2.scServerROWCOUNTGeneric.Sort_By_GROUP_KEYS: %s
And no rows are getting past the sort :
Stage: scServerROWCOUNTGeneric.Sort_By_GROUP_KEYS, 368222 rows input
Stage start time=2014-07-11 02:38:28, end time=2014-07-11 03:10:24, elapsed=00:31:56
Link: Write_To_SORT, 368222 rows
Link: Write_To_AGGREGATOR, 0 rows
The data being sorted is from a flat file which looks like:
"F5"
"ALL"
"F4"
"ALL"
"FF"
"ALL"
"FF"
"ALL"
"FF"
"ALL"
"09"
"ALL"
"FF"
"ALL"
"FF"
"ALL"
"FF"
Anyone have any idea why I am getting so many INFO messages, rather than WARNING messages and still have absolutely no rows getting through the sort.
The job does run during the busiest part of the schedule when we are maxing out the CPU. I cannot tell about memory.
The Sort is producing a "INFO" message for every row processed that provides no information:
330876905 INFO Fri Jul 11 03:07:12 2014
jLandMF025_POD_ALL_200_TNCB101A_1File.DID_LandMF025_2_POD__fzb_TNCB101_2.scServerROWCOUNTGeneric.Sort_By_GROUP_KEYS: %s
And no rows are getting past the sort :
Stage: scServerROWCOUNTGeneric.Sort_By_GROUP_KEYS, 368222 rows input
Stage start time=2014-07-11 02:38:28, end time=2014-07-11 03:10:24, elapsed=00:31:56
Link: Write_To_SORT, 368222 rows
Link: Write_To_AGGREGATOR, 0 rows
The data being sorted is from a flat file which looks like:
"F5"
"ALL"
"F4"
"ALL"
"FF"
"ALL"
"FF"
"ALL"
"FF"
"ALL"
"09"
"ALL"
"FF"
"ALL"
"FF"
"ALL"
"FF"
Anyone have any idea why I am getting so many INFO messages, rather than WARNING messages and still have absolutely no rows getting through the sort.
The job does run during the busiest part of the schedule when we are maxing out the CPU. I cannot tell about memory.