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
IBM DB2 9.7 Advanced Administration Cookbook
IBM DB2 9.7 Advanced Administration Cookbook

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

eBook
$29.99 $42.99
Paperback
$70.99
Subscription
Free Trial
Renews at $19.99p/m

What do you get with Print?

Product feature icon Instant access to your digital eBook copy whilst your Print order is Shipped
Product feature icon Paperback book shipped to your preferred address
Product feature icon Download this book in EPUB and PDF formats
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
OR
Modal Close icon
Payment Processing...
tick Completed

Shipping Address

Billing Address

Shipping Methods
Table of content icon View table of contents Preview book icon Preview Book

IBM DB2 9.7 Advanced Administration Cookbook

Chapter 1. DB2 Instance—Administration and Configuration

In this chapter, we will cover:

  • Creating and configuring instances for non-partitioned environments

  • Creating and configuring a client instance

  • Creating and configuring instances for multipartitioned environments

  • Starting and stopping instances

  • Configuring SSL for client-server instance communication

  • Listing instances

  • Attaching to instances

  • Dropping instances

Introduction


The main focus of this chapter is DB2 instance creation and configuration, for non-partitioned database and for multipartitioned database environments.

Creating and configuring instances for non-partitioned environments


A DB2 instance can be defined as a logical container or as a logical context for databases. It can also be described as a layer between DB2 software binaries, a database, and its objects. Also it provides a level of isolation between databases; for example, it is possible to have two or more databases on the same environment, with the same name, but under different instances. It also provides and ensures the communication layer between clients and databases.

Getting ready

For this recipe (and almost all recipes in this book), we will use two servers running Red Hat Enterprise Linux Server x64 release 5.5 (Tikanga), named nodedb21 and nodedb22. The hostnames are optional, but our recommendation is to set up an identical environment to avoid confusion during reading and applying the recipes.

As install location for the IBM DB2 9.7 Enterprise Server Enterprise software product, we will use the directory /opt/ibm/db2/V9.7 on nodedb21. On nodedb22, we will install DB2 Client software to location /opt/ibm/db2/V9.7_clnt. The instance owner will be db2inst1 on nodedb21 and db2clnt1 as client instance owner on nodedb22. Also, on nodedb21, we will create a second instance owner user named db2inst2, to demonstrate how to create an instance manually.

How to do it...

The default method to create an instance is during the IBM DB2 9.7 Enterprise Server Edition software installation. The other possible option is to use the db2icrt command.

In Linux and Unix, every instance is created under a dedicated user, called the instance owner. To create an instance in Linux and UNIX you have to be the root user; on these platforms, we are limited to one instance per user. On Microsoft Windows platforms, you may have more than one instance created under the same user.

Usually, if you set up the software in graphical mode you do not have to create the users manually—you can do this using the wizard. In our recipes, we want to reuse the same groups (db2iadm1 and db2fadm1) for the non-partitioned and the multipartitioned instance and database setup. For the multipartitioned setup we will have the same groups defined on both servers; because we have to deal with security regarding permissions, here, we should create the groups with the same group ID (GID):

  1. Create primary groups with the same GID on both servers:

    	[root@nodedb21 ~]# groupadd -g 1103 db2iadm1
    	[root@nodedb21 ~]# groupadd -g 1102 db2fadm1
    	[root@nodedb21 ~]#
    	[root@nodedb22 ~]# groupadd -g 1103 db2iadm1
    	[root@nodedb22 ~]# groupadd -g 1102 db2fadm1
    	[root@nodedb22 ~]#
    

    Tip

    Downloading the example code

    You can download the example code files for all Packt books you have purchased from your account at http://www.packtpub.com. If you purchased this book elsewhere, you can visit http://www.packtpub.com/support and register to have the files e-mailed directly to you.

  2. Run db2setup from the IBM DB2 9.7 Enterprise Server Edition software installation kit.

    Note

    Instance owner user db2inst and fenced user db2fenc will be created during installation. The groups db2iadm1 and db2fadm1 will automatically fill in on the screen.

  3. To create a new instance during the installation with db2setup in graphical mode, navigate through configuration steps 1 to 6 and, at step 7 you will find Create a DB2 instance option checked; this is the default option.and let as it is.Click Next.

  4. At step 8—Partitioning options—you will find Single partition instance option checked ; this is the default option and let as it is. Click Next and finalize installation. If installation was successful, we have a new instance named db2inst1 created.

    Another way to create an instance is to use the db2icrt command. This method is suitable in the case that you install the DB2 software with db2_install (manual installation), or that you do not check the Create a DB2 instance option during installation with db2setup. Other scenarios would be if you drop an instance and want to create a new one, or if you want to create an additional instance.

  5. As mentioned previously, in Linux and Unix, every instance has to be created under an instance owner user. As a root user, we will create the user db2inst2 as instance owner and db2fenc2 as fenced user; set passwords identical to the individual usernames:

    	[root@nodedb21 ~]# useradd -g db2iadm1 db2inst2
    	[root@nodedb21 ~]# useradd -g db2fadm1 db2fenc2
    	[root@nodedb21 ~]# passwd db2inst2
    	Changing password for user db2inst2.
    	New UNIX password:
    	Retype new UNIX password:
    	passwd: all authentication tokens updated successfully.
    	[root@nodedb21 ~]# passwd db2fenc2
    	Changing password for user db2fenc2.
    	New UNIX password:
    	Retype new UNIX password:
    	passwd: all authentication tokens updated successfully.
    	[root@nodedb21 ~]#
    
  6. At this step, set the communication protocol to TCP/IP. The instance communication protocol is set up using the DB2COMM variable. We can set this variable no protocol managers will be started and will lead to communication errors at the client side.

    	[db2inst2@nodedb21 ~]$ db2set DB2COMM=TCPIP
    	[db2inst2@nodedb21 ~]$
    
  7. Next, as user root, edit /etc/services and add db2c_db2inst2 50002/tcp entry (highlighted in bold in the listing bellow). Port 50002 will be assigned to db2inst2 instance. Port 50001 corresponds to the db2c_db2inst1 service name and was added at db2inst1 instance creation. Port names prefixed with DB2 are reserved for inter-partition communication, a subject that we're going to discuss later on.

    	db2c_db2inst1   50001/tcp
    	DB2_db2inst1    60000/tcp
    	DB2_db2inst1_1  60001/tcp
    	DB2_db2inst1_2  60002/tcp
    	DB2_db2inst1_END        60003/tcp
    	db2c_db2inst2 50002/tcp
    

    Note

    If you choose to use only port numbers for SVCENAME database manager parameter you do not need to edit this file.

  8. As root user, create instance db2inst2, using the previously created users as instance owner and fenced user:

    [root@nodedb21.~]# /opt/ibm/db2/V9.7/instance/db2icrt -a SERVER ENCRYPT -p db2c_db2inst2 -u db2fenc2 db2inst2
    DBI1070I  Program db2icrt completed successfully.
    [root@nodedb21 ~]#
    

    We need to explain a little bit about the options used for creating instance db2inst2:

    • The –a option indicates the authentication type; the default is SERVER. Using the –a option, the following authentication modes are available: SERVER, CLIENT, and SERVER ENCRYPT. We may change it later by modifying the AUTHENTICATION or the SRVCONN_AUTH instance parameter.

    • The –u switch is used to set the fenced user.

    • The –p option is used to specify the port or its corresponding service name used for client communication, as defined in /etc/services. The port or service name may be changed later by modifying the SVCENAME database manager parameter

    • For MS Windows platforms, we don't have the –a option to specify the authentication mode. The –p option in Windows has a different meaning; it is used to specify the instance profile. The –u option is for specifying the account name and password used that will be included in the Windows service definition associated with the instance.

