HP3000-L Archives

January 2003, Week 4

HP3000-L@RAVEN.UTC.EDU
Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
ALLBASE SQL questions
From:
"Leonard S. Berkowitz" <[log in to unmask]>
Reply To:
[log in to unmask]
Date:
Mon, 27 Jan 2003 15:05:55 -0500
Content-Type:
text/plain
Parts/Attachments:
text/plain (30 lines) 
While running IMAGESQL:

>>SET SQLDBE ISEDB
>>SET TURBODB HEALTH.DATA
>>ATTACH
Split 16 compound source field(s) (ATCWARN 32063).
Mapped 1076 source table/source field name(s) (ATCWARN 32062).
ALLBASE/SQL CREATE TABLE command failed (ATCERR 32353).
  ALLBASE/SQL shared memory lock allocation failed in DBCore.  (DBERR 4008)

ACTERR 32353 points to the Allbase/SQL error messages.
DBERR 4008 says to use SQLUTIL to increase the number of control block
pages.

SHOWDBE tells me that there are 37 control block pages. I increased it,
arbitrarily to 100 and it seems to be working. How can I calculate the
proper number?

Thanks.
--
Leonard S. Berkowitz
Perot Health Care Systems
(Harvard Pilgrim Health Care account)
voice: 617-509-1212
fax: 617-509-1955
pager: 781-226-2431

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

ATOM RSS1 RSS2