Patch Name: PHSS_21576 Patch Description: s700_800 11.00 HP SQL/HP-UX A.G3.13 Development Patch Creation Date: 00/04/20 Post Date: 00/04/26 Hardware Platforms - OS Releases: s700: 11.00 s800: 11.00 Products: HP SQL/HP-UX A.G3.04 Filesets: ALLBASE-SQL.AB-DEV,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,v=HP Automatic Reboot?: No Status: General Release Critical: No Category Tags: defect_repair general_release Path Name: /hp-ux_patches/s700_800/11.X/PHSS_21576 Symptoms: PHSS_21576: SR# 8606130381 CR# JAGac95274 sql daemon dies/need to restart box PHSS_20879: CR# JAGab76626 SR# 8606107020 Performance problems with PSQLC CR# JAGac23669 SR# 5000678615 Need a silent reset of transaction id counter on overflow of that countr CR# JAGab74952 SR# 8606106104 DBCORE 1095 does not appear to be consistent on MPE/iX PHSS_20065: 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 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 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_18449: SR# 1653287227 ALLBASE/SQL internal error at JTMXMJ(9, ) when SMJ on cols w/ diff langs 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 Defect Description: PHSS_21576: SR# 8606130381 CR# JAGac95274 sql daemon dies/need to restart box PHSS_20879: CR# JAGab76626 SR# 8606107020 Performance problems with PSQLC CR# JAGac23669 SR# 5000678615 Need a silent reset of transaction id counter on overflow of that countr CR# JAGab74952 SR# 8606106104 DBCORE 1095 does not appear to be consistent on MPE/iX PHSS_20065: 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 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 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_18449: SR# 1653287227 ALLBASE/SQL internal error at JTMXMJ(9, ) when SMJ on cols w/ diff langs 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 Resolution: 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 8606107020 5000678615 8606106104 8606130381 Patch Files: ALLBASE-SQL.AB-DEV,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,v=HP: /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: ALLBASE-SQL.AB-DEV,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,v=HP: /opt/allbase/bin/psqlpas: HP36217-02A.G3.13 PASCAL Preprocessor/9000 ALLBASE/SQL HP36217-02A.G3.13.00 SQL Parser/Linearizer/9000 ALLBASE/SQL 03/30/00 HP36217-02A.G3.13 SQLX/9000 ALLBASE/SQL HP36217-02A.G3.13 NET AF Library ALLBASE/SQL 03/30/00 HP36217-02A.G3.13 NET Library ALLBASE/SQL 03/30/00 HP36217-02A.G3.13 NET VC Library ALLBASE/SQL 03/30/00 ALLBASE-SQL.AB-DEV,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,v=HP: /opt/allbase/bin/psqlfor: HP36217-02A.G3.13 FORTRAN Preprocessor/9000 ALLBASE/SQL HP36217-02A.G3.13.00 SQL Parser/Linearizer/9000 ALLBASE/SQL 03/30/00 HP36217-02A.G3.13 SQLX/9000 ALLBASE/SQL HP36217-02A.G3.13 NET AF Library ALLBASE/SQL 03/30/00 HP36217-02A.G3.13 NET Library ALLBASE/SQL 03/30/00 HP36217-02A.G3.13 NET VC Library ALLBASE/SQL 03/30/00 ALLBASE-SQL.AB-DEV,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,v=HP: /opt/allbase/bin/psqlc: HP36217-02A.G3.13 C Preprocessor/9000 ALLBASE/SQL HP36217-02A.G3.13.00 SQL Parser/Linearizer/9000 ALLBASE/SQL 03/30/00 HP36217-02A.G3.13 SQLX/9000 ALLBASE/SQL HP36217-02A.G3.13 NET AF Library ALLBASE/SQL 03/30/00 HP36217-02A.G3.13 NET Library ALLBASE/SQL 03/30/00 HP36217-02A.G3.13 NET VC Library ALLBASE/SQL 03/30/00 ALLBASE-SQL.AB-DEV,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,v=HP: /opt/allbase/bin/psqlcbl: HP36217-02A.G3.13 COBOL Preprocessor/9000 ALLBASE/SQL HP36217-02A.G3.13.00 SQL Parser/Linearizer/9000 ALLBASE/SQL 03/30/00 HP36217-02A.G3.13 SQLX/9000 ALLBASE/SQL HP36217-02A.G3.13 NET AF Library ALLBASE/SQL 03/30/00 HP36217-02A.G3.13 NET Library ALLBASE/SQL 03/30/00 HP36217-02A.G3.13 NET VC Library ALLBASE/SQL 03/30/00 ALLBASE-SQL.AB-DEV,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,v=HP: /opt/allbase/include/sqlcall.c: None ALLBASE-SQL.AB-DEV,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,v=HP: /opt/allbase/include/sqlcall.cbl: None ALLBASE-SQL.AB-DEV,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,v=HP: /opt/allbase/include/sqlcall.h: None ALLBASE-SQL.AB-DEV,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,v=HP: /opt/allbase/include/sqlxc.h: None cksum(1) Output: ALLBASE-SQL.AB-DEV,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,v=HP: 2496810602 1821455 /opt/allbase/bin/psqlpas ALLBASE-SQL.AB-DEV,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,v=HP: 2613091398 1596026 /opt/allbase/bin/psqlfor ALLBASE-SQL.AB-DEV,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,v=HP: 1526420433 2001738 /opt/allbase/bin/psqlc ALLBASE-SQL.AB-DEV,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,v=HP: 2736850288 1755872 /opt/allbase/bin/psqlcbl ALLBASE-SQL.AB-DEV,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,v=HP: 3725122807 1049 /opt/allbase/include/sqlcall.c ALLBASE-SQL.AB-DEV,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,v=HP: 606924485 41 /opt/allbase/include/sqlcall.cbl ALLBASE-SQL.AB-DEV,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,v=HP: 2007079305 20 /opt/allbase/include/sqlcall.h ALLBASE-SQL.AB-DEV,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,v=HP: 4068996826 40378 /opt/allbase/include/sqlxc.h Patch Conflicts: None Patch Dependencies: s700: 11.00: PHSS_21575 s800: 11.00: PHSS_21575 Hardware Dependencies: None Other Dependencies: None Supersedes: PHSS_18449 PHSS_20065 PHSS_20879 Equivalent Patches: PHSS_20881: s700: 10.20 s800: 10.20 Patch Package Size: 7080 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_21576 5. Run swinstall to install the patch: swinstall -x autoreboot=true -x patch_match_target=true \ -s /tmp/PHSS_21576.depot By default swinstall will archive the original software in /var/adm/sw/save/PHSS_21576. If you do not wish to retain a copy of the original software, use the patch_save_files option: swinstall -x autoreboot=true -x patch_match_target=true \ -x patch_save_files=false -s /tmp/PHSS_21576.depot 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_21576.text file is available in the product readme: swlist -l product -a readme -d @ /tmp/PHSS_21576.depot To put this patch on a magnetic tape and install from the tape drive, use the command: dd if=/tmp/PHSS_21576.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.