Note

To use the Control Center for managing an instance locally or remotely, you need to have DB2 Administration Server (DAS) up and running, on the server.

To check the status of DAS, execute the following command, as DAS owner user, which is in our case dasusr1:

[dasusr1@nodedb21 ~]$ db2dascfg get dasstatus

ACTIVE

[dasusr1@nodedb21 ~]$

Usually, it is installed and created during IBM DB2 software installation. If there is no DAS created, you should create it using the dascrt command. The steps are similar to those for creating an instance—create a group and a user. It has to be created by specifying the owner.

For example, /opt/ibm/db2/V9.7/instance/dascrt –u dasusr1.

How it works...

In Linux or Unix, when an instance is created, the db2icrt command builds up under the instance owner home directory, the sqllib directory, as a collection of symbolic links pointing to the IBM DB2 software installation home directory. If you want to see what is executing db2icrt in the background, you need to include the –d option to enable debug mode. This explains what happens behind the scenes for the steps mentioned earlier. Usually, this switch is used for detailed diagnostics, and should be activated at the request of IBM support.

Almost all files and directories from sqllib directory are symbolic links to the corresponding installation path (DB2HOME). A short listing inside sqllib directory looks like this:

[db2inst1@nodedb21]/home/db2inst1/sqllib>symlinks -v .
other_fs: /home/db2inst1/sqllib/map -> /opt/ibm/db2/V9.7/map
other_fs: /home/db2inst1/sqllib/bin -> /opt/ibm/db2/V9.7/bin
other_fs: /home/db2inst1/sqllib/ruby64 -> /opt/ibm/db2/V9.7/dsdriver/ruby64

On MS Windows platforms, the db2icrt command creates a service. The binaries are actually copied and a service associated with the instance is created.

On a generic Windows machine we'll create an instance named db2win. Initially, the associated service has the status set to stopped and the startup type set to manually. If you want the service to start automatically at system boot, you have to change its startup type to automatic.

To create instance db2win, execute the following command under a privileged user:

C:\Windows\system32>db2icrt db2win
DB20000I  The DB2ICRT command completed successfully.

To find the associated Windows service with db2win instance, execute the following command:

C:\Windows\system32>sc query state= all  | findstr "DB2WIN"
SERVICE_NAME: DB2WIN
DISPLAY_NAME: DB2 - DB2COPY1 - DB2WIN
C:\Windows\system32>

There's more...

The db2isetup graphical tool might be used also for creating instances; this tool is available only on the Linux and Unix platforms.

On Linux and Unix you have the possibility to create a non-root type instance using the installer. You are limited to only one non-root instance per server.

Updating instances using the db2iuptd command

Usually this command is used to update an instance after an upgrade to a higher version, or migrate an instance from a lower product level such as Workgroup Edition to Enterprise Edition. Also it might be used for instance debug using the –d option. Like db2icrt, this command has its own particularities on MS Windows operating systems. To find the available options and related descriptions of this command issue db2iuptd –h. For non-root type instances exists a variant of this command named db2nruptd.

Creating and configuring a client instance


Usually, this special type of instance is used for cataloging nodes and databases to which you want to connect using this client. Compared to server instances there are some limitations, as it cannot be started or stopped, and you cannot create databases under it. Mainly, it is used by the DB2 Client and DB2 Connect products.

Getting ready…

On nodedb22 we will create the instance owner db2clnt1 and fenced user named db2fenc1. For creating a client instance, we'll use the –s option of the db2icrt command.

How to do it…

  1. Install DB2 Client in the /opt/ibm/db2/V9.7_clnt location on nodedb22, without creating an instance; to do this during installation, check at step 6—Instance setupDefer this task until after installation is complete.

  2. Next, create users on nodedb22db2clnt1 as the client instance owner and db2fenc1 as fenced user—and set passwords identical to the usernames:

    	[root@nodedb22 ~]# useradd -g db2iadm1 db2clnt1
    	[root@nodedb22 ~]# useradd -g db2fadm1 db2fenc1
    	[root@nodedb22 ~]# passwd db2clnt1
    	Changing password for user db2clnt1.
    	New UNIX password:
    	Retype new UNIX password:
    	passwd: all authentication tokens updated successfully.
    	[root@nodedb22 ~]# passwd db2fenc1
    	Changing password for user db2fenc1.
    	New UNIX password:
    	Retype new UNIX password:
    	passwd: all authentication tokens updated successfully.
    	[root@nodedb22 ~]#
    
  3. As user root, create the client instance db2clnt1:

    [root@nodedb22 ~]# /opt/ibm/db2/V9.7/instance/db2icrt -s client -u db2fenc1 db2iclnt1
    DBI1070I  Program db2icrt completed successfully.
    [root@nodedb22 ~]#
    

How it works...

Mainly you need to setup a client instance when you have plans to administer DB2 servers remotely with tools that are using non-Java based connections such as Control Center or Toad for DB2. The same scenario is applicable when you are using CLI for remote administration or command execution and also in this category are non-java based application clients.

There's more...

In the previous section we used the term non-java clients. However, this not totally exact for older type JDBC or JDBC-ODBC bridge connections using type 1 and 2 drivers. Type 3 and 4 JDBC drivers have implemented internally the entire network communication stack; this is the main reason for their independence from client instances and external network libraries. A good example for a tool that is relying only on JDBC type connections is the new Optim Database Administrator recommended by IBM to be used in future for database administration.

See also

The Communication with DRDA servers (z/OS and i/OS) recipe in Chapter 11, Connectivity and Networking

Creating and configuring an instance for multipartitioned environments


The IBM DB2 database multipartitioned feature offers the ability to distribute a large database onto different physical servers or the same SMP server, balancing the workload onto multiple databases that are working as one, offering a very scalable way of data processing. We may have all the database partitions reside on the same server, this method of database partitioning is called logical partitioning. There is another scenario when the database partitions are spanned on different physical servers; this partitioning method is called physical partitioning.

An instance in a multipartitioned configuration is not very different by a non-partitioned instance, if it is running on a logical partitioning scheme. To use only physical partitioning, or physical partitioning combined with logical partitioning, an instance must be configured as shared across all the database partitions. In this recipe, we will use the last scenario.

The instance is created once on one node; on the other participant nodes, you have to create just the instance owner user with the same user ID (UID) and GIDs and the same home directory as on the instance owner node. In the following recipe, we will configure servers for the purpose of multipartitioning and will create a new instance named db2instp.

Notice that in this recipe we will use node and partition termsinterchangeably

Getting ready

To install a multipartitioned instance, we need to prepare a suitable environment. For this recipe, we will use the two Linux servers named nodedb21 and nodedb22, mentioned before. nodedb21 will contain the instance home and will export it through NFS to the nodedb22 system. We will also use a new disk partition, defined on nodedb21, for instance home /db2partinst, which, in our case, is a Linux LVM partition. We will create users on both servers with the same UID, and will install IBM DB2 ESE in a new location or DB2HOME—/opt/ibm/db2/V9.7_part on nodedb21 with the create a response file option. On nodedb22, we'll also install IBM DB2 ESE, in the location /opt/ibm/db2/V9.7_part, using the response file created during installation on nodedb21.

