MC Systems Insight
MC Power Technology Manager
MC RPG Developer
MC Power Developer
MC TNT Tips 'n Techniques
MC AIX Expert
MC Linux Expert
MC Mobile on Power
This Week @ the MC Press Bookstore

August 12, 2015 | Volume 10 Issue 8


TOP STORY: Configuring the DB2 System Environment
FEATURED NEWS: IBM Cloud Orchestrator V2.5 Helps Enterprises Achieve the Speed and Flexibility of Hybrid Cloud
NEWS HIGHLIGHT: IBM PureApplication System W3700 and IBM PureApplication Software V2.1.1 Support IBM Power 8 Servers
MC PRESS BOOKSTORE: Top Selling Titles
EVENT: Security Alert: Expert Uncovers the “Dirty Little Secret” of IBM i Security

Sponsor - The MC Press Bookstore

Become a certified DBA. Take on Exams 611 (DB2 10.1) and 311 (DB2 10.5) with this comprehensive 1,248-page book. This valuable resource is much more than a typical study guide. You’ll gain a deep understanding of DB2 server management, physical design, business rules implementation, activity monitoring, utilities, high availability, security, and connectivity and networking. It’s all the fundamentals plus valuable author insight. Includes 50+ step-by-step DB2 feature implementation procedures and 400+ practice questions with detailed answers. Order Today!


Feature Article - Database
Configuring the DB2 System Environment

Master all aspects of IBM DB2 database administration and prepare to take and pass IBM's Certification Exams 611 and 311: Certified Database Administrator.

mohan saraswatipuraWritten by Mohankumar Saraswatipura and Robert (Kent) Collins

Editor's note: This article is an excerpt from the new book DB2 10.1/10.5 for Linux, UNIX, and Windows Database Administration (Exams 611 and 311): Certification Study Guide.


During normal operation, the DB2 database manager's behavior is controlled, in part, by a collection of values that defines the DB2 operating environment. Some of these values are operating system environment variables, and others are special DB2-specific system-level values known as environment or registry variables. Registry variables provide a way to centrally control the database environment. Four different registry profiles are available, and each controls the database environment at a different level. The registry profiles are as follows:


Sponsor - The MC Press Bookstore

Get the latest and greatest advice from the DB2 for z/OS gurus! DB2 11: The Ultimate Database for Cloud, Analytics, and Mobile provides essential advice and explanations to ensure a successful upgrade--including feedback from early customer experiences. This book describes new DB2 11 features that can help you respond cost-effectively to the data explosion resulting from mobile applications, cloud computing, social media, and smart devices. Understand the new functions in DB2 11, plan your migration strategy, and learn about important new support for application compatibility. Get your copy today!


Featured News
IBM Cloud Orchestrator V2.5 Helps Enterprises Achieve the Speed and Flexibility of Hybrid Cloud

IBM Cloud Orchestrator is a cloud management platform, based on OpenStack, that automates the delivery and lifecycle management of cloud services in hybrid environments.


Sponsor - The MC Press Bookstore

Have you heard? RPG is now fully free-format! This latest edition from RPG expert Jim Martin is your one-stop resource for free-format information. It’s a must-read for all RPG programmers, featuring completely updated code. See the new H, F, D and P specs in action in this easy-to-use reference guide. You’ll learn rules and syntax but also grasp how this modern style of coding can improve your overall productivity--from initial development through maintenance. Get your copy today!


Most Popular MC Press Titles

Best-Selling MC Press Titles

  1. IBM i Security Administration and Compliance
  2. Free-Format RPG IV
  3. RPG TnT
  4. Database Design and SQL for DB2
  5. Mastering IBM i
  6. Flexible Input, Dazzling Output with IBM i
  7. Advanced Guide to PHP on IBM i
  8. The Modern RPG IV Language
  9. DB2 10 for z/OS Database Administration (Exam 612)
  10. DB2 10.1 Fundamentals (Exam 610)


In the News

Vendors:  Have a press release to share?  Send it to MC Press.

The Latest from IBM

Support MC Press - Visit Our Sponsors

Forums Sponsor



Search Sponsor