All posts by Mark Jacobsen

Checking and Maintaining Linux Disk Space

Ever need to find out what’s using the most space on your Linux box? There are a couple commands that will help make things easier…

To find out how much space you have use:

df -h .

Which will give you output like so…

Filesystem      Size  Used Avail Use% Mounted on
/dev/sda         20G   15G  4.2G  79% /

To list out the directories using the most space, use this handy command…

sudo du /usr/local | sort -n

… where /usr/local is the directory you want info for (you can also just start from root: /)

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

charity:water update

Wow. Just the other day I received an updated report on what my 2012 birthday campaign helped achieve and I have to say I’m absolutely floored. The $1001 we raised helped over 860 people!

Let me say that again, you helped over 860 people.

There’s a reason I’ve always been a big fan of charity:water and these types of results just help to reinforce that belief. Take a look at the projects here: Project Page

Wow. Just wow. And THANK YOU!!!

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

Learning VIM

So you would think that as a programmer for many moons now that I would have considerable experience in VIM and VI, but I’m hear today to admit that I am not. For years I’ve gotten by with my favorite Windows text editor notepad++, but the geek in me wanted to know why everyone loves Vim so much. To that end the 2 things I started with are…

I can’t say I’m a convert yet, but it’s always nice to have another tool in the toolbelt. Here for your and my reference is my quick VIM cheat sheet.

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

Connect to DB2 via UNIX Command Line

To access DB2 via the command line on a UNIX/Linux box you need…

  • The DB2 client installed on the box
  • The DB you’re trying to connect to cataloged in the client

Once you know you have that, simply source your db2profile and connect…

. /path/to/db2profile
db2 connect to DBCATNAME user yourid using yourpw

… where DBCATNAME is the name the DB is cataloged as on that box, yourid is your user ID for connecting to the DB, and yourpw is your password for connecting to the DB. Note, that if the actual database resides on the same box, and you want to login as the user your logged into the UNIX box as, you can simplify the connect string and not have to include your user ID or password…

. /path/to/db2profile
db2 connect to DBNAME
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...

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