How to do it...

  1. Because this is not a Linux book, we do not cover how to install NFS or how to create a new Linux partition. As a preliminary task, you should check if you have NFS and portmap installed and running on both servers.

  2. As user root, execute the following commands on both servers:

    To check if we have NFS and portmap on nodedb21:

    	[root@nodedb21 ~]# rpm -qa | grep nfs
    	nfs-utils-lib-1.0.8-7.6.el5
    	nfs-utils-1.0.9-44.el5
    	[root@nodedb21 ~]# rpm -qa | grep portmap
    	portmap-4.0-65.2.2.1
    	[root@nodedb21 ~]#
    

    To check their current status on nodedb21:

    	[root@nodedb21 ~]# service nfs status
    	rpc.mountd (pid 3667) is running...
    	nfsd (pid 3664 3663 3662 3661 3660 3659 3658 3657) is running...
    	rpc.rquotad (pid 3635) is running...
    	[root@nodedb21 ~]#
    	[root@nodedb21 ~]# service portmap status
    	portmap (pid 3428) is running...
    	[root@nodedb21 ~]# 
    

Set up NFS for sharing the instance home

  1. To automatically export /db2partinst on system boot, add your hostnames or the corresponding IP numbers to the /etc/exports file. On nodedb21, add the following line in /etc/exports:

    	/db2partinst       10.231.56.117(rw,no_root_squash,sync) 10.231.56.118(rw,no_root_squash,sync) 
    
  2. To export the partition immediately, execute the following command:

    	[root@nodedb22 ~]# exportfs –ra
    	[root@nodedb22 ~]#
    
  3. On nodedb22, as user root, create a directory /db2partinst, used as mount point for /db2partinst, exported from nodedb21:

    	[root@nodedb22 ~]# mkdir /db2partinst
    	[root@nodedb22 ~]#
    
  4. In /etc/fstab on nodedb22, to mount /db2partinst on system boot, add the following line:

    	nodedb21:/db2partinst /db2partinst nfs rw,timeo=300,retrans=5,hard,intr,bg,suid
    
  5. To mount the partition immediately on nodedb22, issue the following command:

    	[root@nodedb22 ~]# mount nodedb21:/db2partinst /db2partinst
    	[root@nodedb22 ~]#
    

Creating the instance owner and fenced user

  1. On nodedb21, create the instance owner db2instp and the fenced user db2fencp. Instance home will be located in /db2partinst/db2instp:

    [root@nodedb22 ~]# useradd -u 1316 -g db2iadm1 -m -d /db2partinst/db2instp db2instp
    [root@nodedb22 ~]# useradd -u 1315 -g db2fadm1 -m -d /db2partinst/db2fencp db2fencp
    [root@nodedb22 ~]# passwd db2instp
    Changing password for user db2instp.
    New UNIX password:
    Retype new UNIX password:
    passwd: all authentication tokens updated successfully.
    [root@nodedb21 ~]# passwd db2fencp
    Changing password for user db2fencp.
    New UNIX password:
    Retype new UNIX password:
    passwd: all authentication tokens updated successfully.
    [root@nodedb21 ~]#
    
  2. Repeat step 1 on nodedb22 and ignore any warnings.

Set up SSH for client authentication

In a physical multipartitioned environment, any instance owner user has to be able to execute commands on any participant node. To ensure this, we need to establish user equivalence or host equivalence between nodes. Actually, we have two methods: one is with RSH, which is less secure and the other is using SSH, which is secure. With SSH, there are two methods: one is host-based authentication and the other is client-based authentication. Next, we will implement client-based authentication; this method fits better with a small number of partitions, as in our example.

  1. As user db2instp on nodedb21, execute the following commands:

    [db2instp@nodedb21 ~]$ cd ~
    [db2instp@nodedb21 ~]$ mkdir .ssh
    [db2instp@nodedb21 ~]$ chmod 700 .ssh
    [db2instp@nodedb21 ~]$ cd .ssh
    [db2instp@nodedb21 .ssh]$ ssh-keygen -t rsa
    Generating public/private rsa key pair.
    Enter file in which to save the key (/db2partinst/db2instp/.ssh/id_rsa): Enter passphrase (empty for no passphrase):
    Enter same passphrase again:
    Your identification has been saved in /db2partinst/db2instp/.ssh/id_rsa.
    Your public key has been saved in /db2partinst/db2instp/.ssh/id_rsa.pub.
    The key fingerprint is:
    2b:90:ee:3b:e6:28:11:b1:63:93:ba:88:d7:d5:b1:14 db2instp@nodedb21
    [db2instp@nodedb21 .ssh]$ cat id_rsa.pub >> authorized_keys
    [db2instp@nodedb21 .ssh]$ chmod 640 authorized_keys
    
  2. As user db2instp on nodedb22, execute the following commands:

    [db2instp@nodedb22 .ssh]$ cd ~/.ssh
    [db2instp@nodedb22 .ssh]$ ssh-keygen -t rsa
    Generating public/private rsa key pair.
    Enter file in which to save the key (/db2partinst/db2instp/.ssh/id_rsa):
    /db2partinst/db2instp/.ssh/id_rsa already exists.
    Overwrite (y/n)? y
    Enter passphrase (empty for no passphrase):
    Enter same passphrase again:
    Your identification has been saved in /db2partinst/db2instp/.ssh/id_rsa.
    Your public key has been saved in /db2partinst/db2instp/.ssh/id_rsa.pub.
    The key fingerprint is:
    87:36:b4:47:5a:5c:e5:3e:4e:e9:ce:5b:47:2c:ce:6b db2instp@nodedb22
    [db2instp@nodedb22 .ssh]$ cat id_rsa.pub >> authorized_keys
    [db2instp@nodedb22 .ssh]$
    
  3. Go back on nodedb21 and issue the following commands to set up a host trust relationship:

    [db2instp@nodedb21 ~]$ cd ~/.ssh
    [db2instp@nodedb21 .ssh]$ ssh-keyscan -t rsa nodedb21,10.231.56.117 >> known_hosts
    # nodedb21 SSH-2.0-OpenSSH_4.3
    [db2instp@nodedb21 .ssh]$ ssh-keyscan -t rsa nodedb22,10.231.56.118 >> known_hosts
    # nodedb22 SSH-2.0-OpenSSH_4.3
    [db2instp@nodedb21 .ssh]$
    
  4. Verify that the client authentication is working; on nodedb21, issue ssh nodedb22 date (do it the other way around—now it should work without asking for a password):

    [db2instp@nodedb21 .ssh]$ ssh nodedb22 date
    Thu Jun  9 16:42:33 EEST 2011
    [db2instp@nodedb21 .ssh]$ ssh nodedb22
    [db2instp@nodedb22 ~]$ ssh nodedb21 date
    Thu Jun  9 16:42:48 EEST 2011
    [db2instp@nodedb22 ~]$ ssh nodedb22 date
    Thu Jun  9 16:42:55 EEST 2011
    [db2instp@nodedb22 ~]$ ssh nodedb21
    [db2instp@nodedb21 ~]$ ssh nodedb21 date
    Thu Jun  9 16:43:07 EEST 2011
    [db2instp@nodedb21 ~]$
    

Install DB2 ESE software with a response file option

A response file is a text file containing installation and configuration information such as paths, installation options etc. It can be created and recorded using interactive installation and replayed by other installations to perform the same steps.

  1. Launch db2setup, and, at step 4 of the installation wizard (Install action), check the Install DB2 Enterprise Server Edition on this computer and save my setting in a response file option. Provide the complete path to the response file.

  2. At step 5, specify /opt/ibm/db2/V9.7_part for Installation directory.

  3. At step 7 (Partitioning option), check Multiple partition instance.

  4. Next, for DB2 instance owner, choose db2instp and, for fenced user, choose db2fencp. On the next screen, choose Do not create tools catalog. At the end of installation, we will find (in the directory chosen at step 4 of installation wizard) two files with .rsp extension; you need to copy just db2ese_addpart.rsp to nodedb22 and issue on nodedb22, from the installation directory:

    ./db2setup -r <your path>db2ese_addpart.rsp
    DBI1191I  db2setup is installing and configuring DB2 according to the response file provided. Please wait.
    

