with 
last_day(last_day) as 
(
select 
case 
when month(current date) =  12  and day(current date) =  31  then  
   current date - dayofyear(current date) days +  1  year 
else 
   current date - dayofyear(current date) days 
end
from sysibm.sysdummy1 
)
,
calendar(clnd_day, clnd_dayofweek, clnd_day_no) as
(
select last_day, varchar('',  3 ), int( 0 ) from last_day
union all
select clnd_day +  1  day, 
substr('SunMonTueWedThuFriSat', 
		   3  * (dayofweek(clnd_day +  1  day) -  1 ) +  1  ,  3 ),
clnd_day_no +  1 
from calendar
where clnd_day_no  <=  366  
)
select clnd_day "Day of Year", clnd_dayofweek "Day of Week"
from calendar, last_day
where year(clnd_day) = year(last_day) +  1