Patch Name: PHSS_21575

Patch Description: s700_800 11.00 HP SQL/HP-UX A.G3.13 Run-Time 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-RUN,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,v=HP
	ALLBASE-SQL.AB-NET,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,v=HP
	ALLBASE-SQL.AB-SUPPORT,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,v=HP
	ALLBASE-SQL.AB-ODBCSE,fr=E.56.12,fa=HP-UX_B.11.00_32/64,v=HP
	ALLBASE-SQL.AB-REPLICATE,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_21575

Symptoms:
	PHSS_21575:

	SR# 8606130381
	CR# JAGac95274
	sql daemon dies/need to restart box

	PHSS_20878:

	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_20064:

	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_18448:

	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_21575:

	SR# 8606130381
	CR# JAGac95274
	sql daemon dies/need to restart box

	PHSS_20878:

	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_20064:

	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_18448:

	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:
	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-RUN,fr=A.G3.04,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.04,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.04,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-ODBCSE,fr=E.56.12,fa=HP-UX_B.11.00_32/64,
		v=HP:
	/opt/allbase/bin/odbcse/HPREADME
	/opt/allbase/bin/odbcse/odbccl16
	/opt/allbase/bin/odbcse/odbccl32
	/opt/allbase/bin/odbcse/odbclnse
	/opt/allbase/bin/odbcse/odbcutse

	ALLBASE-SQL.AB-REPLICATE,fr=A.G3.04,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.04,fa=HP-UX_B.11.00_32/64,v=HP:
	/opt/allbase/bin/sqlmig:
		HP36217-02A.G3.13 SQLMigrate/9000 ALLBASE/SQL
		HPDBCORE A.G3.13 03/30/00 ALLBASE/SQL

	ALLBASE-SQL.AB-RUN,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,v=HP:
	/opt/allbase/bin/sqlmon:
		HP36217-02A.G3.13 SQLMonitor/9000 ALLBASE/SQL
		HPDBCORE A.G3.13 03/30/00 ALLBASE/SQL

	ALLBASE-SQL.AB-RUN,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,v=HP:
	/opt/allbase/bin/sqlgen:
		HP36217-02A.G3.13 SQL Command Generator/9000
		ALLBASE/SQL
		HP36217-02A.G3.13 SQLX/9000 ALLBASE/SQL
		HP36217-02A.G3.13.00 SQL Parser/Linearizer/9000
		ALLBASE/SQL 03/30/00
		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
		HPDBCORE A.G3.13 03/30/00 ALLBASE/SQL

	ALLBASE-SQL.AB-RUN,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,v=HP:
	/opt/allbase/bin/sqlutil:
		HP36217-02A.G3.13 DBE Utility/9000 ALLBASE/SQL
		HPDBCORE A.G3.13 03/30/00 ALLBASE/SQL

	ALLBASE-SQL.AB-RUN,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,v=HP:
	/opt/allbase/bin/isql:
		HP36217-02A.G3.13 Interactive SQL/9000 ALLBASE/SQL
		HP36217-02A.G3.13 SQLX/9000 ALLBASE/SQL
		HP36217-02A.G3.13.00 SQL Parser/Linearizer/9000
		ALLBASE/SQL 03/30/00
		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-RUN,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,v=HP:
	/opt/allbase/bin/dumpshm:
		HPDBCORE A.G3.13 03/30/00 ALLBASE/SQL

	ALLBASE-SQL.AB-RUN,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,v=HP:
	/opt/allbase/bin/sqlaudit:
		HP36217-02A.G3.13 Replicate/9000 ALLBASE/SQL
		HP36217-02A.G3.13 SQLX/9000 ALLBASE/SQL
		HP36217-02A.G3.13.00 SQL Parser/Linearizer/9000
		ALLBASE/SQL 03/30/00
		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-RUN,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,v=HP:
	/opt/allbase/bin/sqlcheck:
		HP36217-02A.G3.13 SQLCheck/9000 ALLBASE/SQL
		HPDBCORE A.G3.13 03/30/00 ALLBASE/SQL

	ALLBASE-SQL.AB-RUN,fr=A.G3.04,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.04,fa=HP-UX_B.11.00_32/64,v=HP:
	/opt/allbase/lbin/sqldaemon:
		HPDBCORE A.G3.13 03/30/00 ALLBASE/SQL

	ALLBASE-SQL.AB-RUN,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,v=HP:
	/opt/allbase/lbin/hpsqlproc:
		HP36217-02A.G3.13.00 Query Processor/9000
		ALLBASE/SQL 03/30/00
		HP36217-02A.G3.13 SQLX/9000 ALLBASE/SQL
		HP36217-02A.G3.13.00 SQL Parser/Linearizer/9000
		ALLBASE/SQL 03/30/00
		HP36217-02A.G3.13 NET VC Library ALLBASE/SQL
		03/30/00
		HP36217-02A.G3.13 NET AF Library ALLBASE/SQL
		03/30/00
		HP36217-02A.G3.13 NET Library ALLBASE/SQL 03/30/00
		HPDBCORE A.G3.13 03/30/00 ALLBASE/SQL

	ALLBASE-SQL.AB-RUN,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,v=HP:
	/opt/allbase/lib/libsql.a:
		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
		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 PASCAL Preprocessor/9000
		ALLBASE/SQL
		HP36217-02A.G3.13 C Preprocessor/9000 ALLBASE/SQL
		HP36217-02A.G3.13 FORTRAN Preprocessor/9000
		ALLBASE/SQL
		HP36217-02A.G3.13 COBOL Preprocessor/9000
		ALLBASE/SQL
		HP36217-02A.G3.13 NET VC Library ALLBASE/SQL
		03/30/00

	ALLBASE-SQL.AB-RUN,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,v=HP:
	/opt/allbase/lib/hpsqlcat:
		HP36217-02A.G3.13 HPSQLCAT ALLBASE SQL/HP-UX

	ALLBASE-SQL.AB-RUN,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,v=HP:
	/opt/allbase/lib/isqlwel:
		None

	ALLBASE-SQL.AB-RUN,fr=A.G3.04,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.04,fa=HP-UX_B.11.00_32/64,v=HP:
	/opt/allbase/lib/hpsql/sqlinstl:
		None

	ALLBASE-SQL.AB-RUN,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,v=HP:
	/opt/allbase/lib/hpsql/odbcview:
		None

	ALLBASE-SQL.AB-NET,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,v=HP:
	/opt/allbase/bin/hpdaARPA:
		HP36217-02A.G3.13 ALLBASE/NET Utility/9000
		ALLBASE/SQL

	ALLBASE-SQL.AB-NET,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,v=HP:
	/opt/allbase/bin/netutil:
		HP36217-02A.G3.13 ALLBASE/NET Utility/9000
		ALLBASE/SQL
		HP36217-02A.G3.13 NET AF Library ALLBASE/SQL
		03/30/00
		HP36217-02A.G3.13 NET UF Library ALLBASE/SQL
		03/30/00

	ALLBASE-SQL.AB-SUPPORT,fr=A.G3.04,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.13 03/30/00 ALLBASE/SQL

	ALLBASE-SQL.AB-SUPPORT,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,
		v=HP:
	/usr/local/bin/sqlkill:
		HPDBCORE A.G3.13 03/30/00 ALLBASE/SQL

	ALLBASE-SQL.AB-SUPPORT,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,
		v=HP:
	/usr/local/bin/fixmod:
		FIXMOD A.02.01
		HP36217-02A.G3.13 SQLX/9000 ALLBASE/SQL
		HP36217-02A.G3.13.00 SQL Parser/Linearizer/9000
		ALLBASE/SQL 03/30/00
		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-REPLICATE,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,
		v=HP:
	/opt/allbase/lib/libwss.a:
		HP36217-02A.G3.13 Replicate/9000 ALLBASE/SQL

	ALLBASE-SQL.AB-ODBCSE,fr=E.56.12,fa=HP-UX_B.11.00_32/64,
		v=HP:
	/opt/allbase/bin/odbcse/HPREADME:
		None

	ALLBASE-SQL.AB-ODBCSE,fr=E.56.12,fa=HP-UX_B.11.00_32/64,
		v=HP:
	/opt/allbase/bin/odbcse/odbccl16:
		None

	ALLBASE-SQL.AB-ODBCSE,fr=E.56.12,fa=HP-UX_B.11.00_32/64,
		v=HP:
	/opt/allbase/bin/odbcse/odbccl32:
		None

	ALLBASE-SQL.AB-ODBCSE,fr=E.56.12,fa=HP-UX_B.11.00_32/64,
		v=HP:
	/opt/allbase/bin/odbcse/odbclnse:
		HP92453-02A.10.00 HP-UX SYMBOLIC DEBUGGER (END.O)
		$Revision:  74.03 $
		$header:  ODBCHOST.C 1.56 THU, JUL 8, 1999, 4:57 PM
		MGR.ODBCLINK $
		$revision:  1.56 $
		$header:  ODBCCONS.C 1.11 THU, SEP 2, 1999, 10:24 AM
		JOHNM.ODBCLINK $
		$revision:  1.11 $
		$header:  ODBCSERV.C 1.87 THU, DEC 16, 1999, 8:42 PM
		MGR.ODBCLINK $
		$revision:  1.87 $
		$header:  ODBCCOMH.C 1.30 THU, MAY 20, 1999, 5:25 PM
		JOHNM.ODBCLINK $
		$revision:  1.30 $
		$header:  ODBCFMT.C 1.76 THU, NOV 11, 1999, 11:47 AM
		JOHNM.ODBCLINK $
		$revision:  1.76 $
		$header:  VERSJR.C 1.2 MON, MAR 15, 1999, 2:08 PM
		MGR.ODBCLINK $
		$revision:  1.2 $
		$header:  PARSE.C 1.87 MON, NOV 29, 1999, 3:50 PM
		MGR.ODBCLINK $
		$revision:  1.87 $
		$header:  OPEN.C 1.130 THU, DEC 16, 1999, 8:46 PM
		MGR.ODBCLINK $
		$revision:  1.130 $
		$header:  ERROR.C 1.11 THU, JUL 8, 1999, 2:34 PM
		MGR.ODBCLINK $
		$revision:  1.11 $
		$header:  DATACONV.C 1.68 TUE, NOV 23, 1999, 11:56
		AM MGR.ODBCLINK $
		$revision:  1.68 $
		$header:  FETCH.C 1.76 MON, NOV 1, 1999, 1:03 PM
		MARC.ODBCLINK $
		$revision:  1.76 $
		$header:  NONSQL.C 1.28 FRI, JUL 2, 1999, 11:43 AM
		JOHNM.ODBCLINK $
		$revision:  1.28 $
		$header:  QUERY.C 1.59 WED, JUN 23, 1999, 8:37 AM
		JOHNM.ODBCLINK $
		$revision:  1.59 $
		$header:  SECURE.C 1.9 TUE, NOV 23, 1999, 3:38 PM
		MGR.ODBCLINK $
		$revision:  1.9 $
		$header:  SQL.C 1.1 TUE, SEP 2, 1997, 4:52 PM
		MGR.ODBCLINK $
		$revision:  1.1 $
		$header:  STUBS.C 1.19 FRI, MAR 19, 1999, 3:43 PM
		MGR.ODBCLINK $
		$revision:  1.19 $
		$header:  ALLBASER.C 1.50 MON, NOV 1, 1999, 10:32 AM
		JOHNM.ODBCLINK $
		$revision:  1.50 $
		$header:  ALLBASEX.PC 1.15 MON, NOV 1, 1999, 10:33
		AM JOHNM.ODBCLINK $
		$revision:  1.15 $
		$header:  ORASTUBS.C 1.2 FRI, FEB 26, 1999, 2:47 PM
		MGR.ODBCLINK $
		$revision:  1.2 $
		HP36217-02A.G2.02 SQLX/9000 ALLBASE/SQL
		HP36217-02A.G2.02.00 SQL Parser/Linearizer/9000
		ALLBASE/SQL 08/11/97
		HP36217-02A.G2.02 NET AF Library ALLBASE/SQL
		08/08/97
		HP36217-02A.G2.02 NET Library ALLBASE/SQL 08/08/97
		HP36217-02A.G2.02 NET VC Library ALLBASE/SQL
		08/08/97
		PATCH-PHCO_16303 for 10.20; for 10.30, 11.x
		compatibility
		libc.a_ID@@/main/r10dav/libc_dav/libc_dav_cpe/8
		/ux/core/libs/libc/archive_pa1/libc.a_ID
		Sep 11 1998 16:54:45

	ALLBASE-SQL.AB-ODBCSE,fr=E.56.12,fa=HP-UX_B.11.00_32/64,
		v=HP:
	/opt/allbase/bin/odbcse/odbcutse:
		HP92453-02A.10.00 HP-UX SYMBOLIC DEBUGGER (END.O)
		$Revision:  74.03 $
		$header:  ODBCUTIL.C 1.62 MON, NOV 1, 1999, 10:58 AM
		JOHNM.ODBCLINK $
		$revision:  1.62 $
		$header:  VERSJR.C 1.2 MON, MAR 15, 1999, 2:08 PM
		MGR.ODBCLINK $
		$revision:  1.2 $
		$header:  PARSE.C 1.87 MON, NOV 29, 1999, 3:50 PM
		MGR.ODBCLINK $
		$revision:  1.87 $
		$header:  OPEN.C 1.130 THU, DEC 16, 1999, 8:46 PM
		MGR.ODBCLINK $
		$revision:  1.130 $
		$header:  ERROR.C 1.11 THU, JUL 8, 1999, 2:34 PM
		MGR.ODBCLINK $
		$revision:  1.11 $
		$header:  DATACONV.C 1.68 TUE, NOV 23, 1999, 11:56
		AM MGR.ODBCLINK $
		$revision:  1.68 $
		$header:  FETCH.C 1.76 MON, NOV 1, 1999, 1:03 PM
		MARC.ODBCLINK $
		$revision:  1.76 $
		$header:  NONSQL.C 1.28 FRI, JUL 2, 1999, 11:43 AM
		JOHNM.ODBCLINK $
		$revision:  1.28 $
		$header:  QUERY.C 1.59 WED, JUN 23, 1999, 8:37 AM
		JOHNM.ODBCLINK $
		$revision:  1.59 $
		$header:  SECURE.C 1.9 TUE, NOV 23, 1999, 3:38 PM
		MGR.ODBCLINK $
		$revision:  1.9 $
		$header:  SQL.C 1.1 TUE, SEP 2, 1997, 4:52 PM
		MGR.ODBCLINK $
		$revision:  1.1 $
		$header:  STUBS.C 1.19 FRI, MAR 19, 1999, 3:43 PM
		MGR.ODBCLINK $
		$revision:  1.19 $
		$header:  ALLBASER.C 1.50 MON, NOV 1, 1999, 10:32 AM
		JOHNM.ODBCLINK $
		$revision:  1.50 $
		$header:  ALLBASEX.PC 1.15 MON, NOV 1, 1999, 10:33
		AM JOHNM.ODBCLINK $
		$revision:  1.15 $
		$header:  ORASTUBS.C 1.2 FRI, FEB 26, 1999, 2:47 PM
		MGR.ODBCLINK $
		$revision:  1.2 $
		HP36217-02A.G2.02 SQLX/9000 ALLBASE/SQL
		HP36217-02A.G2.02.00 SQL Parser/Linearizer/9000
		ALLBASE/SQL 08/11/97
		HP36217-02A.G2.02 NET AF Library ALLBASE/SQL
		08/08/97
		HP36217-02A.G2.02 NET Library ALLBASE/SQL 08/08/97
		HP36217-02A.G2.02 NET VC Library ALLBASE/SQL
		08/08/97
		PATCH-PHCO_16303 for 10.20; for 10.30, 11.x
		compatibility
		libc.a_ID@@/main/r10dav/libc_dav/libc_dav_cpe/8
		/ux/core/libs/libc/archive_pa1/libc.a_ID
		Sep 11 1998 16:54:45

