Greg, it's difficult to tell how you got these errors.  The following may be 
causes that I know of.  Please let me know if you have questions.

Best Regards
Cathlene McRae



problem: >> DETACH
ALLBASE/SQL DROP TABLE command failed (ATCERR 32355).

Cause: may be dbe corruption. to correct:

1) use dbutil to detach the image database from the dbe.logon as the creator 
of the image database.
dbutil
detach nabase.pub 
2) use sqlutil to purge the dbe.
sqlutil
purgeall
exit



 
Problem:   IMAGESQL gave the following error when creating a new DBE:
ALLBASE/SQL RELEASE command failed (ATCERR 32352).
  ALLBASE/SQL not running.  (DBERR 2100)
Why ?



 Two main reasons for this failure are:

1.  Not enough disc space.

    Use DISCFREE to verify there is adequate disc space on the system
    to build a new DBE.  If there is enough disc space on the system,
    check to see if the account or group where you want to
    build the new DBE has disc space limits which are being exceeded.

    Issue the REPORT command and compare the COUNT with the LIMIT under
    the section labeled FILESPACE-SECTORS.  If these numbers are close,
    free up disc space within the group and/or account
    or increase the limit with the ALTACCT or ALTGROUP command (SM cap
    required).

2.  Duplicate filename.

    When IMAGE/SQL creates a new DBE, it builds a DBCon file, a DBEFile,
    a logfile, and an IMAGE/SQL configuration file.

    For a DBE called TESTDBE, the following files are created:

    TESTDBE    - DBCon file
    TESTDBFL   - DBEFile0
    TESTDBLG   - Logfile
    TESTDBCR   - IMAGE/SQL configuration file

    The convention followed is the first six characters of the DBE name
    followed by the appropriate extensions.  Check to see if a file with
    one of these names already exists that might conflict
    with what IMAGE/SQL is trying to build.

Finding the duplicate file

To correct this problem you need to find the problem file. Doing
a listf of the dbe prefix; for example if the dbe filename is to be
musicdbe, the prefix to use in the listf is [log in to unmask]

The following is an example of the error and how to resolve the problem.

 :imagesql

HP36385B B.G2.07               IMAGE/SQL Utility   MON, SEP 13, 1999, 10:39 AM
(C) COPYRIGHT HEWLETT-PACKARD COMPANY 1993

>> set sqldbe musicdbe
DBE does not exist, do you want to create one? [Y/N] : y
Creating DBE now ...
ALLBASE/SQL RELEASE command failed (ATCERR 32352).
  ALLBASE/SQL not running.  (DBERR 2100)
>>exit
listf music@,2
MUSICDLG  PRIV    256W  FB       10000      10000   1    20000  1 32


:sqlutil
                                          MON, SEP 13, 1999, 10:41 AM
HP36216-02A.G3.02               DBE Utility/3000             ALLBASE/SQL
(C)COPYRIGHT HEWLETT-PACKARD CO. 1982,1983,1984,1985,1986,1987,1988,
1989,1990,1991,1992,1993,1994. ALL RIGHTS RESERVED.

>> purgefile
DBEFile Name: musicdlg
Use DROP DBEFILE to purge DBEFILE associated with DBEnvironment.Purge 
DBEFile (y

/n)? y

DBEFile purged.

>> exit

:imagesql

HP36385B B.G2.07               IMAGE/SQL Utility   MON, SEP 13, 1999, 10:43 AM
(C) COPYRIGHT HEWLETT-PACKARD COMPANY 1993

>>set sqldbe musicdbe
DBE does not exist, do you want to create one? [Y/N] : y
Creating DBE now ...



To purge a dbe correctly you will need to do the following is SQLUTIL.

SQLUTIL
MON, SEP 13, 1999, 10:54 AM
HP36216-02A.G3.02               DBE Utility/3000             ALLBASE/SQL
(C)COPYRIGHT HEWLETT-PACKARD CO. 1982,1983,1984,1985,1986,1987,1988,
1989,1990,1991,1992,1993,1994. ALL RIGHTS RESERVED.

>> purgeall
DBEnvironment Name: musicdbe
Purge DBEnvironment and Log Files (y/n)? y

DBEnvironment and Log Files purged.

>> exit

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