Patch Name: PHSS_20880

Patch Description: s700_800 10.X HP SQL/HP-UX A.G3.13 Run-Time Patch

Creation Date: 00/04/20

Post Date:  00/06/27

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

Products:
	HP SQL/HP-UX A.G3.12 A.G3.11 A.G3.09 A.G3.06 A.G3.05
	A.G3.04 A.G3.03 A.G2.08 A.G2.07

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

Automatic Reboot?: No

Status: General Release

Critical: No

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

Symptoms:
	PHSS_20880:

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

	PHSS_20066:

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

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

	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

	PHSS_18450:

	SR# 1653301788:
	Enhance Allbase/SQL so that DM CTR overflows do not occur

	SR# 5003366013
	SQLGEN does not correctly recognize the last row
	on multiple of 50.

	PHSS_17540:

	SR# 1653287227
	ALLBASE/SQL internal error at JTMXMJ(9, ) when SMJ on
	cols w/ diff langs

	PHSS_17538:

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

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

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

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

	PHSS_20066:

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

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

	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

	PHSS_18450:

	SR# 1653301788:
	Enhance Allbase/SQL so that DM CTR overflows do not occur

	SR# 5003366013
	SQLGEN does not correctly recognize the last row
	on multiple of 50.

	PHSS_17540:

	SR# 1653287227
	ALLBASE/SQL internal error at JTMXMJ(9, ) when SMJ on
	cols w/ diff langs

	PHSS_17538:

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

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

	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 5003366013 1653287458 1653287474 4701406009
	1653301788 8606103472 8606104108 8606100824 8606104922
	8606107020 5000678615 8606106104 8606130381

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
	/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

what(1) Output:
	/opt/allbase/bin/sqlmig:
		HP36217-02A.G3.13 SQLMigrate/9000 ALLBASE/SQL
		HPDBCORE A.G3.13 03/30/00 ALLBASE/SQL
	/opt/allbase/bin/sqlmon:
		HP36217-02A.G3.13 SQLMonitor/9000 ALLBASE/SQL
		HPDBCORE A.G3.13 03/30/00 ALLBASE/SQL
	/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
	/opt/allbase/bin/sqlutil:
		HP36217-02A.G3.13 DBE Utility/9000 ALLBASE/SQL
		HPDBCORE A.G3.13 03/30/00 ALLBASE/SQL
	/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
	/opt/allbase/bin/dumpshm:
		HPDBCORE A.G3.13 03/30/00 ALLBASE/SQL
	/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
	/opt/allbase/bin/sqlcheck:
		HP36217-02A.G3.13 SQLCheck/9000 ALLBASE/SQL
		HPDBCORE A.G3.13 03/30/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.13 03/30/00 ALLBASE/SQL
	/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
	/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
	/opt/allbase/lib/hpsqlcat:
		HP36217-02A.G3.13 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.13 ALLBASE/NET Utility/9000
		ALLBASE/SQL
	/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
	/usr/local/bin/dbcshell:
		HP92453-02A.10.00 HP-UX SYMBOLIC DEBUGGER (END.O)
		$Revision:  74.03 $
		HPDBCORE A.G3.13 03/30/00 ALLBASE/SQL
	/usr/local/bin/sqlkill:
		HPDBCORE A.G3.13 03/30/00 ALLBASE/SQL
	/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
	/opt/allbase/lib/libwss.a:
		HP36217-02A.G3.13 Replicate/9000 ALLBASE/SQL
	/opt/allbase/bin/odbcse/HPREADME:
		None
	/opt/allbase/bin/odbcse/odbccl16:
		None
	/opt/allbase/bin/odbcse/odbccl32:
		None
	/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
	/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:
	2416867509 2163912 /opt/allbase/bin/sqlmig
	1382122462 2440532 /opt/allbase/bin/sqlmon
	1656973384 3145928 /opt/allbase/bin/sqlgen
	4060120177 1484432 /opt/allbase/bin/sqlutil
	1099680451 1993019 /opt/allbase/bin/isql
	263157216 28731 /opt/allbase/bin/dumpshm
	946754304 1300251 /opt/allbase/bin/sqlaudit
	3129498159 1588492 /opt/allbase/bin/sqlcheck
	782860734 28741 /opt/allbase/bin/sqlver
	2918351886 1340792 /opt/allbase/lbin/sqldaemon
	47451878 4696140 /opt/allbase/lbin/hpsqlproc
	2122270814 1883488 /opt/allbase/lib/libsql.a
	2016227358 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
	2217634182 57484 /opt/allbase/bin/hpdaARPA
	460017168 86253 /opt/allbase/bin/netutil
	712844140 3119696 /usr/local/bin/dbcshell
	1416998256 1287516 /usr/local/bin/sqlkill
	3897974707 1373891 /usr/local/bin/fixmod
	878850145 21788 /opt/allbase/lib/libwss.a
	3641255679 11169 /opt/allbase/bin/odbcse/HPREADME
	349637551 537448 /opt/allbase/bin/odbcse/odbccl16
	1097482915 1031472 /opt/allbase/bin/odbcse/odbccl32
	1974813045 3466952 /opt/allbase/bin/odbcse/odbclnse
	591126375 3294912 /opt/allbase/bin/odbcse/odbcutse

Patch Conflicts: None

Patch Dependencies: None

Hardware Dependencies: None

Other Dependencies: None

Supersedes:
	PHSS_10264 PHSS_16380 PHSS_17538 PHSS_17540 PHSS_18450 PHSS_19300
	PHSS_19302 PHSS_20066

Equivalent Patches:
	PHSS_21575:
	s700: 11.00
	s800: 11.00

Patch Package Size: 36610 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_20880

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

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

	By default swinstall will archive the original software in 
	/var/adm/sw/patch/PHSS_20880.  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_20880.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_20880.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.