cksum(1) Output:
	
	ALLBASE-SQL.AB-RUN,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,v=HP:
	4185399315 2213644 /opt/allbase/bin/sqlmig

	ALLBASE-SQL.AB-RUN,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,v=HP:
	1033867363 2498540 /opt/allbase/bin/sqlmon

	ALLBASE-SQL.AB-RUN,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,v=HP:
	2908256680 3291320 /opt/allbase/bin/sqlgen

	ALLBASE-SQL.AB-RUN,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,v=HP:
	1023733611 1530048 /opt/allbase/bin/sqlutil

	ALLBASE-SQL.AB-RUN,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,v=HP:
	3310776527 2112282 /opt/allbase/bin/isql

	ALLBASE-SQL.AB-RUN,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,v=HP:
	1718713793 32847 /opt/allbase/bin/dumpshm

	ALLBASE-SQL.AB-RUN,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,v=HP:
	3337754862 1411197 /opt/allbase/bin/sqlaudit

	ALLBASE-SQL.AB-RUN,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,v=HP:
	1311296773 1638212 /opt/allbase/bin/sqlcheck

	ALLBASE-SQL.AB-RUN,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,v=HP:
	890098087 28744 /opt/allbase/bin/sqlver

	ALLBASE-SQL.AB-RUN,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,v=HP:
	2315537691 1382248 /opt/allbase/lbin/sqldaemon

	ALLBASE-SQL.AB-RUN,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,v=HP:
	1136146934 4926892 /opt/allbase/lbin/hpsqlproc

	ALLBASE-SQL.AB-RUN,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,v=HP:
	3353534414 1974020 /opt/allbase/lib/libsql.a

	ALLBASE-SQL.AB-RUN,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,v=HP:
	2016227358 968488 /opt/allbase/lib/hpsqlcat

	ALLBASE-SQL.AB-RUN,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,v=HP:
	332365454 426 /opt/allbase/lib/isqlwel

	ALLBASE-SQL.AB-RUN,fr=A.G3.04,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.04,fa=HP-UX_B.11.00_32/64,v=HP:
	2010257005 8428 /opt/allbase/lib/hpsql/sqlinstl

	ALLBASE-SQL.AB-RUN,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,v=HP:
	1021242673 31748 /opt/allbase/lib/hpsql/odbcview

	ALLBASE-SQL.AB-NET,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,v=HP:
	3928839056 69795 /opt/allbase/bin/hpdaARPA

	ALLBASE-SQL.AB-NET,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,v=HP:
	1747733034 102657 /opt/allbase/bin/netutil

	ALLBASE-SQL.AB-SUPPORT,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,
		v=HP:
	1585666819 3172712 /usr/local/bin/dbcshell

	ALLBASE-SQL.AB-SUPPORT,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,
		v=HP:
	4273173229 1328956 /usr/local/bin/sqlkill

	ALLBASE-SQL.AB-SUPPORT,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,
		v=HP:
	3620249127 1480738 /usr/local/bin/fixmod

	ALLBASE-SQL.AB-REPLICATE,fr=A.G3.04,fa=HP-UX_B.11.00_32/64,
		v=HP:
	371245007 21024 /opt/allbase/lib/libwss.a

	ALLBASE-SQL.AB-ODBCSE,fr=E.56.12,fa=HP-UX_B.11.00_32/64,
		v=HP:
	3641255679 11169 /opt/allbase/bin/odbcse/HPREADME

	ALLBASE-SQL.AB-ODBCSE,fr=E.56.12,fa=HP-UX_B.11.00_32/64,
		v=HP:
	349637551 537448 /opt/allbase/bin/odbcse/odbccl16

	ALLBASE-SQL.AB-ODBCSE,fr=E.56.12,fa=HP-UX_B.11.00_32/64,
		v=HP:
	1097482915 1031472 /opt/allbase/bin/odbcse/odbccl32

	ALLBASE-SQL.AB-ODBCSE,fr=E.56.12,fa=HP-UX_B.11.00_32/64,
		v=HP:
	1974813045 3466952 /opt/allbase/bin/odbcse/odbclnse

	ALLBASE-SQL.AB-ODBCSE,fr=E.56.12,fa=HP-UX_B.11.00_32/64,
		v=HP:
	591126375 3294912 /opt/allbase/bin/odbcse/odbcutse

Patch Conflicts: None

Patch Dependencies: None

Hardware Dependencies: None

Other Dependencies: None

Supersedes:
	PHSS_18448 PHSS_20064 PHSS_20878

Equivalent Patches:
	PHSS_20880:
	s700: 10.20
	s800: 10.20

Patch Package Size: 37740 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_21575

	5. Run swinstall to install the patch:

		swinstall -x autoreboot=true -x patch_match_target=true \
			  -s /tmp/PHSS_21575.depot

	By default swinstall will archive the original software in 
	/var/adm/sw/save/PHSS_21575.  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_21575.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_21575.text file is 
	available in the product readme:

		swlist -l product -a readme -d @ /tmp/PHSS_21575.depot

	To put this patch on a magnetic tape and install from the
	tape drive, use the command:

		dd if=/tmp/PHSS_21575.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.