Configuring communication for inter-partition command execution

  1. The communication method of inter-partition command execution is controlled by DB2RSCHCM registry variable. Because our choice is SSH for inter-partition command execution, you must next set the DB2RSHCMD variable to point to SSH executable DB2RSHCMD=/usr/bin/ssh. If this variable is not set, the rsh method is used by default:

    	[db2instp@nodedb21 ~]$ db2set DB2RSHCMD=/usr/bin/ssh -i
    
  2. To verify the current DB2 registry variables, issue the following command:

    	[db2instp@nodedb21 ~]$ db2set -all
    	[i] DB2RSHCMD=/usr/bin/ssh
    	[i] DB2COMM=tcpip
    	[i] DB2AUTOSTART=YES
    	[g] DB2FCMCOMM=TCPIP4
    	[g] DB2SYSTEM=nodedb21
    	[g] DB2INSTDEF=db2instp
    

Configuring the nodes

In the db2nodes.cfg file, database partition configuration file, located in $INSTANCEHOME/sqllib, set the participant nodes. Define three nodes—two on nodedb21, partion number 0 with logical port 0 and partition number 2 with logical port 1 and one on nodedb22, partition 1 with logical port 0. After adding the nodes we should have the following structure:

0 nodedb21 0
1 nodedb22 0
2 nodedb21 1

How it works...

Instance db2instp knows about the current nodes by reading their definition from db2nodes.cfg database partition configuration file. The logical ports and number of maximum partitions per server are limited by the range defined within /etc/services file as follows:

DB2_db2inst1
60000/tcp DB2_db2inst1_1
60001/tcp DB2_db2inst1_2
60002/tcp DB2_db2inst1_END	60003/tcp

The structure of db2nodes.cfg, in some cases, can be further elaborated with optional information such as resourcenames or netnames; in our case being a simple setup used for demonstration purpose we have defined only the nodes, hostnames, and the logical ports.

Under Unix and Linux, db2nodes has the following complete format:

dbpartitionnum hostname logicalport netname resourcesetname

Under MS Windows, db2nodes has the following complete format:

dbpartitionnum hostname computername logicalport netname resourcesetname

There's more...

DB2 has two utilities to verify that communication between nodes is working: db2_all and rah. You can also issue practically any administrative command (backup, restore, setting parameters, and so on) across the database partitions with these utilities.

An example of using db2_all for verification:

[db2instp@nodedb21 ~]$ db2_all uptime
  11:54:02 up 17:11,	1 user,	load average: 0.07, 0.03, 0.00 
nodedb21: uptime completed ok
  11:54:03 up 17:11,	0 users,	load average: 0.10, 0.03, 0.01 
nodedb22: uptime completed ok
  11:54:03 up 17:11,	1 user,	load average: 0.07, 0.03, 0.00 nodedb21: uptime completed ok

The same using rah:

[db2instp@nodedb21 ~]$ rah uptime
  14:56:19 up 35 days, 18:09,	1 user,   load average: 0.08, 0.02, 0.01 nodedb21: uptime completed ok
  14:56:20 up 35 days, 18:09,	0 users,  load average: 0.00, 0.00, 0.00 nodedb22: uptime completed ok
  14:56:20 up 35 days, 18:09,	1 user,   load average: 0.08, 0.02, 0.01 nodedb21: uptime completed ok

Obviously, there is also a possibility of using a shared disk, formatted with a concurrent file system, such as, IBM's GPFS or Red Hat GFS, for instance home, and used for sharing across the nodes instead of using NFS exports.

On Windows, it is not recommended to edit the db2nodes.cfg file manually; use the

The following commands instead:

  • db2nlist—to list database partitions

  • db2ncrt—to add a database partition server to an instance

  • db2ndrop—to drop a database partition server to an instance

  • db2nchg—to modify a database partition server configuration

See also

The Converting a non-partitioned database to a multipartitioned database on MS Windows recipe in Chapter 3, DB2 Multipartitioned Databases—Administration and Configuration

Starting and stopping instances


There are several situations in which an instance must be stopped and started, for example, after you change some parameters that are not dynamic, or after applying a fixpack.

Getting ready

We have, at disposal, a couple of different ways to start or stop an instance. We can use, say, db2start for starting and db2stop for stopping; these commands are available for execution in the command line or from DB2 CLI. We can also start or stop an instance from the Control Center. In Windows, you can also start and stop an instance by starting and stopping the service associated with it.

How to do it...

  1. The current instance is set by the environment variable DB2INSTANCE or the global registry variable DB2INSTDEF, in case DB2INSTANCE is not set. This is applicable mostly for Microsoft Windows platforms where there could be more than one instance per user.

    • On Microsoft Windows:

      C:\Documents and Settings>db2ilist
      DB2_02
      DB2WIN
      C:\Documents and Settings>set DB2INSTANCE
      DB2INSTANCE=DB2_02
      

    Now, if we issue db2stop or db2start, only instance DB2_02 will be affected.

    • On our Linux server nodedb21:

      		[db2inst1@nodedb21 ~]$ echo $DB2INSTANCE
      		db2inst1
      
  2. As the db2inst1 instance owner, stop instance db2inst1 with the db2stop command, and start it with db2start:

    [db2inst1@nodedb21 ~]$ db2stop
    06/09/2011 17:55:21     0   0   SQL1064N  DB2STOP processing was successful.
    SQL1064N  DB2STOP processing was successful.
    [db2inst1@nodedb21 ~]$ db2start
    06/09/2011 17:55:29     0   0   SQL1063N  DB2START processing was successful.
    SQL1063N  DB2START processing was successful.
    
  3. As the multipartitioned instance owner db2instp, stop instance db2instp with the db2stop command, and start it with db2start:

    [db2instp@nodedb21 sqllib]$ db2stop
    06/09/2011 19:03:47     1   0   SQL1064N  DB2STOP processing was successful.
    06/09/2011 19:03:48     0   0   SQL1064N  DB2STOP processing was successful.
    06/09/2011 19:03:49     2   0   SQL1064N  DB2STOP processing was successful.
    SQL1064N  DB2STOP processing was successful.
    [db2instp@nodedb21 sqllib]$ db2start
    06/09/2011 19:04:02     1   0   SQL1063N  DB2START processing was successful.
    06/09/2011 19:04:06     2   0   SQL1063N  DB2START processing was successful.
    06/09/2011 19:04:06     0   0   SQL1063N  DB2START processing was successful.
    SQL1063N  DB2START processing was successful.
    
  4. Using the Control Center, right-click on db2inst1 and issue stop and start.

How it works...

In the process of starting an instance, memory structures are allocated and the instance starts listening for connections on the ports assigned by the SVCENAME database manager configuration parameter. At stop, existing connections are disconnected and memory is deallocated.

There's more...

Other options that can be used to start and stop an instance are the DB2 CLI commands, START DATABASE MANAGER and STOP DATABASE MANAGER. For Windows, we have as alternate option to start or stop the service associated with the instance. To set the instance for automatic start on Linux or Unix, at system boot, you can use the instance-level registry variable DB2AUTOSTART=YES or the db2iauto –on <instance name> command.

Configuring SSL for client-server instance communication


Databases can contain sensitive information; these days, the main concern is related to the security of data stored in tables as well as those sent over the network. One method of securing network communication between server and client is SSL, which is actually an abbreviation for Secure Socket Layer. We do not delve further into too much theory. Mainly, SSL addresses the following important security considerations: authentication, confidentiality, and integrity. Mainly SSL encryption and other network communication or also named data in transit encryption methods protects against unauthorized packet interception and analysis performed by an interposed person between a client and a server, also known as eavesdropping.

