Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2011
    Posts
    2

    Unanswered: Restoring v8.2 db to v9.7

    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

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    To disable datalinks, try this link:
    Migrating DB2 Data Links Manager environments
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Jun 2011
    Posts
    2

    Restoring v8.2 db to v9.7

    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

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by fredg View Post
    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.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •