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

I meant recompiling all the stored procedures.

Yes you'll have to re-create (recompile) all stored procedures. Make sure that the compiler path registry variable points to 64-bit libraries.