The DB2 instance has built-in support for SSL. DB2 relies on Global Security Kit for implementing SSL. GSKit is included in the IBM DB2 ESE software installation kit or is downloadable for free from IBM's website. Next, we'll show how to implement a secure connection between a DB2 server and a DB2 client.

Getting ready

For the next recipe, we will use nodedb21 (db2inst1 instance) as server and nodedb22 (db2clnt1 instance) as client, where we have installed DB2 Client in previous recipes. You need to ensure that you have GSKit libraries in LD_LIBRARY_PATH. In our case, the libraries that are located in /home/db2inst1/sqllib/lib64 are pointing to the /opt/ibm/db2/V9.7/lib64 location.

How to do it...

  1. The first step is to add the gsk8capicmd_64 executable in our PATH.

    Include the following in .bash_profile:

    PATH=$PATH:$HOME/bin:$HOME/sqllib/gskit/bin

    Execute source .bash_profile to reinitialize the user environment.

  2. To create a key database on the server, execute the following (for more information about gsk8capicmd_64, execute gsk8capicmd_64 –help):

    [db2inst1@nodedb21 ~]$ gsk8capicmd_64 -keydb -create -db "/home/db2inst1/keystoredb2inst1.kdb" -pw "db2cookbook" -stash
    [db2inst1@nodedb21 ~]$
    
  3. Create a self-signature and self-sign the key database on the server:

    [db2inst1@nodedb21 ~]$ gsk8capicmd_64 -cert -create -db "/home/db2inst1/keystoredb2inst1.kdb" -pw "db2cookbook" -label "db2cookbooksignature" -dn "CN=www.packtpub.com,O=Packt Publishing,OU=Packt Publishing"
    [db2inst1@nodedb21 ~]$
    
  4. Extract the signature for signing the client key database:

    [db2inst1@nodedb21 ~]$ gsk8capicmd_64 -cert -extract -db "/home/db2inst1/keystoredb2inst1.kdb" -label "db2cookbooksignature" -target "/home/db2inst1/db2cookbook.arm" -format ascii -fips -pw "db2cookbook"
    [db2inst1@nodedb21 ~]$
    
  5. Next, create the client key database:

    [db2inst1@nodedb21 ~]$ gsk8capicmd_64 -keydb -create -db "/home/db2inst1/keystoreclientdb2inst1.kdb" -pw "db2ckbk" –stash
    [db2inst1@nodedb21 ~]$
    
  6. Import the self-signed certificate into the client key database:

    [db2inst1@nodedb21 ~]$ gsk8capicmd_64 -cert -add -db "/home/db2inst1/keystoreclientdb2inst.kdb" -pw "db2ckbk" -label "db2cookbooksignature" -file "/home/db2inst1/db2cookbook.arm" -format ascii –fips
    [db2inst1@nodedb21 ~]$
    
  7. To enable SSL as communication protocol on nodedb21, execute the following:

    [db2inst1@nodedb21 ~]$ db2set DB2COMM=tcpip,ssl –i
    [db2inst1@nodedb21 ~]$
    
  8. Enable SSL as communication protocol also on the client side:

    [db2clnt1@nodedb21 ~]$ db2set DB2COMM=tcpip,ssl –i 
    [db2clnt1@nodedb21 ~]$
    
  9. Next, on nodedb21, set SSL-related parameters on the server instance; then, stop and start the instance:

    [db2inst1@nodedb21 ~]$ db2 "update dbm cfg using ssl_svr_keydb /home/db2inst/keystoredb2inst1.kdb"
    DB20000I  The UPDATE DATABASE MANAGER CONFIGURATION command completed
    successfully.
    [db2inst1@nodedb21 ~]$ db2 "update dbm cfg using ssl_svr_stash /home/db2inst/keystoredb2inst1.sth"
    DB20000I  The UPDATE DATABASE MANAGER CONFIGURATION command completed
    successfully.
    [db2inst1@nodedb21 ~]$ db2 "update dbm cfg using ssl_svr_label db2cookbooksignature"
    DB20000I  The UPDATE DATABASE MANAGER CONFIGURATION command completed
    successfully.
    [db2inst1@nodedb21 ~]$ db2 "update dbm cfg using ssl_svcename 50004"
    DB20000I  The UPDATE DATABASE MANAGER CONFIGURATION command completed
    successfully.
    [db2inst1@nodedb21 ~]$ db2stop
    06/09/2011 19:08:39     0   0   SQL1064N  DB2STOP processing was successful.
    SQL1064N  DB2STOP processing was successful.
    [db2inst1@nodedb21 ~]$ db2start
    06/09/2011 19:08:45     0   0   SQL1063N  DB2START processing was successful.
    SQL1063N  DB2START processing was successful.
    

    Note

    Description of SSL-related parameters used on the server side:

    • SSL_SVR_KEYDB specifies a fully qualified filepath of the key file to be used for SSL setup at server side

    • SSL_SVR_STASH—specifies a fully qualified filepath of the stash file to be used for SSL setup at server side

    • SSL_SVR_LABEL—specifies a label of the personal certificate of the server in the key database

    • SSL_SVCENAME—specifies the name of the port that a database server uses to await communications from remote client nodes using SSL protocol

    • Be careful to set the correct paths, otherwise SSL won't work.

  10. Copy /home/db2inst1/keystoreinstclient.kdb and /home/db2clnt1/keystoreinstclient.sth to nodedb22.

  11. On nodedb22, set SSL DB2 client instance-related parameters:

    [db2clnt1@nodedb22 ~]$ db2 "update dbm cfg using SSL_CLNT_KEYDB /home/db2clnt1/keystoreclientdb2inst.kdb"
    DB20000I  The UPDATE DATABASE MANAGER CONFIGURATION command completed successfully.
    [db2clnt1@nodedb22 ~]$  db2 "update dbm cfg using SSL_CLNT_STASH /home/db2clnt1/keystoreclientdb2inst.sth"
    DB20000I  The UPDATE DATABASE MANAGER CONFIGURATION command completed successfully.
    

    Note

    Description of SSL-related parameters on the client side:

    SSL_CLNT_KEYDB specifies the fully qualified filepath of the key file to be used for SSL connection at the client side

    SSL_CLNT_STASH specifies the fully qualified filepath of the stash file to be used for SSL connections at the client side

  12. Next, copy GSKit libraries to the client's DB2HOME/lib64 directory:

    [root@nodedb22 ~]# cp /opt/ibm/db2/V9.7_part/lib64/libgsk8* /opt/ibm/db2/V9.7/lib64/
    [root@nodedb22 ~]#
    

How it works...

SSL establishes the connection between client and server using a mechanism called handshake. There is a lot of information on the Internet about SSL and its working. Briefly, these are the steps for SSL handshake:

  1. The client requests an SSL connection, listing its SSL version and supported cipher suites.

  2. The server responds with a selected cipher suite.

  3. The server sends its digital certificate to the client.

  4. The client verifies the validity of the server's certificate (server authentication).

  5. Client and server securely negotiate a session key.

  6. Client and server securely exchange information using the key selected previously.

There's more...

In this recipe, we used a self signed certificate, which is fine for testing or internal use. For production environments, you should use trusted certificates signed by a third-party certification authority.

Other methods for encrypting data in transit can be implemented by using DATA_ENCRYPT and DATA_ENCRYPT_CMP as authentication methods. Also using port forwarding with SSH tunnels is a good option.

See also

Chapter 10, DB2 Security

