Patch Name: PHSS_17541 Patch Description: s700_800 10.X HP SQL/HP-UX A.G3.05 Development Patch Creation Date: 99/04/01 Post Date: 99/04/14 Hardware Platforms - OS Releases: s700: 10.10 10.20 s800: 10.10 10.20 Products: HP SQL/HP-UX A.G3.05 Filesets: ALLBASE-SQL.AB-DEV Automatic Reboot?: No Status: General Superseded Critical: No Path Name: /hp-ux_patches/s700_800/10.X/PHSS_17541 Symptoms: 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_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 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.05 PASCAL Preprocessor/9000 ALLBASE/SQL HP36217-02A.G3.05.00 SQL Parser/Linearizer/9000 ALLBASE/SQL 02/03/99 HP36217-02A.G3.05 SQLX/9000 ALLBASE/SQL HP36217-02A.G3.05 NET AF Library ALLBASE/SQL 03/28/99 HP36217-02A.G3.05 NET Library ALLBASE/SQL 03/28/99 HP36217-02A.G3.05 NET VC Library ALLBASE/SQL 03/28/99 /opt/allbase/bin/psqlfor: HP36217-02A.G3.05 FORTRAN Preprocessor/9000 ALLBASE/SQL HP36217-02A.G3.05.00 SQL Parser/Linearizer/9000 ALLBASE/SQL 02/03/99 HP36217-02A.G3.05 SQLX/9000 ALLBASE/SQL HP36217-02A.G3.05 NET AF Library ALLBASE/SQL 03/28/99 HP36217-02A.G3.05 NET Library ALLBASE/SQL 03/28/99 HP36217-02A.G3.05 NET VC Library ALLBASE/SQL 03/28/99 /opt/allbase/bin/psqlc: HP36217-02A.G3.05 C Preprocessor/9000 ALLBASE/SQL HP36217-02A.G3.05.00 SQL Parser/Linearizer/9000 ALLBASE/SQL 02/03/99 HP36217-02A.G3.05 SQLX/9000 ALLBASE/SQL HP36217-02A.G3.05 NET AF Library ALLBASE/SQL 03/28/99 HP36217-02A.G3.05 NET Library ALLBASE/SQL 03/28/99 HP36217-02A.G3.05 NET VC Library ALLBASE/SQL 03/28/99 /opt/allbase/bin/psqlcbl: HP36217-02A.G3.05 COBOL Preprocessor/9000 ALLBASE/SQL HP36217-02A.G3.05.00 SQL Parser/Linearizer/9000 ALLBASE/SQL 02/03/99 HP36217-02A.G3.05 SQLX/9000 ALLBASE/SQL HP36217-02A.G3.05 NET AF Library ALLBASE/SQL 03/28/99 HP36217-02A.G3.05 NET Library ALLBASE/SQL 03/28/99 HP36217-02A.G3.05 NET VC Library ALLBASE/SQL 03/28/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: 3816720782 1891096 /opt/allbase/bin/psqlpas 505283770 1669776 /opt/allbase/bin/psqlfor 495264267 2075472 /opt/allbase/bin/psqlc 4217625698 1825504 /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_17540 s800: 10.10 10.20: PHSS_17540 Hardware Dependencies: None Other Dependencies: None Supersedes: PHSS_10265 PHSS_16381 PHSS_17539 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_17541 5a. For a standalone system, run swinstall to install the patch: swinstall -x autoreboot=true -x match_target=true \ -s /tmp/PHSS_17541.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_17541.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_17541. 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_17541.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_17541.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.