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.



mrc Improves m-Power's Interactive Reporting

Today, software developer mrc announces improved interactive reporting within m-Power.

Alliance Key Manager Now Available on IBM Cloud Marketplace

Alliance Key Manager for IBM Cloud provides encryption and key management to help IBM Cloud customers meet data privacy compliance regulations and security best practices.

S4i Express Utilizes the Flexibility of IASPs on iSeries

S4i Systems, Inc. is pleased to announce the latest release of S4i Express, PTF38.

IBM DB2 with BLU Acceleration Pattern V1.2 Delivers Workload Optimization

IBM DB2 with BLU Acceleration Pattern V1.2 enables your online transaction processing (OLTP) database and data mart deployment to a private or public cloud.

Rational Solution for Test Automation V8.6 for Linux

IBM Rational Solution for Test Automation V8.6 delivers new capabilities for mobile and web UI test automation.

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.



Configuring IBM i iSeries Access Server to Use SSL

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


No events

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