Listing and attaching to instances


On a server environment, you may have many instances belonging to one DB2 installation or DB2HOME; obviously, you need to know about them and their name. For this purpose, you have the ability to use some specific commands to list them.

You also need to connect to these instances from remote locations to perform administration tasks; this, in the DB2 world, is called attaching.

Getting ready

In this recipe, we'll show how to list instances and attach to local and remote instances. Again, we'll use nodedb21 as server and nodedb22 as client.

How to do it...

Commands related to creating an instance are performed by the root user; listing is no exception and must be performed as root.

Listing instances

  1. The command to list current instances is db2ilist. It lists the instances that belong to one DB2 copy. List instances created in DBCOPY1:

    	[root@nodedb21 ~]# /opt/ibm/db2/V9.7/instance/db2ilist
    	db2inst1
    	db2inst2
    
  2. The same command from multipartitioned DB2HOME or DBCOPY2:

    	[root@nodedb21 ~]# /opt/ibm//db2/V9.7_part/instance/db2ilist
    	db2instp
    

Attaching to instances

  1. On nodedb22, catalog db2inst1 both as TCPIP and SSL, on our client instance db2clnt1, created before. Because we set up SSL as a separate communication method for the db2inst1 instance, we have to specify it as the security method when cataloging the node (security SSL) with the SSL dedicated port. Catalog the nodes, as follows:

    [db2clnt1@nodedb22 db2dump]$ db2 "CATALOG TCPIP NODE NODE21_S REMOTE nodedb21 SERVER 50004 SECURITY SSL REMOTE_INSTANCE  db2inst1 SYSTEM  nodedb21 OSTYPE  LINUXX8664"
    DB20000I  The CATALOG TCPIP NODE command completed successfully.
    DB21056W  Directory changes may not be effective until the directory cache is refreshed.
    
    [db2clnt1@nodedb22 db2dump]$ db2 "CATALOG TCPIP NODE NODE21_1 REMOTE nodedb21 SERVER 50001 REMOTE_INSTANCE  db2inst1 SYSTEM  nodedb21 OSTYPE  LINUXX8664"
    DB20000I  The CATALOG TCPIP NODE command completed successfully.
    DB21056W  Directory changes may not be effective until the directory cache is refreshed.
    
  2. List the cataloged nodes:

    [db2clnt1@nodedb22 ~]$ db2 "list node directory"
    
     Node Directory
    
     Number of entries in the directory = 2
    Node 1 entry:
    Node name                      = NODE21_S
     Comment                        =
     Directory entry type           = LOCAL
     Protocol                       = TCPIP
     Hostname                       = nodedb21
     Service name                   = 50004
     Security type                  = SSL
     Remote instance name           = db2inst1
     System                         = nodedb21
     Operating system type          = LINUXX8664
    
    Node 2 entry:
    
     Node name                      = NODE21_1
     Comment                        =
     Directory entry type           = LOCAL
     Protocol                       = TCPIP
     Hostname                       = nodedb21
     Service name                   = 50001
     Remote instance name           = db2inst1
     System                         = nodedb21
     Operating system type          = LINUXX8664
    
  3. Attach to instance db2inst1, using first the SSL port, and next the TCP/IP port:

    [db2clnt1@nodedb22 ~]$ db2 "attach to NODE21_S user db2inst1 using db2inst1"
    
       Instance Attachment Information
    
     Instance server        = DB2/LINUXX8664 9.7.4
     Authorization ID       = DB2INST1
     Local instance alias   = NODE21_S
    
    [db2clnt1@nodedb22 ~]$ db2 " attach to node21_1 user db2inst1 using db2inst1"
    
       Instance Attachment Information
     Instance server        = DB2/LINUXX8664 9.7.4
     Authorization ID       = DB2INST1
     Local instance alias   = NODE21_1
    
  4. Attaching to an instance with the Control Center:

    In Control Center navigate to instance db2inst1, right-click, and choose Attach.

How it works...

Instances are registered in a file named global register. This file is always updated when an instance is created or dropped.

When you attach to an instance from a client, you can see that the port on the server is changing its status from listening to established:

[root@nodedb21 ~]# netstat -nlpta | grep 5000*
tcp        0      0 0.0.0.0:50001               0.0.0.0:*                   LISTEN      19974/db2sysc 0
tcp        0      0 0.0.0.0:50003               0.0.0.0:*                   LISTEN      26082/db2sysc 0
tcp        0      0 0.0.0.0:50004               0.0.0.0:*                   LISTEN      19974/db2sysc 0
tcp        0      0 10.231.56.117:50001         10.231.56.118:49321         TIME_WAIT   -
tcp        0      0 10.231.56.117:50004         10.231.56.118:48187         ESTABLISHED 19974/db2sysc 0

This appears on nodedb21, after attaching to instance db2inst1, using the SSL port 50004.

There's more...

There is a straightforward method to verify that one instance is listening on its assigned port from a client. For this purpose, you can try to connect with telnet on that port:

[db2inst1@nodedb22 ~]$ telnet nodedb21 50004
Trying 10.231.56.117...
Connected to nodedb21.
Escape character is ‘^]'.

This means that our port assigned to SSL is listening. To detach from an instance, simply issue the DETACH command.

Another indirect method to list instances on a server is to use the discovery process provided by Configuration Assistant or Control Center locally or remotely.

See also

Chapter 11, Using DB2 Discovery

Dropping instances


There could be situations when it is necessary to drop an instance. An instance might be dropped by using the db2idrop command.

Getting ready

In this recipe, we will drop the instance db2inst2, created previously.

How to do it...

  1. The command for dropping an instance is db2idrop. You have to be user root to drop an instance. First, we need to ensure that the instance is not active. If the instance has active connections and it is active, the db2idrop command fails.

  2. Stop the instance by force:

    	[db2inst2@nodedb21 ~]$ db2stop force
    	07/12/2011 16:38:27     0   0   SQL1064N  DB2STOP processing was successful.
    	SQL1064N  DB2STOP processing was successful.
    	[db2inst2@nodedb21 ~]$
    

    Note

    If the instance hangs for some reason, the db2_kill command might be used. It will bring down the instance abruptly. However, be careful running this, because your databases running under this instance remain in an inconsistent mode.

  3. As the user root, issue the following command to drop db2inst2:

    	[root@nodedb21 ~]# /opt/ibm/db2/V9.7/instance/db2idrop db2inst2
    	DBI1070I  Program db2idrop completed successfully.
    

How it works...

On Linux and Unix, db2idrop actually deletes the sqllib directory from the instance owner home. Therefore, it is recommended to save anything you have placed in this directory such as UDFs or external programs.

On Windows, db2idrop removes the service associated with the instance.

There's more…

As a best practice, before the instance is dropped, it is recommended to save the information related to that instance in a server profile file. In case you plan to recreate the instance and configure it as before, you can simply import the server profile after the instance is created again.

To export the instance profile, use Control Center | Tools | Configuration assistant | Export profile | Customize.

In the Export tab, you have plenty of options to export; choose anything you consider worth being saved.

Left arrow icon Right arrow icon

Key benefits

  • Master all the important aspects of administration from instances to IBM's newest High Availability technology pureScale with this book and e-book.
  • Learn to implement key security features to harden your database's security against hackers and intruders.
  • Empower your databases by building efficient data configuration using MDC and clustered tables.

Description

