Archive

Archive for April, 2012

DB2 for i › More Database Enhancements!

April 27th, 2012 Comments off
You might have missed it as part of this week's IBM i 7.1 technology refresh announcement...


IBM DB2 Web Query has been updated and enhanced!


According to the announcement letter, DB2 Web Query version 2.1 will be available with a new product structure to simplify packaging. The product is now available as either an Express or a Standard offering.

The new version also includes a focus on more granular user security with an entirely new user security center, a new core-based pricing model, enhancements to user interfaces, and improved mobility support. The "IBM i for BI" packaged solution is also enhanced to include DB2 Web Query Standard Edition V2.


From my perspective, DB2 Web Query can and should play a significant role in getting additional value out of your data, as well be a corner stone in a QUERY/400 modernization strategy (more on that idea in a future post).  If you are pulling data out of IBM i because "other" platforms offer more bells and whistles, STOP. There is a better and more efficient way to leverage your investment in business logic and existing databases.


If you have not looked into 
DB2 Web Query as part of your business intelligence and analytics portfolio, now is the time to do so.  If you have considered DB2 Web Query and have questions, concerns or issues, reach out to us - we're here to help you get the most out of DB2 for i.  If you have some DB2 Web Query success stories or ideas, hit me in the comments.




Read the original at DB2 for i.

Categories: Blogs Tags:

DB2 for i › DB2 WIKI REFRESHer

April 24th, 2012 Comments off
For this installment, Kent Milligan is back with a reminder and some exciting news!

It's all yours Kent...


In my blog entrylast month, I highlighted the value of following the DB2 for i Technology Updates wiki to learn about recent DB2 for i enhancements that can boost your productivity and application performance.

One of the times that you will find new info in the wiki is when IBM launches a new Technology Refresh for the IBM i operating system.


Today, Technology Refresh 4 for the IBM i 7.1 operating system was launched with more than 25 database enhancements.

Here is a summary of some of the more interesting DB2 for i enhancements...

The Insert with Remote Subselect support makes it easier to share data between systems.  This new SQL feature enables a table on one system to be populated with data from tables on a different system – eliminating the need to first copy the data into some type of staging area.  The following SQL statement shows easy it is to use this new support.  The only setup work on the requesting system is adding a relational database directory for rmtsystem to the Relational Database Directory with the ADDRDBDIRE system command.
    INSERT INTO locschema.locCustInfo
        SELECT lastname, address, city FROM  rmtsystem.rmtschema.custtable

If you utilize SQL stored procedures and functions to perform critical business calculations that you don’t want to share with others, then you should dig into the new Obfuscation feature for SQL procedures and function. Think of obfuscation as just a really big word for masking. With the obfuscation feature, users will see a masked value of your business logic like the following graphic displays - instead of the original business calculation when accessing the DB2 for i catalog. The obfuscation feature should be most interesting to software vendors that have many algorithms and processes that they would like to protect as intellectual assets.



The new SQL XMLTablefunction puts the finishing touch on the DB2 and XML integration capabilities that were delivered at GA of the IBM i 7.1 release.  The XMLTable function is a swiss-army knife type of tool enabling developers to use a wide range of XPath expressions to retrieve data from XML documents in relational format.  Let’s assume the following XML document is stored within an XML column named location_doc within the employee table.
 
  <dept bldg="025">
        <employee id="146">
               <name><first>Mary</first>
                           <last>Dilbertson</last></name>
               <phone>507-333-1234</phone>
               <office>415</office>
               <officesize measure="SQFT">160</officesize>
        </employee>
  </dept>

This SELECT statement utilizes the XMLTABLE function to return a subset of the business data stored in the XML document in relational format to produce the following output.
  SELECT X.empid, X.lastname, X.officenum 
  FROM employee, 
       XMLTABLE ('$d/dept/employee' PASSING location_doc as "d" 
               COLUMNS 
               empID           INTEGER        PATH '@id',
               lastname       VARCHAR(25)    PATH 'name/last',
               officenum      CHAR(3)         PATH 'office') AS X

