Hi Dennis
This is close except that we did not move anything.
He has a dbe in one account with a local database.
He wants to add another image database across account boundaries to the same dbe.
Can this be done or does it violate some internal rule?
Thanks
account xxxxx dbe mydbe with image db image.pub.xxxxx
add to dbe dbe mydbe image2.pub.another account
Ray
> ----------
> From: Heidner, Dennis L
> Sent: Thursday, June 15, 2000 5:33 PM
> To: Legault, Raymond D
> Cc: Ehrenberg, Kenneth W; Thomson, Robert G
> Subject: RE: WHAT'S NEXT?(DBERR 13552)
> Importance: High
>
> Does the following info apply? You may also need to alter the security on the dbe to allow users read it across the account boundaries.
>
> DocId: KBRC00002680 Updated: 6/9/00 3:55:49 PM
>
> PROBLEM
>
> Customer runs into various problems after moving an image/sql database to a
> new account. What are the various problems and how to avoid them?
>
> RESOLUTION
>
> When moving a SQL dbe to a new account it will depend on whether the dbe is
> attached to an image database. The following procedures are for moving an
> IMAGE/SQL environment using Tstore. This procedure is not supported. One reason
> is any customization you may have in your dbe will be lost.
>
> The following does include the common errors which can occur during this
> process. The databases used in the following are 'Music' an image database
> attached to a sql dbe 'MUSICDBE' (image/sql)
>
> DETACH the image database from the dbe using DBUTIL.
> dbutil.pub.sys
> detach music This will detach the image database from all DBEs it
> may be attached.
>
> Store all files Imagesql DBE and Imagedb
>
> Note: The imagesql dbe files will include the dbe file plus
> files with the same prefix as the dbe name with the following
> suffixes: fl, lg, cr.
> For example:
> Musicdbe created by image/sql also creates musicdfl, musicdlg,
> and musicdcr. The dcr file is the imagesql attach file.
>
>
> Logon to the New Account using the user name which will be used
> as the DBE creator.
>
> Restore the database files to the new account with local;create
> options.
>
> Errors seen with IMAGE/SQL dbe after the restore if the DETACH is
> NOT done before the store:
>
> ISQL
>
> isql=> connect to 'musicdbe';
> Attempt to create a file in an account other than the DBCon's.
> (DBERR 3104)
> isql=>
>
> DBUTIL
> HP30391C.07.10 TurboIMAGE/XL: DBUTIL (C) COPYRIGHT HEWLETT-PACKARD COMPANY 1987
>
> >>DETACH MUSIC
> Detach failed from MUSICDBE.DATABASE.MCRAE (ATCERR 32351)
> >>exit
>
> Imagesql
> >>SET SQL MUSICDBE
> >>SET TURBO MUSIC
> >>DETACH
> ALLBASE/SQL CONNECT command failed (ATCERR 32351).
> Attempt to create a file in an account other than the DBCon's.
> (DBERR 3104)
> >>exit
>
> How to get rid of the errors if detach was not done before the
> store:
>
> Using ISQL, do start dbe newlog before using the DBE.
> Once a newlog has been created, you will have access to the DBE.
>
> isql: sample command
> start dbe 'musicdbe' multi newlog log dbefile musicdbelog3
> with pages=250, name='musiclg3';
> isql=>
>
> isql=> select * from music.albums;
> IMAGE/SQL error 110; TurboIMAGE error -21; TurboIMAGE intrinsic 403, &
> Auxiliary error 0. (DBERR 13552)
> isql=>
>
> Why does this error occur? You are attempting to access the database in the orginal account.
>
> Imagesql
> >>set sqldbe musicdbe
> >>display bases
> DBEnvironment : MUSICDBE.PUB.MOVEDB
>
> BASE FILE OWNER BASE TYPE
> --------- ----- ---------
>
> MUSIC.DATABASE.MCRAE MUSIC TurboIMAGE
>
> Total Databases : 1
> >>
> >>set turbo music
> >>attach
> Mapped 1 source table/source field name(s) (ATCWARN 32062).
> ALLBASE/SQL CREATE TABLE command failed (ATCERR 32353).
> Table/View MUSIC.ALBUMS already exists. (DBERR 2207)
> >>
> This error occcurs because MUSIC.DATABASE.MCRAE has the same tables.
>
> If you cannot create a new store tape with a detach dbe, it would be
> best to detach and purge the old dbe, then recreate the dbe using
> imagesql.
>
> dbutil
> detach music This will detach all dbe references
> exit
>
> sqlutil
> purgeall This will purge all the SQL files
>
> imagesql
> set sqldbe musicdbe This will create a New dbe
> set turbo music
> exit
>
>
>
>
> If you did detach from the dbe before the store do the following;
>
> imagesql
> >>set sqldbe musicdbe
> >>display bases
> No database attached to the DBEnvironment (ATCWARN 32067).
> >>set turbo music
> >>attach
> ALLBASE/SQL CONNECT command failed (ATCERR 32351).
> Attempt to create a file in an account other than the DBCon's.
> (DBERR 3104)
> >>exit
>
> To get access to the dbe, you need to do a start dbe newlog before the
> attach.
>
> isql sample command
> start dbe 'musicdbe' multi newlog log dbefile musicdbelog3
> with pages=250, name='musiclg3';
> isql=> exit
>
> After this command is issued, use imagesql to attach the dbe to
> the image database.
>
> imagesql
> >>set sqldbe musicdbe
> >>set turbo music
> >>attach
> Mapped 1 source table/source field name(s) (ATCWARN 32062).
> >>display bases
>
> DBEnvironment : MUSICDBE.PUB.MOVEDB
>
> BASE FILE OWNER BASE TYPE
> --------- ----- ---------
>
> MUSIC.PUB.MOVEDB MUSIC TurboIMAGE
>
> Total Databases : 1
>
> >>exit
>
> Please note you will have to add you custom options to the DBE at this
> point. What you had no longer exists for this DBE in this NEW ACCOUNT.>
> Dennis Heidner
>
> 865-2334 7M-EM
> 957-5049 FAX>
>
> ----------
> From: Legault, Raymond D
> Sent: Thursday, June 15, 2000 7:21 AM
> To: Heidner, Dennis L
> Cc: Ehrenberg, Kenneth W; Thomson, Robert G; Legault, Raymond D
> Subject: RE: WHAT'S NEXT?(DBERR 13552)
> Importance: High
>
> Hi Dennis
>
> SQLVER found 1 problem. However, I don't think this is the problem.
>
> The database is released. It works from the ASR account but not the TIMS account.
>
> I ran GOD in the TIMS account just for grins but no difference.
>
> Can you call HP and put in a ticket for us.
>
> Thanks
>
> Ray
>
>
> ALLBASE/SQL:
> -----------
>
> dbmon.pub.sys (created SAT, MAY 20, 2000):
> @(#)HPDBCORE A.G3.04 02/23/99 ALLBASE/SQL
>
> hpsqludc.pub.sys (created SAT, MAY 20, 2000):
>
> isql.pub.sys (created SAT, MAY 20, 2000):
> HP36216-02A.G3.04 Interactive SQL/3000 ALLBASE/SQL
>
> psqlc.pub.sys (created SAT, MAY 20, 2000):
> HP36216-02A.G3.04 C Preprocessor/3000 ALLBASE/SQL
>
> psqlcob.pub.sys (created SAT, MAY 20, 2000):
> HP36216-02A.G3.04 COBOL Preprocessor/3000 ALLBASE/SQL
>
> psqlfor.pub.sys (created SAT, MAY 20, 2000):
> HP36216-02A.G3.04 FORTRAN Preprocessor/3000 ALLBASE/SQL
>
> psqlpas.pub.sys (created SAT, MAY 20, 2000):
> HP36216-02A.G3.04 PASCAL Preprocessor/3000 ALLBASE/SQL
>
> sqlct000.pub.sys (created SAT, MAY 20, 2000):
>
> sqlgen.pub.sys (created SAT, MAY 20, 2000):
> HP36216-02A.G3.04 SQL Command Generator/3000 ALLBASE/SQL
>
> sqlmonp.pub.sys (created SAT, MAY 20, 2000):
> HP36216-02A.G3.04 SQLMonitor/3000 ALLBASE/SQL
>
> sqlmig.pub.sys (created SAT, MAY 20, 2000):
> HP36216-02A.G3.04 SQLMigrate/3000 ALLBASE/SQL
>
> sqlutil.pub.sys (created SAT, MAY 20, 2000):
> HP36216-02A.G3.04 DBE Utility/3000 ALLBASE/SQL
>
> sqlwl000.pub.sys (created SAT, MAY 20, 2000):
>
> ALLBASE/NET:
> -----------
>
> anutil.pub.sys (created SAT, MAY 20, 2000):
> @(#)HP36216-02A.G3.04 ALLBASE/NET 900 ALLBASE/SQL
>
> hpdalstn.pub.sys (created SAT, MAY 20, 2000):
> @(#)HP36216-02A.G3.04 ALLBASE/NET 900 ALLBASE/SQL
>
> hpdadvr.pub.sys (created SAT, MAY 20, 2000):
> HP36216-02A.G3.04 ALLBASE/NET 900 ALLBASE/SQL
>
> hpipdvr.pub.sys (created SAT, MAY 20, 2000):
> @(#)HP36216-02A.G3.04 ALLBASE/PC API 900 ALLBASE/SQL
>
> hpipns.pub.sys (created SAT, MAY 20, 2000):
> @(#)HP36216-03A.G1.12 ALLBASE/PC API 900 ALLBASE/SQL
> ***** WARNING: Version incompatibility found.
>
> netutil.pub.sys (created SAT, MAY 20, 2000):
> HP36216-02A.G3.04 ALLBASE/NET 900 ALLBASE/SQL
>
> hpipfile.net.sys (created SAT, MAY 20, 2000):
>
> hpipmast.net.sys (created SAT, MAY 20, 2000):
>
> hpipserv.net.sys (created SAT, MAY 20, 2000):
>
> Common ALLBASE/SQL Libraries:
> ----------------------------
>
> xl.pub.sys (created SAT, MAY 20, 2000):
> @(#)HPDBCORE A.G3.04 02/23/99 ALLBASE/SQL
> HP36216-02A.G3.02 Replicate/3000 ALLBASE/SQL
> HP36216-02A.G3.04 Query Processor/3000 ALLBASE/SQL
> HP36216-02A.G3.04 SQL Parser/Linearizer/3000 ALLBASE/SQL
> HP36216-02A.G3.04 ALLBASE/NET 900 ALLBASE/SQL
> HP36216-02A.G3.04 SQLX/3000 ALLBASE/SQL
> HP36216-02A.G3.04 SQLX/3000 ALLBASE/SQL
> HP36216-02A.G3.04 SQLX/3000 ALLBASE/SQL
> HP36216-02A.G3.04 PASCAL Preprocessor/3000 ALLBASE/SQL
> HP36216-02A.G3.04 C Preprocessor/3000 ALLBASE/SQL
> HP36216-02A.G3.04 FORTRAN Preprocessor/3000 ALLBASE/SQL>
> > HP36216-0> 2A.G3.04 COBOL Preprocessor/3000 ALLBASE/SQL
>
> ------------------------------------------------------------------------
>
> SUMMARY:
> -------
>
> Current ALLBASE/SQL version installed: A.G3.04
>
> ALLBASE/SQL has 0 file(s) missing.
>
> ALLBASE/NET has 0 file(s) missing.
>
> Number of version incompatibilities found: 1
> 131ASR,DATABASE:
>
>
> ----------
> From: Legault, Raymond D
> Sent: Thursday, June 15, 2000 6:13 AM
> To: Heidner, Dennis L
> Cc: Legault, Raymond D
> Subject: FW: WHAT'S NEXT?(DBERR 13552)
>
> Hi Dennis
>
> I will take a look but it has been a while since I have looked at this stuff.
>
> Ray
>
>
> Base= asbase.database.asr
>
> Attached to these HP SQL DBEnvironments:
> GTIMPROD.DATABASE.TIMS
> TESTDBE.DATABASE.ASR
>
> ----------
> From: Ehrenberg, Kenneth W
> Sent: Thursday, June 15, 2000 5:43 AM
> To: Legault, Raymond D
> Cc: Thomson, Robert G
> Subject: WHAT'S NEXT?
>
> THIS IS FROM ASR ACCOUNT...
>
> SELECT * FROM ASBASE.MATERIAL_BIN;
> --------------+-----------+-----------+--------------------------+---------
> MB_ACTIVE_DATE|MB_BOX_QTY |MB_BOX_SIZE|MB_BIN_LOCATION |MB_INVEN_
> --------------+-----------+-----------+--------------------------+---------
> 19810515 | 0| 0|C2 |19910812
> 19810515 | 0| 0|C2 |19900326
> 19810515 | 0| 0|C2 |19920130
> 19810515 | 0| 0|C2 |19930625
> 19810515 | 0| 0|C2 |19900102
> 19810515 | 500| 0|C2 |19890824
> 19810515 | 0| 0|C2 |19930524
> 19810515 | 0| 0|C2 |19980730
> 19810515 | 0| 0|C2 |19900116
> 19810515 | 0| 0|C2 |19920901
> 19810515 | 0| 0|C2 |19930616
> 19810515 | 0| 0|C2 |19970109
> 19810515 | 0| 0|C2 |19980415
> 19810515 | 0| 0|C2 |19970109
> 19810515 | 0| 0|C2 |19860829
> 19810515 | 0| 0|C2 |19980429
> ---------------------------------------------------------------------------
> First 16 rows have been selected.
> U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd] > E
>
>
>
>
>
>
> AND THIS IS WHEN I AM IN TIMS ACCOUNT
> I checked to make sure that I can see the dataset
>
> LLOAD_DEBIT_REQS |ASBASE |SYSTEM | 0|
> MATERIAL_BIN |ASBASE |SYSTEM | 0| <<<<<<<<<
> MATERIAL_MASTER |ASBASE |SYSTEM | 0|
> NA_DEBIT_REQS |ASBASE |SYSTEM | 0|
> PHYS_INVENTORY |ASBASE |SYSTEM | 0|
> RESTOCK |ASBASE |SYSTEM | 0|
> UNIT_MASTER |ASBASE |SYSTEM | 0|
> ---------------------------------------------------------------------------
> First 16 rows have been selected.
> U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd] > E
>
>
> isql=> SELECT * FROM ASBASE.MATERIAL_BIN;
> IMAGE/SQL error 110; TurboIMAGE error -21; TurboIMAGE intrinsic 403, &
> Auxiliary error 0. (DBERR 13552)
> isql=>
>
>
> Not quite sure what to do now. I've tried the release, etc. no work. Any ideas?>
>
>
> > Ken Ehrenberg, 7-B293
> A&M-Operations Information Systems
> The Boeing Co-Seattle
> 206 662-2224 m/s 42-70
>
>
>
>
>
|
