Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Posts
    190

    Unanswered: Restore 32bit backup to 64bit OS

    How can I fix the problem below after restoring a 32bit database on a 64bit ?
    Will rebinding all the stored procedures fix it.

    Thanks

    db2level
    DB21085I Instance "db2inst1" uses "64" bits and DB2 code release "SQL08022"
    with level identifier "03030106".
    Informational tokens are "DB2 v8.1.0.89", "special_15295", "U800790_15295", and
    FixPak "9".
    Product is installed at "/opt/IBM/db2/V8.1".




    2006-06-16-09.43.44.392481-240 E164147943A647 LEVEL: Error (OS)
    PID : 26166 TID : 1 PROC : db2fmp (3946) 0
    INSTANCE: db2inst1 NODE : 000
    FUNCTION: DB2 UDB, oper system services, sqloLoadModule, probe:190
    CALLED : OS, -, dlopen
    OSERR : EBADF (9) "Bad file number"
    DATA #1 : Library name or path, 72 bytes
    /app/home/db2inst1/sqllib/function/routine/sqlproc/DBLIQ003/LIQ/P4704480
    DATA #2 : shared library load flags, PD_TYPE_LOAD_FLAGS, 4 bytes
    0
    DATA #3 : String, 125 bytes
    ld.so.1: db2fmp: fatal: /app/home/db2inst1/sqllib/function/routine/sqlproc/DBLIQ003/LIQ/P4704480: wrong ELF class: ELFCLASS32

  2. #2
    Join Date
    Apr 2004
    Posts
    190
    I meant recompiling all the stored procedures.

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Yes you'll have to re-create (recompile) all stored procedures. Make sure that the compiler path registry variable points to 64-bit libraries.

Posting Permissions

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