We are tring to restore a sde on db2 from a backup, We use the flowing command to do the restore:
db2--> restore db SDEDB from /db2/sde5 taken at 20150919163011……
The restore was successful, we check the table number, index number, they are the same as the old database. Here are the software we are using:
Database: DB2 9.7.2 Operating System: AIX 6.1 SDE: 10.0 ArcGIS Desktop: 10.0 SP5
When I try to make a direct connection to DB2 from ArcCatlog, it gave me an error message states:
“This release of the GeoDatagbase is either invalid or out of date. DBMS table not found [SDEDB.SDE.GDB_Release]”;
It is quite strange that “SDE.GDB_Release” is not exist in the source gdb either, but my ArcCatlog works fine with the source DB2.
Then I try to check out the privileges of the sde user, so I grant the flowing privileges to the SDE, although it may already have these privileges:
CONNECT to database; CREATETAB in database; CREATEIN, ALTERIN, and DROPIN for the necessary schema; EXECUTE on MON_GET_CONNECTION; CONTROL on database objects, SELECT on SYSIBM.SYSDUMMY1 SELECT on SYSCAT.ROLEAUTH, SYSCAT.DBAUTH, and SYSCAT.TABAUTH DBADM authority SYSCTRL or SYSADM authority EXECUTE on MON_GET_CONNECTION
Unfortunately, the error remains, I still can NOT make a direct connection to the new DB2.
I already search the google, most of the documents point out it is compatibility between the geodatabase and the ArcGIS Desktop, but we have a 10.0 gdb and 10.0 sp5 desktop.
Any help is appreciate, we are quite desperate, thank you very much.