Patch Name: PHSS_29875 Patch Description: s700_800 11.X OV DP5.10 patch - DB2 packet Creation Date: 03/12/03 Post Date: 03/12/04 Hardware Platforms - OS Releases: s700: 11.00 11.11 s800: 11.00 11.11 Products: DATA-PROTECTOR A.05.10 Filesets: DATA-PROTECTOR.OMNI-DB2-P,fr=A.05.10,fa=HP-UX_B.11.00_32/64,v=HP Automatic Reboot?: No Status: General Release Critical: No Category Tags: defect_repair enhancement general_release Path Name: /hp-ux_patches/s700_800/11.X/PHSS_29875 Symptoms: PHSS_29875: Id = HSLco42939 SR: H555010848 Backup performance can be worse then expected and concurrency of a device must be 1. Id = HSLco43806 SR: H555011211 IBM DB2 UDB integration is not supported by Data Protector 5.1 on Linux. Defect Description: PHSS_29875: Id = HSLco42939 SR: H555010848 Number of buffers is hardcoded to 2 and buffer size is hardcoded to 1024. Because these values cannot be changed, the performance tuning is not possible. Problems could also occur if concurrency is bigger than 1 because more buffers are required. Resolution: New environment variables "OB2_DB2BUFFSIZE" and "OB2_DB2BUFFNUM" are introduced. "OB2_DB2BUFFSIZE" can be used to change the value of buffer size and "OB2_DB2BUFFNUM" can be used to change the number of buffers. Default values for buffer number is changed to concurrency * 2 and buffer size to 256. Please note that during a restore the buffer size must be the same or positive integer multiple of backup buffer size. If you raise the buffer number or size, you can encounter SQL2009C error. If you encounter it, please change database configuration parameter UTIL_HEAP_SZ. It should be bigger than buffer size * buffernum. Because now default buffer size is smaller, it has to be set by "OB2_DB2BUFFSIZE" to 1024 when restoring backup images done before this changes. Id = HSLco43806 SR: H555011211 IBM DB2 UDB integration is not supported by Data Protector 5.1 on Linux. Resolution: IBM DB2 UDB integration is supported by Data Protector 5.1 on Linux. Enhancement: Yes PHSS_29875: General release patch PHSS_29875/DPSOL_00053 introduces Data Protector A.05.10 IBM DB2 UDB integration on Linux operating system. SR: H555011211 H555010848 Patch Files: DATA-PROTECTOR.OMNI-DB2-P,fr=A.05.10,fa=HP-UX_B.11.00_32/64, v=HP: /opt/omni/databases/vendor/db2/hp/s800/hp-ux-11/A.05.10/ packet.Z /opt/omni/databases/vendor/db2/gpl/i386/linux-60/A.05.10/ packet.Z /opt/omni/databases/vendor/db2/gpl/i386/linux-60/A.05.10/ require.dat /opt/omni/databases/vendor/db2/ibm/rs6000/aix-51/A.05.10/ packet.Z /opt/omni/databases/vendor/db2/ibm/rs6000/aix-43/A.05.10/ packet.Z what(1) Output: DATA-PROTECTOR.OMNI-DB2-P,fr=A.05.10,fa=HP-UX_B.11.00_32/64, v=HP: /opt/omni/databases/vendor/db2/hp/s800/hp-ux-11/A.05.10/ packet.Z: None /opt/omni/databases/vendor/db2/gpl/i386/linux-60/A.05.10/ packet.Z: None /opt/omni/databases/vendor/db2/gpl/i386/linux-60/A.05.10/ require.dat: None /opt/omni/databases/vendor/db2/ibm/rs6000/aix-51/A.05.10/ packet.Z: None /opt/omni/databases/vendor/db2/ibm/rs6000/aix-43/A.05.10/ packet.Z: None cksum(1) Output: DATA-PROTECTOR.OMNI-DB2-P,fr=A.05.10,fa=HP-UX_B.11.00_32/64, v=HP: 2186714503 2058433 /opt/omni/databases/vendor/db2/ibm/ rs6000/aix-43/A.05.10/packet.Z 1137080893 2059180 /opt/omni/databases/vendor/db2/ibm/ rs6000/aix-51/A.05.10/packet.Z 4085618357 1217993 /opt/omni/databases/vendor/db2/gpl/i386/ linux-60/A.05.10/packet.Z 1303697453 17 /opt/omni/databases/vendor/db2/gpl/i386/ linux-60/A.05.10/require.dat 1096679727 2647671 /opt/omni/databases/vendor/db2/hp/s800/ hp-ux-11/A.05.10/packet.Z Patch Conflicts: None Patch Dependencies: None Hardware Dependencies: None Other Dependencies: None Supersedes: None Equivalent Patches: None Patch Package Size: 7530 KBytes Installation Instructions: Please review all instructions and the Hewlett-Packard SupportLine User Guide or your Hewlett-Packard support terms and conditions for precautions, scope of license, restrictions, and, limitation of liability and warranties, before installing this patch. ------------------------------------------------------------ 1. Back up your system before installing a patch. 2. Login as root. 3. Copy the patch to the /tmp directory. 4. Move to the /tmp directory and unshar the patch: cd /tmp sh PHSS_29875 5. Run swinstall to install the patch: swinstall -x autoreboot=true -x patch_match_target=true \ -s /tmp/PHSS_29875.depot By default swinstall will archive the original software in /var/adm/sw/save/PHSS_29875. If you do not wish to retain a copy of the original software, include the patch_save_files option in the swinstall command above: -x patch_save_files=false WARNING: If patch_save_files is false when a patch is installed, the patch cannot be deinstalled. Please be careful when using this feature. For future reference, the contents of the PHSS_29875.text file is available in the product readme: swlist -l product -a readme -d @ /tmp/PHSS_29875.depot To put this patch on a magnetic tape and install from the tape drive, use the command: dd if=/tmp/PHSS_29875.depot of=/dev/rmt/0m bs=2k Special Installation Instructions: PHSS_29875: This patch has to be installed on the Installation Server host. The Data Protector DB2 agent must be redistributed to the DB2 client system(s) after the installation of the patch in order to get the fixes into effect. For distribution of the DB2 agent, refer to the Data Protector Installation guide. Patch includes no Site Specific Patches. A Site Specific Patch is a temporary hotfix that you might have received from HP Support if you have encountered a problem with Data Protector for which no General Release patch was or is available yet. If any newer Site Specific Patch - that is one with a higher number - for the DB2 agent is installed on your system, then you must re-apply this SSP after installing this DB2 agent patch.