topic Re: Not able to copy/paste feature class to IBM DB2 Enterprise DB in ArcGIS Enterprise Questions

Not able to copy/paste feature class to IBM DB2 Enterprise DB

GeorgeHaskett — Wed, 30 Oct 2013 17:36:12 GMT

Hello,

We recently copied our test DB2 database to a new server and reconnected to the newer version. I can copy and paste tables without any issues, however when I try to either copy and paste a feature class to the database in question, I receive the following error:

Error exporting data.
Underlying DBMS error
DBMS table not found [[IBM][CLI Driver][DB2/NT64] SQL0204N
"SDE.GCCSV" is an undefined name. SQLSTATE=42704::42S02]

Likewise when I copy a table to the database in question, create an event layer w/n ArcMap and then try to export it as a feature class into the newly created database, I get the same error. Note that the Data Transfer window does not indicate any issues.

When I try the Feature Class to Feature Class tool, it runs for approx. 2 seconds and errors out. The Geoprocessing results indicate that there was an "Underlying DBMS Error" and give an error code of 210. The definition of the code states the following three potential issues:

Data locking, incorrect path, and limited access rights

I've checked and there are no schema locks on the data, the path is correct and our IT claims that the rights are set up properly.

Having said that, the enterprise GIS is new to them and we are still experimenting with it.

Does anyone have any pointers?

Thanks,

Re: Not able to copy/paste feature class to IBM DB2 Enterprise DB

VinceAngelo — Wed, 30 Oct 2013 18:27:09 GMT

This question really belongs over in Geodatabase & ArcSDE.

It's usually helpful to provide the hardware platform, version (and fixpack) of the database,
and the ArcGIS release (and service pack) you're using.

Did you change database name when you copied the data to the new server? The
ArcSDE metadata stores the original creation database, which could cause this sort
of problem.

What user owns this spatial data? (Best practice is to avoid SDE user ownership
of any spatial data -- Instead create one or more users to own tables and as many
more are necessary to manage access to the tables [though the permissions should
always be granted through roles].)

- V

Re: Not able to copy/paste feature class to IBM DB2 Enterprise DB

GeorgeHaskett — Wed, 30 Oct 2013 19:21:44 GMT

Thanks, the GeoDatabase & ArcSDE makes more sense.

As for the platform, etc. We are using IBM DB2 9.8 with ArcGIS for Server 10.1.

I did not preform the actual transfer of data. They stated that they wanted to mirror the original database on a new server prior to turning the original one off. The data was originally created under the SDE user account. I am told that I am signing on with a similar user account, however I cannot validate this myself.

Is it possible that the user account is not set up the same on the new server as it was on the older one? The GIS related aspects of this are new to our IT department.

Re: Not able to copy/paste feature class to IBM DB2 Enterprise DB

VinceAngelo — Wed, 30 Oct 2013 20:17:37 GMT

DB2 is a bit of an odd duck, because the Esri ST_GEOMETRY is the only native spatial blade,
and I haven't worked with it recently enough to know how it supports "similar" SDE accounts.

If the data transfer was done using a database copy process that didn't update the SDE table
metadata, then nothing is going to work right. If a simple export/import was used, then maybe
only the geodatabase metadata is courrupt (which is still enough, of course).

I think you need to know a lot more about what was done, but Tech Support is probably going
to be the best way to know which questions to ask, because the DB2 pool of experience out
here in the Forums is going to be *way* less than in Tech Support.

- V