We are upgrading from db2 luw 8.2 to 9.7 in one of our environments. The new version (9.7) is on a new server and we are taking backups from 8.2 and restoring to 9.7. This has worked successfully except for one database. This database had 3 tables that were not being used but had a column that had a datalink data type. Not sure how that happened, but it did. We know that datalink is not supported in 9.7. We never enable the datalink manager on the 8.2 server either. We deleted the three tables from database in question, did a backup and then tried to restore to 9.7. We are receiving the following errors:


2011-05-31-11.12.27.407357-300 E3566617E821 LEVEL: Severe
PID : 19981 TID : 140701484443392PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
EDUID : 613 EDUNAME: db2bm.338.0 (PWXDADW)
FUNCTION: DB2 UDB, database utilities, sqluWriteDLCfg, probe:1311
MESSAGE : SQL20158N DB2 Data Links Manager is not supported in this DB2 copy
version.
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -20158 sqlerrml: 0
sqlerrmc:
sqlerrp : sqluWrit
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:

2011-05-31-11.12.27.407625-300 E3567439E434 LEVEL: Error
PID : 19981 TID : 140701484443392PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
EDUID : 613 EDUNAME: db2bm.338.0 (PWXDADW)
FUNCTION: DB2 UDB, database utilities, sqluWriteDLCfg, probe:1312
DATA #1 : String, 103 bytes
Restore detected a Datalinks enabled database.
Cannot restore such a database into the current release.


Any clues as to what else could be in the database that could be indicating the datalinks was enabled?

Thanks

To disable datalinks, try this link:
Migrating DB2 Data Links Manager environments

I thought about that, but when I list the datalinks managers there are none. Receive the following:
There are no DB2 Data Link Managers configured for this database

Since that obviously did not work when you tried to upgrade to 9.7, I would follow instructions in the manual, for which I provided a link explaining them. If the instructions don't work, then call IBM support.