Patch Name: PHSS_31209 Patch Description: s700_800 11.00 HP SQL/HP-UX A.G3.46 Run-Time Patch Creation Date: 04/07/19 Post Date: 04/07/21 Hardware Platforms - OS Releases: s700: 11.00 s800: 11.00 Products: HP SQL/HP-UX A.G3.14 Filesets: ALLBASE-SQL.AB-RUN,fr=A.G3.14,fa=HP-UX_B.11.00_32/64,v=HP ALLBASE-SQL.AB-NET,fr=A.G3.14,fa=HP-UX_B.11.00_32/64,v=HP ALLBASE-SQL.AB-SUPPORT,fr=A.G3.14,fa=HP-UX_B.11.00_32/64,v=HP ALLBASE-SQL.AB-REPLICATE,fr=A.G3.14,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_31209 Symptoms: PHSS_31209: SR# 8606335860 CR# JAGae96914 RESTORE fails when name of input file exceeds 36 character SR# 8606350874 CR# JAGaf11686 ALLBASE/SQL internal error at JBLFXPF DBERR 4051 SR# 8606351607 CR# JAGaf12412 allbase allows logfiles larger then what can be processed PHSS_26184: SR# 8606233604 Allbase Replicate UX sometimes stops Replicating when Checkpoint occur PHSS_25631: SR# 8606206557 CR# JAGad75730 unload failure DBERR 237 while unloading data SR# 8606216499 CR# JAGad85668 Allbase cannot handle some languages on 10.20 PHSS_24452: SR# 8606182986 SELECT with SUB_STRING on a NLS varchar column with null values gives DBcore internal error SR# 8606196069 SQLMON does not work on G3.23 PHSS_23889: SR# 8606177425 SQLMOn does not work since G3.15 SR# 8606184134 DBERR 10071 when using Allbase/Net SR# 8606167904 NLS-Problem: Allbase connect changes the display of printf of numbers SR# 8606160803 Enhance Allbase/SQL to allow implicit AS clause as well as explicit PHSS_22091: SR# 1653306985 SELECT with SUB_STRING get error ALLBASE/SQL internal error at JASNLMV(1 SR# 8606134741 Function 'LOWER' doesn't work if Lang = German. SR# 8606124122 isql abort pascal escape code 2031719 dberr 237 when loading tables Defect Description: PHSS_31209: SR# 8606335860 CR# JAGae96914 RESTORE fails when name of input file exceeds 36 character SR# 8606350874 CR# JAGaf11686 ALLBASE/SQL internal error at JBLFXPF DBERR 4051 SR# 8606351607 CR# JAGaf12412 allbase allows logfiles larger then what can be processed PHSS_26184: SR# 8606233604 Allbase Replicate UX sometimes stops Replicating when Checkpoint occur PHSS_25631: SR# 8606206557 CR# JAGad75730 unload failure DBERR 237 while unloading data SR# 8606216499 CR# JAGad85668 Allbase cannot handle some languages on 10.20 PHSS_24452: SR# 8606182986 SELECT with SUB_STRING on a NLS varchar column with null values gives DBcore internal error SR# 8606196069 SQLMON does not work on G3.23 PHSS_23889: SR# 8606177425 SQLMOn does not work since G3.15 SR# 8606184134 DBERR 10071 when using Allbase/Net SR# 8606167904 NLS-Problem: Allbase connect changes the display of printf of numbers SR# 8606160803 Enhance Allbase/SQL to allow implicit AS clause as well as explicit PHSS_22091: SR# 1653306985 SELECT with SUB_STRING get error ALLBASE/SQL internal error at JASNLMV(1 SR# 8606134741 Function 'LOWER' doesn't work if Lang = German. SR# 8606124122 isql abort pascal escape code 2031719 dberr 237 when loading tables Resolution: Enhancement: No SR: 1653306985 8606134741 8606124122 8606177425 8606184134 8606167904 8606160803 8606182986 8606196069 8606206557 8606216499 8606233604 8606335860 8606350874 8606351607 Patch Files: ALLBASE-SQL.AB-RUN,fr=A.G3.14,fa=HP-UX_B.11.00_32/64,v=HP: /opt/allbase/bin/sqlmig /opt/allbase/bin/sqlmon /opt/allbase/bin/sqlgen /opt/allbase/bin/sqlutil /opt/allbase/bin/isql /opt/allbase/bin/sqlaudit /opt/allbase/bin/sqlcheck /opt/allbase/bin/sqlver /opt/allbase/lbin/sqldaemon /opt/allbase/lbin/hpsqlproc /opt/allbase/lib/libsql.a /opt/allbase/lib/hpsqlcat /opt/allbase/lib/isqlwel /opt/allbase/lib/nls/C/sqlver.cat /opt/allbase/lib/hpsql/sqlinstl /opt/allbase/lib/hpsql/odbcview /opt/allbase/bin/dumpshm ALLBASE-SQL.AB-NET,fr=A.G3.14,fa=HP-UX_B.11.00_32/64,v=HP: /opt/allbase/bin/hpdaARPA /opt/allbase/bin/netutil ALLBASE-SQL.AB-SUPPORT,fr=A.G3.14,fa=HP-UX_B.11.00_32/64, v=HP: /usr/local/bin/dbcshell /usr/local/bin/sqlkill /usr/local/bin/fixmod ALLBASE-SQL.AB-REPLICATE,fr=A.G3.14,fa=HP-UX_B.11.00_32/64, v=HP: /opt/allbase/lib/libwss.a what(1) Output: ALLBASE-SQL.AB-RUN,fr=A.G3.14,fa=HP-UX_B.11.00_32/64,v=HP: /opt/allbase/bin/sqlmig: $Revision: 92453-07 linker linker crt0.o B.11.30 011005 $ HP36217-02A.G3.46 SQLMigrate/9000 ALLBASE/SQL HPDBCORE A.G3.46 06/28/04 ALLBASE/SQL ALLBASE-SQL.AB-RUN,fr=A.G3.14,fa=HP-UX_B.11.00_32/64,v=HP: /opt/allbase/bin/sqlmon: $Revision: 92453-07 linker linker crt0.o B.11.30 011005 $ HP36217-02A.G3.46 SQLMonitor/9000 ALLBASE/SQL HPDBCORE A.G3.46 06/28/04 ALLBASE/SQL ALLBASE-SQL.AB-RUN,fr=A.G3.14,fa=HP-UX_B.11.00_32/64,v=HP: /opt/allbase/bin/sqlgen: $Revision: 92453-07 linker linker crt0.o B.11.30 011005 $ HP36217-02A.G3.46 SQL Command Generator/9000 ALLBASE/SQL HP36217-02A.G3.46 SQLX/9000 ALLBASE/SQL HP36217-02A.G3.46.00 SQL Parser/Linearizer/9000 ALLBASE/SQL 06/28/04 HP36217-02A.G3.46 NET AF Library ALLBASE/SQL 06/28/04 HP36217-02A.G3.46 NET Library ALLBASE/SQL 06/28/04 HP36217-02A.G3.46 NET VC Library ALLBASE/SQL 06/28/04 HPDBCORE A.G3.46 06/28/04 ALLBASE/SQL ALLBASE-SQL.AB-RUN,fr=A.G3.14,fa=HP-UX_B.11.00_32/64,v=HP: /opt/allbase/bin/sqlutil: $Revision: 92453-07 linker linker crt0.o B.11.30 011005 $ HP36217-02A.G3.46 DBE Utility/9000 ALLBASE/SQL HPDBCORE A.G3.46 06/28/04 ALLBASE/SQL ALLBASE-SQL.AB-RUN,fr=A.G3.14,fa=HP-UX_B.11.00_32/64,v=HP: /opt/allbase/bin/isql: $Revision: 92453-07 linker linker crt0.o B.11.30 011005 $ HP36217-02A.G3.46 Interactive SQL/9000 ALLBASE/SQL HP36217-02A.G3.46 SQLX/9000 ALLBASE/SQL HP36217-02A.G3.46.00 SQL Parser/Linearizer/9000 ALLBASE/SQL 06/28/04 HP36217-02A.G3.46 NET AF Library ALLBASE/SQL 06/28/04 HP36217-02A.G3.46 NET Library ALLBASE/SQL 06/28/04 HP36217-02A.G3.46 NET VC Library ALLBASE/SQL 06/28/04 ALLBASE-SQL.AB-RUN,fr=A.G3.14,fa=HP-UX_B.11.00_32/64,v=HP: /opt/allbase/bin/dumpshm: $Revision: 92453-07 linker linker crt0.o B.11.30 011005 $ HPDBCORE A.G3.46 06/28/04 ALLBASE/SQL ALLBASE-SQL.AB-RUN,fr=A.G3.14,fa=HP-UX_B.11.00_32/64,v=HP: /opt/allbase/bin/sqlaudit: HP36217-02A.G3.46 Replicate/9000 ALLBASE/SQL HP36217-02A.G3.46 SQLX/9000 ALLBASE/SQL HP36217-02A.G3.46.00 SQL Parser/Linearizer/9000 ALLBASE/SQL 06/28/04 HP36217-02A.G3.46 NET AF Library ALLBASE/SQL 06/28/04 HP36217-02A.G3.46 NET Library ALLBASE/SQL 06/28/04 HP36217-02A.G3.46 NET VC Library ALLBASE/SQL 06/28/04 ALLBASE-SQL.AB-RUN,fr=A.G3.14,fa=HP-UX_B.11.00_32/64,v=HP: /opt/allbase/bin/sqlcheck: $Revision: 92453-07 linker linker crt0.o B.11.30 011005 $ HP36217-02A.G3.46 SQLCheck/9000 ALLBASE/SQL HPDBCORE A.G3.46 06/28/04 ALLBASE/SQL ALLBASE-SQL.AB-RUN,fr=A.G3.14,fa=HP-UX_B.11.00_32/64,v=HP: /opt/allbase/bin/sqlver: HP36217 A.G3.00 SQLVER.CAT/9000 ALLBASE/SQL 06/06/97 HP36217 A.G3.00 SQLVER/9000 ALLBASE/SQL 06/06/97 ALLBASE-SQL.AB-RUN,fr=A.G3.14,fa=HP-UX_B.11.00_32/64,v=HP: /opt/allbase/lbin/sqldaemon: $Revision: 92453-07 linker linker crt0.o B.11.30 011005 $ HPDBCORE A.G3.46 06/28/04 ALLBASE/SQL ALLBASE-SQL.AB-RUN,fr=A.G3.14,fa=HP-UX_B.11.00_32/64,v=HP: /opt/allbase/lbin/hpsqlproc: $Revision: 92453-07 linker linker crt0.o B.11.30 011005 $ HP36217-02A.G3.46.00 Query Processor/9000 ALLBASE/SQL 06/28/04 HP36217-02A.G3.46 SQLX/9000 ALLBASE/SQL HP36217-02A.G3.46.00 SQL Parser/Linearizer/9000 ALLBASE/SQL 06/28/04 HP36217-02A.G3.46 NET VC Library ALLBASE/SQL 06/28/04 HP36217-02A.G3.46 NET AF Library ALLBASE/SQL 06/28/04 HP36217-02A.G3.46 NET Library ALLBASE/SQL 06/28/04 HPDBCORE A.G3.46 06/28/04 ALLBASE/SQL ALLBASE-SQL.AB-RUN,fr=A.G3.14,fa=HP-UX_B.11.00_32/64,v=HP: /opt/allbase/lib/libsql.a: HP36217-02A.G3.46 NET AF Library ALLBASE/SQL 06/28/04 HP36217-02A.G3.46 NET Library ALLBASE/SQL 06/28/04 HP36217-02A.G3.46 NET VC Library ALLBASE/SQL 06/28/04 HP36217-02A.G3.46.00 SQL Parser/Linearizer/9000 ALLBASE/SQL 06/28/04 HP36217-02A.G3.46 SQLX/9000 ALLBASE/SQL HP36217-02A.G3.46 PASCAL Preprocessor/9000 ALLBASE/SQL HP36217-02A.G3.46 C Preprocessor/9000 ALLBASE/SQL HP36217-02A.G3.46 FORTRAN Preprocessor/9000 ALLBASE/SQL HP36217-02A.G3.46 COBOL Preprocessor/9000 ALLBASE/SQL HP36217-02A.G3.46 NET VC Library ALLBASE/SQL 06/28/04 ALLBASE-SQL.AB-RUN,fr=A.G3.14,fa=HP-UX_B.11.00_32/64,v=HP: /opt/allbase/lib/hpsqlcat: HP36217-02A.G3.46 HPSQLCAT ALLBASE SQL/HP-UX ALLBASE-SQL.AB-RUN,fr=A.G3.14,fa=HP-UX_B.11.00_32/64,v=HP: /opt/allbase/lib/isqlwel: None ALLBASE-SQL.AB-RUN,fr=A.G3.14,fa=HP-UX_B.11.00_32/64,v=HP: /opt/allbase/lib/nls/C/sqlver.cat: None ALLBASE-SQL.AB-RUN,fr=A.G3.14,fa=HP-UX_B.11.00_32/64,v=HP: /opt/allbase/lib/hpsql/sqlinstl: None ALLBASE-SQL.AB-RUN,fr=A.G3.14,fa=HP-UX_B.11.00_32/64,v=HP: /opt/allbase/lib/hpsql/odbcview: None ALLBASE-SQL.AB-NET,fr=A.G3.14,fa=HP-UX_B.11.00_32/64,v=HP: /opt/allbase/bin/hpdaARPA: $Revision: 92453-07 linker linker crt0.o B.11.30 011005 $ HP36217-02A.G3.46 ALLBASE/NET Utility/9000 ALLBASE/SQL ALLBASE-SQL.AB-NET,fr=A.G3.14,fa=HP-UX_B.11.00_32/64,v=HP: /opt/allbase/bin/netutil: $Revision: 92453-07 linker linker crt0.o B.11.30 011005 $ HP36217-02A.G3.46 ALLBASE/NET Utility/9000 ALLBASE/SQL HP36217-02A.G3.46 NET AF Library ALLBASE/SQL 06/28/04 HP36217-02A.G3.46 NET UF Library ALLBASE/SQL 06/28/04 ALLBASE-SQL.AB-SUPPORT,fr=A.G3.14,fa=HP-UX_B.11.00_32/64, v=HP: /usr/local/bin/dbcshell: HP92453-02A.11.00 HP-UX SYMBOLIC DEBUGGER (END.O ILP32) $Revision: 75.02 $ HPDBCORE A.G3.46 06/28/04 ALLBASE/SQL ALLBASE-SQL.AB-SUPPORT,fr=A.G3.14,fa=HP-UX_B.11.00_32/64, v=HP: /usr/local/bin/sqlkill: $Revision: 92453-07 linker linker crt0.o B.11.30 011005 $ HPDBCORE A.G3.46 06/28/04 ALLBASE/SQL ALLBASE-SQL.AB-SUPPORT,fr=A.G3.14,fa=HP-UX_B.11.00_32/64, v=HP: /usr/local/bin/fixmod: FIXMOD A.02.01 HP36217-02A.G3.46 SQLX/9000 ALLBASE/SQL HP36217-02A.G3.46.00 SQL Parser/Linearizer/9000 ALLBASE/SQL 06/28/04 HP36217-02A.G3.46 NET AF Library ALLBASE/SQL 06/28/04 HP36217-02A.G3.46 NET Library ALLBASE/SQL 06/28/04 HP36217-02A.G3.46 NET VC Library ALLBASE/SQL 06/28/04 ALLBASE-SQL.AB-REPLICATE,fr=A.G3.14,fa=HP-UX_B.11.00_32/64, v=HP: /opt/allbase/lib/libwss.a: HP36217-02A.G3.46 Replicate/9000 ALLBASE/SQL cksum(1) Output: ALLBASE-SQL.AB-RUN,fr=A.G3.14,fa=HP-UX_B.11.00_32/64,v=HP: 1057251273 2181784 /opt/allbase/bin/sqlmig ALLBASE-SQL.AB-RUN,fr=A.G3.14,fa=HP-UX_B.11.00_32/64,v=HP: 2858308482 2470288 /opt/allbase/bin/sqlmon ALLBASE-SQL.AB-RUN,fr=A.G3.14,fa=HP-UX_B.11.00_32/64,v=HP: 1172925715 3270008 /opt/allbase/bin/sqlgen ALLBASE-SQL.AB-RUN,fr=A.G3.14,fa=HP-UX_B.11.00_32/64,v=HP: 2653260531 1498436 /opt/allbase/bin/sqlutil ALLBASE-SQL.AB-RUN,fr=A.G3.14,fa=HP-UX_B.11.00_32/64,v=HP: 76126691 2101248 /opt/allbase/bin/isql ALLBASE-SQL.AB-RUN,fr=A.G3.14,fa=HP-UX_B.11.00_32/64,v=HP: 2023347894 32768 /opt/allbase/bin/dumpshm ALLBASE-SQL.AB-RUN,fr=A.G3.14,fa=HP-UX_B.11.00_32/64,v=HP: 690396561 1409024 /opt/allbase/bin/sqlaudit ALLBASE-SQL.AB-RUN,fr=A.G3.14,fa=HP-UX_B.11.00_32/64,v=HP: 1632687361 1602460 /opt/allbase/bin/sqlcheck ALLBASE-SQL.AB-RUN,fr=A.G3.14,fa=HP-UX_B.11.00_32/64,v=HP: 2684576985 24576 /opt/allbase/bin/sqlver ALLBASE-SQL.AB-RUN,fr=A.G3.14,fa=HP-UX_B.11.00_32/64,v=HP: 3307893325 1359172 /opt/allbase/lbin/sqldaemon ALLBASE-SQL.AB-RUN,fr=A.G3.14,fa=HP-UX_B.11.00_32/64,v=HP: 1533124054 4910404 /opt/allbase/lbin/hpsqlproc ALLBASE-SQL.AB-RUN,fr=A.G3.14,fa=HP-UX_B.11.00_32/64,v=HP: 2137186263 1968828 /opt/allbase/lib/libsql.a ALLBASE-SQL.AB-RUN,fr=A.G3.14,fa=HP-UX_B.11.00_32/64,v=HP: 3950207352 971026 /opt/allbase/lib/hpsqlcat ALLBASE-SQL.AB-RUN,fr=A.G3.14,fa=HP-UX_B.11.00_32/64,v=HP: 332365454 426 /opt/allbase/lib/isqlwel ALLBASE-SQL.AB-RUN,fr=A.G3.14,fa=HP-UX_B.11.00_32/64,v=HP: 1912521371 1323 /opt/allbase/lib/nls/C/sqlver.cat ALLBASE-SQL.AB-RUN,fr=A.G3.14,fa=HP-UX_B.11.00_32/64,v=HP: 2010257005 8428 /opt/allbase/lib/hpsql/sqlinstl ALLBASE-SQL.AB-RUN,fr=A.G3.14,fa=HP-UX_B.11.00_32/64,v=HP: 1021242673 31748 /opt/allbase/lib/hpsql/odbcview ALLBASE-SQL.AB-NET,fr=A.G3.14,fa=HP-UX_B.11.00_32/64,v=HP: 3943464806 53248 /opt/allbase/bin/hpdaARPA ALLBASE-SQL.AB-NET,fr=A.G3.14,fa=HP-UX_B.11.00_32/64,v=HP: 3630260456 98304 /opt/allbase/bin/netutil ALLBASE-SQL.AB-SUPPORT,fr=A.G3.14,fa=HP-UX_B.11.00_32/64, v=HP: 4066910778 3145456 /usr/local/bin/dbcshell ALLBASE-SQL.AB-SUPPORT,fr=A.G3.14,fa=HP-UX_B.11.00_32/64, v=HP: 1225335527 1301828 /usr/local/bin/sqlkill ALLBASE-SQL.AB-SUPPORT,fr=A.G3.14,fa=HP-UX_B.11.00_32/64, v=HP: 876787523 1474560 /usr/local/bin/fixmod ALLBASE-SQL.AB-REPLICATE,fr=A.G3.14,fa=HP-UX_B.11.00_32/64, v=HP: 2679633249 25316 /opt/allbase/lib/libwss.a Patch Conflicts: None Patch Dependencies: None Hardware Dependencies: None Other Dependencies: None Supersedes: PHSS_22091 PHSS_23889 PHSS_24452 PHSS_25631 PHSS_26184 Equivalent Patches: PHSS_31207: s700: 10.20 s800: 10.20 Patch Package Size: 9620 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_31209 5. Run swinstall to install the patch: swinstall -x autoreboot=true -x patch_match_target=true \ -s /tmp/PHSS_31209.depot By default swinstall will archive the original software in /var/adm/sw/save/PHSS_31209. If you do not wish to retain a copy of the original software, include the patch_save_files option in the swinstall command above: -x patch_save_files=false 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_31209.text file is available in the product readme: swlist -l product -a readme -d @ /tmp/PHSS_31209.depot To put this patch on a magnetic tape and install from the tape drive, use the command: dd if=/tmp/PHSS_31209.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 G3.31 to G3.34, 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.