Patch Name: PHSS_18451 Patch Description: s700_800 10.X HP SQL/HP-UX A.G3.06 Development Patch Creation Date: 99/07/21 Post Date: 99/07/26 Hardware Platforms - OS Releases: s700: 10.10 10.20 s800: 10.10 10.20 Products: HP SQL/HP-UX A.G3.05 A.G3.04 A.G3.03 Filesets: ALLBASE-SQL.AB-DEV Automatic Reboot?: No Status: General Superseded Critical: No Path Name: /hp-ux_patches/s700_800/10.X/PHSS_18451 Symptoms: PHSS_18451: SR# 5003366013 SQLGEN does not correctly recognize the last row on multiple of 50. SR# 1653287458 Sqlutil >STOREINFO command needs to be more robust SR# 1653287474 SQLUTIL Restore produces completely unhelpful errors PHSS_17541: SR# 1653287227 ALLBASE/SQL internal error at JTMXMJ(9, ) when SMJ on cols w/ diff langs 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_18451: SR# 5003366013 SQLGEN does not correctly recognize the last row on multiple of 50. SR# 1653287458 Sqlutil >STOREINFO command needs to be more robust SR# 1653287474 SQLUTIL Restore produces completely unhelpful errors PHSS_17541: SR# 1653287227 ALLBASE/SQL internal error at JTMXMJ(9, ) when SMJ on cols w/ diff langs 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 1653287227 5003366013 1653287458 1653287474 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.G3.06 PASCAL Preprocessor/9000 ALLBASE/SQL HP36217-02A.G3.06.00 SQL Parser/Linearizer/9000 ALLBASE/SQL 05/31/99 HP36217-02A.G3.06 SQLX/9000 ALLBASE/SQL HP36217-02A.G3.06 NET AF Library ALLBASE/SQL 05/31/99 HP36217-02A.G3.06 NET Library ALLBASE/SQL 05/31/99 HP36217-02A.G3.06 NET VC Library ALLBASE/SQL 05/31/99 /opt/allbase/bin/psqlfor: HP36217-02A.G3.06 FORTRAN Preprocessor/9000 ALLBASE/SQL HP36217-02A.G3.06.00 SQL Parser/Linearizer/9000 ALLBASE/SQL 05/31/99 HP36217-02A.G3.06 SQLX/9000 ALLBASE/SQL HP36217-02A.G3.06 NET AF Library ALLBASE/SQL 05/31/99 HP36217-02A.G3.06 NET Library ALLBASE/SQL 05/31/99 HP36217-02A.G3.06 NET VC Library ALLBASE/SQL 05/31/99 /opt/allbase/bin/psqlc: HP36217-02A.G3.06 C Preprocessor/9000 ALLBASE/SQL HP36217-02A.G3.06.00 SQL Parser/Linearizer/9000 ALLBASE/SQL 05/31/99 HP36217-02A.G3.06 SQLX/9000 ALLBASE/SQL HP36217-02A.G3.06 NET AF Library ALLBASE/SQL 05/31/99 HP36217-02A.G3.06 NET Library ALLBASE/SQL 05/31/99 HP36217-02A.G3.06 NET VC Library ALLBASE/SQL 05/31/99 /opt/allbase/bin/psqlcbl: HP36217-02A.G3.06 COBOL Preprocessor/9000 ALLBASE/SQL HP36217-02A.G3.06.00 SQL Parser/Linearizer/9000 ALLBASE/SQL 05/31/99 HP36217-02A.G3.06 SQLX/9000 ALLBASE/SQL HP36217-02A.G3.06 NET AF Library ALLBASE/SQL 05/31/99 HP36217-02A.G3.06 NET Library ALLBASE/SQL 05/31/99 HP36217-02A.G3.06 NET VC Library ALLBASE/SQL 05/31/99 /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: 1258304597 1891088 /opt/allbase/bin/psqlpas 4264138789 1669776 /opt/allbase/bin/psqlfor 428417183 2071376 /opt/allbase/bin/psqlc 4085748755 1821408 /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_18450 s800: 10.10 10.20: PHSS_18450 Hardware Dependencies: None Other Dependencies: None Supersedes: PHSS_10265 PHSS_16381 PHSS_17539 PHSS_17541 Equivalent Patches: None Patch Package Size: 7390 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_18451 5a. For a standalone system, run swinstall to install the patch: swinstall -x autoreboot=true -x match_target=true \ -s /tmp/PHSS_18451.depot By default swinstall will archive the original software in /var/adm/sw/patch/PHSS_18451. 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_18451.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_18451.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.