Alan Seiden Consulting: PHP and IBM i Expertise › Zend Framework 2 performance optimization: it works

September 26th, 2014 Comments off

Zend Framework 2 (ZF2) provides optimization techniques that are often overlooked by published performance tests. One excellent source for such techniques is a presentation by Gary Hockin. I was thrilled when my client and friend King Harrison IV of K3S began testing the effect of these techniques on his ZF2 application running on IBM i.

King’s initial tests produced a 600ms reduction in load time, obtaining respectable performance for his database-heavy application. He plans to update his blog post with further speed improvements as he implements them.

Read King Harrison IV’s blog post about ZF2 performance improvements.

Read the original at Alan Seiden Consulting: PHP and IBM i Expertise.

Alan Seiden Consulting: PHP and IBM i Expertise › Save your fingers when using PHP-CLI

September 12th, 2014 Comments off

In Batch PHP I showed how to call PHP from a command line. For example, with Zend Server 6 or 7 on IBM i, one would launch a PASE command line using the command CALL QP2TERM, or launch QShell using QSH, then type a command such as this:

/usr/local/zendsvr6/bin/php-cli myscript.php

For those of us who use PHP-CLI often, the above command can be a finger-buster. Let’s shorten the path by creating a symbolic link:

cd /usr/bin
ln -s /usr/local/zendsvr6/bin/php-cli phpc

I created the symbolic link in /usr/bin, a directory that is likely to be in any user’s path.

Now try the shortened command:

phpc myscript.php

To test the shortcut without a PHP script, use the -v switch, which requests version information (‘v’ for version) about your PHP installation.

phpc -v

The above command will return version information that starts out something like this:

PHP 5.3.6 (cli) (built: Apr  7 2011 09:37:14)                                
Copyright (c) 1997-2011 The PHP Group                                        
Zend Engine v2.3.0, Copyright (c) 1998-2011 Zend Technologies                
    with Zend Extension Manager v5.1, Copyright (c) 2003-2010, by Zend Techno
    - with Zend Data Cache v4.0, Copyright (c) 2004-2010, by Zend Technologie
s [loaded] [licensed] [disabled]                                             
    - with Zend Guard Loader v3.3, Copyright (c) 1998-2010, by Zend Technolog
ies [loaded] [licensed] [enabled]                                            
    - with Zend Job Queue v4.0, Copyright (c) 2004-2010, by Zend Technologies
 [loaded] [not licensed] [disabled]

By creating a symbolic link to the PHP-CLI binary, practitioners of PHP can speed their work while saving their fingers.

For more about symbolic links, see my article Link up with QShell.

Read the original at Alan Seiden Consulting: PHP and IBM i Expertise.

iDevelop › Tidbits on Java Programmers and Apple Announcement

September 11th, 2014 Comments off
Training the Next Generation of RPGers We just finished delivering the second part of an introductory RPG class to the group of Java programmers that...

Read the original at iDevelop.

i Can › IBM Power Systems Technical Symposium in Melbourne and Auckland and Enjoying the Land Down Under

September 8th, 2014 Comments off
Recently I attended the IBM Power Systems Technical Symposium in Melbourne Australia, followed by a similar conference the next week in Auckland New Zealand. This...

Read the original at i Can.

DB2 for i › Ready or Not?

September 5th, 2014 Comments off
The following message is brought to you by senior level consultant, long time member of the IBM DB2 team, and my good friend Mr. Jim Denton...


Ready or not …

Here it comes.  Change is one of constants in our lives as IT professionals – we are often confronted by new business requirements,  increasing data and transaction volumes, shifting strategic priorities, opportunities to leverage analytics, data model limitations, long running or erratic queries, new user interface demands, integrating new applications, managing business consolidations and acquisitions, etc.  And practically everyone will have additional challenges to add to that list.

As part of the DB2 for i Center of Excellence team, I often get the opportunity to teach both the SQL Performance and the Advanced SQL courses.  Practically every session of those courses includes students saying “I wish I’d known.”  They’ve spent valuable time writing a complicated program instead of just a few carefully crafted SQL statements.  They’ve rewritten code to improve performance without knowing there were several easier options.  Or they’ve used SQL without leveraging SQL’s strengths for set-based processing.

