TechTips / Database


TechTip: Store and Parse JSON Data Natively with DB2 for i PDF Print E-mail
Tips & Techniques - Database
Written by Michael Sansoterra   
Friday, 18 November 2016 00:00

Learn how the latest DB2 for i features can reduce development time when interacting with the popular JSON data format.

Written by Michael Sansoterra

In my prior tip about using JSON with DB2 for i, I articulated a method of accessing JSON with SQL by use of Java external user-defined functions (UDFs) that convert JSON to XML and XML to JSON. Starting in IBM i 7.1 TR10 (Database Group PTF Level 34) and IBM i 7.2 TR2 (Database Group PTF Level 5), IBM has added native JSON support to the DB2 for i database engine. Keep in mind that, at this first release, the JSON support is still considered a "technology preview," so be sure to test any JSON implementations carefully before using them in production. Also, based on available documentation, some of these features and JSON functions are not yet advertised by IBM for the IBM i and may be subject to change.

Add a comment
Last Updated on Thursday, 17 November 2016 11:47
Read more...
 
User Rating: / 2
PoorBest 
TechTip: DB2 for IBM i Services - The Practical PDF Print E-mail
Tips & Techniques - Database
Written by David Shirey   
Thursday, 27 October 2016 23:00

About six months ago, I talked about the relatively new DB2 for i Service tool and why it was pretty nifty. Now, let’s take a closer look at it and see how you actually use it.

david shireyWritten by David Shirey  

As I said in the previous tip on this topic, the DB2 for i Services developed by Scott Forstie’s team and being enhanced with every new technology refresh is another way to investigate what’s happening on your IBM i. Although we’re accustomed to doing this using a variety of very powerful system commands, the DB2 for i Service package provides a fresh, more flexible, and more sophisticated way of digging out this information.

Add a comment
Last Updated on Thursday, 27 October 2016 16:25
Read more...
 
TechTip: DB2 for i Optimization Strategies, Part 6 PDF Print E-mail
Tips & Techniques - Database
Written by Michael Sansoterra   
Thursday, 13 October 2016 23:00

Avoid common SQL programming mistakes that can drag application performance.

Written by Michael Sansoterra

In this final installment of this DB2 for i coding series, I’ll discuss two items. First, I’ll examine a reason why a query that once performed well when it was first written might become lethargic as time passes. Second, I’ll discuss a way to potentially improve the performance of multi-row update statements. In the end, the lessons are how to avoid some common coding flaws that can take the wind out of your database sails.

Add a comment

Last Updated on Wednesday, 12 October 2016 11:16
Read more...
 
TechTip: DB2 11 for z/OS Performance and Tuning Tips PDF Print E-mail
Tips & Techniques - Database
Written by Susan Lawson   
Thursday, 25 August 2016 23: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 15:44
Read more...
 
TechTip: DB2 for i Optimization Strategies, Part 5 PDF Print E-mail
Tips & Techniques - Database
Written by Michael Sansoterra   
Thursday, 11 August 2016 23: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 10:56
Read more...
 
TechTip: How to Prepare for the DB2 10.5 DBA for LUW Upgrade from DB2 10.1 Certification Exam PDF Print E-mail
Tips & Techniques - Database
Written by Roger Sanders   
Thursday, 21 July 2016 23:00

One of the best ways to prepare for any DB2 certification exam is by answering practice questions that are similar to, and that are presented in the same format as, the questions you are likely to encounter when you take the actual exam.

roger sandersWritten by Roger E. Sanders

Editor’s note: This article is adapted from DB2 10.5 DBA for LUW Upgrade from DB2 10.1: Certification Study Notes (Exam 311) by Roger E. Sanders.

 

 A few months after the “IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1” certification exam (Exam 311) was announced, I spent several weeks developing training material that I could use to help individuals prepare for the 311 certification exam. I used the same technique to develop material for that course that I have used to develop my other DB2 certification exam preparation courses and study guides: I carefully reviewed notes I had taken during the exam development process, as well as the questions I wrote for that particular test, and I made sure I covered, in detail, all the objectives that had been defined for that certification exam.

Add a comment
Last Updated on Thursday, 21 July 2016 11:59
Read more...
 
TechTip: DB2 for i Optimization Strategies, Part 4 PDF Print E-mail
Tips & Techniques - Database
Written by Michael Sansoterra   
Thursday, 14 July 2016 23:00

Continue to explore the many ways to improve application queries to reduce the amount of work DB2 for i has to do to process them.

Written by Michael Sansoterra

In the prior tips of this series (1, 2, and 3), there were some general SQL coding guidelines given to avoid giving DB2 for i unnecessary work while doing its job to complete a process or query. This tip continues with more advice from real-world coding encounters.

Add a comment
Last Updated on Thursday, 14 July 2016 18:46
Read more...
 
TechTip: i Illuminate 7.3—Get a Grip PDF Print E-mail
Tips & Techniques - Database
Written by Scott Forstie   
Thursday, 16 June 2016 23:00

Use the Gripping Charm to grasp the possibilities that lie ahead. Read how Scott dodges danger and dementors with DB2 for i spells.

Written by Scott Forstie

Good, you’re back. I was beginning to think that you had encountered some ugly business. After all, there is danger at every turn. For myself, I have been keeping a very public profile since we last spoke to one another. With the rollout of IBM i 7.3, everyone wants to know “What’s New in DB2 for i.” As I do my level best to tell them about the DB2 for i enhancements, I notice that frequently people aren’t fully utilizing the capabilities already at their fingertips. As you’ll read in this episode, an established DB2 for i column-level control will rescue me from an untimely demise.

Add a comment
Last Updated on Thursday, 16 June 2016 23:00
Read more...
 
<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>

Page 1 of 20

WEBCAST

MC Webcast CenterFEATURED WEBCAST

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!

 

TRIAL SOFTWARE

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.

   MC-STORE.COM