Patch Name: PHSS_17539 Patch Description: s700_800 10.X HP SQL/HP-UX A.G2.08 Development Patch Creation Date: 99/02/02 Post Date: 99/02/03 Hardware Platforms - OS Releases: s700: 10.10 10.20 s800: 10.10 10.20 Products: HP SQL/HP-UX A.G2.08 Filesets: ALLBASE-SQL.AB-DEV Automatic Reboot?: No Status: General Superseded Critical: No Path Name: /hp-ux_patches/s700_800/10.X/PHSS_17539 Symptoms: PHSS_17539: SR# 1653248781 SQLUTIL DBWARN 13343 when SETUPRECOVERY to a time and STORE was static SR# 1653257451 SQLMON aborts in /loc o if logon name too long > 13chs SR# 1653287441 SQLUTIL Store, problems if total of filenames >12k ; ON G1 store corrupt SR# 1653287466 SQLUTIL RESTORE command will fail if the total filenames >16k SR# 1653139980 dbwarn 8 during load from external for filed of type decimal (18,0) SR# 1653199943 ISQL gives wrong data if 2 people do selects in the same directory SR# 1653285379 Allbase connect takes several seconds with lang=ja_JP.SJIS on 10.20 SR# 5003434548 Date in Banner use to be corrupt when lang set to japanese (LANG=japanese) 10x version. SR# 1653284380 Ctime date field used to be corrupt when lang set to japanese (LANG=japanese) 10x version. SR# 1653283937 Replication failure after a variable amount of time. SR# 1653275404 Running a job failed on validate force all procedures with autocommit; SR# 1653288621 G2.07 Allbase/SQL on 10.20 cannot psqlc with LANG=ja_JP.SJIS PHSS_16381: SR# 1653203976 INDEX not used for decimal = 10 SR# 1653215228 BLOBS do not work certain record lengths SR# 1653229401 Alter table with Lang = xxx gets type and Lang wrong SR# 5003431015 C pre prog aborts in NLJUDGE SR# 5003394312 2080's from rmalph with local_sls - 1 SR# 1653133330 Allbase/sql 2ND DEFER CONSTRAINTS fails after COMMIT with Kept Cursor SR# 5003349522 Orphaned DBMON processes cause SQL patch installation fail. SR# 1653248237 A 3 table join in Allbase/SQL does not return all the rows SR# 1653251116 ImageSQL may not get data with LIKE or LIKE on key item SR# 1653251538 IMAGESQL Select returns no rows. SYSTEM.IMAGEKEY NDISTINCT incorrect. 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_17539: SR# 1653248781 SQLUTIL DBWARN 13343 when SETUPRECOVERY to a time and STORE was static SR# 1653257451 SQLMON aborts in /loc o if logon name too long > 13chs SR# 1653287441 SQLUTIL Store, problems if total of filenames >12k ; ON G1 store corrupt SR# 1653287466 SQLUTIL RESTORE command will fail if the total filenames >16k SR# 1653139980 dbwarn 8 during load from external for filed of type decimal (18,0) SR# 1653199943 ISQL gives wrong data if 2 people do selects in the same directory SR# 1653285379 Allbase connect takes several seconds with lang=ja_JP.SJIS on 10.20 SR# 5003434548 Date in Banner use to be corrupt when lang set to japanese (LANG=japanese) 10x version. SR# 1653284380 Ctime date field used to be corrupt when lang set to japanese (LANG=japanese) 10x version. SR# 1653283937 Replication failure after a variable amount of time. SR# 1653275404 Running a job failed on validate force all procedures with autocommit; SR# 1653288621 G2.07 Allbase/SQL on 10.20 cannot psqlc with LANG=ja_JP.SJIS PHSS_16381: SR# 1653203976 INDEX not used for decimal = 10 SR# 1653215228 BLOBS do not work certain record lengths SR# 1653229401 Alter table with Lang = xxx gets type and Lang wrong SR# 5003431015 C pre prog aborts in NLJUDGE SR# 5003394312 2080's from rmalph with local_sls - 1 SR# 1653133330 Allbase/sql 2ND DEFER CONSTRAINTS fails after COMMIT with Kept Cursor SR# 5003349522 Orphaned DBMON processes cause SQL patch installation fail. SR# 1653248237 A 3 table join in Allbase/SQL does not return all the rows SR# 1653251116 ImageSQL may not get data with LIKE or LIKE on key item SR# 1653251538 IMAGESQL Select returns no rows. SYSTEM.IMAGEKEY NDISTINCT incorrect. 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 1653203976 1653215228 1653229401 5003431015 1653248781 1653257451 1653287441 1653287466 1653139980 1653199943 1653285379 5003434548 1653284380 1653283937 1653275404 1653288621 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.G2.08 PASCAL Preprocessor/9000 ALLBASE/SQL HP36217-02A.G2.08.00 SQL Parser/Linearizer/9000 ALLBASE/SQL 01/25/99 HP36217-02A.G2.08 SQLX/9000 ALLBASE/SQL HP36217-02A.G2.08 NET AF Library ALLBASE/SQL 08/30/98 HP36217-02A.G2.08 NET Library ALLBASE/SQL 08/30/98 HP36217-02A.G2.08 NET VC Library ALLBASE/SQL 08/30/98 /opt/allbase/bin/psqlfor: HP36217-02A.G2.08 FORTRAN Preprocessor/9000 ALLBASE/SQL HP36217-02A.G2.08.00 SQL Parser/Linearizer/9000 ALLBASE/SQL 01/25/99 HP36217-02A.G2.08 SQLX/9000 ALLBASE/SQL HP36217-02A.G2.08 NET AF Library ALLBASE/SQL 08/30/98 HP36217-02A.G2.08 NET Library ALLBASE/SQL 08/30/98 HP36217-02A.G2.08 NET VC Library ALLBASE/SQL 08/30/98 /opt/allbase/bin/psqlc: HP36217-02A.G2.08 C Preprocessor/9000 ALLBASE/SQL HP36217-02A.G2.08.00 SQL Parser/Linearizer/9000 ALLBASE/SQL 01/25/99 HP36217-02A.G2.08 SQLX/9000 ALLBASE/SQL HP36217-02A.G2.08 NET AF Library ALLBASE/SQL 08/30/98 HP36217-02A.G2.08 NET Library ALLBASE/SQL 08/30/98 HP36217-02A.G2.08 NET VC Library ALLBASE/SQL 08/30/98 /opt/allbase/bin/psqlcbl: HP36217-02A.G2.08 COBOL Preprocessor/9000 ALLBASE/SQL HP36217-02A.G2.08.00 SQL Parser/Linearizer/9000 ALLBASE/SQL 01/25/99 HP36217-02A.G2.08 SQLX/9000 ALLBASE/SQL HP36217-02A.G2.08 NET AF Library ALLBASE/SQL 08/30/98 HP36217-02A.G2.08 NET Library ALLBASE/SQL 08/30/98 HP36217-02A.G2.08 NET VC Library ALLBASE/SQL 08/30/98 /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: 1557547965 1677543 /opt/allbase/bin/psqlpas 1270502341 1452130 /opt/allbase/bin/psqlfor 1982064105 1853730 /opt/allbase/bin/psqlc 3001096995 1607860 /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: s700: 10.10 10.20: PHSS_17538 s800: 10.10 10.20: PHSS_17538 Hardware Dependencies: None Other Dependencies: None Supersedes: PHSS_10265 PHSS_16381 Equivalent Patches: None Patch Package Size: 6540 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_17539 5a. For a standalone system, run swinstall to install the patch: swinstall -x autoreboot=true -x match_target=true \ -s /tmp/PHSS_17539.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_17539.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_17539. 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_17539.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_17539.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.