Output produced by the XMLTable function:



To increase the adoption of SQL by IBM i developers across all languages and interfaces, a new RUNSQLCL command is available on both the IBM i 7.1 and 6.1 releases.  This command will make it easier for developers to exploit SQL in their CL programs.  

Hopefully, this summary of the “Technology Refresh” DB2 for i enhancements not only whets your appetite to take a deeper look at this new round of DB2 for i updates, but also motivates you to be a frequent visitor to the DB2 for i Technology Updates Wiki.





Read the original at DB2 for i.

Categories: Blogs Tags:

The Buzz › IBM Announces PowerLinux and PowerLinux Solution Edition for SAP Applications

April 24th, 2012 Comments off
Seems I’m suddenly hearing a lot about SAP solutions. Our May Power Systems issue, which hits desks in about a week, covers today’s big PowerLinux...


Read the original at The Buzz.

DB2 for i › Get Educated, Have Fun, See Boston!

April 19th, 2012 Comments off
Our friends over at System i Developer have announced a new event!

The new SQL for i Spotlight conference to be held in early June looks to be an excellent opportunity to get educated, have fun and see Boston (not necessarily in that order).

In earlier posts I've ranted mentioned the benefits of maintaining and/or growing your knowledge, skill and expertise in the area of data-centric processing and SQL usage. The SQL for i Spotlight event is designed and offered to do just that. Based on my personal experience with the RPG & DB2 Summit conferences, I expect Spotlight to be an outstanding value and extremely advantageous to the database administrator, engineer, or SQL developer.

If you want to know more about DB2 for IBM i, don't delay, sign up today!

By the way, it looks like an early registration (through May 1, 2012) results in a discount.


Read the original at DB2 for i.

Categories: Blogs Tags:

Alan Seiden's PHP and IBM i Resources › Which version of Zend Server for IBM i do I have?

April 18th, 2012 Comments off

Here is the easiest way to determine which version of Zend Server is installed on a given IBM i system.

From a 5250 command line, follow these four steps:

