Monthly Archives: October 2016

Food

Canada Creek Ribs

1 Comment

I had blogged this a number of years back, but due to changes it managed to disappear from the interwebs. Back for everyone’s benefit…

Anyone who knows me knows that I’m not the cook in our family, but every so often I come across a recipe that becomes a staple. I think I found another one…

While hanging out at my college buddy’s cabin in Canada Creek (near Atlanta, MI) he made the most delicious, fall off the bone baby back ribs I’ve probably ever had. Naturally, I had to get the recipe.

Go to the store and get…

– Baby Back Ribs
– Sweet Baby Rays BBQ Sauce
– Garlic Salt
– Paprika
– Hickory Salt (I used Hickory Bacon Salt)

The morning of (or the night before), sprinkle the Garlic Salt, Hickory Salt, and Paprika on the ribs, wrap them in aluminum foil, and stick them back in the fridge.

Appox 5-6 hours before dinner, put the ribs (still wrapped in aluminum foil – I’d also suggest on a cookie sheet) in the oven at 300. Let them cook for 4-6 hours (I did 5.5).

Once they have cooked for 4-6 hours, fire up the grill. Put the ribs on the grill (no cookie sheet) leaving the aluminum foil under them (but opened up). Slather with BBQ sauce and let cook for another 10 minutes or so.

Enjoy!

Please remember to subscribe to the newsletter to stay up to date!

You or someone you know looking to buy or sell?
Disclaimer: Thoughts and opinions are my own, and do not reflect the views of any employer, family member, friend, or anyone else. Some links may be affiliate links, but I don't link to anything I don't use myself. You would think this should be self evident these days, but apparently not...
DB2

DB2 Ownership Transfer

Leave a comment

If you ever get an error in DB2 along the lines of…

SQLCODE=-727, SQLSTATE=56098, SQLERRMC=1;-551;42501;MARKJ|EXECUTE|XX.PROC_P

…but in your code are executing the proc as another user (say “USR1”) instead of MARKJ, it may be that MARKJ created the proc and until recently still had the necessary access for executing everything in XX.PROC_P. Subsequently permissions were “fixed” and now stuff starts blowing up all over because MARKJ no longer has access. How to fix? Well, like all things I’m sure there are a million ways to do it, but the easiest in this situation was to have MARKJ transfer the ownership on everything he owned. To determine that, the following SQL was run to generate the commands, then the commands were run…


SELECT 
CASE ROUTINETYPE WHEN 'F' THEN
    'TRANSFER OWNERSHIP OF FUNCTION  '||
    RTRIM(ROUTINESCHEMA)||'.'|| ROUTINENAME ||
    ' TO USER DB2DBA PRESERVE PRIVILEGES; '
ELSE
    'TRANSFER OWNERSHIP OF PROCEDURE  '||
    RTRIM(ROUTINESCHEMA)||'.'|| ROUTINENAME ||
    ' TO USER DB2DBA PRESERVE PRIVILEGES; '
END
FROM SYSCAT.ROUTINES 
WHERE OWNER = 'MARKJ' 
WITH UR;
Please remember to subscribe to the newsletter to stay up to date!

You or someone you know looking to buy or sell?
Disclaimer: Thoughts and opinions are my own, and do not reflect the views of any employer, family member, friend, or anyone else. Some links may be affiliate links, but I don't link to anything I don't use myself. You would think this should be self evident these days, but apparently not...