Non-Partitioned Database Environment


Non-Partitioned Database Environment

When installing DB2 ESE in a non-partitioned database environment you need to make the following preparation.

Preparing the Environment for Installation

Before performing the DB2 installation, you need to verify that the server:

  • meets the necessary installation requirements (i.e., software level, etc.)

  • has the correct operating system version and fix level

  • has enough memory to run DB2

  • has enough disk space for DB2 product installation

  • has the necessary user accounts for installation and setup

For UNIX and Linux:

  • You must update kernel parameters to the recommended values for HP-UX, Linux, and Solaris.

    • Use db2osconf for Solaris.

  • A system restart is required.

  • For Solaris, set the following network parameters:

    • Set the TCP network parameters:

        ndd set /dev/tcp tcp_xmit_hiwat 65536   ndd set /dev/tcp tcp_recv_hiwat 65536  

      - tcp_xmit_hiwat is the send buffer window size, in bytes. The default value for tcp_xmit_hiwat is 16,384 bytes.

      - tcp_recv_hiwat is the receive window size, in bytes. The default value for tcp_recv_hiwat is 24,576 bytes.

      - tcp_max_buf is the maximum buffer size, in bytes. It controls how large the send and receive buffers are set to by an application using setsockopt(3SOCKET). The default value for tcp_max_buf is 1,048,576 bytes. If TCP connections are being made in a high-speed network environment, increase the value to match the network link speed.

    • Set the UDP network parameters:

        ndd set /dev/udp udp_xmit_hiwat 65536   ndd set /dev/udp udp_recv_hiwat 65536  

      - udp_xmit_hiwat is the maximum UDP socket datagram size, in bytes. The default value for udp_xmit_hiwat is 8,192 bytes.

      - udp_recv_hiwat is the maximum UDP socket receive buffer size, in bytes. The default value for udp_recv_hiwat is 8,192 bytes.

      - udp_max_buf is the maximum buffer size, in bytes. It controls how large the send and receive buffers, in bytes, are set to by an application using UDP or setsockopt(3SOCKET). The default value for udp_max_buf is 262,144 bytes. Do not change the value. If this parameter is set to a very large value, UDP socket applications can consume too much memory.

    • To list the current network settings:

        no get /dev/tcp <network_parm>   no get /dev/udp <network_parm>  
  • For AIX, set the following network parameters:

    • Set the maximum number of processes to a higher value. The default value for maxuproc is 500.

        chdev l sys0 a maxuproc='4096'  
    • List the current TCP/IP network setting:

        no a  pg  
    • Set the TCP/IP network parameters:

        no o thewall=1048576   no o rfc1323=1   no o tcp_sendspace=655360   no o tcp_recvspace=655360   no o udp_sendspace=65536   no o udp_recvspace=655360   no o sb_max=1310720  

      - thewall controls the maximum amount of RAM, in KB, that the mbuf management facility can allocate. The default value for thewall is 131,024.

      - rfc1323 ” if the value of this variable is nonzero, it allows the TCP window size to be the maximum of 32 bits instead of 16 bits. What this means is that you can set tcp_recvspace and tcp_sendspace to be greater than 64 KB. The default value for rfc1323 is 0.

      - tcp_sendspace sets the default socket send buffer. It keeps an application from overflowing the socket send buffer and limits the number of mbufs by an application. The default value for tcp_sendspace is 16,384.

      - tcp_recvspace is used as the default socket receive buffer size when an application opens a TCP socket. The default value for tcp_recvspace is 16,384.

      - udp_sendspace sets the limit for the amount of memory that can be used by a single UDP socket for buffering outgoing data. If a UDP application fills this buffer space, it must sleep until some of the data has passed on to the next layer of the protocol stack. The default value for udp_sendspace is 9,216.

      - udp_recvspace sets the size limit of the receive space buffer for any single UDP socket. The default value for udp_recvspace is 41,920.

      - sb_max controls the upper limit for any buffer. The default value for sb_max is 1,048,576.

  • Create a DB2 home file system and other necessary file systems and/or raw devices to store database file structure, log files, backup images, table space containers, etc.

NOTE

For recommended kernel parameters, refer to the DB2 ESE Quick Beginnings Guide.




Advanced DBA Certification Guide and Reference for DB2 UDB v8 for Linux, Unix and Windows
Advanced DBA Certification Guide and Reference for DB2 Universal Database v8 for Linux, UNIX, and Windows
ISBN: 0130463884
EAN: 2147483647
Year: 2003
Pages: 121

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net