IBM DB2 LUW is a leading relational database system developed by IBM. DB2 LUW database software offers industry leading performance, scale, and reliability on your choice of platform on various Linux distributions, leading Unix Systems like AIX, HP-UX and Solaris and MS Windows platforms. With lots of new features, DB2 9.7 delivers one the best relational database systems in the market. IBM DB2 9.7 Advanced Administration Cookbook covers all the latest features with instance creation, setup, and administration of multi-partitioned database. This practical cookbook provides step-by-step instructions to build and configure powerful databases, with scalability, safety and reliability features, using industry standard best practices. This book will walk you through all the important aspects of administration. You will learn to set up production capable environments with multi-partitioned databases and make the best use of hardware resources for maximum performance. With this guide you can master the different ways to implement strong databases with a High Availability architecture.

Who is this book for?

If you are a DB2 Database Administrator who wants to understand and get hands on with the underlying aspects of database administration, then this book is for you. This book assumes that you have a basic understanding of DB2 database concepts.

What you will learn

  • Learn to make best use of scalability with multi-partitioned databases
  • Get to grips with advanced technological breakthroughs with RBAC, and pureScale technology
  • Sharpen your troubleshooting skills
  • Design and implement the best backup strategy
  • Master the new exciting features added to the DB2 9.7 version
  • Get step-by-step instructions to tune and optimize DB2 to achieve best performance
  • Understand the database objects and their integration
Estimated delivery fee Deliver to Thailand

Standard delivery 10 - 13 business days

$8.95

Premium delivery 5 - 8 business days

$45.95
(Includes tracking information)

Product Details

Country selected
Publication date, Length, Edition, Language, ISBN-13
Publication date : Feb 24, 2012
Length: 480 pages
Edition : 1st
Language : English
ISBN-13 : 9781849683326
Vendor :
IBM
Category :
Tools :

What do you get with Print?

Product feature icon Instant access to your digital eBook copy whilst your Print order is Shipped
Product feature icon Paperback book shipped to your preferred address
Product feature icon Download this book in EPUB and PDF formats
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
OR
Modal Close icon
Payment Processing...
tick Completed

Shipping Address

Billing Address

Shipping Methods
Estimated delivery fee Deliver to Thailand

Standard delivery 10 - 13 business days

$8.95

Premium delivery 5 - 8 business days

$45.95
(Includes tracking information)

Product Details

Publication date : Feb 24, 2012
Length: 480 pages
Edition : 1st
Language : English
ISBN-13 : 9781849683326
Vendor :
IBM
Category :
Tools :

Packt Subscriptions

See our plans and pricing
Modal Close icon
$19.99 billed monthly
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Simple pricing, no contract
$199.99 billed annually
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just $5 each
Feature tick icon Exclusive print discounts
$279.99 billed in 18 months
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just $5 each
Feature tick icon Exclusive print discounts

Frequently bought together


Stars icon
Total $ 207.97
IBM WebSphere Application Server 8.0 Administration Guide
$65.99
IBM DB2 9.7 Advanced Application Developer Cookbook
$70.99
IBM DB2 9.7 Advanced Administration Cookbook
$70.99
Total $ 207.97 Stars icon

Table of Contents

14 Chapters
DB2 Instance—Administration and Configuration Chevron down icon Chevron up icon
Administration and Configuration of the DB2 Non-partitioned Database Chevron down icon Chevron up icon
DB2 Multipartitioned Databases—Administration and Configuration Chevron down icon Chevron up icon
Storage—Using DB2 Table Spaces Chevron down icon Chevron up icon
DB2 Buffer Pools Chevron down icon Chevron up icon
Database Objects Chevron down icon Chevron up icon
DB2 Backup and Recovery Chevron down icon Chevron up icon
DB2 High Availability Chevron down icon Chevron up icon
Problem Determination, Event Sources, and Files Chevron down icon Chevron up icon
DB2 Security Chevron down icon Chevron up icon
Connectivity and Networking Chevron down icon Chevron up icon
Monitoring Chevron down icon Chevron up icon
DB2 Tuning and Optimization Chevron down icon Chevron up icon
IBM pureScale Technology and DB2 Chevron down icon Chevron up icon

Customer reviews

Top Reviews
Rating distribution
Full star icon Full star icon Full star icon Full star icon Half star icon 4.5
(8 Ratings)
5 star 62.5%
4 star 25%
3 star 12.5%
2 star 0%
1 star 0%
Filter icon Filter
Top Reviews

Filter reviews by




Srilu Mar 14, 2012
Full star icon Full star icon Full star icon Full star icon Full star icon 5
This is First V9.7 DB2 udb book with detailed info. Book covers all the topics and new fetures for 'DB2 9.7 Advanced Database Administrator including V9.8 db2 pureScale and V9.7 DPF,MDC, Security new features .I read Chapter12 from packtpub about Monitoring .Really good with practical examples .This book will help every DB2 UDB DBA for daily Job duties. I would highly recommend this book to fellow DBAs and developers.Cheers ..Srilu
Amazon Verified review Amazon
aroushdi May 09, 2012
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Though IBM has the info center and other publications for DB2 , It is difficult to find the information we need and we jump from a page to another until we find the proper info .This book closes this gap and you find the information needed in a very short time.From my point of view it is targeted to all audience from beginners to the expert .Still relevant even for DB2 V10 with the exeption of the new functionalaties.The only thing I miss in the book is the WINDOWS specific environment .
Amazon Verified review Amazon
Adrian Neagu (OCM) Mar 02, 2012
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Excellent book, probably the best on this topic.The explanations and code snippets are outstanding.Very recommended for who want to learn DB2 in a different way.
Amazon Verified review Amazon
DL Apr 23, 2012
Full star icon Full star icon Full star icon Full star icon Full star icon 5
This is a great book with quick reference and simple straight forward answers. This book is highly recommended to all DB2 DBA admins.
Amazon Verified review Amazon
Robert W. Cooke Mar 20, 2012
Full star icon Full star icon Full star icon Full star icon Full star icon 5
The IBM DB2 9.7 Advanced Administration Cookbook was a pleasant surprise to review. The book is in more of a step by step format than a book of recipes.The book begins where it should at initial DB2 installation and creating an instance. It then proceeds on to creating databases tablespaces, bufferpools, and database objects.I was most impressed by the Backup and Recovery, Monitoring, and Tuning and Optimization chapters. The Backup and Recovery chapter is short but it covers all forms of online and offline backups and different recovery options. Monitoring covers system, snapshot, and event monitoring as well as using the memory visualizer and health monitor. DB2 Tuning and Optimization gives examples of O/S monitoring, using explain, and how indexes, reorgs, and runstats can help performance.The cookbook also discusses DB2 tools such as db2dart, db2look, db2move, db2pd, reorgchk, list tablespaces and others. It mentions db2top but does not demonstrate it.There is a chapter on DB2 PureScale but I'm not experienced with that product.The cookbook could contain more common problems/issues and troubleshooting but an entire book could be written just on that topic. All in all the IBM DB2 9.7 Advanced Administration Cookbook provides a well rounded approach to a new or novice DB2 DBA. Even an experienced DBA would learn a few things. It does not deep drive into everything but it goes far enough and provides good examples to perform the main DB2 DBA tasks. The IBM DB2 document ion and redbooks will provide the fine details.
Amazon Verified review Amazon
Get free access to Packt library with over 7500+ books and video courses for 7 days!
Start Free Trial

FAQs

What is the delivery time and cost of print book? Chevron down icon Chevron up icon

Shipping Details

USA:

'

Economy: Delivery to most addresses in the US within 10-15 business days

Premium: Trackable Delivery to most addresses in the US within 3-8 business days

UK:

Economy: Delivery to most addresses in the U.K. within 7-9 business days.
Shipments are not trackable

Premium: Trackable delivery to most addresses in the U.K. within 3-4 business days!
Add one extra business day for deliveries to Northern Ireland and Scottish Highlands and islands