1. GO LICPGM
2. Take option 10 (Display installed licensed programs)
3. Scroll down to the licensed program 2ZSVRPI 
     (on my system it's the last entry)
4. Read the product description,
     containing version numbers for Zend Server and PHP
     in the form "Zend Server for IBM i [version] ( PHP [version])"

On my IBM i, I see:
2ZSVRPI   *INSTALLED   Zend Server for IBM i 5.6.0 ( PHP 5.3 )
so Zend Server is at 5.6.0 and PHP is 5.3.

Thanks to Zend’s Sam Pinkhasov for this tip.


Read the original at Alan Seiden's PHP and IBM i Resources.

Mike's IBM i PHP blog and more... › Open Source Tools for IBM i

April 16th, 2012 Comments off
Tools anyone?
Rather than blather on about the new toolkit, once again, I was struck by an opportunity I saw recently in the open source arena. One of the things I love about open source is the idea that I can kick the tires before buying into a solution. There will always be those folks out there who refuse to pay for anything, regardless of the level of value they derive from someone else’s efforts. There are many ways to contribute to the open source community that do not require code and here is an article that highlights a few.

So as I was discussing the open source arena the other day with a colleague he mentioned another project. Like Zend Server CE that is distributed for no charge and has an optional support model. The is attractive in many ways, mostly by breaking down the barrier to entry to almost nothing. Also, it provides an insidious way for some derelict companies to modernize. It still shocks me to run into a company with apathetic management or “coasters” (those who have a couple of years to go before retirement and do not wish to risk anything new.)
I want staff to stand up and start skunk-works projects and here are a couple of way to do that. Managers are welcome to exploit these techniques, as well.

phpMyAdmin – comes pre-installed with Zend Server
This is an open source utility written in PHP that provides nearly every administrative function necessary for MySQL. The MySQL Monitor (command line interface) can seem a bit intimidating for the uninitiated and this interface really softens the blow. Getting familiar with MySQL makes like a lot easier and is required when ramping up on other open source projects like SugarCRM, MediaWiki, Joomla and Drupal, all of which I have installed and run on IBM i. Here is a helpful tip:When you first install MySQL, either as part of Zend Server or as part of the Zend DBi product just released by Zend you should realize the ROOT user profile (MySQL equivalent of QSECOFR) has no password. Immediately upon installation of the MySQL Server I create a powerful profile for myself and once I have verified that it is working I set the password to ROOT so that no one can hack my implementation.

Content Management with Drupal or Joomla or whatever…
Putting up a website can seem like a daunting task. Installing something that can manage the site might make more sense, especially if your company is contemplating a new Intranet. There are many open source content management systems (CMS) out there to consider. I have been a big advocate of Drupal since it has a VERY large and rabid following and seems to have many key features folks want in their sites. But truly any content management system will do. The folks at WMCPA and COMMON selected Joomla as their CMS of choice and have been very pleased with it.

Documentation?
A while ago I picked up a tip from Jon Paris of Partner400 fame. The idea was to take a wiki application and allow end users to build their own doc. Jon recommends PMWiki and while I am not terribly familiar with that solution I tend to advocate MediaWiki. MediaWiki has a great feature that is activated by default. This feature can be turned on to allow the IT staff and developers to build the end user documentations for programs and processes within the organization. AND for each page they build there is a corresponding end user documentation page that is fully annotatable. Meaning, end users can makes notes right on the page running in PHP and updating MySQL running directly on IBM i. Think of some of the added benefits to this approach like automatically backing up end user documentation with each SAV of the IFS or option 21. Also, think of disaster recovery scenarios where the end user doc is now immediately available after restoring the system. No need to recover a file server or windows/linux box.

There are quite a few interesting options out there and I would strongly recommend you check out the YiPs website for more details… or, let your fingers do the walking with Google.


Read the original at Mike's IBM i PHP blog and more....

Categories: Blogs Tags:

midrange.com - In My Humble Opinion › Justin Porter — COMMON BoD Candidate 2012

April 15th, 2012 Comments off
Editors note: The following is a post by guest author Justin Porter who is a candidate for the COMMON Board of Directors. COMMON has survived quite well through the financial crisis—in no small part due to the dedication of its members, volunteers and staff who wish to see COMMON continue providing top quality education into [...]



Read the original at midrange.com - In My Humble Opinion.

Categories: Blogs Tags: , ,

Pete's Wordshop › More (ir)-Rationality

April 13th, 2012 Comments off

I love Rational tools but as I mentioned to my IBM sales representative “I am beginning to suspect that the Rational Marketing team has never left the 60′s and is still “tripping” when they decide to put their pricing together.  That or they took their sales class from PT Barnum (“There’s a sucker born every minute…”). “  The source of the pain here is that as a developer enrolled in IBM’s wonderful (and it IS wonderful) developer discount program, I had two primary complaints:

1) You receive no notification of expiring Software Maintenance Agreements (SWMA)

2) Trying to sort out what the final costs will be based on the various discounts and product ID’s is nothing short of alchemy….

#1, I am happy to say, has been “fixed”.  I did receive notification that my SWMA was expiring. But every year is an adventure and this year was no exception! The IBM OS and licensed programs are very simple, I never have a problem with them.  But when it comes to the Rational products, you can never really know how the pricing will come out.  Fortunately, I only have ONE Rational product – RDP (it has been through many naming conventions: WDSc, WDSCi, RDi, RDP and if I can believe what my IBM sales rep says, it is now RDG) but the constant name game leads to confusion every year as to *what* exactly, needs software support.  This year I was finally able to narrow it down to my two licenses of RDG.  “Send me the quote” I said!

