Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
IBM DB2 9.7 Advanced Administration Cookbook

You're reading from   IBM DB2 9.7 Advanced Administration Cookbook Over 100 recipes focused on advanced administration tasks to build and configure powerful databases with IBM DB2 book and ebook

Arrow left icon
Product type Paperback
Published in Feb 2012
Publisher Packt
ISBN-13 9781849683326
Length 480 pages
Edition 1st Edition
Tools
Arrow right icon
Toc

Table of Contents (21) Chapters Close

IBM DB2 9.7 Advanced Administration Cookbook
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
1. DB2 Instance—Administration and Configuration FREE CHAPTER 2. Administration and Configuration of the DB2 Non-partitioned Database 3. DB2 Multipartitioned Databases—Administration and Configuration 4. Storage—Using DB2 Table Spaces 5. DB2 Buffer Pools 6. Database Objects 7. DB2 Backup and Recovery 8. DB2 High Availability 9. Problem Determination, Event Sources, and Files 10. DB2 Security 11. Connectivity and Networking 12. Monitoring 13. DB2 Tuning and Optimization 14. IBM pureScale Technology and DB2 Index

Configuring network communications


Nowadays, almost every organization is using a server/client model for accessing data stored in a central location. In order to communicate with a server, clients must use network communication protocols recognized by the servers to perform inbound requests. The configuration of the communication stack used by the database servers, necessary to establish connections from clients, is the main subject of the following recipe.

Getting ready

In this recipe, we'll create a new instance db2inst3 and configure the communication protocol (TCP/IP) and ports by using the command line and Control Center.

How to do it...

  1. Create the fenced user, db2fenc3:

    [root@nodedb21 instance]# useradd db2inst3 -g db2iadm1
    [root@nodedb21 instance]#
    
  2. Create to be a fenced user for instance db2inst3:

    [root@nodedb21 home]# useradd db2fenc3 -g db2iadm1
    [root@nodedb21 instance]#
    
  3. Set password identical to the username for both users.

  4. Create instance db2inst3:

    [root@nodedb21 ~]# /opt/ibm/db2...
lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime