Release Notes

46.6 Memory Windows for HP-UX 11

Memory windows is for users on large HP 64-bit machines, who want to take advantage of greater than 1.75 GB of shared memory for 32-bit applications. Memory windows is not required if you are running the 64-bit version of DB2. Memory windows makes available a separate 1 GB of shared memory per process or group of processes. This allows an instance to have its own 1 GB of shared memory, plus the 0.75 GB of global shared memory. If users want to take advantage of this, they can run multiple instances, each in its own window. Following are prerequisites and conditions for using memory windows:

• DB2 EE environment
  • Patches: Extension Software 12/98, and PHKL_17795.
  • The $DB2INSTANCE variable must be set for the instance.
  • There must be an entry in the /etc/services.window file for each DB2 instance that you want to run under memory windows. For example:

       db2instance1 50
       db2instance2 60
     
       Note:  There can only be a single space between the name and the ID.
    

  • Any DB2 commands that you want to run on the server, and that require more than a single statement, must be run using a TCP/IP loopback method. This is because the shell will terminate when memory windows finishes processing the first statement. DB2 Service knows how to accomplish this.
  • Any DB2 command that you want to run against an instance that is running in memory windows must be prefaced with db2win (located in sqllib/bin). For example:

       db2win db2start
       db2win db2stop
    

  • Any DB2 command that is run outside of memory windows (but when memory windows is running) should return a 1042. For example:

       db2win db2start <== OK
       db2 connect to db  <==SQL1042
       db2stop <==SQL1042
       db2win db2stop   <== OK
    

• DB2 EEE environment
  • Patches: Extension Software 12/98, and PHKL_17795.
  • The $DB2INSTANCE variable must be set for the instance.
  • The DB2_ENABLE_MEM_WINDOWS registry variable must be set to TRUE.
  • There must be an entry in the /etc/services.window file for each logical node of each instance that you want to run under memory windows. The first field of each entry should be the instance name concatenated with the port number. For example:

         === $HOME/sqllib/db2nodes.cfg for db2instance1 ===
         5 host1 0 
         7 host1 1
         9 host2 0
     
         === $HOME/sqllib/db2nodes.cfg for db2instance2 ===
         1 host1 0 
         2 host2 0
         3 host2 1
     
         === /etc/services.window on host1 ===
         db2instance10 50
         db2instance11 55
         db2instance20 60
     
         === /etc/services.window on host2 ===
         db2instance10 30
         db2instance20 32
         db2instance21 34 
    

  • You must not preface any DB2 command with db2win, which is to be used in an EE environment only.