All posts by Mark Jacobsen

DB2

Find DB2 Nicknames

01/24/2013 Mark Jacobsen Leave a comment

Want to see the nickname setup for a DB2 database? Here’s a handy query…

SELECT 
        NICK.TABSCHEMA,
        NICK.TABNAME,
        NICK.SERVERNAME,
        NICK.OWNER,
        NICK.REMOTE_SCHEMA,
        NICK.REMOTE_TABLE,
        SRV.SERVERTYPE
FROM    SYSCAT.NICKNAMES NICK
        INNER JOIN SYSCAT.SERVERS SRV
            ON (NICK.SERVERNAME = SRV.SERVERNAME);

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

ColdFusion, Linux

Start ColdFusion8 on Ubuntu Server Start

01/17/2013 Mark Jacobsen Leave a comment

Ok, so this is not the most bleeding edge post, but hopefully useful if you need it. Here’s what you need to do if you need to get ColdFusion8 to start on server reboot (since it doesn’t appear to install itself as a service) using Ubuntu server.

First, create a service script and make sure it’s executable like so…

sudo touch /etc/init.d/coldfusion
sudo chmod 755 /etc/init.d/coldfusion

Next, you need to actually put something in the script…

sudo nano /etc/init.d/coldfusion

Here’s what to put in the file…

#! /bin/sh

### BEGIN INIT INFO
# Short-Description: ColdFusion8 service
### END INIT INFO

file=/opt/coldfusion8/bin/coldfusion

case "$1" in
stop)
$file stop
;;
status)
$file status
;;
restart)
$file restart
;;
*)
$file start
;;
esac

exit 0

Finally, you need to tell Ubuntu to use your service and make it available

sudo update-rc.d coldfusion defaults

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

You or someone you know looking to buy or sell?

WordPress

New Essential WordPress Plugins Page

01/08/2013 Mark Jacobsen Leave a comment

Curious what WordPress plugins you should bother to install? I’ve created a resource page with the ones I find most useful.

Visit the Essential WordPress Plugins page now.

If there are any I missed that you find useful, please add them to the comments.

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

You or someone you know looking to buy or sell?

DB2

Seven commands developers can run to resolve issues in DB2 AIX development

12/19/2012 Mark Jacobsen Leave a comment

Now here’s a super geeky one for you, but also super helpful when doing DB2 dev on AIX. Thanks to one of our App DBAs for providing this!

Please note that you will need DBADM rights to do some of these things so your mileage may vary.

First you need to determine what command(s) to run…

