Patch Name: PHSS_19303 Patch Description: s700_800 10.X HP SQL/HP-UX A.G3.11 Development Patch Creation Date: 99/10/15 Post Date: 99/10/21 Hardware Platforms - OS Releases: s700: 10.10 10.20 s800: 10.10 10.20 Products: HP SQL/HP-UX A.G3.09 A.G3.06 A.G3.05 A.G3.04 A.G3.03 A.G2.08 A.G2.07 Filesets: ALLBASE-SQL.AB-DEV Automatic Reboot?: No Status: General Superseded Critical: No Path Name: /hp-ux_patches/s700_800/10.X/PHSS_19303 Symptoms: PHSS_19303: SR# 8606103472 SQL aborts on Powerpatch 6 SR# 8606104108 Compiled and linked program OK with Allbase G.1 but not SR# 8606100824 Allbase G2.08 SETUPRECOVERY returns DBERR 14072 SR# 8606104922 Optimizer chooses bad access-plan, as it doesn't calculate SMJ-costs PHSS_19301: SR# 1653287458 Sqlutil >STOREINFO command needs to be more robust SR# 1653287474 SQLUTIL Restore produces completely unhelpful errors SR# 4701406009: multiconnect on multi-processor-system may fail with DBERR 4130 SR# 1653301788: Enhance Allbase/SQL so that DM CTR overflows do not occur PHSS_18451: SR# 1653301788: Enhance Allbase/SQL so that DM CTR overflows do not occur SR# 5003366013 SQLGEN does not correctly recognize the last row on multiple of 50. 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_19303: SR# 8606103472 SQL aborts on Powerpatch 6 SR# 8606104108 Compiled and linked program OK with Allbase G.1 but not SR# 8606100824 Allbase G2.08 SETUPRECOVERY returns DBERR 14072 SR# 8606104922 Optimizer chooses bad access-plan, as it doesn't calculate SMJ-costs PHSS_19301: SR# 1653287458 Sqlutil >STOREINFO command needs to be more robust SR# 1653287474 SQLUTIL Restore produces completely unhelpful errors SR# 4701406009: multiconnect on multi-processor-system may fail with DBERR 4130 SR# 1653301788: Enhance Allbase/SQL so that DM CTR overflows do not occur PHSS_18451: SR# 1653301788: Enhance Allbase/SQL so that DM CTR overflows do not occur SR# 5003366013 SQLGEN does not correctly recognize the last row on multiple of 50. 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 4701406009 1653301788 8606103472 8606104108 8606100824 8606104922 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.11 PASCAL Preprocessor/9000 ALLBASE/SQL HP36217-02A.G3.11.00 SQL Parser/Linearizer/9000 ALLBASE/SQL 09/30/99 HP36217-02A.G3.11 SQLX/9000 ALLBASE/SQL HP36217-02A.G3.11 NET AF Library ALLBASE/SQL 09/30/99 HP36217-02A.G3.11 NET Library ALLBASE/SQL 09/30/99 HP36217-02A.G3.11 NET VC Library ALLBASE/SQL 09/30/99 /opt/allbase/bin/psqlfor: HP36217-02A.G3.11 FORTRAN Preprocessor/9000 ALLBASE/SQL HP36217-02A.G3.11.00 SQL Parser/Linearizer/9000 ALLBASE/SQL 09/30/99 HP36217-02A.G3.11 SQLX/9000 ALLBASE/SQL HP36217-02A.G3.11 NET AF Library ALLBASE/SQL 09/30/99 HP36217-02A.G3.11 NET Library ALLBASE/SQL 09/30/99 HP36217-02A.G3.11 NET VC Library ALLBASE/SQL 09/30/99 /opt/allbase/bin/psqlc: HP36217-02A.G3.11 C Preprocessor/9000 ALLBASE/SQL HP36217-02A.G3.11.00 SQL Parser/Linearizer/9000 ALLBASE/SQL 09/30/99 HP36217-02A.G3.11 SQLX/9000 ALLBASE/SQL HP36217-02A.G3.11 NET AF Library ALLBASE/SQL 09/30/99 HP36217-02A.G3.11 NET Library ALLBASE/SQL 09/30/99 HP36217-02A.G3.11 NET VC Library ALLBASE/SQL 09/30/99 /opt/allbase/bin/psqlcbl: HP36217-02A.G3.11 COBOL Preprocessor/9000 ALLBASE/SQL HP36217-02A.G3.11.00 SQL Parser/Linearizer/9000 ALLBASE/SQL 09/30/99 HP36217-02A.G3.11 SQLX/9000 ALLBASE/SQL HP36217-02A.G3.11 NET AF Library ALLBASE/SQL 09/30/99 HP36217-02A.G3.11 NET Library ALLBASE/SQL 09/30/99 HP36217-02A.G3.11 NET VC Library ALLBASE/SQL 09/30/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: 3459860050 1698029 /opt/allbase/bin/psqlpas 1199982531 1476714 /opt/allbase/bin/psqlfor 3706168480 1878313 /opt/allbase/bin/psqlc 3183042191 1632442 /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_19302 s800: 10.10 10.20: PHSS_19302 Hardware Dependencies: None Other Dependencies: None Supersedes: PHSS_10265 PHSS_16381 PHSS_17539 PHSS_17541 PHSS_18451 PHSS_19301 Equivalent Patches: PHSS_20065: s700: 11.00 s800: 11.00 Patch Package Size: 6640 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_19303 5a. For a standalone system, run swinstall to install the patch: swinstall -x autoreboot=true -x match_target=true \ -s /tmp/PHSS_19303.depot By default swinstall will archive the original software in /var/adm/sw/patch/PHSS_19303. 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_19303.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_19303.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.