Problem

Allbase database was copied over to another account. Now the Allbase Database
is not accessible. However, I am able to access the database in the original
account and this is the same database.
i.e.
I can access the database in the original account but  cannot access the
database in the new account.


     Cause:
Allbase Database is a relational database and has a log file. Log files are
typically used to for recovery purposes and the system will have it configured
to a specific instance of the database.

When another instance of the database is created, you need to create a new
logfile.


     Solution:

After restoring the database to the account, activate the utility - ISQL. Then
run the script outlined below.

(Follow this example script and modify to your needs. Following script is
based on ALLDBE Database.)

Database : ALLEDBE

START   DBE 'ALLDBE' MULTI NEWLOG
        BUFFER = (600, 120),
        TRANSACTION = 100,
        RUN     BLOCK = 500
        LOG     DBEFILE DBELOG1
        WITH    PAGES = 30000,
        NAME    = 'DBELOG';


NOTE

        The figures and the underlined items can be modified to fit your
environment.
        You may typically run this same script, modifying only the underlined
items - definition of log file.
        If you copy the script into a file and try to run it from ISQL, use
the command 'START' to activate the script.
        Alternatively, you could type in the script online.


Common Error Messages :

3054    :     File System Error - Nonexistent DBEFile or log file.
                   - This means some of the database files are missing.
Validate that your restore is correct!

(For other error messages refer to the manuals.)


 If you have further questions, please let me know - Daniel
Rathinam@59592      Last Updated : 980813




Leonard Berkowitz wrote:

> In a job to attach several data bases to a DBE, I get the following error:
>
>       ATTACH
>        ALLBASE/SQL CONNECT command failed (ATCERR 32351).
>
>  Attempt to create a file in an account other than the DBCon's.   (DBERR
> 3104)
>
> This implies that some file in the DBE has a fully-qualified file
> reference. How can I find this?
>
> Thanks
>
> ========================
> Leonard S. Berkowitz
> mailto:[log in to unmask]
> phone: (617) 972-9400 ext. 3250
> fax:   (617) 923-5555