TechTip: DB2 11 for z/OS Performance and Tuning Tips PDF Print E-mail
Tips & Techniques - Database
Written by Susan Lawson   
Friday, 26 August 2016 00:00

Raise or lower the priority of a workload as needed to meet user-specified goals.

susan lawsonWritten by Susan Lawson

This article is an excerpt from chapter 6, “Performance and Tuning,” of DB2 11 for z/OS Database Administration: Certification Study Guide (Exam 312).


Using z/OS Workload Manager (WLM), you can set z/OS performance options for DB2. With WLM, you define performance goals and assign a business importance to each goal. The goals for work are defined in business terms, and the system decides how much resource, such as CPU and storage, to give to the work to meet its goal.


WLM controls the dispatching priority based on the user-supplied goals. It raises or lowers the priority as needed to meet the specified goal. Thus, you need not fine-tune the exact priorities of every piece of work in the system and can focus instead on business objectives.

Add a comment

Last Updated on Wednesday, 24 August 2016 16:44
TechTip: C# for RPGers: Not All Strings Are Born Equal PDF Print E-mail
Tips & Techniques - Programming
Written by Rafael Victoria-Pereira   
Friday, 26 August 2016 00:00

This time around, I’ll explain a very important object-oriented (OO) concept and some neat things you can do with a string in C# using a new type of object: StringBuilder.

rafael victoria preiraWritten by Rafael Victória-Pereira

If you haven’t read the last couple of TechTips, here’s what I’ve talked about: I introduced strings as a slightly different data type (a complex one, when compared to the simple data type presented before) and showed how to extract characters from it using a method called “substring.” Substring is very similar to an RPG BIF, but it’s a part of the string object, not a standalone function. Strings are objects and have “internal BIFs,” called “methods.” Some are similar to the RPG BIFs you know; others are something totally different.

Add a comment
Last Updated on Tuesday, 16 August 2016 16:11
TechTip: DB2 Adapter for Shells PDF Print E-mail
Tips & Techniques - Scripting
Written by Aaron Bartell   
Friday, 12 August 2016 00:00

aaron bartellIf you're anything like me, you want to participate in the open-source community but don't want to screw things up. I invite you to participate in a safer side of open source.

Written by Aaron Bartell

In the past couple of articles (1 and 2), I've focused on higher-level community musings. I did this to encourage engagement and convey where engagement is already taking place. In short, open source on IBM i is growing significantly faster than it has in the past.


Now it's time to dive back into some geekier topics.

Add a comment
Last Updated on Friday, 12 August 2016 00:00
TechTip: DB2 for i Optimization Strategies, Part 5 PDF Print E-mail
Tips & Techniques - Database
Written by Michael Sansoterra   
Friday, 12 August 2016 00:00

Learn how to take an ax to common suboptimal SQL programming practices.

Written by Mike Sansoterra

This series is almost done, yet there are so many illustrations of potential code improvements to offer to the DB2 for i development community. This tip discusses possible performance improvements when replacing legacy cursors with set operations and when using temporary tables. See the references at the end of this tip for links to prior tips in this series.

Add a comment
Last Updated on Thursday, 11 August 2016 11:56
TechTip: Take Open-Source ILE Further PDF Print E-mail
Tips & Techniques - Programming
Written by Liam Allan   
Friday, 05 August 2016 00:00

In this TechTip, I’ll talk about what it takes to be part of the open-source ILE community, as well as what ILE content is available today.

Written by Liam Allan

Hi, everyone! This is my first article on MC Press, with many more to follow hopefully. My name is Liam Allan, and I am only 19 years young. I’ve been working with the IBM i platform since 2014 (when I was 17), and I mainly focus on RPG in my career, but I love to dabble in anything ILE and PASE in my own time. I enjoy developing open-source software (OSS) for people to use on IBM i, and I also love helping people learn about open source and how it can benefit them.

Add a comment
Last Updated on Friday, 05 August 2016 00:00
User Rating: / 4
TechTip: C# for RPGers—Learn More About C#’s Methods and Properties PDF Print E-mail
Tips & Techniques - Programming
Written by Rafael Victoria-Pereira   
Friday, 29 July 2016 00:00

In the previous TechTip, I showed you a couple of string methods, which were somewhat similar to RPG BIFs. This time, I’ll show you how to discover what’s available and introduce a couple of object-oriented languages concepts.

Written by Rafael Victória-Pereira

rafael victoria preiraStart firing up Visual Studio, because this is going to be a hands-on TechTip! I’ll explain a few more string methods, so that you can get familiar with the way Visual Studio can help you choose the right tool for the job, or, in other words, the right method for the job.


If you haven’t been following this series, go back to the previous TechTip and copy-paste the full code to a new Console Application project. This TechTip from earlier in this series explains how it’s done.

Add a comment

Last Updated on Friday, 29 July 2016 00:00
TechTip: Evolutionary Change and the IBM i Developer PDF Print E-mail
Tips & Techniques - Career
Written by Rick Flagler   
Friday, 29 July 2016 00:00

Dont fight evolution! Adopt new stuff!

rick flaglerWritten by Rick Flagler

The topic of this article resulted from several recent events:


  • The June anniversary of the AS/400 launch and its 27th birthday
  • A television campaign by a national cable provider regarding ability to CHANGE
  • Debate about RDi vs. SEU concurrent with developer comments that IT managers wont spring for RDi because of its expense in the IT budget
  • Recently released totally free-format RPG programming techniques
Add a comment
Last Updated on Friday, 29 July 2016 09:40
TechTip: IBM i Access Client Solutions Update PDF Print E-mail
Tips & Techniques - System Administration
Written by Steve Pitcher   
Friday, 22 July 2016 00:00

Integrated File System support leads the way with this important new update.

steve pitcherWritten by Steve Pitcher

As of today, there’s a new version of the highly popular IBM i Access Client Solutions (ACS) product. If you’ve already downloaded the April version of ACS, you can easily upgrade using the new Check for Updates feature underneath the Help option in the title bar. Otherwise, click here and download the latest version. If you want all the ODBC features, those are included in two separate Application Package downloads (one for Windows, one for Linux) found on the IBM ESS website.

Add a comment
Last Updated on Monday, 25 July 2016 10:08
<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>

Page 1 of 198



See What i Can Do With Modern RPG Development

Your applications deserve more than just a new look! Change the perception of the IBM i as “old” with modern development tips from IBM and Profound Logic Software.
Watch as Barbara Morris, Brian May and Alex Roytman dive beneath the GUI surface to show the benefits of:


  • Working with free-format RPG in IBM i TR7
  • Breaking free from “The Cycle” of traditional RPG development
  • Going beyond the 10 character limit in display and database files
  • And more!

You'll also see a live demonstration of these techniques as the presenters create a modern web application before your eyes! 


Watch the Webinar Now!



MS Office Connector for Query/400

NGS' Qport Office enables Windows users to run IBM Query/400 queries to: 

 - Create and update Excel spreadsheets and Access databases

 - Create Word documents

 - Send to Windows screen and PC printers

No query conversion is required. Works with i5/OS V5R1 & above. Installs in minutes!

If you don’t have a budget to replace IBM Query/400, but want your users to have one click enhanced output of their queries.… Request the online license agreement and product download instructions today!

Offer good through December 31, 2013.