Patch Name: PHSS_22089

Patch Description: s700_800 10.20 HP SQL/HP-UX A.G3.17 Run-Time Patch

Creation Date: 00/08/03

Post Date:  00/08/09

Hardware Platforms - OS Releases:
	s700: 10.20
	s800: 10.20

Products:
	HP SQL/HP-UX A.G3.14

Filesets:
	ALLBASE-SQL.AB-RUN ALLBASE-SQL.AB-NET ALLBASE-SQL.AB-SUPPORT
	ALLBASE-SQL.AB-REPLICATE

Automatic Reboot?: No

Status: General Superseded

Critical: No

Path Name: /hp-ux_patches/s700_800/10.X/PHSS_22089

Symptoms:
	PHSS_22089:

	SR# 1653306985
	CR# JAGab38060
	SELECT with SUB_STRING get error ALLBASE/SQL internal
	error at JASNLMV(1

	SR# 8606134741
	CR# JAGad03876
	Function 'LOWER' doesn't work if Lang = German.

	SR# 8606124122
	CR# JAGac39505
	isql abort pascal escape code 2031719 dberr 237 when
	loading tables

Defect Description:
	PHSS_22089:

	SR# 1653306985
	CR# JAGab38060
	SELECT with SUB_STRING get error ALLBASE/SQL internal
	error at JASNLMV(1

	SR# 8606134741
	CR# JAGad03876
	Function 'LOWER' doesn't work if Lang = German.

	SR# 8606124122
	CR# JAGac39505
	isql abort pascal escape code 2031719 dberr 237 when
	loading tables

SR:
	1653306985 8606134741 8606124122

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.17 SQLMigrate/9000 ALLBASE/SQL
		HPDBCORE A.G3.17 07/13/00 ALLBASE/SQL
	/opt/allbase/bin/sqlmon:
		HP36217-02A.G3.17 SQLMonitor/9000 ALLBASE/SQL
		HPDBCORE A.G3.17 07/13/00 ALLBASE/SQL
	/opt/allbase/bin/sqlgen:
		HP36217-02A.G3.17 SQL Command Generator/9000
		ALLBASE/SQL
		HP36217-02A.G3.17 SQLX/9000 ALLBASE/SQL
		HP36217-02A.G3.17.00 SQL Parser/Linearizer/9000
		ALLBASE/SQL 07/13/00
		HP36217-02A.G3.17 NET AF Library ALLBASE/SQL
		07/13/00
		HP36217-02A.G3.17 NET Library ALLBASE/SQL 07/13/00
		HP36217-02A.G3.17 NET VC Library ALLBASE/SQL
		07/13/00
		HPDBCORE A.G3.17 07/13/00 ALLBASE/SQL
	/opt/allbase/bin/sqlutil:
		HP36217-02A.G3.17 DBE Utility/9000 ALLBASE/SQL
		HPDBCORE A.G3.17 07/13/00 ALLBASE/SQL
	/opt/allbase/bin/isql:
		HP36217-02A.G3.17 Interactive SQL/9000 ALLBASE/SQL
		HP36217-02A.G3.17 SQLX/9000 ALLBASE/SQL
		HP36217-02A.G3.17.00 SQL Parser/Linearizer/9000
		ALLBASE/SQL 07/13/00
		HP36217-02A.G3.17 NET AF Library ALLBASE/SQL
		07/13/00
		HP36217-02A.G3.17 NET Library ALLBASE/SQL 07/13/00
		HP36217-02A.G3.17 NET VC Library ALLBASE/SQL
		07/13/00
	/opt/allbase/bin/dumpshm:
		HPDBCORE A.G3.17 07/13/00 ALLBASE/SQL
	/opt/allbase/bin/sqlaudit:
		HP36217-02A.G3.17 Replicate/9000 ALLBASE/SQL
		HP36217-02A.G3.17 SQLX/9000 ALLBASE/SQL
		HP36217-02A.G3.17.00 SQL Parser/Linearizer/9000
		ALLBASE/SQL 07/13/00
		HP36217-02A.G3.17 NET AF Library ALLBASE/SQL
		07/13/00
		HP36217-02A.G3.17 NET Library ALLBASE/SQL 07/13/00
		HP36217-02A.G3.17 NET VC Library ALLBASE/SQL
		07/13/00
	/opt/allbase/bin/sqlcheck:
		HP36217-02A.G3.17 SQLCheck/9000 ALLBASE/SQL
		HPDBCORE A.G3.17 07/13/00 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.17 07/13/00 ALLBASE/SQL
	/opt/allbase/lbin/hpsqlproc:
		HP36217-02A.G3.17.00 Query Processor/9000
		ALLBASE/SQL 07/13/00
		HP36217-02A.G3.17 SQLX/9000 ALLBASE/SQL
		HP36217-02A.G3.17.00 SQL Parser/Linearizer/9000
		ALLBASE/SQL 07/13/00
		HP36217-02A.G3.17 NET VC Library ALLBASE/SQL
		07/13/00
		HP36217-02A.G3.17 NET AF Library ALLBASE/SQL
		07/13/00
		HP36217-02A.G3.17 NET Library ALLBASE/SQL 07/13/00
		HPDBCORE A.G3.17 07/13/00 ALLBASE/SQL
	/opt/allbase/lib/libsql.a:
		HP36217-02A.G3.17 NET AF Library ALLBASE/SQL
		07/13/00
		HP36217-02A.G3.17 NET Library ALLBASE/SQL 07/13/00
		HP36217-02A.G3.17 NET VC Library ALLBASE/SQL
		07/13/00
		HP36217-02A.G3.17.00 SQL Parser/Linearizer/9000
		ALLBASE/SQL 07/13/00
		HP36217-02A.G3.17 SQLX/9000 ALLBASE/SQL
		HP36217-02A.G3.17 PASCAL Preprocessor/9000
		ALLBASE/SQL
		HP36217-02A.G3.17 C Preprocessor/9000 ALLBASE/SQL
		HP36217-02A.G3.17 FORTRAN Preprocessor/9000
		ALLBASE/SQL
		HP36217-02A.G3.17 COBOL Preprocessor/9000
		ALLBASE/SQL
		HP36217-02A.G3.17 NET VC Library ALLBASE/SQL
		07/13/00
	/opt/allbase/lib/hpsqlcat:
		HP36217-02A.G3.17 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.17 ALLBASE/NET Utility/9000
		ALLBASE/SQL
	/opt/allbase/bin/netutil:
		HP36217-02A.G3.17 ALLBASE/NET Utility/9000
		ALLBASE/SQL
		HP36217-02A.G3.17 NET AF Library ALLBASE/SQL
		07/13/00
		HP36217-02A.G3.17 NET UF Library ALLBASE/SQL
		07/13/00
	/usr/local/bin/dbcshell:
		HP92453-02A.10.00 HP-UX SYMBOLIC DEBUGGER (END.O)
		$Revision:  74.03 $
		HPDBCORE A.G3.17 07/13/00 ALLBASE/SQL
	/usr/local/bin/sqlkill:
		HPDBCORE A.G3.17 07/13/00 ALLBASE/SQL
	/usr/local/bin/fixmod:
		FIXMOD A.02.01
		HP36217-02A.G3.17 SQLX/9000 ALLBASE/SQL
		HP36217-02A.G3.17.00 SQL Parser/Linearizer/9000
		ALLBASE/SQL 07/13/00
		HP36217-02A.G3.17 NET AF Library ALLBASE/SQL
		07/13/00
		HP36217-02A.G3.17 NET Library ALLBASE/SQL 07/13/00
		HP36217-02A.G3.17 NET VC Library ALLBASE/SQL
		07/13/00
	/opt/allbase/lib/libwss.a:
		HP36217-02A.G3.17 Replicate/9000 ALLBASE/SQL

cksum(1) Output:
	423386040 2163912 /opt/allbase/bin/sqlmig
	2326080937 2440532 /opt/allbase/bin/sqlmon
	1038735771 3145928 /opt/allbase/bin/sqlgen
	1480536877 1484432 /opt/allbase/bin/sqlutil
	1055362280 1993019 /opt/allbase/bin/isql
	897474398 28731 /opt/allbase/bin/dumpshm
	3942329055 1300251 /opt/allbase/bin/sqlaudit
	4013611179 1588492 /opt/allbase/bin/sqlcheck
	646536326 28741 /opt/allbase/bin/sqlver
	1245643960 1340792 /opt/allbase/lbin/sqldaemon
	827991806 4696140 /opt/allbase/lbin/hpsqlproc
	52379064 1884296 /opt/allbase/lib/libsql.a
	3582346713 968488 /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
	1258935181 57484 /opt/allbase/bin/hpdaARPA
	1542436101 86253 /opt/allbase/bin/netutil
	416007470 3119696 /usr/local/bin/dbcshell
	1588504281 1287516 /usr/local/bin/sqlkill
	1074049868 1373891 /usr/local/bin/fixmod
	2888822005 21788 /opt/allbase/lib/libwss.a

Patch Conflicts: None

Patch Dependencies: None

Hardware Dependencies: None

Other Dependencies: None

Supersedes: None

Equivalent Patches:
	PHSS_22091:
	s700: 11.00
	s800: 11.00

Patch Package Size: 28450 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_22089

	5a. For a standalone system, run swinstall to install the
	    patch:

		swinstall -x autoreboot=true -x match_target=true \
			-s /tmp/PHSS_22089.depot

	By default swinstall will archive the original software in
	/var/adm/sw/patch/PHSS_22089.  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_22089.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_22089.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.14 to G3.17, 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.