Clearly, knowledge is our best defense against an onslaught of change.   So what can you do to prepare yourself?  Here are some ideas:

  • Keep reading blogs like this one!
  • Take advantage of the DB2 for i homepage and in particular, the vast array of whitepapers on the Resources tab

We understand your frustration when we are forced to cancel public workshops due to low enrollments.  Ask us about a private session.  It is probably less expensive than you think and we can train more members of your team at the same time.  We can also customize content and focus on what’s important to you. 

One last point -- I highly recommend that you always take credit for your successes.  This can be anything from talking to your colleagues at the coffee machine to executive level presentations.  This is no time to be modest!  Taking credit builds organizational momentum and demonstrates the value of ongoing investments in DB2 for i skills.

Your company has made significant business investments in IBM i and you have a long list of technical challenges which require new knowledge and new skills.  Take a minute and ask yourself:

Are you ready?

Read the original at DB2 for i.

Categories: Blogs Tags:

You and i › Modernizing–Bellamy & looksoftware

September 3rd, 2014 Comments off
Well, it’s been a while since my last blog. I’ve enjoyed some vacation, relaxing with friends and family while I recharge my batteries. I’ve also...

Read the original at You and i.

iDevelop › You Can Never Have Too Many RSE Shortcuts

September 2nd, 2014 Comments off
As part of our preparations for the upcoming RPG & DB2 Summit in Minneapolis we've just released the latest edition of our "Favorite Keyboard Shortcuts...

Read the original at iDevelop.

Categories: Blogs, IBM Systems Magazine Tags:

DB2 for i › Governance and Control? Show Me

August 27th, 2014 Comments off
In the state of Louisiana where I was born and spent some formative years, they often repeat a famous quote: "it ain't braggin' if you can do it".

And in the state of Missouri where I went to college, the unofficial motto is "show me". 

"Show me, do it".  There's no quicker way to separate fact from fiction, truth from falsehood, or request a demonstration. And if all goes well, you might learn something; or at least be entertained!

With that in mind, I am excited to announce the results of a recent project that clearly demonstrates one of the major new database enhancements delivered in IBM i 7.2.

Our DB2 for i Center of Excellence team partnered with the IBM International Technical Support Organization (think Redbooks) and the smart, creative folks in IBM i Development to illuminate and exercise Row and Column Access Control. The fruit of this labor is an ITSO Redpaper describing design, definition and implementation scenarios of DB2 row permissions and column masks.


Show Me

If you are interested in establishing effective policies and gaining control of row and column access in a truly data centric way, I want you to do three things:

1. Go here and watch the brief video explaining the situation, then share it with your business leaders - especially the owners of the data.  There is a version in Spanish as well as in English.

2. Go here and download the DB2 for i Row and Column Access Control Redpaper.  Read it.  Think about it.  Generate awareness in your organization.

3. Identify an executive champion - someone who will have to answer the phone when sensitive data lands on the wrong desk.  Initiate a project with assistance from the IBM DB2 for i Center of Excellence team.  In other words, point out the problem (unfettered access to all the data), and then suggest the solution (RCAC).

As always, feel free to contact me if you need help with articulating the situation at any level of your organization.

And remember, data is valuable. Please protect it.

Read the original at DB2 for i.

Categories: Blogs Tags:

iDevelop › Who Was That Masked Man? Or That Masked Value?

August 26th, 2014 Comments off
In a recent post, we voiced our concerns about the potential for application error when taking advantage of the masking support related to RCAC in...

Read the original at iDevelop.

Categories: Blogs, IBM Systems Magazine Tags: ,

i Can › IBM i 7.2 – Batch Model

August 26th, 2014 Comments off
In the IBM i 7.2 release, there is a new function called “Batch Model”; the 7.2 announcement stated: “The Batch Model has been added, providing...

Read the original at i Can.