Understanding DB2 Object Privileges, Part 3

In the final installment of this three-part series, learn about DB2's system, server, nickname, and variable privileges plus several more.

roger sandersWritten by Roger E. Sanders

Editor's note: This article is an excerpt from the book DB2 10.1 Fundamentals: Certification Study Guide


In DB2 for Linux, UNIX, and Windows and DB2 for z/OS, object privileges convey the right to perform certain actions against specific database objects. Part 1 of this series reviewed DB2's authorization ID, buffer pool, table space, storage group, schema, table, view, and index privileges. Part 2 of this series reviewed DB2's sequence, distinct type, function, procedure, routine, collection, package, and plan privileges. In this article, we conclude our discussion of DB2 object privileges by examining the remaining privileges available to control user interactions with DB2 objects.

DR Strategy Guide for IBM i

Don't wait for a disaster. Start planning today.

Written by Maxava

Editor's note: This article introduces the white paper DR Strategy Guide for IBM i available free from the MC White Paper Center.


Organizations cannot control whether or not they will be affected by a natural disaster, extended power outage or any other unplanned incident. However, they can ensure their business is prepared to respond to and recover from these events with minimal disruption or impact to their customers.


These types of events disrupt business operations, and they all have the potential to cripple a business if a supporting contingency plan is not in place. So what happens after the worst-case scenario becomes a very real disaster situation? Your business is in a crisis. Can you rely on past practices or processes? Common Disaster Recovery framework is a classic risk management mistake that will impact your organization in both reputation and bottom line. The industry is riddled with numerous failed efforts resulting from monolithic Disaster Recovery implementations.

TechTip: Make a Switch with Printer Job Language (PJL)

Do you like printing stuff? Or doing things for other people who like to print stuff? Then this tip might be just what you need, especially if you like doing complex things with your prints.

david shireyWritten by David Shirey

I'm just going to say this up front and be done with it. I don't like printers. Never have, never will. I think it dates back to the days when we had the big line printers and I was never able to get the paper lined up to suit Gloria, the night operator. It shouldn't have mattered, but I was younger then and she was hot. I have my pride. It just always seemed to me that printers were the perfect demonic combination of electronics and mechanical gears. But that's my problem, not yours.

Partner TechTip: How SEQUEL Handles Big Data

Big data: A big opportunity to improve business.
mike stegemanWritten by Mike Stegeman

Big data is one of the biggest buzzwords in IT right now. A lot of companies are clamoring to set up advanced analytics tools and establish business processes that help them make sense of the troves of information now passing through their systems. The goal? To improve decision-making and be in a good position to respond to changing conditions.

Is 2014 the Internet's Last Good Year?

Without our input, the Internet's fate is left to the whim of career politicians, lobbyists, and marketing departments.

roger penceWritten by Roger Pence

The destiny of the Internet as we know it today hangs on the fate of Net neutrality. I'll dig into some of the basics of Net neutrality in this article (with mostly fact but a few closing opinions), but before that, let's go back in time.



IBM InfoSphere Information Server Offers Unlimited Users and Simplifies Metric Counting Rules

Effective July 24, 2014, select IBM InfoSphere Information Server products will be offered under a new set of prices and pricing metrics that deliver greater value and flexibility to IBM clients.

Cognos Business Intelligence V10.2.1 Delivers Additional Chargeable Component Features

IBM Cognos Business Intelligence V10.2.1 provides the following new features to give you visibility into your businesses' past, present and future performance.

DRV Technologies Releases 6.0 of the DRV FlexTool Solutions Suite

DRV Technologies, Inc., the developer of FlexTools report management, electronic forms and MICR laser checks software, report writer / query tool, and system monitoring for the IBM i, iSeries, and AS/400, has announced the release of FlexTools V6.0 which is the DRV suite of solutions including SpoolFlex, FormFlex, Secure Checks, DBXFlex and MessageFlex.

Townsend Security Brings Two Factor Authentication to Leading IBM i Security Solutions

With mobile-based two factor authentication, Townsend Security offers customers an additional control to protect core security solutions from un-authorized access due to compromised credentials.

RPG Can Now Directly Access Mobile Device Functionality Using LANSA's aXes Mobile App

Making all smartphone and tablet functions, such as camera, video, voice and barcoding, available to your existing 5250 applications will take your IBM i modernization efforts to the next level.

HelpSystems Announces File Event Monitoring for Libraries, Directories, IFS

New features in Robot/SCHEDULE version 12 enhance job schedule flexibility and control with event-based dependencies and improved reporting.



Configuring IBM i iSeries Access Server to Use SSL

To see a list of all the MC Press videos, click here


Wed Jul 30 @13:00 - 02:00PM
IFS Security: Don’t Leave Your Server Vulnerable

Events Calendar

July 2014
29 30 1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30 31 1 2



Take Your PHP Skills to the Next Level


>> NEW BOOK:  Advanced Guide to PHP on IBM i




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.


Latest Titles >>

eBook Special >>



Shop the MC Press Store