What I received first surprised and then confused me.  The quote I *thought* I would receive was $548 for *both* my licenses. You have to remember that this is a developer *discount* program and everything on the i IS heavily discounted.  Everything BUT the Rational tools.  The cost of the OS (nada).  The cost of the supporting OS products, nada!  Cost of the Rational tools? 131% of list!  Yeah, you read that correctly.  For a developer ‘discount’ program the actual tools cost you MORE than if you purchased them retail.  Tis the “Smarter Planet” at work at IBM!  I am just hoping that Microsoft (which *discounts* it’s tools) doesn’t catch wind of this cash cow approachfor IBM…..

My SWMA on *each* copy of RDG is $548.  My cost if I buy a license with 1 year of support from IBM “retail”: $416.00  You would *think* that a developer discount would produce a *lower* cost for the developer.  Gee, I wonder why RPG developers *don’t* move to use Rational tooling?  Hmmm, could it be the (ir)-Rational pricing?

Just once I would love to be surprised in a happy way by Rational pricing.  Developers should get a discount when there is a ‘developer discount’ offering don’t you think?  Apparently the Rational division thinks not…..


Read the original at Pete's Wordshop.

Categories: Blogs Tags:

News › Checking For Cracks In The Technology Foundation

April 13th, 2012 Comments off

Have you ever come face to face with the reality that you are not getting what you paid for? You make IT investments like a Power Systems server running IBM i, but don't come close to taking full advantage of the platform. The sad truth is that your hardware and software are loaded with unused capabilities. You paid for them, but you get value out of only the features you use. It's sort of like paying the cable TV company for 150 channels, but never watching more than 10.

This is not a recent phenomenon, but it does seem to be getting worse. If that wasn't true, why is every company in the IT business putting a greater emphasis on services? Yes, there's money in it. IBM realized this a long time ago. And it's a bit surprising that a company so fond of making product name changes hasn't rebranded International Business Machines as International Business Services.

But aside from the money, the reason IT services are popping up everywhere is because only the companies that build products know how to get the maximum value out of what they make. OK, that's not 100 percent true. There are people outside the hardware and software fortresses who make a point of specializing in certain skills and operating specific tools. They stay right on top of all the enhancements. But most IT departments don't have specialists, they have generalists. And they generally have their work-a-day plates filled to overflowing, which keeps them very busy in the present and with little time to consider the future. They realize the future--as envisioned by their boss--has much higher expectations for IT to contribute more toward business goals, but a chicken that lays one egg a day can't be coaxed into laying seven. I mean, there's only so much you can do, right?

Please make the jump with me now to Sirius Computer Solutions, one of the mega-resellers and integrators of the IT business. The services business is not new to Sirius, but the company does have a new service available within the Power Systems portion of the Sirius IT biz that you need to be aware of, and it is called the Power Architectural Review, or PAR.

These types of reviews are not new, but Stan Staszak, director of Power Systems solutions at Sirius, says the approach is slightly different than in the past when they were informally called optimization studies or server consolidation studies and each group within Sirius had its own way of doing the studies. The PAR program has unified and standardized the review process to provide a better overall view of the IT and business alignment potential, but typically what motivates a company to do a PAR is an interest in saving money and increasing efficiencies.

Often this becomes a server consolidation effort, which results in hardware and software savings related to initial costs as well as maintenance. Other benefits include reduced floor space footprint, reduction in power consumption, and in most cases the addition of a highly resilient system, which is a priority for many companies with the concerns about the business risk that downtime creates.

Although Staszak points out that each PAR is completely unique to the customer being reviewed, it's often the case that a company can gain the needed resiliency and save money through server consolidation.

Nine out of ten reviews the shops are running AIX on Power rather than IBM i on Power. Several factors come into play here. Part of this has to do with logical partitioning (LPAR) being adopted years ago by the technologically savvy IBM i shops, while this technology has only recently become popular in Unix environments. About 70 to 80 percent of Sirius' IBM i customers have virtualized their environments, Staszak estimates. This has led to IBM i server consolidation well ahead of the Unix user base, where server farms proliferated.

The competitive wins that IBM has achieved over its Unix rivals, Oracle and Hewlett-Packard, are also a factor. As those companies turn to IBM for advice, server consolidation and resilient systems are part of the discussion. The boost in processing power offered in Power7 servers has a tendency to make this conversation pick up speed.