EU:

Premium: Trackable delivery to most EU destinations within 4-9 business days.

Australia:

Economy: Can deliver to P. O. Boxes and private residences.
Trackable service with delivery to addresses in Australia only.
Delivery time ranges from 7-9 business days for VIC and 8-10 business days for Interstate metro
Delivery time is up to 15 business days for remote areas of WA, NT & QLD.

Premium: Delivery to addresses in Australia only
Trackable delivery to most P. O. Boxes and private residences in Australia within 4-5 days based on the distance to a destination following dispatch.

India:

Premium: Delivery to most Indian addresses within 5-6 business days

Rest of the World:

Premium: Countries in the American continent: Trackable delivery to most countries within 4-7 business days

Asia:

Premium: Delivery to most Asian addresses within 5-9 business days

Disclaimer:
All orders received before 5 PM U.K time would start printing from the next business day. So the estimated delivery times start from the next day as well. Orders received after 5 PM U.K time (in our internal systems) on a business day or anytime on the weekend will begin printing the second to next business day. For example, an order placed at 11 AM today will begin printing tomorrow, whereas an order placed at 9 PM tonight will begin printing the day after tomorrow.


Unfortunately, due to several restrictions, we are unable to ship to the following countries:

  1. Afghanistan
  2. American Samoa
  3. Belarus
  4. Brunei Darussalam
  5. Central African Republic
  6. The Democratic Republic of Congo
  7. Eritrea
  8. Guinea-bissau
  9. Iran
  10. Lebanon
  11. Libiya Arab Jamahriya
  12. Somalia
  13. Sudan
  14. Russian Federation
  15. Syrian Arab Republic
  16. Ukraine
  17. Venezuela
What is custom duty/charge? Chevron down icon Chevron up icon

Customs duty are charges levied on goods when they cross international borders. It is a tax that is imposed on imported goods. These duties are charged by special authorities and bodies created by local governments and are meant to protect local industries, economies, and businesses.

Do I have to pay customs charges for the print book order? Chevron down icon Chevron up icon

The orders shipped to the countries that are listed under EU27 will not bear custom charges. They are paid by Packt as part of the order.

List of EU27 countries: www.gov.uk/eu-eea:

A custom duty or localized taxes may be applicable on the shipment and would be charged by the recipient country outside of the EU27 which should be paid by the customer and these duties are not included in the shipping charges been charged on the order.

How do I know my custom duty charges? Chevron down icon Chevron up icon

The amount of duty payable varies greatly depending on the imported goods, the country of origin and several other factors like the total invoice amount or dimensions like weight, and other such criteria applicable in your country.

For example:

  • If you live in Mexico, and the declared value of your ordered items is over $ 50, for you to receive a package, you will have to pay additional import tax of 19% which will be $ 9.50 to the courier service.
  • Whereas if you live in Turkey, and the declared value of your ordered items is over € 22, for you to receive a package, you will have to pay additional import tax of 18% which will be € 3.96 to the courier service.
How can I cancel my order? Chevron down icon Chevron up icon

Cancellation Policy for Published Printed Books:

You can cancel any order within 1 hour of placing the order. Simply contact customercare@packt.com with your order details or payment transaction id. If your order has already started the shipment process, we will do our best to stop it. However, if it is already on the way to you then when you receive it, you can contact us at customercare@packt.com using the returns and refund process.

Please understand that Packt Publishing cannot provide refunds or cancel any order except for the cases described in our Return Policy (i.e. Packt Publishing agrees to replace your printed book because it arrives damaged or material defect in book), Packt Publishing will not accept returns.

What is your returns and refunds policy? Chevron down icon Chevron up icon

Return Policy:

We want you to be happy with your purchase from Packtpub.com. We will not hassle you with returning print books to us. If the print book you receive from us is incorrect, damaged, doesn't work or is unacceptably late, please contact Customer Relations Team on customercare@packt.com with the order number and issue details as explained below:

  1. If you ordered (eBook, Video or Print Book) incorrectly or accidentally, please contact Customer Relations Team on customercare@packt.com within one hour of placing the order and we will replace/refund you the item cost.
  2. Sadly, if your eBook or Video file is faulty or a fault occurs during the eBook or Video being made available to you, i.e. during download then you should contact Customer Relations Team within 14 days of purchase on customercare@packt.com who will be able to resolve this issue for you.
  3. You will have a choice of replacement or refund of the problem items.(damaged, defective or incorrect)
  4. Once Customer Care Team confirms that you will be refunded, you should receive the refund within 10 to 12 working days.
  5. If you are only requesting a refund of one book from a multiple order, then we will refund you the appropriate single item.
  6. Where the items were shipped under a free shipping offer, there will be no shipping costs to refund.

On the off chance your printed book arrives damaged, with book material defect, contact our Customer Relation Team on customercare@packt.com within 14 days of receipt of the book with appropriate evidence of damage and we will work with you to secure a replacement copy, if necessary. Please note that each printed book you order from us is individually made by Packt's professional book-printing partner which is on a print-on-demand basis.

What tax is charged? Chevron down icon Chevron up icon

Currently, no tax is charged on the purchase of any print book (subject to change based on the laws and regulations). A localized VAT fee is charged only to our European and UK customers on eBooks, Video and subscriptions that they buy. GST is charged to Indian customers for eBooks and video purchases.

What payment methods can I use? Chevron down icon Chevron up icon

You can pay with the following card types:

  1. Visa Debit
  2. Visa Credit
  3. MasterCard
  4. PayPal
What is the delivery time and cost of print books? Chevron down icon Chevron up icon

Shipping Details

USA:

'

Economy: Delivery to most addresses in the US within 10-15 business days

Premium: Trackable Delivery to most addresses in the US within 3-8 business days

UK:

Economy: Delivery to most addresses in the U.K. within 7-9 business days.
Shipments are not trackable

Premium: Trackable delivery to most addresses in the U.K. within 3-4 business days!
Add one extra business day for deliveries to Northern Ireland and Scottish Highlands and islands

EU:

Premium: Trackable delivery to most EU destinations within 4-9 business days.

Australia:

Economy: Can deliver to P. O. Boxes and private residences.
Trackable service with delivery to addresses in Australia only.
Delivery time ranges from 7-9 business days for VIC and 8-10 business days for Interstate metro
Delivery time is up to 15 business days for remote areas of WA, NT & QLD.

Premium: Delivery to addresses in Australia only
Trackable delivery to most P. O. Boxes and private residences in Australia within 4-5 days based on the distance to a destination following dispatch.

India:

Premium: Delivery to most Indian addresses within 5-6 business days

Rest of the World:

Premium: Countries in the American continent: Trackable delivery to most countries within 4-7 business days

Asia:

Premium: Delivery to most Asian addresses within 5-9 business days

Disclaimer:
All orders received before 5 PM U.K time would start printing from the next business day. So the estimated delivery times start from the next day as well. Orders received after 5 PM U.K time (in our internal systems) on a business day or anytime on the weekend will begin printing the second to next business day. For example, an order placed at 11 AM today will begin printing tomorrow, whereas an order placed at 9 PM tonight will begin printing the day after tomorrow.


Unfortunately, due to several restrictions, we are unable to ship to the following countries:

  1. Afghanistan
  2. American Samoa
  3. Belarus
  4. Brunei Darussalam
  5. Central African Republic
  6. The Democratic Republic of Congo
  7. Eritrea
  8. Guinea-bissau
  9. Iran
  10. Lebanon
  11. Libiya Arab Jamahriya
  12. Somalia
  13. Sudan
  14. Russian Federation
  15. Syrian Arab Republic
  16. Ukraine
  17. Venezuela