All posts by Mark Jacobsen

Determine DB2 Client Version (aka: level) installed on UNIX box

Sometimes you need to know what version of the DB2 client is installed on a particular unix/linux box. To do so, simple source the client profile and run db2level like so…

. /path/to/db2profile
db2level
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...

Generate test data to help debug DB2 SQL

You can easily create test data to help debug SQL statements:

with data (key, value) as
(   values ('key1', 'a')
         , ('key2', null)
         , ('key3', 'z')
)
select 'min', min(coalesce(value,'')) from data
union
select 'max', max(coalesce(value,'')) from data
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...

UNIX: Don’t Show Permission Denied Errors when using find Command

If you’re using the unix find command to search for files with a particular name

find -name theName
find: `./dir/thing': Permission denied
find: `./dir/thing1': Permission denied
find: `./dir/thing2': Permission denied

You might get distracted by all those “Permission denied” errors. The easy way to solve this is to redirect stderr to /dev/null like so…

find -name theName 2>/dev/null
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...

UNIX: No such file or directory but the file exists

Ever have a script that is executing another script and get an error that looks like this?…

/path/stub.ksh[2]: /path/XX/script.ksh: not found [No such file or directory]

Then you make sure that the file does in fact exist, and that you can read it?

So why does it say there’s “No such file or directory”?

Might want to check if the file has Windows line breaks. Easiest way to do that is run the following…

cat -v /path/XX/script.ksh

… and you’ll probably see that your lines end with ^M characters. If so, you have Window’s line breaks and you might want to look into not introducing them in the first place (save in Unix format), or check out the dos2unix command.

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

Missing You

I sit here on the eve of your death some 15 years ago. Of course I’ve had a few and have been listening to Runaway Train and Crazy Train a number of times. Not even sure why I’m writing this, but of course I do. It’s because I miss you. My girls miss you. And they never met you. You eliminated that possibility.

For years I’ve tried to come to terms with why you did what you did. I still can’t say I understand. I can’t say that I’ll ever be able to let it go.

Try figuring out how to explain suicide to a brilliant 6 year old, or a 4 year old that won’t stop asking questions. Sure I’ve read the articles. The thing is, kids aren’t dumb. So instead we just stick with the fact that Uncle Scott died. We already have to deal with tears just for that fact. Often for no apparent reason.

Why not just write this in a “journal”? Because the thing is that in the “adult world” we like to gloss over the issue. We make gun to the head gestures in jest not knowing the potential pain we’re bringing to those nearby. We take the “righteous” and “pious” positions that suicide is a sin or that the person who committed suicide was “weak” or “cowardly”.

Maybe, but what gives you the right? WHAT GIVES YOU THE RIGHT???

The thing is, suicide takes someone from a family. From loved ones. From people who care about them.

Even if they’ve screwed up. Even if they’ve done stupid things. Even if [insert your own reason].

The point is… I would argue that mental illness is a real thing. It’s not a weakness unless by weakness you mean a deficiency in some area that most of us have plenty of reserves (or at lease enough to make it through).

To wrap up this rant let me just say…

  • I apologize to any coworkers
  • I’m sorry Mom and Dad (let me know if you want me to delete this. I may anyway)
  • Even if my girls never see this they mean more to me than words can ever describe and it makes me appreciate how far my parents have come, because I’m not sure I could be so strong.
  • I miss you Scott

Anyway, I’ll close with the poignant words to Runaway Train…

Promised myself I wouldn’t weep. One more promise I couldn’t keep. It seems no one can help me now. I’m in too deep there’s no way out…

Can you help me remember how to smile? Make it somehow all seem worthwhile? How on earth did I get so jaded? …

It seems no one can help me now. I’m in too deep there’s no way out. This time I have really led myself astray.

Bought a ticket on a runaway train. Like a mad man laughing at the rain. Little out of touch. Little insane. Just easier than dealing with the pain.

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

Let me help you buy or sell that house!

It may have been a little quiet around here lately, but that’s because I’ve been hard at work studying for my real estate sales license. Fortunately, I passed the exam on Thursday and am now free to help anyone buy or sell real estate in the state of Michigan!

Visit my new site at FreedomRE.com (note it’s still under some construction)

Why did I want to get my license? It’s actually been something I’ve been interested in for a long time, and briefly considered probably 6 or 7 years ago. With a strong interest and actual background in finances, technology, business, and sales I figured that should pair well with my interest in Real Estate. In addition, I’ve been selling real estate Call Capture Hotlines to real estate agents and mortgage brokers for the last 9 years.

What differentiates me and why would someone want to work with me? I would say it’s a combination of personality fit, professionalism, and competence. As anyone who has worked with me before knows, I have a reputation for getting things done and putting my client first. I’m not going to gush all over you or sit and gab your ear off, but I will provide you my 12+ years of technology and finance experience, 10+ years sales and marketing experience, and my reputation for success. Most of all, I don’t think you’ll find another agent in the area with anywhere close to my background and skills.

I would love a chance to put my money where my mouth is and help you buy or sell that home! Contact me today:

[email protected]
517-252-4440
http://www.freedomre.com/contact

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

Parental Zen: How to Keep Your Cool as a Parent #1aDay

Leo provides more great insight on keeping your cool as a parent. I know I’m nowhere near perfect on this, but it’s a good reminder. As he says:

“The main problem is that we have some ideal as parents, of how our kids should behave. We think they should be ideal kids, but in truth they’re not ideal, they’re real. They have faults, just like we do. They need help, they make mistakes, they get angry, they get frustrated. We do too. Let’s figure out how to behave when we make mistakes, get angry, get frustrated, and show the kids how to do this through our example.”

Read the full article here

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

Q3 charity:water Campaign

My third quarter charity:water campaign is now live! To date you’ve helped raise over $2,500 for clean water and in doing so helped over 300 people! I don’t know about you, but the fact that you can potentially save someone’s life for less then $9 just blows my mind.

Every day, 5,000 kids under the age of 5 die from water-related illnesses.

So, if you would like to help continue to help solve the water crises, please take a moment to consider a small donation. And remember, with charity:water’s 100% model your entire donation helps to serve the people who need it!

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

The Single Easiest Habit Change to Improve Your Life Forever #1aDay

This one thing has made a huge difference in my life. Find out about it by reading the full article here

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

Happy Memorial Day

Now go out and enjoy some of those freedoms provided by those who fought and served. And while you’re doing that, take a moment to say “thanks”.

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