Not that this excludes the IBM i customers. Staszak claimed that an IBM i account just recently completed a PAR with Sirius and the calculated savings exceeded $400,000 due to a reduction in total servers and a reduction in maintenance on the hardware and software sides, while a highly available system was put in place.

Although server consolidation plays a big role in these system reviews, it's not the single point of focus. Having a system that can be managed more efficiently goes beyond blowing up server farms.

"Closing the gap between IT service capabilities and current business requirements that include recoverability and availability are important," Staszak says, "but meeting emerging IT services--SLAs and SLOs--are also important. Increased reliability and quality of service, cost control, maintaining or decreasing operating costs while increasing functionality, and decreasing server sprawl are all factors."

Does this mean there will be more consolidations of IBM i and AIX environments on shared servers? It seems likely, but only on rare occasions even though it makes a great amount of sense on paper.

"We are working with a large customer with both AIX and IBM i environments that is trying to determine the best plan for consolidating those environments," Staszak was quick to point out. "Server consolidation is not always feasible. It depends on the network and bandwidth considerations. Having a separate workgroup server at a remote location has its advantages and security issues need to be taken into consideration. In some cases, the environment is already pretty well optimized."

You might wonder if managed services (hosted services) would play a role in some of these PAR discussions, but Staszak says no. "I can't think of an example where a PAR was completed with a recommendation for managed services," he says. Sirius does provide managed services for hardware and software.

About a half a dozen Power Architectural Reviews are being done per quarter, and they are free.

 

by Dan Burger


Read the original at News.

Categories: Blogs Tags:

Articles › When will your IBM i be in the cloud?

April 13th, 2012 Comments off

ITJungle published an article today concerning Connectria hosting IBM i in the cloud for under $500/month.  I now count three (3) vendors that offer hosting environments at this price point:

 

Symmetry Corp (my hosting provider)

 

Abascus LLC

 

Connectria

 

This is great news because progress is being made.  What progress is that?  Well, if you host with these guys you don’t have to deal directly with IBM which takes talent (literally) to navigate efficiently their waters of procurement (I’ve done this three times and hope I never need to buy another machine directly from IBM).

 

What’s more interesting is the companies mentioned in the ITJungle article:

 

Louis Vuitton, Things Remembered, Paramount Studios, ASD, Purolator, Ecko Unlimited, Gulfstream and Ansell Healthcare.  These aren’t small developer shops that were looking for inexpensive hosting as is my case.  Instead these companies have a lot of risk-to-savings research onus by moving to cloud.  Evidently it made dollars and cents.

 

What conversations are being had in your IT dept about putting your IBM i in the cloud?  I couldn’t say it is for everyone, but it is good to know EXACTLY why it isn’t good for you so you can answer that question in a meeting, but also so you can choose to go cloud once that issue has been removed.

 

NEUGC and IBM Cloud

 

While on the subject of cloud… I attended a NEUGC.org conference session given by IBM’er Rob Bestgen and can say without a doubt that IBM is taking cloud seriously - even to the point where they are leading in areas I haven’t even seen on Amazon EC2 or VMWare (i.e. systematic application deployment based on industry specs – more on that later).

 

In my opinion the reality/acceptance/popularity of “cloud” has the ability to make IBM i as prolific and significant as it was in the late 80’s.

 

Why?  Because it enables third parties like Connectria to more easily provide third party IBM i hosting services that can be setup in automated fashion (see this youtube video for how the IBM Virtual Loaner Program works: http://www.youtube.com/watch?v=rXk5t7gYm1c) at a fraction of the cost of acquisition.  The last bit is for IBM to address cloud licensing, which I have been told is a high priority within their walls.

 

The IBM i OS is ready for cloud, but what about everything that sits on top of the OS (i.e. programming languages and programming runtime environments). What, if anything, do we need from RPG to make it even more cloud ready?

 

By Aaron Bartell


Read the original at Articles.

Categories: Blogs Tags: