Patch Name: PHSS_10265 Patch Description: s700_800 10.X HP SQL/HP-UX A.G1.21 Development patch Creation Date: 97/03/10 Post Date: 97/03/14 Hardware Platforms - OS Releases: s700: 10.10 10.20 s800: 10.10 10.20 Products: HP SQL/HP-UX A.G1.21 Filesets: ALLBASE-SQL.AB-DEV Automatic Reboot?: No Status: General Superseded Critical: No Path Name: /hp-ux_patches/s700_800/10.X/PHSS_10265 Symptoms: PHSS_10265: SR# 1653190942 ALLBASE/SQL internal error at JTMXSQ(1, ). (DBERR 4051) SR# 5000712372 C program in dynamic mode generates DBERR 4053 SR# 5003331991 C preprocessor limited to 255 bytes while C compiler can have 1024. SR # 1653199083 Selects return wrong number and incorrect rows in results. Defect Description: PHSS_10265: SR# 1653190942 ALLBASE/SQL internal error at JTMXSQ(1, ). (DBERR 4051) SR# 5000712372 C program in dynamic mode generates DBERR 4053 SR# 5003331991 C preprocessor limited to 255 bytes while C compiler can have 1024. SR # 1653199083 Selects return wrong number and incorrect rows in results. SR: 1653190942 5000712372 5003331991 1653199083 Patch Files: /opt/allbase/bin/psqlpas /opt/allbase/bin/psqlfor /opt/allbase/bin/psqlc /opt/allbase/bin/psqlcbl /opt/allbase/include/sqlcall.c /opt/allbase/include/sqlcall.cbl /opt/allbase/include/sqlcall.h /opt/allbase/include/sqlxc.h what(1) Output: /opt/allbase/bin/psqlpas: HP36217-02A.G1.21 PASCAL Preprocessor/9000 ALLBASE/SQL HP36217-02A.G1.21.00 SQL Parser/Linearizer/9000 ALLBASE/SQL 02/11/97 HP36217-02A.G1.21 SQLX/9000 ALLBASE/SQL HP36217-02A.G1.21 NET AF Library ALLBASE/SQL 11/20/96 HP36217-02A.G1.21 NET Library ALLBASE/SQL 11/20/96 HP36217-02A.G1.21 NET VC Library ALLBASE/SQL 11/20/96 /opt/allbase/bin/psqlfor: HP36217-02A.G1.21 FORTRAN Preprocessor/9000 ALLBASE/SQL HP36217-02A.G1.21.00 SQL Parser/Linearizer/9000 ALLBASE/SQL 02/11/97 HP36217-02A.G1.21 SQLX/9000 ALLBASE/SQL HP36217-02A.G1.21 NET AF Library ALLBASE/SQL 11/20/96 HP36217-02A.G1.21 NET Library ALLBASE/SQL 11/20/96 HP36217-02A.G1.21 NET VC Library ALLBASE/SQL 11/20/96 /opt/allbase/bin/psqlc: HP36217-02A.G1.21 C Preprocessor/9000 ALLBASE/SQL HP36217-02A.G1.21.00 SQL Parser/Linearizer/9000 ALLBASE/SQL 02/11/97 HP36217-02A.G1.21 SQLX/9000 ALLBASE/SQL HP36217-02A.G1.21 NET AF Library ALLBASE/SQL 11/20/96 HP36217-02A.G1.21 NET Library ALLBASE/SQL 11/20/96 HP36217-02A.G1.21 NET VC Library ALLBASE/SQL 11/20/96 /opt/allbase/bin/psqlcbl: HP36217-02A.G1.21 COBOL Preprocessor/9000 ALLBASE/SQL HP36217-02A.G1.21.00 SQL Parser/Linearizer/9000 ALLBASE/SQL 02/11/97 HP36217-02A.G1.21 SQLX/9000 ALLBASE/SQL HP36217-02A.G1.21 NET AF Library ALLBASE/SQL 11/20/96 HP36217-02A.G1.21 NET Library ALLBASE/SQL 11/20/96 HP36217-02A.G1.21 NET VC Library ALLBASE/SQL 11/20/96 /opt/allbase/include/sqlcall.c: None /opt/allbase/include/sqlcall.cbl: None /opt/allbase/include/sqlcall.h: None /opt/allbase/include/sqlxc.h: None cksum(1) Output: 1287974293 1689652 /opt/allbase/bin/psqlpas 2546614215 1468328 /opt/allbase/bin/psqlfor 1808917571 1865832 /opt/allbase/bin/psqlc 1979037613 1619956 /opt/allbase/bin/psqlcbl 3725122807 1049 /opt/allbase/include/sqlcall.c 606924485 41 /opt/allbase/include/sqlcall.cbl 2007079305 20 /opt/allbase/include/sqlcall.h 4068996826 40378 /opt/allbase/include/sqlxc.h Patch Conflicts: None Patch Dependencies: None Hardware Dependencies: None Other Dependencies: None Supersedes: None Equivalent Patches: None Patch Package Size: 6590 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_10265 5a. For a standalone system, run swinstall to install the patch: swinstall -x autoreboot=true -x match_target=true \ -s /tmp/PHSS_10265.depot 5b. For a homogeneous NFS Diskless cluster run swcluster on the server to install the patch on the server and the clients: swcluster -i -b This will invoke swcluster in the interactive mode and force all clients to be shut down. WARNING: All cluster clients must be shut down prior to the patch installation. Installing the patch while the clients are booted is unsupported and can lead to serious problems. The swcluster command will invoke an swinstall session in which you must specify: alternate root path - default is /export/shared_root/OS_700 source depot path - /tmp/PHSS_10265.depot To complete the installation, select the patch by choosing "Actions -> Match What Target Has" and then "Actions -> Install" from the Menubar. 5c. For a heterogeneous NFS Diskless cluster: - run swinstall on the server as in step 5a to install the patch on the cluster server. - run swcluster on the server as in step 5b to install the patch on the cluster clients. By default swinstall will archive the original software in /var/adm/sw/patch/PHSS_10265. If you do not wish to retain a copy of the original software, you can create an empty file named /var/adm/sw/patch/PATCH_NOSAVE. Warning: If this file exists when a patch is installed, the patch cannot be deinstalled. Please be careful when using this feature. It is recommended that you move the PHSS_10265.text file to /var/adm/sw/patch for future reference. To put this patch on a magnetic tape and install from the tape drive, use the command: dd if=/tmp/PHSS_10265.depot of=/dev/rmt/0m bs=2k Special Installation Instructions: You must to use SQLINSTL before running ANY new version (later than G.0). For example, when you go from G1.14 to G1.15, then you have to run SQLINSTL for successful migration. The SQLINSTL script is provided in the G.1 version of ALLBASE/SQL to make it easy for a DBA to move to a delta release. Using SQLINSTL ensures that you will have access to the most recent version of the SYSTEM and CATALOG views, and it also uses VALIDATE FORCE statements to revalidate all stored sections.