REORG(#1), RUNSTAT(#5), REBIND (#6) as a first step when performance is suffering
REORG(#1) when you recieve a SQL0668N reason code 7 or any other SQL message indicating a REORG is required
REORG(#1) after table alters or deleting lots of rows when you want to reclaim space.
REORG(#2) when you recieve a ADM6044E or a SQL2216N SQL error “-289” on a REORG (#1)
CLEAR LOAD PENDING (#3) when you recieve a SQL0668N reason code 3
RUNSTAT(#5) after REORGs(#1 or #2), data volume changes(+10%), and/or adding indexes
EMPTY A TABLE WITH A LOAD REPLACE(#4) when you want to empty a medium or larger sized table
REBIND(#6) after every RUNSTAT(#5) if you are using stored procedures
SET INTEGRITY(#7) to fix SQL0668N reason code 1

Then change the command syntax to match the required objects. All parameters starting with a dollar sign($) e.g. $TABSCHEMA, $TABNAME, $ROUTINESCHEMA, $ROUTINENAME, and/or $STEMP_TBSPACE must be replaced with valid table schema/name, stored procedure schema/name, system temporary tablespace.

Note: RAPID SQL 7.7.5 Issue: Add cast syntax (CAST(‘command-syntax’ AS CLOB)) if your version of Rapid SQL returns an error
Example: CALL SYSPROC.ADMIN_CMD (CAST(‘REORG TABLE $TABSCHEMA.$TABNAME ALLOW READ ACCESS’ AS CLOB));

Finally, run the commands via any interface that can call stored procedures including RAPID SQL

Other resources for troubleshoot messages or research other options for the commands supplied below by searching these

1. REORG A TABLE

CALL SYSPROC.ADMIN_CMD ('REORG TABLE $TABSCHEMA.$TABNAME ALLOW READ ACCESS');

2. REORG A LARGE TABLE

CALL SYSPROC.ADMIN_CMD('REORG TABLE $TABSCHEMA.$TABNAME ALLOW READ ACCESS USE $STEMP_TBSPACE');

Note: To find $STEMP_TBSPACE:

SELECT TBSPACE AS $STEMP_TBSPACE, PAGESIZE FROM SYSCAT.TABLESPACES WHERE DATATYPE = 'T' WITH UR;

3. CLEAR A LOAD PENDING **This leaves the table empty**

CALL SYSPROC.ADMIN_CMD('LOAD FROM /dev/null OF DEL TERMINATE INTO $TABSCHEMA.$TABNAME NONRECOVERABLE');

4. EMPTY A TABLE WITH LOAD REPLACE

CALL SYSPROC.ADMIN_CMD ('LOAD FROM /dev/null OF DEL REPLACE INTO $TABSCHEMA.$TABNAME NONRECOVERABLE');

5. RUNSTAT A TABLE

CALL SYSPROC.ADMIN_CMD('RUNSTATS ON TABLE $TABSCHEMA.$TABNAME ON ALL COLUMNS AND SAMPLED DETAILED INDEX ALL ALLOW WRITE ACCESS');

6. REBIND A STORED PROCEDURE

CALL SYSPROC.REBIND_ROUTINE_PACKAGE('P','$ROUTINESCHEMA.$ROUTINENAME','ANY');

7. SET INTEGRITY

SET INTEGRITY FOR $TABSCHEMA.$TABNAME IMMEDIATE CHECKED;

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

You or someone you know looking to buy or sell?

MySql

Execute a SQL file via the MySQL command line in one line

12/12/2012 Mark Jacobsen 1 Comment

Have a large script (like a DB dump) you want to execute from the command line in one line so you can just drop it in a batch/shell script and run with it? Assuming MySql is on your system path, here’s the command…

mysql -u user -ppass < C:\temp\myscript.sql

Where "user" is the username, and "pass" is the password (note, there's no space or other delimiter between the "-p" and the password)

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

You or someone you know looking to buy or sell?

Java

Add a SSL Cert to Your Java Keystore

12/06/2012 Mark Jacobsen Leave a comment

If you’ve ever had to add a SSL certificate to a java keystore, you know that the command is a little convoluted. Here for your and my reference is the command…

 "D:\Program Files\Java\jre1.5.0_22\bin\keytool" -import -trustcacerts -alias MyCA2 -file C:\MyCA2.crt -keystore "D:\Program Files\Java\jre1.5.0_22\lib\security\cacerts"

When promoted for the password, the default is “changeit”, and make sure to choose/type “yes” when asked if you want to trust the cert.

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

You or someone you know looking to buy or sell?

Productivity

How I manage my social media intake

12/03/2012 Mark Jacobsen Leave a comment

Every now and then, people ask how I knew something or how I can keep up on the things I do. Rather than go over it a bunch of times I’d like to try and share it once.

First and foremost, the most important thing is managing the “noise” you do listen to. Specifically, I do not watch or read the “news” unless an event somewhere else triggers the need/desire to check things out. Second, in social media you need to learn how the tools work, and by that I mean using things like lists, or hiding individual noise makers (for example, if less than 1 in 3 of your posts has anything useful and you’re not immediate family there’s a good chance you’re getting blocked).

So on to the specifics… The way I make this work is with a few tools:

Feedly – For subscribing to RSS feeds
Social Media – Take your choice. Mine are LinkedIn, Facebook, Twitter, Google+
Flipboard – For viewing social media and RSS feeds
Pocket – For reading the things that may actually be useful
Evernote – For storing the things that actually were useful

Step 1 – Setup your Inputs

In this step, you would subscribe to the feeds you’re interested in via Google Reader, setup social media profiles on the network(s) of your choice, connect with the people you want to on those networks, and create your VIP lists.

On Twitter I have a private “VIP” list I maintain of people I most respect and that post useful content. This list has less than 20 members.

On Facebook, because of their ridiculous “news feed”, I don’t pay attention to most posts and a lot of people wind up getting hidden. I also have a VIP list for immediate family.

No matter what network I strongly recommend setting up a “VIP” list (actually call it that) so you can easily get at the people and content you’re most interested in without all the other noise.

Step 2 – Setup Flipboard

This is my platform of choice for being able to quickly scan inputs at a glance and decide which things may be worth my time. For example, you can have a board for your Google Reader feed, social media feeds, or even specific lists on Twitter, Facebook, or Google+.

You’ll also want to setup the “read it later” service of your choice, which for me is Pocket. Once you’ve done this, as you’re flipping through the posts on any “board” you can simply long press and choose “Read Later” to have the article saved without all the ads and garbage for easy reading later.

This is where the “triage” is done multiple times a day. When I have a spare minute I’ll flip through a given board or boards marking articles of interest to read later.

Step 3 – Read

After things have been saved to Pocket, when I have more than a quick minute I’ll read the articles I’m interested in. Pocket is great because it has apps for iPhone and Android as well as a web app for reading on a larger screen.

Step 4 – Archive

If I find something I really like, Pocket makes it very easy to save the article to Evernote for future reference (except for on the web platform). Once in Evernote I can get at any article from anywhere since they have an app for just about every platform under the sun. Personally, I have an “Article Ref” notebook that everything gets shoved into.

So there you have it. My personal method for managing my social media intake. Hope you find it useful and learned something you hadn’t known before.

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

You or someone you know looking to buy or sell?

Parenting

Self Control

11/27/2012 Mark Jacobsen Leave a comment

A friend shared this post from facebook and I thought it worthwhile to pass along…

If we cannot control our own mouths (e.g. we lecture too much, have to prove our point, yell and scream)…how can we expect our children to control their mouths?

If we cannot control our emotions, how can we expect our kids to control their emotions?

… Let’s make 2013 the year we get control of ourselves.

Of course this is sometimes easier said than done as any parent can attest to 🙂

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

You or someone you know looking to buy or sell?

WordPress

Exclude Categories from WordPress Feed

11/24/2012 Mark Jacobsen Leave a comment

Want to keep posts from a given WordPress category or categories out of your public feed? If so, just edit the template’s functions.php file and append this code…

function myFeedExcluder($query) {
 if ($query->is_feed) {
   $query->set('cat','-12');
 }
return $query;
}

add_filter('pre_get_posts','myFeedExcluder');

This code will keep the category ID=”12″ out of the feed. If you want to exclude more than one category, put them in separated by commas ‘-12,-25,-33′.

Thanks to this page for this tip!

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

You or someone you know looking to buy or sell?

Misc / Random

Thankful for Being Blessed

11/22/2012 Mark Jacobsen 1 Comment

As we enter the stereotypical season of thanks I’ve been looking back at things that we’ve accomplished over the years, and I’ve realized that I have been extremely blessed. I’m blessed…

To have been born in America
To be healthy
To have parents from a working class background
To have had a good education
To have married a wonderful woman
To have healthy children
To have a great company
To have a great job
To have been taught: discipline, self-sacrifice, and hard work

For any of you that helped to heap these many blessings on me, I say “Thank You!” now, tomorrow, and forever.

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

You or someone you know looking to buy or sell?