Patch Name: PHSS_25629 Patch Description: s700_800 10.20 HP SQL/HP-UX A.G3.31 Run-Time Patch Creation Date: 01/11/06 Post Date: 01/11/07 Hardware Platforms - OS Releases: s700: 10.20 s800: 10.20 Products: HP SQL/HP-UX A.G3.28 A.G3.23 A.G3.17 A.G3.14 Filesets: ALLBASE-SQL.AB-RUN,A.G3.14,A.G3.17,G3.23,A.G3.28 ALLBASE-SQL.AB-NET,A.G3.14,A.G3.17,G3.23,A.G3.28 ALLBASE-SQL.AB-SUPPORT,A.G3.14,A.G3.17,G3.23,A.G3.28 ALLBASE-SQL.AB-REPLICATE,A.G3.14,A.G3.17,G3.23,A.G3.28 Automatic Reboot?: No Status: General Release Critical: No Path Name: /hp-ux_patches/s700_800/10.X/PHSS_25629 Symptoms: PHSS_25629: SR# 8606206557 CR# JAGad75730 unload failure DBERR 237 while unloading data SR# 8606216499 CR# JAGad85668 Allbase cannot handle some languages on 10.20 PHSS_24450: SR# 8606182986 CR# JAGad52202 SELECT with SUB_STRING on a NLS varchar column with null values gives DBcore internal error SR# 8606196069 CR# JAGad65273 SQLMON does not work on G3.23 PHSS_23887: 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_22089: 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_25629: SR# 8606206557 CR# JAGad75730 unload failure DBERR 237 while unloading data SR# 8606216499 CR# JAGad85668 Allbase cannot handle some languages on 10.20 PHSS_24450: SR# 8606182986 CR# JAGad52202 SELECT with SUB_STRING on a NLS varchar column with null values gives DBcore internal error SR# 8606196069 CR# JAGad65273 SQLMON does not work on G3.23 PHSS_23887: 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_22089: 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 SR: 1653306985 8606134741 8606124122 8606177425 8606184134 8606167904 8606160803 8606182986 8606196069 8606206557 8606216499 Patch Files: /opt/allbase/bin/sqlmig /opt/allbase/bin/sqlmon /opt/allbase/bin/sqlgen /opt/allbase/bin/sqlutil /opt/allbase/bin/isql /opt/allbase/bin/dumpshm /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/libwss.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/hpdaARPA /opt/allbase/bin/netutil /usr/local/bin/dbcshell /usr/local/bin/sqlkill /usr/local/bin/fixmod what(1) Output: /opt/allbase/bin/sqlmig: HP36217-02A.G3.31 SQLMigrate/9000 ALLBASE/SQL HPDBCORE A.G3.31 10/23/01 ALLBASE/SQL /opt/allbase/bin/sqlmon: HP36217-02A.G3.31 SQLMonitor/9000 ALLBASE/SQL HPDBCORE A.G3.31 10/23/01 ALLBASE/SQL /opt/allbase/bin/sqlgen: HP36217-02A.G3.31 SQL Command Generator/9000 ALLBASE/SQL HP36217-02A.G3.31 SQLX/9000 ALLBASE/SQL HP36217-02A.G3.31.00 SQL Parser/Linearizer/9000 ALLBASE/SQL 10/23/01 HP36217-02A.G3.31 NET AF Library ALLBASE/SQL 10/23/01 HP36217-02A.G3.31 NET Library ALLBASE/SQL 10/23/01 HP36217-02A.G3.31 NET VC Library ALLBASE/SQL 10/23/01 HPDBCORE A.G3.31 10/23/01 ALLBASE/SQL /opt/allbase/bin/sqlutil: HP36217-02A.G3.31 DBE Utility/9000 ALLBASE/SQL HPDBCORE A.G3.31 10/23/01 ALLBASE/SQL /opt/allbase/bin/isql: HP36217-02A.G3.31 Interactive SQL/9000 ALLBASE/SQL HP36217-02A.G3.31 SQLX/9000 ALLBASE/SQL HP36217-02A.G3.31.00 SQL Parser/Linearizer/9000 ALLBASE/SQL 10/23/01 HP36217-02A.G3.31 NET AF Library ALLBASE/SQL 10/23/01 HP36217-02A.G3.31 NET Library ALLBASE/SQL 10/23/01 HP36217-02A.G3.31 NET VC Library ALLBASE/SQL 10/23/01 /opt/allbase/bin/dumpshm: HPDBCORE A.G3.31 10/23/01 ALLBASE/SQL /opt/allbase/bin/sqlaudit: HP36217-02A.G3.31 Replicate/9000 ALLBASE/SQL HP36217-02A.G3.31 SQLX/9000 ALLBASE/SQL HP36217-02A.G3.31.00 SQL Parser/Linearizer/9000 ALLBASE/SQL 10/23/01 HP36217-02A.G3.31 NET AF Library ALLBASE/SQL 10/23/01 HP36217-02A.G3.31 NET Library ALLBASE/SQL 10/23/01 HP36217-02A.G3.31 NET VC Library ALLBASE/SQL 10/23/01 /opt/allbase/bin/sqlcheck: HP36217-02A.G3.31 SQLCheck/9000 ALLBASE/SQL HPDBCORE A.G3.31 10/23/01 ALLBASE/SQL /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 /opt/allbase/lbin/sqldaemon: HPDBCORE A.G3.31 10/23/01 ALLBASE/SQL /opt/allbase/lbin/hpsqlproc: HP36217-02A.G3.31.00 Query Processor/9000 ALLBASE/SQL 10/23/01 HP36217-02A.G3.31 SQLX/9000 ALLBASE/SQL HP36217-02A.G3.31.00 SQL Parser/Linearizer/9000 ALLBASE/SQL 10/23/01 HP36217-02A.G3.31 NET VC Library ALLBASE/SQL 10/23/01 HP36217-02A.G3.31 NET AF Library ALLBASE/SQL 10/23/01 HP36217-02A.G3.31 NET Library ALLBASE/SQL 10/23/01 HPDBCORE A.G3.31 10/23/01 ALLBASE/SQL /opt/allbase/lib/libsql.a: HP36217-02A.G3.31 NET AF Library ALLBASE/SQL 10/23/01 HP36217-02A.G3.31 NET Library ALLBASE/SQL 10/23/01 HP36217-02A.G3.31 NET VC Library ALLBASE/SQL 10/23/01 HP36217-02A.G3.31.00 SQL Parser/Linearizer/9000 ALLBASE/SQL 10/23/01 HP36217-02A.G3.31 SQLX/9000 ALLBASE/SQL HP36217-02A.G3.31 PASCAL Preprocessor/9000 ALLBASE/SQL HP36217-02A.G3.31 C Preprocessor/9000 ALLBASE/SQL HP36217-02A.G3.31 FORTRAN Preprocessor/9000 ALLBASE/SQL HP36217-02A.G3.31 COBOL Preprocessor/9000 ALLBASE/SQL HP36217-02A.G3.31 NET VC Library ALLBASE/SQL 10/23/01 /opt/allbase/lib/hpsqlcat: HP36217-02A.G3.31 HPSQLCAT ALLBASE SQL/HP-UX /opt/allbase/lib/isqlwel: None /opt/allbase/lib/nls/C/sqlver.cat: None /opt/allbase/lib/hpsql/sqlinstl: None /opt/allbase/lib/hpsql/odbcview: None /opt/allbase/bin/hpdaARPA: HP36217-02A.G3.31 ALLBASE/NET Utility/9000 ALLBASE/SQL /opt/allbase/bin/netutil: HP36217-02A.G3.31 ALLBASE/NET Utility/9000 ALLBASE/SQL HP36217-02A.G3.31 NET AF Library ALLBASE/SQL 10/23/01 HP36217-02A.G3.31 NET UF Library ALLBASE/SQL 10/23/01 /usr/local/bin/dbcshell: HP92453-02A.10.00 HP-UX SYMBOLIC DEBUGGER (END.O) $Revision: 74.03 $ HPDBCORE A.G3.31 10/23/01 ALLBASE/SQL /usr/local/bin/sqlkill: HPDBCORE A.G3.31 10/23/01 ALLBASE/SQL /usr/local/bin/fixmod: FIXMOD A.02.01 HP36217-02A.G3.31 SQLX/9000 ALLBASE/SQL HP36217-02A.G3.31.00 SQL Parser/Linearizer/9000 ALLBASE/SQL 10/23/01 HP36217-02A.G3.31 NET AF Library ALLBASE/SQL 10/23/01 HP36217-02A.G3.31 NET Library ALLBASE/SQL 10/23/01 HP36217-02A.G3.31 NET VC Library ALLBASE/SQL 10/23/01 /opt/allbase/lib/libwss.a: HP36217-02A.G3.31 Replicate/9000 ALLBASE/SQL cksum(1) Output: 533804655 2151592 /opt/allbase/bin/sqlmig 2689545485 2428220 /opt/allbase/bin/sqlmon 3997654817 3141816 /opt/allbase/bin/sqlgen 3852594218 1472112 /opt/allbase/bin/sqlutil 2258732398 1997084 /opt/allbase/bin/isql 3858078369 28731 /opt/allbase/bin/dumpshm 2936818996 1304333 /opt/allbase/bin/sqlaudit 3656383857 1572072 /opt/allbase/bin/sqlcheck 2786572509 28741 /opt/allbase/bin/sqlver 3307596931 1332576 /opt/allbase/lbin/sqldaemon 1481397491 4700216 /opt/allbase/lbin/hpsqlproc 406694234 1881820 /opt/allbase/lib/libsql.a 30413441 970949 /opt/allbase/lib/hpsqlcat 332365454 426 /opt/allbase/lib/isqlwel 1912521371 1323 /opt/allbase/lib/nls/C/sqlver.cat 2010257005 8428 /opt/allbase/lib/hpsql/sqlinstl 1021242673 31748 /opt/allbase/lib/hpsql/odbcview 1824686603 49268 /opt/allbase/bin/hpdaARPA 1264043592 94460 /opt/allbase/bin/netutil 1354380496 3107384 /usr/local/bin/dbcshell 1840850409 1275204 /usr/local/bin/sqlkill 3440776159 1377965 /usr/local/bin/fixmod 3176580714 21788 /opt/allbase/lib/libwss.a Patch Conflicts: None Patch Dependencies: None Hardware Dependencies: None Other Dependencies: None Supersedes: PHSS_22089 PHSS_23887 PHSS_24450 Equivalent Patches: PHSS_25631: s700: 11.00 s800: 11.00 Patch Package Size: 28380 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_25629 5a. For a standalone system, run swinstall to install the patch: swinstall -x autoreboot=true -x match_target=true \ -s /tmp/PHSS_25629.depot By default swinstall will archive the original software in /var/adm/sw/patch/PHSS_25629. 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_25629.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_25629.depot of=/dev/rmt/0m bs=2k Special Installation Instructions: You must use SQLINSTL before running ANY new version (later than G.0). For example, when you go from G3.17 to G3.23, 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.